use excel to calculate the below question, assume the risk$-$free rate during the $24-$year period was $2\mathrm{.}5\%$ per year. given that cumulative return is $640\mathrm{.}40\%$ for XYZ funds and the cumulative return is $728\mathrm{.}24\%$ for S and P $500$ and the average annual return is $8\mathrm{.}70\%$ for XYZ and $9\mathrm{.}21\%$ for S and P $500$ Calculate the following measures and show your results in the table below. $($HINT

use the annualized return calculated in Q$1$ to calculate the risk premium & Sharpe Ratio in Q$2).$ Please include your work to questions $1$ & $2$ in the same Excel Spreadsheet and

upload the file as instructed below.

A$)$ Annualized volatility of XYZ Fund & S&P $500(10$ pts$)$

B$)$ Annualized risk premium of XYZ Fund & S&P $500(10$ pts$)$

C$)$ Sharpe Ratio of the XYZ Fund & S&P $500(5$ pts$)$