Social Work homework help

How do you set this up in excel?An investor wishes to invest some or all of his $12.5 million in a diversified portfolio through a commerciallender. The types of investments, the expected interest per year, and the maximum allowed percentage he willconsider include the following (the variable name is given in parentheses in the investment column):INVESTMENT EXPECTED INTEREST MAXIMUM ALLOWEDLow-income mortgage loans (L) 7.00% 20%Conventional mortgage loans (C) 6.25% 40%Government sponsored mortgage loans (G) 8.25% 25%Bond investments (B) 5.25% 12%Stock investments (S) 8.75% 15%Futures trading (F) 9.50% 10%The investor also wants at least 35% of his investments to be in non-mortgage instruments and no more than60% to be invested in high-yield instruments (i.e., expected interest > 8%) that carry high risk. State theprimal LP—the objective is to maximize total return subject to constraints.Sheet1 InvestmentL InvestmentInterestConstraints:Total fundsLow IncomeConvenitionalGovermentBondStockFuturesNon-MortageHigh-YeildMax Allowed CGBSCONVENITIONALOW INCOMEL…