One of the most common questions SIP investors ask after their first year of investing is: "How do I know what return my SIP is actually earning?" It's a surprisingly tricky question. Unlike a fixed deposit, where the return is stated upfront and guaranteed, a SIP's return depends on the timing and amount of each instalment, the current value of the portfolio, and the period over which you're measuring. Three different return metrics — absolute return, CAGR, and XIRR — are commonly used, and each tells a different story. This article explains all three, shows you how to calculate them, and helps you understand which one to use when evaluating your SIP performance.
The three return metrics: absolute, CAGR, and XIRR
Before diving into calculations, let's understand what each metric measures and when it's appropriate to use:
Absolute return is the simplest metric: the percentage gain or loss on your investment, calculated as (current value − invested amount) / invested amount × 100. If you invested ₹1,00,000 and your portfolio is now worth ₹1,15,000, your absolute return is 15%. Absolute return is useful for a quick sense of total gain, but it doesn't account for the time period — a 15% return in 1 year is excellent, while a 15% return in 10 years is poor. Absolute return also doesn't account for the timing of investments, making it misleading for SIPs where instalments are spread over time.
CAGR (Compound Annual Growth Rate) is the annualized return assuming a single lump-sum investment. It's calculated as (final value / initial value)^(1/years) − 1. If you invested ₹1,00,000 as a lump sum 5 years ago and it's now worth ₹1,61,051, your CAGR is 10% per year. CAGR is useful for comparing lump-sum investments, but it's misleading for SIPs because it assumes a single investment at the start, not multiple investments over time. Using CAGR for a SIP understates the actual return because later instalments have had less time to compound.
XIRR (Extended Internal Rate of Return) is the most accurate return metric for SIPs. It calculates the annualized return that makes the net present value of all cash flows (investments as negative, redemptions as positive) equal to zero. XIRR accounts for the timing and amount of each individual cash flow, making it the correct metric for any investment with multiple inflows or outflows at different times — which is exactly what a SIP is. When your mutual fund platform shows your "SIP return," it's (or should be) using XIRR.
Why XIRR is the correct metric for SIPs
To understand why XIRR is correct and CAGR is misleading for SIPs, consider this example. You start a ₹10,000/month SIP on January 1, 2024, and continue for 12 months. Total invested: ₹1,20,000. On December 31, 2024, your portfolio is worth ₹1,30,000. What's your return?
Absolute return = (₹1,30,000 − ₹1,20,000) / ₹1,20,000 × 100 = 8.33%. This tells you your total gain but not the annualized rate, and it doesn't account for the fact that your first ₹10,000 was invested for 12 months while your last ₹10,000 was invested for only 1 month.
CAGR (incorrectly applied) = (₹1,30,000 / ₹1,20,000)^(1/1) − 1 = 8.33%. For a 1-year period, CAGR equals absolute return. But this is misleading because it treats the ₹1,20,000 as if it was all invested on January 1 — when in reality, only ₹10,000 was invested then, and the rest was invested over the subsequent 11 months. The "true" return on your money is higher than 8.33% because most of your capital was invested for less than 12 months.
XIRR = approximately 14.8%. This is the correct annualized return, accounting for the fact that each ₹10,000 instalment was invested for a different length of time. The first instalment (January 1) earned returns for 12 months; the last instalment (December 1) earned returns for only 1 month. XIRR weights each instalment's return by its time invested, producing the true annualized return.
How to calculate XIRR in Excel and Google Sheets
Calculating XIRR manually is complex (it requires iterative numerical methods), but Excel and Google Sheets have a built-in XIRR function. Here's how to use it:
- Create a table with two columns: Date and Cash Flow.
- Enter each SIP instalment as a negative number (cash outflow) with its date. E.g., 2024-01-01: −10000, 2024-02-01: −10000, etc.
- Enter the current portfolio value as a positive number (what you would receive if you redeemed today) with today's date. E.g., 2024-12-31: +130000.
- Use the XIRR function: =XIRR(cash_flow_range, date_range). The result is your annualized SIP return.
Most mutual fund platforms (Groww, Zerodha Coin, Kuvera, Paytm Money) automatically calculate and display XIRR for your SIP investments, so you typically don't need to calculate it manually. But understanding how it's calculated helps you verify the numbers and compare returns across platforms.
How to track your SIP returns over time
Tracking SIP returns is not a one-time exercise — it's an ongoing practice that helps you evaluate fund performance and stay motivated. Here's a recommended tracking cadence:
Monthly: Check your portfolio value and total invested amount. Note the absolute gain/loss. Don't calculate XIRR monthly — the short time period makes it noisy and potentially misleading. This is just a quick check to ensure everything is working.
Quarterly: Calculate your 1-year rolling XIRR (last 4 quarters' data). Compare to your expected return rate (e.g., 12% for equity SIPs). If the XIRR is within ±3% of your expected rate, the SIP is on track. If it's significantly lower, investigate — but don't panic, as quarterly XIRR can be volatile.
Annually: Calculate your full-period XIRR (since SIP start date). Compare to the fund's benchmark index return over the same period. If your fund's XIRR is within 1–2% of the benchmark, it's performing as expected. If it's consistently 3%+ below the benchmark over 3+ years, consider switching to a different fund or an index fund.
Every 5 years: Comprehensive portfolio review. Compare your actual XIRR to your financial plan's assumed return rate. If actual returns are significantly below assumptions, you may need to increase your SIP amount, extend your tenure, or adjust your goals. Use the SIP Calculator to re-model your plan with the actual return rate.
Common return-tracking mistakes
Mistake 1: Using CAGR instead of XIRR for SIPs. Many investors and even some financial advisors use CAGR for SIP returns, which understates the actual return. Always use XIRR for any investment with multiple cash flows at different times.
Mistake 2: Comparing SIP returns to lump-sum returns. A 12% XIRR on a SIP is not the same as a 12% CAGR on a lump sum. The SIP's 12% XIRR means each instalment earned approximately 12% annualized over its specific holding period — the effective total return on all invested capital is different. Don't compare apples to oranges.
Mistake 3: Panicking over short-term XIRR. A 1-year XIRR of −5% on an equity SIP is normal during a market downturn. It doesn't mean the SIP is failing — it means the market is down, and your SIP is buying units at lower prices. Evaluate SIP returns over 3+ year periods, not months.
Mistake 4: Ignoring benchmark comparison. A 10% XIRR on your equity SIP sounds good — until you realize the Nifty 50 returned 14% over the same period, meaning your fund underperformed by 4%. Always compare your SIP's XIRR to the appropriate benchmark (Nifty 50 for large-cap funds, Nifty Midcap 150 for mid-cap funds, etc.) to evaluate whether the fund is adding or destroying value.
What XIRR should you expect?
Expected XIRR depends on the type of fund and the time horizon:
- Equity large-cap funds (index or active): 10–13% XIRR over 5+ years. In any given 1-year period, XIRR could range from −20% to +40%.
- Equity flexi-cap/mid-cap funds: 11–15% XIRR over 7+ years, with higher volatility (−30% to +50% in any year).
- Debt funds: 5–7% XIRR with very low volatility.
- Hybrid funds: 8–10% XIRR with moderate volatility.
These are historical averages, not guarantees. Your actual XIRR will depend on market conditions during your specific investment period. Use these ranges to set realistic expectations and to evaluate whether your SIP is performing within the normal range for its category.
Using the SIP Calculator for return planning
The SIP Calculator uses a single assumed return rate (that you specify) to project future corpus. This is a planning tool, not a tracking tool — it doesn't calculate your actual XIRR. Use the SIP Calculator for forward-looking planning ("if I invest ₹X at Y% for Z years, I'll have ₹W"), and use your platform's XIRR display (or the Excel method above) for backward-looking tracking ("my SIP has earned X% annualized since I started").
If your actual XIRR after 3+ years is significantly different from the rate you assumed in the SIP Calculator, re-run the calculator with the actual rate to see if you're still on track for your goal. If not, adjust your monthly SIP amount or tenure accordingly. This annual recalibration is essential for staying on track to your financial goals.
The return you don't measure is the return you can't improve. Track your SIP's XIRR annually, compare it to the benchmark, and adjust your plan if reality diverges from assumptions. What gets measured gets managed.
The bottom line
Tracking your SIP returns requires understanding three metrics: absolute return (for quick total-gain sense), CAGR (for lump-sum investments only), and XIRR (the correct metric for SIPs with multiple cash flows). Calculate your SIP's XIRR annually using your platform's built-in display or the Excel XIRR function, compare it to your fund's benchmark index, and evaluate whether you're within the expected range for your fund category. Don't panic over short-term XIRR fluctuations — equity SIP returns are volatile over periods under 3 years. Use the SIP Calculator for forward-looking planning and XIRR for backward-looking tracking. Together, they give you a complete picture of your SIP journey — where you're going and how fast you're getting there.