Last Updated: February 2026 • 25 min read
Compound Interest Formula: Complete Guide with Every Variation
The compound interest formula is the mathematical engine behind wealth building. Whether you need the basic formula, the version with monthly contributions, continuous compounding, or CAGR, this guide walks you through every variation with step-by-step calculations you can follow. Use our compound interest calculator to run these formulas instantly with your own numbers.
- A = P(1 + r/n)^(nt) is the foundational compound interest formula
- Six key formulas cover every compound interest scenario you will encounter
- Each variable matters — small changes in rate or time produce large differences in results
- The formula with contributions adds a future value of annuity component
- Continuous compounding uses A = Pe^(rt) for theoretical maximum growth
- APY vs APR conversion lets you compare accounts with different compounding frequencies
- Use our compound interest calculator to run these formulas instantly
Formula 1: Basic Compound Interest
The standard compound interest formula calculates the future value of a lump-sum investment that compounds at regular intervals. This formula is the standard compound interest equation used in financial mathematics, as described by Investopedia. For a comprehensive overview of how compound interest works beyond just the formula, see our complete compound interest guide.
A = P(1 + r/n)^(nt)
Variable Definitions
| Variable | Meaning | Example |
|---|---|---|
| A | Future value (total amount including interest) | What you want to find |
| P | Principal (initial investment amount) | $10,000 |
| r | Annual interest rate (as a decimal) | 0.06 (for 6%) |
| n | Compounding periods per year | 12 (monthly), 365 (daily), 1 (annual) |
| t | Time in years | 10 |
Worked Example: $10,000 at 6% for 10 Years (Monthly Compounding)
A = 10,000(1 + 0.06/12)^(12 × 10)
A = 10,000(1 + 0.005)^120
A = 10,000(1.005)^120
A = 10,000 × 1.81940
A = $18,193.97
Your $10,000 grows to $18,193.97. The total interest earned is $18,193.97 - $10,000 = $8,193.97.
How the Formula Derives from Simple Interest
Simple interest uses the formula A = P(1 + rt), which adds interest linearly. Compound interest modifies this by dividing the rate into n periods (r/n), then raising to the total number of periods (nt). This creates exponential growth because each period's interest is calculated on the new, larger balance.
For a single compounding period (n=1, t=1), compound interest equals simple interest: A = P(1 + r). The difference emerges when n > 1 or t > 1, because accumulated interest starts earning its own interest. For a deeper comparison, see our simple vs. compound interest guide.
Understanding Each Variable in Depth
Mastering the compound interest formula requires a thorough understanding of what each variable represents and how it affects your calculations. As explained by Khan Academy's finance tutorials, each component plays a distinct role in determining your investment's growth trajectory.
Principal (P): Your Starting Point
The principal represents your initial investment before any interest accrues. This is the foundation upon which all compound growth builds. Whether it is $1,000 in a savings account or $100,000 in a retirement fund, the principal establishes the base amount that will multiply over time. The larger your principal, the more absolute dollars you earn in interest, though the percentage return remains the same. Many investors focus on building a larger principal through strategies like lump-sum investing from bonuses, inheritance, or tax refunds.
Interest Rate (r): The Growth Multiplier
The interest rate must always be expressed as a decimal in the formula. Convert percentages by dividing by 100: a 7.5% rate becomes 0.075. This rate represents the annual percentage rate (APR) before accounting for compounding frequency. The rate has a dramatic exponential effect on long-term growth—even a 1% difference can translate to tens of thousands of dollars over a 30-year period. Historical stock market returns average around 10% nominally, while high-yield savings accounts currently offer 4-5% APY.
Compounding Frequency (n): The Acceleration Factor
The variable n determines how often interest gets added to your principal within a year. Common compounding frequencies include:
| Frequency | n Value | Interest Added | Common Uses |
|---|---|---|---|
| Annually | 1 | Once per year | Some bonds, basic loans |
| Semi-annually | 2 | Every 6 months | Corporate bonds, some CDs |
| Quarterly | 4 | Every 3 months | Dividends, some savings accounts |
| Monthly | 12 | Every month | Most savings accounts, mortgages |
| Daily | 365 | Every day | High-yield savings, credit cards |
| Continuous | ∞ | Infinitely often | Theoretical/academic use |
More frequent compounding means interest begins earning its own interest sooner, accelerating growth. However, the difference between daily and monthly compounding is minimal compared to the difference between annual and monthly compounding.
Time (t): The Most Powerful Variable
Time in years is the exponent's multiplier, making it the most powerful factor in the formula. Because compound interest is exponential, doubling your time horizon does more than double your returns. A $10,000 investment at 7% grows to $19,672 in 10 years, $38,697 in 20 years, and $76,123 in 30 years. This mathematical reality explains why financial advisors consistently emphasize starting early—time cannot be bought, borrowed, or recovered once it has passed.
Formula 2: Compound Interest with Regular Contributions
Most investors don't just make a one-time deposit. The formula expands to include periodic monthly contributions using the future value of an annuity. Understanding this variation is essential for anyone building a long-term savings or investment plan:
A = P(1 + r/n)^(nt) + PMT × [((1 + r/n)^(nt) - 1) / (r/n)]
Where PMT is the contribution per period. If you contribute monthly and compounding is monthly, PMT is your monthly deposit amount.
For Beginning-of-Period Contributions (Annuity Due)
A = P(1 + r/n)^(nt) + PMT × [((1 + r/n)^(nt) - 1) / (r/n)] × (1 + r/n)
The only difference is the extra (1 + r/n) multiplier, which accounts for each contribution earning one additional period of interest.
Worked Example: $5,000 Initial + $300/Month at 7% for 25 Years
P = 5,000, PMT = 300, r = 0.07, n = 12, t = 25
A = 5,000(1 + 0.07/12)^(300) + 300 × [((1.005833)^300 - 1) / 0.005833]
A = 5,000 × 5.72712 + 300 × 810.07
A = 28,635.62 + 243,021.49
A = $271,657.11
Total contributed: $5,000 + ($300 × 300) = $95,000. Interest earned: $271,657.11 - $95,000 = $176,657.11. That means 65% of the final balance came from compound interest alone.
Multiple Worked Examples: Different Scenarios
Understanding the compound interest formula becomes clearer when you see it applied to various real-world situations. The following examples demonstrate how different combinations of principal, rate, time, and contributions affect outcomes. For more detailed scenarios, explore our compound interest examples guide.
Example 1: Emergency Fund in a High-Yield Savings Account
Scenario: You deposit $15,000 into a high-yield savings account offering 4.5% APY, compounded daily. How much will you have after 3 years?
A = 15,000(1 + 0.045/365)^(365 × 3)
A = 15,000(1.000123)^1095
A = 15,000 × 1.14427
A = $17,164.05
Your emergency fund earns $2,164.05 in interest while remaining fully liquid and FDIC insured.
Example 2: Retirement Savings with Employer Match
Scenario: You contribute $500/month to your 401(k), your employer matches 50% ($250/month), and you expect 8% annual returns over 35 years. Starting balance: $0.
A = 0(1 + 0.08/12)^(420) + 750 × [((1.00667)^420 - 1) / 0.00667]
A = 0 + 750 × [15.968 - 1) / 0.00667]
A = 750 × 2,244.99
A = $1,683,742.50
Total contributed: $750 × 420 = $315,000. Interest earned: $1,368,742.50. The employer match and compound interest transform modest monthly savings into a substantial retirement fund.
Example 3: College Savings (529 Plan)
Scenario: You start a 529 plan for your newborn with $2,500 and add $200/month. Assuming 6% returns, what will be available when they turn 18?
A = 2,500(1.005)^216 + 200 × [((1.005)^216 - 1) / 0.005]
A = 2,500 × 2.9281 + 200 × 385.62
A = 7,320.25 + 77,124.00
A = $84,444.25
Total invested: $2,500 + ($200 × 216) = $45,700. Growth from compound interest: $38,744.25.
| Scenario | Initial | Monthly | Rate | Years | Final Value | Total Invested | Interest Earned |
|---|---|---|---|---|---|---|---|
| Emergency Fund | $15,000 | $0 | 4.5% | 3 | $17,164 | $15,000 | $2,164 |
| 401(k) with Match | $0 | $750 | 8% | 35 | $1,683,743 | $315,000 | $1,368,743 |
| 529 College Savings | $2,500 | $200 | 6% | 18 | $84,444 | $45,700 | $38,744 |
| Short-Term Goal | $5,000 | $400 | 5% | 5 | $33,604 | $29,000 | $4,604 |
| Aggressive Growth | $25,000 | $1,000 | 10% | 20 | $895,842 | $265,000 | $630,842 |
Formula 3: Continuous Compounding
Continuous compounding represents the mathematical limit as the number of compounding periods approaches infinity. It uses Euler's number (e ≈ 2.71828):
A = Pe^(rt)
This formula is derived by taking the limit of (1 + r/n)^(nt) as n approaches infinity, which equals e^(rt).
Worked Example: $10,000 at 5% for 10 Years (Continuous)
A = 10,000 × e^(0.05 × 10)
A = 10,000 × e^0.5
A = 10,000 × 1.64872
A = $16,487.21
Compare this to daily compounding ($16,486.65) — the difference is only $0.56 over 10 years. Continuous compounding is mainly used in theoretical finance and options pricing (the Black-Scholes model), not in everyday banking.
The Mathematics Behind Continuous Compounding
The continuous compounding formula emerges from a fundamental limit in calculus. As compounding frequency increases toward infinity, the expression (1 + r/n)^n approaches e^r, where e is Euler's number (approximately 2.71828). This mathematical constant appears throughout nature and mathematics, from population growth models to radioactive decay.
The derivation involves the limit definition: e = lim(n→∞)(1 + 1/n)^n. Substituting r/n for the rate per period and taking the limit yields the elegant formula A = Pe^(rt). While no real-world financial institution compounds continuously, this formula serves as the theoretical upper bound for compound growth and is essential in:
- Options pricing: The Black-Scholes model uses continuous compounding for theoretical option values
- Bond mathematics: Zero-coupon bond pricing often uses continuous compounding
- Academic finance: Many theoretical models assume continuous compounding for mathematical convenience
- Actuarial science: Insurance calculations sometimes use continuous models
Continuous vs. Discrete Compounding Comparison
| $10,000 at 6% for 10 Years | Compounding Frequency | Final Value | Difference from Annual |
|---|---|---|---|
| Annual | n = 1 | $17,908.48 | $0.00 |
| Semi-annual | n = 2 | $18,061.11 | $152.63 |
| Quarterly | n = 4 | $18,140.18 | $231.70 |
| Monthly | n = 12 | $18,193.97 | $285.49 |
| Daily | n = 365 | $18,220.44 | $311.96 |
| Continuous | n → ∞ | $18,221.19 | $312.71 |
The table demonstrates diminishing returns as compounding frequency increases. Moving from annual to monthly adds $285.49, but moving from daily to continuous adds only $0.75.
Formula 4: Future Value of Annuity (Monthly Contributions Only)
When you want to calculate the growth of regular contributions without an initial principal, you use the future value of an ordinary annuity formula. This is the second component of the full contribution formula, isolated for clarity:
FV = PMT × [((1 + r/n)^(nt) - 1) / (r/n)]
This formula calculates how much your regular contributions will grow to, assuming each payment is made at the end of each period. The SEC's investor education resources emphasize the importance of understanding this formula for retirement planning.
Understanding the Annuity Factor
The bracketed portion [((1 + r/n)^(nt) - 1) / (r/n)] is called the "future value annuity factor" or "annuity accumulation factor." It represents the total multiplier applied to each payment after accounting for all the compounding periods. Financial calculators and spreadsheets often have this built in as the FV function.
Worked Example: $500/Month for 30 Years at 7%
FV = 500 × [((1 + 0.07/12)^(360) - 1) / (0.07/12)]
FV = 500 × [((1.005833)^360 - 1) / 0.005833]
FV = 500 × [(8.1165 - 1) / 0.005833]
FV = 500 × 1,219.97
FV = $609,985.00
Total contributed: $500 × 360 = $180,000. Interest earned: $429,985.00. Your contributions more than tripled due to compound interest.
Annuity Due vs. Ordinary Annuity
The formula above assumes payments at the end of each period (ordinary annuity). If you make payments at the beginning of each period (annuity due), multiply the result by (1 + r/n):
FV = PMT × [((1 + r/n)^(nt) - 1) / (r/n)] × (1 + r/n)
For the same $500/month example above, an annuity due yields: $609,985.00 × 1.005833 = $613,543.67. The extra $3,558.67 comes from each payment having one additional month to compound.
Formula 5: CAGR (Compound Annual Growth Rate)
The CAGR formula works in reverse: given a starting value, ending value, and time period, it tells you the annualized growth rate:
CAGR = (Ending Value / Beginning Value)^(1/t) - 1
Worked Example: Investment Grew from $10,000 to $25,000 in 8 Years
CAGR = (25,000 / 10,000)^(1/8) - 1
CAGR = (2.5)^0.125 - 1
CAGR = 1.12135 - 1
CAGR = 0.12135 = 12.14%
CAGR smooths out year-to-year volatility and gives you a single annualized rate. CAGR is widely used by investment professionals and is featured in SEC educational materials as a standardized measure of investment performance. It is the standard way to compare investment performance across different time periods and asset classes. Note that CAGR differs from average annual return when returns are volatile.
Formula 6: APY vs APR Formulas and Conversions
Understanding the difference between APY (Annual Percentage Yield) and APR (Annual Percentage Rate) is crucial for comparing financial products accurately. For a comprehensive exploration, see our APY vs APR explained guide.
APY = (1 + r/n)^n - 1
Where r is the APR (stated annual rate) and n is the compounding frequency.
APR = n × [(1 + APY)^(1/n) - 1]
Worked Example: 5% APR Compounded Daily
APY = (1 + 0.05/365)^365 - 1
APY = (1.000137)^365 - 1
APY = 1.05127 - 1
APY = 0.05127 = 5.127%
A 5.00% APR with daily compounding yields 5.127% APY. The higher the base rate and the more frequent the compounding, the larger the gap between APR and APY. Banks are required by the Truth in Savings Act (Regulation DD) to disclose APY to consumers. Always compare APY when evaluating savings accounts or CDs.
When to Use Each Metric
- APY for savings: Always compare savings accounts, CDs, and money market accounts using APY
- APR for loans: Loan costs are typically expressed as APR, though the true cost depends on compounding
- Credit cards: Compare using APR, but remember daily compounding makes effective rate higher
APR to APY Conversion Table
| APR | Compounded Monthly (APY) | Compounded Daily (APY) | Continuous (APY) |
|---|---|---|---|
| 3.00% | 3.042% | 3.045% | 3.046% |
| 4.00% | 4.074% | 4.081% | 4.082% |
| 5.00% | 5.116% | 5.127% | 5.127% |
| 6.00% | 6.168% | 6.183% | 6.184% |
| 7.00% | 7.229% | 7.250% | 7.251% |
| 8.00% | 8.300% | 8.328% | 8.329% |
| 10.00% | 10.471% | 10.516% | 10.517% |
| 12.00% | 12.683% | 12.747% | 12.750% |
Formula 7: Rule of 72
The Rule of 72 is a quick estimation formula for determining how long it takes an investment to double:
Years to Double ≈ 72 / Annual Interest Rate
Why 72?
The exact formula for doubling time is ln(2)/ln(1+r), which equals approximately 0.6931/r for small r. Multiplying both numerator and denominator by 100 gives 69.31/rate. The number 72 is used instead because it is divisible by more numbers (2, 3, 4, 6, 8, 9, 12) making mental math easier, and it provides slightly better accuracy for rates in the 6-10% range that most investors encounter.
| Rate | Rule of 72 | Exact (ln2/ln(1+r)) | Error |
|---|---|---|---|
| 2% | 36.0 years | 35.0 years | +2.9% |
| 5% | 14.4 years | 14.2 years | +1.4% |
| 7% | 10.3 years | 10.2 years | +0.5% |
| 10% | 7.2 years | 7.3 years | -0.9% |
| 15% | 4.8 years | 5.0 years | -3.6% |
Solving for Different Variables
The basic formula can be rearranged to solve for any unknown variable:
Solving for Principal (How Much to Invest Now)
P = A / (1 + r/n)^(nt)
Example: To have $50,000 in 15 years at 6% compounded monthly: P = 50,000 / (1.005)^180 = 50,000 / 2.45409 = $20,374.16
Solving for Rate (What Return Do I Need?)
r = n[(A/P)^(1/nt) - 1]
Example: To grow $10,000 to $30,000 in 12 years with monthly compounding: r = 12[(30,000/10,000)^(1/144) - 1] = 12[3^(0.00694) - 1] = 12 × 0.00766 = 9.19%
Solving for Time (How Long Will It Take?)
t = ln(A/P) / (n × ln(1 + r/n))
Example: How long for $15,000 to reach $40,000 at 7% compounded monthly: t = ln(40,000/15,000) / (12 × ln(1.005833)) = ln(2.6667) / (12 × 0.005816) = 0.9808 / 0.06979 = 14.05 years
Complete Formula Reference Table
This comprehensive table summarizes every compound interest formula covered in this guide, along with when to use each one:
| Formula Name | Formula | When to Use | Key Variables |
|---|---|---|---|
| Basic Compound Interest | A = P(1 + r/n)^(nt) | One-time deposits, CDs, savings accounts | A = future value, P = principal |
| With Contributions | A = P(1 + r/n)^(nt) + PMT[(1 + r/n)^(nt) - 1]/(r/n) | Regular savings plans, 401(k), IRA | PMT = periodic payment |
| Continuous Compounding | A = Pe^(rt) | Theoretical finance, options pricing | e = Euler's number (2.71828) |
| Future Value of Annuity | FV = PMT[(1 + r/n)^(nt) - 1]/(r/n) | Regular contributions without initial deposit | FV = future value of contributions only |
| CAGR | CAGR = (FV/PV)^(1/t) - 1 | Analyzing past investment performance | FV = ending value, PV = starting value |
| APY from APR | APY = (1 + r/n)^n - 1 | Comparing accounts with different compounding | r = stated APR, n = compounding frequency |
| APR from APY | APR = n[(1 + APY)^(1/n) - 1] | Reverse APY conversion | APY = effective annual yield |
| Rule of 72 | Years to Double = 72 / rate | Quick mental estimates | Rate expressed as whole number (use 6, not 0.06) |
| Present Value | P = A / (1 + r/n)^(nt) | How much to invest now for future goal | Rearranged basic formula |
| Required Rate | r = n[(A/P)^(1/nt) - 1] | What return needed to reach goal | Rearranged basic formula |
| Time to Goal | t = ln(A/P) / [n × ln(1 + r/n)] | How long to reach target amount | Uses natural logarithm (ln) |
Using These Formulas in Spreadsheets
You can implement all compound interest formulas in Excel or Google Sheets:
| Calculation | Excel/Sheets Formula |
|---|---|
| Future Value (basic) | =P*(1+r/n)^(n*t) |
| Future Value (with PMT) | =FV(r/n, n*t, -PMT, -P) |
| Present Value | =PV(r/n, n*t, -PMT, FV) |
| Required Payment | =PMT(r/n, n*t, -P, FV) |
| CAGR | =(EndValue/StartValue)^(1/Years)-1 |
| APY from APR | =(1+APR/n)^n-1 |
| Continuous compounding | =P*EXP(r*t) |
The built-in FV() function is the most convenient for calculations with contributions. Note that Excel uses negative signs for cash outflows (deposits), so you prefix P and PMT with a minus sign.
How Each Variable Impacts Your Results
Understanding the relative importance of each variable helps you focus your financial strategy on the factors that matter most.
The Sensitivity of Time (t)
Time is the most powerful variable in the compound interest formula. Doubling your investment period does far more than doubling your interest rate. Here is why:
| Scenario | Principal | Rate | Time | Final Balance | Interest Earned |
|---|---|---|---|---|---|
| Base case | $10,000 | 6% | 20 years | $33,102 | $23,102 |
| Double the rate | $10,000 | 12% | 20 years | $107,652 | $97,652 |
| Double the time | $10,000 | 6% | 40 years | $109,564 | $99,564 |
| Double the principal | $20,000 | 6% | 20 years | $66,205 | $46,205 |
Doubling the time period from 20 to 40 years produces almost the same result as doubling the interest rate. Both outperform simply doubling the starting principal. This mathematical reality is why financial advisors emphasize starting early above all else.
The Rate-Frequency Interaction
Higher interest rates magnify the benefit of more frequent compounding. At 2% annually, switching from annual to daily compounding adds just $2 per year on $10,000. At 12%, the same switch adds $63 per year. This interaction matters for high-yield environments: when rates are elevated, the compounding frequency on your savings accounts and CDs becomes a more significant factor.
When Contributions Dominate
For most working professionals, the contribution term (PMT) eventually dominates the formula. If you start with $5,000 and add $500 per month at 7% for 30 years, your final balance is approximately $612,438. Of that, only $30,024 came from compounding on the original $5,000. The remaining $582,414 came from your contributions and the compound growth on those contributions. This demonstrates why consistently increasing your savings rate matters more than chasing higher returns once you have built the habit.
Common Mistakes When Using the Formula
1. Forgetting to Convert the Rate to a Decimal
The formula uses r as a decimal: 7% = 0.07, not 7. Using 7 instead of 0.07 will give you absurdly large results.
2. Mismatching Compounding Frequency and Contribution Frequency
If contributions are monthly but compounding is daily, you need to adjust the contribution formula. The simplest approach is to use monthly compounding (n=12) when calculating monthly contributions, which gives a very close approximation.
3. Using the Wrong n Value
Common n values: daily = 365, monthly = 12, quarterly = 4, semi-annually = 2, annually = 1. Using the wrong n changes your result significantly over long periods.
4. Ignoring Inflation
The formula gives nominal (not inflation-adjusted) results. To estimate real returns, subtract the expected inflation rate from your interest rate before calculating, or apply the formula separately for inflation adjustment.
5. Assuming Constant Returns
The formula assumes a fixed interest rate. Real investments like stocks have variable returns. The formula gives you what a constant rate would produce, which is useful for planning but not a guarantee.
6. Confusing Total Return with Interest Rate
When using the formula for stock market projections, people often use the total return figure (e.g., 10% for the S&P 500) without accounting for inflation. The formula works with whatever rate you input, so if you want inflation-adjusted projections, use a real return rate (typically 6-7% for equities). Using nominal returns produces nominal future values that overstate purchasing power.
7. Forgetting About Taxes
The compound interest formula calculates gross returns. In taxable accounts, interest and investment gains are subject to federal and state taxes. A 5% return in a taxable account for someone in the 24% federal bracket yields an after-tax return of approximately 3.8%. For long-term planning, it's more realistic to apply an after-tax rate in the formula, unless you're modeling tax-advantaged accounts like 401(k)s or Roth IRAs where compounding occurs on the full pre-tax or tax-free amount.
Choosing the Right Formula for Your Situation
With six formulas available, selecting the right one depends on your specific scenario:
- One-time investment, fixed rate: Use the basic formula A = P(1 + r/n)^(nt). This applies to CDs, savings accounts, or modeling a lump-sum investment.
- Regular deposits over time: Use the contribution formula with PMT. This fits 401(k) contributions, monthly savings plans, or any scenario with recurring deposits.
- Theoretical or academic analysis: Use continuous compounding A = Pe^(rt). This is standard in options pricing, mathematical modeling, and physics applications.
- Evaluating past performance: Use CAGR = (FV/PV)^(1/t) - 1. This works for comparing investments, analyzing portfolio returns, or benchmarking against an index.
- Comparing financial products: Use APY = (1 + r/n)^n - 1. This normalizes different compounding frequencies into a single comparable number.
- Quick mental estimates: Use the Rule of 72. This requires no calculator and gives surprisingly accurate results for rates between 5% and 12%.
In practice, most personal finance calculations only require the first two formulas. The basic formula handles existing savings, and the contribution formula handles ongoing investment plans. Our compound interest calculator implements all six and lets you switch between them with a single click.
Frequently Asked Questions
A is the future value (what your investment will be worth). P is the principal (your initial deposit). r is the annual interest rate as a decimal (5% = 0.05). n is how many times interest compounds per year (12 for monthly, 365 for daily). t is the number of years. Multiply them together as shown to calculate how any investment grows over time.
The mathematically precise number is closer to 69.3 (which is 100 × ln(2)). However, 72 is used because it is divisible by 2, 3, 4, 6, 8, 9, and 12, making mental division much easier. It also provides better accuracy for interest rates in the 6-10% range, which are the most common rates investors encounter. For rates below 4%, the Rule of 69.3 is more accurate.
Use the combined formula: A = P(1 + r/n)^(nt) + PMT × [((1 + r/n)^(nt) - 1) / (r/n)]. The first part calculates growth on your initial deposit. The second part (the future value of an annuity) calculates the accumulated value of all your monthly contributions. Set n = 12 for monthly compounding and PMT to your monthly deposit amount. Or simply use our calculator's Monthly tab to do it instantly.
The compound interest formula (A = P(1 + r/n)^(nt)) calculates the future value given a known rate. The CAGR formula ((FV/PV)^(1/t) - 1) works in reverse, calculating the rate given known starting and ending values. They are algebraic rearrangements of the same underlying concept. Use compound interest to project forward, and CAGR to analyze past performance. Learn more in our CAGR guide.
For basic compound interest, type: =P*(1+r/n)^(n*t), replacing variables with cell references or numbers. For calculations with contributions, use Excel's built-in =FV(rate, nper, pmt, pv) function. For example, =FV(0.07/12, 12*20, -500, -10000) calculates the future value of $10,000 initial plus $500/month at 7% over 20 years. Note the negative signs for cash outflows.
The basic compound interest formula shows how a loan balance grows if no payments are made. For amortized loans (mortgages, car loans) where you make regular payments, you need the loan payment formula: PMT = P × [r(1+r)^n] / [(1+r)^n - 1]. This calculates the fixed payment that fully pays off the loan over n periods. Credit card debt is a case where compound interest works against you if you only make minimum payments.
APR (Annual Percentage Rate) is the stated rate before accounting for compounding. APY (Annual Percentage Yield) is the effective rate after compounding. Convert APR to APY with: APY = (1 + APR/n)^n - 1. For example, 5% APR compounded monthly equals 5.116% APY. Always compare savings accounts using APY for an apples-to-apples comparison. See our complete APY vs APR guide for details.
Continuous compounding (A = Pe^rt) is the mathematical limit as compounding frequency approaches infinity, while daily compounding uses n = 365. The practical difference is minimal: $10,000 at 5% for 10 years yields $16,486.65 daily vs. $16,487.21 continuous—a difference of just $0.56. Continuous compounding is mainly used in academic finance and options pricing models like Black-Scholes. For more details, see our continuous compounding guide.
Yes, the formula can be algebraically rearranged. To solve for time: t = ln(A/P) / (n × ln(1 + r/n)). To solve for rate: r = n[(A/P)^(1/nt) - 1]. To solve for principal: P = A / (1 + r/n)^(nt). These rearrangements help answer questions like "How long until I reach $100,000?" or "What return do I need to double my money in 10 years?"
The future value of annuity formula is FV = PMT × [((1 + r/n)^(nt) - 1) / (r/n)]. Use this when you want to calculate the growth of regular contributions without an initial lump sum. For example, if you start contributing $500/month at age 25 with no initial savings, this formula tells you what you will have at retirement. It is the second component of the full compound interest formula with contributions.