ISPMT

Syntax:

ISPMT ( rate , per, nper , pv )

Description: Computes the interest paid during a specific period of an investment.

Arguments:

Name

Type

Description

rate

number

The interest rate for the investment.

per

number

The period for which the interest is to be found, and shall be in the range 1–nper.

nper

number

The total number of payment periods for the investment.

pv

number

The present value the investment.

Arguments representing cash paid by investor shall be expressed as negative numbers; arguments representing cash received by the investor shall be expressed as positive numbers.

Return Type and Value: number – The interest paid during a specific period of an investment.

example: