Compound Interest Formula: The Complete Guide

The compound interest formula is A = P(1 + r/n)^nt, where A is the final amount, P is the principal, r is the annual interest rate (as a decimal), n is the number of compounding periods per year, and t is time in years. A $1,000 deposit at 6% compounded daily grows to $1,127.49 after two years — versus just $1,120 with simple interest. That $7.49 gap sounds small, but at scale and over decades, it becomes transformative.

Compound interest is the mechanism behind every savings account, every retirement fund, and every long-term investment portfolio. Understanding how to calculate it — and how compounding frequency changes the outcome — puts you in control. This guide walks through the formula, a full worked example, the difference versus simple interest, how to apply it in Excel, and the shortcuts that make real-world math faster.

All rates and APYs mentioned in this article are for illustration purposes. Rates change frequently — always verify current rates directly with your financial institution before making decisions.

Contents

1. What the Compound Interest Formula Actually Means
2. Simple Interest Formula vs Compound Interest Formula
3. Compound Interest Formula Step-by-Step Worked Example
4. How Compounding Frequency Changes Your Result
5. Compound Interest Formula in Excel
6. Compound Interest with Monthly Contributions
7. The Rule of 72, the Fastest Shortcut in Finance
8. Compound Interest Formula vs Simple Interest Formula at a Glance
9. Watch This First
10. What Real People Are Saying
11. Frequently Asked Questions
12. Your Next Steps

What the Compound Interest Formula Actually Means

The compound interest formula looks intimidating until you break down what each variable is doing. Here it is again in full:

A = P(1 + r/n)^nt

• A = the total amount at the end (principal + interest)
• P = the principal (your starting deposit or loan balance)
• r = the annual interest rate expressed as a decimal (so 6% becomes 0.06)
• n = the number of times interest compounds per year (daily = 365, monthly = 12, quarterly = 4, annually = 1)
• t = the number of years the money is invested or borrowed

The key insight buried in this formula is the exponent. When you raise (1 + r/n) to the power of nt, you're multiplying a growth factor against itself dozens, hundreds, or even thousands of times. That repeated multiplication is what separates compound interest from simple interest. Each period, the interest you've already earned gets folded back into the base, and then that larger base earns interest in the next period. The balance isn't just growing — the rate of growth itself accelerates over time.

To isolate just the interest earned (rather than the total balance), use this version:

CI = P(1 + r/n)^nt − P

That's total compound interest = final amount minus your original principal. If you deposited $5,000 and ended up with $6,800, your compound interest earned is $1,800.

The formula assumes interest is being credited and reinvested at each compounding period. If you withdraw interest as it's paid rather than letting it accumulate, you lose the compounding effect entirely and are effectively back to simple interest math. That's a critical distinction for anyone building long-term savings. If you're putting money to work in a high-yield savings account, leaving the interest untouched is what activates the full power of the formula.

One more version worth knowing is the continuous compounding formula: A = Pe^rt, where e is Euler's number (approximately 2.71828). This represents the theoretical maximum you'd earn if interest compounded infinitely often. In practice, daily compounding is close enough to continuous compounding that the difference is negligible for most real-world calculations.

Simple Interest Formula vs Compound Interest Formula

The simple interest formula is: I = Prt

Where I is interest earned, P is principal, r is the annual rate as a decimal, and t is time in years. According to Texas State University's MathWorks program, if you invest a principal amount P at interest rate r for t years, the simple interest earned is exactly I = Prt — no more, no less. It's a flat calculation. The interest never earns interest.

Take $1,000 at 5% for 10 years. Simple interest gives you $50 per year, every year, for a total of $500 in interest and a final balance of $1,500. The math is consistent and predictable. According to Stevenson University's finance curriculum, with simple interest you add the same flat dollar amount each period — it never changes regardless of how long you hold the investment.

Compound interest on that same $1,000 at 5% compounded annually for 10 years produces $628.89 in interest — a final balance of $1,628.89. That's $128.89 more than simple interest, generated purely by interest earning interest. Push the timeline out to 30 years and the gap becomes dramatic: simple interest yields $1,500 in total interest, while compound interest at 5% annually turns that $1,000 into $4,321.94 — over $2,800 more.

Where does simple interest still show up? Car loans, some personal loans, and U.S. Treasury securities often use simple interest calculations. Short-term borrowing where the payoff happens quickly doesn't give compound interest much time to work, so lenders use the simpler method. For mortgages and most savings products, though, compound interest is the standard.

The compounding advantage cuts both ways. When you're the investor, compound interest builds wealth faster than the simple interest formula ever could. When you're the borrower — on a credit card or a payday loan — compound interest works against you with equal force. Credit card balances that compound daily at 20–29% APR demonstrate exactly why carrying a balance is so destructive to personal finances. Understanding this formula is genuinely protective knowledge.

Compound Interest Formula Step-by-Step Worked Example

Here's a concrete walkthrough using a scenario that comes up constantly in real financial planning: someone deposits $3,000 into a savings account at 4% annual interest, compounded monthly, and leaves it alone for 5 years. What do they end up with?

Step 1: Identify your variables.

• P = $3,000
• r = 0.04 (4% expressed as a decimal)
• n = 12 (monthly compounding)
• t = 5 years

Step 2: Plug into the formula.

A = 3000 × (1 + 0.04/12)^12×5

Step 3: Simplify inside the parentheses first.

0.04 ÷ 12 = 0.003333...

1 + 0.003333 = 1.003333

Step 4: Calculate the exponent.

12 × 5 = 60

So you need: 1.003333⁶⁰

1.003333⁶⁰ ≈ 1.22099

Step 5: Multiply by the principal.

A = 3,000 × 1.22099 = $3,662.97

Step 6: Calculate compound interest earned.

CI = $3,662.97 − $3,000 = $662.97

For comparison, simple interest on the same $3,000 at 4% for 5 years would be: I = 3,000 × 0.04 × 5 = $600.00. The compound interest example earns $62.97 more — not life-changing in isolation, but scale this to $30,000 over 20 years and the compounding advantage is enormous.

Now run the frequently cited example directly: $1,000 at 6% compounded daily for 2 years.

• P = $1,000, r = 0.06, n = 365, t = 2
• A = 1000 × (1 + 0.06/365)^365×2
• 0.06 ÷ 365 = 0.000164384
• 1.000164384⁷³⁰ ≈ 1.12749
• A = 1,000 × 1.12749 = $1,127.49

That matches the verified figure from financial reference data. The compound interest earned is $127.49, versus $120.00 under simple interest. The difference is $7.49 — modest over two years, but the daily compounding ensures every single day's interest gets added to the base for the next day's calculation. Over decades, that daily reinvestment is what builds generational wealth.

For anyone who wants to run these numbers without manual calculation, a dedicated compound interest calculator handles the exponent math instantly and lets you model different rates and time horizons side by side.

How Compounding Frequency Changes Your Result

The n variable in the compound interest formula is more powerful than most people realize. Everything else being equal, the more frequently interest compounds, the higher your final balance. The differences between frequencies are smaller than you'd expect for modest rates, but they're real and they accumulate.

Take $10,000 at 5% for 10 years. Here's how the compounding frequency changes the outcome:

The jump from annual to monthly compounding adds nearly $200 to your balance. Going from monthly to daily adds another $16. The law of diminishing returns kicks in as compounding frequency increases — which is why continuous compounding (theoretically infinite periods) is only marginally better than daily for realistic interest rates.

What this table also shows clearly: the biggest win isn't moving from monthly to daily compounding. It's moving from simple interest to compound interest at all. That gap is over $1,400 on a $10,000 deposit over 10 years. That's the fundamental argument for choosing savings vehicles that compound interest rather than pay flat periodic yields.

A common question: is 1% per month the same as 12% per year? The basic conversion multiplies the periodic rate by the number of periods — so 1% monthly equals 12% APR. But in compounding terms, 1% monthly compounded monthly actually produces an effective annual rate of about 12.68%, because each month's interest gets added to the base before the next month's interest is calculated. This distinction matters enormously when comparing loan rates quoted as monthly versus annual figures.

Compound Interest Formula in Excel

Excel doesn't have a single "compound interest" button, but the formula translates directly into a spreadsheet with no special functions required. For a standard lump-sum deposit with no additional contributions, use this cell formula:

=P*(1+r/n)^(n*t)

In practice, with actual cell references, it looks like this. Set up a simple input table:

Cell B5 will calculate $8,235.05 — your $5,000 growing at 5% compounded monthly for 10 years. To isolate interest earned, add a B6 cell with =B5-B1, which gives $3,235.05.

For a year-by-year breakdown, use the same formula with t stepping from 1 to however many years you want to model. Put years in column A (1 through 10), and in column B enter =B1*(1+$B$2/$B$3)^($B$3*A1) — using absolute references for your input cells and a relative reference for the year. Drag down and you get a running balance table.

Users in r/investing favor an even simpler Excel approach for tracking monthly growth: enter the starting balance in A1, then put =A1*1.01 in A2 (for a 1% monthly rate), and =A2*1.01 in A3. Highlight A2 and A3, then drag the fill handle downward to extend the series for as many months as you want. This method makes the growth visually intuitive — you can literally watch each row's value increase as you scroll down.

Excel also has a built-in FV (Future Value) function that can handle both lump-sum and recurring contribution scenarios: =FV(rate, nper, pmt, pv). For a lump sum with no additional contributions: =FV(0.05/12, 120, 0, -5000) produces the same $8,235.05. The negative sign on the principal tells Excel you're paying money out (investing it), so the future value returns as positive.

Compound Interest with Monthly Contributions

The basic compound interest formula handles a one-time lump sum. Most real savers contribute money regularly — every paycheck, every month. For that scenario, you need the Future Value of an Annuity formula:

A = PMT × [((1 + r/n)^nt − 1) / (r/n)]

Where PMT is the fixed periodic payment amount. If you also start with an existing balance, add the standard compound interest formula result for your lump sum to this annuity formula result.

Here's a concrete example. Suppose you start with $0 and contribute $200 per month into an account earning 6% compounded monthly for 20 years.

• PMT = $200
• r = 0.06, n = 12, t = 20
• r/n = 0.005
• nt = 240
• (1.005)²⁴⁰ = 3.31020
• (3.31020 − 1) / 0.005 = 462.04
• A = 200 × 462.04 = $92,408

Your total contributions over 20 years: $200 × 240 = $48,000. Your compound interest earned: $44,408. The interest you earned exceeds what you actually put in. That's what consistent compounding over a 20-year horizon looks like.

This is why the combination of time and regular contributions is the most powerful wealth-building tool available to ordinary earners. According to the Killik & Co YouTube channel, investing a relatively modest sum monthly at a reasonable long-term rate — and then simply leaving it alone — can produce final balances that dwarf the total amount actually deposited, because the bulk of gains accumulate in the later years when the compounding base is largest. The channel illustrates this specifically: the gap between cumulative deposits and cumulative interest widens dramatically as you approach year 25, 30, and 40 of a consistent investment period. Bailing out early doesn't just stop contributions — it forfeits the most productive years of compounding.

For anyone managing a longer-horizon goal like retirement, connecting this math to a broader paycheck budgeting strategy is the practical first step. Carving out even $100–$200 per month and directing it toward a compounding account is where the formula stops being abstract and starts being real money.

The Rule of 72, the Fastest Shortcut in Finance

The Rule of 72 is a mental math shortcut that tells you roughly how long it takes money to double at a given compound interest rate. Divide 72 by the annual interest rate percentage, and the result is approximately how many years until your money doubles.

Years to double ≈ 72 / Interest Rate (%)

Examples:

• 6% interest: 72 ÷ 6 = 12 years to double
• 8% interest: 72 ÷ 8 = 9 years to double
• 12% interest: 72 ÷ 12 = 6 years to double
• 4% interest: 72 ÷ 4 = 18 years to double

Why 72 specifically? The mathematically precise number is 69.3 (derived from the natural logarithm of 2), which applies exactly to continuous compounding. Daily compounding is close enough to continuous that 69.3 or 70 would be technically more accurate. However, 72 is used because it divides cleanly by 2, 3, 4, 6, 8, 9, and 12 — making mental division much easier without meaningfully sacrificing accuracy. The approximation error is typically under 1% for rates between 4% and 15%, which covers most real-world investment scenarios.

The Rule of 72 works in reverse too. If you want your money to double in 10 years, you need to earn 72 ÷ 10 = 7.2% annually. That's a useful benchmark when evaluating whether an investment is likely to meet your goals.

It also applies to debt. A credit card charging 24% APR will double the balance you carry in exactly 3 years (72 ÷ 24 = 3) if you make no payments. That reframe makes the cost of carrying credit card debt viscerally clear in a way that an APR percentage alone often doesn't. The same formula that builds wealth on the savings side destroys it on the debt side — just as efficiently.

For investors tracking index fund performance or evaluating index funds versus ETFs, the Rule of 72 is a fast gut-check on whether a fund's historical return is likely to double your money within your target horizon.

Compound Interest Formula vs Simple Interest Formula at a Glance

The table above captures the practical distinction at a glance. According to Investopedia's explanation of simple vs. Compound interest, compound interest multiplies savings or investment growth far more aggressively than simple interest, while the simple interest formula works by multiplying the loan principal by the rate and by the term — a straightforward linear calculation that never feeds back on itself.

The practical takeaway: when you're saving or investing, always favor compounding. When you're borrowing, understand that compound interest makes debt more expensive over time — especially on revolving balances like credit cards. That dual nature is what makes this formula worth understanding in both directions.

Watch This First

Watch: the Killik & Co YouTube channel on how to harness compound growth →

This video from the Killik & Co YouTube channel is one of the clearest visual explanations of why the biggest compounding gains arrive late — not early. The channel demonstrates with a concrete running example how someone contributing a fixed monthly sum at a steady rate ends up with cumulative interest that eventually dwarfs total contributions deposited. In their illustration, depositing £100 per month at 8% for 40 years produces a final balance well over £350,000 — from a total of just £48,000 in actual deposits. The difference is entirely compound interest accumulating on a growing base over time.

Critically, the channel makes a point worth repeating: the worst thing you can do is exit an investment in the final years of a long compounding horizon. Bailing out at year 30 of a 40-year investment doesn't just stop the contributions — it eliminates the period when compounding is working hardest, when the interest generated each year exceeds what was deposited over entire earlier decades. The channel frames this as the core reason why patience, not sophistication, is the most valuable investor trait when it comes to compounding.

The video also reinforces the assets-and-liabilities duality mentioned throughout this guide: the same compounding math that builds investment wealth will accelerate debt at exactly the same pace if you're on the wrong side of an interest-bearing balance. That framing makes the formula feel less like abstract math and more like a force of nature you either work with or get crushed by.

What Real People Are Saying

Reddit users in r/MathHelp frequently run into the same wall when first learning the compound interest formula: the standard A = P(1 + r/n)^nt formula only accounts for a single lump-sum deposit. As soon as someone tries to model their actual savings behavior — depositing $300 per month into an account — the formula breaks down. Several users in that thread note the need for the annuity formula to handle regular periodic contributions separately from the initial principal, then combine the two results for a complete picture.

In r/mathematics, users discuss why more frequent compounding produces higher returns: the key is that interest earned earlier in the period gets reinvested sooner, meaning it starts generating its own interest faster. The earlier each payment is credited, the more time it has to compound — which is why daily compounding edges out monthly compounding even for the same nominal annual rate.

Users in r/investing sometimes push back on whether compound interest is really as magical as finance content makes it sound. The honest answer from the community: it's not magic, it's math. $1,000 at 7% simple interest earns $70 in year one. At compound interest, year one is identical — $70. The difference builds in year two, when compound interest earns $74.90 (7% of $1,070) while simple interest still earns $70. The gap is small early. The gap is enormous at year 30. The community consensus is consistent: the formula itself is basic arithmetic; what makes it powerful is time, and most people don't give it enough of that.

Frequently Asked Questions

How do you find compound interest if only simple interest is given?

If you know the simple interest for a given principal, rate, and time, you can back-calculate P, r, and t using I = Prt, then plug those same values into the compound interest formula A = P(1 + r/n)^nt. For example, if simple interest on a deposit is $300 over 3 years at 5%, then P = 300 ÷ (0.05 × 3) = $2,000. Compound interest on that same $2,000 at 5% for 3 years compounded annually would be $2,000 × (1.05)³ − $2,000 = $315.25 — about $15.25 more than the simple interest calculation.

How much is $1,000 worth at the end of 2 years if the interest rate of 6% is compounded daily?

$1,127.49. Using A = 1000 × (1 + 0.06/365)^365×2, you get approximately $1,127.49. This compares to $1,120 under simple interest at the same rate and term — a $7.49 advantage for compounding. Over longer periods and larger principals, that compounding premium grows substantially.

Is 1% per month actually the same as 12% per year?

In nominal (APR) terms, yes — multiplying 1% by 12 months equals 12%. But in effective annual rate terms, no. When interest compounds monthly at 1% per month, the effective annual rate is (1.01)¹² − 1 = approximately 12.68%. That extra 0.68% exists because each month's interest gets added to the balance before the next month calculates. When comparing loan products, always compare effective annual rates, not just the nominal monthly rate multiplied by 12.

Why is the number 72 used in the Rule of 72 and not 69 or 70?

The mathematically precise constant is 69.3, derived from the natural log of 2. That's the exact value for continuous compounding. Daily compounding is close enough to continuous that 69.3 or 70 would be more precise. The number 72 became standard because it divides cleanly by 2, 3, 4, 6, 8, 9, and 12 — making mental arithmetic easy. For rates between 4% and 15%, the Rule of 72 produces answers within 1% of the exact doubling time, which is accurate enough for planning purposes without requiring a calculator.

What is the compound interest formula for 3 years, and how does it differ from simple interest over 3 years?

For 3 years, the compound interest formula is A = P(1 + r/n)³ⁿ. With annual compounding (n=1), it simplifies to A = P(1 + r)³. For $5,000 at 6%: A = 5,000 × (1.06)³ = 5,000 × 1.19102 = $5,955.08, earning $955.08 in interest. Simple interest on the same terms: I = 5,000 × 0.06 × 3 = $900.00. The compound interest difference is $55.08 over three years — modest, but it accelerates significantly in years 5, 10, and beyond as the gap between linear and exponential growth widens.

How do you use the compound interest formula in Excel without making errors?

The most reliable method is to store each variable (P, r, n, t) in separate cells and reference them in your formula. Avoid typing constants directly into the formula — if you hard-code 0.06 inside a nested function and later want to test a different rate, you'll miss it. Use absolute cell references ($B$2 instead of B2) so you can copy the formula to adjacent cells without breaking your variable references. For periodic contributions, use Excel's built-in FV function: =FV(r/n, n*t, -PMT, -P), where PMT is the regular payment and P is the starting principal. Both get entered as negative numbers to represent cash going out.

Can compound interest work against you on loans, and how do you calculate the damage?

Yes — and the compound interest formula works identically on debt as it does on savings. A $5,000 credit card balance at 24% APR compounded daily will grow to approximately $6,393 after one year if you make zero payments. After three years with no payments: roughly $10,404 — more than double the original balance. Using the Rule of 72: 72 ÷ 24 = 3 years to double. That's why high-rate revolving debt is financially destructive at a pace that surprises most people. The formula is neutral — it amplifies both savings growth and debt growth with equal indifference.

Your Next Steps

The compound interest formula isn't just a math concept — it's a decision-making tool. Here's how to put it to work immediately.

Step 1: Run your own numbers. Take your current savings balance (or the amount you plan to deposit), your account's annual interest rate, its compounding frequency, and your time horizon. Plug those into A = P(1 + r/n)^nt. If manual calculation feels slow, use the Excel method in this guide or a trusted compound interest calculator to see your projected balance in 5, 10, and 20 years side by side. The visual difference between 5 years and 20 years of compounding is the most motivating thing you can show yourself.

Step 2: Audit what's compounding against you. Look at every revolving balance you carry — credit cards especially. Apply the Rule of 72 to each rate. A card at 22% doubles its balance in roughly 3.3 years with no payments. If any debt balance is compounding faster than your savings, prioritizing payoff before additional investing is almost always the mathematically correct move. Understanding the formula works in both directions helps you make that call clearly rather than emotionally.

Step 3: Set up a regular contribution. The compound interest formula for a lump sum is powerful. The annuity formula — adding consistent contributions monthly — is where most real wealth gets built. Even $100 per month matters. Set up an automatic transfer to a savings or investment account, and don't interrupt it. The Killik & Co YouTube channel illustrates exactly why the final years of a multi-decade compounding strategy produce more interest than all the early years combined. Starting earlier is better. Continuing consistently is what the math actually rewards.

The formula is simple. The discipline is the hard part. But now you have both the math and the framework to use it.

About the Author
Written by Varn Kutser
Personal finance writer covering savings, investing, and budgeting with a data-first approach. Every rate, limit, and claim is verified against official sources — FDIC, IRS, and Federal Reserve. No clickbait, no guesswork, just numbers.

Disclaimer: Rates and terms mentioned in this article are subject to change. Verify current rates directly with financial institutions before opening any account.

Last updated: April 21, 2026 · fabelo.io