The compound interest formula
A = P(1 + r/n)nt
Step-by-step worked example
Scenario: You deposit £2,000 at 5% annual interest, compounded monthly, for 3 years.
- Convert the rate: r = 5% = 0.05
- Set compounding frequency: n = 12 (monthly)
- Set time: t = 3 years
- Apply the formula: A = 2000 × (1 + 0.05/12)12×3
- Calculate the exponent: 12 × 3 = 36
- Calculate the base: 1 + 0.05/12 = 1.004167
- Raise to power: 1.00416736 = 1.16147
- 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 frequency | n value | Final amount | Interest earned |
|---|---|---|---|
| Annually | 1 | £2,315.25 | £315.25 |
| Quarterly | 4 | £2,321.49 | £321.49 |
| Monthly | 12 | £2,322.94 | £322.94 |
| Daily | 365 | £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]
Skip the maths. Enter your principal, monthly contribution, rate and time horizon to get an instant result.
Open the Compound Interest CalculatorFrequently 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.