Explain using excel (show formulas please)

The following data apply to Problems 1 through 7: A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a long-term bond fund, and the third is a money market fund that provides a safe return of 8%. The characteristics of the risky funds are as follows: Expected Return Standard Deviation Stock fund (S) 20% 30% Bond fund (B) 12 15 The correlation between the fund returns is .10. 1. 2. 3. 4. What are the investment proportions in the minimum-variance portfolio of the two risky funds, and what are the expected value and standard deviation of its rate of return? Tabulate and draw the investment opportunity set of the two risky funds. Use investment proportions for the stock fund of 0% to 100% in increments of 20%. Draw a tangent from the risk-free rate to the opportunity set. What does your graph show for the expected return and standard deviation of the optimal portfolio? Solve numerically for the proportions of each asset and for the expected return and standard deviation of the optimal risky portfolio. 5. What is the Sharpe ratio of the best feasible CAL? 6. You require that your portfolio yield an expected return of 14%, and that it be efficient, that is, on the steepest feasible CAL. a. What is the standard deviation of your portfolio? b. What is the proportion invested in the money market fund and each of the two risky funds? 7. If you were to use only the two risky funds and still require an expected return of 14%, what would be the investment proportions of your portfolio? Compare its standard deviation to that of the optimized portfolio in Problem 9. What do you conclude? The following data apply to Problems 1 through 7: A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a long-term bond fund, and the third is a money market fund that provides a safe return of 8%. The characteristics of the risky funds are as follows: Expected Return Standard Deviation Stock fund (S) 20% 30% Bond fund (B) 12 15 The correlation between the fund returns is .10. 1. 2. 3. 4. What are the investment proportions in the minimum-variance portfolio of the two risky funds, and what are the expected value and standard deviation of its rate of return? Tabulate and draw the investment opportunity set of the two risky funds. Use investment proportions for the stock fund of 0% to 100% in increments of 20%. Draw a tangent from the risk-free rate to the opportunity set. What does your graph show for the expected return and standard deviation of the optimal portfolio? Solve numerically for the proportions of each asset and for the expected return and standard deviation of the optimal risky portfolio. 5. What is the Sharpe ratio of the best feasible CAL? 6. You require that your portfolio yield an expected return of 14%, and that it be efficient, that is, on the steepest feasible CAL. a. What is the standard deviation of your portfolio? b. What is the proportion invested in the money market fund and each of the two risky funds? 7. If you were to use only the two risky funds and still require an expected return of 14%, what would be the investment proportions of your portfolio? Compare its standard deviation to that of the optimized portfolio in Problem 9. What do you conclude