Question: all work shown in excel !!! A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a

all work shown in excel !!!
A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a long-term government and corporate bond fund, and the third is a T-bill money market fund that yields a rate of 8%. The probability distribution of the risky funds is as follows: 10 points Expected Return 17% 12 Standard Deviation 38% 17 Stock fund (S) Bond fund (B) eBook The correlation between the fund returns is 0.13. Print a-1. What are the investment proportions in the minimum-variance portfolio of the two risky funds. (Do not round intermediate calculations. Enter your answers as decimals rounded to 4 places.) References Portfolio invested in the stock Portfolio invested in the bond a-2. What is the expected value and standard deviation of its rate of return? (Do not round intermediate calculations. Enter your answers as decimals rounded to 4 places.) Rate of Return Expected return Standard deviation
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
