If you can provide, steps using excel for future questions, it would be greatly appreciated.

Problem 4-03 (Algorithmic) The employer 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 af Laan/Investment Annual Rate af Retum (%) Automobile loans Furniture Inans 1 Other secured loans Signature loans Risk free securities 4 13 9 The credit union will have $1.4 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 signatureloars may not excond the funds invested in risk-free securities. How should the $1.4 million be allocated to each af the laan/'investment alternatives to maximize tatal annual return? Round your answers to the nearest callar. Automobile Loans Furniture Loans Other Secured Loans $ Signature Loans $ 140,000 Risk Free Loans What is the projected total annual return? Round your answer to the nearest dollar. Feedback Cho My Work Incorrect