Knowing how to calculate compound interest is a foundational financial skill. Whether you're planning your retirement, comparing savings accounts, or evaluating investment options, understanding the math helps you make smarter decisions — and avoid being misled by oversimplified projections.
In this guide, we'll walk through the compound interest formula step by step, show worked examples for both lump sums and regular contributions, and show you how to use our free compound interest calculator for instant results.
The Compound Interest Formula
A = P × (1 + r/n)^(n × t)- A = Final amount (future value)
- P = Principal (starting investment)
- r = Annual interest rate expressed as a decimal (e.g., 7% = 0.07)
- n = Number of times interest compounds per year (daily=365, monthly=12, quarterly=4, annually=1)
- t = Time period in years
Step-by-Step Calculation: Lump Sum Only
Scenario: You invest $8,000 at 7% annual interest, compounded monthly, for 10 years.
Step 1: Convert the interest rate to a decimal: 7% ÷ 100 = 0.07
Step 2: Divide the rate by the compounding frequency: 0.07 ÷ 12 = 0.005833
Step 3: Calculate the total number of compounding periods: 12 × 10 = 120 periods
Step 4: Apply the formula: A = 8,000 × (1 + 0.005833)^120
Step 5: Calculate (1.005833)^120 = 2.0097
Step 6: Multiply: 8,000 × 2.0097 = $16,077.57
Your $8,000 investment grows to $16,077.57 after 10 years at 7% compounded monthly. You earned $8,077.57 in compound interest — essentially doubling your money!
Step-by-Step Calculation: With Monthly Contributions
When you add regular monthly deposits, the formula becomes:
FV = P(1+r/n)^(nt) + PMT × [((1+r/n)^(nt) − 1) / (r/n)]- PMT = Monthly contribution amount
- All other variables same as above
Scenario: $8,000 principal + $250/month at 7% monthly compounding for 10 years.
Part 1 (Principal FV): $8,000 × (1.005833)^120 = $16,077.57
Part 2 (Contributions FV): $250 × [((1.005833)^120 − 1) / 0.005833] = $250 × 173.28 = $43,320
Total FV = $16,077.57 + $43,320 = $59,397.57
Adding $250/month transformed a $16,077 result into nearly $59,398 — a 270% improvement from consistent contributions.
Calculate Compound Interest in Excel or Google Sheets
Excel and Google Sheets have a built-in FV (Future Value) function that handles compound interest with contributions:
=FV(rate/n, n*years, -monthly_contribution, -principal)- Example:
=FV(0.07/12, 12*10, -250, -8000) - Result: $59,397.57
- Note: contributions and principal are negative (cash outflows)
The Fastest Method: Use Our Free Calculator
While manual calculations and Excel are educational, our compound interest calculator makes it effortless to:
- Adjust inputs in real time and see instant results
- View interactive growth charts over any time horizon
- Compare two scenarios side by side
- Toggle inflation adjustment for real returns
- Download a year-by-year breakdown table
Skip the Math — Use Our Calculator
Get instant compound interest results with interactive charts, year-by-year tables, and inflation adjustment.
Calculate Now FreeCompounding Frequency Examples
| Frequency | n value | $10,000 at 8% for 20 years |
|---|---|---|
| Annually | 1 | $46,610 |
| Quarterly | 4 | $48,754 |
| Monthly | 12 | $49,268 |
| Daily | 365 | $49,530 |
Frequently Asked Questions
A = P(1 + r/n)^(nt). Where P=principal, r=annual rate (decimal), n=compounds per year, t=years. For monthly contributions, add: PMT × [((1+r/n)^nt - 1)/(r/n)].
Use the extended FV formula including the PMT annuity component, or use our calculator which handles this automatically.
Yes! =FV(rate/n, n*years, -contribution, -principal) gives the future value. For $10,000 at 8% monthly for 20 years: =FV(0.08/12, 240, 0, -10000) = $49,268.
Use our free compound interest calculator — enter your numbers and get instant results with interactive charts, no math required.