# ISPMT

### [data-colorid=be2469jz39]{color:#2f2f2f} html[data-color-mode=dark] [data-colorid=be2469jz39]{color:#d0d0d0}Description

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

### 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.

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

A
B
1
Data
Description
2
0.1
Annual interest rate
3
1
Period
4
3
Number of years in the investment
5
8000000
Amount of loan
6
7
ISPMT
-64814.81481

JavaScript errors detected