How to Use CUMIPMT() in Google Sheets

Description

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

How To Actually Use CUMIPMT() in Sheets

CUMIPMT(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)

Try CUMIPMT yourself

In cells A1 to A3, enter the interest rate (5%), number of periods (10), and present value (1000). Use the CUMIPMT formula in cell B1 to calculate the cumulative interest from period 1 to period 10, assuming payments are made at the end of each period.

Your formula

Hints (3)

Locale Separator ,

Official Docs

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 CUMIPMT() formula:

Generate a CUMIPMT() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses CUMIPMT(). 2 free AI generations, no signup. Members get unlimited use.

Generate a CUMIPMT() formula