How to Calculate Compound Interest

Compound interest pays interest on interest — balances accelerate over time when you save, and debt grows faster when you borrow. Understanding the formula helps you compare savings accounts, investment illustrations, and loan true cost without trusting vague marketing. Savers feel compounding in retirement accounts when dividends reinvest; borrowers feel it on minimum credit card payments that barely touch principal.

The core formula

Future value A = P × (1 + r/n)^(n×t). P is principal, r annual rate as a decimal (5% → 0.05), n compounding periods per year, t years. Monthly compounding uses n = 12. Continuous compounding uses e^(rt) — rare in consumer products but common in textbooks. Example: $10,000 at 4% compounded monthly for 10 years — r/n = 0.04/12, exponent 12×10. The result exceeds simple interest because each month's interest joins the principal.

Spreadsheet approach

Google Sheets or Excel: =P*(1+r/n)^(n*t) with cells for each input. For periodic contributions, use FV or build a month-by-month table — easier to audit than one giant formula. Label units clearly; confusing monthly rate with annual rate is the usual mistake.

Calculator on FileToolsHub

Open /tool/compound-interest, enter principal, annual rate, compounding frequency, years, and optional contributions. Compare scenarios side by side before committing to a CD term or estimating long-term savings. Rule of 72 divides 72 by rate percent for doubling time mental math; it approximates compound growth, not linear. Pair with /tool/rule-of-72-calculator for quick mental doubling-time estimates.

Loans vs savings

Credit cards compound daily on unpaid balances — small daily rates add up. Mortgages often quote annual rate with monthly compounding on amortizing schedules; use /tool/loan-calculator or /tool/mortgage-calculator for payment breakdowns, not just end balance. Tax-advantaged accounts change after-tax yield but not the compounding mechanics inside the account — separate tax advice from the math tutorial. Always check whether quoted APY already includes compounding; APR on loans may exclude fees.

Limitations of pure math

Real investments add volatility, taxes, and fees this formula ignores. Use compounding for bank-style guaranteed rates; use broader planning tools for retirement with equity exposure.

Sanity-check your inputs

Write down whether the quoted rate is APR or APY and whether compounding matches your product (daily on savings, monthly on many loans). Plug the same numbers into /tool/compound-interest and one spreadsheet cell to confirm they agree before you present results to a client or family member. When comparing investment marketing materials, ask for the assumed rate and contribution schedule in writing — compound curves look dramatic over 30 years with small changes in assumptions. Use /tool/simple-interest-calculator when a product is explicitly simple-interest to avoid mixing models.

Nominal versus effective rate matters when compounding frequency exceeds annual quotes — compare APY to APY, not APR to APY without conversion. Continuous compounding appears in calculus examples; consumer products almost always use discrete periods. When modeling inflation-adjusted savings, run compound growth on nominal balance then discount separately so you do not double-count. For bond ladders, each rung may reinvest at a new rate — a single compound formula is an illustration, not a full portfolio model. Teach students to build a table for years 0–10 so they see curvature; the formula alone hides how slow early years feel.

When comparing loans, use the same compounding basis the lender discloses in the Truth-in-Lending style summary rather than a simplified formula alone. For education, plot contributions plus interest separately so learners see how much came from their paycheck versus growth. If your spreadsheet uses nominal annual rate divided by 12, confirm that matches the loan docs — some products use daily accrual with a different effective cost.

When comparing loans, use the same compounding basis the lender discloses in the Truth-in-Lending style summary rather than a simplified formula alone. For education, plot contributions plus interest separately so learners see how much came from their paycheck versus growth. If your spreadsheet uses nominal annual rate divided by 12, confirm that matches the loan docs — some products use daily accrual with a different effective cost.

FAQ

Is compounding frequency a big deal? At equal APY, more frequent compounding helps slightly; APY normalization exists to compare products.

Can interest be negative? Deflation scenarios aside, consumer savings rates at or below zero still use the same math.

Does the tool store my numbers? Browser calculators process locally or session-only — treat like any financial scratch pad.

What about inflation? Nominal future value ignores purchasing power; subtract inflation mentally or use /tool/inflation-calculator.