Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
How do you set this up in excel?
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...