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 fully-amortizing CAM loan with monthly payments. The contract interest rate on the loan is 3.25% and there are no points associated with the loan. a.) Assuming no upfront fees/points or prepayment penalty, what is the EIR if the mortgage is prepaid in full at the end of year 6? b.) Assuming 1 point in origination fees but no prepayment penalty, what is the EIR if the mortgage is prepaid in full at the end of year 6? c.) Assuming 1 point in origination fees and a 2% prepayment penalty, what is the EIR if the mortgage is prepaid in full at the end of year 6? Following is Template in Excel - ABC D E F G H 1 J K L M N O 2 la EIR 1b EIR 1c EIR 3 Loan Amount Balloon Payment Prepay Penalty Term (Years) Rate 4 5 Points Cash flows Cash flows Cash flows 6 7 Payment Interest Month Beg balance 1 Principal End balance 3 4 5 6 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 7 8 9 10 11 12 13 14 15 16 17 24 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 fully-amortizing CAM loan with monthly payments. The contract interest rate on the loan is 3.25% and there are no points associated with the loan. a.) Assuming no upfront fees/points or prepayment penalty, what is the EIR if the mortgage is prepaid in full at the end of year 6? b.) Assuming 1 point in origination fees but no prepayment penalty, what is the EIR if the mortgage is prepaid in full at the end of year 6? c.) Assuming 1 point in origination fees and a 2% prepayment penalty, what is the EIR if the mortgage is prepaid in full at the end of year 6? Following is Template in Excel - ABC D E F G H 1 J K L M N O 2 la EIR 1b EIR 1c EIR 3 Loan Amount Balloon Payment Prepay Penalty Term (Years) Rate 4 5 Points Cash flows Cash flows Cash flows 6 7 Payment Interest Month Beg balance 1 Principal End balance 3 4 5 6 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 7 8 9 10 11 12 13 14 15 16 17 24