NPER

Calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.

Parameter List

Syntax
NPER(ratepayment_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.

Examples

NPER(0,375%, -100, 5000, 0, ) returns $55.4742522