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 O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.