ISPMT (interest payment)

<< Click to Display Table of Contents >>

ISPMT (interest payment)

Syntax:

ISPMT(Rate, Per, NPer, PV)

Description:

Returns the interest due in the specified period of an investment.

The function expects the following arguments:

Rate is the interest rate (per payment period).

Per is the payment period to be evaluated.

NPer is the total number of payment periods.

PV is the present value.

See also:

PPMT, PMT, IPMT