must be done in excel

after the whit line it is the same photos that were before, just clearer

6X Before you begin, print out all the pages in this workbook. Otter Products Inc. issued bonds on January 1, 2019. Interest is to be paid semi-annually. Other information is as follows: Term in years: Face value of bonds issued: $200,000 Issue price: $206,000 Specified interest rate each payment period: Required: 1 Calculate: a. The amount of interest paid in cash every payment period. b. The amount of amortization to be recorded at each interest payment date (use the straight-line method). 2 Complete this amortization table by calculating interest expense, and beginning and ending bond carrying amounts at the end of each period over three years. Amortization Table _ (A+D) Beg. bond carrying amount Periodic interest expense Actual cash interest Periodic discount (prem.) amort. Ending bond carrying amount poid Year 2019 Period ending Jun. 30 Dec. 31 Jun. 30 Dec. 31 Jun. 30 Dec. 31 2020 2021 26 3 Calculate the actual interest rate under the straight-line method of amortization for each 27 six-month period. Round all percentage calculations to two decimal placed. Use the 28 following format: Six- Six month Bond month period carrying interest ending amount Year expense (B/A) 2019 2020 Jun. 30 Dec. 31 Jun. 30 Dec. 31 Jun. 30 Dec. 31 2021 14 Prepare the journal entry for December 31, 2019. Before you begin, print out all the pages in this workbook. Otter Products Inc. issued bonds on January 1, 2019. Interest is to be paid semi-annually. Other information is as follows: Term in years: Face value of bonds issued: $200,000 Issue price: $206,000 Specified interest rate each payment period: 6% Required: 1 Calculate: a. The amount of interest paid in cash every payment period. b. The amount of amortization to be recorded at each interest payment date (use the straight-line method). 2 Complete this amortization table by calculating interest expense, and beginning and ending bond carrying amounts at the end of each period over three years. Amortization Table (A + D) Beg. bond carrying amount Periodic interest expense Actual cash interest paid Periodic discount (prem.) amort. Ending bond carrying amount Year 2019 Period ending Jun. 30 Dec. 31 Jun. 30 Dec. 31 Jun. 30 Dec. 31 2020 2021 28 26 3 Calculate the actual interest rate under the straight-line method of amortization for each 27 six-month period. Round all percentage calculations to two decimal placed. Use the following format: Six- Six month Bond month period carrying interest ending amount Year expense (B/A) 2019 2020 Jun. 30 Dec. 31 Jun. 30 Dec. 31 Jun. 30 Dec. 31 2021 Dec. 31 4 Prepare the journal entry for December 31, 2019