In excel sheet suppose $2$ stocks A and B$,$ with $20\%/10\%$ risk and $30\%$ return $/15\%$ volatility $($ all the work should be done in excel $)$

$1-$calculate the return and risk of $10$ combinations of these $2$ stocks in excel: $0\%-100\%,10\%-90\%...$

$2-$ calculate the sharp ratio of each portfolio in excel

$($suppose risk free rate is $6\%)$

$3)$ use the goal seek formula in excel to find the weights that give us the portfolio with the highest sharp ratio correlation $=0\mathrm{.}4$ in excel

$4)$ draw on a risk$/$return graph the $10$ portfolio combinations in excel