CHECK FIGURE: 2. Bad Debt Expense = $43,860

On December 31, 2020, RCA Company's Allowance for Doubtful Accounts had an unadjusted debit balance of $7,800. The accountant for RCA has prepared a schedule of the December 31, 2020, accounts receivable by age and, on the basis of past experience, has estimated the percentage of the receivables in each age category that will become uncollectible. This information is summarized as follows:

December 31, 2020 Age of Accounts Expected Percentage

Accounts Receivable Receivable Uncollectible

$620,000 Not due (under 30 days) 1.75%

355,600. 1 to 30 days past due 2.5

91,000 31 to 60 days past due 8.5

11,500 61 to 90 days past due 35.00

7,600 Over 90 days past due 60.00

Required

1. Calculate the amount that should appear in the December 31, 2020, balance sheet as the Allowance for Doubtful Accounts.

2. Prepare the journal entry to record bad debt expense for 2020.

Analysis Component: On July 31, 2021, RCA concluded that a customer's $4,200 receivable (created in 2020) was uncollectible and that the account should be written off. What effect will this action have on RCA's 2021 profit?

Explain your answer. in excel please thank you