Calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate. Learn more
NPER() is a financial function in Google Sheets that calculates the number of payment periods required to pay off a loan or investment based on a constant payment amount, a fixed interest rate, and other relevant factors.
The NPER() function takes five arguments:
rate: The interest rate per payment period. paymentamount: The amount of the payment made each period. presentvalue: The present value or the amount of the loan or investment. futurevalue (optional): The future value of the loan or investment at the end of the payment period. Default is 0. endor_beginning (optional): Specifies whether payments are due at the end or beginning of each period. Default is 0 or end of the period.
NPER() returns the number of periods needed to repay the loan or investment based on the given inputs.