Skip to content
LoveToCalc

Compound interest calculator

See how a starting amount and monthly deposits grow when your returns earn returns of their own. Compare two plans side by side.

Your numbers

Withdrawals

Result

Final balance

$292,465

Put a second set of numbers beside this one and see the difference.

Total deposits
$130,000
Interest earned
$162,465
Interest share of balance
55.6%

After 20 years you would have $292,465. You deposit $130,000 in total, and $162,465 comes from compound interest.

Deposits are made at the end of each month and the annual return is compounded monthly. Withdrawals are made at the end of each month and never take more than is left; a dash next to "Money runs out in year" means the money lasts the whole period. Taxes, fees and inflation are not included.

Growth year by year

Show year-by-year table
YearDepositsInterestBalance
0$10,000$0$10,000
1$16,000$890$16,890
2$22,000$2,263$24,263
3$28,000$4,151$32,151
4$34,000$6,592$40,592
5$40,000$9,623$49,623
6$46,000$13,287$59,287
7$52,000$17,627$69,627
8$58,000$22,692$80,692
9$64,000$28,530$92,530
10$70,000$35,197$105,197
11$76,000$42,751$118,751
12$82,000$51,254$133,254
13$88,000$60,772$148,772
14$94,000$71,376$165,376
15$100,000$83,143$183,143
16$106,000$96,153$202,153
17$112,000$110,494$222,494
18$118,000$126,258$244,258
19$124,000$143,547$267,547
20$130,000$162,465$292,465
Download each year's deposits and interest

The CSV uses commas between fields and a decimal point. In the Excel file the numbers are plain numbers, which Excel shows in your own format.

The Excel sheet recalculates when you change the numbers in the blue cells. The CSV holds the values only.

Ready-made template with example numbers: Compound interest in Excel

Compound interest in Excel: FV

The same calculation in one cell, with your numbers. Paste it into Excel:

=FV((1+7%)^(1/12)-1,20*12,-500,-10000)

In Swedish Excel the function is called SLUTVÄRDE. There the arguments are separated by semicolons and decimals written with a comma. Google Sheets uses the English names whatever the language.

The minus sign is not a mistake. Excel tells money coming in from money going out by its sign, so one of the amounts is negative. Flip the signs and the answer flips too.

How compound interest works

With compound interest you earn a return not only on the money you put in, but also on the returns you have already earned. $10,000 growing at 7% a year becomes $10,700 after one year. In year two the 7% is calculated on $10,700, so you end at $11,449 — the extra $49 is interest on interest.

In year one that $49 is barely worth mentioning. That is exactly why the effect is so easy to underestimate: it stays invisible for a long time, and then it is the only thing that matters. Starting with $10,000 and depositing $500 a month at 7% a year, you reach $292,465 after 20 years. Leave the same plan running for another ten and you reach $660,849. Those last ten years added $368,384 — more than the entire balance you had built in the first twenty.

Formula

The calculator treats the annual return as an effective annual rate and adds deposits at the end of each month. The monthly rate is derived so that twelve months of growth equal exactly one year at the annual rate:

i = (1 + r)1/12 − 1

FV = P · (1 + r)t + M · ((1 + i)n − 1) / i

Example

You start with $10,000, deposit $500 a month and earn 7% a year. Watch where the balance comes from as the years pass:

Time Total deposits Interest earned Final balance Interest share
10 years $70,000 $35,197 $105,197 33%
20 years $130,000 $162,465 $292,465 56%
30 years $190,000 $470,849 $660,849 71%

After ten years most of the balance is still your own money. After thirty, nearly three quarters of it is interest. Same plan throughout — only more time.

Waiting and saving more later

A common way to postpone saving is to assume you will make it up later with a bigger deposit. Run the numbers before you decide.

Twice the monthly deposit, more money in, and still $452,729 less at the end. The fifteen years you removed were the ones that would have had the longest to grow, and a plan that starts later has to be considerably larger to catch up.

When does money double? The rule of 72

A shortcut you can do in your head: divide 72 by the return in percent, and you get roughly how many years a lump sum takes to double.

Return Rule of 72 Exact
5% 14.4 years 14.2 years
7% 10.3 years 10.2 years
10% 7.2 years 7.3 years

The rule stays close to the exact answer between about 4% and 12%. At 7%, a starting amount doubles about every ten years: $100,000 becomes $200,000, then $400,000, then $800,000. For the exact figure rather than the rule of thumb, use the doubling time calculator.

What fees cost

A fee shows up as a lower return, which means it works against compounding itself rather than against a single year. Depositing $500 a month for 30 years:

One percentage point of fees cost $97,470, about a sixth of the final balance. You can account for this yourself: subtract the fund’s or account’s annual fee from the return you enter, and the calculator shows what you keep instead of what existed before the fee.

What inflation does

The calculator works in dollars, not in purchasing power. The final balance is what the account says, not what the money buys. To see the result in today’s money, enter a real return instead — the return minus inflation, roughly:

rreal = (1 + r) / (1 + inflation) − 1

At a 7% return and 2% inflation, the real return is 4.90%. The same plan — $10,000 to start and $500 a month for 20 years — then looks like this:

That is not less money. It is the same money, expressed in what it is expected to be worth. Which inflation rate is reasonable is your call; 2% is used here only as a worked example.

Average return is not what you get

Something that surprises many people: a plan that gains 20% one year and loses 20% the next has not broken even. $100,000 becomes $120,000, and 20% of $120,000 is $24,000 — leaving $96,000. The average of +20 and −20 is zero, but the result is −4%.

The more a return swings, the wider the gap between the arithmetic average and what you actually hold. This calculator uses a steady annual return, which is the right basis for comparing two plans against each other, but it means reality rarely looks like the curve. Read a smooth upward line as an illustration of the effect, not as a forecast for any single year.

Compare two plans

Often the useful question is “how much more will it be if I change something?” Choose Compare two scenarios and you get two sets of fields, a result for each and the difference worked out between them.

Raise the monthly deposit from $500 to $750, with $10,000 to start and 7% over 20 years, and the final balance goes from $292,465 to $419,349. The $60,000 of extra deposits turned into $126,884 — more than double, because every extra deposit had time to grow too.

The comparison lives in the address bar, so the link you copy opens both scenarios for whoever you send it to.

When you start taking money out

Saving has two phases, and the second one is what the first was for. Choose Withdrawals: Fixed amount or Share of balance, and the chart carries on past the day the deposits stop, showing the capital paying itself out.

Deposits stop when the withdrawals begin, and the period is the whole journey: 30 years with withdrawals after 15 means fifteen years of saving and fifteen of spending.

Take $10,000 to start, $500 a month and a 7% return. After fifteen years there is $183,143. Withdraw $2,000 a month from then on and it is gone during year 26; around $1,600 a month lasts the whole period instead. Choose 4% and the withdrawals start at $610 a month — after thirty years you have taken out $134,991 and still have $280,108. The difference is that the percentage only ever takes a share of what is there.

What the calculator does not include

The result is an illustration, not a forecast.

Frequently asked questions

Are deposits made at the start or the end of the month? At the end of each month. That is the standard assumption in finance textbooks and spreadsheet functions (FV), and it gives a slightly more conservative result than depositing at the start of the month.

What annual return should I use? It depends on what you save in. A savings account pays its stated interest rate, while the return on funds and stocks varies. Picking a single figure is always a guess, so guess in ranges: run a cautious rate and an optimistic one and see how far apart they land. That is what the comparison mode is for.

Why does 7% a year not mean 7/12% a month? If you compounded 7/12% every month, the lump sum would grow by about 7.23% in a year, not 7%. The calculator uses a monthly rate of about 0.565% so that a year of growth equals exactly the annual return you entered.

Does the starting amount or the monthly deposit matter more? It depends on the time horizon. The starting amount has the whole period to grow, while the last deposit only sits for a month. Over short periods the deposits dominate; over long ones the interest takes over — in the example above, interest is 33% of the balance after ten years and 71% after thirty.

How much do I need to save to reach a target? Work backwards instead: enter the goal and the time in the savings goal calculator and it gives you the monthly amount required.

What if I cannot deposit the same amount every month? The calculator assumes a fixed monthly amount. If yours varies, the simplest estimate is what you expect the average to be. To see how sensitive the result is to that assumption, compare two levels against each other — the gap between them is the margin of error you are living with.

How long does the money last once I start withdrawing? Money runs out in year tells you, when the withdrawal is a fixed amount. A dash means the capital lasts the whole period you entered. The figure is more sensitive to the return than to the withdrawal: drop the return by a point and see how many years disappear — that is the uncertainty to plan around, not the last hundred of the monthly amount.

Last reviewed October 6, 2026 ·How pages are reviewed

The formula behind this

All saving & investing calculators

Put this calculator on your site

Copy the code into your page where the calculator should appear. It loads from lovetocalc.com, so it stays current on its own — all we ask is that the credit line comes with it.