SOLVE IN EXCEL FORMAT. SHOW STEP-BY-STEP OF FORMULAS.

3-13. Portfolio Planning. An investment company currently has $10 million to invest. The goal is to maximize expected return earned over the next year. Their four investment possibilities are summarized below. In addition, the company has specified that at least 30% of the funds must be placed in common stock and treasury bonds, and no more than 40% in money market funds and municipal bonds. All of the $10 million currently on hand will be invested. Formulate an LP model that tells how much money to invest in each instrument and solve it. MAXIMUM ALLOWABLE INVESTMENT INVESTMENT POSSIBILITY EXPECTED RETURN (%) MILLIONS s) Treasury Bonds Common Stock 6 12 Money Market Municipal Bonds