Question

show in excel!

10 points Greta, an elderly investor, has a degree of risk aversion of A= 3 when applied to return on wealth over a one-year horizon. She is pondering two portfolios, the S&P 500 and a hedge fund, as well as a number of one-year strategies. (All rates are annual and continuously compounded.) The S&P 500 risk premium is estimated at 7.4% per year, with a SD of 22.4%. The hedge fund risk premium is estimated at 12.4% with a SD of 37.4%. The returns on both of these portfolios in any particular year are uncorrelated with its own returns in other years. They are also uncorrelated with the returns of the other portfolio in other years. The hedge fund claims the correlation coefficient between the annual returns on the S&P 500 and the hedge fund in the same year is zero, but Greta is not fully convinced by this claim. Skipped Calculate Greta's capital allocation using an annual correlation of 0.3. (Do not round your intermediate calculations. Round your answers to 2 decimal places.) eBook S&P Print Hedge Risk-free asset References

Answer 1

B16 X ✓ fc =((B5*B9)-(B6*B10)/((B5*B9)+(B6*B8)-(B5+B6)*B10) А 22.4% 37.4% 0.0% 0.0% 7.4% 12.4% 0.05 0.14 1 SD of S&P 500 2 SD of Hedge fund 3 Correlation between fund returns 4 Risk free rate of return (RF) 5 Expected risk premium on S&P 500 6 Expected risk premium on Hedge fund 7 8 Variance of S&P 500 9 Variance of Hedge fund 10 15 16 Portfolio invested in S&P 500 17 Portfolio invested in Hedge fund 18 19 Expected return on optimal risky portfolio (E(rp)] 20 21 SD of optimal risky portfolio (op) 22 23 Reward to volatility ratio of the feasible CAL 62.46% 37.54% 9.28% 19.82% 0.4680 25 S&P 26 Hedge 27 Risk-free asset 49.16% 29.55% 21.29%

*Please rate thumbs up