Please show work in excel

E7-7 (Recording Bad Debts) Duncan Company reports the following financial information before adjustments. Dr. Cr. $100,000 Accounts Receivable Allowance for Doubtful Accounts Sales Revenue (all on credit) Sales Returns and Allowances $ 2,000 900,000 50,000 Instructions Prepare the journal entry to record Bad Debt Expense assuming Duncan Company estimates bad debts at (a) 1% of net sales and (b) 5% of accounts receivable