Financial accounting , Financial Accounting

Assignment Help:

a. Create a worksheet in your excel file and name it "Part A Q2". In column A to E set up general journal and input the necessary journal entries to record the transactions and events listed above. Explanations (narrations) for your journal entries are required. Copy it to the word document.

Clearly show all supporting calculations in the columns to the right of the journal entries.  Leave column G empty and input the heading "Calculations area:" in cell H2.  Perform all calculations in this area of the worksheet.  Show the calculations in narrative form in the cell next to the cell containing the formula (e.g. "(=$20,000*0.08=$1,600)").  Calculations should be rounded to the nearest cent (i.e. to two decimal places). Copy all the calculations to the word document.

b.  Based on the transaction on 5th January 2010, do you think that the bad debt estimation was correct in 2009?  Record your answer in word file.

c.  In the rows below your journal, create a running balance ledger account. Prepare the account for Allowance for Bad Debts. To arrive at closing you must use the formula and these formulae will be checked. Copy it to the word document.

d.  What closing balance of Allowance for Bad Debts you have arrived at? Is this balance equal to 2% of net credit sales? Why or why not? Give explanations. Record your answer in word document.

e.  In the rows below the running balance ledger account, provide an extract from the balance sheet for the end of December 2010, showing how the assets from the transactions above would be reported under the Current Assets heading in the balance sheet. Copy it to the word document.


Related Discussions:- Financial accounting

A realized gross profit, On December 15, 2011 Risby Sales Co. sold a track ...

On December 15, 2011 Risby Sales Co. sold a track of land that cost $3,600,000 for $4,500,000. Rigsby appropriately uses the installment sale method of accounting for this transact

What net carrying amount, On June 30, 2011, Omara Co. had outstanding 8%, $...

On June 30, 2011, Omara Co. had outstanding 8%, $3,000,000 face amount, 15-year bonds maturing on June 30, 2021. Interest is payable on June 30 and December 31. The unamortized bal

Assignment, Can you do the attacched quections by Monday?

Can you do the attacched quections by Monday?

Rate of return on the market, The risk-free rate of return, rRF , is 10%; t...

The risk-free rate of return, rRF , is 10%; the needed rate of return on the market, rM, 16%; and Schuler Company's stock has a beta coefficient of 1.6. a.       If the dividend

Asking price, The price stages are that at which sellers recruit securities...

The price stages are that at which sellers recruit securities to borrowers.

Fin 501, Look closely at the stock market in Fiji. Do a trend analysis of t...

Look closely at the stock market in Fiji. Do a trend analysis of the stock market based on the following: ? The function of the stock market ? The trend analysis of the number of

Pooling and duplication of deductions, Individual taxpayers who don't itemi...

Individual taxpayers who don't itemize their deductions are entitled to a standard deduction amount by which to decrease ADJUSTED GROSS INCOME in arriving at taxable income. Amount

Consolidated balance sheet-group accounts, CONSOLIDATED BALANCE SHEET T...

CONSOLIDATED BALANCE SHEET The consolidated balance sheet involves adding assets and liabilities of the subsidiary to those of the holding company while excluding inter-company

Please explain why, The following data has been taken from the management a...

The following data has been taken from the management accounting reports from Spinnaker Sales. Div A -Income from operations $1,800,000 Total service department charges $1,600,000.

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd