Use Template Below To Answer Question Below. Please Included All Formula You Entered Into Template in Excel. $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. 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? Template Used In Excel B D E F H J K 1 2 3 EIR 4 Loan Amount Balloon Payment Prepay Penalty Term (Years) Rate Points 5 6 Cash flows Month Beg balance Payment Interest 7 8 Principal End balance 9 10 2 3 4 5 11 12 13 6 14 7 15 8 16 17 18 19 12 20 Dora = 998 13 21 14 15 22 23 16 24 17 25 18 26 19 27 20 28 21