If you invest through a SIP, the return percentage your mutual fund app shows you is probably wrong — or at least, not the number you actually need. That number is usually absolute return or CAGR, and neither one accounts for the fact that you put money in at different times, in different amounts. XIRR does.

What is XIRR?

XIRR stands for Extended Internal Rate of Return. It calculates your annualised return while accounting for the exact date and amount of every cash flow — every SIP instalment, every lump sum top-up, every withdrawal.

In simple terms: if you invested ₹5,000 every month for three years, XIRR tells you the single annual growth rate that explains how your money grew from all those separate instalments into your current fund value.

Why XIRR matters more than CAGR for SIP investors

CAGR assumes one lump sum invested on day one and left untouched. That's rarely how real investors behave. If you're running a SIP, or you've added and removed money at different points, CAGR will either overstate or understate your real return.

Example:

You invest ₹10,000/month for 24 months (₹2,40,000 total)
Current value: ₹2,75,000
Simple absolute return: 14.6%
But that 14.6% happened over an average holding period of about 12 months (since later instalments haven't been invested as long) — not 24 months
XIRR correctly annualises this to roughly 22-24%, because it accounts for when each rupee actually went in

Without XIRR, you'd either underestimate how well your fund is doing, or wrongly compare it against a lump-sum benchmark.

How XIRR is calculated

The formula behind XIRR solves for the rate (r) where:

Sum of [Cash flow ÷ (1 + r)^(days/365)] = 0

Each cash flow (SIP instalment, withdrawal, current value) is discounted based on exactly how many days ago it happened. This is a trial-and-error / iterative calculation — not something you do by hand with a formula on paper. Excel's XIRR() function does it, and so does a dedicated tool.

How to calculate XIRR without building a spreadsheet

Manually building an XIRR spreadsheet means logging every SIP date, every amount, every partial redemption, and getting the formula syntax right. Most investors either skip this entirely or get it wrong (a single incorrect date can shift the result meaningfully).

On Valuezig's fund analytics tool, you can pull up any mutual fund and see its return metrics — including annualised figures calculated the correct way — without maintaining your own spreadsheet. If you're tracking your actual portfolio (not just a single fund), the portfolio tracker applies this same logic across all your holdings and SIPs automatically, so you always know your real annualised return, not an approximation.

XIRR vs CAGR vs Absolute Return: quick comparison

Metric	Accounts for timing of cash flows?	Best used for
Absolute Return	No	Quick, rough sense of gain/loss
CAGR	No (assumes single lump sum)	Comparing lump-sum investments only
XIRR	Yes	SIPs, multiple investments, any real-world cash flow pattern

Common mistakes when interpreting XIRR

Comparing XIRR of a SIP to CAGR of a lump-sum fund — these aren't the same measure, so the comparison is misleading.
Judging XIRR over very short periods (under 1 year) — short-term XIRR can look dramatically high or low due to market timing, not fund quality.
Ignoring the sign convention — investments should be negative cash flows, redemptions/current value positive, or the calculation breaks.

Bottom line

If you're investing via SIP — which most Indian mutual fund investors are — XIRR is the number that actually tells you how your money has grown. CAGR and absolute return will mislead you in either direction depending on your investment pattern.

See your real XIRR across all your mutual fund holdings on the Valuezig portfolio tracker — free, and built specifically for Indian investors.

XIRR Calculator for Mutual Funds — What It Is and How to Calculate It