how would I do( a. b. c.) on excel

(12 Oct were $690,000, of which 2/3 were on credit. Record the entry QS 8-6 Adjusting entry to estimate bad debts-aging of receivables LO2,3 Dim Sum Foods has accounts receivable of $260,000 and the allowance for doubtful accounts has a credit balance of $6,000. Based on analyzing the aging of the accounts receivable, management determined that the appropriate ending balance in the allowance for doubtful accounts at year-end, December 31, should be $26,000 a. Draw a T-account for the allowance for doubtful accounts and fill it in with all of the given information, b. Determine the amount of bad debt expense that needs to be recorded. c. Prepare the adjusting journal entry to record the estimated bad debts at year-end. A Daut Me 20.000 20000 GENERAL JOURNAL Account de toplanation Date FR C Dec 31 26.000 20.000