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 |