McNe: Corporation issued 5700,000 of 6%,10 year bends payable on January 1,2022 . The market interest rate at the date of issuance was 4%, and the bonds pay interest samiannually (on June 30 and December 31) McNeil Corporation's year-end is June 30. Read the requitements 1. Using the PV function in Excel, calculate the issue price of the bonds, (Round your answer to the nearest whole dollar) The issue price of the bonds is Requirements 1. Using the PV function in Excet, calculate the tssue price of the bonds 2. Prepare an elleclive-interest amortization table far the bonds through the first three interest payments. Round amounts to the nearest dollar 3. Recoed McNeil Corporation's issuance of the bends on January 1, 2022, and payment of the first semiannual interest amount and amortizabion of the bond premium on June 30, 2022. Explanations ate not required