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

WACC, WHAT ARE THE MAIN VIEWS OF WACC PREVALENT IN THE FINANCIAL MANAGEMENT...

WHAT ARE THE MAIN VIEWS OF WACC PREVALENT IN THE FINANCIAL MANAGEMENT LITERATURE

Analysis of financial statement, complete the balance sheet and sales infor...

complete the balance sheet and sales information using the following data: debt to assets ratio 50% current ratio 1.8x total assets turnover 1.5x day sales outstanding 36.5 days (c

Nominal interest rate, You are considering an investment in a 40-year secur...

You are considering an investment in a 40-year security. The security will pay $25 a year at the end of each of the first 3 years. The security will then pay $30 a year at the end

Discounting the expected cash flows in valuation process, After deter...

After determining the expected cash flows and appropriate interest rate, the last step in the valuation process is to find the total PV of all cash flows. The PV

Takeover risk, If the issuer company is taken over, then the bondhold...

If the issuer company is taken over, then the bondholders are likely to suffer. It is due to lowering of the stock prices in the market as a post takeover effect.

How cash flow problems arise, Q. How cash flow problems arise? It is si...

Q. How cash flow problems arise? It is significant first to distinguish between profitability and cash availability. The key scheme relates to insolvency since even profitable

Determine about the zero interest bonds, Determine about the Zero Interest ...

Determine about the Zero Interest Bonds (ZIBs) Very much alike DDBs, only crucial difference is that these are issued at face values (DDBs are issued at a discount to face valu

Pension fund management, Pension fund management Pension fund systems o...

Pension fund management Pension fund systems ought to be carefully designed and supervised to make sure that their purposes are met, the economic consequences are appropriate a

Project on investment banking house, The Project to be Addressed by the Pap...

The Project to be Addressed by the Paper: You have just graduated from CCI's MBA program and have secured a position as a fund manager for a well known investment banking house

Accounting period - accounting principle, Accounting Period - Accounting Pr...

Accounting Period - Accounting Principle Accounting period refers to span of time at the end of that and for which the financial statement are prepared to throw light on the r

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