Garcia Company uses the accounts receivable aging method to estimate uncollectible accounts. At the beginning of the year, the balance of the Accounts Receivable account was a debit of $90,430, and the balance of Allowance for uncollectible Accounts was a credit of $8,100. During the year, the company had sales on account of $475,000, sales returns and allowances of $6,200, worthless accounts written off of $8,800, and collections from customers of $452,730. At the end of year (December 31, 2011), a junior accountant for Garcia Company was preparing an aging analysis of accounts receivable. AT the top of page 6 of the report, the following totals appeared:

To finish the analysis, the following accounts need to be classified:

From past experience, the company has found that the following rates are realistic for estimating uncollectible accounts:

Time Percentage Considered Uncollectible
Not yet due2
1-30 days past due5
31-60 days past due 15
61-90 days past due 25
Over 90 days past due 50
Required
1. Complete the aging analysis of accounts receivable.
2. Compute the end-of-year balances (before adjustments) of Accounts Receivable and Allowance for Uncollectible Accounts.
3. Prepare an analysis computing the estimated uncollectible accounts.
4. Calculate Garcia Company's estimated uncollectible accounts expense for the year (round amount to the nearest whole dollar)
5. What role do estimates play in applying the aging analysis? What factors might affect theseestimates?

Transcribed Image Text:

31-60 61-90 Over 90 Not Yct 1-30 Days Days Dys Dys Past Customer Account Balance Forward $89,640 $49,030 S24,110 S9,210 S3,990 $3,300 Total D Pt Duc Past Duc Past Duc Due Amount $ 930 645 1,850 2,205 Due Date Account B. Smith L.. Wing A. Rak T. Cat M. Nut S. Prince . Wind Jan. 14 ncxt year) Dec. 24 Sepe. 28 Aug. 16 Dec. 14 an. 23 next year) Nov. 5 350 1,785 295 S8,060