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