Question: How do i calculate this please show in excel and explain? For this question, round your answers to 3 decimal places and do not express

 How do i calculate this please show in excel and explain?For this question, round your answers to 3 decimal places and do

How do i calculate this please show in excel and explain?

For this question, round your answers to 3 decimal places and do not express your answers as percentages. 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 (The correlation between the fund returns is 0.10 ): c. What are the investment proportions in the optimal risky portfolio of the two risky funds, and what is the Sharpe ratio, expected value and standard deviation of its rate of return? The optimal risky portfolio weight for Stock fund is The optimal risky portfolio weight for Bond fund is The expected return for optimal risky portfolio is The standard deviation for optimal risky portfolio is The Sharpe ratio for optimal risky portfolio is

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!