Nper Function

Nper Function is used for calculating number of periods for an investment based on periodic, constant payments and constant interest rate.

Syntax for Nper() Function:

FV(rate;Pmt;PV;FvType)

rate – Interest Rate

PV – Present Value

Pmt – Payment

FV – Future Value

Type – 1 if payment is at the beginning of the period, 0 if payment is at the end of the period

You need to provide first 3 variables in order FV() Function to work. Last 2 variables are optional.

Example1:

Tifanny asks Nelson for a loan of 25,000$. She can pay Nelson back 1250$ a month. Considering monthly interest rate is 1.25%, how many months will it take Tiffany to pay the loan back to Nelson.

Our formulation with Nper() Function for this deal is:

Nper(1.25% ; -1.250 ; 25.000 ; 0 ; 0) = 23.15

So with 1,250$ monthly payments, it will take 23.15 months for Tiffany to pay 25,000$ loan back to Nelson with 1.25% monthly interest rate.