# ISPMT

## Content

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

## Syntax

`ISPMT(rate, per, nper, pv)`

## Arguments

This function has these arguments:

| Argument | Description |
| -------- | ----------- |
| *rate* | [Required] Interest rate for the investment. |
| *per* | [Required] Number of the period for which to find the interest, between 1 and *nper*. |
| *nper* | [Required] Total number of payment periods for the investment. |
| *pv* | [Required] 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.

## Examples

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