On June 30, 2016, the market interest rate is 8%. Team Sports Ltd. issues $800,000 of 10%, 10-year bonds payable. The bonds pay interest on June 30 and December 31. Team Sports Ltd. amortizes bond premium by the effective-interest method. Requirements Use the PV function in Excel to calculate the issue price of the bonds. Prepare a bond amortization table for the first four semiannual interest periods. Record the issuance of bonds payable on June 30, 2016; the payment of interest on December 31, 2016; and the payment of interest on June 30, 2017. The issue price of the bonds is $908, 723. 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.)