Functions
ISPMT
Interest paid for a period (straight line)
Try it
When to use it
When should I use ISPMT instead of IPMT?
Use ISPMT for loans that use straight-line (equal-principal) amortisation — each period's interest is calculated on the outstanding balance after the period's principal repayment, unlike IPMT which uses standard annuity amortisation.
Used in
Syntax
ISPMT(rate, per, nper, pv)Examples
=ISPMT(0.15,2,5,1000) // => -90