Navigation:  Formula Reference > Spreadsheet Formula Functions >

ISPMT

Previous pageReturn to chapter overviewNext page

 

This function calculates the interest paid during a specific period of an investment.

Syntax

ISPMT(rate,per,nper,pv)

Remarks

This function has these arguments:

Argument

Description

rate

Interest rate for the investment.

per

Number of the period for which to find the interest, between 1 and nper.

nper

Total number of payment periods for the investment.

pv

Present value of the investment.

Remarks

Be consistent with the units for rate and nper.

The cash you pay out is represented by negative numbers and the cash you receive by positive numbers.

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

ISPMT(B1,C4,C5,1)

ISPMT(R1C2,R4C3,R6C3,R7C3)

 

See Also

IPMT

PMT

PV