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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!