Calculate the bad debt estimation, Cost Accounting

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

Dr. Cr. Allowance for Bad Debts........................... $1,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 $2,000. 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 June.

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 at 2% using income statement approach. During the year ended 2010 Anika made total net sales of $100,000 (of which 90% credit).

31 December Anika had an Accounts Receivable Balance of $44,000


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 5  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/13/2013 5:21:24 AM | Location : United States

Related Discussions:- Calculate the bad debt estimation, Assignment Help, Ask Question on Calculate the bad debt estimation, Get Answer, Expert's Help, Calculate the bad debt estimation Discussions

Write discussion on Calculate the bad debt estimation
Your posts are moderated
Related Questions
Semi Variable Costs Are costs along with both a fixed and variable cost component? The fixed component is such portion that is constant irrespective of the level of activity.

Following figures are taken from annual budget of ABC manufacturers for the year 2013: Fixed factory overhead Rs. 4,000,000 Factory overhead absorption rate Rs. 70 per direct labor

1.    The following table summarizes the short-run production function for your firm. Your product sells for $5 per unit, labor costs $5 per unit, and the rental price of capital i

BEP- Break Event Point: It shows no Loss and no Profit The level of activity at which, total revenues equivalent total costs. A point at which there is no profit and no loss.

You are thinking of investing in one of two corporations, both in the same industry, the XYZ Corporation or the ABC Corporation. Selected data follows: Sales data for the year e

Hello, I''m currently doing a research on a company and planning an Activity Based Costing system since the company is using Traditional Costing system to allocate the overhead to

Relationship among Financial Accounting and Cost Accounting The difference among management and cost accounting may be highlighted by using a number of questions namely as;

Price and Quality Aspect of Variance At this point it is serious to understand that all variance has two aspects, a price aspect and a quantity aspect: these two aspects combi

Consider as Illustration. Profit and loss account of TIL demonstrates, that, operations have given gross addition of Rs. 360 million to funds throughout the period. These funds sho

A retail dealer in garments is currently selling 24000 shirts annually. He supplies the following details for the year ended 31st December,2007. Rs Selling Price per shirt