IPMT practice

IPMT returns the interest part of one loan payment. Below are the 1 financial modeling exercise on Modeldrill that use it, each checked instantly in your browser.

Syntax

IPMT(rate, period, nper, pv, [fv], [type])

What people get wrong

The result is negative for a positive loan amount, because it is cash going out; IPMT plus PPMT equals PMT.

financial modeling exercise that use IPMT

• Split payments with IPMT and PPMTLevel 3Pro

Often used together with: PPMT