NPER


Definition of NPER:

This formula calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.

Sample Usage

NPER(2,500,40000)

NPER(A2,B2,C2,D2,1)

Syntax

NPER(rate, payment_amount, present_value, [future_value, end_or_beginning])

  • rate - The interest rate.
  • payment_amount - The amount of each payment made.
  • present_value - The current value of the annuity.
  • future_value - [ OPTIONAL ] - The future value remaining after the final payment has been made.
  • end_or_beginning - [ OPTIONAL - 0 by default ] - Whether payments are due at the end (0) or beginning (1) of each period.

Notes

  • Ensure that consistent units are used for rate and payment_amount. For example, a car loan for 36 months may be paid monthly, in which case the annual percentage rate should be divided by 12 and the payment_amount is the amount of each monthly payment. On the other hand, a different type of loan of the same length and principal might be paid quarterly, in which case the annual percentage rate should be divided by 4 and the amount paid each period would be adjusted accordingly..

See Also

PV: Calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate.

PPMT: Calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate.

PMT: Calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate. 

IPMT: Calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate. 

FVSCHEDULE: Calculates the future value of some principal based on a specified series of potentially varying interest rates.

FV: Calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate.

Step 1. To use the NPER Formula, start with the Excellentable you would like to edit.

NPER-1.png

Step 2. Then type the NPER formula into the cell you have chosen to display the outcome:

NPER-2.png

Step 3. Fill in the 5 values- In this example I have chosen 5 values that are the same. 

NPER-3.png

By adding the values you would like to calculate, Excellentable generates the outcome: