please do all requirments

Use the PV function in Excel to calculate the issue price of the bonds. 2. Prepare a bond amortization table for the first year of the bonds. 3. Record the issuance of the bonds payable on December 31, 2021; the first semiannual interest payment on June 30,2022 ; and the second payment on December 31, 2022. amonizes bond discount using the efective interest method The sonkanual interest dales are June 30 and Decenber 31 Read the Requirement 1. Use the PV hunction in Excel to calculate the issue price of the bonds (Round your antiner to the neovest weche dollar) The iscue price of the bonds is