ProductSolutionsTemplatesResources

CUMPRINC

Calculates the cumulative principal paid over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate. Learn more

Video field
Financial

The CUMPRINC function in Google Sheets is used to calculate the cumulative principal payments made on a loan or investment over a specified period, assuming a constant interest rate.

The function takes six arguments:

Rate: The interest rate per period of the loan or investment. Numberofperiods: The total number of payment periods for the loan or investment. Presentvalue: The present value or principal amount of the loan or investment. Firstperiod: The first payment period for which you want to calculate the cumulative principal payment. Lastperiod: The last payment period for which you want to calculate the cumulative principal payment. Endor_beginning: This argument specifies whether the payments are made at the end or beginning of each period. Use 0 or "End of period" for payments made at the end of each period, or 1 or "Beginning of period" for payments made at the beginning of each period.

The CUMPRINC function returns the cumulative principal payment made from the firstperiod to the lastperiod, inclusive.

Visit Official Docs

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!