The Ciao Style Store uses the accounts receivable aging method to estimate uncollectible accounts. On February 1, 2010, the balance of the Accounts Receivable account was a debit of $442,341, and the balance of Allowance for Uncollectible Accounts was a credit if $43,700. During the year, the store had sales on accounts of $3,722,000, sales returns and allowance of $60,000, worthless accounts written off of $44,300, and collections from customers of $3,211,000. As part of the end-of-year (January 31, 2011) procedures, an aging analysis of accounts receivable is prepared. The analysis, which is partially complete, is a follows:

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:
Percentage Considered
Time Uncollectible
Note yet due ...............2
1-30 days past due ...........5
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. How much is Ciao Style Store's estimated uncollectible accounts expense for the year? (Round the adjustment to the nearest whole dollar.)
5. What role do estimated play in applying the aging analysis? What factors might affect theseestimates?

Transcribed Image Text:

31-60 61-90 Over Not Yet 1-30 Days Days Days 90 Days DucPast Du Past Duc ast Due Past Due Customer Account Total Balance Forward $793,791 $438,933 S149,614 S106,400 S57,442 S41,402 Account Kras T. Lopez L.. Zapal R. Caputo E. Rago S. Smith A. Quinn Amount S11,077 9,314 8.664 780 14,710 6.316 4,389 S55,250 Due Date an. 15 Feb, 15 next fiscal year) Dec. 20 Oct. 1 an 4 Nov. 15 Mar next fiscal year)