please use excel and show formulas please. thank you.

Adirondack Savings Bank (ASB) has $1 million in new funds that must be allocated to home loans, personal loans, and automobile loans. The annual rates of return for the three types of loans are 7% for home loans, 12% for personal loans, and 9% for automobile loans. The bank's planning committee has decided that at least 40% of the new funds must be allocated to home loans. In addition, the planning committee has specified that the amount allocated to personal loans cannot exceed 60% of the amount allocated to automobile loans. Objective: Determine the amount of funds ASB should allocate to each type of loan to maximize the total annual return for the new funds. Answer the following questions by playing with your excel and changing values. If the interest rate on home loans increases to 9%, would the amount allocated to each type of loan change? Explain. Suppose the total amount of new funds available is increased by $10,000. What effect would this have on the total annual return? Explain