Complete the following on the Lesson 7 Template, EXCEL which is an Excel spreadsheet.Using the allowance method, prepare the journal entries to write off bad debts based on past due receivables 90 days or more past due.Using the direct write-off method, prepare the journal entries to write off the bad debts expense.Using the allowance method, prepare the balance sheet presentation of accounts receivable as a net realizable value method showing gross, the allowance, and net amounts.Using the direct write-off method, prepare the balance sheet presentation of accounts receivable as it would show after the write offs.Which method shows lower net realizable accounts receivable? Why?