ee On June 30, 2018, the market interest rate is 10% Team Corporation issues $800,000 of 11%, 10-year bonds payable. The bonds pay interest on June 30 and December 31 The company amortizes bond premium using the effective-interest method. Read the Banrement Semiannual Team Corporation Amortization Table Interest Premium Expense Amortization Interest Premium Account Interest Period Payment Balance Jun 30, 2018 Bond Carrying Amount 800000 804000 0 Dec 31, 2018 44000 40000 4000 4000 Jun 30, 2019 44000 39800 4200 200 800200 Dec 31, 2019 44000 Jun 30, 2020 44000 0 Requirements - X 1. Use the PV function in Excel to calculate the issue price of the bonds. 2. Prepare a bond amortization table for the first four semiannual interest periods. 3. Record the issuance of bonds payable on June 30, 2018, the payment of interest on December 31, 2018, and the payment of interest on June 30, 2019. 100 1001 1200 Print Done