# ISPMT

### Description

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

### Sample Usage

### Syntax

ISPMT(rate, per, nper, pv)

The ISPMT function syntax has the following arguments:

Rate Required. The interest rate for the investment.

Per Required. The period for which you want to find the interest, and must be between 1 and nper.

Nper Required. The total number of payment periods for the investment.

Pv Required. The present value of the investment. For a loan, pv is the loan amount.

### Remarks

Make sure that you are consistent about the units you use for specifying rate and nper. If you make monthly payments on a four-year loan at an annual interest rate of 12 percent, use 12%/12 for rate and 4*12 for nper. If you make annual payments on the same loan, use 12% for rate and 4 for nper.

For all the arguments, the cash you pay out, such as deposits to savings or other withdrawals, is represented by negative numbers; the cash you receive, such as dividend checks and other deposits, is represented by positive numbers.

For additional information about financial functions, see the PV function.

### In order to use the ISPMT formula, start with your edited Excellentable

### Then type in the ISPMT formula in the area you would like to display the outcome:

### By adding the values you would like to calculate the ISPMT formula for, Excellentable will generate the outcome: