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:

Expected Return Standard Deviation

Stock fund (S) 20% 30%

Bond fund (B) 12 15

The correlation between the fund returns is 0.10.

What are the investment proportions in the minimum-variance portfolio of the two risky funds? What is 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%.

Please show step by step the works in excel.