NPER stands for Number of Periods. The NPER function in Excel calculates how many payment periods are needed to pay off a loan or reach an investment goal, based on constant payments and a constant interest rate. In simple words: NPER tells you "how long will it take" to finish paying or saving.