I need help using the excel formulas to answer this question.

Instructions: Complete all cells shaded green. All answers must be determined using EXCEL formulae. Question 2 On January 1, 2021 a Company issued the following Bonds: \begin{tabular}{|l|c|} \hline Face amount & $500,000.0 \\ \hline Number of years & 15 \\ \hline Stated interest rate & 8% \\ \hline \multicolumn{2}{|l|}{ The bonds pay interest semi-annually. } \end{tabular} 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) \begin{tabular}{|l|} \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \end{tabular} \begin{tabular}{|l|} \hline 2 points \\ \hline 2 points \\ \hline 2 points \\ \hline 2 points \\ \hline 2 points \\ \hline \end{tabular} Price of bond as an absolute amount Part 2 Use the IF function to answer either 'Premium" or "Discount" to the following question: The bond in Part 1 is sold at a: 2 points 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 formulae or cell references