A bank has $650,000 in assets to allocate among investments in bonds, home mortgages, car loans, and

Question:

A bank has $650,000 in assets to allocate among investments in bonds, home mortgages, car loans, and personal loans. Bonds are expected to produce a return of 10%, mortgages 8.5%, car loans 9.5%, and personal loans 12.5%. To make sure the portfolio is not too risky, the bank wants to restrict personal loans to no more than the 25% of the total portfolio. The bank also wants to ensure that more money is invested in mortgages than in personal loans. It also wants to invest more in bonds than personal loans.

a. Formulate an LP model for this problem with the objective of maximizing the expected return on the portfolio.

b. Implement your model in a spreadsheet and solve it.

c. What it the optimal solution?

Expected Return
The expected return is the profit or loss an investor anticipates on an investment that has known or anticipated rates of return (RoR). It is calculated by multiplying potential outcomes by the chances of them occurring and then totaling these... Portfolio
A portfolio is a grouping of financial assets such as stocks, bonds, commodities, currencies and cash equivalents, as well as their fund counterparts, including mutual, exchange-traded and closed funds. A portfolio can also consist of non-publicly...