# NPer

The **NPer** function returns the number of periods for a loan or investment based on known amount, interest rate, and periodic payment amount.

**NPer** is part of the set of financial functions that Sigma supports.

## Syntax

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

The **NPer** function has the following arguments:

- rate
- Required.
- The interest rate per period.
- pmt
- Required
- The payment for each period.
- pv
- Required
- The present value, or total value of all payments made as of the current date.
- fv
- Optional
- The future value, or a cash balance after the last payment.
- Defaults to 0.
- type
- Optional.
- Due date of the payment.
- 0
- End of the period
- 1
- Beginning of the period

- Default is 0.

## Examples

NPer(0.07/12, 1000, 100000)

The number of months it takes to pay off a loan of $100,000 if the interest rate is 7% and the regular payments are $1,000 each month is 79, or 6 years and 7 months.

NPer(0.07/4, 3000, 100000)

The number of quarters it takes to pay off a loan of $100,000 if the interest rate is 7% and the regular payments are $3,000 each quarter is 26.49, or about 6 years and 7.5 months.

## Related functions

- PV
- FV
- Pmt
- NPER function in Microsoft documentation