Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A bonk has $649,000 in assets to allocate among investments in bonds, home mortgages, car loans, and personal loans. Bonds are expected to produce a

image text in transcribed
A bonk has $649,000 in assets to allocate among investments in bonds, home mortgages, car loans, and personal loans. Bonds are expected to produce a return of 11%, mortgages 9.5%, car loans 10.5%, and personal loans 13.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 at least as much money is invested in mortgages as is invested in personal loans. The bank also wants to invest at least as much in bonds as they do in personal loans. (Let x1,x2,x3, and x4 be the amount (in dollars) invested in bonds, mortgages, car loans, and personal loans, respectively.) (a) Formulate an LP model for this problem with the objective of maximizing the expected return (in dollars) on the portfolio. MAX: Subject to: total amount spent amount for personal loans mortgages and personal toans bonds and personal loans x1,x2,x3,x40 (b) Implement your model in a spreadsheet and solve it. What is the optimat solution? (x1,x2,x3,x4)=(

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Information Technology Control And Audit

Authors: Angel R. Otero

5th Edition

1498752284, 9781498752282

More Books

Students also viewed these Accounting questions

Question

3. Identify some ways in which scientific rigor may be increased.

Answered: 1 week ago