On January 1, 2017, SDNOB Company issues 16%, $5,000,000 4-year bonds and the bonds pay interest quarterly on Mar 31, Jun 30, Sep 30, and Dec 31 each year. The prevailing market interest rate at the date of issue is 12%. Use the Effective Interest Rate method of amortization. REQUIRED: 1. Calculate the price of the bonds at the issue date Principal Coupon Payment Future Value Present Value Factor Present Value 0.00 Price of Bonds This is a numeric cell, so please enter numbers only. 2. Prepare a partial amortization table only for the first 242 years using the table given below A B F 1 INTEREST EXPENSE D AMORTIZED AMOUNT E UNAMORTIZED BALANCE DATE INTEREST PAID CARRYING VALUE OF BONDS 1/1/2017 2 3 3/31/2017 6/30/2017 4 5 9/30/2017 12/31/2017 6 7 3/31/2018 8 6/30/2018 9 10 9/30/2018 12/31/2018 3/31/2019 6/30/2019 11 12 3. Prepare journal entries to record the following: (a) Payment of interest on June 30, 2018 (b) Due to high interest rates in 2019, assume that the company retires the bonds on 6/30/2019 at 93. View transaction list Journal entry worksheet (a) Payment of interest on June 30, 2018 Note: Enter debits before credits. A B C D Account Title Debit Credit S.No/Date June 30, 2018 1 2. 3 4 5 6 Record entry Clear entry View general journal