12) Amortization with Equal Payments Prepare an amortization schedule for a 20-year loan of $150,000. The interest rate is 3.65 percent per year, and the loan calls for equal annual payments. No mortgage points or deductions. Total 14 points for this problem a. Build the Amortization Table with Equal Annual Payments. (Do this in Excel template, Amortize over 20 years down to zero balance) (Total 5 points) (E Beginning Balance Totall (D) Principal Payment Year Interest Payment Payment Ending Balance Answer the Three questions (3 points each): b. In the 4 year, principal portion of what is paid is = c. By the 7 year what is the total interest is paid is = d. Total interest over life of the loan