How to Calculate Compound Interest (The Formula and a Spreadsheet That Works)

Compound interest is the single most important concept in personal finance. It is what turns small, regular contributions into a large retirement balance over 30 years. It is also what makes credit card debt and missed mortgage payments so destructive. The same math, in different directions.

This guide is the practical version: the exact formula, how the compounding frequency changes the outcome, and a spreadsheet layout you can use to model any investment or loan. If you just want the answer, the Uttir Compound Interest Calculator does the math for you in your browser, with monthly contributions and a year-by-year table.

The 60-second explanation

Simple interest is calculated only on the original principal. If you put $1,000 in an account at 5% simple interest, you earn $50 per year, every year, forever.

Compound interest is calculated on the principal and the accumulated interest. The first year, you earn $50, same as simple interest. Now the balance is $1,050. The second year, you earn 5% of $1,050, which is $52.50. The third year, the balance is $1,102.50, and you earn $55.13. The interest earns interest. That is the whole idea.

For long time horizons, the difference is dramatic. At 5% over 30 years, $1,000 in simple interest becomes $2,500. In compound interest, it becomes $4,321. The compounding adds $1,821, almost 75% more, for the same rate and the same time.

The formula

The compound interest formula, for a single lump-sum deposit with no withdrawals or additions:

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

Where:

• A = the final amount (principal + interest)
• P = the initial principal
• r = the annual interest rate (as a decimal — 5% becomes 0.05)
• n = the number of times interest compounds per year
• t = the time in years

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

• P = 1,000, r = 0.05, n = 12, t = 10
• A = 1,000 × (1 + 0.05/12)^(12 × 10)
• A = 1,000 × (1.004167)^120
• A = 1,000 × 1.6470
• A = $1,647.01

The interest earned is $647.01. The calculator shows this and the year-by-year breakdown.

What about monthly contributions?

The formula above is for a lump sum. For a savings plan with regular contributions (like a 401(k) where you contribute every month), the formula gets longer. It is the sum of two parts:

1. The future value of the initial balance (the formula above).
2. The future value of the contributions, each one compounded from when it was made.

The second part is itself a formula. If you contribute C every period for n × t periods, and each contribution compounds at the same rate:

FV of contributions = C × [((1 + r/n)^(n × t) - 1) / (r/n)]

The total future value is the sum of the two:

FV = P × (1 + r/n)^(n × t) + C × [((1 + r/n)^(n × t) - 1) / (r/n)]

For a $10,000 initial balance plus $200 per month at 7% for 30 years:

• P = 10,000, C = 200, r = 0.07, n = 12, t = 30
• FV of P: 10,000 × (1 + 0.07/12)^360 = 10,000 × 8.116 = $81,165
• FV of contributions: 200 × [(8.116 - 1) / (0.07/12)] = 200 × 1219.97 = $243,994
• Total: $81,165 + $243,994 = $325,159

The Uttir calculator handles this in one click, with the year-by-year table showing how the contributions add up.

How often compounding matters

The compounding frequency (daily, monthly, quarterly, annually) matters less than most people think. For the same nominal rate, the difference between daily and annual compounding is small at low rates and noticeable at high rates.

Example: $10,000 at 5% for 10 years.

Compounding	n	Final amount
Annually	1	$16,288.95
Quarterly	4	$16,436.19
Monthly	12	$16,470.09
Daily	365	$16,486.65

Going from annual to daily at 5% gains you $197.70 over 10 years. That is real money, but it is small compared to the difference between 5% and 6% (which is about $2,200 at the same time horizon).

At higher rates, the difference is more dramatic. At 20% over 10 years, daily compounding produces about 8% more than annual. That is because the compounding effect is multiplicative — small differences in the rate inside the exponent get amplified over time.

The practical takeaway: when comparing savings accounts, the APY (annual percentage yield) is the right number to compare, not the nominal rate. APY already accounts for the compounding frequency.

APY vs APR

For savings and investments, the rate is usually quoted as APY (annual percentage yield), which assumes the interest is compounded and reinvested.

For loans, the rate is usually quoted as APR (annual percentage rate), which is the nominal rate without compounding.

When you are comparing, convert to the same basis. A 5% APY savings account and a 5% APR loan are not directly comparable — the savings account earns more per dollar (because of compounding), the loan costs more per dollar (because of compounding on the balance).

The rule of 72

For a quick mental estimate: how long does it take to double your money at a given rate?

Years to double ≈ 72 / rate (%)

At 6%, money doubles in 12 years. At 8%, in 9 years. At 10%, in 7.2 years. The rule is accurate within a few percent for rates between 2% and 20%, and it is the fastest way to estimate compound interest in your head.

The flip side for debt: at 18% APR on a credit card, your balance doubles in 4 years if you make no payments. This is why high-interest debt is so dangerous.

How to model a real investment in a spreadsheet

For a savings or investment plan, the most useful layout is a year-by-year table with four columns:

Year	Start balance	Contributions	End balance
1	$0	$2,400	$2,496
2	$2,496	$2,400	$5,090
3	$5,090	$2,400	$7,789

The end balance is the start balance plus contributions, grown at the rate. The formula in a spreadsheet:

End balance = (Start balance + Contributions) × (1 + r)

For monthly contributions, repeat the row 12 times per year, with monthly contributions and monthly rate. For irregular contributions, add a row for each one with its own date.

The Uttir calculator does this and shows the year-by-year table.

Compounding and inflation

Most discussions of compound interest ignore inflation, which is a mistake. Inflation is a compounding force in the opposite direction: your money loses purchasing power at a roughly steady rate per year.

To get the real return (after inflation):

real return ≈ (1 + nominal return) / (1 + inflation) - 1

For a 7% nominal return and 3% inflation, the real return is about 3.9%. A 7% nominal return with 0% inflation is 7% real. A 7% nominal return with 7% inflation is 0% real — your money is growing in number, but not in purchasing power.

This is why "I earned 8% on my investments last year" is not, by itself, useful. The question is: 8% nominal, but how much inflation? The real return is the number that matters.

Compounding and taxes

For taxable accounts, the interest you earn is usually taxed as ordinary income (or as capital gains, for stock investments). This affects the effective rate.

For a $10,000 investment at 5% in a taxable account where the interest is taxed at 25%, the effective rate is 5% × 0.75 = 3.75%. Over 30 years, the difference between 5% and 3.75% is enormous — about 50% less in the final balance.

Tax-advantaged accounts (401(k), IRA, Roth IRA, 401(k) match) avoid this. The compounding is the same math, but the tax drag is removed or deferred. This is the second reason why tax-advantaged accounts are so important — the first is the employer match, the second is the tax-free compounding.

Compounding and loans

The same math applies in reverse for loans. A loan with compound interest grows the balance every period. For a credit card at 20% APR with no payments, a $1,000 balance becomes $1,200 in one year, $1,440 in two years, $2,074 in three years, doubling in about 4 years.

For mortgages and other amortized loans, the monthly payment includes both interest and principal, and the balance shrinks even as interest is added. The Loan Calculator shows the full amortization schedule for a loan of any size, rate, and term.

Common questions

What is the difference between compound interest and simple interest?

Simple interest is calculated only on the original principal. Compound interest is calculated on the principal plus the accumulated interest. For a 30-year time horizon at any rate above 2%, compound interest is significantly larger than simple interest. The longer the time and the higher the rate, the bigger the difference.

Is compound interest good or bad?

It depends on which side of the transaction you are on. Compound interest on savings is one of the most powerful forces for building wealth. Compound interest on debt is one of the most destructive forces for personal finance. The math is the same; the direction is what matters.

What is the best compounding frequency?

For savings, more frequent compounding is better (daily beats monthly beats annually). For loans, less frequent compounding is better. In practice, the difference between daily and monthly compounding is small for low rates, and the dominant factor is the rate itself.

How long does it take to double my money?

Use the rule of 72: years to double ≈ 72 / rate (%). At 7%, about 10 years. At 10%, about 7 years. At 20%, about 3.6 years. This is a mental-math shortcut, accurate to within a few percent for rates between 2% and 20%.

Bottom line

Compound interest is the most important concept in personal finance. The formula is simple, the math is the same in every spreadsheet, and the difference it makes over decades is enormous. The Uttir Compound Interest Calculator shows the year-by-year breakdown for any starting balance, contribution, rate, and time horizon. Use it to model your retirement savings, your next investment, or the cost of carrying a balance on a high-interest debt.