Syntax. ISPMT(Rate,Per,Nper,Pv)

Definition. This function calculates the sum of interest that accrues for a certain part of the year with a given annual interest rate and simple yield in arrears. Other time periods are possible, but not common.

For reasons of compatibility, this function was included in Lotus 1-2-3.


  • Rate (required) The annual interest rate in arrears that is to be distributed equally among all the periods in the year

  • Per (required) Specifies the number of the period (starting with zero) from the end of which the interest is to be calculated until the end of the year

  • Nper (required) The total amount of periods with the year; determines the factor for the annual interest rate

  • Pv (required) The present value (cash value) ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.