Navigation:  Formulas and functions > Functions from A to Z > ISPMT (interest payment)

Syntax:

ISPMT(Rate, Per, NPer, PV)

Description:

This returns the interest paid in the specified period for an investment with equal installments.

The function expects the following arguments:

Rate is the interest rate (per payment period)

Per is the payment period to be considered

NPer is the total number of payment periods

PV is the present value (initial amount)

See also:

PPMT, PMT, IPMT