NPER

NPER stands for Number of Periods and is defined as the total number of periods over which constant payments are made with a constant interest rate. The NPER function is a financial function in Excel that returns the number of periods that are required to pay off a loan or reach an investment goal through regular periodic payments and at a fixed interest rate.