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

Investigate the functions for horizontal asymptotes, Q. Investigate the fol...

Q. Investigate the following functions for both horizontal and vertical asymptotes, x and y-intercepts, and state the domain and range of each and where the function is increasing

Determine about the shareholders, Determine about the Shareholders Shar...

Determine about the Shareholders Shareholders, being the owners of the company, elect board of directors and vote on major issues that affect functioning and long term plans of

Factors affecting cost of capital, Factors Affecting cost of capital are el...

Factors Affecting cost of capital are elements in the business environment that cause a company cost of capital to be high and low. Figure below illustrative the various primary fa

Risk and return, I need report on Risk and Return. Do you provide help in t...

I need report on Risk and Return. Do you provide help in topic Risk and Return? I need expert's assistance to solve my college assignment. Please suggest if it works for me.

Calculate the price of a put option contract, The price of a non-dividend p...

The price of a non-dividend paying share, St, follows a geometric Brownian motion process. The current price of the share is £10 and volatility of the share price process is 12% pe

Explain the difference between cash and profit, Explain the Difference betw...

Explain the Difference between cash and profit Cash flow statement shows all the cash in and cash out for the organisation for that period. It demonstrates the cash generating

Compute the economic order quantity, Q. Compute the economic order quantity...

Q. Compute the economic order quantity? TNG has a current order size of 50000 units Average number of orders per year = demand/order size = 255380/50000 = 5·11 orders Ann

How cash budget and capital budget relate to pro forma, Explain how the cas...

Explain how the cash budget and the capital budget relate to pro forma financial statements. The cash budget depicts the projected flow of cash in and out of the firm for fixed

Methods of easing cash shortages, Q. Methods of easing cash shortages? ...

Q. Methods of easing cash shortages? There are several techniques which can potentially offset the effects of cash shortages. In the long-term nevertheless the adequacy of cash

Explain the benefits of benchmarking, Explain the Benefits of benchmarking ...

Explain the Benefits of benchmarking - Better understanding of business, competition and customers. - Improves business performance and discourages complacency. - Good wa

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