Functions
IPMT
Interest payment for a period
Try it
When to use it
When should I use IPMT instead of PMT?
Use IPMT for just the interest portion of a single payment; use PMT for the full periodic payment amount.
How does IPMT relate to PPMT?
For any period, IPMT (interest) plus PPMT (principal) equals the total PMT payment.
Use cases
Interest portion of a later mortgage payment
Split a payment into interest plus principal
Used in
finance · lending · real-estate
Syntax
IPMT(rate, per, nper, pv, [fv], [type])Examples
=IPMT(0.05/12,1,360,100000) // => -416.6666666666667
=IPMT(2,5,12,100) // => -199.96989312057806
=IPMT(0.1/12,1,36,8000,0,1) // => 0