If you invest via SIP, you’ve probably seen “returns” quoted as CAGR. But CAGR doesn’t accurately measure SIP returns because your money is invested at different times. That’s where XIRR comes in — it’s the correct way to measure how your SIP is actually performing.
Quick Answer: XIRR (Extended Internal Rate of Return) calculates the annualized return on investments made at irregular intervals — like monthly SIPs. Unlike CAGR which assumes a single lump sum, XIRR accounts for each individual cash flow and its timing, giving you the true return on your SIP.
Why CAGR Doesn’t Work for SIP
CAGR (Compound Annual Growth Rate) assumes you invested all your money at once on Day 1. But in a SIP, you invest ₹5,000 every month — so your first installment has been invested for 12 months, your second for 11 months, your third for 10 months, and so on.
Using CAGR for SIP returns either overstates or understates your actual returns because it ignores the timing of each investment. XIRR solves this by considering every cash flow and its exact date.
A Simple Example
Say you invest ₹10,000/month for 12 months (total invested: ₹1,20,000) and your portfolio value after 12 months is ₹1,32,000.
- Simple return: (₹1,32,000 – ₹1,20,000) / ₹1,20,000 = 10% — but this is misleading
- CAGR: Would treat it as if ₹1,20,000 was invested on Day 1 — incorrect
- XIRR: Accounts for each ₹10,000 installment date — gives the true annualized return (~18-20% in this case)
The XIRR is higher than the simple return because your later installments were invested for a shorter period but still earned returns.
How XIRR Works
XIRR calculates the discount rate that makes the Net Present Value (NPV) of all cash flows equal to zero. In simpler terms, it finds the single annualized rate of return that explains all your investments and the final value.
Each SIP installment is treated as a negative cash flow (money going out), and the current portfolio value is treated as a positive cash flow (money coming back).
How to Calculate XIRR in Excel/Google Sheets
The formula is straightforward:
=XIRR(values, dates)
Step-by-Step Example: 12-Month SIP of ₹5,000
Set up your spreadsheet like this:
Formula: =XIRR(B1:B13, A1:A13)
Result: ~18.5% (this is your annualized SIP return)
Key Rules for XIRR Calculation
- SIP investments must be entered as negative numbers (money going out)
- Current portfolio value must be positive (money coming back)
- Dates must be in proper date format
- There must be at least one positive and one negative value
- Multiply the result by 100 to get percentage
XIRR Benchmarks: What’s Good?
Note: These benchmarks are for equity funds over 3+ year periods. Debt funds will have lower XIRR (6-8% is good). Also, XIRR can be misleading for very short periods (under 1 year) — it annualizes returns, so a 5% gain in 2 months shows as ~30% XIRR.
XIRR vs CAGR vs Absolute Returns
Where to Check Your XIRR
Most investment platforms now show XIRR automatically:
- Groww, Zerodha Coin, Kuvera: Show XIRR in portfolio section
- MF Central (by AMFI): Consolidated view of all mutual fund investments with returns
- Excel/Google Sheets: Use the XIRR formula for manual calculation
- Value Research, Moneycontrol: Portfolio trackers with XIRR calculation
FAQs
Why is my XIRR different from the fund’s published returns?
Fund houses publish CAGR based on NAV growth over specific periods. Your XIRR depends on when you started your SIP, how much you invested, and whether you made any additional lump sum investments or withdrawals. Two investors in the same fund can have different XIRRs based on their investment timing.
Can XIRR be negative?
Yes. A negative XIRR means your investments have lost value overall. This can happen during market downturns, especially if you’ve been investing for a short period. Don’t panic — if you’re invested in good funds, continue your SIP and the XIRR should improve over time as markets recover.
Should I check XIRR frequently?
Checking once every 6 months or annually is sufficient. Frequent checking leads to anxiety during market dips. For SIPs, focus on the 3-5 year XIRR rather than short-term fluctuations. If your 3+ year XIRR is consistently below the benchmark, consider switching funds.
How is XIRR different from IRR?
IRR assumes equal time periods between cash flows (e.g., exactly monthly). XIRR uses actual dates, making it more accurate for real-world SIPs where dates may vary (weekends, holidays). For practical purposes, always use XIRR for your SIP return calculation.
Related Articles
- What Is CAGR? How to Calculate Investment Returns
- What Is SIP? A Beginner’s Guide to Systematic Investment Plans
- SIP vs Lump Sum: Which Is the Better Way to Invest?
- What Is Compound Interest? The Power of Compounding
- What Is Expense Ratio in Mutual Funds?
Conclusion
XIRR is the most accurate way to measure your SIP returns. Unlike CAGR, it accounts for the timing of each investment, giving you a true picture of how your money is performing. Use the XIRR function in Excel or Google Sheets to calculate it yourself, or rely on your investment platform’s built-in calculation. Aim for a 12%+ XIRR on equity SIPs over 3-5 years, and use it as a tool to evaluate whether your fund choices are working for you.