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 | –22.40 | % | –42.50 | % | 3 | % |
| 2012 | 25.10 | 21.30 | 5 | |||
| 2013 | 14.20 | 14.80 | 2 | |||
| 2014 | 6.60 | 8.80 | 6 | |||
| 2015 | –2.28 | –5.20 | 3 | |||
Calculate Jensen’s alpha for the fund, as well as its information ratio. (Do not round intermediate calculations. Enter the alpha as a percent rounded to 2 decimal places. Round the ratio to 4 decimal places.)
| Year | Fund | Market | Risk-Free | Excess Return | ||||
| 2011 | -22.40 | % | -42.5 | % | 3 | % | 20.10 | |
| 2012 | 25.10 | 21.3 | 5 | 3.80 | ||||
| 2013 | 14.20 | 14.8 | 2 | -0.60 | ||||
| 2014 | 6.60 | 8.8 | 6 | -2.20 | ||||
| 2015 | -2.28 | -5.2 | 3 | 2.92 | ||||
| Mean | 4.244 | -0.56 | 3.8 | 4.804 | ||||
| =Item - Mean | -26.64 | -41.94 | 15.30 | |||||
| 20.86 | 21.86 | -1.00 | ||||||
| 9.96 | 15.36 | -5.40 | ||||||
| 2.36 | 9.36 | -7.00 | ||||||
| -6.52 | -4.64 | -1.88 | ||||||
| Squared | 709.902736 | 1758.963600 | 233.967616 | |||||
| 434.972736 | 477.859600 | 1.008016 | ||||||
| 99.121936 | 235.929600 | 29.203216 | ||||||
| 5.550736 | 87.609600 | 49.056016 | ||||||
| 42.562576 | 21.529600 | 3.549456 | ||||||
| Mean of squared | 258.422144 | 516.378400 | 63.356864 | |||||
| Sq. Root | 16.075514 | =Std. Dev. | 22.723961 | =Std. Dev. | 7.959703 | =Std. Dev. | ||
| β = Correlation Coefficient Between Market and Stock × Standard Deviation of Stock Returns/Standard Deviation of Market Returns | ||||||||
| = | 0.97*16.075514/22.723961 | = | 0.686203 | |||||
| Jensen's alpha = Portfolio return - [Risk Free Rate + Portfolio Beta * (Market Return - Risk Free Rate)]. | ||||||||
| =4.244-(3.8+0.686203*(-0.56-3.8)) | = | 3.4358 | ||||||
| Information ratio Formula = (Rp – Rb) / Tracking error | ||||||||
| where, | ||||||||
| Rp = Rate of return of the investment portfolio | ||||||||
| Rb = Benchmark rate of return | ||||||||
| Tracking error = Standard deviation of the excess return with respect to the benchmark rate of return | ||||||||
| Tracking Error= | 7.959703 | |||||||
| Inf. Ratio= | 0.6035 |