20. 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 personal loans. The bank 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 is the optimal solution?

20. 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 personal loans. The bank 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 is the optimal solution?

Microeconomics: Principles & Policy

14th Edition

ISBN:9781337794992

Author:William J. Baumol, Alan S. Blinder, John L. Solow

Publisher:William J. Baumol, Alan S. Blinder, John L. Solow

Chapter9: The Financial Markets And The Economy: The Tail That Wags The Dog

Section: Chapter Questions

Problem 5TY

See similar textbooks

Similar questions

Why are banks more willing to lend to well-established firms?
Many retirement funds charge an administrative fee each year equal to 0.25% on managed assets. Suppose that Alexx and Spenser each invest 5,000 in the same stock this year. Alexx invests directly and earns 5 a year. Spenser uses a retirement fund and earns 4.75. After 30 years, how much more will Alexx have than Spenser?
What is the risk if a bank does not diversify its loans?
How much money do you have to put into a bank account that pays 10% interest compounded annually to have 10,000 in ten years?
What are some ways that someone looking for a loan might reassure a bank that is faced with imperfect information about whether the borrower will repay the loan?
Why should a financial investor care about diversification?
Why are bonds somewhat risky to buy, even though they make predetermined payments based on a fixed rate of interest?
Why are banks called financial intermediaries?
If you owned a small firm that had become somewhat established, but you needed a surge of financial capital to cant out a major expansion, would you prefer to raise the funds through borrowing or by issuing stock? Explain your choice.
What is the asset-liability time mismatch that all banks face?
How can a bank end up with negative net worth?
How is buying a house to live in a type of financial investment?