Question: Can you please answer this queation in excel with a detailed explanation? 4. A pension fund manager is considering three mutual funds. The first is
4. 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: Stock fund (S) Bond fund (B) Expected Return 20% 12 Standard deviation 30% 15 The correlation between the fund returns is 0.10. 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? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Standard deviation % b. What is the proportion invested in the money market fund and each of the two risky funds? (Do not round intermediate calculations. Round your answers to 2 decimal places.) Money market fund Stocks Bonds Proportion Invested % % %
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
