Must complete in excel.

1.) Create an amortization schedule and answer the following questions for a $750,000 30-year fixed-rate, constant-payment mortgage that is partially-amortizing with a balloon payment of $150,000. The contract interest rate is 3.50% with monthly payments. Up-front fees on the loan equal 2.0% and there is no pre-payment penalty.

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

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

3. c) What is the EIR if the loan is prepaid at the end of year 8 and there is a 3%

   prepayment penalty? (Hint: the prepayment penalty is 3% of the remaining balance)

Please show formulas used in excel, thank you!