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.