Using excell with explanations please

P8.1A (LO 1, 2, 4) At December 31, 2019, House Co. reported the following information on its balance sheet. Instructions a. Prepare the journal entries to record each of these five transactions. Assume that no cash discounts were taken on the collections of accounts receivable. b. Enter the January 1, 2020, balances in Accounts Receivable and Allowance for Doubtful Accounts, post the entries to the two accounts (use T-accounts), and determine the balances. c. Prepare the journal entry to record bad debt expense for 2020, assuming that an aging of accounts receivable indicates that expected bad debts are $115,000. d. Compute the accounts receivable turnover for 2020, assuming the expected bad debt information provided in (c)