Syntax. NPER(Rate,Pmt,Pv,Fv,Type)

Definition. The function NPER() calculates the duration of a compound interest rate process, annuity calculation, or repayment calculation. It is based on possible regular payments of the same amount and/or one-time payments at the start or end of the time period, according to the finance mathematical benefit principle

Payment of the creditor + Payment of the debtor = 0


  • Rate (required) The (constant) period interest rate as interest rate in arrears.

  • Pmt (required/optional, see Note) The amount of the regular payments. This can be interpreted as annuity.

  • Pv (required/optional, see Note) The start value of one payment direction. For disbursement plans, this is the account balance at the beginning of these ...

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

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