On June 30, 2021, the market interest rate is 10% Team Corporation issues $500,000 of 11%. 25-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 requirements Requirement 1. Use the PV Junction in Excel to calculate the issue price of the bonds. (Round your answer to the nearest whole dollar) The issue price of the bonds is $545.640 Requirement 2. Prepare an amodization 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) Team Corporation Amortization Table Premium Amortization Sem Interest Period Interest Payment Interest Expense Jun 30, 2021 Premium Account Bond Carrying Balance Amount