How SIP returns are calculated
The SIP formula is FV = P × [((1+r)ⁿ − 1) ÷ r] × (1+r). Rather than asking
you to take that on trust, this page derives it from the one idea it rests on: each instalment
is a separate lump sum, compounding for its own length of time.
The one idea everything follows from
A SIP is not one investment. Twelve months of ₹5,000 is twelve separate ₹5,000 investments, each made on a different date, each compounding for a different length of time.
So work out what each one becomes and add them up. With a monthly rate r and n total instalments, and money going in at the start of each month:
- Instalment 1 compounds for all n months:
P(1+r)n - Instalment 2 compounds for n−1 months:
P(1+r)n−1 - …
- Instalment n compounds for 1 month:
P(1+r)1
The total is therefore:
FV = P[(1+r)1 + (1+r)2 + … + (1+r)n]
That bracket is a geometric series with first term (1+r) and ratio (1+r). Nothing more exotic than that is going on.
Collapsing the series
A geometric series with first term a and ratio x over n terms sums to
a(xn − 1) ÷ (x − 1). Here a = (1+r) and x = (1+r), so x − 1 = r:
FV = P × (1+r) × [((1+r)n − 1) ÷ r]
Which is the formula, with the factors written in a different order. That is the entire derivation — one geometric series, one standard sum.
Two things fall straight out of it:
- Why r cannot be zero. The division by r breaks down. At a zero rate nothing
compounds, so the answer is simply
P × n, and any careful implementation special-cases it. Ours does. - Why n matters more than r. n sits in an exponent while r does not. Doubling the duration does far more than adding two points to the return.
Worked through, one number at a time
₹5,000 a month, 12% a year, 10 years.
- Monthly rate. r = 12 ÷ 12 ÷ 100 = 0.01. Note this is a nominal rate divided by 12, which is the standard convention — not the twelfth root of 1.12.
- Number of instalments. n = 10 × 12 = 120.
- Growth factor. (1.01)120 = 3.300387.
- Series sum. (3.300387 − 1) ÷ 0.01 = 230.0387.
- Annuity-due adjustment. × 1.01 = 232.3391.
- Multiply by the instalment. × 5,000 = ₹11,61,695.
You invested ₹6,00,000. Compounding added ₹5,61,695 — 48% of the final figure. Check it in the calculator.
The one convention that explains most disagreements
That step-five factor of (1+r) is where calculators diverge, and almost nobody says so.
- Annuity-due assumes money arrives at the start of each period, so every instalment earns one extra month. This is what a real mandate does, and it is what this site uses.
- Annuity-ordinary assumes money arrives at the end, and drops the (1+r).
The difference in the reference case: ₹11,61,695 against ₹11,50,193 — about 1.00%, which is roughly ₹11,502. Small in percentage terms, real in rupees, and it grows with the term.
So if another calculator gives you a slightly smaller number, this is usually why. Neither is "wrong" — they are answering marginally different questions. Ours is documented on the methodology page so you can tell which you are looking at.
The iterative version, and why we compute both
The same answer arrives from a loop that needs no algebra:
value = 0; each month: value = (value + P) × (1 + r)
Run that 120 times and you get ₹11,61,695 — the identical figure, because it is the identical series.
This site computes both, deliberately. The closed form gives the headline number; the loop generates the year-by-year table, and it also handles a step-up SIP, where a changing instalment means there is no clean closed form at all. The test suite asserts the two agree, so the table and the total can never drift apart.
What the formula cannot tell you
One rate is a fiction
The formula needs a single constant r. Real funds return −18%, then +31%, then +4%. The same average delivered in a different order produces the same final value for a SIP — but a completely different experience, and a materially different outcome once you start withdrawing.
The formula also ignores expense ratios, exit loads, tax and the possibility that you stop paying. Costs alone typically remove 0.5 to 2 percentage points. If you want a net figure, subtract the expense ratio from the rate you enter.
Questions people actually ask
Why is the monthly rate annual ÷ 12 rather than the twelfth root?
Because the input is a nominal annual rate, by convention. Dividing by 12 gives 1% a month, which compounds to 12.68% effective over a year — slightly more than the 12% you typed.
Using the twelfth root of 1.12 (about 0.9489% a month) would make 12% the effective annual rate instead. Both are internally consistent; the division convention is near-universal in Indian SIP calculators, so we follow it and say so.
Does this formula work for a weekly or quarterly SIP?
Yes, with r and n redefined for the period: divide the annual rate by the number of periods a year and count instalments instead of months. The frequency calculator does this, and shows that the choice barely changes the outcome.
How do I calculate my actual SIP return rather than a projection?
Use XIRR, not this formula. This formula projects forwards from an assumed rate; XIRR works backwards from what actually happened, using the real dates and amounts.
The XIRR calculator does it, and XIRR vs CAGR vs absolute returns explains why the other two measures mislead here.
Can I do this in a spreadsheet?
Yes: =FV(rate/12, years*12, -amount, 0, 1). The final argument, 1, sets
payments at the beginning of the period — that is the annuity-due switch. Leave it at 0 and you get
the end-of-period variant, which is exactly the discrepancy described above.
Where these numbers come from
- AMFI — Indian mutual fund industry data and investor education
- NSE — Nifty 50 index — index construction and returns methodology