How to Calculate Compound Interest

Introduction

Most people learn about interest in school and promptly forget it. Then they open a savings account, take out a loan, or start investing — and suddenly it matters a great deal.

Compound interest is the mechanism that makes wealth grow faster over time and debt spiral out of control if left unchecked. It is not complicated once you see the formula and walk through a real example. This article covers the exact formula, shows you how to apply it step by step, compares different compounding frequencies, flags the mistakes most people make, and answers the questions that come up most often.

If you want to skip the arithmetic and try numbers directly, use the free calculator tools at NovaCalculator to run your own scenarios in seconds.

What Is Compound Interest?

Simple interest is calculated only on the original principal. If you deposit $1,000 at 5% simple interest for three years, you earn $50 each year — $150 total.

Compound interest is different. Each period, the interest you already earned is added to the principal, and the next period’s interest is calculated on that larger amount. Over time, you earn “interest on interest.” That compounding effect is why Einstein allegedly called it the eighth wonder of the world (whether he actually said it is debatable; the math is not).

The key variables are:

P — Principal (starting amount)
r — Annual interest rate (as a decimal)
n — Number of times interest compounds per year
t — Time in years
A — Final amount (principal + interest)

The Compound Interest Formula

The standard formula is:

A = P × (1 + r/n)^(n × t)

To find only the interest earned (not the total balance), subtract the principal:

Interest = A − P

Breaking Down Each Part

P × … — You start with your principal and multiply everything else on top of it.

(1 + r/n) — This is the growth factor per compounding period. Dividing the annual rate by n converts it to a per-period rate, and adding 1 represents the fact that you keep the original amount plus the interest.

^(n × t) — The exponent is the total number of compounding periods. If interest compounds monthly (n = 12) over 5 years (t = 5), the exponent is 60.

Continuous Compounding (Bonus Formula)

Some financial products compound continuously rather than at discrete intervals. The formula becomes:

A = P × e^(r × t)

Where e is Euler’s number (approximately 2.71828). Continuous compounding represents the theoretical maximum you can earn at a given rate. In practice, the difference between daily and continuous compounding is tiny.

Step-by-Step Worked Example

Scenario: You invest $5,000 at an annual interest rate of 6%, compounded monthly, for 10 years. How much will you have, and how much of that is interest?

Step 1: Identify Your Variables

P = 5,000
r = 6% = 0.06
n = 12 (monthly compounding)
t = 10

Step 2: Calculate the Per-Period Rate

r/n = 0.06 / 12 = 0.005

Step 3: Calculate the Growth Factor Per Period

1 + r/n = 1 + 0.005 = 1.005

Step 4: Calculate the Exponent

n × t = 12 × 10 = 120

Step 5: Raise the Growth Factor to the Exponent

(1.005)^120 = 1.8194

You can compute this on a scientific calculator using the ^ or y^x button, or use the formula =1.005^120 in any spreadsheet.

Step 6: Multiply by the Principal

A = 5,000 × 1.8194 = $9,097.00

Step 7: Find the Interest Earned

Interest = $9,097.00 − $5,000 = $4,097.00

Result: After 10 years, your $5,000 grows to approximately $9,097. You earned $4,097 in interest — more than 80% of your original deposit — without adding another cent.

Comparison: What If It Were Simple Interest?

With simple interest at 6% for 10 years:

Interest = 5,000 × 0.06 × 10 = $3,000

Total = $8,000. The compounding effect adds an extra $1,097 over simple interest in this example. The gap widens significantly at longer timeframes.

How Compounding Frequency Affects Your Returns

Using the same $5,000 at 6% for 10 years, here is how different compounding frequencies compare:

Compounding Frequency	n Value	Final Balance
Annually	1	$8,954.24
Semi-annually	2	$9,030.56
Quarterly	4	$9,070.09
Monthly	12	$9,096.98
Daily	365	$9,110.14
Continuously	—	$9,110.60

The difference between annual and monthly compounding is about $143 on a $5,000 investment over 10 years. The difference between monthly and daily is less than $14. Frequency matters, but the rate and time matter far more.

What This Means in Practice

When comparing savings accounts, a higher rate with annual compounding almost always beats a slightly lower rate with daily compounding. Do the math rather than assuming more frequent compounding automatically wins. The calculators at NovaCalculator let you compare scenarios side by side so you can see the actual difference for your numbers.

The Rule of 72: A Quick Mental Shortcut

You do not always need the full formula. The Rule of 72 lets you estimate how long it takes to double your money at a given compound interest rate:

Years to double ≈ 72 / Annual Interest Rate (%)

Example: At 6% annual compounding, your money doubles in roughly 72 / 6 = 12 years.

At 8%, it doubles in about 9 years. At 3%, roughly 24 years.

The rule works because of the mathematics underlying exponential growth. It is accurate to within a year or two for rates between 3% and 18%, which covers most real-world situations.

Common Mistakes When Calculating Compound Interest

1. Forgetting to Convert the Rate to a Decimal

The formula uses r as a decimal. A rate of 5% means r = 0.05, not r = 5. Plugging in 5 instead of 0.05 will give you an absurd answer — thousands of times your principal.

2. Confusing Annual Rate With Per-Period Rate

The formula already handles the conversion (r/n). Do not divide your rate by n and then enter that divided rate as if it were the annual rate. Apply the formula as written.

3. Using the Wrong Value of n

If your bank says interest compounds “quarterly,” n = 4. Monthly is 12. Daily is typically 365, though some institutions use 360. Verify with your bank or loan documents rather than guessing.

4. Mixing Up n and t

Both appear in the formula and it is easy to swap them. n is frequency (times per year), t is duration (years). A 5-year loan compounding monthly uses n = 12 and t = 5, giving an exponent of 60 — not n = 5 or t = 12.

5. Ignoring Fees and Taxes

The formula shows gross growth. Real-world accounts often have maintenance fees, and interest income is generally taxable. An account earning 5% with a 0.5% annual fee effectively earns 4.5%. Calculate your net return, not just the gross.

6. Assuming APR and APY Are the Same

APR (Annual Percentage Rate) is the stated rate. APY (Annual Percentage Yield) accounts for compounding and is always equal to or higher than APR. When comparing financial products, use APY for a true apples-to-apples comparison.

FAQ: Compound Interest

1. What is the difference between APR and APY?

APR is the base annual interest rate without factoring in compounding. APY reflects the actual annual return after compounding is applied. For a savings account with 6% APR compounding monthly, the APY is approximately 6.17%. Lenders often advertise APR (looks lower), while savings accounts advertise APY (looks higher). Always check which one you are looking at.

2. Does compound interest work the same way for debt?

Yes, and this is where it works against you. Credit card balances, student loans, and mortgages all use compounding, though the mechanics vary. Credit cards typically compound daily on any unpaid balance, which is why carrying a balance month to month is so costly. If you have a $5,000 credit card balance at 20% APR compounding daily and make no payments, the balance grows to roughly $6,107 after one year.

3. How do I calculate compound interest in Excel or Google Sheets?

Use this formula in a cell:

=P*(1+r/n)^(n*t)

Replace P, r, n, and t with cell references or direct values. For example, if P is in A1, r in B1, n in C1, and t in D1:

=A1*(1+B1/C1)^(C1*D1)

Make sure r is entered as a decimal (0.06, not 6).

4. What is the best compounding frequency for a savings account?

From a pure math standpoint, daily compounding is marginally better than monthly, which is marginally better than quarterly. But the difference is small compared to the interest rate itself. A savings account paying 4.5% compounding daily is better than one paying 4.0% compounding daily, even though the compounding frequency is the same. Chase the rate first; compounding frequency is a secondary consideration.

5. Can I use the compound interest formula for investments with regular contributions?

Not directly — the standard formula assumes a single lump-sum deposit. Regular contributions (like monthly deposits into a retirement account) require a different formula called the future value of an annuity:

FV = PMT × [((1 + r/n)^(n×t) − 1) / (r/n)]

Where PMT is the regular payment amount. This gets complex quickly, which is why using a financial calculator or the compound interest tools at NovaCalculator is more practical for multi-contribution scenarios.

Putting It All Together: A Real-World Perspective

The formula A = P × (1 + r/n)^(n×t) is one of the most useful equations in personal finance. It describes how money grows in savings accounts and investment accounts, how debt accumulates when not paid down, and why starting early matters more than the rate itself.

Consider two investors:

Investor A puts $3,000 per year into an index fund starting at age 25, earning 7% annually, and stops at 35 (10 years of contributions, then lets it ride to age 65).
Investor B waits until 35 and contributes $3,000 per year for 30 years at the same 7%.

Investor A contributes $30,000 total. Investor B contributes $90,000 total. Yet Investor A ends up with more money at retirement because the earlier years of compounding are the most powerful. Time in the market, driven by compound interest, outweighs three times as many contributions made later.

This is why financial advisors repeat the same advice: start as early as possible, even with small amounts.

Conclusion

Compound interest follows a straightforward formula, but its effects are anything but simple. The four variables — principal, rate, compounding frequency, and time — interact in ways that reward patience and punish procrastination.

To recap the key points:

The formula is A = P × (1 + r/n)^(n×t)
Convert your rate to a decimal before plugging it in
More frequent compounding helps, but the rate and time matter more
The Rule of 72 (72 / rate = years to double) is a reliable mental shortcut
For debt, compound interest works against you — the same mechanics that grow savings also grow balances

Ready to run the numbers for your own situation? Use the free financial calculators at NovaCalculator to calculate compound interest for any principal, rate, and time period — including scenarios with regular contributions and different compounding frequencies. No sign-up required.

Frequently Asked Questions

What is the difference between APR and APY? +

Does compound interest work the same way for debt? +

Yes, and this is where it works against you. Credit card balances, student loans, and mortgages all use compounding. Credit cards typically compound daily on any unpaid balance, which is why carrying a balance month to month is so costly. A $5,000 credit card balance at 20% APR compounding daily with no payments grows to roughly $6,107 after one year.

How do I calculate compound interest in Excel or Google Sheets? +

Use =P*(1+r/n)^(n*t) in a cell, replacing P, r, n, and t with cell references or direct values. Make sure r is entered as a decimal (0.06, not 6).

What is the best compounding frequency for a savings account? +

Can I use the compound interest formula for investments with regular contributions? +

Not directly — the standard formula assumes a single lump-sum deposit. Regular contributions require the future value of an annuity formula: FV = PMT × [((1 + r/n)^(n×t) − 1) / (r/n)]. Using a financial calculator is more practical for multi-contribution scenarios.