In: Finance
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) | 19 | % | 34 | % | ||
Bond fund (B) | 10 | 18 | ||||
The correlation between the fund returns is 0.11.
Solve numerically for the proportions of each asset and for the expected return and standard deviation of the optimal risky portfolio. (Do not round intermediate calculations. Enter your answers as decimals rounded to 4 places.)
Portfolio invested in stock
Portfolio invested in bond
expected return
standard deviation
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.
Cell reference -