# Nper

In this tutorial, you will learn: What does nper mean in Excel? How to use the NPER function to calculate the number of periods required to pay off a loan or the number of investments needed to earn the target amount? And more!

## nper

It seems you are using an older browser. This site is optimized for modern browsers. Please upgrade to a modern browser for the best experience.DataThis page in:EnglishEspañolFrançaisالعربية中文Bank nonperforming loans to total gross loans (%)CloseBrowse byCountryorIndicator

You can also use the NPER function in VBA. Type:application.worksheetfunction.nper(rate,pmt,pv,fv,type)For the function arguments (rate, etc.), you can either enter them directly into the function or define variables to use instead.

Arguments:•rate: interest rate per period•nper: number of periods•pmt: added payment to be made per period; enter as a negative number•pv (optional): present value of investment; enter as a negative number•type (optional): type of payment scheme. 0 means payments are due at the end of the period; 1 means payments are due at the beginning of the period.

Arguments:•rate: interest rate per period•nper: number of periods•pv: present value of the investment•fv (optional): future value of the investment or cash value remaining after final payment. If omitted, fv is assumed to be 0.•type (optional): type of payment scheme. 0 (default) means payments are due at the end of the period; 1 means payments are due at the beginning of the period.

Arguments:•rate: interest rate per period•nper: number of periods•pmt: payment to be made per period•fv (optional): future value of the investment or cash value remaining after final payment. If omitted, fv is assumed to be 0.•type (optional): type of payment scheme. 0 (default) means payments are due at the end of the period; 1 means payments are due at the beginning of the period.

InExcel we use the PMT function. Its use is based on these parameters: PMT(rate,nper,pv,fv,type)where:Rate is the interest ratenper is the number of paymentspv is the present value of the loanfv and type will be addressed later.

IPMT(rate,per,nper,pv,fv,type)($496.35)PPMT(rate,per,nper,pv,fv,type)Note that the sum of these two equals the total payment, ($664.27), that the function PMT provided above.

How is this helpful? Well, it shows you the anagrams of nper scrambled in different ways and helps you recognize the set of letters more easily. It will help you the next time these letters, N P E R come up in a word scramble game.