I need all three requirements! thank you!

McNel Corporation issued $800.000 of 6%, 10 year bonds payable on January 1, 2022. The market interest rate at the date of issuance was 4% and the bonds pay torot semiannually on June 30 and December 31). McNeil Corporation's your-onds June 30 Read the requirements 1. Using the functionnel, calculate the issue price of the bonds (Round your answer to the nearest wnole dollar) The price of the bonds is - X Requirements 1. Using the PV function in Excel, calculate these price of the bondo 2. Prepare an effective interest amortization table for the bonds through the first three interest payments Round amounts to the nearest dollar 1. Record McNeil Corporation's issuance of the bonds on January 1, 2022. and payment of the first semiannual interest amount and amortization of the bond premium on June 30, 2022 Explanations are not required Print Done