What is IPMT?
Calculates the interest portion of a payment for a specific period of a loan.
Syntax
=IPMT(rate, per, nper, pv, [fv], [type])
Example
Formula: =IPMT(6%/12, 1, 360, -200000)
Result: $1,000.00
How It Works
Calculates first month's interest on a $200,000 mortgage at 6%. The first payment has the highest interest portion.