Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.
Sintaxis
NPER(rate, pmt, pv, [fv], [type])Argumentos
rateobligatorio
The interest rate per period.
pmtobligatorio
The payment made each period; it cannot change over the life of the annuity.
pvobligatorio
The present value, or the lump-sum amount that a series of future payments is worth now.
fvopcional
The future value or a cash balance you want to attain after the last payment is made.
typeopcional
The number 0 or 1 and indicates when payments are due (0 = end of period, 1 = beginning of period).
The NPER function calculates the total number of payment periods required to reach a specific financial goal or pay off a loan. It assumes that payments are constant and the interest rate remains unchanged throughout the duration of the investment.
=NPER(0.05/12, -200, 10000)→54.55Calculates the number of months to pay off a $10,000 loan with a 5% annual interest rate and $200 monthly payments.
Identify your financial variables
Gather the interest rate, periodic payment amount, and the present value of the loan or investment.
Enter the NPER formula
Input the values into the NPER function, ensuring that cash outflows are represented as negative numbers.
This usually happens if the payment amount is too low to cover the interest, making it impossible to reach the future value.