How to use the NPER function in Microsoft Excel

The NPER function is under the Excel Financial functions used to compute the number of periods or time needed to pay off a certain loan or to reach your investment goal through regular periodic payments and at a fixed interest rate.