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

calculate the average issue price, Star Corporation issued both common and...

Star Corporation issued both common and preferred stock during 19X6. The stockholders' equity sections of the company's balance sheets at the end of 19X6 and 19X5 follow.

Covenants, what is a maximum leverage ratio covenant designed to control

what is a maximum leverage ratio covenant designed to control

Holding company with a direct shareholding in sub-subsidiary, Holding compa...

Holding company with a direct shareholding in sub-subsidiary company Under this type of structure, both the holding and subsidiary company have some shareholding in the sub-subsi

Prepare the necessary journal entries in 2013, Berg Company adopted a stock...

Berg Company adopted a stock-option plan on November 30, 2013, that provided that 73,200 shares of $5 par value stock be designated as available for the granting of options to offi

What factors in preview company''s control environment, WILL SOMEONE PLEASE...

WILL SOMEONE PLEASE ASSIST ME WITH THIS ASSISGNMENT Preview Company, a diversified manufacturer, has five divisions that operate throughout the United States and Mexico. Preview ha

Journal entry, XYZ Corporation recieves $100,000 from investors for issuing...

XYZ Corporation recieves $100,000 from investors for issuing them shares of its stock. XYZ's journal entry to record this transaction would include a a debit to investment b credit

Leverage, Evaluate the importance of leverage in financial management of a ...

Evaluate the importance of leverage in financial management of a small scale company

Expense recognition, Purchases office supplies on account costing $12,600 d...

Purchases office supplies on account costing $12,600 during July. It pays $5,500 for these purchases during July and the remainder during August. Office supplies on hand on July 1

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