Bond Discount Amortization - Effective Interest Method method to amortize bond premium or discount. The bonds pay annual interest on January 1 . worksheet entitled Amortization Table. Enter the formulas to calculate the price of the bond in the worksheet entitled Pricing the Bond. a. Prepare the journal entry to record the issuance of the bonds on January 1,2017. c. Prepare the journal entry to record the accrual of interest and the amortization of the discount on December 31,2017. d. Prepare the journal entry to record the payment of interest on January 1, 2018. e. Prepare the journal entry to record the accrual of interest and the amortization of the interest on December 31,2018. f. Calculate the price of the bond by entering the Excel function that: a. Determines the present value of the repayment of the bond at maturity. b. Determines the present value of the series of bond interest payments over the life of the bond. c. Determines the price of the bond. file to upload. Do not upload JPEG. GIF or PDF files, which will not be graded or accepted. Submit on or before the due date. Late submissions will be accepted up to one week late, but with a penalty of 5% per day. Bond Amortization Problem Sp 2023.xisx Bond Discount Amortization - Effective Interest Method method to amortize bond premium or discount. The bonds pay annual interest on January 1 . worksheet entitled Amortization Table. Enter the formulas to calculate the price of the bond in the worksheet entitled Pricing the Bond. a. Prepare the journal entry to record the issuance of the bonds on January 1,2017. c. Prepare the journal entry to record the accrual of interest and the amortization of the discount on December 31,2017. d. Prepare the journal entry to record the payment of interest on January 1, 2018. e. Prepare the journal entry to record the accrual of interest and the amortization of the interest on December 31,2018. f. Calculate the price of the bond by entering the Excel function that: a. Determines the present value of the repayment of the bond at maturity. b. Determines the present value of the series of bond interest payments over the life of the bond. c. Determines the price of the bond. file to upload. Do not upload JPEG. GIF or PDF files, which will not be graded or accepted. Submit on or before the due date. Late submissions will be accepted up to one week late, but with a penalty of 5% per day. Bond Amortization Problem Sp 2023.xisx