Question

Aging Schedule (Excel) MetS company had a $1,000 credit balance in Allowance for Doubtful Accounts at December 31, 2018, before the current year's provision for uncollectible accounts. An aging of the accounts receivable revealed the following: Estimated Percentage Uncollectible Current Accounts $110,000 2% 1-30 days past due 30,000 31-60 days past due 20,000 8% 61-90 days past due 25,000 15% Over 90 days past due 15,000 40% Total Accounts Receivable $200.000 5% Instructions: You must show and explain your answers to receive credit and you need to set up an aging schedule using Excel. You earn more extra points by using formulas in your Excel schedule. (a) Determine the amount to recognize as bad debt expense on December 31, 2018. (b) What is the amount that is reported as the net balance for Accounts Receivable as of December 31, 2018? (c) Assume the same facts as above except that the Allowance for Doubtful Accounts account had a $500 debit balance before the current year's provision for uncollectible accounts. What is the amount of bad debt expense to recognize for the year. (d) What is the amount that is reported as the net balance for Accounts Receivable as of December 31, 2018.

Answer 1

Solution a:

Computation of Allowance for Uncollectible Accounts
Ageing	Accounts Receivables	% Uncollectible	Required Allowance
Current accounts	$110,000.00	2%	$2,200.00
1-30 days past due	$30,000.00	5%	$1,500.00
31-60 days past due	$20,000.00	8%	$1,600.00
61-90 days past due	$25,000.00	15%	$3,750.00
Over 90 days past due	$15,000.00	40%	$6,000.00
Total	$200,000.00		$15,050.00

Bad debts expense for year ended Dec 31, 2018 = Required allowance - Existing balance in allowance for doubtful accounts

= $15,050 - $1,000 = $14,050

Solution b:

Net accounts receivables = Gross receivables - Allowance for doubtful accounts = $200,000 - $15,050 = $184,950

Solution c:

Bad debts expense for year ended Dec 31, 2018 = Required allowance +  Existing debit balance in allowance for doubtful accounts

= $15,050 - $500 = $15,550

Solution d:

Net accounts receivables = Gross receivables - Allowance for doubtful accounts = $200,000 - $15,050 = $184,950