Question

Trophy Fish Company supplies flies and fishing gear products to sporting goods stores and outfitters throughout the western United States. The accounts receivable clerk for Trophy Fish prepared the following partially completed aging of receivables schedule as of the end of business on December 31, 20Y7:

			Not		Days Past Due
			Past
Customer	Balance		Due		1-30		31-60		61-90		91-120		Over 120
AAA Outfitters	19,900		19,900
Brown Trout Fly Shop	7,100						7,100
Zigs Fish Adventures	4,100				4,100
Subtotals	1,306,300		752,000		284,300		127,200		42,300		21,300		79,200

The following accounts were unintentionally omitted from the aging schedule:

Customer	Due Date		Balance
Adams Sports and Flies		May 22	$5,000
Blue Dun Flies		Oct. 10	5,400
Cicada Fish Co.		Sept. 29	7,900
Deschutes Sports		Oct. 20	7,300
Green River Sports		Nov. 7	3,600
Smith River Co.		Nov. 28	2,700
Western Trout Company		Dec. 7	6,300
Wolfe Sports		Jan. 20	4,900

Trophy Fish has a past history of uncollectible accounts by age category, as follows:

Age Class	Percent Uncollectible
Not past due	1	%
1-30 days past due	2
31-60 days past due	10
61-90 days past due	28
91-120 days past due	42
Over 120 days past due	78

Required:

1. Determine the number of days past due for each of the preceding accounts. If an account is not past due, enter a zero.

Customer	Due Date	Number of Days Past Due
Adams Sports and Flies	May 22	days
Blue Dun Flies	Oct. 10	days
Cicada Fish Co.	Sept. 29	days
Deschutes Sports	Oct. 20	days
Green River Sports	Nov. 7	days
Smith River Co.	Nov. 28	days
Western Trout Company	Dec. 7	days
Wolfe Sports	Jan. 20	days

Feedback

Count the number of days after the due date up to December 31. Do not include the due date in your count. Remember that not all months have an equal number of days.

Learning Objective 4.

2. Complete the aging of receivables schedule by adding the omitted accounts to the bottom of the schedule and updating the totals. If an amount box does not require an entry, leave it blank.

Trophy Fish Company
Aging of Receivables Schedule
December 31, 20Y7
Customer	Balance	Not Past Due	Days Past Due 1-30	Days Past Due 31-60	Days Past Due 61-90	Days Past Due 91-120	Days Past Due Over 120
AAA Outfitters	19,900	19,900
Brown Trout Fly Shop	7,100			7,100
Zigs Fish Adventures	4100		4100
Subtotals	1,306,300	752,000	284,300	127,200	42,300	21,300	79,200
Adams Sports and Flies
Blue Dun Flies
Cicada Fish Co.
Deschutes Sports
Green River Sports
Smith River Co.
Western Trout Company
Wolfe Sports
Totals
Percent uncollectible (%)		%	%	%	%	%	%
Estimate of uncollectible accounts	$	$	$	$	$	$	$

Answer 1

Solution 1:

Customer	Due Date	Number of Days Past Due
Adams Sports and Flies	22-May	223	Days
Blue Dun Flies	10-Oct	82	Days
Cicada Fish Co.	29-Sep	93	Days
Deschutes Sports	20-Oct	72	Days
Green River Sports	7-Nov	54	Days
Smith River Co.	28-Nov	33	Days
Western Trout Company	7-Dec	24	Days
Wolfe Sports	20-Jan	345	Days

Solution 2:

Trophy Fish Company
Aging of Receivables Schedule
December 31, 20Y7
Customer	Balance	Not Past Due	Days Past Due 1-30	Days Past Due 31-60	Days Past Due 61-90	Days Past Due 91-120	Days Past Due Over 120
AAA Outfitters	$19,900.00	$19,900.00
Brown Trout Fly Shop	$7,100.00			$7,100.00
Zigs Fish Adventures	$4,100.00		$4,100.00
Subtotals	$1,306,300.00	$752,000.00	$284,300.00	$127,200.00	$42,300.00	$21,300.00	$79,200.00
Adams Sports and Flies	$5,000.00						$5,000.00
Blue Dun Flies	$5,400.00				$5,400.00
Cicada Fish Co.	$7,900.00					$7,900.00
Deschutes Sports	$7,300.00				$7,300.00
Green River Sports	$3,600.00			$3,600.00
Smith River Co.	$2,700.00			$2,700.00
Western Trout Company	$6,300.00		$6,300.00
Wolfe Sports	$4,900.00						$4,900.00
Totals	$1,349,400.00	$752,000.00	$290,600.00	$133,500.00	$55,000.00	$29,200.00	$89,100.00
Percent uncollectible (%)	%	1%	2%	10%	28%	42%	71%
Estimate of uncollectible accounts	$117,607.00	$7,520.00	$5,812.00	$13,350.00	$15,400.00	$12,264.00	$63,261.00