Prepare the account for allowance for bad debts, Accounting Basics

The 31st December 2009 trial balance of Anika Co. reported the following information.

Dr. Cr. Allowance for Bad Debts........................... $2,300

During the year 2010 the following selected transactions are available:

5 January 2010 Anika wrote off the balance due from Michael as a bad debt amounted to $900. 19 April Peter was unable to pay his account balance of $1,500. He accepted $1,500 10% bill to settle his obligation with Anika on 30th July.

30 June Anika collected the bill in full amount on due that with the interest.

31 December Anika uses allowance method to estimate bad debt expense using balance sheet approach. An aging schedule indicates that $1,200 of accounts receivable will be uncollectible. 31 December Anika had an Accounts Receivable Balance of $41,000

Required:

a. Create a worksheet in your excel file and name it "Part A Q3". 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 H1. 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 document.

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 balance estimated as per ageing schedule (i.e. $ 1,500)? 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/13/2013 5:23:44 AM | Location : United States







Related Discussions:- Prepare the account for allowance for bad debts, Assignment Help, Ask Question on Prepare the account for allowance for bad debts, Get Answer, Expert's Help, Prepare the account for allowance for bad debts Discussions

Write discussion on Prepare the account for allowance for bad debts
Your posts are moderated
Related Questions
XYZ plc provides engineering and consultancy services to the oil and gas industry.  Over the past few years, they have incurred expenditure of £1m researching and developing a new

The list of accounts below and the unadjusted balances of these accounts were taken from the ledger of the Manville Corporation at the end of their accounting period, March 31,

Q. Illsutarte the Summary of transactions? Summary of transactions is a teaching tool utilized to show the effects of transactions on the accounting equation. Note that the sto

What do you recognize by Open Item Managed Account? Ans) Open item management make sures that all items that have not yet been cleared are available in the system. Only after ea

What are steps to explain supplier? Ans) Supplier should follow the check list. 1 He should make confidence in the client mind 2 Services to be completed (fulfilled in tim

Q. What do you mean by depreciable asset? A depreciable asset is a manufactured asset such like a building, vehicle, machine or piece of equipment that provides service to a bu

Q. Explain about lower-of-cost-or-market method? The lower-of-cost-or-market (LCM) method is the inventory costing method that values inventory at the lower of its historical c

Consider the following 2008 data for Newark General Hospitals (in millions of dollars Simple Budget_______Flexible Budget_ Actual Budget__ Revenue______$4.7$____4.8_____$4.5____.


The salaries paid in 2004 is Rs. 5,00,000; Salaries outstanding  is  Rs. 20,000; Salaries paid in advance for 2004 is Rs. 30,000. What is the actual salary expenditure for 2004? Wh