What Is XIRR in Mutual Funds? Guide to Calculate SIP Returns Correctly

If you have ever wondered why your mutual fund SIP returns look different from what a simple “12% returns” calculation would suggest, you need to understand XIRR. XIRR (Extended Internal Rate of Return) is the most accurate way to measure SIP returns because it accounts for the timing of each monthly investment.

Why CAGR Does Not Work for SIP

CAGR (Compound Annual Growth Rate) works perfectly for lumpsum investments where you invest one amount at the start and let it grow. For example:

• Invest ₹1,00,000 lumpsum
• After 3 years, it becomes ₹1,40,000
• CAGR = (1,40,000 / 1,00,000)^(1/3) - 1 = 11.9%

But SIP is different. You invest ₹5,000 every month. The first ₹5,000 gets 5 years of compounding, while the last ₹5,000 gets only 1 month of compounding. CAGR assumes all money is invested for the same period — which gives a misleading result for SIP.

What Is XIRR?

XIRR is the annualised return that accounts for each cash flow’s timing. It answers the question: “At what constant annual rate would each of these monthly investments need to grow to reach the final portfolio value?”

Simple explanation: XIRR is like CAGR, but for uneven cash flows. It finds the discount rate that makes the net present value of all your cash flows equal to zero.

SIP XIRR Example

Let us walk through a real example:

• SIP amount: ₹10,000 per month
• Duration: 12 months (Jan to Dec 2025)
• Total invested: ₹1,20,000
• Final portfolio value: ₹1,30,000

If you used simple returns: (1,30,000 - 1,20,000) / 1,20,000 = 8.33%

But this ignores the fact that your January investment was invested for 12 months, while your December investment was invested for only 1 month. The true annualised return (XIRR) is higher than 8.33% because most of your money was not invested for the full year.

In this case, the XIRR would be approximately 16.5% — much higher than the simple return of 8.33%. This is why XIRR is the correct measure for SIP returns.

Detailed XIRR Worked Example (3-Year SIP)

Let us walk through a 3-year SIP with real numbers to see how XIRR differs from other return measures.

Scenario: ₹10,000 monthly SIP from January 2021 to December 2023. Total invested: ₹3,60,000.

Step 1 — Unit accumulation: At each month’s NAV, your ₹10,000 buys units. In months 1-6, the NAV fluctuates between ₹100-₹120. In month 7-18, the NAV drops (market correction) to ₹70-₹90, buying more units. In months 19-36, the NAV recovers to ₹130-₹150.

Step 2 — Final value: After 36 months, your total accumulated units are 3,200, and the current NAV is ₹140. Your portfolio value is 3,200 × ₹140 = ₹4,48,000.

Step 3 — Calculating different return measures:

Measure	Calculation	Result
Absolute return	(4,48,000 - 3,60,000) / 3,60,000	24.4%
Simple annualised	(4,48,000 / 3,60,000)^(1/3) - 1	7.6%
XIRR	Accounts for each cash flow date	~13.8%

The absolute return (24.4%) sounds decent but is misleading because it ignores the 3-year time frame. The simple annualised return (7.6%) is wrong because it assumes all ₹3.6 lakh was invested for 3 years — but each ₹10,000 installment was invested for a different duration. The XIRR (13.8%) is the correct annualised return.

Why the gap between CAGR and XIRR?

The CAGR calculation assumes the full ₹3.6 lakh was invested on day one and compounded for 3 years. In reality:

• The first installment (Jan 2021) was invested for 36 months.
• The 18th installment (Jun 2022) was invested for 18 months.
• The last installment (Dec 2023) was invested for only 1 month.

XIRR correctly weights each installment by its investment duration. This is why XIRR is always higher than CAGR for a profitable SIP — because most of your money was not invested for the full period, yet your final portfolio reflects the full growth.

How XIRR Compares Across Market Conditions

Market Condition	Example Period	XIRR Range (10K/mo SIP)	What It Tells You
Bull market (consistent rise)	2012-2015	15-18%	SIP captures full upside
Volatile (crashes + recovery)	2019-2024	14-17%	SIP buys more units during dips
Flat market (no net growth)	2008-2013	6-10%	SIP still generates positive XIRR due to volatility capture
Bear market (sustained decline)	Brief periods	Negative to 2%	XIRR can be negative over short periods

The key insight: in volatile markets (which describe most of India’s history), SIP XIRR tends to exceed the market’s simple CAGR because rupee-cost averaging buys more units during dips.

How Our SIP Calculator Uses XIRR

Our SIP calculator automatically calculates XIRR for every investment scenario. Here is what happens when you use it:

1. You select a fund (e.g., Parag Parikh Flexi Cap Fund)
2. You set your monthly SIP amount (e.g., ₹10,000)
3. You choose a date range (e.g., Jan 2020 to Jan 2025)
4. Our calculator fetches real NAV data for each date
5. It simulates buying units each month at that date’s NAV
6. It calculates the final portfolio value using actual unit accumulation
7. It computes the XIRR using every individual cash flow date

This gives you the true annualised return of that fund over that specific period — not an estimate or projection. The XIRR shown is the exact return a SIP investor would have earned investing in that fund on those dates.

XIRR Formula (Simplified)

The mathematical definition of XIRR is:

0 = Σ [Cash Flowᵢ / (1 + XIRR)^((Dateᵢ - Date₀) / 365)]

Where:

• Cash Flowᵢ is each monthly investment (negative) and the final redemption (positive)
• Dateᵢ is the date of each cash flow
• Date₀ is the date of the first cash flow

This equation is solved through iteration (trial and error) — which is why doing it manually is difficult. Our calculator handles this automatically.

XIRR vs Absolute Returns: Key Differences

Metric	What It Measures	Best Used For
Absolute Return	Total gain as % of investment	Simple understanding, lumpsum
CAGR	Annualised return, single investment	Lumpsum comparisons
XIRR	Annualised return, multiple cash flows	SIP comparisons, withdrawals
Rolling Returns	Returns over overlapping periods	Fund performance evaluation

Why XIRR Matters for Your Investment Decisions

Understanding XIRR helps you:

1. Compare funds accurately — Fund A might show 15% absolute return and Fund B shows 14%, but Fund B might have a higher XIRR if you invested in it more recently

2. Evaluate your SIP performance — A “12% expected return” fund might have delivered 9% XIRR over the last 5 years. This tells you the realistic performance

3. Plan withdrawals — If you plan to do SWP (Systematic Withdrawal Plan), XIRR helps calculate the sustainable withdrawal rate

4. Compare SIP vs lumpsum — XIRR normalises returns so you can compare different investment patterns

Common XIRR Misconceptions

“Higher XIRR always means a better fund” Not necessarily. A fund might show high XIRR over a short period due to market conditions. Always look at 5+ year XIRR for meaningful comparison.

“XIRR is the same as the fund’s reported returns” No. Fund houses report CAGR for lumpsum and a separate number for SIP (sometimes called “SIP returns” or “SIP XIRR”). Our SIP calculator computes the actual XIRR based on real NAV data, which may differ from the fund house’s advertised returns.

“XIRR guarantees future returns” No. XIRR is a backward-looking measure based on historical NAV. Past performance does not guarantee future returns. But it does give you a realistic picture of how the fund has actually performed for SIP investors.

How to Use the SIP Calculator for XIRR Analysis

Try this exercise using our SIP calculator to understand XIRR better:

1. Search for any fund — say HDFC Flexi Cap Fund
2. Set a monthly SIP of ₹10,000 from January 2020 to January 2025
3. Note the XIRR shown in the results
4. Now try the same fund with the same amount but from January 2015 to January 2025
5. Compare the XIRR — the longer period may show lower XIRR due to including more market cycles, but it is a more reliable indicator of the fund’s performance

Key Takeaways

• XIRR is the correct way to measure SIP returns because it accounts for cash flow timing
• CAGR only works for lumpsum where all money is invested for the same period
• Our SIP calculator automatically computes XIRR using real NAV data
• Always look at 5+ year XIRR for meaningful fund comparisons
• XIRR is backward-looking — use it to evaluate past performance, not predict future returns