ipmt
Interest portion of a periodic loan payment.
Syntax
Section titled “Syntax”v = ipmt(rate, per, nper, pv, fv, type)Description
Section titled “Description”For period per, returns the interest portion of the payment. Sum of ipmt + ppmt equals pmt for that period.
Example
Section titled “Example”ipmt(0.05/12, 1, 30*12, 200000)