ISPMT()

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.

Arguments

  • 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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial