81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



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

How To Use in Sheets

NPER(rate, payment_amount, present_value, [future_value], [end_or_beginning])

External Links

5 Engineering Economics - Number of Periods (NPER) Example

I demonstrate how to use the Number of Periods (NPER) function in Google Sheets. NPER is used to determine how long it will take an investment to reach its goal.

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.