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

State about the nick leeson and barings, Nick Leeson and Barings Leeson...

Nick Leeson and Barings Leeson was the trader who managed to bring about the collapse of Barings Bank in 1995. The main reason he was able to do this was because there was a ce

Enumerate the potential drawbacks of divestment, Potential drawbacks of div...

Potential drawbacks of divestment - There may be some loss of economies of scale. Fixed overheads would have a lower capacity to recover them. - Cash generated may not be

Need for working capital, Along with the fixed capital nearly every Small-S...

Along with the fixed capital nearly every Small-Scale industries requires working capital though the extent of working capital requirement differs in different businesses. Working

Define swap broker, Define Swap Broker A swap broker arranges a swap am...

Define Swap Broker A swap broker arranges a swap among two counterparties for a fee with no taking a risk position in the swap.

Current scenario of hedge fund industry, Global Scenario The Hedge Fund...

Global Scenario The Hedge Fund industry has captured over US $ 2 trillion in assets globally by the end of year 2006. According to an investor survey revealed for the Hedge Fun

Determine about the systems based audit, Determine about the Systems based ...

Determine about the Systems based audit Systems based audit is useful as it would help identify risks within the processes in an organisation and review how adequate the contr

Type of assets, type of assets for ppt from t.y.bom com student in commerce...

type of assets for ppt from t.y.bom com student in commerce department in financial management

Dual aspect concept - accounting principle, Dual Aspect Concept - Accountin...

Dual Aspect Concept - Accounting Principle This is, no doubt, the basic concept in accounting.  Under this concept, each transaction has got a two-fold aspect: (i) yielding

Simple average of the outcomes - time constraint, 1. Your welfare depends o...

1. Your welfare depends on how much time you travel T and how much time you play P and is the product of the two, i.e.,  W = T * P (a) The total amount of time you have is 10 ho

Nature of current liabilities, Current Liabilities: A liability is an ...

Current Liabilities: A liability is an obligation to convey assets or do services at some future date. For purposes of balance sheet analysis, it is important to create a dist

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