Calculates the interest paid during a specific period of an investment.
Syntax
ISPMT(rate, per, nper, pv)Argument
rateobligatoriskt
The interest rate for the investment.
perobligatoriskt
The specific period for which you want to calculate the interest (must be between 1 and nper).
nperobligatoriskt
The total number of payment periods for the investment.
pvobligatoriskt
The present value of the investment.
The ISPMT function calculates the interest portion of a loan or investment payment for a specific period. It assumes a linear amortization schedule where the principal is paid off in equal installments.
=ISPMT(0.05, 1, 3, 10000)→-500Calculates the interest for the first period of a 3-year loan of 10,000 at 5% interest.
Identify loan parameters
Gather the interest rate, total number of periods, and the present value of the loan.
Apply the ISPMT function
Enter the formula into a cell, specifying the period you wish to analyze.
ISPMT assumes a linear amortization schedule, whereas IPMT assumes a constant payment amount (annuity) where interest decreases over time.