Purpose
Return value
Syntax
=NPER(rate,pmt,pv,[fv],[type])- rate - The interest rate per period.
- pmt - The payment made each period.
- pv - The present value, or total value of all payments now.
- fv - [optional] The future value, or a cash balance you want after the last payment is made. Defaults to 0.
- type - [optional] When payments are due. 0 = end of period. 1 = beginning of period. Default is 0.
How to use
You can use the NPER function to get the number of payment periods for a loan (or an investment), given the amount, the interest rate, and a periodic payment amount.
Notes
- pmt normally includes principal and interest but not taxes, reserve payments, or fees.
- Be sure you supply rate consistent with periods. For example, if an annual interest rate is 12 percent, use 12%/12 for rate to get NPER to return periods in months.
NPER function examples
Calculate payment periods for loan
Related functions
FV Function
PV Function
The Excel PV function is a financial function that returns the present value of an investment. You can use the PV function to get the value in today's dollars of a series of future payments, assuming periodic, constant payments and a constant interest rate.
RATE Function
The Excel RATE function is a financial function that returns the interest rate per period of an annuity. You can use RATE to calculate the periodic interest rate, then multiply as required to derive the annual interest rate. The RATE function calculates by iteration.
NPER Function
PMT Function
PPMT Function
The Excel PPMT function can be used to calculate the principal portion of a given loan payment. For example, you can use PPMT to calculate the principal amount of a payment for the first period, the last period, or any period in between.
IPMT Function
The Excel IPMT function is a financial function used to calculate the interest payment for a given period of an investment or a loan, based on constant periodic payments and a constant interest rate. For example, you can use IPMT to get the interest amount of a loan payment for the...
CUMPRINC Function
The Excel CUMPRINC function is a financial function that returns the cumulative principal paid on a loan between a start period and an end period. You can use CUMPRINC to calculate and verify the total principal paid on a loan, or the principal paid between any two payment periods.
CUMIPMT Function
The Excel CUMIPMT function is a financial function that returns the cumulative interest paid on a loan between a start period and an end period. You can use CUMIPMT to determine the total interest paid on a loan, or the interest paid between any two payment periods.
