In: Finance
You have been given the following return information for a mutual fund, the market index, and the risk-free rate. You also know that the return correlation between the fund and the market is 0.97.
Year | Fund | Market | Risk-Free | |||
2011 | –17.6 | % | –34.5 | % | 2 | % |
2012 | 25.1 | 20.5 | 4 | |||
2013 | 13.4 | 12.4 | 2 | |||
2014 | 6.6 | 8.4 | 5 | |||
2015 | –1.8 | –4.2 | 3 | |||
What are the Sharpe and Treynor ratios for the fund? (Do not round intermediate calculations. Round your answers to 4 decimal places
Please see the table below. Please be guided by the second column titled “Linkage” to understand the mathematics. The last row highlighted in yellow is your answer. Figures in parenthesis, if any, mean negative values. All financials are in $. Adjacent cells in blue contain the formula in excel I have used to get the final output.
Sharpe Ratio = Average of excess returns / Std deviation of excess returns = 1.94% / 15.54% = 0.1248
Beta of the fund = Correlation x Std dev of the fund / Std dev of the market = 0.97 x 16.08% / 21.51% = 0.7250
Treynor Ratio = Average excess return / Beta = 1.94% / 0.7250 = 0.0268