Arial 12 B B17 A 17 18 19 20 21 X Periodic rate of interest, 12 Periodic Tate of interest, B Number of Payments (Nper) Payment, PMT 22 Amortization table 23 24 Payment 25 number A General > $ +0 .00 .00 20 H C D E F G H 1.1975% 100.00 $2,419.79 *make sure payment is rounded to 2 decimal places use the ROUND function + Payment Interest portion Principal Principal portion balance 26 0 1 $408,405.00 27 1 28 2 $2,419.79 $2,419.79 29 30 31 345 $2,419.79 $2,419.79 $2,419.79 32 6 $2,419.79 33 7 34 8 $2,419.79 $431,440.29 $4,890.65 ($2,470.86) $410,875.86 $4,920.24 ($2,500.45) $413,376.31 $4,950.18 ($2,530.39) $415,906.70 $4,980.48 ($2,560.69) $418,467.39 $5,011.15 ($2,591.36) $421,058.75 $5,042.18 ($2,622.39) $423,681.14 $5,073.58 ($2,653.79) $426,334.93 $5,105.36 #### $0.00 35