Formulas > =NPER()
How to Use NPER() in Google Sheets
Description
How To Actually Use NPER() in Sheets
NPER(rate, payment_amount, present_value, [future_value], [end_or_beginning])
Try NPER yourself
In cells A1 to A3, enter the interest rate, the payment amount, and the present value of an investment. Use the NPER formula in cell A5 to calculate the number of periods needed to pay off the investment.
Hints (2)
-
Make sure to enter the interest rate as a decimal.
-
The payment amount should be a negative value if it's an outgoing payment.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the NPER() formula:
Generate a NPER() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses NPER(). 2 free AI generations, no signup. Members get unlimited use.
Generate a NPER() formula