NPER

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

Video field
Financial

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.

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes no code required!