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

Holding company with a direct shareholding in sub-subsidiary, Holding compa...

Holding company with a direct shareholding in sub-subsidiary company Under this type of structure, both the holding and subsidiary company have some shareholding in the sub-subsi

Determine the simple rate of return on the investment, Sheridon Corporation...

Sheridon Corporation is investigating automating a process by purchasing a new machine for $515,000 that would have a 10 year useful life and no salvage value. By automating the pr

Budget, the following information relates to Thomas limited who decide to c...

the following information relates to Thomas limited who decide to commence business on 01 January 2016 with R375000 cash: what is his budget for February, march, April?

Absorbed cost, These are the indirect costs that are related with manufactu...

These are the indirect costs that are related with manufacturing. Absorbed costs involve expenses like insurance, or property taxes for the building in which the production process

Bell mountain vineyards is considering updating, Bell Mountain Vineyards is...

Bell Mountain Vineyards is considering updating its current manual accounting system with a high-end electronic system. While the new accounting system would save the company mon

Compare the alternatives on a total-annual-cost , The Rohr Company's old eq...

The Rohr Company's old equipment for making subassemblies is worn out. The company is considering two alternatives: a) Completely replacing the old equipment with new equipment

Cost estimation, 1a. Explain why it is the case that the value of intermedi...

1a. Explain why it is the case that the value of intermediate goods produced and sold during the year is not included directly as part of GDP, but the value of intermediate goods p

Describe the effects of each transaction on assets, KAM Computer Timeshare ...

KAM Computer Timeshare Company entered into the following transactions durnig May 2014 Decribe the effects of each transaction on assets, liabilities, and owner's equity. 1. Purcha

Flexibility in debt finance, Q. Flexibility in Debt finance? Debt finan...

Q. Flexibility in Debt finance? Debt finance is more elastic than equity in that various amounts can be borrowed at a fixed or floating interest rate and for a range of maturit

Explain briefly two methods of calculating depreciation, QUESTION 1: Th...

QUESTION 1: The Alpha Company Ltd was registered with Nominal Capital of 60,000 Equity shares of Rs.10 each. The following were the ledger balances on 31st March 2011.

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