LOCATING THE MINIMUM VARIANCE PORTFOLIO

Fill in the highlighted cells and answer the questions. we use sample data

Q$4.$ Use excel function SOLVER to find the Global Minimum Variance Portfolio $($GMVP$)$

Percentage in $K$

Percentage in XOM you can start with any value here. Short position is not allowed.

$10$

$11$

$12$

$13$

$14$

$15$

$16$

$18$

$19$

$20$

$\frac{21}{22}$

$\backslash$table$[[$Average$,E(r_K)$ and $E(r_{\text{X}\text{O}\text{M}}),831\%,$XOM$],[$Variance$,$ Var$(r_K)$ and Var$(r_{\text{X}\text{O}\text{M}}),0\mathrm{.}0139,0\mathrm{.}0281],[$Sigma$,{}_K$ and ${}_{\text{X}\text{O}\text{M}},1180\%,16\mathrm{.}77\%$