On June 30, 2014, the market interest ate is 7%. Score Sports Ltd. ss es $3,000,000 of 12%, 20-year bonds payable. The bonds pay interest on June 30 and December 31. Score Sports Ltd. amortizes bonds by the effective nterest method 1. Us the PV function in Excer to calculate the issue price of the bonds 2. 3. Prapara an amortization table for tha first four semiannual interest periods Record the issuance of bonds payable on Juna 30, 2014; the payment of interest onDecember 31, 2014; and the payment of interest on June 30, 2015 Requirement 1. Use the PV function in Exce to cakculate the issue price of the bonds. (Round your answer to the nearest whole dollar.) The issue price of the bonds is s Requirement 2. Prepare an amortization table for the first four semiannual interest periods Enter the issue date information, then complete the table for each of the following semiannual interest periods (Round your answers to the nearest whole dollar.) Score Sports Ltd. Amortization Table Interest Interest Premium mm Account Bond Carrying Interest Period Jun 30, 2014 Dec 31, 2014 Jun 30, 2015 Dec 31, 2015 Jun 30, 2016 Amortization Balance