In: Accounting
Daley Company prepared the following aging of receivables analysis at December 31.
Days Past Due | ||||||
Total | 0 | 1 to 30 | 31 to 60 | 61 to 90 | Over 90 | |
Account receivables | 670000 | 416000 | 110000 | 56000 | 38000 | 50000 |
% uncollectible | 3% | 4% | 7% | 9% | 12% |
Requirements:
a. Complete the table below to calculate the estimated balance of Allowance for Doubtful Accounts using aging of accounts receivable.
b. Prepare the adjusting entry to record bad debts expense using the estimate from part a. Assume the unadjusted balance in the Allowance for Doubtful Accounts is a $5,600 credit.
c. Prepare the adjusting entry to record bad debts expense using the estimate from part a. Assume the unadjusted balance in the Allowance for Doubtful Accounts is a $2,100 debit.
Requirement [a]
Respective balances will be multiplied by the respective Uncollectuble % rate.
Accounts receivables | % uncollectibles | Estimated Uncollectibles | ||
[A] | [B] | [C = A x B] | ||
Not due | $416,000 | 3.00% | $12,480 | |
1 to 30 | $110,000 | 4.00% | $4,400 | |
31 to 60 | $56,000 | 7.00% | $3,920 | |
61 to 90 | $38,000 | 9.00% | $3,420 | |
Over 90 | $50,000 | 12.00% | $6,000 | |
Estimated balance of Allowance account [Adjusted ending balance required] | $30,220 | Credit |
Requirement [b]
Unadjusted balance in Allowance account | $5,600 | Credit | |
Estimated balance of Allowance account [Adjusted ending balance required] | $30,220 | Credit | |
Bad Debt Expense [or Uncollectible account expense] | $24,620 | $ 30220 credit required - $ 5600 credit existing |
Entry:
Accounts title | Debit | Credit |
Bad Debt Expense | $24,620 | |
Allowance for Doubtful Accounts | $24,620 | |
(to record adjustments for bad debts) |
Requirement [c]
Unadjusted balance in Allowance account | $2,100 | Debit |
Estimated balance of Allowance account [Adjusted ending balance required] | $30,220 | Credit |
Bad Debt Expense [or Uncollectible account expense] | $32,320 | $ 30220 credit required + $2100 debit existing |
Entry:
Accounts title | Debit | Credit |
Bad Debt Expense | $32,320 | |
Allowance for Doubtful Accounts | $32,320 | |
(to record adjustments for bad debts) |
Under Allowance method: |
>Bad Debt Expense is recorded by debiting Bad Debt expense, and crediting the Allowance account, which increases Allowance account balance. |
Requirements asked:
[a]
/ | Accounts receivables | % uncollectibles | Estimated Uncollectibles | |
Not due | $416,000 | 3.00% | $12,480 | |
1 to 30 | $110,000 | 4.00% | $4,400 | |
31 to 60 | $56,000 | 7.00% | $3,920 | |
61 to 90 | $38,000 | 9.00% | $3,420 | |
Over 90 | $50,000 | 12.00% | $6,000 | |
Estimated balance of Allowance account [Adjusted ending balance required] | $30,220 | Credit |
[b]
Accounts title | Debit | Credit |
Bad Debt Expense | $24,620 | |
Allowance for Doubtful Accounts | $24,620 | |
(to record adjustments for bad debts) |
[c]
Accounts title | Debit | Credit |
Bad Debt Expense | $32,320 | |
Allowance for Doubtful Accounts | $32,320 | |
(to record adjustments for bad debts) |