In: Accounting
Below is the “totals” section of XYZ Corporation’s full aging schedule. XYZ will be using this information to estimate uncollectible accounts receivable at year-end
| Number of Days Outstanding | ||||||
| Total | 0-30 | 31-60 | 61-90 | 91-120 | Over 120 | |
| Accounts receivable | $ 375,000 | $ 220,000 | $ 90,000 | $ 30,000 | $ 20,000 | $ 15,000 | 
| % uncollectible | 1% | 4% | 5% | 9% | 20% | |
| Estimate bad debts | ||||||
Instructions:
Please list each response separately label them clearly to avoid confusion. thank you.
a)
| Age category | Amount | % uncollectible | Estimated Bad debts | 
| 0-30 | 220000 | 1% | 2200 | 
| 31-60 | 90000 | 4% | 3600 | 
| 61-90 | 30000 | 5% | 1500 | 
| 91-120 | 20000 | 9% | 1800 | 
| over 120 | 15000 | 20% | 3000 | 
| Total estimated bad debts | 12100 | 
b)
Bad debt expense for the year = Total estimated bad debts - current balance in Allowance for Doubtful Accounts
= 12100 -3000
= 9100
| Date | Account title | Debit | credit | 
| Bad debt expense | 9100 | ||
| Allowance for doubtful account | 9100 | 
c)
Bad debt expense for the year = Total estimated bad debts - current balance in Allowance for Doubtful Accounts
= 12100 -(-500)
= 12100+500
= 12600
| Date | Account title | Debit | credit | 
| Bad debt expense | 12600 | ||
| Allowance for doubtful account | 12600 | 
d)
| Date | Account title | Debit | credit | 
| Allowance for doubtful account | 1800 | ||
| Accounts receivable | 1800 |