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

Explain do mergers result in layoffs, Do mergers result in layoffs? Whole...

Do mergers result in layoffs? Whole employment in the banking industry in fact has increased slightly over the last ten years. A few mergers do result in layoffs. Though, many ba

Finance charges on credit card, Jack needs to borrow $1,000 for the next ye...

Jack needs to borrow $1,000 for the next year. Bank South will give him the loan at 9 percent. Suncoast bank will give him the loan at 7 percent with a $50 loan origination fee. Fi

Bonds with warrants, Bonds with Warrants: Warrants are usually attached...

Bonds with Warrants: Warrants are usually attached with the bonds or preference shares to attract the investor. The objective is to induce the potential investors to subscribe

What do you know about sinking funds, Q. What do you know about sinking fun...

Q. What do you know about sinking funds? sinking funds : quite often, one may be interested to accumulate a target amount over a given period inclusive of interest for the peri

Opportunity worth today, Assume that you can receive $25,000 per year forev...

Assume that you can receive $25,000 per year forever and that your cost of money is 7%.  What is this opportunity worth today?

Evaluate the extent to which the balanced scorecard, Evaluate the extent to...

Evaluate the extent to which the Balanced Scorecard: The Balanced Scorecard has been described as an effective measurement system which enables managers of an organisation to

Explain and compare the costs of hedging, Explain and compare the costs of ...

Explain and compare the costs of hedging via the forward contract and the options contract. Answer: There is no up-front cost of hedging through forward contracts. Though, in t

Bond Valuation, The Pennington Corporation issued a new series of bonds on ...

The Pennington Corporation issued a new series of bonds on January 1, 1979. The bonds were sold at par ($1,000), have a 12 percent coupon, and mature in 30 years, on December 31,

Foreign exchange exposure, Using an appropriate 'factor model', assess (a) ...

Using an appropriate 'factor model', assess (a) the performance of the management in creating value for shareholders and (b) the extent of the foreign exchange exposure of a FTSE10

What is the cash flows from financing activities, Cash flows from financing...

Cash flows from financing activities: Items included in this heading are: Cash receipts Cash payments Cash  receipts  from  iss

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