Please illustrate in excel templet.

1.) Constant Payment Mortgage [15 points] - Create an amortization schedule and answer the following questions for a S600,000 25-year fixed-rate, constant-payment mortgage that is partially-amortizing with a balloon payment of $100,000. The contract interest rate is 4.2% with monthly payments. Up-front fees on the loan equal 2.5% and there is no pre-payment penalty. a) b) c) What is the APR (annual percentage rate) for the loan? What is the EIR (effective interest rate) on the loan if prepaid at the end of year 12? What is the EIR if the loan is prepaid at the end of year 12 and there is a 2% prepayment penalty? (Hint: the prepayment penalty is 2% of the remaining balance) 1.) Constant Payment Mortgage [15 points] - Create an amortization schedule and answer the following questions for a S600,000 25-year fixed-rate, constant-payment mortgage that is partially-amortizing with a balloon payment of $100,000. The contract interest rate is 4.2% with monthly payments. Up-front fees on the loan equal 2.5% and there is no pre-payment penalty. a) b) c) What is the APR (annual percentage rate) for the loan? What is the EIR (effective interest rate) on the loan if prepaid at the end of year 12? What is the EIR if the loan is prepaid at the end of year 12 and there is a 2% prepayment penalty? (Hint: the prepayment penalty is 2% of the remaining balance)