Create an Excel Model for this Example. (please give step by step excel instructions) Use Solver to determine solution (please give step by step excel instructions)

Types of LoansInvestment Annual Rate of Return 81 Auto Loans Furniture Loans 10 11 Other Secured Loans 12 Signature Loans 9 Risk-Free Securities The credit union will have S2 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 total funds invested. 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? Amount allocated to Auto Loans Amount allocated to Furniture Loans Amount allocated to Other Secured Loans Amount allocated to Signature Loans Amount allocated to Risk-free Securities What is the projected annual return dollars