The following table presents the performance of stock and bond funds under various scenarios. Scenario Severe recession Mild recession Normal growth Boom Probability Rate of return of stock fund (%) 0.05 -40 0.20 -15 0.50 12 0.25 30 Rate of return of bond fund (%) -9 11 5 -2 Weights in Portfolio expected Portfolio standard stock fund return deviation p.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1.0 1 e. Use Excel to draw the investment opportunity set. (3 marks) f. Calculate the weight in stock fund, expected return and standard deviation of the minimum-variance portfolio. (6 marks) g. Given the T-bill rate is 2.5%. Calculate the weight in stock fund, expected return and standard deviation of the optimal risky portfolio. (6 marks) h. Calculate the Sharpe ratio for the optimal risky portfolio. (2 marks)