Compound Interest Calculator: Daily, Monthly, Quarterly & Annual Compounding
Calculate compound interest on any investment with our free calculator. Choose your compounding frequency, add monthly deposits, and instantly see growth charts, a frequency comparison table, and a year-by-year schedule. Includes the Rule of 72 and a compound vs. simple interest comparison.
What Is Compound Interest?
Albert Einstein reportedly called compound interest "the eighth wonder of the world. He who understands it, earns it; he who doesn't, pays it." Whether or not Einstein actually said this, the sentiment is undeniably true: compound interest is the single most powerful force in personal finance and investing.
Compound interest is the process of earning interest on both your original principal and on the interest that has already been added to your balance. Unlike simple interest, which is calculated only on the initial deposit, compound interest creates an exponential growth curve that accelerates over time.
For example, imagine you deposit $10,000 into an account that earns 6% per year, compounded annually. After Year 1, you earn $600 in interest, bringing your balance to $10,600. In Year 2, you earn 6% on the full $10,600 — that's $636, not just $600. By Year 3, you earn $674.16. Each year, the amount of interest grows because the base on which it's calculated keeps increasing. After 30 years, your original $10,000 grows to $57,434.91 — more than five times your initial investment — with no additional deposits at all.
Compound interest works for you when you're saving or investing, and against you when you're borrowing. Credit cards, for instance, charge compound interest on unpaid balances, which is why carrying a balance can be so costly. Understanding how compounding works is essential for making informed decisions about savings accounts, certificates of deposit (CDs), retirement accounts, student loans, and mortgages.
Compound Interest Formula
The standard formula for calculating compound interest is:
Where:
- FV = Future Value (the amount you'll have after interest)
- PV = Present Value or initial principal
- r = Annual nominal interest rate (as a decimal, e.g. 6% = 0.06)
- m = Number of compounding periods per year (1 = annually, 4 = quarterly, 12 = monthly, 365 = daily)
- n = Number of years
When you make regular monthly deposits (PMT), the formula extends to include a future value of annuity component:
Where i = r/m is the interest rate per compounding period, and N = m × n is the total number of compounding periods.
The total compound interest earned is simply: Interest = FV − PV − Total Deposits.
How Compounding Frequency Affects Your Returns
The number of times interest is compounded per year has a direct impact on how much your money grows. More frequent compounding means interest is calculated and added to your balance more often, so each subsequent calculation uses a slightly larger base.
Consider $10,000 invested at 6% annual rate for 10 years with no additional deposits:
| Compounding | Periods/Year | Future Value | Interest Earned | APY |
|---|---|---|---|---|
| Annually | 1 | $17,908.48 | $7,908.48 | 6.000% |
| Semi-Annually | 2 | $18,061.11 | $8,061.11 | 6.090% |
| Quarterly | 4 | $18,140.18 | $8,140.18 | 6.136% |
| Monthly | 12 | $18,193.97 | $8,193.97 | 6.168% |
| Daily | 365 | $18,220.44 | $8,220.44 | 6.183% |
| Continuously | ∞ | $18,221.19 | $8,221.19 | 6.184% |
Key observations from this table:
- Moving from annual to monthly compounding adds $285.49 in extra interest over 10 years.
- The jump from monthly to daily adds only $26.47 — diminishing returns as frequency increases.
- Daily and continuous compounding are nearly identical in practice (only $0.75 difference).
- Over longer periods (e.g. 30 years), these differences compound further: annual gives $57,435 while monthly gives $60,226 — a gap of nearly $2,800.
Most savings accounts and CDs compound daily or monthly. When comparing financial products, always look at the APY (not the APR) to see the true annual return after compounding.
Compound Interest vs Simple Interest
Understanding the difference between simple and compound interest is fundamental to financial literacy.
Simple interest is calculated only on the original principal:
Compound interest is calculated on the principal plus all accumulated interest:
| Aspect | Simple Interest | Compound Interest |
|---|---|---|
| Calculation Base | Original principal only | Principal + accumulated interest |
| Growth Pattern | Linear (straight line) | Exponential (accelerating curve) |
| Formula | FV = PV(1 + rn) | FV = PV(1 + r/m)mn |
| $10,000 at 6%, 10 yrs | $16,000.00 | $18,193.97 (monthly) |
| $10,000 at 6%, 30 yrs | $28,000.00 | $60,225.75 (monthly) |
| Common Uses | Short-term loans, car loans, some bonds | Savings accounts, CDs, mortgages, credit cards, investments |
| Benefit to Saver | Lower returns | Higher returns (interest on interest) |
The gap widens dramatically over time. At 6% over 10 years, compound interest yields $2,193.97 more than simple interest on a $10,000 deposit. Over 30 years, that advantage explodes to $32,225.75. This exponential divergence is why starting to invest early — even with small amounts — has such an outsized impact on long-term wealth building.
Use the calculator above and switch to the "Compound vs Simple" line chart to visualize this difference for your specific inputs.
The Rule of 72: Quick Doubling Time Estimate
The Rule of 72 is a simple yet powerful mental math shortcut used by investors and financial advisors to quickly estimate how long it will take for an investment to double in value at a given fixed annual rate of return.
For example:
| Annual Rate | Rule of 72 Estimate | Actual Doubling Time | Error |
|---|---|---|---|
| 2% | 36.0 years | 35.0 years | +1.0 yr |
| 4% | 18.0 years | 17.7 years | +0.3 yr |
| 6% | 12.0 years | 11.9 years | +0.1 yr |
| 8% | 9.0 years | 9.0 years | 0.0 yr |
| 10% | 7.2 years | 7.3 years | −0.1 yr |
| 12% | 6.0 years | 6.1 years | −0.1 yr |
The Rule of 72 is most accurate for interest rates between 6% and 10%. For lower rates (below 4%), the Rule of 69.3 (using 69.3 instead of 72) provides slightly better accuracy because 69.3 is the natural logarithm of 2 times 100.
You can also use the rule in reverse: if you want to double your money in 10 years, you need a return of approximately 72 ÷ 10 = 7.2% per year.
Compound Interest Examples
Example 1: High-Yield Savings Account
You deposit $5,000 into a high-yield savings account offering 4.5% APY compounded daily, and add $200 per month for 5 years.
PMT portion: $200/month × annuity factor = $13,322.18
Total FV = $19,584.59
- Total deposits: $5,000 + ($200 × 60) = $17,000
- Total interest earned: $2,584.59
Example 2: Long-Term Index Fund Investment
You invest $20,000 in an S&P 500 index fund with a historical average return of 10% annually, compounded monthly, and contribute $500/month for 25 years.
PMT portion: $500/month × annuity factor = $662,507.79
Total FV = $898,766.72
- Total invested: $20,000 + ($500 × 300) = $170,000
- Total interest: $728,766.72 — more than 4x what you contributed!
Example 3: The Power of Starting Early
Compare two investors who each invest $300/month at 8% compounded monthly:
| Investor | Starts At | Stops At | Years | Total Contributed | FV at Age 65 |
|---|---|---|---|---|---|
| Alice | Age 25 | Age 65 | 40 | $144,000 | $1,054,275 |
| Bob | Age 35 | Age 65 | 30 | $108,000 | $447,107 |
Alice invests only $36,000 more than Bob but ends up with $607,168 more at retirement. Those extra 10 years of compounding more than doubled her final balance. This is why financial advisors consistently emphasize: start investing as early as possible.
Continuous Compounding
Continuous compounding is the mathematical limit of compounding frequency — as if interest is compounded an infinite number of times per year, every instant. While no real bank compounds continuously, this concept is widely used in financial modeling, options pricing (the Black-Scholes model), and academic finance.
The formula for continuous compounding uses Euler's number e (≈ 2.71828):
Where:
- e = Euler's number (≈ 2.71828...)
- r = Annual interest rate (decimal)
- n = Number of years
Example: $10,000 at 6% continuously compounded for 10 years:
Compare this to daily compounding ($18,220.44) — the difference is only $0.75. In practice, daily compounding approximates continuous compounding very closely, which is why continuous compounding serves primarily as a theoretical benchmark.
The continuously compounded return can also be converted to its effective annual rate: EAR = er − 1. For a 6% continuously compounded rate: EAR = e0.06 − 1 = 6.184%.
How to Calculate Compound Interest in Excel
Microsoft Excel and Google Sheets offer built-in functions that make compound interest calculations straightforward. Here are the two most useful functions:
The FV Function
Use Excel's FV() function to calculate the future value of an investment with compound interest and optional periodic deposits:
- rate — Interest rate per period (e.g., 6%/12 = 0.5% for monthly compounding)
- nper — Total number of compounding periods (e.g., 10 years × 12 = 120)
- pmt — Monthly deposit (enter as negative for cash outflows)
- pv — Present value / principal (enter as negative)
- type — 0 = end of period, 1 = beginning of period
=FV(0.06/12, 120, -100, -10000, 0)This calculates the future value of $10,000 with $100 monthly deposits at 6% compounded monthly for 10 years. Result: $34,550.99
The EFFECT Function
Use EFFECT() to convert a nominal annual rate (APR) to an effective annual rate (APY) based on compounding frequency:
- nominal_rate — The stated annual rate (e.g., 6%)
- npery — Number of compounding periods per year
=EFFECT(0.06, 12) returns 0.06168 (or 6.168%), which is the effective annual rate for a 6% nominal rate compounded monthly. Use =EFFECT(0.06, 365) for daily compounding: returns 6.183%.
For Google Sheets, both functions use identical syntax. You can also build custom compound interest formulas: =A1*(1+B1/C1)^(C1*D1) where A1 = principal, B1 = annual rate, C1 = periods per year, D1 = years.
Frequently Asked Questions About Compound Interest
-
Compound interest is interest calculated on the initial principal and on the accumulated interest of previous periods. Each time interest is calculated, it's added to your balance, which means the next interest calculation uses a larger base. Over time, this creates exponential growth. The formula is FV = PV × (1 + r/m)mn, where PV is your starting amount, r is the annual rate, m is compounding frequency, and n is years.
-
More frequent compounding always produces higher returns. Daily compounding yields more than monthly, which yields more than quarterly or annually. However, the incremental benefit diminishes: the jump from annual to monthly is significant, but the difference between daily and continuous compounding is negligible. For practical purposes, daily or monthly compounding gives you nearly the maximum possible return. When choosing between savings accounts, compare the APY, which already factors in compounding frequency.
-
APR (Annual Percentage Rate) is the nominal annual rate without accounting for compounding. APY (Annual Percentage Yield) includes the effect of compounding and represents the actual annual return. For example, a 6% APR compounded monthly has an APY of 6.168%. Banks advertise APY for savings (to make returns look higher) and APR for loans (to make costs look lower). Always compare APY when evaluating savings products.
-
When you carry a balance on a credit card, compound interest works against you. Most credit cards compound daily on your outstanding balance, meaning unpaid interest gets added to your balance and begins accruing its own interest. A $5,000 credit card balance at 22% APR, if you only make minimum payments, could take 20+ years to pay off and cost you over $8,000 in interest alone. This is why paying more than the minimum — or paying in full — is so critical.
-
Yes! Enter your current retirement savings as the principal, your expected annual return as the rate (7-10% is common for stock market averages), your years until retirement, and your monthly contributions as the deposit. The result shows your projected retirement balance. For more specialized features like 401(k) employer matching, visit our Retirement FV Calculator.
-
Inflation erodes the purchasing power of your returns. To find the "real" return after inflation, subtract the inflation rate from your nominal return: Real Rate ≈ Nominal Rate − Inflation Rate. For more precision, use: Real FV = Nominal FV ÷ (1 + inflation)n. If your savings earn 5% but inflation is 3%, your real return is approximately 2%. Our Inflation Calculator can adjust your results automatically.