ISPMT

Returns the interest paid during a specific period of a loan or investment.
=ISPMT($B$1/12, 1, $B$2*12, $B$3)
ISPMT() Month 1 Result is -$204.86
=ISPMT($B$1/12, 2, $B$2*12, $B$3)
ISPMT() Month 2 Result is -$201.39
=ISPMT($B$1/12, 3, $B$2*12, $B$3)
ISPMT() Month 3 Result is -$197.92
=ISPMT($B$1/12, 4, $B$2*12, $B$3)
ISPMT() Month 4 Result is -$194.44
=ISPMT($B$1/12, 5, $B$2*12, $B$3)
ISPMT() Month 5 Result is -$190.97
=ISPMT($B$1/12, 6, $B$2*12, $B$3)
ISPMT() Month 6 Result is -$187.50
=ISPMT($B$1/12, 7, $B$2*12, $B$3)
ISPMT() Month 7 Result is -$184.03
=ISPMT($B$1/12, 8, $B$2*12, $B$3)
ISPMT() Month 8 Result is -$180.56
=ISPMT($B$1/12, 9, $B$2*12, $B$3)
ISPMT() Month 9 Result is -$177.08
=ISPMT($B$1/12, 10, $B$2*12, $B$3)
ISPMT() Month 10 Result is -$173.61
=ISPMT($B$1/12, 11, $B$2*12, $B$3)
ISPMT() Month 11 Result is -$170.14
=ISPMT($B$1/12, 12, $B$2*12, $B$3)
ISPMT() Month 12 Result is -$166.67