The spreadsheet below has annual returns for three mutual funds—Capital Appreciation, High Return…

The spreadsheet below has annual returns for three mutual funds—Capital Appreciation, High Return and Total Return—for 10 years. A market return and a risk-free rate are provided, along with the beta for each of the three funds. a.   Calculate the average return and standard deviation for each of the three funds and for the market. b. Calculate the Sharpe and Treynor measures for each of the three funds and for the market based on your part a) answers and the betas provided. Which fund performed best according to each measure? c.   Calculate Jensen s alpha in the indicated cells by subtracting the required return as given by the CAPM equation from the average return. Alpha is the difference between what the fund actually returned and what it was expected to return based on the CAPM equation. d.   Determine the amount of diversification for each fund.

 

Looking for a Similar Assignment? Hire our Top Techical Tutors while you enjoy your free time! All papers are written from scratch and are 100% Original. Try us today! Active Discount Code FREE15