Risk Free Rate is $5\%$ and other numbers needed are in the table, Solve these $5$ problems through excel:

$1.$ Choose $10$ levels of expected returns. For each return level, use Solver to find the portfolio of the three risky assets that has the lowest portfolio risk. The $10$ levels are:

$0\mathrm{.}5\%$

$2\mathrm{.}0\%$

$4\mathrm{.}5\%$

$6\mathrm{.}0\%$

$8\mathrm{.}0\%$

$10\mathrm{.}0\%$

$12\mathrm{.}0\%$

$15\mathrm{.}0\%$

$18\mathrm{.}0\%$

$20\mathrm{.}0\%$

$2.$ Plot the efficient frontier using the $10$ portfolios found above.

$3.$ Find the optimal risky portfolio.

$4.$ Suppose that your client wishes to achieve an expected return of $10\%$ on the complete portfolio. How should you allocate her investment money across the assets to achieve this objective?

$5.$ Suppose that your client is willing to take on a risk level of $6\%$ for the complete portfolio. How should you allocate her investment money across the assets to achieve this objective?

Risk and return characteristics of three risky assets:

Here are the formula for computing $3-$asset portfolio's expected return and risk:

$E(r_P)=w_{1}E(r_1)+w_{2}E(r_2)+w_{3}E(r_3)$

Var$(r_P)=(w_1{}_1{)}^2+(w_2{}_2{)}^2+(w_3{}_3{)}^2+2w_1{w}_2{}_1{}_2{}_{1,2}+2w_1{w}_3{}_1{}_3{}_{1,3}+2w_2{w}_3{}_2{}_3{}_{2,3}$