Spread 8.0 Documentation
ISPMT
Support Options
Formula Reference > Built-In Functions > ISPMT

Glossary Item Box

ISPMT


Name

Interest payment

Description

Calculates the interest paid during a specific period of an investment.

Syntax

ISPMT(rate,per,nper,pv)

Remarks

The cash you pay out is represented by negative numbers and the cash you receive by positive numbers. Be consistent with the units for rate and nper.

This function has the following 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

Data Type

Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

ISPMT(B1,C4,C5,1)
ISPMT(R1C2,R4C3,R6C3,R7C3)

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.