ISPMT

Investment's interest paid

Description

Given a particular period, calculates an investment's interest paid. This is done based on a constant interest rate and periodic payments of constant amounts.

Function signature

ISPMT(rate: Number, period: Number, numberofperiods: Number, presentvalue: Number) => Number

Parameter

Description

Rate

The interest rate

Period

The time frame for which you want to view the interest payment.

Number of periods

The number of payments to be made.

Present value

The current value of the annuity.

Examples

Formula

Return value

ISPMT(0.1, 3, 12, 100)

-7.5

ISPMT(1, 3, 12, 100)

-75

ISPMT(1, 6, 12, 100)

-50

ISPMT(1, 3, 12, 200)

-150