Please answer this question in Excel:

1. You have just signed up for a retirement plan and can invest your money in a growth fund (G) or a value fund (V). You can also invest in a risk free asset that earns 1%. You believe there are three possible scenarios: ( 2.25 points) State 1( Prob =.5):,rg=12%,rV=8% State 2( Prob =.25):rG=8%,rV=4% State 3( Prob =.25):rG=6%,rv=3% a) Compute the expected return and standard deviation of the growth and value fund. Also compute the covariance and correlation between the value and growth funds. (0.5 points) b) Compute the market portfolio (i.e., the portfolio of the two risky assets that yields the highest Sharpe Ratio). ( 0.25 points) c) What is the expected return, standard deviation, and Sharpe Ratio of the market portfolio? ( 0.25 points) d) What is the beta of the growth fund with respect to the market? What is the beta of the value fund with respect to the market? What is the beta of the market with respect to the market? ( 0.25 points) e) What are the predicted returns of the growth fund, the value fund, and the market according to the CML? ( 0.25 points) f) What are the predicted returns of the growth fund, the value fund, and the market according to the SML? ( 0.25 points) g) Are the predicted returns according to the CML and SML the same for the value fund? The growth funds? The market? For each, explain why they are the same or why they differ? (0.5 points)