Parameter List
Syntax
NPER(rate, payment_amount,
[present_value]
, [future_value]
, [end_or_beginning]
)rate
The interest rate. For example: 2%.
payment_amount
The amount of each payment made. For example: -50.
[optional] present_value
The current value of the annuity. For example: 400.
[optional] future_value
The future value remaining after the final payment has been made. For example: 0. The default value is 0.
[optional] end_or_beginning
Whether the payments are due at the end (0) or beginning (1) of each period. For example: 0 or 1. The default type is 0.