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