oviding for doubtful accounts

At the end of the current year, the accounts receivable account has a debit balance of $1,453,000 and sales for the year total $20,340,000. Determine the amount of the adjusting entry to provide for doubtful accounts under each of the following assumptions:

The allowance account before adjustment has a debit balance of $9,900. Bad debt expense is estimated at 1/4 of 1% of sales.

The allowance account before adjustment has a debit balance of $9,900. An aging of the accounts in the customer ledger indicates estimated doubtful accounts of $21,240.

The allowance account before adjustment has a credit balance of $8,000. Bad debt expense is estimated at 3/4 of 1% of sales.

The allowance account before adjustment has a credit balance of $8,000. An aging of the accounts in the customer ledger indicates estimated doubtful accounts of $66,400.

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below