Requirement 1. Use the FV function in Excel to calculate the issue price of the bonds. (Round your answer to the nearest whole dolar.) The issue price of the bonds is Requirement 2. Prepare an effective-interest method amorization table for the first four semiannual interest periods. (Round your answers to the nearest whole dollar.) Requirements 1. Use the PV function in Excal to calculate the issue price of the bonds. 2. Prepare an effective-interest method amortization table for the fisst four semiannual interest periods. 3. Journa ze the following transactions: a. Issuance of the bonds on December 31, 2021. Credit Convertible Bonds Payable. b. Payment of interest and amortization of the bond discount on June 30 , 2022. Requirement 3. Journalize the following transactions. (Record debits first, then credits. Exclude explanations from all journal entries.) c. Payment of interest and amortization of the bond discount on December 31, 2022. a. Record the issuance of the bonds on December 31, 2021. Credit Corvertible Bonds Payable. (Round your answers to the nearest whole dollar.) d. Conversion by the bondholders on July 1,2023 , of bonds with a total face value of $1,600,000 into 90,000 shares of Rugaboo's $1par common stock. 4. Show how Rugaboo would report the remaining bonds payable on its balance sheet at December 31, 2023