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 term of the bonds. 3. Journalize the following transactions: a. Issuance of the bonds on December 31, 2014. Credit Convertible Bonds Payable. b. Payment of interest and amortization of the bond discount on June 30, 2015. c. Payment of interest and amortization of the bond discount on December 31, 2015. d. Conversion by the bondholders on July 1, 2016, of bonds with face value of $1,600,000 into 120,000 shares of Herndon Corp.s $1-par common stock. 4. Show how Herndon Corp. would report the remaining bonds payable on its balance sheet at December 31, 2016