XIRR Calculator
Calculate the true annualised return on irregular cashflows — exactly what Excel's XIRR function does. Perfect for evaluating SIPs with top-ups, partial redemptions, mutual fund portfolios bought at different times, or any sequence of investments and withdrawals on uneven dates.
Enter every cashflow with its date. Investments are negative (money out), redemptions and current portfolio value are positive (money in).
Annualised return (XIRR)
14.57%
Iterated 3 times to converge
- Total invested
- ₹2,00,000
- Total received
- ₹2,50,000
- Net gain
- ₹50,000
Sum of all positive minus all negative cashflows
Tip
For a portfolio you currently hold, add today's portfolio value as the final positive cashflow. XIRR will tell you the actual annualised return you've earned across all your irregular contributions and withdrawals — exactly what Excel's XIRR function returns.
How it works
XIRR finds the discount rate r that makes the net present value of all cashflows equal to zero:
NPV(r) = Σ cashflow_i / (1 + r)^(days_i / 365) = 0
where:
cashflow_i = each cashflow (negative for outflows, positive for inflows)
days_i = days between cashflow_i and the first cashflow
r = annualised rate (XIRR)There's no closed-form solution — it's solved iteratively. We use Newton-Raphson as the primary method (typically converges in 5-15 iterations), with bisectionas a fallback for edge cases. The result matches Excel's XIRR to at least 6 decimal places.
How to use
- Enter every contribution as a negative number (money you put in) with its date.
- Enter every redemption as a positive number (money you took out) with its date.
- For a portfolio you still hold, add today's value as the final positive cashflow. Without this, XIRR can't see the unrealised gain.
- Add or remove rows as needed. The calculator updates the XIRR as you type.
- For a typical SIP analysis: 36 monthly entries of -₹X each, then one final positive entry for the current portfolio value.
Frequently asked questions
What is XIRR?
XIRR (Extended Internal Rate of Return) is the annualised return on a series of irregular cashflows — investments and withdrawals on different dates and in different amounts. It's the right metric to use whenever your contributions or redemptions aren't perfectly regular: top-up SIPs, lump-sum additions, partial redemptions, missed instalments, or evaluating a portfolio of different funds bought at different times.
How is XIRR different from CAGR?
CAGR (Compound Annual Growth Rate) assumes a single investment and a single redemption — it can only handle two cashflows. XIRR generalises CAGR to any number of cashflows on any dates. For a one-time investment held to a final date, XIRR equals CAGR. For SIPs, top-ups, or any irregular pattern, XIRR is the correct number; CAGR doesn't apply.
How does the calculator find XIRR?
It uses Newton-Raphson iteration on the Net Present Value equation: find the rate `r` such that the discounted sum of all cashflows equals zero. NPV(r) = sum of cashflow_i / (1 + r)^(days_i / 365). The math is identical to Excel's XIRR function — same convention, same day-count basis. If Newton's method fails to converge for unusual cashflow patterns, the calculator falls back to bisection on the interval (-99.9%, 1000%), which always finds a solution if one exists.
What sign convention should I use?
Money you invest (out of your pocket) is negative; money you receive (redemptions, dividends, current portfolio value) is positive. Example: a ₹10,000 SIP entry should be -10000; a ₹17,000 redemption should be +17000. To find your portfolio's XIRR right now, list all past cashflows with their signs, then add today's portfolio value as a positive final entry.
Why does XIRR sometimes return an error?
XIRR requires at least one negative and one positive cashflow — without both, there's no rate that balances the equation. Common mistakes: forgetting to add the current portfolio value as a positive entry, entering all amounts as positive, or using only positive (income) cashflows. The calculator shows an em-dash with a hint if the inputs aren't valid.
What's a good XIRR for an Indian equity portfolio?
Long-run averages: 12-15% for diversified equity funds over 10+ years. 10-12% for hybrid/balanced. 7-9% for debt. If your XIRR over 5+ years is below the index XIRR for the same period (Nifty 50 / Sensex), consider whether your fund choices, timing, or withdrawal pattern is dragging returns. Don't compare year-1 XIRR — it's noise.
Does XIRR account for taxes?
No — XIRR uses the gross cashflows you provide. To get a post-tax XIRR, enter redemptions net of capital gains tax. For most equity-heavy portfolios with long holding periods, the difference is small (LTCG at 12.5% only on gains above ₹1.25L per year). For debt or short-term equity (taxed at slab), the post-tax XIRR can be significantly lower than the gross.