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

Explain the term- recording business transactions, Recording Business Trans...

Recording Business Transactions ACCOUNT. An account is an individual record or form to record and précis information for each liability, asset, or owner's equity transactio

Portfolio''s new beta., Assume you hold a diversified portfolio having of a...

Assume you hold a diversified portfolio having of a $7,500 investment in every of 20 different common stocks. The portfolio's beta is 2.15. Now, assume you sell one of the stocks w

ACCRUED INTEREST, IF I HAVE A LOAN AND ACCRUED INTEREST .THEN ACCRUED INTER...

IF I HAVE A LOAN AND ACCRUED INTEREST .THEN ACCRUED INTEREST GOES ON WHICH SIDE- DEBIT OR CREDIT ?

Explain the term- not-for-profit organisations, Explain the term- Not-for-p...

Explain the term- Not-for-profit organisations There are many organisations that don't exist mainly for the pursuit of profit. Instance include: ?charities ?clubs and ass

General limitations of net present value, General limitations of Net Presen...

General limitations of Net Present Value when applied to investment appraisal NPV is a generally used technique employed in investment appraisal but is subject to a number of r

Determine the npv of future cash flows, While many people know that Sonora,...

While many people know that Sonora, Mexico is a beautiful vacation spot, it is also a large furniture manufacturing location in North America. Guillermo Navallez made furniture for

Characteristics of accounting information?, According to the FASB, the usef...

According to the FASB, the usefulness of accounting is judged by which of the following two qualitative characteristics of accounting information? Comparability and neutrality Unde

Make journal entries required to dispose off, make journal entries require...

make journal entries required to dispose off over or under applied manufacturing overhead assuming it is allocated among work in process, finished goods and cost of goods sold ba

Prepare a year trading cash budget, Prepare a year trading cash budget: ...

Prepare a year trading cash budget: Gary Hart needs to calculate how much working capital he will need in his first year as a restaurateur. An accountant friend recommends he

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