Question

Estimating Bad Debts Expense and Reporting of Receivables
At December 31, 2013, Sunil Company had a balance of $600,000 in its accounts receivable and an unused balance of $6,720 in its allowance for uncollectible accounts. The company then aged its accounts as follows:

Current	$486,400
0-60 days past due	70,400
61-180 days past due	28,800
Over 180 days past due	14,400
Total accounts receivable	$600,000

The company has experienced losses as follows: 1% of current balances, 5% of balances 0-60 days past due, 15% of balances 61-180 days past due, and 40% of balances over 180 days past due. The company continues to base its provision for credit losses on this aging analysis and percentages.

a. What amount of bad debts expense does Sunil report on its 2013 income statement?

$Answer

b. Show how accounts receivable and the allowance for uncollectible accounts are reported in its December 31, 2013, balance sheet.

Current Assets:
Accounts receivable	$Answer
Less: Allowance for uncollectible accounts	Answer
Accounts receivable, net	$Answer

Answer 1

• Working

Past Due base #	Amount of accounts receivables	% uncollectible	Estimated uncollectible
1	$486,400	1%	$4,864
2	$70,400	5%	$3,520
3	$28,800	15%	$4,320
4	$14,400	40%	$5,760
	$600,000		$18,464

• Requirement [a]
  --Existing unadjusted balance in Allowance account given = $ 6720 Credit
  --Adjusted balance required as per above working = $ 18,464 Credit

--Answer
Bad Debt Expense to be reported = $ 18464 – 6720
= $ 11,744

• Requirement [b]

Current Assets:
Accounts receivable	$ 600,000
Less: Allowance for uncollectible accounts	$ 18,464
Accounts receivable, net	$ 581,536