How Compound Interest Actually Works (With a Table You Can Check)

Every post about compound interest eventually says “let it grow” and then shows a curve. A curve is not evidence. So this post is the spreadsheet behind the claim: one table of actual balances, at three rates, over forty years, with the arithmetic shown so you can spot-check any cell yourself. If compound interest has ever felt like something you’re supposed to be impressed by rather than something you understand, this is the version where nothing is hand-waved.

The Setup

One lump of $10,000, invested, never added to. Three annual return assumptions: 5% (a conservative, savings-adjacent number), 7% (roughly the stock market’s long-run average after inflation, historically), and 10% (roughly the market’s long-run nominal average, before inflation). I’m showing nominal numbers — meaning in future dollars that will buy less — so keep the inflation caveat in mind as you read every row.

The Table

Balance of a one-time $10,000 investment, by year-end, at each rate:

Year	At 5%	At 7%	At 10%
1	$10,500	$10,700	$11,000
5	$12,763	$14,026	$16,105
10	$16,289	$19,672	$25,937
20	$26,533	$38,697	$67,275
30	$43,219	$76,123	$174,494

Every cell is just 10,000 × (1 + rate)^year. The year-20 cell at 10%: 1.10^20 = 6.7275, and 10,000 × 6.7275 = $67,275. Grab a calculator and race me — the whole table reproduces in five minutes, and once you’ve done it once, the fog lifts permanently.

What the table is actually telling you

Three patterns, and they’re the whole lesson:

• Growth is invisible early and absurd late. Between year 1 and year 5 at 7%, the balance gains about $3,300. Between year 25 and year 30 at 7%, it gains roughly $21,800 — on the same original $10,000, with no new money. The curve is flat, then it’s a wall. Nothing about the investment changed; the exponent just did its work.
• The rate compounds the way the money does. Doubling 7% to 14% wouldn’t double the outcome — it more than doubles it, because gains on gains multiply. That’s why the 5% and 10% columns aren’t “the same line, a bit faster.” They’re different animals by year 30.
• Time is the variable you control with behavior, not brilliance. The difference between $76,000 and $43,000 at year 30 isn’t a smarter stock picker. It’s an extra ~2% a year, sustained, for three decades. Fees and rate differences, compounded, are the actual game — more on that below.

The Rule of 72 — and Its Fine Print

The shortcut everyone should keep: divide 72 by the annual rate to estimate how long money takes to double. At 7%: 72 ÷ 7 ≈ 10.3 years. At 10%: ≈ 7.2 years. At 5%: ≈ 14.4 years.

Check it against the table. At 7%, when does $10,000 first exceed $20,000? The table says year 20 is $38,697, so the doubling happened somewhere before year 20 — and interpolating, right around year 10. The rule said 10.3. Good enough for a conversation, accurate enough for planning.

The fine print: the Rule of 72 is an approximation that gets slightly less accurate at extreme rates, and it assumes annual compounding. It’s a mental tool, not a quote for a contract. Its real value is that you can do it at a car dealership, at a kitchen table, in your head, in three seconds.

Adding Money Changes the Picture — a Lot

The single-lump table shows the pure math, but most of us contribute over time. Here’s the same 7% assumption with $6,000 added each year ($500 a month, treated as an annual contribution to keep the arithmetic clean — true monthly compounding would land slightly higher):

Year	Total contributed	Balance at 7%	Growth (the part you didn’t earn)
10	$60,000	$82,899	$22,899
20	$120,000	$245,973	$125,973
30	$180,000	$566,764	$386,764
40	$240,000	$1,197,811	$957,811

Read that growth column twice. By year 30, more than two-thirds of the balance is compound growth, not contributions. By year 40, it’s four-fifths. The formula is the same annuity factor as before: [(1.07^30 − 1) ÷ 0.07] ≈ 94.46, and $6,000 × 94.46 ≈ $566,764. Nothing here is a prediction — it’s what a constant 7% would do, so you can see the shape of the mechanism and set your expectations honestly.

If you want the milestone-first version of this — the behavioral side of getting the first chunk on the board — start with the case for the first $10,000, because the first savings milestone is where almost everyone either builds the habit or quits.

Where Compound Interest Quietly Works Against You

The same math runs in reverse, and I’d be doing you a disservice to skip it. A credit card balance compounding at 22% APR is a 401(k) running in reverse. Divide 72 by 22: a card balance untouched doubles in about 3.3 years. Nobody charges you a fee for that doubling; the balance just quietly does it while you’re busy.

This is also why fees deserve their own arithmetic. A 1% annual expense ratio on a long horizon doesn’t cost you 1% — it costs you 1% of every future dollar, every year, compounding. Over 30 years on a large balance, that gap is routinely six figures, and I’ve broken down that specific math in the expense-ratio post. Compounding is morally neutral: it amplifies whatever rate you feed it, positive or negative, and it doesn’t care which.

Why the early years feel like a scam

Being honest about the emotional experience matters, because this is where people quit. In year 1 of a $10,000 investment at 7%, you earned $700. You’ll be tempted to conclude the whole thing is a rounding error. The conclusion is wrong only because it’s early — the payoff structure is back-loaded, and the back half of the timeline is where the number goes vertical. Every long-term investor lives through the boring decade. The ones who stay are the ones who understood in advance that boring is the mechanism.

I wrote a whole post about running these numbers for the first time and what changed for me afterward — compound interest is boring until you actually run the numbers — and this table is essentially the expanded version of that exercise. The same back-loading shows up in savings milestones too: the jump from your first $100,000 to your second takes years off the calendar, which I worked through in the first-$100,000 math.

Do This With It

1. Open a spreadsheet. Column A: years 1-30. Column B: =10000*1.07^A1, dragged down. That’s the entire model. Change the 10,000 and the 1.07 to your real numbers.
2. Add your actual monthly contribution as a second scenario and compare the year your balances cross six figures. The gap between “lump sum” you and “contributing” you is usually the largest number in the file.
3. Find your Rule-of-72 number at your portfolio’s expected rate, and note which birthday money doubling lands near. That’s the number to remember when markets get loud.

One honest disclaimer before you act on any of this: I’m not a financial advisor, none of this is financial advice, and no historical average guarantees anything about your specific future. What the table does do is make the mechanism legible — and once you can see that the tenth year matters more than the first, and that the rate you hold for thirty years matters more than any single good year, most of the loud financial internet becomes a lot easier to ignore.