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
IAS 1 contents of financial statements IAS 1 prescribes the contents of published financial statements. The major reports that are included as part of the published financial sta

How to determine the depreciation To determine depreciation in straight-line method, take cost of the asset, less the trade-in value, and divide by the estimated years of usefu

Grants are not necessarily recognized as revenue when they are awarded. Columbus City was awarded a state reimbursement grant of $150,000 to assist its adult literacy program. The

Q. Bento, Inc. had 500,000 shares of common stock outstanding before a stock split occurred, and 1,500,000 shares outstanding after the stock split. The stock split was a. 2-for-5.

Determine about the accounting information Numerous user groups have an interest in accounting information relating to a business. Majority of these are outside the business ho

The following costs were incurred in 2010 in the design and construction of a new office building over a nine-month period during 2010: Requirement Calculate the amount

what is use of accounting ratios?

Five years ago Ramon Millan quit his job as an associate at a large law firm and opened a burger joint in Malibu. His innovative use of aged blue cheeses and specialty sauces resul

The December 31, 2005, balance sheet of Far Imports includes the following items: The bonds were issued on December 31, 2004, at 97, with Interest payable on June 30 and December 3

Prepare an Excel spreadsheet containing the following: - Construct the next five-year pro-forma statements (income statement and balance sheet). - Estimate annual F