Requirements 1. 2. 3. Use the PV function in Excel to calculate the issue price of the bonds. Prepare an effective-interest method amortization table for the first four semiannual interest periods. Journalize the following transactions: a. Issuance of the bonds on December 31, 2018. Credit Convertible Bonds Payable. b. Payment of interest and amortization of the bond discount on June 30, 2019. c. Payment of interest and amortization of the bond discount on December 31, 2019. d. Conversion by the bondholders on July 1, 2020, of bonds with a total face value of $1,400,000 into 70,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. On December 31, 2018, Lugaboo Corporation issues 6% 10-year convertible bonds payable with a face value of $3,500,000. The semiannual interest dates are June 30 and December 31. The market interest rate is 10% Lugaboo amortizes bond discounts using the effective interest method Read the reguiremens Requirement 1. Use the Pv function in Exceto calculate the issue price of the bonds. (Round your answer to the nearest whole dollar) The issue price of the bonds is $ Requirement 2. Prepare an effective-Inherent method amortization table for the first four comiannual interest periods. (Round your answers to the nearest whole dollar) Lugaboo Corporation Amortization Table Samiannual Interest Discount Discount Account Bond Carrying Interest Date Payment Interest Expen Amortization Balance Amount 12:31 2018 6-30-2010 12-31-2019 8-30-2020 12312020 Requirement 3. Joumalize the following transactions (Record debit first, then credits. Exclude explanations from all journal entries) a. Record the issuance of the bonds on December 31, 2018 Credit Convertible Bonds Payable (Round your answers to the nearest whole dollar) Journal Entry Date Accounts Debit Credit 2018 Dec 31 b. Record the payment of interest and amortization of the bonds on June 30, 2019. (Round your answers to the nearest whole dollar) Journal Entry Date Accounts Debit Credit 2019 Jun 30 c. Record the payment of interest and amortization of the bonds on December 31, 2019. (Round your answers to the nearest whole dollar) Journal Entry Date Accounts Debit Credit 2019 Dec 31 d. Record the conversion by the bondholders on July 1, 2020, of bonds with a total face value of 51,400,000 into 70,000 shares of Lugaboo's 51-par common stock. (Round your answers to the nearest whole dollar Journal Entry Date Accounts Debit Credit 2020 Al Requirement 4. Show how Lugaboo would report the remaining bonds payable on its balance sheet at December 31, 2020 (Calculate the discount by multiplying the discount calculated in the original amortization table by the traction of bonds remaining Round your answers to the nearest whole dolar) c. Record the payment of interest and amortization of the bonds on December 31, 2019. (Round your answers to the nearest whole dollar) Journal Entry Accounts Debit Credit Date 2019 Dec 31 d. Record the conversion by the bondholders on July 1, 2020, of bonds with a total face value of $1,400,000 into 70,000 shares of Lugaboo's 51-par common stock. (Round your answers to the nearest whole dollar) Journal Entry Accounts Debit Date 2020 Credit Jul Requirement 4. Show how Lugaboo would report the remaining bonds payable on its balance sheet at December 31, 2020. (Calculate the discount by multiplying the discount calculated in the original amortization table by the fraction of bonds remaining, Round your answers to the nearest whole dollar) Lugaboo Corporation Partial Balance Sheet December 31, 2020 Less