Functions
CUMPRINC
Cumulative principal paid
Try it
When to use it
When should I use CUMPRINC instead of PPMT?
Use CUMPRINC when you want the total principal repaid over multiple periods — for example, how much principal you pay down in the first year of a loan.
Used in
finance · lending · real-estate
Syntax
CUMPRINC(rate, nper, pv, start, end, type)Examples
=CUMPRINC(0.12,12,100,1,5,0) // => -26.32417137303437