Question

A credit union wants to make investments in the following areas. The information presented in the...

A credit union wants to make investments in the following areas.

The information presented in the table below indicates the area of investment and the corresponding yearly return.

Type of investment and 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 a maximum of $2,500,000 available for investment during the coming year. In order to create a diverse portfolio the credit union has established the following investment restrictions:

∙ Risk free securities may not exceed 30% of the total funds invested, but must comprise at least 5% of the total funds invested.

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

Create a linear programming model that allocated $2,500,000 to each alternative to maximize annual return?

Solve the formulation of the above problem in Excel

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The employee credit union at State University is planning the allocation of funds for the coming...
The employee credit union at State University is planning the allocation of funds for the coming year. The credit union makes four types of loans to its members. In addition, the credit union invests in risk-free securities to stabilize income. The various revenue-producing investments together with annual rates of return are as follows: Type of Loan/Investment Annual Rate of Return (%) Automobile loans 8 Furniture loans 10 Other secured loans 11 Signature loans 12 Risk-free securities 9 The credit union...
The employee credit union at State University is planning the allocation of funds for the coming...
The employee credit union at State University is planning the allocation of funds for the coming year. The credit union makes four types of loans to its members. In addition, the credit union invests in risk-free securities to stabilize income. The various revenue-producing investments together with annual rates of return are as follows: Type of Loan/Investment Annual Rate of Return (%) Automobile loans 8 Furniture loans 10 Other secured loans 11 Signature loans 12 Risk-free securities 9 The credit union...
The employee credit union at State University is planning the allocation of funds for the coming...
The employee credit union at State University is planning the allocation of funds for the coming year. The credit union makes four types of loans to its members. In addition, the credit union invests in risk-free securities to stabilize income. The various revenue-producing investments together with annual rates of return are as follows: Type of Loan/Investment Annual Rate of Return (%) Automobile loans 9 Furniture loans 11 Other secured loans 12 Signature loans 13 Risk-free securities 10 The credit union...
The employee credit union at State University is planning the allocation of funds for the coming...
The employee credit union at State University is planning the allocation of funds for the coming year. The credit union makes four types of loans to its members. In addition, the credit union invests in risk-free securities to stabilize income. The various revenueproducing investments together with annual rates of return are as follows: Type of Loan/Investment Annual Rate of Return (%) Automobile loans 8 Furniture loans 10 Other secured loans 11 Signature loans 12 Risk-free securities 9 The credit union...
The employee credit union at State University is planning the allocation of funds for the coming...
The employee credit union at State University is planning the allocation of funds for the coming year. The credit union makes four types of loans to its members. In addition, the credit union invests in risk-free securities to stabilize income. The various revenue-producing investments together with annual rates of return are as follows: Type of Loan/Investment Annual Rate of Return (%) Automobile loans 8 Furniture loans 10 Other secured loans 11 Signature loans 12 Risk-free securities 9 The credit union...
The employee credit union at State University is planning the allocation of funds for the coming...
The employee credit union at State University is planning the allocation of funds for the coming year. The credit union makes four types of loans to its members. In addition, the credit union invests in risk-free securities to stabilize income. The various revenue-producing investments together with annual rates of return are as follows: Type of Loan/Investment Annual Rate of Return (%) Automobile loans 9 Furniture loans 11 Other secured loans 12 Signature loans 13 Risk-free securities 10 The credit union...
Problem 4-03 (Algorithmic) The employee credit union at State University is planning the allocation of funds...
Problem 4-03 (Algorithmic) The employee credit union at State University is planning the allocation of funds for the coming year. The credit union makes four types of loans to its members. In addition, the credit union invests in risk-free securities to stabilize income. The various revenueproducing investments together with annual rates of return are as follows: Type of Loan/Investment Annual Rate of Return (%) Automobile loans 8 Furniture loans 12 Other secured loans 14 Signature loans 13 Risk-free securities 9...
Problem 4-03 (Algorithmic) The employee credit union at State University is planning the allocation of funds...
Problem 4-03 (Algorithmic) The employee credit union at State University is planning the allocation of funds for the coming year. The credit union makes four types of loans to its members. In addition, the credit union invests in risk-free securities to stabilize income. The various revenueproducing investments together with annual rates of return are as follows: Type of Loan/Investment Annual Rate of Return (%) Automobile loans 8 Furniture loans 10 Other secured loans 11 Signature loans 12 Risk-free securities 9...
Multiple Choice 11. Prepayment risk is: A. the risk you will not receive the cash flows...
Multiple Choice 11. Prepayment risk is: A. the risk you will not receive the cash flows on a mortgage-backed security B. the risk that you will receive the cash flows sooner than expected and be forced to invest at a lower rate. C. the risk that you will receive the cash flows later than expected and not be able to invest at current, higher rates. 12. Based on the video Inside the Meltdown, it appeared that the main reason Lehman...
Question 1: Case study You are a financial adviser and the following information is an extract...
Question 1: Case study You are a financial adviser and the following information is an extract of data you gathered as part of fact finding during an initial client consultation for married couple Janet and Steven Blake. Janet works as a Teacher and Steven works as town planner at the local government. The have two children who are aged 12 and 14. Janet and Steven would like to know how much money they will receive after paying tax and expenses...