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

Different powers of investment-trust laws and accounts , Powers of investme...

Powers of investment 1. Shares and debentures:  A trustee may: Invest in bearer securities if these would otherwise be authorised;    Acquiesce in an amalgamation

State the term reliability- accounting information, State the term Reliabil...

State the term Reliability- Accounting Information Accounting must be free from significant error or bias. It must be capable of being relied upon by managers to represent

Case law about investment, As an investor, you are considering buying stock...

As an investor, you are considering buying stock in a relatively new company. Medical Horizons, Inc., has been in existence for 10 years and is now about to go public. The first st

Modern techniques economic order quantity, The economic demand quantity can...

The economic demand quantity can also be found out with the assist of a graph. In this technique ordering cost, carrying cost and total inventory costs as per various lot sizes are

Estimate the cost, Olivia has received a $15 gift certificate that is redee...

Olivia has received a $15 gift certificate that is redeemable only for roasted peanuts. Bags of roasted peanuts come in two sizes, regular and jumbo. A regular bag contains 30 pean

Prepare a year trading cash budget, Prepare a year trading cash budget: ...

Prepare a year trading cash budget: Gary Hart needs to calculate how much working capital he will need in his first year as a restaurateur. An accountant friend recommends he

Calculate the net present value of the investment, Calculate the Net Presen...

Calculate the Net Present Value of the Investment XYZ Ltd is a manufacturer of household goods located in Ang Mo Ko. They presently make and wholesale fruit juicers, blenders

Show the expatriation tax, Q. Show the Expatriation Tax? Expatriation T...

Q. Show the Expatriation Tax? Expatriation Tax - Individuals who loose or terminate their residency within 10 year period immediately preceding the close of a tax year, if term

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