How to solve the following using excel: 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.

amount allocated in dollars.$)$

Max

s$.$t$.$

Available investment funds

$H+P+A=5000000$

$A+H+P=5000000$

Minimum home loan amount

$H0\mathrm{.}40(H+P+A)$

$H0\mathrm{.}4(A+H+P)$

Maximum personal loan amount

$P0\mathrm{.}60A$

$H,P,A0$

$($b$)$ How much $($in dollars$)$ should be allocated to each type of loan?

home loans $$2000000$

personal loans

auto loans

$

$1875000$

What is the total annual return $($in dollars$)?$

$$443750$

What is the annual percentage return? $($Round your answer to two decimal places.$)$

$8\mathrm{.}88$

$($c$)$ If the interest rate on home loans increases to $9\%,$ would the amount allocated to each type of loan change? Explain.

Since $0\mathrm{.}09$ i: within the allowable range, the amount allocated to each type of loan obtained in part $($b$)$ will not $$ change.

$($d$)$ Suppose the total amount of new funds available is increased by $$50,000.$ What effect would this have on the total annual return? Explain. $($Round your answer to the nearest dollar.$)$

Increasing the amount of new funds available by $$50,000$ will increase the total annual return $($in dollars$)$ by $

$($e$)$

How much would the annual percentage return change? $($Round your answer to two decimal places.$)$