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.