NPER
Syntax:
NPER ( rate , pmt , pv [ , [ fv ] [ , [ type ] ] ] )
Description: Computes the number of periods for an investment based on periodic, constant payments and a constant interest rate.
Arguments:
Name |
Type |
Description |
||||||
|---|---|---|---|---|---|---|---|---|
rate |
number |
The interest rate per period. |
||||||
pmt |
number |
The payment made each period; it cannot change over the life of the annuity. Typically, pmt contains principal and interest but no other fees or taxes. |
||||||
pv |
number |
The present value, or the lump-sum amount that a series of future payments is worth right now. |
||||||
fv |
number |
The future value, or a cash balance to be attained after the last payment is made. If fv is omitted, it is assumed to be 0 (i.e., the future value of a loan, for example, is 0). |
||||||
type |
number |
The timing of the payment, truncated to integer, as follows:
|
Return Type and Value: number – The number of periods for an investment based on periodic, constant payments and a constant interest rate.
However, if type is any number other than 0 or 1, #NUM! is returned.