Cumulative interest calculator: total interest, step by step

By · · 6 min read · How we write our guides

Cumulative interest is the total interest paid or earned over a period, added up. A cumulative interest calculator works it out for a loan (how much interest you'll pay over its life, or between two payments) or for savings (how much interest you've earned). For a fixed-rate loan, the quick version is: monthly payment × number of payments − amount borrowed. For example, a $300,000 mortgage at a made-up 6% over 30 years has a payment of about $1,798.65; 360 of those total about $647,515, so the cumulative interest is about $347,515. Try your own loan in the calculator below. This guide also shows the math, a year-by-year example, the one-line spreadsheet function, and where to find the real figure for your own loan.

Try the numbers

Loan interest calculator

Your loan documents show your real rate.

Toward the balance, if your loan allows it.

Interest compounds

Canadian fixed mortgage rates are often compounded twice a year. Check how your lender compounds. Payments stay monthly either way.

Monthly payment about

$1,798.65 a month

Cumulative interest: about $347,515 if the rate stays fixed and every payment is on time.

An illustration, not a forecast.

Borrowed$300,000
Interest$347,515
Total paid$647,515
Year by year
AfterCumulative interest paidInterest paidBalance still owedStill owed
1 year$17,900$296,316
5 years$87,082$279,163
10 years$166,895$251,057
15 years$236,904$213,147
30 years$347,515$0

Works the same in US or Canadian dollars.

What cumulative interest means

Interest is the price of borrowing money, or the payment for lending it. "Cumulative" just means running total. Two common uses:

  • On a loan: the total interest you pay. It can be for the whole loan ("lifetime interest") or a slice of it, like the first year or this calendar year.
  • On savings: the total interest you've earned so far, including interest earned on earlier interest.

Most people look it up for a loan, so that comes first. Savings are further down.

How to calculate cumulative interest on a loan

Most mortgages, car loans and student loans are amortizing: you pay the same amount every month, and each payment covers that month's interest first, with the rest paying down the balance. Three steps:

  1. Find the monthly payment. The formula is M = P × i ÷ (1 − (1 + i)^−N), where P is the amount borrowed, i is the monthly rate (the yearly rate ÷ 12) and N is the number of payments. Your loan documents also show it.
  2. Multiply by the number of payments to get the total you'll pay.
  3. Subtract the amount borrowed. What's left is the cumulative interest.

Example, with made-up numbers: a $25,000 car loan at 7% a year for 5 years. The monthly rate is 0.07 ÷ 12, there are 60 payments, and the payment works out to about $495.03. 60 × $495.03 is about $29,702. Subtract the $25,000 and the cumulative interest is about $4,702.

This shortcut assumes a fixed rate and that you make every payment on schedule, no more and no less. Variable rates, extra payments and missed payments all change the total.

A worked example: a 30-year mortgage, year by year

Same $300,000 at a made-up 6% fixed for 30 years, payment about $1,798.65 a month:

AfterCumulative interest paidBalance still owed
1 year$17,900$296,316
5 years$87,082$279,163
10 years$166,895$251,057
15 years$236,904$213,147
30 years$347,515$0

In the first year, about $17,900 of the roughly $21,584 you pay goes to interest, and the balance drops by only about $3,684. Halfway through, you've paid more than two-thirds of the lifetime interest, and you still owe over 70% of the original loan. That's amortization: interest is charged on what you still owe, and early on you owe the most.

Do it in a spreadsheet: CUMIPMT

Excel and Google Sheets have a function that adds up the interest between any two payments:

=CUMIPMT(6%/12, 360, 300000, 1, 12, 0)

In order: the monthly rate, the total number of payments, the amount borrowed, the first and last payment to include, and 0 for payments at the end of each month. This returns about −17,900, the first year's interest (negative because you pay it). Change 1 and 12 to 1 and 360 for the whole loan, or 49 and 60 for year five. Its sister function, CUMPRINC, adds up the principal paid over the same stretch.

What changes the total

With the same made-up $300,000 at 6%:

  • The term. Over 15 years instead of 30, the payment is about $2,531.57 a month, higher, but the cumulative interest is about $155,683 instead of $347,515.
  • Extra payments. Adding $100 a month toward the balance, if your loan allows it, pays it off in 313 months instead of 360, with about $294,168 of interest: roughly $53,000 less.
  • The rate. Every point of rate changes the total by tens of thousands of dollars on a loan this size.

Each of these is a trade-off, not a rule. A higher payment leaves less room for an emergency fund or retirement savings, and some loans charge prepayment penalties. Check your loan's terms first.

US and Canada differences

In the US, mortgage interest on your home can be deductible if you itemize (IRS Publication 936), which lowers its real cost for some people. In Canada, interest on a mortgage for the home you live in generally isn't deductible. Canadian fixed mortgage rates are also often compounded twice a year rather than monthly, so a US-style calculator can be slightly off; the calculator above has a twice-a-year option, and your lender can tell you how your loan compounds.

Cumulative interest on savings

The same idea works in reverse. On a savings account, CD or GIC, cumulative interest is everything you've earned so far, and each month's interest earns interest too. With made-up numbers, $10,000 at 4% compounded monthly earns about $2,210 in 5 years.

To work it out: ending balance − starting balance − anything you added. The SEC's Investor.gov compound interest calculator will run it with monthly additions. In the US, banks show the yield as APY (annual percentage yield), which includes compounding, under the Truth in Savings rules. For the idea behind it, see how compound interest works.

Paying down debt vs investing: where cumulative interest fits

Knowing your cumulative interest makes one common question clearer: should extra money pay down a loan or go into investments? Paying down a balance saves its interest rate with certainty. Investing offers a return that isn't promised and can be negative in any year. A 20% credit card and a 4% mortgage sit very differently in that comparison, and an employer match on retirement contributions is its own case. Reasonable people land on either side for lower-rate debt, or split the money; the call is yours. For the investing side, see how to start investing.

How to check your own numbers

  1. Mortgage (US): your Closing Disclosure shows the total of payments and the Total Interest Percentage (TIP): total interest as a percentage of the loan amount.
  2. Credit cards (US): each statement shows the interest charged that period and so far this year.
  3. Mortgage or loan (Canada): your disclosure statement shows the cost of borrowing; your lender's online account usually shows interest paid to date.
  4. Any fixed-rate loan: run CUMIPMT with your rate, term and balance, and compare it with your statement.
  5. Savings: compare your year-end statement's interest with the APY you were quoted.

The Bywell course covers the trade-off in "Paying down debt vs investing," in the Building your plan unit. It lists each debt with its balance and rate, highest first, so the comparison is clear whichever way you lean.

This is general information, not investment advice. Rates here are made up for illustration.

Try this lesson free

Paying down debt vs investing

6 min · Building your plan

Right here in your browser, no download. Read it in a few minutes, then answer questions that explain why each answer is right. Free includes the Start here unit, then 3 lessons a day.

Already investing? Follow your stocks and ask Claude or ChatGPT.

Common questions

What does cumulative interest mean?
It's the total interest over a stretch of time, added up. On a loan, it's all the interest you pay, either over the whole loan or between two payments. On savings, it's all the interest you've earned so far.
How do I calculate the total interest on a loan?
Work out the monthly payment, multiply it by the number of payments, and subtract the amount borrowed. A made-up $25,000 loan at 7% over 5 years has a payment of about $495.03; 60 payments total $29,702, so the interest is about $4,702.
What is CUMIPMT in Excel or Google Sheets?
A function that adds up the interest paid between two payment numbers on a fixed-rate loan. =CUMIPMT(rate per period, number of payments, amount borrowed, first payment, last payment, 0) returns the total as a negative number, because it's money you pay.
Why is most of an early mortgage payment interest?
Interest is charged on the balance you still owe, and early on that balance is at its largest. As you pay it down, less of each fixed payment goes to interest and more to the balance. This schedule is called amortization.
Where can I find the total interest on my own loan?
In the US, a mortgage's Closing Disclosure shows the Total Interest Percentage and total of payments, and credit card statements show interest charged this year. In Canada, check your loan or mortgage disclosure statement for the cost of borrowing.

Sources

  1. CFPB: Regulation Z, 12 CFR 1026.38, content of disclosures (Closing Disclosure: total of payments, Total Interest Percentage)
  2. CFPB: Regulation Z, 12 CFR 1026.7, periodic statement (interest charged for the period and year to date)
  3. CFPB: Regulation DD, Truth in Savings (12 CFR 1030): APY disclosure for deposit accounts
  4. IRS Publication 936: Home Mortgage Interest Deduction
  5. SEC Investor.gov: Compound Interest Calculator
  6. Justice Laws: Interest Act, section 6 (blended mortgage payments: rate calculated yearly or half-yearly)
  7. Justice Laws: Cost of Borrowing (Banks) Regulations, SOR/2001-101 (disclosure statements)

General information and education, not investment advice. Bywell never makes buy, sell or hold recommendations.

Keep reading