Use template below to answer questions part a to part c. Please Answer Questions Part a) to Part c), Please Included All Formula You Entered Into Template. $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) Following is Template in Excel A D E F G H 1 J K L M N 0 P 1 2 1a EIR 1b EIR 1c EIR 3 4 5 Loan Amount Balloon Payment Prepay Penalty Term (Years) Rate Points 6 Cash flows Cash flows Cash flows 7 Payment Interest Principal End balance 8 9 Month Beg balance 1 2 3 4 10 11 12 13 14 5 6 7 8 15 9 16 17 18 19 20 21 22 23 24 10 11 12 13 14 15 16 17 Use template below to answer questions part a to part c. Please Answer Questions Part a) to Part c), Please Included All Formula You Entered Into Template. $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) Following is Template in Excel A D E F G H 1 J K L M N 0 P 1 2 1a EIR 1b EIR 1c EIR 3 4 5 Loan Amount Balloon Payment Prepay Penalty Term (Years) Rate Points 6 Cash flows Cash flows Cash flows 7 Payment Interest Principal End balance 8 9 Month Beg balance 1 2 3 4 10 11 12 13 14 5 6 7 8 15 9 16 17 18 19 20 21 22 23 24 10 11 12 13 14 15 16 17