NPER()

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

Arguments

  • 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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial