Determine the projected total annual return

Reference no: EM1341414

Allocation of Funds: LP Problem

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 returns 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 has $2,000,000 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,000,000 be allocated to each of the loan/investment alternatives to maximize total return? What is the projected total annual return? Formulate the problem and solve it on a computer by using the Microsoft's Excel. You need to submit the formulation as well as the computer output.

Reference no: EM1341414

Questions Cloud

Find direct labor cost and their overtime direct labor cost : For next fiscal year, determine their annual regular time direct labor cost and their overtime direct labor cost based on a level capacity aggregate planning strategy.

Explain union and non-union workplace : Compare organizational environments of a union and non-union workplace as it impacts MORALE.

Find the total of northwoods direct labor costs : Northwoods direct labor costs - Explain what is the total of Northwoods direct labor costs

Why employees resist labor unions : Explain What are some reasons that employees still resist Unions even after the passage of the National Labor Relations Act

Determine the projected total annual return : How should the $2,000,000 be allocated to each of the loan/investment alternatives to maximize total return and What is the projected total annual return?

Develop a direct labor standards : Grefrath Corporation is developing direct labor standards and A particular product requires 0.62 direct labor-hours per unit

Evaluate standard rate per direct labor : Jeffs Corporation - evaluate standard rate per direct labor

Find the standard direct labor-hours per unit : The allowance for cleanup, machine downtime, and rejects is 0.13 direct labor-hours per unit - the standard direct labor-hours per unit

Find the labor rate variance for september : Mazzucco Corporation Labor Rate Variance - Find the Labor Rate Variance for September would be recorded

User Account

All Pages