prociding for doubtful accounts

Providing for doubtful accounts at the end of the current year, the counts receita contra debt of 1,701,000 and sales for the year to 123,40,000 Determeer en under each of the few mom The wewnice account before adjustment has a debito 11.400 per 1/4 fifa b. The one ont before adjustments de bance of $13.00. As of account in the customer er intet The allowance account for woment has credit borce of 1.000 de especies d. The allowance account before adjustment has credit bance of $5.700 laging of the court in the currederas de conf. 300 This information has been called in the Microsoft Excel One on the set, perform the rear you, and not you in the actions belo Open the Round you to the nearest OS CS D A B Providing for doubtful accounts E F G 1 2 3 DATA 4 Debit balance Sales for the year $1,703,000 $23,840,000 6 Using formulas and cell references, perform the required analysis, and input your answers into the Amount column. Transfer the numeric results for the green entry cells (D12, D17, D22, and D27) into the 7 appropriate fields in CNOWV2 for grading 8 9 a. Debit balance of the allowance account before adjustment Bad debt expense is estimated at 10 11 $11,600 1/4 Amount of 1% of sales Formula 12 Amount of the adjusting entry 13 14 b. Debit balance of the allowance account before adjustment 15 Estimated allowance for doubtful accounts $11,600 $24,880 Amount T6 Formula 17 18 Amount of the adjusting entry 19 a Credit balance of the allowance account before adjustment Bad debt expense is estimated at 20 21 $6.900 3/4 Amount of 1% of sales Formula 22 23 Amount of the adjusting entry 24 d. Credit balance of the allowance account before adjustment 25 Estimated allowance for doubtful accounts $6,900 $57,300 Amount 26 Formula Amount of the adjusting entry 27 28 29 30 31 22 Pris for doua there. hew the 16.00 www