3. The employee credit union at Boeing 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 invest in risk-free securities to stabilize income.

Types of Loans/Investment

Annual Rate of Return %

Auto loans

8

Furniture loans

10

Other secured loans

11

Signature loans

12

Risk-free securities

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

Signature loans may not exceed 10% of funds invested in all 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

a. How should the $2 million be allocated?

b. What is the projected annual return?

please include step by step input into excel

3. The employee credit union at Boeing 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 invest in risk-free securities to stabilize income. Types of Loans/Investment Annual Rate of Return % Auto loans Furniture loans Other secured loans Signature loans Risk-free securities 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 Signature loans may not exceed 10% of funds invested in all 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 a. How should the $2 million be allocated? b. What is the projected annual return