Please help and can you solve in excel with formulas

14 Formulate this portfolio selection problem by using LP and solve it by using Excel. An investor wishes to invest some or all of his $12.5 million in a diversified portfolio through a commer- cial lender. The types of investments, the expected interest per year, and the maximum allowed per- centage 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? EXPECTED INTEREST MAXIMUM ALLOWED INVESTMENT 20% 7.00% 6.25% 8.25% 40% 25% Low-income mortgage loans Conventional mortgage loans Government sponsored mortgage loans Bond investments Stock investments Futures trading 12% 5.75% 8.75% 9.50% 15% 10%