please provide step by step and screnshot of excel tables with explanation

Lance Company has estimated its bad debts at 2 per cent of net credit sales. During 2022 , the company decided to calculate the required balance for the allowance for doubtful accounts at year-end, December 31 , by aging its accounts receivable. The review suggested a required balance of $8,000 would not be collectible. The following data, which already have been recorded in the company's general ledger, are also available: The Allowance for Doubtful Accounts general ledger account reported the following balances: January 1, 2021$8,000(Cr) and Net credit sales of $300,000. Required: Prepare journal entries to record: 1. The amount of bad debt expense for the year 2021 2. The bad debt expense on December 31, 2022 3. The collection on June 5,2022