if you can please post the answer on excel that would be great!

E-7 (Recording Bad Debts) Sandel Company reports the following financial information before adjustments. C. 160,000 Accounts Receivable Allowance for Doubtful Accounts Sales Revenue (all on credit) Sales Returns and Allowances 2,000 800.000 50.000 Instructions Prepare the journal entry to record bad debt expense assuming Sandel Company estimates bad debts at a) 1% of net sales and (b) 5% of accounts receivable