You invest ₹5,000 every month in a mutual fund SIP. After 10 years your portfolio shows ₹11.6 lakh. But your statement also shows a "XIRR of 13.4%." What does that mean — and is it good? This guide explains every method for calculating SIP returns, with real worked examples you can follow step by step.
A Systematic Investment Plan (SIP) is a method of investing a fixed amount in a mutual fund at regular intervals — typically monthly. Each instalment buys units of the fund at the prevailing Net Asset Value (NAV) on that day. Over time, your SIP accumulates units at different NAV prices, and your total return is the growth in the total value of all units purchased.
How SIP returns differ from FD returns: An FD earns interest on a fixed principal at a fixed rate. A SIP earns returns on an ever-growing corpus of mutual fund units — the return rate is not fixed and varies with market performance. This makes SIP return calculation more complex than FD calculation.
The standard formula for calculating the future value (maturity amount) of a SIP, assuming a constant rate of return, is:
This formula assumes a constant rate of return. Real mutual fund returns vary month to month — the formula gives an estimate based on an assumed annual return. For actual past returns on completed SIPs, XIRR is the correct method.
CAGR stands for Compound Annual Growth Rate. It expresses the rate at which an investment would have grown if it grew at a steady rate each year. For lump sum investments, CAGR is straightforward. For SIPs, it is more approximate — because you are investing different amounts at different times.
CAGR is not accurate for SIPs. Because SIP investments happen at different times, using simple CAGR on total invested vs final value understates the actual return. XIRR is the correct metric for SIP return calculation. CAGR works well only for lump sum investments.
XIRR (Extended Internal Rate of Return) is the most accurate way to measure SIP returns. It accounts for the timing of each cash flow — meaning each monthly investment is treated as a separate cash flow at its specific date. XIRR answers: "What single annual return rate would produce this outcome, given the exact dates and amounts of all investments?"
| Metric | Best Used For | Accounts for Timing? | Comparable Across Investments? |
|---|---|---|---|
| Absolute Return | Quick glance at total gain/loss | No | No — misleading across different periods |
| CAGR | Lump sum investments | Partially | Yes — but only for lump sums |
| XIRR | SIPs and irregular investments | Yes — exact dates | Yes — most accurate for SIPs |
| Annualised Return | Fund fact sheets | No | Partially |
Column A: dates of each SIP (e.g. 1 Jan 2020, 1 Feb 2020…). Column B: amounts as negative (e.g. −5000, −5000…) since these are outflows.
On the last row, enter today's date in Column A and your current portfolio value as a positive number in Column B (this is an inflow — money you'd receive if you redeemed).
In any empty cell, type: =XIRR(B1:B121, A1:A121) — where B1:B121 contains all your cash flows and A1:A121 contains all corresponding dates. The result is your annualised XIRR return.
What is a good XIRR for a SIP? For equity mutual funds in India, an XIRR of 12–15% over a 10+ year period is considered good. Large-cap funds typically deliver 10–13% XIRR; mid and small-cap funds can deliver 14–18% over long periods — with higher volatility. Debt fund SIPs typically deliver 6–8% XIRR.
A step-up SIP (also called a top-up SIP) increases your monthly investment amount by a fixed percentage every year — typically 10%. This mirrors income growth and dramatically increases your final corpus.
| SIP Type | Starting SIP | Annual Step-Up | Tenure | Rate | Final Corpus | Total Invested |
|---|---|---|---|---|---|---|
| Regular SIP | ₹5,000/mo | None | 20 years | 12% | ₹49.96 lakh | ₹12 lakh |
| Step-Up SIP | ₹5,000/mo | 10% per year | 20 years | 12% | ₹1.00 crore | ₹34.4 lakh |
| Regular SIP | ₹10,000/mo | None | 15 years | 12% | ₹50.46 lakh | ₹18 lakh |
| Step-Up SIP | ₹10,000/mo | 10% per year | 15 years | 12% | ₹87.9 lakh | ₹38.1 lakh |
The step-up SIP advantage: A 10% annual step-up on a ₹5,000/month SIP at 12% for 20 years produces ₹1 crore — double the ₹49.96 lakh from a flat SIP. The extra ₹22.4 lakh invested (additional contributions) generates ₹50 lakh extra — a 2x leverage on incremental investment.
The difference between 10% and 15% annual return sounds small — but over 20 years it creates a massive gap in final corpus. Here is how ₹5,000/month grows at different return assumptions:
| Tenure | Invested | @ 10% p.a. | @ 12% p.a. | @ 15% p.a. |
|---|---|---|---|---|
| 5 years | ₹3 lakh | ₹3.87 lakh | ₹4.12 lakh | ₹4.49 lakh |
| 10 years | ₹6 lakh | ₹10.33 lakh | ₹11.62 lakh | ₹13.93 lakh |
| 15 years | ₹9 lakh | ₹20.73 lakh | ₹25.23 lakh | ₹33.94 lakh |
| 20 years | ₹12 lakh | ₹38.28 lakh | ₹49.96 lakh | ₹75.79 lakh |
| 25 years | ₹15 lakh | ₹66.65 lakh | ₹94.88 lakh | ₹1.64 crore |
| 30 years | ₹18 lakh | ₹1.13 crore | ₹1.76 crore | ₹3.50 crore |
Monthly SIP of ₹5,000. Returns are assumed constant — actual mutual fund returns vary. Past performance does not guarantee future results.
These are projections, not guarantees. Mutual fund returns are market-linked and not fixed. The 12–15% figures are based on historical Indian equity market performance over long periods — actual returns in your investment period may be higher or lower. Always consult a SEBI-registered financial advisor before investing.
Starting a ₹3,000/month SIP at age 25 produces a far larger corpus by age 55 than starting ₹6,000/month at age 35 — even though the 35-year-old invests more money. The first 10 years of compounding are irreplaceable.
Market crashes are the best time to be in a SIP — you buy more units at lower NAV. Many investors make the mistake of pausing SIPs during corrections, missing the cheapest accumulation phase. Stay invested through volatility.
Increase your SIP amount by 10% every April (financial year start). This mirrors typical salary increments and keeps your investment proportional to your income without requiring a big upfront commitment.
Avoid chasing the "top fund of the year" — 1-year returns are meaningless for SIP evaluation. Look at 5-year and 10-year XIRR, rolling returns, and consistency of performance across market cycles.
Regular mutual fund plans charge a distribution commission (typically 0.5–1.5% per year) that reduces your returns. Direct plans have no commission — choosing direct over regular can add 1–1.5% to annual returns, which compounds to lakhs over 20 years.