1 Requirements 1. Use the PV function in Excel to calculate the issue price of the bonds. 2. Prepare an effective-interest method amortization table for the first four semiannual interest periods. Journalize the following transactions: 3. a. Issuance of the bonds on December 31, 2018. Credit Convertible b. Payment of interest and amortization of the bond discount on June 30, c. Payment of interest and amortization of the bond discount on d. Conversion by the bondholders on July 1, 2020, of bonds with a total Bonds Payable. 2019. December 31, 2019. face value of $2,000,000 into 40,000 shares of Lugaboo's $1-par common stock. Show how Lugaboo would report the remaining bonds payable on its balance sheet at December 31, 2020 4. PrintDone 1 Requirements 1. Use the PV function in Excel to calculate the issue price of the bonds. 2. Prepare an effective-interest method amortization table for the first four semiannual interest periods. Journalize the following transactions: 3. a. Issuance of the bonds on December 31, 2018. Credit Convertible b. Payment of interest and amortization of the bond discount on June 30, c. Payment of interest and amortization of the bond discount on d. Conversion by the bondholders on July 1, 2020, of bonds with a total Bonds Payable. 2019. December 31, 2019. face value of $2,000,000 into 40,000 shares of Lugaboo's $1-par common stock. Show how Lugaboo would report the remaining bonds payable on its balance sheet at December 31, 2020 4. PrintDone