Answer Questions Part A To Pait B $600,000 10-year 3/1 ARM loan that is fully-amortizing with monthly payments. The loan terms include a teaser rate of 2.0%. After the initial teaser rate period, the interest rate resets annually to the index rate plus a margin of 1.50%. The loan terms also include an annual interest rate cap of 2.0% and a lifetime interest rate cap of 6.0% over the initial teaser rate. Part A) PLEASE INCLUDED FORMULA YOU ENTERED INTO TEMPLATE IN EXCEL: Calculate the appropriate contract rate for years 1 10 Part B) 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 Template In Excel Year 1 2 3 4. 5 Index Contract 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 6 7 8 9 10 B D G H 1 2 3 4 Loan Amount Balloon Payment Prepay Penalty Term (Years) Rate Points 5 6 7 0 Beg balance Payment Interest Principal End balance 8 1 9 10 2 3 4 5 11 12 13 14 15 16 17 18 6 7 8 9 10 11 12 13 14 15 16 17 19 20 21 22 23 24 25 26 18 19 27 28 29 30 20 21 22 23 24 31