Investment Possibility

Expected Return $(\%)$

Treasury

Bills

$6\mathrm{.}5$

CD

$5$

Stock

Fund

$13$

Municipal

Bonds

$8\mathrm{.}5$

An investor has $$70,000$ to divide among $4$ investments as given

in the table.The goal is to maximize expected return earned over the next

year. All of the $$70,000$ will be invested.The following guidelines must be followed:$1.$ No more than $20\%$ of the total investment should be in

Municipal Bonds$\mathrm{.}2.$ To be safe, the $ amount invested in CD and Treasury Bills

should be no less than in Municipal Bonds and Stock Fund$\mathrm{.}3.$ To diversify, each of the $4$ investments should be at least

$10\%$ of the total investment.$$In excel please$$