Using the mutual fund, benchmark and market proxy data provided in the attached spreadsheet, analyze and rank the performance of each mutual fund and their respective benchmarks within their specific categories as follows: A$)$ Calculate the Treynor and Sharpe ratio measures $($equations in slides $3$ and $6$ in the PPT$)$ for each fund and their three respective benchmarks. $1)$ Use the S&P $500$ index as the market proxy $($RM$)$ for estimating beta. The RFR proxy is the $90-$day T$-$Bill return $($provided$).2)$ Use the sample formula in Excel for standard deviation and use the slope function to calculate beta. Note that when calculating beta, individual fund returns are alwaysassigned to the Y$-$axis and returns on the market proxy to the X$-$axis. $3)$ Organize your Sharpe and Treynor estimates in the table in the spreadsheet and rank each fund and benchmark within their category from $1-3(1=$best$)$ for each measure. B$)$ Calculate Jensens alpha for each of the six funds and three benchmarks. $1)$ Use the averages you calculated previously and the modified alpha equation $($PPT slide $12)$ to find alpha. You can use the lower equation in place of running a regression, plugging in the known values from above and solving for alpha$\mathrm{.}2)$ Add your alpha estimates to the data table and rank them as you did in Part A$.$C$)$ Compute the Information Ratio $($IR$)$ for each of the six funds and their benchmarks. $1)$ Find the Excess Returns $($ERs$)$ by subtracting the overall market proxy return from the individual asset returns for each year. The average $($arithmetic mean$)$ for each column of Excess Returns is E in the equation $($PPT slide $13)$ for each fund and benchmark. $2)$ The standard deviation of each column of Excess Returns is the tracking error, ER$($use the sample standard deviation formula to calculate it$).3)$ Add your IR estimates to the data table and rank them as before. D$)$ Calculate the Sortino performance measure for each mutual fund and respective benchmark $($PPT slides $14$ & $15).1)$ The average $($arithmetic mean$)$ return for each asset is and the average $($arithmetic mean$)$ risk$-$free rate proxy return is $\mathrm{.}2)$ Use for your minimum acceptable return threshold $().3)$ To find the semi$-$deviation $($DR$),$ copy the raw fund returns to a new worksheet. $($a$)$ Using the average return on the market $()$ as the hurdle rate, delete every annual return falling above $()$ for each fund and benchmark.