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

Promissory note - evidence of a debt, Promissory Note - Evidence of a DEBT ...

Promissory Note - Evidence of a DEBT with specific amount due and interest rate. Note may specify a maturity date or it may be payable on demand. Promissory note may or may not acc

Successive interest computations, Show that if an investment of P dollars d...

Show that if an investment of P dollars declines by 4% during a year , the balance at the end of the year is P(1-.04) that is P(.96) ?

Effect of releasing accounting information, The objective of this project i...

The objective of this project is to demonstrate the effect of releasing accounting information concerning profits on the valuation (i.e. share price) of an Australian;listed compan

Fraudulent preferences-fraudulent conveyances, Fraudulent preferences ...

Fraudulent preferences The trustee can set aside any transaction effected within the six months preceding the presentation of the petition in circumstances such as to make it

What do you mean by re - organization, Q. What do you mean by Re - organiza...

Q. What do you mean by Re - organization? Reorganization - This is a change in businesses capital arrangements. If for a CORPORATION there are 7 statutory options for reorganiz

Bank reconciliation statement, in bank reconciliation statement what are th...

in bank reconciliation statement what are the statement to be reconcile

AS-10.., WHAT IS dEPRECIATION?

WHAT IS dEPRECIATION?

MAKING A PITCH, SAMPLES PITCH FOR AN ACCOUNTING ASSIGNMENTS

SAMPLES PITCH FOR AN ACCOUNTING ASSIGNMENTS

Write up the necessary ledger accounts, Question: Agatha Co. is a tradi...

Question: Agatha Co. is a trading company making up its accounts regularly to 31 December each year. At 01 January 2005 the following balances existed in the records of Agat

Net present value evaluation of proposed investment, Q. Net present value e...

Q. Net present value evaluation of proposed investment? WORKINGS Fixed costs = 4·50 × 100000 = $450000 per year Annual writing down allowance = 3000000/10 = $300000

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