1、Using Excels Solver to solve question4 D12=B12*D11*D7; C13=B13*C11*C8; D13=D112*D8;B14= =SUM(B12:B13)C15=SUM(C12:D13);C16=SQRT(C15);C17=B12*C2+B13*C3C18=(C17-C4)/C16Step3: Work out the optimal risky portfolio set.Run solver, set the target cell as C18. In order to get the optimal risky portfolio, we
2、 ought to maximize the sharpe ratio, so the target should be set as “maximize”. The changeable variables should be set as “$B$12:$B$13” which denote the weight of each stock.Finally, add a constraint which demands that “B14=1” and run it. Then, we can obtain the optimal risky portfolioStep4: Work out the minimum-variance portfolio set.Using the similar method, we can get the minimum-variance portfolio.
