NPER
Description
Returns the number of periods required to pay off a loan, based on the specified periodic payment and interest rate.
Syntax
NPER(
rate
,
pmt
,
pv
, [
fv
], [
type
])
- rate: The interest rate for each period.
- pmt: The amount of the payment.
- pv: The present value.
- fv: The future value.
- type: The payment timing. 0 or Empty = the payment occurs at the end of the period; 1 = the payment occurs at the beginning of the period.