Article updated on April 17, 2018

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

Formula in cell B3:

=ISPMT(0.1/12,1,4*12,10000)

Excel Function Syntax

ISPMT(rate, per, nper, pv)

Arguments

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.

Comments

Make sure you use the same unit across all arguments.

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