In: Accounting
B-Good, Inc. has accounts receivable at September 30 of $1,000,000. At September 30, Allowance for Doubtful Accounts has a | |||||||||
credit balance (prior to adjustment) of | $ 2,250 | ||||||||
The Company uses the percentage of receivables basis for estimating uncollectible accounts. An analysis of the accounts | |||||||||
and the percentage of estimated bad debts are as follows: | |||||||||
Month of | Age of | 9/30 | Estimated % | ||||||
Sale: | Accounts | Balance | Uncollectible | ||||||
September | 1 - 30 days | $650,000 | 2.5% | ||||||
August | 31 - 60 days | 150,000 | 6.0% | ||||||
July | 61 - 90 days | 120,000 | 33.0% | ||||||
June | 91-120 days | 50,000 | 59.0% | ||||||
Prior to June | over 120 days | 30,000 | 90.0% | ||||||
$1,000,000 | |||||||||
Instructions: | |||||||||
(a) Determine the total estimated uncollectibles. | |||||||||
Total | |||||||||
Age of | Estimated | ||||||||
Accounts | Balance | % | Uncollectible | ||||||
Cell Reference | Cell Reference | Cell Reference | Formula | ||||||
Cell Reference | Cell Reference | Cell Reference | Formula | ||||||
Cell Reference | Cell Reference | Cell Reference | Formula | ||||||
Cell Reference | Cell Reference | Cell Reference | Formula | ||||||
Cell Reference | Cell Reference | Cell Reference | Formula | ||||||
Formula | |||||||||
(b) Record the adjusting journal entry to estimate bad debts. Include an explanation of the entry. | |||||||||
Debit | Credit | ||||||||
Sep 30 | Account Title | Formula | |||||||
Account Title | Cell Reference | ||||||||
Explanation | |||||||||
(c) On 10/15, management authorizes the write-off of an uncollectible customer account with a balance of | $ 9,640 | ||||||||
Record this write off. | |||||||||
Debit | Credit | ||||||||
Oct. 15 | Account Title | Cell Reference | |||||||
Account Title | Cell Reference |