Author: Oscar Cronquist Article last updated on April 17, 2018

The ISPMT calculates the interest paid during a specific period of an investment.

Formula in cell B3:


Excel Function Syntax

ISPMT(rate, per, nper, pv)


rate Required. The interest rate. 10% = 0.1
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.
pv Required. The present value. For a loan, pv is the loan amount.


Make sure you use the same unit across all arguments.

Negative numbers is cash you pay and positive numbers is cash you receive.