IPMT

Returns the interest payment, during a specific period of a loan or investment that is paid in,
constant periodic payments, with a constant interest rate.
=IPMT($B$1/12, 1, $B$2*12, $B$3)
IPMT() Month 1 Result is -$208.33
=IPMT($B$1/12, 2, $B$2*12, $B$3)
IPMT() Month 2 Result is -$205.27
=IPMT($B$1/12, 3, $B$2*12, $B$3)
IPMT() Month 3 Result is -$202.19
=IPMT($B$1/12, 4, $B$2*12, $B$3)
IPMT() Month 4 Result is -$199.10
=IPMT($B$1/12, 5, $B$2*12, $B$3)
IPMT() Month 5 Result is -$196.00
=IPMT($B$1/12, 6, $B$2*12, $B$3)
IPMT() Month 6 Result is -$192.89
=IPMT($B$1/12, 7, $B$2*12, $B$3)
IPMT() Month 7 Result is -$189.76
=IPMT($B$1/12, 8, $B$2*12, $B$3)
IPMT() Month 8 Result is -$186.62
=IPMT($B$1/12, 9, $B$2*12, $B$3)
IPMT() Month 9 Result is -$183.47
=IPMT($B$1/12, 10, $B$2*12, $B$3)
IPMT() Month 10 Result is -$180.30
=IPMT($B$1/12, 11, $B$2*12, $B$3)
IPMT() Month 11 Result is -$177.12
=IPMT($B$1/12, 12, $B$2*12, $B$3)
IPMT() Month 12 Result is -$173.92