Please do with formula

Bond Pricing (10 points) A compay issued bond of 8 million with coupon rate of 6% and maturity of 5 years on Jan 1, 2020 The bond makes semi-annual coupon payments, and the yield to maturity is 8%. How much the compay receives when issue the bond? Rate PMT NPER FV Price use PV function Interest Payment Present value factor for annuity Face Value Present Vale Factor Price Using Present Value Table Bond Amortization for above Bond (20 Points) Payment Interst Expense Amortize Discount/Primium Bond Balance Jan-1-2020 Jun-30-2020 Dec-31-2020 Jun-30-2021 Dec-31-2021 Jun-30-2022 Dec-31-2022 Jun-30-2023 Dec-31-2023 Jun-30-2024 Dec-31-2024