XIRR Calculator
Find the true annualised return on your SIP, mutual fund or any investment with money going in and out on different dates.
Instalments repeat on this day every month up to the valuation date.
Add every investment and withdrawal with its date: lumpsums, irregular SIPs, top-ups or partial redemptions.
| Date | Type | Amount (₹) | Remove |
|---|
From your fund statement or app. Enter 0 if you've fully redeemed.
Your XIRR
—
Total invested
Value + withdrawals
Gain
Absolute return
Simple CAGR
Not sure what to do with this result?
Ask FinChat, our AI planning assistant, about your XIRR result. Free to try, no signup.
Cash flows used in this calculation ·
=XIRR(B2:B99, A2:A99).
| Date | Type | Amount |
|---|
XIRR is calculated the same way as Excel’s XIRR function: actual days between dates divided by 365. Returns are before tax and exit load unless your current value already reflects them. Results are indicative only.
What is XIRR?
XIRR (Extended Internal Rate of Return) is the annualised return on an investment where money goes in or comes out on different dates. It is the single yearly rate that, applied to each cash flow for exactly the time it was invested, turns everything you put in into what you have today.
That makes it the right return measure for SIPs. In a 3-year SIP, your first instalment has been invested for three years but your last for only a month. This is why most investment apps and portfolio trackers show your SIP return as XIRR.
XIRR formula
XIRR is the rate r that makes the present value of all cash flows equal zero:
Here Ci is each cash flow (investments negative, withdrawals and current value positive), di is its date and d0 is the date of the first cash flow. There is no direct formula for r, so it is found by trial and error: guess a rate, check how far the total is from zero, and refine. Excel does the same iteratively; this calculator uses the Newton-Raphson method and matches Excel’s result.
XIRR example: a one-year SIP
Say you invested ₹10,000 on the 1st of every month from January to December 2025, and the investment was worth ₹1,30,000 on 1 January 2026.
- Total invested: ₹1,20,000 across 12 instalments
- Gain: ₹10,000, an absolute return of 8.33%
- XIRR: 15.67% a year
The XIRR is almost double the absolute return because the money wasn’t invested for a full year. On average, each rupee was invested for only about six and a half months. Earning ₹10,000 on ₹1,20,000 in that time works out to about 15.7% a year.
XIRR vs CAGR vs absolute return
| Measure | What it tells you | Use it for |
|---|---|---|
| Absolute return | Total gain as a % of money invested, ignoring time | Holdings under a year |
| CAGR | Yearly growth rate of a single amount from a start date to an end date | One lumpsum, no top-ups or withdrawals; comparing fund or index returns |
| XIRR | Yearly return across many cash flows, each weighted by how long it was invested | SIPs, top-ups, partial withdrawals, your whole portfolio |
For a single lumpsum with no other transactions, XIRR and CAGR give the same answer. With a SIP, a CAGR calculated from total invested to current value understates your return, because it treats every instalment as if it were invested on day one. Try the calculator above: the “Simple CAGR” figure shows how far off it is. To find the CAGR between two values, use the CAGR calculator. To see how a fixed amount compounds, use the lumpsum calculator. To project a future SIP corpus, use the SIP calculator. For a longer walk-through with real fund examples, read XIRR vs CAGR explained.
How to calculate XIRR in Excel or Google Sheets
-
1
Put dates in column A and amounts in column B
Enter each investment as a negative number (−10000) and each withdrawal as a positive number.
-
2
Add today’s value as the last row
Use today’s date and the current value as a positive number, as if you redeemed everything today.
-
3
Use the XIRR function
Type
=XIRR(B2:B14, A2:A14)and format the cell as a percentage. For the example above it returns 15.67%.
Shortcut: open “Cash flows used in this calculation” above and click Copy for Excel / Sheets to paste the exact rows this calculator used.
How to read your XIRR
Compare it with the right benchmark. An equity fund’s XIRR means most when set against the XIRR you would have earned by putting the same SIP into its benchmark index on the same dates, or against what a fixed deposit would have paid over that period.
Be careful with short periods. XIRR annualises returns, so a 3% gain in two months shows up as roughly 19% a year. Treat XIRRs on holdings under a year as noisy.
A negative XIRR means your current value plus withdrawals is less than what you put in. For equity SIPs this is common in the first year or two after a market fall, and says little about long-term returns.
Related Articles
Deep-dive guides to help you make better financial decisions.
XIRR vs CAGR in Mutual Funds: How SIP Returns Work
A SIP XIRR of 4% after three years doesn't mean the fund is broken. It reflects how XIRR mathematically amplifies recen…
Read article →
How Much SIP Per Month Do You Need? Goal-Based Formula
Don't pick a random SIP amount. Here's the reverse formula: start with your goal, work backward to the exact monthly in…
Read article →
SIP Crossover Point: When Gains Exceed Contributions
Your SIP XIRR is volatile for years. Returns look disappointing. Then something shifts: accumulated gains exceed total …
Read article →Explore More Financial Tools
Free calculators and planning tools to help you make smarter financial decisions.