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.
Updated 4 months ago
Related resources