For E14-5, please create a excel table showing the premium fully amortized at maturity.

For each of these two independent situations, prepare journal entries to record the following. (a) The issuance of the bonds. (b) The payment of interest on July 1. (c) The accrual of interest on December 31. Entries for Bond Transactions -Straight Line) Celine Dion Company issued $600,000 of 10% 20-year bonds on January 1, 2017, at 102. Interest is payable semiannually on July 1 and January 1. Dion Company uses the straight-line method of amortization for bond premium or discount. Prepare the journal entries to record the following. (a) The issuance of the bonds. (b) The payment of interest and the related amortization on July 1, 2017. (c) The accrual of interest and the related amortization on December 31, 2017. (Entries for Bond Transactions-Effective-Interest) Assume the same information as in E14-4, except that Celine Dion Company uses the effective-interest method of amortization for bond premium or discount. Assume an effective yield of 9.7705%. Prepare the journal entries to record the following. (Round to the nearest dollar.) (a) The issuance of the bonds. (b) The payment of interest and related amortization on July 1, 2017. (c) The accrual of interest and the related amortization on December 31, 2017 (Amortization Schedule-Straight-Line) Devon Harris Company sells 10% bonds having a maturity value of $2,000,000 for $1, 855, 816. The bonds are dated January 1, 2017, and mature January 1, 2022. Interest is payable annual on January 1