O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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) ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required