use excel i got payment as $$3,625$

$1.$ Create the amortization spreadsheet and answer the following questions for a $$450,000$

$15-$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?