Homework Help is Here – Start Your Trial Now!
Business
Operations Management
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 Risk-free securities 12 9 The credit union will have $2 million available for investment during the coming year. State laws and credit union policies impose the following restrictions on the composition of the loans and investments: • Risk-free securities may not exceed 30% of the total funds available for investment. Signature loans may not exceed 10% of the funds invested in all loans (automobile, furniture, other secured, and signature loans). Furniture loans plus other secured loans may not exceed the automobile loans. • Other secured loans plus signature loans may not exceed the funds invested in risk-free securities. How should the $2 million be allocated to each of the loan/investment alternatives to maximize total annual return? Type of Loan/Investment Fund Allocation Automobile loans $ Furniture loans $ Other secured loans $ Signature loans Risk-free securities $ $ What is the projected total annual return? Annual Return = $

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 Risk-free securities 12 9 The credit union will have $2 million available for investment during the coming year. State laws and credit union policies impose the following restrictions on the composition of the loans and investments: • Risk-free securities may not exceed 30% of the total funds available for investment. Signature loans may not exceed 10% of the funds invested in all loans (automobile, furniture, other secured, and signature loans). Furniture loans plus other secured loans may not exceed the automobile loans. • Other secured loans plus signature loans may not exceed the funds invested in risk-free securities. How should the $2 million be allocated to each of the loan/investment alternatives to maximize total annual return? Type of Loan/Investment Fund Allocation Automobile loans $ Furniture loans $ Other secured loans $ Signature loans Risk-free securities $ $ What is the projected total annual return? Annual Return = $

Practical Management Science
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 45P: A project does not necessarily have a unique IRR. (Refer to the previous problem for more...
See similar textbooks
icon
Related questions
Question

Use Excel to answer the question.

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 Risk-free securities 12 9 The credit union will have $2 million available for investment during the coming year. State laws and credit union policies impose the following restrictions on the composition of the loans and investments: • Risk-free securities may not exceed 30% of the total funds available for investment. Signature loans may not exceed 10% of the funds invested in all loans (automobile, furniture, other secured, and signature loans). Furniture loans plus other secured loans may not exceed the automobile loans. • Other secured loans plus signature loans may not exceed the funds invested in risk-free securities. How should the $2 million be allocated to each of the loan/investment alternatives to maximize total annual return? Type of Loan/Investment Fund Allocation Automobile loans $ Furniture loans $ Other secured loans $ Signature loans Risk-free securities $ $ What is the projected total annual return? Annual Return = $
Transcribed Image Text: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 Risk-free securities 12 9 The credit union will have $2 million available for investment during the coming year. State laws and credit union policies impose the following restrictions on the composition of the loans and investments: • Risk-free securities may not exceed 30% of the total funds available for investment. Signature loans may not exceed 10% of the funds invested in all loans (automobile, furniture, other secured, and signature loans). Furniture loans plus other secured loans may not exceed the automobile loans. • Other secured loans plus signature loans may not exceed the funds invested in risk-free securities. How should the $2 million be allocated to each of the loan/investment alternatives to maximize total annual return? Type of Loan/Investment Fund Allocation Automobile loans $ Furniture loans $ Other secured loans $ Signature loans Risk-free securities $ $ What is the projected total annual return? Annual Return = $
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
SEE MORE TEXTBOOKS