Create the amortization spreadsheet and answer the following questions for a $$450,00015-$year fixed$-$rate, constant$-$payment mortgage loan that is partially$-$amortizing with a balloon payment of $$50,000.$ The contract interest rate is $6\%$ with monthly payments. Up$-$front discount points on the loan are $2\%,$ and there is a $1\%$ pre$-$payment penalty.

a$)$ What is the APR $($annual percentage rate$)$ on the loan $-$ assuming that there is no early prepayment on the mortgage?

b$)$ What is the EAR $($effective annual rate$)$ on the loan if it prepaid at the end of year $7?$

c$)$ What is the monthly mortgage payment during month $160?$

d$)$ How much cumulative interest is paid during the $14$th year of the mortgage?

Please use excel and show formuals

Thanks