Compound Interest Formula Explained: A Complete Breakdown
Disclaimer: This content is educational only and is not personalized financial, investment, tax, legal, or credit advice. Compound Interest Formula Explained: A Complete Breakdown
Disclaimer: This content is educational only and is not personalized financial, investment, tax, legal, or credit advice.
Compound Interest Formula Explained: A Complete Breakdown
The compound interest formula is one of the most useful equations you will ever learn — not because you need to run it by hand, but because understanding it reveals exactly why certain financial decisions are worth years of your life and others are expensive traps.
Once you understand what each variable does, you stop thinking about saving in abstract terms. You see money in motion — growing, compounding, multiplying. And you understand which levers actually move the needle.
This guide breaks the formula down completely: every variable, every compounding scenario, how to handle regular contributions, real step-by-step examples, and when to hand the math to a calculator.
Quick Answer
The compound interest formula is: A = P(1 + r/n)^(nt)
- A = Final amount
- P = Principal (starting amount)
- r = Annual interest rate (as a decimal)
- n = Compounding periods per year
- t = Time in years
Example: $10,000 at 7% compounded monthly for 20 years → A = 10,000 × (1 + 0.07/12)^(240) = $40,065
👉 Skip the math: [BankDeMark Compound Interest Calculator(/calculators/compound-interest-calculator)
1. The Formula: Full Breakdown
The Standard Compound Interest Formula
A = P(1 + r/n)^(nt)
This is the core equation. Every compound interest calculation — from a savings account earning 4.5% to a retirement portfolio compounding over 40 years — uses this formula or a variation of it.
Let's map each component:
| Symbol | Name | What It Represents |
|---|---|---|
| A | Accumulated amount | The total balance at the end of the period |
| P | Principal | The initial deposit or investment |
| r | Annual interest rate | The yearly rate as a decimal (7% = 0.07) |
| n | Compounding frequency | Times per year interest is calculated |
| t | Time | Number of years |
| (1 + r/n) | Growth factor per period | The multiplier applied each compounding period |
| ^(nt) | Exponent | Total number of compounding periods |
What the Exponent Does
The exponent (nt) is where the exponential magic lives. It is the total number of compounding periods — monthly compounding over 20 years means 240 periods (12 × 20). Each period, the growth factor multiplies the balance.
This is why compound interest accelerates over time: more compounding periods means more multiplications of a growing base.
2. What Each Variable Means — In Detail
P — Principal
The principal is your starting amount. In a savings account, it's your initial deposit. In an investment portfolio, it's your opening balance.
Key insight: The principal only sets the starting point. Its influence on the final balance diminishes over time relative to the compounding effect — which is why even modest principals can grow into substantial amounts given enough time.
r — Annual Interest Rate
The rate must be expressed as a decimal in the formula.
| Rate (%) | Decimal (r) |
|---|---|
| 3% | 0.03 |
| 5% | 0.05 |
| 7% | 0.07 |
| 8.5% | 0.085 |
| 10% | 0.10 |
| 22% | 0.22 |
Key insight: The rate is the most powerful short-term variable in the formula. Doubling the rate roughly more than doubles the outcome over long periods due to the exponential function. This is why fee differences — which effectively reduce your net return rate — compound into enormous dollar differences over time.
n — Compounding Frequency
This is how many times per year interest is calculated and added to your balance.
| Frequency | Value of n |
|---|---|
| Annually | 1 |
| Semi-annually | 2 |
| Quarterly | 4 |
| Monthly | 12 |
| Daily | 365 |
Key insight: More frequent compounding means slightly higher effective returns. But the impact is smaller than most people expect. The difference between monthly and daily compounding at 5% is marginal. Focus energy on rate and time, not compounding frequency.
t — Time in Years
Time is the exponent multiplier — it scales the number of compounding periods. At monthly compounding, 10 years = 120 periods. 40 years = 480 periods.
Key insight: Time is the most important variable over long horizons. Due to the exponential function, adding years to the end of an investment period produces the largest dollar gains. Removing years from the beginning (by starting late) causes the largest dollar losses.
3. Step-by-Step Calculation Walkthrough
Let's solve a real problem manually.
Problem: You deposit $8,000 in a high-yield savings account at 4.8% annual interest, compounded monthly. How much will you have in 5 years?
Step 1: Identify your variables
- P = 8,000
- r = 4.8% = 0.048
- n = 12 (monthly)
- t = 5
Step 2: Calculate r/n 0.048 ÷ 12 = 0.004
Step 3: Calculate 1 + r/n 1 + 0.004 = 1.004
Step 4: Calculate the exponent (n × t) 12 × 5 = 60
Step 5: Raise (1 + r/n) to the power of (nt) 1.004^60 = 1.2704 (you can use a calculator for this step)
Step 6: Multiply by P 8,000 × 1.2704 = $10,163
Step 7: Find interest earned $10,163 − $8,000 = $2,163 in interest
Your $8,000 deposit grows to $10,163 in 5 years at 4.8% monthly compounding.
4. Annual vs. Monthly vs. Daily Compounding
The same formula applies to all compounding frequencies — only the value of n changes.
The Three Key Variants
Annual compounding (n = 1):
A = P(1 + r)^t
Interest is added once per year. The formula simplifies because r/1 = r.
Monthly compounding (n = 12):
A = P(1 + r/12)^(12t)
Interest is calculated and added 12 times per year.
Daily compounding (n = 365):
A = P(1 + r/365)^(365t)
Interest is calculated and added 365 times per year.
Numerical Comparison
$20,000 at 6% for 15 years:
| Compounding | Formula Variable | Final Balance | Interest Earned |
|---|---|---|---|
| Annual | n = 1 | $47,946 | $27,946 |
| Quarterly | n = 4 | $48,729 | $28,729 |
| Monthly | n = 12 | $48,976 | $28,976 |
| Daily | n = 365 | $49,064 | $29,064 |
The difference between annual and daily compounding on $20,000 over 15 years is $1,118 — meaningful, but small relative to the total balance. The real action is in rate and time.
APY: The Number That Accounts for Compounding Frequency
APY (Annual Percentage Yield) already incorporates compounding frequency into a single comparable number. When comparing savings accounts, always compare APYs — it levels the playing field regardless of how often each account compounds.
APY formula: APY = (1 + r/n)^n − 1
A 4.8% rate compounded monthly has an APY of: (1 + 0.048/12)^12 − 1 = 1.004^12 − 1 = 4.907%
This means it performs slightly better than a 4.8% annually compounded account.
5. The Formula With Regular Deposits
The standard formula assumes one lump-sum deposit. Most real investors make regular contributions — monthly or annually. This requires a different formula.
Future Value of an Annuity Formula
For regular, equal deposits made at the end of each period:
FV = PMT × [((1 + r/n)^(nt) − 1) / (r/n)
Where:
- FV = Future value
- PMT = Regular payment amount
- r = Annual interest rate (decimal)
- n = Compounding periods per year
- t = Years
Combining Initial Principal + Regular Contributions
If you start with both an initial deposit AND make regular contributions, calculate each separately and add:
Total FV = FV of lump sum + FV of regular contributions
Total = P(1 + r/n)^(nt) + PMT × [((1 + r/n)^(nt) − 1) / (r/n)
Example: Starting With $5,000 and Adding $300/Month
- P = $5,000
- PMT = $300
- r = 7% = 0.07
- n = 12
- t = 25 years
FV of lump sum: 5,000 × (1 + 0.07/12)^(300) = 5,000 × (1.005833)^300 = 5,000 × 5.7205 = $28,602
FV of monthly contributions: 300 × [((1.005833)^300 − 1) / 0.005833 = 300 × [(5.7205 − 1) / 0.005833 = 300 × [4.7205 / 0.005833 = 300 × 809.2 = $242,760
Total balance: $28,602 + $242,760 = $271,362
You contributed $5,000 + ($300 × 300 months) = $5,000 + $90,000 = $95,000 of your own money. The rest — $176,362 — is compound interest.
This math is exactly why you should skip the manual calculation: [BankDeMark Compound Interest Calculator(/calculators/compound-interest-calculator) handles all of this instantly.
6. Continuous Compounding
Continuous compounding is the mathematical limit — what happens when interest compounds infinitely many times per second.
The Continuous Compounding Formula
A = Pe^(rt)
Where e is Euler's number ≈ 2.71828.
Example: $10,000 at 7% for 30 Years
Annual compounding: A = 10,000 × (1.07)^30 = $76,123 Monthly compounding: A = 10,000 × (1 + 0.07/12)^360 = $81,165 Continuous compounding: A = 10,000 × e^(0.07×30) = 10,000 × e^(2.1) = $81,451
The difference between monthly and continuous compounding is only $286 on $10,000 over 30 years. Continuous compounding is a mathematical concept used in finance theory and options pricing — not a feature offered by savings accounts or brokerages.
7. Simple Interest vs. Compound Interest Formula
Simple Interest Formula
I = P × r × t
A = P + (P × r × t) = P(1 + rt)
Simple interest is linear. The annual interest earned never changes — it is always the same percentage of the original principal.
Side-by-Side Formula Comparison
| Feature | Simple Interest | Compound Interest |
|---|---|---|
| Formula | A = P(1 + rt) | A = P(1 + r/n)^(nt) |
| Interest base | Only principal | Principal + prior interest |
| Growth shape | Linear | Exponential |
| $10K at 7% / 30 years | $31,000 | $76,123 |
| Difference | — | $45,123 more |
Simple interest is used for some short-term loans and bonds. For long-term savings and investment contexts, the term "interest" almost always implies compounding.
8. Compound Interest Formula in Excel and Google Sheets
You do not need to type the formula manually in Excel or Sheets. Use the built-in FV function.
FV Function Syntax
=FV(rate, nper, pmt, pv, [type)
- rate = Interest rate per period (annual rate ÷ n)
- nper = Total number of periods (n × t)
- pmt = Regular payment per period (use 0 if none, or a negative number for contributions)
- pv = Present value / starting amount (enter as a negative number)
Examples
$10,000 lump sum at 7% annually for 20 years:
=FV(0.07, 20, 0, -10000)
→ $38,697
$10,000 at 7% monthly compounding for 20 years:
=FV(0.07/12, 240, 0, -10000)
→ $40,065
$300/month for 30 years at 7%, monthly compounding (no initial deposit):
=FV(0.07/12, 360, -300, 0)
→ $365,991
$5,000 starting + $300/month for 25 years at 7%, monthly:
=FV(0.07/12, 300, -300, -5000)
→ $271,362
The negative signs represent cash outflows (money you are putting in). The result is a positive number representing the future value.
9. Real Calculation Examples
Example Set 1: Different Principals, Same Rate and Time
Assumptions: 7% annual rate, monthly compounding, 30 years, no additional contributions.
| Starting Principal | Final Balance | Interest Earned | Multiple of Principal |
|---|---|---|---|
| $1,000 | $8,117 | $7,117 | 8.1× |
| $5,000 | $40,584 | $35,584 | 8.1× |
| $10,000 | $81,165 | $71,165 | 8.1× |
| $25,000 | $202,913 | $177,913 | 8.1× |
| $50,000 | $405,825 | $355,825 | 8.1× |
Notice: compound interest applies the same multiplier regardless of principal. Every dollar invested grows at the same rate. There is no advantage to waiting to save "a bigger lump sum" — each dollar you invest today will grow to $8.10 in 30 years at these assumptions.
Example Set 2: Same Principal, Different Rates
Starting amount: $20,000. Monthly compounding. 25 years. No additional contributions.
| Annual Rate | Final Balance | Interest Earned |
|---|---|---|
| 3% | $41,978 | $21,978 |
| 5% | $70,106 | $50,106 |
| 7% | $114,550 | $94,550 |
| 8% | $146,305 | $126,305 |
| 10% | $234,835 | $214,835 |
The difference between 5% and 7% over 25 years on $20,000 is $44,444. This is why investment fees — which directly reduce your effective return rate — are worth minimizing aggressively.
Example Set 3: Same Everything, Different Time
Starting amount: $15,000. 7% annual rate, monthly compounding.
| Years | Final Balance | Interest Earned | Ratio (Interest/Principal) |
|---|---|---|---|
| 5 | $21,424 | $6,424 | 43% |
| 10 | $30,595 | $15,595 | 104% |
| 15 | $43,688 | $28,688 | 191% |
| 20 | $62,388 | $47,388 | 316% |
| 30 | $127,123 | $112,123 | 747% |
| 40 | $259,020 | $244,020 | 1,627% |
By year 40, the interest earned is over 16 times the original principal. The original $15,000 is a small fraction of the final balance — almost irrelevant compared to the compounding effect.
10. Common Formula Mistakes
Mistake 1: Forgetting to Convert Rate to Decimal
The most common error. Using 7 instead of 0.07 produces wildly wrong results.
- Wrong: A = 10,000 × (1 + 7/12)^(120) → completely incorrect
- Correct: A = 10,000 × (1 + 0.07/12)^(120) → $20,097
Mistake 2: Not Adjusting Rate for Compounding Frequency
When compounding monthly, divide the annual rate by 12 before applying it. The rate (r/n) is the per-period rate, not the annual rate.
Mistake 3: Using the Wrong Time Units
Time (t) must be in years. If you are calculating 18 months, use t = 1.5, not 18.
Mistake 4: Confusing APR and APY
APR (Annual Percentage Rate) does not account for compounding frequency. APY (Annual Percentage Yield) does. For comparing savings products, always use APY. For the formula, use APR (the stated rate) with the appropriate compounding frequency — the formula will naturally produce the APY result.
Mistake 5: Applying the Lump Sum Formula to Regular Contributions
The standard A = P(1 + r/n)^(nt) formula only works for a single deposit. If you are making regular contributions, you need the annuity formula or a calculator.
11. When to Use a Calculator Instead
The compound interest formula is important to understand — but you should almost always use a calculator for actual planning.
Use a calculator when:
- Making regular contributions (the annuity formula is unwieldy)
- Comparing multiple scenarios quickly
- Planning for specific financial goals (retirement, down payment, education)
- Modeling the impact of different contribution amounts or rates
The [BankDeMark Compound Interest Calculator(/calculators/compound-interest-calculator) handles:
- One-time deposits with any compounding frequency
- Regular monthly or annual contributions
- Any combination of initial deposit + regular contributions
- Side-by-side rate and time comparisons
- Graphical output showing the compounding curve
Additional tools:
- [Investment Calculator(/calculators/investment-calculator) — For portfolio growth projections
- [Retirement Calculator(/calculators/retirement-calculator) — For long-term retirement planning
- [TFSA Calculator(/calculators/tfsa-calculator) (Canada) — Tax-free compound growth
- [RRSP Calculator(/calculators/rrsp-calculator) (Canada) — Tax-deferred growth
12. Canada and USA Applications
Where the Formula Applies in Canada
TFSA: Compound interest operates on 100% of your gains — no annual tax drag. The formula gives exact results without adjustment.
RRSP: Pre-tax contributions compound without annual tax. The formula applies, but at withdrawal, tax is owed on the total balance (not just interest).
Non-registered accounts: Dividends are taxed annually in Canada, reducing the effective compounding rate. Use an after-tax return assumption in the formula (e.g., if expected return is 7% and marginal tax rate on dividends is 20%, effective compounding rate is approximately 5.6%).
High-yield savings accounts: The formula applies directly. Compare accounts using APY.
Where the Formula Applies in the USA
Roth IRA / 401(k): Compound interest operates tax-free or tax-deferred. The formula gives exact results for pre-tax growth projections.
Taxable brokerage accounts: Capital gains taxes apply when assets are sold, but unrealized appreciation compounds unimpeded. Use the formula for growth projections and model tax impact at withdrawal separately.
HYSA (High-Yield Savings Accounts): Interest is taxable as ordinary income in the USA each year, slightly reducing effective compounding. Factor in a modest tax-drag adjustment for accurate projections.
13. Key Takeaways
- The compound interest formula is A = P(1 + r/n)^(nt)
- Four variables drive the outcome: principal (P), rate (r), compounding frequency (n), and time (t)
- Time and rate have the largest impact; compounding frequency matters less than most people expect
- For regular contributions, use the annuity formula: FV = PMT × [((1 + r/n)^(nt) − 1) / (r/n)
- Annual, monthly, and daily compounding produce different results — but the difference is smaller than the difference a higher return rate makes
- The FV function in Excel/Sheets makes these calculations straightforward
- APY accounts for compounding frequency — use it to compare savings products accurately
- Never mistake the rate percentage for the decimal (7% ≠ 7 in the formula)
- All real-world planning should use a calculator — the formula is for understanding the mechanics
Run the Numbers on Your Situation The formula tells you how compound interest works. The calculator shows you exactly what it means for your money.
👉 [BankDeMark Compound Interest Calculator(/calculators/compound-interest-calculator)
Related resources:
- [Investment Calculator(/calculators/investment-calculator)
- [How Compound Interest Works: Complete Beginner Guide(/blog/how-compound-interest-works)
- [Daily vs. Monthly Compound Interest(/blog/daily-vs-monthly-compound-interest)
- [Compound Interest Examples: Real Numbers(/blog/compound-interest-examples)
- [Investing Pillar(/pillars/investing)
Frequently Asked Questions
What is the compound interest formula? 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 compounding periods per year, and t is years. To find interest earned, subtract principal: Interest = A − P.
What does each variable in the compound interest formula mean? P is your starting amount. r is the annual rate as a decimal (7% = 0.07). n is how many times per year interest compounds — 365 for daily, 12 for monthly, 4 for quarterly, 1 for annually. t is years. A is the total balance at the end.
How do you calculate compound interest monthly? Use A = P(1 + r/12)^(12t). Example: $5,000 at 6% monthly for 5 years: A = 5,000 × (1.005)^60 = $6,744. Interest = $1,744.
How is the compound interest formula different for regular contributions? Use the future value annuity formula: FV = PMT × [((1 + r/n)^(nt) − 1) / (r/n). It is complex manually — use the BankDeMark Compound Interest Calculator for instant results with any contribution schedule.
What is the difference between the compound interest and simple interest formulas? Simple interest: A = P(1 + rt) — interest only on original principal. Compound interest: A = P(1 + r/n)^(nt) — interest on principal plus accumulated interest. On $10,000 at 7% for 30 years, simple interest produces $31,000; compound interest produces $76,123.
Does compounding frequency matter in the formula? Yes, but less than most expect. At 5% over 10 years on $10,000: annual compounding = $16,289; daily = $16,487. The difference is $198. Rate and time are far more impactful variables.
How do I calculate compound interest in Excel? Use =FV(rate, nper, pmt, pv). Example for $10,000 at 7% monthly for 20 years: =FV(0.07/12, 240, 0, -10000) → $40,065.
What is the continuous compounding formula? A = Pe^(rt), where e ≈ 2.71828. At 7% for 30 years: A = 10,000 × e^(2.1) ≈ $81,451. Continuous compounding is a mathematical concept — real accounts use daily or monthly.
BankDeMark Editorial Team — Updated May 2026