Question $1(60$ points$)$

A bank has $$650,000$ to invest among bonds, home mortgages, car loans and personal loans. Bonds are expected

to produce a return of $10\%,$ mortgages $8\mathrm{.}5\%,$ car loans $9\mathrm{.}5\%,$ and personal loans $12\mathrm{.}5\%.$ To make sure the

portfolio is not too risky, the bank wants to restrict personal loans to no more than $25\%$ of the total portfolio.

The bank also wants to invest more in bonds than personal loans.

Formulate an LP for this problem with the objective of maximizing the expected return on the portfolio.

$($Note: Linear!$)$

Solve this LP by Excel Solver. Explain to me step by step how I should go into excel and what variables and inputs I need to put in to solve this using excel