Functions
CUMIPMT
Cumulative interest paid
Try it
When to use it
When should I use CUMIPMT instead of IPMT?
Use CUMIPMT when you need the total interest paid over a range of periods — for example, the interest cost in year one of a mortgage — rather than a single period's interest.
Used in
finance · lending · real-estate
Syntax
CUMIPMT(rate, nper, pv, start, end, type)Examples
=CUMIPMT(0.12,12,100,1,5,0) // => -54.39423242396349
=CUMIPMT(0.12,12,100,1,12,0) // => -93.72416911279494