All functions / Financial
IPMT
The interest part of one loan payment.
Syntax
=IPMT(rate, per, nper, pv, [fv], [type])
Arguments
rate: Interest rate per period, e.g. 5%/12 for monthly payments at 5% a year.per: Which payment: 1 for the first, up to nper.nper: Total number of payments.pv: The loan amount (present value).fv(optional): Balance left after the last payment (default 0).type(optional): 0 (default) = payments at the end of each period, 1 = at the start.
Example
=IPMT(6%/12, 1, 36, 20000) → -100.00 interest in month 1