The compound interest formula

A = P(1 + r/n)nt

AFinal amount (principal + interest)
PPrincipal (starting amount)
rAnnual interest rate as a decimal (5% = 0.05)
nNumber of times interest compounds per year
tTime in years

Step-by-step worked example

Scenario: You deposit £2,000 at 5% annual interest, compounded monthly, for 3 years.

  1. Convert the rate: r = 5% = 0.05
  2. Set compounding frequency: n = 12 (monthly)
  3. Set time: t = 3 years
  4. Apply the formula: A = 2000 × (1 + 0.05/12)12×3
  5. Calculate the exponent: 12 × 3 = 36
  6. Calculate the base: 1 + 0.05/12 = 1.004167
  7. Raise to power: 1.00416736 = 1.16147
  8. Multiply: 2000 × 1.16147 = £2,322.94

Interest earned: £2,322.94 − £2,000 = £322.94

How compounding frequency affects the result

Using the same £2,000 at 5% for 3 years, here is how the final amount changes with different compounding frequencies:

Compounding frequencyn valueFinal amountInterest earned
Annually1£2,315.25£315.25
Quarterly4£2,321.49£321.49
Monthly12£2,322.94£322.94
Daily365£2,323.65£323.65

The difference between annual and daily compounding is only £8.40 over 3 years. Compounding frequency matters less than the rate and the time horizon.

Calculating compound interest with regular contributions

When you add money regularly (e.g. monthly), the formula becomes more complex. The future value of an annuity-due formula is:

FV = P(1+rm)12t + PMT × (1+rm) × [((1+rm)12t − 1) / rm]

rmEffective monthly rate = (1 + r/n)n/12 − 1
PMTMonthly contribution amount

Skip the maths. Enter your principal, monthly contribution, rate and time horizon to get an instant result.

Open the Compound Interest Calculator

Frequently asked questions

How do I calculate compound interest in a spreadsheet?

Use the FV function: =FV(rate/n, n*years, 0, -principal). For example, =FV(0.05/12, 12*3, 0, -2000) gives the future value of £2,000 at 5% compounded monthly for 3 years.

What is the effective annual rate (EAR)?

The EAR is the actual annual return after accounting for compounding within the year. EAR = (1 + r/n)^n - 1. For 5% compounded monthly: EAR = (1 + 0.05/12)^12 - 1 = 5.116%. This is what the AER on savings accounts represents.

How do I calculate how long it takes to reach a target?

Rearrange the formula to solve for t: t = ln(A/P) / (n * ln(1 + r/n)). Or use the Rule of 72 for a quick estimate: divide 72 by the annual rate to get the approximate doubling time.