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

Illustrate miller-orr model recognises, Q. Illustrate Miller-Orr model reco...

Q. Illustrate Miller-Orr model recognises? The Miller-Orr model recognises which cash balance requirements are likely to fluctuate and that active management is required in r

Determine the name of some profit margin ratios, Determine the name of some...

Determine the name of some profit margin ratios Other profit margin ratios can also be computed: Gross profit/ turnover Profit after tax/ turnover Advertising co

Explain the npv criterion, Consider that you are deciding whether to undert...

Consider that you are deciding whether to undertake one of two projects. Project A involves buying expensive machinery which will produce a better product at a lower cost. The mach

Monetary approach to the Exchange Rate, a The Monetary Approach to the ER. ...

a The Monetary Approach to the ER. All else equal, an increase in the interest rate in Canada is associated, in the long run, with higher prices in Canada and an appreciated exchan

Compute the interest, (a) These are merely the differences of the two pric...

(a) These are merely the differences of the two prices. Consequently the mark to market losses are given by { Q 1 - Q 0 ,Q 2 - Q 0 ,Q 3 - Q 0 ,Q 4 - Q

What are the internal audits, What are the Internal audits Internal au...

What are the Internal audits Internal audit is seen as independent from management who are devising and implementing internal controls and must be able to provide advice on in

What is percentage of sales method, Q. What is Percentage of Sales Method? ...

Q. What is Percentage of Sales Method? Percentage of Sales Method: - Under this process certain key ratios based on past year's information are established. These ratios is abl

Determination of spread, Determination of spread Daily interest rate = ...

Determination of spread Daily interest rate = 5.11/ 365 = 0.014% per day Variance of cash flows = 1000 × 1000 = $1000000 per day Transaction cost = $18 per transaction

Exchange rates, Exchange Rates The prices at which one country's c...

Exchange Rates The prices at which one country's currency can be changed into that of other country. Although perceptions in the currency markets of the privacy of a count

Discount rate determinants, Discount Rate Determinants The discount rat...

Discount Rate Determinants The discount rate is the firm weighted average cost of capital. It represents the opportunity cost of investing creditors and shareholders funds in o

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