# ISPMT

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



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)`

## Version Available

This function is available in product version 2.0 or later.

## See Also

[IPMT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionIPMT) \| [PMT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionPMT) \| [PV](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionPV) \| [Financial Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functsfinance)