please do all three requirments

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 Jure 30, 2021, the market interest rate is 9%. Ramsey Corporation issues $550,000 of 12%,20-year bonds payable. The bonds pay interest on dune 30 and December 31 . The compary amortizes bond premium using the effective-interest method. Read the teouirements Requirement 1. Use the PV function in Excel to caiculate the issue price of the bondi. (Round your answer to the nearest whole dollar)