# How to use NPER function in Excel Nper function denotes the time period required to pay off the loans. This function will normally give the answer to the question like suppose I have Rs. 200000 today how much time will it take double the money at an interest rate of 6%. If we know the rate, Present value, and the Annuity Payment we can easily find the number of years.

The formula for calculating Nper function

Where,

Nper stands for the Number of years or the time period taken.

The rate stands for the interest rate at which is provided.

PMT stands for Payment Annuity.

PV stands for the Present Value.

FV stands for the Future Value.

Type stands for when the payment is made.

The arguments in the box brackets are optional.

Example of Nper function

Rs 2028.53 is paid monthly for a loan of Rs 200,000. The interest rate is 9% and the payment needs to be done yearly. How much time will it take to pay off the loan?

Solution:

Here, Rate = 9%

PMT= Rs 2028.53

PV = Rs 200,000

The other arguments are optional.