NPER function
Summary
Returns the number of periods for an investment
Syntax
NPER(rate,pmt,pv,[fv],[type])
For a more complete description of the arguments in NPER and for more information about annuity functions, see PV.
The NPER function syntax has the following arguments:
• Rate Required. The interest rate per period.
• Pmt Required. 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 Required. The present value, or the lump-sum amount that a series of future payments is worth right now.
• Fv Optional. The future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (the future value of a loan, for example, is 0).
• Type Optional. The number 0 or 1 and indicates when payments are due.
Set type equal to | If payments are due
0 or omitted | At the end of the period
1 | At the beginning of the period
The NPER function syntax has the following arguments:
• Rate Required. The interest rate per period.
• Pmt Required. 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 Required. The present value, or the lump-sum amount that a series of future payments is worth right now.
• Fv Optional. The future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (the future value of a loan, for example, is 0).
• Type Optional. The number 0 or 1 and indicates when payments are due.
Set type equal to | If payments are due
0 or omitted | At the end of the period
1 | At the beginning of the period
Example
=NPER(A2/12, A3, A4, A5, 1)
=NPER(A2/12, A3, A4, A5)
=NPER(A2/12, A3, A4)
=NPER(A2/12, A3, A4, A5)
=NPER(A2/12, A3, A4)