Calculate the XIRR (Extended Internal Rate of Return) for a series of irregular cash flows - useful for investments with uneven timing, like SIPs, redemptions, or multiple lump-sum entries and exits.
Cash Flows
Enter investments (money going out) as negative amounts and returns/redemptions (money coming in) as positive amounts.
How to Use the XIRR Calculator
For each transaction, enter its "Date" and "Amount (₹)".
Enter investments as negative amounts (e.g. -50000) and returns/redemptions as positive amounts (e.g. 65000).
Use "Add Cash Flow" to add more rows, or the × button to remove one (at least two rows are required).
Click "Calculate XIRR" to see the annualized rate of return across all your cash flows.
What XIRR Actually Solves
XIRR is the single annual rate r at which the present value of all your cash flows adds up to zero: the sum of each amount ÷ (1 + r)^t = 0, where t is the number of days from the first cash flow to that cash flow, divided by 365. There is no direct formula for r, so the calculator starts from a guess of 10% and refines it repeatedly until the answer stops changing. Put simply, XIRR is the steady yearly return a bank account would have needed to pay to turn exactly your deposits, on exactly your dates, into exactly your withdrawals and final value.
Worked Examples
Two investments and one redemption: you invest ₹1,00,000 on 1 January 2023 and another ₹50,000 on 1 January 2024, then redeem everything for ₹1,80,000 on 1 January 2025. Your gain is ₹30,000 on ₹1.5 lakh, which looks like 20%. But the first ₹1 lakh was invested for two years and the ₹50,000 for only one, so the XIRR is about 11.45% a year.
Date
Amount to enter (₹)
01-01-2023
-100000
01-01-2024
-50000
01-01-2025
180000
A monthly SIP: you invest ₹10,000 on the 5th of every month from January to December 2025, and on 5 January 2026 the holding is worth ₹1,30,000. That is ₹10,000 of gain on ₹1,20,000 invested, an absolute return of 8.33%. Yet the XIRR is about 15.67%, because on average each instalment was invested for only around six and a half months. Enter the twelve instalments as -10000 each and the current value as 130000 on the valuation date.
XIRR, CAGR and Absolute Return Compared
Measure
What it tells you
Best used for
Absolute return
Total gain as a percentage of money invested, ignoring time
Holdings of under a year, or a quick check
CAGR
Yearly growth rate between one starting value and one ending value
A single lump-sum investment, or comparing a fund's point-to-point performance
XIRR
Yearly return that accounts for the amount and date of every cash flow
SIPs, top-ups, partial withdrawals, SWPs, or a whole portfolio
With just one investment and one redemption, XIRR and CAGR give almost the same answer. For ₹1 lakh invested on 1 April 2020 that became ₹2 lakh on 1 April 2025, CAGR is 14.87% and XIRR is 14.86%; the tiny gap arises because XIRR counts actual days, including the 29 February in 2024.
Tips for an Accurate Result
If you still hold the investment, add its current market value as a positive amount dated today. This is how mutual fund statements and portfolio apps calculate the XIRR they show.
Use the actual transaction dates from your account statement, not the dates you placed the orders. A few days rarely matters over years, but over a few months it can shift the result noticeably.
Be careful with periods under a year. XIRR annualises the return, so a 3% gain in one month shows up as an XIRR of over 40%, which you would only earn if that pace continued all year.
Include every rupee that came back to you, such as dividends paid out or partial redemptions, as positive amounts on their dates. Leaving them out understates your return.
Frequently Asked Questions
XIRR calculates the annualized return for cash flows that happen on irregular dates and amounts, like SIPs or multiple lump-sum investments and withdrawals. CAGR only works for a single investment and a single withdrawal, assuming smooth compounding in between.
It finds the rate that makes the XNPV (extended net present value) of all your cash flows equal to zero, using the Newton-Raphson iterative method. Each cash flow is discounted based on the number of days between its date and the first cash flow's date, divided by 365.
XIRR measures the return on money invested (outflows) versus money received back (inflows). Without at least one of each, there's no meaningful rate of return to solve for.
Yes. If the total you got back, including the current value, is less than what you put in, the XIRR is negative. For example, investing ₹1,00,000 and having it worth ₹90,000 one year later gives an XIRR of about -10%. A negative XIRR on a recent SIP is common after a market fall and says little about the long-term result.
The method searches for the rate step by step and can fail when the cash flows are unusual, for instance when the return is extremely large or close to -100% over a very short period, or when money goes in and out several times so that more than one rate fits. Check that every investment is negative, every receipt is positive, and the dates are right. Splitting a long, complicated history into simpler periods also helps.