CUMIPMT

Returns the cumulative interest paid on a loan or investment, between two specified periods.
=CUMIPMT($B$1, $B$2, $B$3, 1, 12, 0)
CUMIPMT() Year 1 Result is -$2,294.98
=CUMIPMT($B$1, $B$2, $B$3, 13, 24, 0)
CUMIPMT() Year 2 Result is -$1,833.10
=CUMIPMT($B$1, $B$2, $B$3, 25, 36, 0)
CUMIPMT() Year 3 Result is -$1,347.59
=CUMIPMT($B$1, $B$2, $B$3, 37, 48, 0)
CUMIPMT() Year 4 Result is -$837.24
=CUMIPMT($B$1, $B$2, $B$3, 49, 60, 0)
CUMIPMT() Year 5 Result is -$300.79