Use Template Below To Answer Question Below. Please Included All Formula You Entered Into Template in Excel. $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. Assuming upfront points of 3.0%, what is the loan's EIR if it is held until maturity? Template Used In Excel B D E F G H 1 K 1 2 3 EIR 4 Loan Amount Balloon Payment Prepay Penalty Term (Years) Rate Points 5 6 Cash flows Beg balance Payment Interest Principal End balance 7 8 O 1 2 3 4 6 7 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 8 9 10 11 12 13 14 15 16 17 18 19 20