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

Financial strategy IRR, what managers should know about internal rate of re...

what managers should know about internal rate of return (IRR) and why?

Economic order quantity formula, For getting the EOQ formula we shall use t...

For getting the EOQ formula we shall use the subsequent symbols: U = annual usage/demand Q = quantity ordered F = cost per order C = per cent carrying cost P  = pric

Change in profit sharing ratio, Change in profit sharing ratio When there...

Change in profit sharing ratio When there is a change in profit sharing ratio, it means that some of the partners will get higher profits based on the new ratios in the future wh

Derive the optimal value of loss function, Derive the Optimal Value of Loss...

Derive the Optimal Value of Loss Function A speculative attack and the consequent currency crisis may not be due to excessive money-growth or other misaligned fundamentals, bu

What should be the basic earnings per share, Information concerning the cap...

Information concerning the capital structure of Piper Corporation is as follows: December 31, 2011 2010 Common stock 150,000 shares 150,000 shares Convertible preferred stock 15,00

Calculating future values, Show all support work for your calculations. ...

Show all support work for your calculations. 1.  Simple Interest versus Compound Interest [LO1]  First City Bank pays 7 percent simple interest on its savings account balances,

Student, Open "Hoyle CPA: Earnings Per Share." Under "Free Questions" selec...

Open "Hoyle CPA: Earnings Per Share." Under "Free Questions" select "Financial Accounting & Reporting."

Prepare the journal entries to record non-monetary exchange, Moore Corporat...

Moore Corporation follows a policy of a 10% depreciation charge per year on all machinery and a 5% depreciation charge per year on buildings (the corporation uses the nearest full

their yield to maturity, Thatcher Corporation's bonds will mature in 12 ye...

Thatcher Corporation's bonds will mature in 12 years. The bonds have a face value of $1,000 and an 11.5% coupon rate, paid semi-yearly. The price of the bonds is $1,050. The bonds

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