please do it in exel

P15.1A (LO 2, 4) Financial Statement On May 1, 2020, Herron Corp. issued $600,000, 9%, 5-year bonds at face value. The bonds were dated May 1, 2020, and pay interest annually on May 1. Financial statements are prepared annually on December 31. Prepare entries to record issuance of bonds, interest accrual, and bond redemption. Instructions a. Prepare the journal entry to record the issuance of the bonds. b. Prepare the adjusting entry to record the accrual of interest on December 31, 2020. c. Show the balance sheet presentation on December 31, 2020. d. Prepare the journal entry to record payment of interest on May 1, 2021. Int. exp. $18,000 e. Prepare the adjusting entry to record the accrual of interest on December 31, 2021. f. Assume that on January 1, 2022, Herron pays the accrued bond interest and calls the bonds. The call price is 102. Record the payment of interest and redemption of the bonds