CUMPRINC

Returns the cumulative payment on the principal of a loan or investment, between two specified periods.
=CUMPRINC($B$1, $B$2, $B$3, 1, 12, 0)
CUMPRINC() Year 1 Result is -$9,027.76
=CUMPRINC($B$1, $B$2, $B$3, 13, 24, 0)
CUMPRINC() Year 2 Result is -$9,489.64
=CUMPRINC($B$1, $B$2, $B$3, 25, 36, 0)
CUMPRINC() Year 3 Result is -$9,975.15
=CUMPRINC($B$1, $B$2, $B$3, 37, 48, 0)
CUMPRINC() Year 4 Result is -$10,485.50
=CUMPRINC($B$1, $B$2, $B$3, 49, 60, 0)
CUMPRINC() Year 5 Result is -$11,021.95