Smart Investment Analysis
XIRR Calculator
Calculate Your Real Annualized Investment Returns
Calculate annualized returns for investments with multiple transactions on different dates. Analyze SIP contributions, additional investments, partial withdrawals, and final redemption values using our free XIRR Calculator.
- Multiple Cash Flow Analysis
- Date-Based Return Calculation
- Free Online Calculator
Calculate Your Investment Returns
Enter your actual investment and withdrawal transactions with their corresponding dates to estimate your annualized XIRR.
Investment money you paid in — a negative cash flow.
Withdrawal money you received — a positive cash flow.
| Transaction Date | Transaction Type | Amount (₹) | Action |
|---|
Use this only when you want your present portfolio value treated as the terminal value of the analysis. Do not add an ending value if you have already entered a redemption on the same date — that would double-count the same money.
Annualized XIRR
—
XIRR is an annualized rate, not the same thing as your absolute profit. A 20% absolute gain over four years is a very different annualized result from a 20% gain over six months. XIRR is a measurement of the cash flows you entered — it is not a promise or projection of future returns.
This calculator is provided for educational and informational purposes only. XIRR is an estimate based on the cash flows and dates entered by the user. Results depend on the accuracy of the inputs and the assumptions used in the calculation. Past performance does not guarantee future results. Mutual fund investments are subject to market risks. Please read all scheme-related documents carefully before investing. This tool does not provide personalized investment advice or guarantee returns.
How to Use the XIRR Calculator
- Enter each transaction date. Use the actual date on which the money left or entered your portfolio — not the date of the folio statement.
- Choose the transaction type. Investments and deposits are negative cash flows. Withdrawals and final redemption values are positive cash flows.
- Enter the amount in rupees. Always enter a positive number. The calculator applies the correct sign from the transaction type you selected.
- Add every relevant transaction. Missing a single instalment or withdrawal changes the annualized result.
- Add your final value. The last positive cash flow should represent either a redemption you actually received or your current portfolio value on the valuation date.
- Press Calculate XIRR. The calculator solves for the annualized rate that makes the present value of all your cash flows equal to zero.
XIRR Formula Explained
XNPV(r) = Σ [ CFᵢ ÷ (1 + r)(dᵢ − d₀) ÷ 365 ] = 0
- CFᵢ — the signed cash flow of transaction i. Investments are negative, withdrawals and redemptions are positive.
- dᵢ — the date on which cash flow i occurred.
- d₀ — the earliest transaction date in the series.
- r — the annualized XIRR. This is the unknown the calculator solves for.
- 365 — the fixed day-count convention used to convert calendar days into years.
Because r appears inside an exponent, the equation cannot be rearranged into a simple closed-form answer. The calculator uses a numerical solver: it first brackets the rate between two values where the equation changes sign, then narrows the interval with bisection, and finally refines the answer with a Newton–Raphson step. The process stops when the result is stable to a very high precision.
How to Calculate XIRR for SIP Investments
A monthly SIP is the classic case where XIRR is more useful than a simple return figure. Each instalment is invested on a different date, so each rupee has been invested for a different length of time. XIRR accounts for that automatically.
What to enter
- Every SIP instalment as an Investment / Deposit on its actual debit date.
- Any lump-sum top-ups as separate Investment rows.
- Every partial withdrawal as a Withdrawal row.
- The current portfolio value, or the final redemption amount, as a Final Value / Redemption row.
What to avoid
- Do not enter the SIP amount once and multiply it — each instalment needs its own date.
- Do not enter a redemption and an ending portfolio value for the same date.
- Do not enter investments as positive numbers — that reverses the result.
- Do not mix the folio date with the bank debit date if they differ.
If you are still building your SIP plan, the SIP Calculator can help you project contributions, while the Step-Up SIP Calculator handles annual increases in your instalment amount. Once you have real transactions, come back here to measure what actually happened.
XIRR vs CAGR
Both XIRR and CAGR express a return as an annualized percentage, but they are designed for different situations. Choosing the wrong one is one of the most common reasons investors get confused about their own performance.
| Point of Comparison | XIRR | CAGR |
|---|---|---|
| Suitable cash-flow pattern | Multiple cash flows in and out, on different dates | One initial investment and one final value |
| Treatment of multiple transactions | Handles any number of dated transactions | Not designed for interim transactions |
| Treatment of irregular dates | Uses the exact date of every cash flow | Uses only the total holding period |
| Common use cases | SIPs, multiple top-ups, partial withdrawals, portfolio-level returns | Lump-sum investment held for a fixed period |
| Important limitations | Requires a numerical solver; some cash-flow patterns may have more than one mathematical root | Ignores the timing of any money added or removed during the period |
In short: CAGR is generally appropriate for a single initial value and a final value over a period, whereas XIRR is useful when there are multiple dated cash flows. If you want to check a one-time investment, use the CAGR Calculator or the Lumpsum Calculator. If your money moved in and out on several dates, this XIRR Calculator is the right tool.
How to Interpret Your XIRR Result
Positive XIRR
The cash flows you entered produced a gain on an annualized basis. A higher number means the money grew faster relative to the time it was invested — but it says nothing about whether that pace will continue.
Negative XIRR
The cash flows you entered produced a loss on an annualized basis. This is a normal outcome for investments held through a market decline or redeemed early.
XIRR Near Zero
The money broadly returned to its invested value over the period, after accounting for the timing of each cash flow.
There is no single XIRR percentage that is universally "good". A suitable result depends on the asset class, the time period, the risk taken, and your own financial goals. Compare your XIRR against a relevant benchmark for the same period rather than against a fixed number.
Common XIRR Calculation Mistakes
- Incorrect transaction signs. Entering an investment as a positive number flips the entire result.
- Wrong dates. Using the statement date instead of the actual transaction date distorts the time weighting of every cash flow.
- Omitted withdrawals. Ignoring money you already took out misrepresents the money you actually received.
- Double-counting the ending value. Adding both a redemption and a current portfolio value on the same date counts the same money twice.
- Confusing annualized and absolute returns. A 30% absolute gain over five years is roughly a 5.4% annualized return, not 30% per year.
- Forgetting the first instalment. The very first SIP debit is a real cash flow and must be included.
Is XIRR the Same as Mutual Fund Returns?
No. XIRR is a calculation method for a series of dated cash flows. It is not a mutual fund scheme, a category, or an assurance of future performance. When a fund house or an advisor quotes an "XIRR" for your portfolio, they are simply applying this same method to your actual transaction history.
Two investors in the same mutual fund can have different XIRR values for the same period, because their entry dates and amounts differ. That is expected behaviour, not an error.
Frequently Asked Questions About XIRR
What is XIRR in simple words?
XIRR is the single annualized percentage that describes how your money grew, given that it went in and came out on different dates. It is the annual rate at which every one of your cash flows would need to be discounted so that they exactly balance out.
How do I calculate XIRR for a monthly SIP?
List every SIP instalment as a negative cash flow on its actual debit date, and list the current portfolio value or final redemption as a positive cash flow on the valuation date. Then solve for the rate that balances them. This calculator does that automatically once you enter the rows.
Is XIRR better than CAGR?
Neither is universally better — they answer different questions. CAGR is appropriate when there is one investment at the start and one value at the end. XIRR is appropriate when money moved in or out at multiple points in time.
Can XIRR be negative?
Yes. A negative XIRR simply means the dated cash flows produced a loss on an annualized basis over the period you entered.
Why is my XIRR calculation failing?
The most common causes are: a missing date or amount, all transactions having the same sign, all dates being identical, fewer than two transactions, or a cash-flow pattern where the solver cannot establish a stable solution. The calculator reports the specific problem instead of showing a made-up number.
Can XIRR be more than 100%?
Mathematically, yes. A short holding period with a large gain can produce a very high annualized figure. That number is arithmetically valid but should not be read as a rate you can expect to repeat.
Does XIRR include withdrawals?
Yes. Withdrawals are positive cash flows and must be included. Leaving them out misrepresents the timing and size of the money you actually received.
Is XIRR a guaranteed return?
No. XIRR is a backward-looking measurement of cash flows that have already happened. It carries no assurance about future performance.
What is the difference between XIRR and absolute return?
Absolute return is the simple total gain expressed as a percentage of the money invested, with no regard for how long the money was invested. XIRR annualizes the result and accounts for the exact date of every cash flow.
Can I calculate XIRR in Excel?
Yes. Microsoft Excel and Google Sheets both provide an XIRR function that accepts a range of values and a matching range of dates. The method is the same one used here — only the interface differs.
Turn Numbers Into A Plan
A calculator tells you what happened. Sound financial education tells you what to do next. Explore our free guides, or reach out for a conversation about your goals.
Financial Disclaimer
This calculator is provided for educational and informational purposes only. XIRR is an estimate based on the cash flows and dates entered by the user. Results depend on the accuracy of the inputs and the assumptions used in the calculation. Past performance does not guarantee future results. Mutual fund investments are subject to market risks. Please read all scheme-related documents carefully before investing. This tool does not provide personalized investment advice or guarantee returns.