Question: need some help with this excel problem?? An investor is considering three mutual funds. The first is a stock fund, the second is a longterm

need some help with this excel problem?? need some help with this excel problem?? An investor is considering three

An investor is considering three mutual funds. The first is a stock fund, the second is a longterm government and corporate bond fund and the third is a T-bill money market fund that yields a sure rate of 1.5%. The probability distributions of the risky funds are: The correlation between the two risky fund returns is 0.15. a. Using Excel graph the risky investment opportunity set. Use investment portions for the stock fund 0% to 100% in increments of 1%. b. What is the weight (+/1%) in the stock fund for the minimum variance portfolio? Label it on your graph in part a. c. What is the weight (+/1%) in the stock fund for the optimal risky portfolio? Label it on your graph in part a. d. What is the Sharpe Ratio for the best feasible Capital Allocation Line? e. Draw the capital allocation line associated with this optimal risky portfolio. f. Suppose now that your portfolio must yield an expected return of 9% and be efficient. Label it on your graph in part e. What is the investment proportions of your portfolio ie proportion invested in T-bill fund and each of the two risky funds

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!