IPMT

Name

IPMT —
IPMT(rate,per,nper,pv,fv,type)

Description

Calculates the amount of a payment of an annuity going towards interest.

Formula for IPMT is:

IPMT(PER) = PMT - PRINCIPAL(PER-1) * INTEREST_RATE

where:

PMT = Payment received on annuity

PRINCIPA(per-1) = amount of the remaining principal from last period

See also

PPMT , PV , FV