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

Statement of cash flow, under gaap, are proceeds from capital lease obligat...

under gaap, are proceeds from capital lease obligation reported in the statement of cash flow and why

Heath foods''s bonds , Heath Foods's bonds have 6 years left over to maturi...

Heath Foods's bonds have 6 years left over to maturity. The bonds have a face value of $1,000 and a yield to maturity of 8%. They pay interest yearly and have a 10% coupon rate. Wh

The notes to the accounts-financial statement, THE NOTES TO THE ACCOUNTS ...

THE NOTES TO THE ACCOUNTS The notes to the accounts provide additional information on the a/c policies that the company has adopted the make-up of some of the items appearing on

Key person insurance, For purposes of rules which apply to top heavy plans,...

For purposes of rules which apply to top heavy plans, a key employee: 1. An officer of employer earning more than $130,000; 2. An individual who owns more than 5 percent of e

Return on Equity, Maghrabi Enclosure follows a moderate current asset inves...

Maghrabi Enclosure follows a moderate current asset investment policy, but it is considering whether to shift to a different strategy. The firm''s annual sales are $500,000; its f

Help, #The ABC Organization Unadjusted Trial Balance As of 31 December 2012...

#The ABC Organization Unadjusted Trial Balance As of 31 December 2012 Account Codes Dr Cr Cash 10,789 Furniture and fixtures 60,000 Supplies inventory 8,531 Pledged contributions r

Analysis of Investment, How to proceed on the analysis of investment puttin...

How to proceed on the analysis of investment putting in mind that there are many criteria in this respect:Net income per year, Cash flows, Device life of 7 years, 10% return on inv

Powers of trustee-rights and duties of trustee, Powers of trustee (A) ...

Powers of trustee (A) Of his own initiative, he may: 1.    Sell and transfer any part of the bankrupt's property; 2.    Gives receipts for money received; 3.    Take all n

How do u find the retained earnings?, How do i find the retained earnings? ...

How do i find the retained earnings? What is the formula to find retained earnings? What is the retained earnings? Accounts payable $ 5,000 Notes payable $ 7,000 Accounts receivabl

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