Linear program investment
Not what you're looking for?
Please solve the following problem in Excel 97-2003 using solver. Please show detailed breakdown of the problem to answer the following questions.
A credit union wants to make investments in the following:
Type of Investment Annual Rate of Return (%)
_______________________________________________
Vehicle Loans 7
Consumer Loans 9
Other secured loans 10
Signature Loans 11
Risk-Free securities 8
The firm will haved $2,500,000 available for investment during the coming year. The following restrictions apply:
-Risk free securities may not exceed 30% of the total funds, but must comprise at least 5% of the total.
-Signature loans may not exceed 12% of the funds invested in all loans (vehicle, consumer, other secured loans and signature loans)
-Consumer loans plus other secured loans may not exceed the vehicle loans
-Other secured loans plus signature loans may not exceed the funds invested in risk free securities.
How should the $2,500,000 be allocated to each alternative to maximize annual return? What is the annual return?
Purchase this Solution
Solution Summary
Linear program investment is exemplified.
Purchase this Solution
Free BrainMass Quizzes
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.
Know Your Linear Equations
Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.
Graphs and Functions
This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.