Solution :
Account Estimated Estimated
receivable loss% bad debts
Current 250,000 0.5 1250
1-30 days of past due 90,000 1.0 900
31-60 days of past due 20,000 2.0 400
61-120 days of past due 11,000 5.0 550
121-180 days of past due 6,000 10.0 600
Over 180 days of past due 4,000 25.0 1000
Total account receivable 381,000 4700
a). The amount for the bad debts expense is = 4700 - (4350 - 3830)
= 4180
b). Balance in the accounts receivable
Accounts receivable = 381,000
Less : allowance for bad debts = - 4180
Net realizable value of the accounts receivable = 376,820
c). Bad debts expense
a). 4180
Balance: 4180
The allowance for un-collectible account
Beg. Bal : 4350
write off : 3830
a). 4180
Balance 4700