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

Prepare statement of income and comprehensive income, The following income ...

The following income statement items appeared on the adjusted trial balance of Schembri Manufacturing Corporation for the year ended December 31, 2013 ($ in 000s): sales revenue, $

Consolidating Accounting, I have an assignment in consolidation accounting ...

I have an assignment in consolidation accounting and would like to know if you can assist me in doing the assignment for me. I am doing BA in Accounting . Please let me know. Re

Determine the amount and character of the recognized gain, On May 2, 1986, ...

On May 2, 1986, Hannah acquired residential real estate for $450,000. Of the cost, $100,000 was allocated to the land and $350,000 to the building. On January 20, 2013, the buildin

Bond''s yield to maturity, A 15-year, 14% semiannual coupon bond with a par...

A 15-year, 14% semiannual coupon bond with a par value of $1,000 may be known as in 4 years at a call price of $1,075. The bond sells for $1,050. (Suppose that the bond has just be

Assets, all types of assets

all types of assets

What do you mean by depreciation, Q. What do you mean by depreciation? What...

Q. What do you mean by depreciation? What are the causes for depreciation? Explain the two methods of depreciation. Depreciation means a fall in the quality, quantity or value o

What amount of loss, On January 1, 2011, Doty Co. redeemed its 15-year bond...

On January 1, 2011, Doty Co. redeemed its 15-year bonds of $2,500,000 par value for 102. They were originally issued on January 1, 1999 at 98 with a maturity date of January 1, 201

Vegetable gowing, disscuss the applicability of a operating cycle in vegeta...

disscuss the applicability of a operating cycle in vegetable growing bussiness in uganda

The time value of money , Calculate the present value and determine the npv...

Calculate the present value and determine the npv, Financial Management. Assume today is 3 December 2009. Helen is 30 years old and has a Bachelor of Business. She is currently em

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