How to Calculate Cumulative Interest (3 Methods, Step-by-Step)

There are three reliable ways to calculate cumulative interest, depending on whether you want to learn the math, build a spreadsheet model, or just get a fast accurate answer.

Method 1 — By hand with the formula

For a lump sum with no contributions:

A = P × (1 + r/n)^(n × t)

Then: Cumulative Interest = A − P

Worked example

$5,000 at 6% compounded monthly for 10 years:

1. r/n = 0.06 / 12 = 0.005
2. n × t = 12 × 10 = 120
3. (1.005)^120 ≈ 1.81940
4. A = 5000 × 1.81940 = 9,097
5. Cumulative interest = $9,097 − $5,000 = $4,097

Method 2 — In Excel or Google Sheets

Lump-sum future value

=FV(rate, nper, pmt, [pv], [type])

For our example:

=FV(0.06/12, 12*10, 0, -5000)

Returns ≈ $9,096.98. Subtract the principal to get cumulative interest.

With recurring contributions

=FV(0.06/12, 12*10, -200, -5000)

Adds $200/month deposits to the same scenario. Returns ≈ $41,829.

Cumulative interest function

=CUMIPMT(rate, nper, pv, start_period, end_period, type)

Specifically designed for loans. For example, total interest on the first 12 months of a $300,000 mortgage at 6.5% over 30 years:

=CUMIPMT(0.065/12, 360, 300000, 1, 12, 0)

Per-year cumulative growth (manual schedule)

Build a year column and use this recursive cell:

End_balance = Start_balance × (1 + rate)^periods + PMT × ((1+rate)^periods − 1) / rate

Drag down to build a year-by-year amortization-style table.

Method 3 — Use our online calculator (fastest)

Open the cumulative interest calculator, enter your numbers, and the answer appears instantly along with:

• An interactive growth chart
• Year-by-year schedule (printable, downloadable as CSV)
• Effective APY
• Inflation-adjusted real value
• After-tax cumulative interest
• Pie chart showing the principal/contribution/interest split

The calculator implements every formula in this guide and handles edge cases (continuous compounding, annuity-due timing, step-up SIPs) that spreadsheets struggle with.

Common pitfalls

• Confusing APR and APY. Always use APY for projecting compound growth.
• Annual rate without dividing. If interest compounds monthly, you must divide the annual rate by 12 in the formula.
• Wrong sign in spreadsheet FV. In Excel, payments and present value are inputs to the bank — make them negative if you want the future value to be positive.
• Forgetting to subtract contributions. Cumulative interest is the growth, not the final balance. Subtract principal + contributions.

Which method should you use?

• Learning the math? Method 1 — work through the formula step by step.
• Building a custom model? Method 2 — Excel or Google Sheets.
• Quick, accurate answer with charts? Method 3 — our calculator.