Excel Function : ISPMT

Download now!

Excel Function : ISPMT




Calculates the interest paid during a specific period of an investment

Microsoft Excel Reference Page


Syntax and Description of the ISPMT Excel Function

The syntax for the ISPMT function in Microsoft Excel is: =ISPMT(rate, per, nper, pv) rate - The interest rate per period. per - The period for which you want to calculate the interest. nper - The total number of payment periods in the loan. pv - The present value of the loan.

About ISPMT Excel Function

ISPMT is an Excel function that calculates the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.