Question

RLF Company sells office equipment and supplies to many organizations in the city and surrounding area on contract terms of 2/10, n/30. In the past, over 75% of the credit customers have taken advantage of the discount by paying within 10 days of the invoice date. The number of customers taking the full 30 days to pay has increased within the last year. Current indications are that less than 60% of the customers are now taking the discount. Bad debts as a percentage of gross credit sales have risen from the 2.5% provided in past years to about 4.1% in the current year. The company’s Finance Committee has requested more information on the collections of accounts receivable. The controller responded to this request with the report reproduced below. The fact that some credit accounts will prove uncollectible is normal. Annual bad debt write-offs have been 2.5% of gross credit sales over the past 5 years. During the last fiscal year, this percentage increased to slightly less than 4.1%. The current Accounts Receivable balance is $1,800,000. The condition of this balance in terms of age and probability of collection is as follows. RLF COMPANY Accounts Receivable Collections May 31, 2017 Proportion of Total Age Categories Probability of Collection 60% not yet due 98% 22% less than 30 days past due 96% 9% 30 to 60 days past due 94% 5% 61 to 120 days past due 91% 2½% 121 to 180 days past due 75% 1½% over 180 days past due 30% Allowance for Doubtful Accounts had a credit balance of $26,500 on June 1, 2016. RLF has provided for a monthly bad debt expense accrual during the current fiscal year based on the assumption that 4.1% of gross credit sales will be uncollectible. Total gross credit sales for the 2016–2017 fiscal year amounted to $3,700,000. Write-offs of bad accounts during the year totaled $104,000. Prepare an accounts receivable aging schedule for RLF Company using the age categories identified in the controller’s report to the Finance Committee showing the following. (Round Proportion of Total to 3 decimal places, e.g 50% is .500 and Probability of Non-Collection to 2 decimal places e.g. 50% is 0.50.) (1) The amount of accounts receivable outstanding for each age category and in total. (2) The estimated amount that is uncollectible for each category and in total.

Answer 1

Accounts receivable balance	1,800,000
	a	b=1800000*a	c	d=100%-c	e=b*d
Age categories	Proportion of Total	Amount in category	Probability of collection	Probability of non collection	Estimated uncollectible amount
Not yet due	60%	1,080,000	98%	2.00%	21,600.00
Lessthan 30 days past due	22%	396,000	96%	4.00%	15,840.00
30 to 60 days past due	9%	162,000	94%	6.00%	9,720.00
61 to 120 days past due	5%	90,000	91%	9.00%	8,100.00
121 to 180 days past due	2.50%	45,000	75%	25.00%	11,250.00
Over 180 days past due	1.50%	27,000	30%	70.00%	18,900.00
Total	100%	1,800,000			85,410.00