Investment

How SIP Returns Are Calculated

A SIP is not one investment growing at a rate. It is many investments, each compounding for a different length of time.

Last updated

3 min read

The short version

  • Each instalment compounds only for the months remaining after it is invested.
  • FV = P × ((1+i)ⁿ − 1) ÷ i × (1+i), with instalments at the start of the month.
  • Most of the growth appears late, when the corpus is largest.
  • Absolute return and annualised return are different numbers — do not confuse them.

Each instalment is a separate investment

This is the idea that makes everything else about SIPs make sense. Your first instalment compounds for the entire period. Your last instalment compounds for one month. Every instalment in between compounds for its own length of time.

Summing all of those individual growths gives the standard SIP formula: FV = P × ((1+i)ⁿ − 1) ÷ i × (1+i), where P is the instalment, i is the monthly return and n is the number of instalments. The final × (1+i) reflects investing at the start of each month, which is the convention every mainstream Indian SIP calculator uses.

Why the last few years do most of the work

On a ₹10,000 monthly SIP at an assumed 12%, the value roughly doubles between year fifteen and year twenty while the amount invested rises by only a third.

The reason is simply that the same percentage return produces far more rupees on a large corpus than on a small one. This is why stopping a SIP a few years early costs disproportionately more than starting it a few years late — you lose the years when the compounding is doing most of its work.

Why the last few years do most of the work
End of yearInvestedValue at 12%Growth that year
5₹6,00,000₹8,24,864₹1,52,000 approx
10₹12,00,000₹23,23,391₹3,60,000 approx
15₹18,00,000₹50,45,760₹6,90,000 approx
20₹24,00,000₹99,91,479₹12,60,000 approx

Absolute return versus annualised return

A twenty-year SIP that turns ₹24 lakh into ₹1 crore has an absolute return of about 316%. That number is impressive and almost meaningless, because it says nothing about how long it took.

The right measure for a series of investments made at different times is XIRR — the internal rate of return that accounts for the timing of each cash flow. It is what fund houses report and what you should compare across options.

Confusing the two is how people conclude that an investment "gave 300% returns" when the annualised figure was around 12%.

What actually changes the outcome

  • Time, more than anything else. Starting five years earlier beats contributing 20% more.
  • The step-up. Raising the instalment each year in line with income compounds those increases for the remaining years.
  • Not stopping. Missed instalments during market falls are the most expensive ones to miss, because they were buying at lower prices.
  • Costs. A higher expense ratio quietly removes a meaningful share of the final corpus over twenty years.
  • The assumed return. It is the input you control least and the one that moves the answer most — which is a reason to plan on a conservative figure.

Frequently asked questions

What return should I assume for a SIP?
There is no correct answer, which is why calculators make it an input. Whatever you assume, run the numbers again at two or three percentage points lower and check whether the plan still works. Planning on the optimistic figure is how goals get missed.
Why does my actual return differ from the calculator?
Because a calculator assumes a constant monthly return and markets do not deliver one. Real returns arrive unevenly, and the order in which good and bad years arrive changes the outcome. The calculator shows the mechanism, not a prediction.
Is XIRR the same as absolute return?
No. Absolute return is total growth as a percentage of the amount invested, ignoring time. XIRR is the annualised rate that accounts for when each instalment was invested. For a SIP, XIRR is the meaningful number and absolute return is close to useless for comparison.

Sources

Every figure on this page is traceable to the official source below. If a source has changed since the date shown, please tell us and we will correct it.