Answer Questions Part A To Part B $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. Part A) Calculate Following in the Template Below In Excel AND PLEASE INCLUDED FORMULA YOU ENTERED INTO TEMPLATE IN EXCEL: Beg balance, Payment, Interest, Principal, End Balance, EIR, Cash flows Part B) 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? Template In Excel A B D E F G H 1 1 2 3 EIR 4 Loan Amount Balloon Payment Prepay Penalty $600,000 Term (Years) $480.000 Rate 0.00% Points 30 3.25% 0.00% Cash flows Month Beg balance Payment Interest Principal End balance 2. 3 4 5 6 7 8 9 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 10 11 12 13 14 15 16 17 18 19 20 21 22 23