Excel Function

NPER

Calculates the number of periods for a loan or annuity.

NPER(rate, pmt, pv, [fv], [type])

Arguments

rate

Required

Specify the interest rate per period. For monthly calculations, use the annual rate divided by 12.

pmt

Required

Specify the payment each period. Payments are usually entered as negative values.

pv

Required

Specify the present value. In loan calculations, this is the principal.

fv

Optional

Specify the future value. If omitted, it is treated as 0.

type

Optional

Specify when payments are due: 0/omitted = end of period, 1 = beginning of period.

Practice Preview

Use NPER to calculate the number of periods needed for a loan with rate 0.005 per period, payment -23199.36, and principal 1200000.

Example Table

#
ASlip ID
BUnit Price
CQuantity
DAmount
2S001120.53361.5
3S00298.25491
4S003450.72901.4
5S004300.441201.6
6S005150.96905.4
7
8

How to Use (Formula)

=NPER(0.005, -23199.36, 1200000, 0, 0)

Result

#NUM!

Practice This Function

Start Function PracticeBack to Function List

NPER FAQ

How do I use NPER in Excel?

Use NPER when you want to calculate the number of payment periods. Enter Rate, pmt, pv in that order, then add optional arguments when needed.

Where can I practice NPER?

Use the "Start Function Practice" button to jump straight into NPER drills.

What arguments does NPER use?

The main arguments are Rate, pmt, pv, fv, Payment timing. Start with the required ones, then add optional arguments if needed.