Question 1 Constant Payment Mortgage [30 points] - Create an amortization schedule and answer the following questions for a $600,000 30-year fixed-rate, constant-payment mortgage that is partially amortizing with a balloon payment of $100,000. The contract interest rate is 3.25% with monthly payments. Up-front fees on the loan equal 3.0% and there is no pre-payment penalty.

a.) What is the annual percentage rate (APR) for the loan?

b.) What is the effective interest rate (EIR) on the loan if prepaid at the end of year 6?

c.) What is the EIR if the loan is prepaid at the end of year 6 and there is a 2% prepayment penalty? (Hint: the prepayment penalty is 2% of the remaining balance)

NEED HELP FILLING OUT CHART UNTIL 360 MONTHS

2b 2c 2a EIR EIR EIR Loan Amount Balloon Payment Prepay Penalty Term (Years) Rate Points Cash flows Cash flows Cash flows Beg balance Payment Interest Principal End balance Month 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17