Prepare a revised aging schedule showing ages of accounts

Assignment Help Financial Accounting
Reference no: EM13179206

Bad debt and the allowance for doubtful accounts.

Normandale Brewing and Distilling Company's post closing trial balance on December 31, 2009 (in other words, at the beginning of 2010) reflects the following balances:

295_Prepare a revised aging schedule showing ages of accounts.png

Sales for 2010 were $5,500,000. All sales were sales on account. At the end of each month during 2010, Bobby Bookkeeper posted a journal entry recording bad debt expense for an amount equal to .75% (three quarters of one percent) of monthly sales, using the percentage of sales method. During 2009 collections of accounts receivable were $4,300,000.

A. Provide a journal entry to summarize the 12 monthly journal entries posted by the Bobby Bookkeeper during 2010 to record bad debt expense.

B. Provide a journal entry to summarize the collections of accounts receivable during 2010.

C. What is the amount of accounts receivable on December 31, 2010 according to the general ledger?

D. What is the amount of the allowance for doubtful accounts as of December 31, 2010? On January 15, 2011, Andy Auditor arrives on the scene and asks to see an aging schedule of the accounts receivable as of December 31, 2010. Bobby Bookkeeper provides an aging
schedule showing that:

- 10% of the receivables are older than 60 days,
- 20% of the receivables are between 31 and 61 days old, and
- 70% of the receivables were less than 30 days old.

Upon analysis of the $300,000 of accounts receivable, Andy sees:

- Invoice # M45987 dated December 15, 2010 in the amount of $10,000, receivable from Denny Hecker, who is in prison pending trial for his multi-million fraud. and

- Invoice #C98785 dated March 2, 2010 in the amount of $20,000 receivable from Trevor Cook who is in prison serving a 150 year term for fraud,  Andy and Bobby discuss these invoices and decide they should be written off as of December 31, 2010.

E. Provide the journal entry that Bobby will post to write off these accounts.

Andy and Bobby decide that of the remaining accounts receivable (after the write-offs taken in E above) 1% of the receivables that are not past due should be estimated as uncollectible, 5 % of the receivables that are past due but less than 61 days old should be estimated as uncollectible, and 50% of the receivables that are more than 60 days past due should be estimated as uncollectible

F. Prepare a revised aging schedule showing ages of the accounts receivable after the write-offs. Be very careful with your dates. [Hint: Be sure to reflect the write-offs taken in E above, in the correct age category].

G. Provide the journal entry that Bobby will post to adjust bad debt expense and the allowance for doubtful accounts as of December 31, 2010.

Reference no: EM13179206

Questions Cloud

Find the interest and the amount repaid : find the interest and the amount repaid using a 360-day year. round to the nearest cent. $9400.00principal, 10%rate, 36 days time. need to find the interest and amount.
Define the factors that influence the elasticity of demand : If the quantity demanded for apples increases by 1.25 per cent when the price of grapes increases by 2.5 per cent, the cross elasticity of demand between apple and grapes is,Suppose a rise in the price of a good from $7.50 to $8.50 leads to a decr..
Define a markov chain : Define a Markov chain with r+1 classes and find its transition probability matrix.
What is the probability that a freshman selected at random : What is the probability that a freshman selected at random from this group is enrolled in each of the following? (Enter your answers to three decimal places.)
Prepare a revised aging schedule showing ages of accounts : Prepare a revised aging schedule showing ages of the accounts receivable after the write-offs. Be very careful with your dates. [Hint: Be sure to reflect the write-offs taken in E above, in the correct age category].
Real property and tangible personal property : What is the difference between real property and tangible personal property?  Differentiate between an ownership and a possessory interest in real estate.
Find the dimensions of the strongest beam : The strength of a rectangular beam is proportional to the product of its width and the square of its depth. Find the dimensions of the strongest beam that can be cut from a circular cylindrical log of radius r.
What is the probability of selecting a value : the mean of a normally distributed population is 400 pounds. the standard deviation is 10 pounds. What is the probability of selecting a value between the mean and 415 pounds?
What is the likelihood that 5 will be broken : A company owns 300 laptops. Each laptop has an 7% probability of not working. You randomly select 20 laptops for your salespeople.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Valuation of bond at applicable inflation rates

Valuation of Bond at applicable inflation rates and change in the risk free rates and what rate should you see for a three-year-maturity Treasury Bond in today's  Wall Street Journal ?

  Evaluate the total overhead applied to production during may

Evaluate the total overhead applied to production during May. Determine the cost of the ending work in process inventory. Evaluate the cost of jobs completed during May. Calculate the cost of goods sold for the year ended May 31.

  Determine the weighted- average contribution margin

determine the (1) weighted- average contribution margin, (2) break-even point in units, and (3) number of units of each product that will be sold at the break-even point.

  Analyze the amount of expenses

Analyze the amount of these expenses that Simon is able to deduct, considering he itemizes his deductions, in each of the subsequent situations

  Determine the equivalent units for may for materials

Finding  the equivalent units for materials and conversion - Determine the equivalent units for May for materials and conversion costs?

  Comparative financial statement analysis and ratio analysis

Comparative financial statement analysis and ratio Analysis and trend analysis should involve Sales, Operating Expenses, Cost of Goods Sold, and Net Income

  Prepare the journal entries to record

Prepare the journal entries to record the estimated warranty costs and (b) the actual costs incurred and Preparation of journal entries to record

  Illustrate what weight should templeton use in computing

The current owner have no debt financing but Templeton plans to borrow $320 million and invest $100 million in equity. Illustrate what weight should Templeton use in computing the WACC for this acquisiton? Round to one decimal place.

  Determine alpha of the stock

The market expected rate of return is 8% and the risk-free rate is 5%.  Determine alpha of the stock

  What is phoenix''s merge retained earnings balance

What is Phoenix's merge retained earnings balance at 31 st December, 2013?

  Explain why the amount of net income differs from the amount

What amount of net income would Spartan Company report on its 2010 income statement? Explain why the amount of net income differs from the amount of the ending Retained Earnings balance.

  Determine a simple price index

Calculation of Simple Price Index - determine a simple price index for this item using 19X4 as the base year.

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