Type the linear program, optimal solution, and objective function value in a word document. Submit your excel file. An investor wishes to invest some or all of his $12.5 million in a diversified portfolio through a commercial lender. The types of investments, the expected interest per year, and the maximum allowed percentage 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? Investment Expected Return Maximum Allowed Low-income mortgage loans 6.50% 20% Conventional mortgage loans 6.00% 30% Government sponsored mortgage loans 8.25% 25% Bond investments 5.75% 15% Stock investments 8.75% 18% Futures trading 9.25% 10%
Type the linear program, optimal solution, and objective function value in a word document.
Submit your excel file.
An investor wishes to invest some or all of his $12.5 million in a diversified portfolio through a commercial lender. The types of investments, the expected interest per year, and the maximum allowed percentage 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?
|
Investment |
Expected Return |
Maximum Allowed |
|
Low-income mortgage loans
|
6.50% |
20% |
|
Conventional mortgage loans
|
6.00% |
30% |
|
Government sponsored mortgage loans |
8.25% |
25% |
|
Bond investments
|
5.75% |
15% |
|
Stock investments
|
8.75% |
18% |
|
Futures trading
|
9.25% |
10% |
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 6 images
Can you show where the values go in an excel photo?
by Bartleby Expert
