Marvin has found a home he likes and is excited to analyze an adjustable rate mortgage with the following terms: can you answer this on excel and show formulas please

$7/130-$year ARM @ $7\mathrm{.}50\%$

$$ After the introductory rate, the rate charged will be the index rate $+1\%$ risk premium subject to the two constraints:

$-2\%$ annual increase cap

$-12\mathrm{.}5\%$ maximum rate

$$ In month $85$ the index rate is $7\mathrm{.}5\%.$ In month $97$ the index rate is $5\%.$ In month $109$ the index rate is $8\%.$ In month $121$ and thereafter the index rate is $10\%.$

$$ The purchase price of the home is $$300,000.$ Marvin is putting down $10\%$ of the purchase price and borrowing the remainder. To help Marvin, create an amortization table associated with this loan on the third sheet $("$ARM$")$ of the Excel file on folio to complete this question. You will be graded on accurately calculating each payment, identifying correct rates, determining beginning balance, and ending bal$-$ance.

$($a$)$ What is the beginning loan balance?

$($b$)$ What is the ending loan balance?

$($c$)$ What payment and rate will be charged in month $85?$

$($d$)$ What payment and rate will be charged in month $97?$

$($e$)$ What payment and rate will be charged in month $109?$

$($f$)$ What payment and rate will be charged in month $121?$