Guide
How to Calculate Compound Interest: Formula and Worked Example
Compound interest is interest earned on interest: each time interest is added, the balance grows, and the next interest is worked out on the larger balance. This guide explains the formula in plain steps, works through an example with and without monthly deposits, shows what the compounding frequency changes, and gives the spreadsheet formula that reproduces the figures.
Published
Simple interest vs compound interest
With simple interest, interest is worked out on the starting amount only: Rs 100,000 at 10% earns Rs 10,000 every year, Rs 50,000 in five years. With compound interest, the interest is added to the balance and earns interest itself. The first year still earns Rs 10,000, but the second year earns 10% of Rs 110,000, and so on:
| Year | Interest earned (Rs) | Balance at year end (Rs) |
|---|---|---|
| 1 | 10,000 | 110,000 |
| 2 | 11,000 | 121,000 |
| 3 | 12,100 | 133,100 |
| 4 | 13,310 | 146,410 |
| 5 | 14,641 | 161,051 |
The difference is small over five years, Rs 11,051, and large over long periods: the same Rs 100,000 passes Rs 200,000 between year 7 (Rs 194,872) and year 8 (Rs 214,359). The Rule of 72 estimates the doubling time: 72 ÷ 10 ≈ 7.2 years at 10%.
The formula, step by step
Using Rs 100,000 at 10% for 5 years with interest added once a year (n = 1):
- Rate per period: r ÷ n = 0.10 ÷ 1 = 0.10.
- Number of periods: n × t = 1 × 5 = 5.
- Growth factor: (1 + 0.10)5 = 1.15 = 1.61051.
- Final amount: A = 100,000 × 1.61051 = Rs 161,051.
- Interest: 161,051 − 100,000 = Rs 61,051.
With interest added monthly (n = 12), the rate per period is 0.10 ÷ 12 and there are 60 periods: A = 100,000 × (1 + 0.10 ÷ 12)60 = Rs 164,531. The extra Rs 3,480 comes from interest being added, and earning, sooner.
Adding a monthly deposit
Most people save a fixed amount each month as well. Each deposit then compounds for the time it has left. With a monthly rate i = r ÷ 12 and N months, the deposits D made at the end of each month grow to D × ((1 + i)N − 1) ÷ i, which is added to the lump-sum result above1.
Example: Rs 100,000 to start, Rs 5,000 a month, 10% a year added monthly, for 5 years. You put in Rs 100,000 + 60 × Rs 5,000 = Rs 400,000. The balance after 5 years is Rs 551,716, so the interest is Rs 151,716. Year by year, as the calculator shows it:
| Year | Deposited (Rs) | Interest (Rs) | Balance (Rs) |
|---|---|---|---|
| 1 | 60,000 | 13,299 | 173,299 |
| 2 | 60,000 | 20,975 | 254,274 |
| 3 | 60,000 | 29,454 | 343,727 |
| 4 | 60,000 | 38,821 | 442,548 |
| 5 | 60,000 | 49,168 | 551,716 |
Each year’s interest is larger than the last, because the balance it is worked out on is larger. Starting from nothing, Rs 5,000 a month at 10% for 10 years comes to Rs 1,024,225 from Rs 600,000 of deposits.
How often interest is added
A rate of 12% a year does not always earn 12%. Interest added more often earns slightly more, because each addition starts earning sooner. The effective yearly rate is what the quoted (nominal) rate really earns in a year:
| Interest added | Balance after a year (Rs) | Interest (Rs) | Effective yearly rate |
|---|---|---|---|
| Yearly | 1,120,000 | 120,000 | 12.00% |
| Quarterly | 1,125,509 | 125,509 | 12.55% |
| Monthly | 1,126,825 | 126,825 | 12.68% |
| Daily | 1,127,475 | 127,475 | 12.75% |
The gap from yearly to daily is about Rs 7,500 on a million, so the rate itself matters far more than the frequency. When comparing accounts, compare the effective rate, or the amount at the end of the year, not the nominal rate alone.
The same figures in Excel or Google Sheets
The FV function gives the future value of a lump sum plus regular payments: =FV(rate, nper, pmt, [pv], [type]), with the rate per period, the number of periods, the payment per period, the starting amount, and type 0 for payments at the end of each period2. Amounts you pay in are entered as negatives so the result is positive. The example above is =FV(10%/12, 60, -5000, -100000), which gives 551,716, the calculator’s figure.
Using the calculator
The Compound Interest Calculator takes the Starting amount, the Monthly deposit, the Yearly interest or profit rate, the number of Years and how often interest is added: Daily, Monthly, Quarterly or Yearly. It shows the final balance, what you put in, the interest earned, the effective yearly rate and a year-by-year table. Deposits are made at the end of each month and start earning the month after.
It assumes a fixed rate for the whole period and leaves out tax on interest or profit, fees, inflation and withdrawals. Banks and funds credit interest on their own schedule and round in their own way, so treat the result as an estimate, and the rate you enter as your assumption rather than any bank’s offer. Rates up to 100% and periods up to 60 years are accepted.
Common questions
What is the compound interest formula?
A = P × (1 + r ÷ n) to the power of n × t: starting amount P, yearly rate r as a decimal, n additions of interest a year, t years. The interest earned is A minus P. For regular deposits, add D × ((1 + i) to the power of N − 1) ÷ i, with the rate per period i and N periods.
What is the difference between the nominal and the effective rate?
The nominal rate is the quoted yearly rate. The effective rate is what it actually earns in a year once compounding is counted: 12% added monthly is 12.68% a year, and 12% added once a year is 12%.
How long does money take to double?
Roughly 72 divided by the yearly rate in percent: about 7.2 years at 10%, about 9 years at 8%. The exact answer from the formula is between 7 and 8 years at 10%, since Rs 100,000 becomes Rs 194,872 after 7 years and Rs 214,359 after 8.
Is the result what my bank will pay?
Not exactly. The calculator shows the maths for the rate you enter. Your bank’s or fund’s own terms decide when interest is credited, how it is rounded, and what tax or fees are taken off, so check its statement or schedule.
Does compound interest apply to loans too?
Yes: unpaid interest on a loan is added to the balance and charged interest in the same way. For a loan repaid in fixed monthly instalments, see how to calculate loan EMI.
Sources
- Wikipedia: Compound interest — the compound interest formula with the compounding frequency, and the future value of a series of regular payments.
- Microsoft Support: FV function — syntax FV(rate, nper, pmt, [pv], [type]); type 0 means payments at the end of each period.