A Systematic Investment Plan (SIP) lets you invest a fixed amount in a mutual fund every month. But how do you know what your money is actually earning? Calculating SIP returns is not the same as calculating returns on a one-time lump sum, because each instalment stays invested for a different length of time. This guide explains exactly how to calculate SIP returns in India, with formulas, worked examples and the difference between absolute return, CAGR and XIRR.
Why SIP Returns Are Calculated Differently
When you invest a lump sum, the whole amount grows for the full period. With a SIP, your first instalment may grow for 5 years, but your most recent instalment has been invested for only a month. Each unit is bought at a different Net Asset Value (NAV). Because of this staggered timing, a simple percentage cannot capture the true return. This is why investors rely on the SIP future value formula and on XIRR.
The SIP Future Value Formula
The maturity value of a SIP is calculated using the future value of an annuity formula:
M = P × ({[1 + i]^n – 1} / i) × (1 + i)
- M = maturity amount you receive
- P = amount you invest each month
- i = monthly rate of return (annual rate divided by 12)
- n = total number of instalments
Suppose you invest Rs 5,000 per month for 10 years (120 instalments) at an expected 12% annual return. The monthly rate i = 12% / 12 = 1% = 0.01. Plugging into the formula gives a maturity value of approximately Rs 11.6 lakh, while your total investment was only Rs 6 lakh. The remaining Rs 5.6 lakh is the power of compounding at work.
Absolute Return vs CAGR vs XIRR
There are three common ways to express SIP returns, and it is important to know which one to use.
| Metric | What It Measures | Best Used For |
|---|---|---|
| Absolute Return | Total gain as a simple percentage, ignoring time | Quick lump-sum snapshot |
| CAGR | Annualised growth rate for a single investment | Lump-sum investments held over years |
| XIRR | Annualised return across many cash flows on different dates | SIPs and irregular investments |
Absolute Return
Absolute return = (Current Value – Total Invested) / Total Invested × 100. If you invested Rs 6 lakh and it is now worth Rs 11.6 lakh, the absolute return is 93.3%. This number looks impressive but does not tell you the yearly rate.
Why XIRR Is the Gold Standard for SIPs
XIRR (Extended Internal Rate of Return) handles multiple investments made on different dates and gives a single annualised figure. Because every SIP instalment is a separate cash flow, XIRR is the most accurate way to measure SIP performance. You can calculate it in Microsoft Excel or Google Sheets using the =XIRR(values, dates) function: list every instalment as a negative cash flow with its date, then enter the current value as a positive figure on today’s date.
Using an Online SIP Calculator
The easiest method for most investors is an online SIP calculator offered by fund houses and platforms such as AMFI, Groww and Zerodha Coin. You simply enter your monthly amount, the expected return rate and the duration, and it instantly shows the maturity value and total gains. These tools use the future value formula above, so the result matches a manual calculation.
A Worked Example
- Monthly SIP: Rs 10,000
- Duration: 15 years (180 instalments)
- Expected return: 12% per year
- Total invested: Rs 18 lakh
- Estimated maturity value: about Rs 50 lakh
The same SIP over 20 years would grow to roughly Rs 1 crore, showing how a longer horizon dramatically increases the final corpus thanks to compounding.
Recommended Reading
If you want to understand the mathematics of compounding and disciplined investing in more depth, a good personal finance book can be a worthwhile companion.
Browse Investing Books on Amazon India ↗
Related Guides
To go deeper into SIPs and fund selection, read What Is SIP and How It Works in India and How to Start Investing in Mutual Funds in India. If you are choosing between fund types, see Index Fund vs Mutual Fund.
Frequently Asked Questions
Is the 12% return guaranteed in a SIP?
No. Equity mutual funds are market-linked and returns vary year to year. The 12% figure is a common long-term assumption for equity funds, but actual returns can be higher or lower.
What is the difference between CAGR and XIRR for a SIP?
CAGR assumes a single investment and a single time period, which does not fit a SIP. XIRR accounts for the different dates of each instalment, so it is the correct metric for SIP returns.
Can I calculate SIP returns in Excel?
Yes. Enter each instalment as a negative value against its date, add the current value as a positive figure on today’s date, and use the =XIRR formula to get an accurate annualised return.
Do SIP returns include the effect of taxes?
The calculator shows pre-tax returns. Equity fund gains are subject to capital gains tax, so your in-hand return after redemption will be slightly lower.
Disclaimer: This article is for educational purposes only and does not constitute investment advice. Mutual fund investments are subject to market risks. Please read all scheme-related documents carefully and consult a SEBI-registered investment advisor before investing.