Tolon Company has made an analysis of its sales and accounts receivable for the past 5 years. Assume all accounts written off in a year related to sales of the preceding year and were part of the accounts receivable at the end of that year. That? is, no account is written off before the end of the year of the? sale, and all accounts remaining unpaid are written off before the end of the year following the sale. The analysis showed the? following:

The balance in Allowance for Uncollectible Accounts on December? 31, 20X4, was $16,100.

Requirement 1. Determine the bad debts expense for 20X5 and the balance of the Allowance for Uncollectible Accounts for December? 31, 20X5, using the percentage of sales method. ?(A/R = Accounts? Receivable.)

Begin with the bad debts expense for 20X5 and start by determining the formula and entering the amounts to calculate the bad debts expense as a percentage of sales.

Now determine the balance of the Allowance for Uncollectible Accounts for December? 31, 20X5 using the percentage of sales method.

Select the formula and then enter the amounts to calculate the allowance at December? 31, 20X5.

Requirement 2. Repeat requirement 1 using the percentage of ending accounts receivable method. ?(A/R = Accounts? Receivable.)

Start by determine the formula and entering the amounts to calculate the allowance as a percentage of ending accounts receivable using the percentage of ending accounts receivable method.

Next, select the formula and enter the amounts to calculate the balance of the Allowance for Uncollectible accounts at the end of 20X5 using the percentage of ending accounts receivable method.

Sales 20X1 680,000 750,000 20X2 750,000 20X3 850,000 20X4 840,000 20X5 Ending Accounts Receivable 90,000 97,000 103,000 114,000 110,000 Bad Debts Written Off During the Year 12,000 12,500 14,000 16,500 17.600