Use the PV function in Excel to calculate the issue price of the bonds

Requirements 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,2021 ; the payment of interest on December 31,2021; and the payment of interest on June 30 , 2022. On June 30,2021 , the market interest rate is 9%. Ramsey Corporation issues $550,000 of 12%,20-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 reauirements. Requirement 1. Use the PV function 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 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.)