Excel Online Structured Activity: Bond valuation analysis to answer the question below. Open spreadsheet $ \begin{tabular}{|c|c|c|c|} \hline & & & \\ \hline 1 & Bond valuation & & \\ \hline 2 & & & \\ \hline 3 & Years to maturity & 25 & \\ \hline 4 & Par value of bond & $1,000.00 & \\ \hline 5 & Coupon rate & 9.00% & \\ \hline 6 & Frequency interest paid per year & 2 & \\ \hline 7 & Effective annual rate & 7.57% & \\ \hline 8 & & & \\ \hline 9 & Calculation of periodic rate: & & Formulas \\ \hline 10 & Nominal annual rate & & #N/A \\ \hline 11 & Periodic rate & & #N/A \\ \hline 12 & & & \\ \hline 13 & Calculation of bond price: & & Formulas \\ \hline 14 & Number of periods & & \#N/A \\ \hline 15 & Interest rate per period & 0.00% & \\ \hline 16 & Coupon payment per period & & #N/A \\ \hline 17 & Par value of bond & $1,000.00 & \\ \hline 18 & Price of bond & & #N/A \\ \hline 19 & & & \\ \hline \end{tabular}