# Linear Program For an Investment Using Excel Solver

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 have $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

A complete, neat and step-by-step solution is provided in the attached Excel file.

##### 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.

##### 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.

##### Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

##### Probability Quiz

Some questions on probability