Calculating SIP returns is not as straightforward as multiplying your monthly investment by an expected rate. Each instalment enters the fund on a different date, earns compounding for a different number of months, and gets redeemed together at the end. Understanding the mechanics behind the number your SIP Calculator shows you makes you a more confident investor and helps you set realistic goals.
What You Need
Before running any calculation, gather three inputs:
- Monthly SIP amount (P) — the fixed rupee amount invested each month.
- Investment tenure in years — converted to months (n) for the formula.
- Expected annual return rate — converted to a monthly rate (r) for the formula.
These three variables fully determine your future corpus under a flat SIP. For step-up SIPs or portfolios with top-ups and partial withdrawals, you also need the dates and amounts of every cash flow to compute XIRR.
Step 1: Apply the Future Value of SIP Formula
The standard formula for the maturity value of a monthly SIP — Systematic Investment Plan is:
FV = P × [(1 + r)^n − 1] / r × (1 + r)
Where:
- P = monthly investment amount (in rupees)
- r = monthly return rate = annual rate ÷ 12
- n = total number of monthly instalments = years × 12
The factor (1 + r) at the end accounts for each instalment being invested at the start of the month (annuity due), meaning each payment earns one extra month of compounding compared with an end-of-month payment.
Step 2: Work Through a Concrete Example
Inputs: Rs 10,000/month, 10-year tenure, 12% expected annual return.
Compute the monthly rate: r = 12% ÷ 12 = 1% = 0.01
Compute number of instalments: n = 10 × 12 = 120
Apply the formula:
FV = 10,000 × [(1.01)^120 − 1] / 0.01 × 1.01
= 10,000 × [3.3004 − 1] / 0.01 × 1.01
= 10,000 × 2.3004 / 0.01 × 1.01
= 10,000 × 230.04 × 1.01
= 10,000 × 232.34
≈ Rs 23,23,391
Breakdown:
- Total invested: Rs 10,000 × 120 = Rs 12,00,000
- Final corpus: Rs 23,23,391
- Returns earned: Rs 11,23,391
- Wealth ratio: 1.94× (your money nearly doubles)
Run the same numbers in the SIP Calculator to verify — and to instantly switch tenure or rate without recalculating manually.
Step 3: See the Power of Compounding Over 20 Years
Extending the same SIP (Rs 10,000/month, 12%) to 20 years changes the picture dramatically.
- Total invested: Rs 10,000 × 240 = Rs 24,00,000
- Final corpus: approximately Rs 99,91,478 (≈ Rs 1 crore)
- Wealth ratio: 4.16×
The corpus does not grow linearly. In the first 10 years you build Rs 23 lakh on Rs 12 lakh invested. In the next 10 years, the existing corpus itself earns returns, and you add Rs 12 lakh more — taking the total to nearly Rs 1 crore. This is compounding in action: the returns of earlier years become the principal for later years.
Corpus at Different Tenures (Rs 5,000/month)
| Tenure | 10% p.a. | 12% p.a. | 15% p.a. |
|---|---|---|---|
| 5 years | Rs 7.8L | Rs 8.2L | Rs 8.9L |
| 10 years | Rs 20.5L | Rs 23.2L | Rs 27.9L |
| 15 years | Rs 41.8L | Rs 50.5L | Rs 67.9L |
| 20 years | Rs 76.6L | Rs 99.9L | Rs 1.51Cr |
The difference between 10% and 15% over 20 years is not 50% — it is nearly double the corpus. Rate of return matters enormously over long horizons, which is why choosing between a direct-plan diversified equity fund and a conservative debt fund is not a minor decision.
Step 4: Layer in a Step-Up SIP
A flat SIP is the baseline. A step-up SIP increases your monthly investment by a fixed percentage each year. Most investors can manage a 10% annual step-up aligned with typical salary increments.
Comparison at 12% annual return, 20 years:
| SIP Type | Monthly Start | Corpus |
|---|---|---|
| Flat SIP | Rs 10,000 | ~Rs 99.9 lakh |
| 10% step-up SIP | Rs 10,000 | ~Rs 1.5 crore |
The step-up variant delivers approximately 50% more corpus with the same starting amount. The total invested also rises — from Rs 24 lakh (flat) to roughly Rs 68 lakh (step-up) — but the wealth creation is proportionally much higher because the larger instalments in later years still have 5–10 years to compound.
Model both scenarios in the SIP Calculator before committing to a fixed instalment amount.
Step 5: Calculate Your Actual Return Using XIRR
The formula above gives the theoretical future value at a constant assumed rate. For an existing SIP portfolio — especially one with top-ups, pauses, or partial redemptions — your actual money-weighted return is the XIRR (Extended Internal Rate of Return).
XIRR takes every instalment date and amount as an outflow, and the current portfolio value as the final inflow, then solves for the annualised rate that makes the net present value of all cash flows equal to zero.
How to compute it:
- Export your SIP transaction history from your AMC or CAMS/KFintech statement.
- List every instalment as a negative cash flow with its exact date.
- List the current portfolio value as a positive cash flow on today's date.
- Feed the data into the XIRR Calculator.
This gives your true personal return, which accounts for the specific dates when your money entered the fund — not the fund's own CAGR.
SIP XIRR vs Fund CAGR — Understanding the Gap
This is the most common source of confusion for SIP investors.
Fund CAGR is the annualised return on a rupee invested at the very start of the fund's measurement period. It is calculated on a single lump-sum basis.
Your SIP XIRR is always lower than the fund CAGR over the same period because:
- Your first instalment earns 10 years of compounding.
- Your last instalment earns only 1 month of compounding.
- On average, each rupee earns roughly half the total tenure in compounding time.
Example: A fund delivers 15% CAGR over 10 years. A monthly SIP investor in the same fund over the same period typically achieves an XIRR of approximately 12–13%. The gap narrows when the fund's returns are back-loaded (strong recent performance) and widens when returns are front-loaded.
This is not a problem with SIPs — it is simply the mathematical reality of staggered entry. The lumpsum-calculator-india shows what a one-time investment would have grown to at the same fund CAGR, allowing a direct comparison.
Common Mistakes to Avoid
Using the fund CAGR as your personal return. If a fund factsheet says "15% CAGR over 10 years," that number does not apply to your SIP. Calculate your XIRR using the XIRR Calculator.
Ignoring the expense ratio. The expense ratio is deducted daily from the NAV and does not appear as a visible charge. A 1.5% expense ratio in a regular plan versus 0.5% in a direct plan translates to roughly 1% per year in returns — which over 20 years can reduce your final corpus by 15–18%.
Stopping SIP during a market crash. This is the most damaging mistake. When the market falls, the same monthly SIP buys more units at lower NAV. These cheaply acquired units amplify gains during the recovery. Investors who stopped SIPs in March 2020 and resumed six months later missed the cheapest entry points of the decade.
Treating SIP returns as guaranteed. The formula uses an assumed rate. Actual equity fund returns fluctuate year to year. Planning at 10–12% for diversified equity gives a reasonable conservative estimate; never plan equity SIPs at 15%+ for primary financial goals.
Key Terms
- SIP — Systematic Investment Plan — A method of investing a fixed amount in a mutual fund at regular intervals, typically monthly.
- XIRR — Extended Internal Rate of Return — The annualised money-weighted return on a portfolio with multiple cash flows at different dates.
- CAGR — Compound Annual Growth Rate — The annualised return on a single lump-sum investment over a defined period.
- NAV — Net Asset Value — The per-unit price of a mutual fund, calculated daily after deducting liabilities from total assets.
- Compounding — The process by which returns earned on an investment are reinvested to generate further returns, creating exponential growth over time.