This article describes the formula syntax and usage of the ISPMT function in Microsoft Excel.


Calculates the interest paid (or received) for the specified period of a loan (or investment) with even principal payments.


ISPMT(rate, per, nper, pv)

The ISPMT function syntax has the following arguments:

RateRequired. The interest rate for the investment.
PerRequired. The period for which you want to find the interest, and must be between 1 and Nper.
NperRequired. The total number of payment periods for the investment.
PvRequired. The present value of the investment. For a loan, Pv is the loan amount.



ISPMT function example with even-principal loan amortization

Leave a Reply

Your email address will not be published. Required fields are marked *

Open chat
ভর্তি/সার্টিফিকেট তথ্য জানতে ক্লিক করুন
Scan the code
আস সালামু আলাইকুম। বিস্তারিত জানতে/ কল করতে ক্লিক করুন Open Chat বাটনে