Financial accounting , Financial Accounting

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.

Posted Date: 3/8/2013 6:00:53 AM | Location : United States







Related Discussions:- Financial accounting , Assignment Help, Ask Question on Financial accounting , Get Answer, Expert's Help, Financial accounting Discussions

Write discussion on Financial accounting
Your posts are moderated
Related Questions
Do you anyone on staff with the above experience? Notes cannot be copied from any real company''s financial report.

Hydroponics is considering adding another greenhouse that would cost $95,000 and generate $20,000 in annual net cash flows over its 8 year expected life. What is this project's int

Extract the term structure of interest rates out to 3 years given the following bond data: Maturity (yrs)    Coupon rate (%)   Yield to maturity (%) 0. 5

Question 1 Explain the five accounting concepts with an example Separate entity concept Going concern concept Money measurement concept Cost concept Dual aspect

Question: (a) Describe how cost concepts and behavior can be important to Management. (b) What do you meant by "flexing" the Budget? Describe the importance of flexible bud

scope of financial accounting

In the current year, Madison Corporation had $50,000 of taxable income at a tax rate of 25%. During the year, Madison began offering warranties on its products and has a warranty l


Calculate the Return on Sales and Asset Turnover 1. Complete a trend analysis for the items below for the last three years using the earliest year as the base year. Cash