#$5)$ An investor wishes to invest some or all of his $$12\mathrm{.}5$ million in a diversified portfolio through a commercial lender. The types of investments,

the expected interest per year, and the maximum allowed percentage investment he will consider are shown on the following table. He wants at

least $35\%$ of his investments to be in nonmortgage instruments and no more than $60\%$ to be in high$-$yield $($and high$-$risk$)$ instruments $($i$.$e$.,$

expected interest $>8\%).$ How should his investment be diversified to make the most interest income?

Investment

Low$-$income mortgage loans

$6\mathrm{.}50\%$

Conventional mortgage loans

$6\mathrm{.}00\%$

Government sponsored

mortgage loans

Bond investments

$5\mathrm{.}75\%$

$15\%$

Stock investments

$8\mathrm{.}75\%$

$18\%$

Futures trading

$9\mathrm{.}25\%$

$10\%$

I need this solved with Excel's Solver Add$-$On