Prepare a revised aging schedule of account, Financial Management

Assignment Help:

Debit Credit

Accounts receivable $300,000

Allowance for doubtful accounts $35,000

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].


Related Discussions:- Prepare a revised aging schedule of account

Impact of the yield level in bonds, Different bonds trade at differen...

Different bonds trade at different yields though the coupon rate, maturity, and embedded options are same for them. Assuming that all the other bond characteristi

Forward contracts, Forward Contracts: The origin of forward contracts i...

Forward Contracts: The origin of forward contracts is lost in history. Some authors suggest that, it was India where these contracts took birth, while some others suggest that

Explaqin advantage of any available cash discounts, Assume that you have be...

Assume that you have been consistently impressed by David and Tom Gardner of The Motley Fool since you first heard of their rather improbable rise to prominence in financial circ

Computing forward rate, We can compute any forward rate using the spo...

We can compute any forward rate using the spot rate. When we tell 3 years forward rate 4 years from now, there are two elements to consider. One is the length of

Accounting entity - accounting principle, Accounting Entity - Accounting Pr...

Accounting Entity - Accounting Principle For accounting reasons it is suppose that business has separate existence and its entity is different from that of its owner(s). In si

Expected monthly return, In this exercise you will construct efficient port...

In this exercise you will construct efficient portfolios with 5 risky assets using Excel's non-linear optimization routing "Solver". The questions are designed to be sequential and

Terms of maturity date very short term, 1. (a) A barbell is a approach of...

1. (a) A barbell is a approach of maintaining a portfolio of securities concentrated at two extremes in terms of maturity date very short term and very long term. A positive

Why is the replacement value of assets method, Why is the replacement value...

Why is the replacement value of assets method not generally used to value complete businesses? The replacement value of assets method isn't often applied to entire business val

Brief on mistakes in linton’s evaluation, Mistakes in Linton's evaluation ...

Mistakes in Linton's evaluation (1) The preliminary investment in working capital should be offset by a working capital release in the final year, assuming a constant level of

Companies that would be best able to handle high debt levels, Give two exam...

Give two examples of types of companies that would be best able to handle high debt levels. Companies that manage local telephone service and those that manage natural gas deli

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