XIRR Calculator
Work out the annualized return (XIRR) for an investment made up of several cash flows on different dates — for example, more than one SIP instalment, a top-up investment, or a partial withdrawal followed by a final redemption. Enter each cash flow with its date and amount below; the calculator weighs every rupee by exactly how long it was invested and solves for the single annual rate that ties them all together.
Fill in the form and select "Calculate" to see your results here.
What is the XIRR Calculator?
This calculator computes XIRR — Extended Internal Rate of Return — the annualized return for an investment with multiple cash flows on irregular dates. A plain CAGR calculation only works for a single amount invested once and redeemed once; the moment you invest in more than one instalment, add a top-up, or make a partial withdrawal, CAGR can no longer represent the return accurately. XIRR is the metric mutual fund registrars actually use to report your annualised return on a Consolidated Account Statement, and it's the right tool whenever your investment history has more than two dates in it.
How to use this calculator
- For each cash flow, choose whether it's an Investment (money going out, e.g. a SIP instalment or lump sum) or a Redemption / Current Value (money coming back, e.g. a withdrawal or the value today).
- Enter the date the cash flow happened and its amount (always entered as a positive number — the type you selected determines the sign).
- Select "+ Add cash flow" for each additional instalment, top-up, or withdrawal. You need at least one Investment and one Redemption / Current Value, on at least two different dates.
- Select "Calculate XIRR" to see your annualized return.
Formula
There is no algebraic way to isolate XIRR from this equation — the rate appears inside an exponent that itself depends on a day count that varies for every cash flow. This calculator solves it the same way spreadsheet software does: iteratively, using the Newton-Raphson method (with a bisection fallback for cash-flow patterns Newton-Raphson doesn't converge on), narrowing in on the rate that makes the right-hand side equal exactly zero.
Example
Suppose you invest ₹10,000 on 1 January 2023, invest another ₹10,000 on 1 July 2023, and the combined investment is worth ₹22,000 when you check its value on 1 January 2024. Entering these three cash flows (two Investments of ₹10,000 each, one Redemption / Current Value of ₹22,000) gives an XIRR of approximately 13.44% p.a. Notice this differs from a naive "total gain ÷ total invested ÷ 1 year" estimate (₹2,000 gain on ₹20,000 invested = 10%) because the first ₹10,000 was invested for a full year while the second was invested for only six months — XIRR correctly weighs each instalment by its own holding period rather than treating all money as invested for the same length of time.
Factors that affect your XIRR
- Timing of each cash flow. The same total amounts invested and redeemed on different dates can produce a meaningfully different XIRR, since each cash flow's contribution is weighted by exactly how many days it was invested.
- Number and size of cash flows. Adding more instalments or withdrawals changes the shape of the equation being solved, not just its total — two investors with the same net invested amount can have different XIRRs if their instalment sizes and timing differ.
- The final valuation date and amount. Since XIRR is only as accurate as the "current value" you enter, using a stale or approximate valuation for an ongoing investment will understate or overstate the true annualized return.
- Cash flow completeness. Leaving out a real cash flow (an instalment you forgot, or a partial withdrawal) will produce an XIRR that doesn't reflect your actual investment history — include every cash flow for an accurate figure.
Frequently Asked Questions
XIRR (Extended Internal Rate of Return) is the annualized return for a series of cash flows that happen on irregular dates and in irregular amounts — multiple SIP instalments, a top-up investment, a partial withdrawal, and so on. CAGR only works cleanly for a single lump sum invested once and redeemed once. Since most real investments involve more than one cash flow at more than one point in time, XIRR is the metric actually used by AMFI-registered mutual fund registrars (CAMS, KFin) to report your "Annualised Return."
Every cash flow is weighted by exactly how many days it sat in the investment relative to the first cash flow, not by a rounded number of months or years. Money invested earlier compounds for longer and pulls the XIRR calculation differently than the same amount invested just before the redemption date, which is why two investors putting in the same total amount can see different XIRR figures if their instalment dates differ.
XIRR solves for the single annual rate that makes the present value of every cash flow — money going out as an investment and money coming back as a redemption or current value — net to zero. Without at least one outflow and one inflow on different dates, there is no rate to solve for, so the calculator requires both before it can compute a result.
Yes. A negative XIRR simply means the investment lost value on an annualized basis over the period entered — for example, if the current value or redemption amount is lower than what was invested. This is a real, valid result and not a calculation error.
This can happen if every cash flow falls on the same date (there's no time gap for a rate to act on) or if the pattern of amounts is unusual enough that no realistic annual rate satisfies the equation. Check that your dates span more than a single day and that you've entered at least one investment and one redemption before trying again.
Related calculators
Calculations are estimates based on the cash flows you enter. Actual returns reported by a fund house or registrar may differ slightly due to rounding conventions, additional cash flows not entered here, or a different valuation date. See our full disclaimer.