can someone help me with the excel formulas on how to do this please.

Instructions: Complete all cells shaded green. All answers must be determined using EXCEL formuloe, Question 2 On January 1, 2021 a company issued the following Bonds Face amount $500,000 Number of years 15 Stated interest rate 8% The bonds pay interest semi-annually. Part 1 Using the PV function and assuming the annual market interest rate is 6%determine the price of the bonds issued on January 1, 2021 Number of interest periods Semi-annual interest payment Face amount (Future Value) Market interest rate per semi-annual period Price of bonds (Present Value) 2 points 2 points 2 points 2 points 2 points (Use PV FX function) Price of bond as an absolute amount 2 points 16 12 18 19 20 21 22 23 24 25 26 22 Part 2 Use the IF function to answer either "Premium" or "Discount" to the following question: 2 points The bond in Part 1 is sold at a: Compare the price of the bond as an absolute amount to the face amount Note: points will only be assigned where the answer is determine using EXCEL formule or cell references. 28 20