Calculators Investment
XIRR
True annualised return on investments with irregular dates and amounts — enter your actual buy/sell history.
XIRR is the annualised rate r that satisfies Σ CFi / (1 + r)ti = 0, where t is years from the earliest date. Unlike CAGR, XIRR correctly weights each cash flow by its exact date.
What this calculator covers
- True annualised return for any cash flow pattern — XIRR handles multiple investments and withdrawals at different dates, giving a single annualised rate that CAGR cannot provide.
- Mutual fund SIP returns — enter each SIP instalment as Money Out with its actual date; add the current portfolio value as Money In with today's date.
- LIC and insurance policy returns — enter premiums paid as Money Out; maturity value (Sum Assured + bonus) as Money In. Discover the real XIRR behind any policy's projected returns.
- Stock portfolio returns — multiple buy tranches as Money Out; sale proceeds and/or current market value as Money In. Handles partial exits and multiple tranches correctly.
- Clear sign convention — Money Out is your investments, Money In is what you receive. Always enter positive numbers; the calculator applies signs internally.
- Date picker for every row — click the calendar icon or type in DD/MM/YYYY format. Running totals shown per section so you can sense-check your entries.
- Newton-Raphson algorithm — converges to 10−9 tolerance with six starting points; matches Excel's =XIRR() to rounding precision.
XIRR vs CAGR at a glance
| CAGR | XIRR | |
|---|---|---|
| What it measures | Return on a single lump-sum investment | Return on any mix of investments and withdrawals |
| Cash flows | One investment, one exit | Multiple investments and exits at different dates |
| Date handling | Start date and end date only | Actual calendar date for every transaction |
| Use for SIPs | Incorrect — ignores when each instalment was made | Correct — weighs each instalment by its holding period |
| Use for lump-sum | Correct and simpler | Correct — equals CAGR when there is one investment |
| Excel function | No native CAGR(): use (end/start)^(1/years)−1 | =XIRR(values, dates) |
Rule of thumb: use CAGR for one investment, one exit. Use XIRR for everything else.
Frequently asked questions
What is XIRR?
XIRR (Extended Internal Rate of Return) is the annualised return on a series of cash flows at irregular intervals. Unlike CAGR — which assumes a single lump-sum held to a single exit — XIRR accounts for multiple investments and withdrawals at different dates.
It answers: "What constant annual return, applied to each rupee for exactly as long as it was invested, explains my total result?"
XIRR is the correct metric for SIPs, EMIs, LIC premium payments, and any portfolio with multiple buy/sell transactions.
XIRR vs CAGR — what is the difference and when should I use each?
CAGR measures the single annualised return between one start value and one end value over a fixed period. It is correct for a single lump-sum investment.
XIRR generalises CAGR to handle multiple cash flows at different dates, weighing each rupee by how long it was invested.
- Use CAGR when: you made one investment and are checking its current value. Use the CAGR calculator →
- Use XIRR when: you have multiple SIP instalments, LIC premium payments, or stocks bought across different dates.
If you have only one investment and one exit, XIRR equals CAGR exactly.
How do I calculate XIRR for a mutual fund SIP?
Enter each SIP instalment as a Money Out row with its actual date and amount. Then enter the current market value of your units as a single Money In row with today's date.
Example: ₹10,000 per month for 12 months, current value ₹1,28,000 today:
- Add 12 Money Out rows: ₹10,000 each, with the actual dates of each SIP debit.
- Add 1 Money In row: ₹1,28,000, today's date.
Always enter positive numbers — this calculator handles the sign convention internally.
What is a good XIRR for mutual funds in India?
For equity mutual funds over a 5+ year SIP horizon:
- 12–15%: Good. Consistent with long-run Nifty 50 TRI returns.
- 15–18%+: Excellent — typical of mid/small-cap funds in strong cycles. Not guaranteed.
- 8–12%: Acceptable for large-cap or blended funds over shorter periods.
- Below 8%: Underperforming an equity mandate — worth reviewing the fund.
For context: LIC endowment plans typically produce 4–6% XIRR. Tax-saving FDs deliver around 5% post-tax XIRR at the 30% slab.
Why is my XIRR different from the returns shown on Groww or Zerodha?
Common reasons for a mismatch:
- The app is showing absolute return (a simple percentage, not annualised) — this diverges from XIRR over time.
- Cash dividends you received are not included in the app's figure. Add them as Money In rows here.
- Date of current valuation differs by a day — measurable effect on short-duration investments.
- Missing transactions — purchases before you joined a platform may be absent from its history.
How do I calculate XIRR for an LIC policy?
Enter every premium paid (including GST) as a Money Out row with the exact payment date and amount.
Enter the maturity value (Sum Assured + total bonus) as a single Money In row with the maturity date.
If you received survival benefits mid-policy, add those as additional Money In rows too.
The XIRR on traditional LIC endowment plans typically comes out between 4% and 6% — significantly below equity mutual fund returns over the same horizon.
Can XIRR be negative? What does it mean?
Yes. A negative XIRR means your total receipts are worth less than your total investments in present-value terms — the investment destroyed capital, not just grew slowly.
Example: ₹1 lakh invested 3 years ago, current value ₹85,000 — XIRR is approximately −5.5% p.a.
In this calculator, the XIRR result turns red when it is negative.
What is the difference between XIRR and IRR?
IRR (Internal Rate of Return) assumes equal time intervals between cash flows — for example, exactly one payment per year or per month.
XIRR (Extended IRR) uses actual calendar dates, so it handles unequal intervals correctly: a 28-day February, a missed SIP month, or premium payments on different day-of-month across years.
For perfectly regular monthly SIPs, IRR and XIRR are nearly identical. For anything irregular, only XIRR is accurate.
What date should I use for the current portfolio value?
Use today's date for the Money In row that represents your current unrealised portfolio value. If you are calculating XIRR for a fully exited investment, use the actual exit/settlement date.
Date precision matters: a one-day error on ₹10 lakh+ over a short period (under 1 year) can shift XIRR by 0.1–0.5 percentage points.
Does XIRR account for dividends and bonus units?
Cash dividends: add each payment as a Money In row with the actual payment date and net amount received. Without this, XIRR understates your true return.
Bonus units (unit splits or NFO bonus units): no extra row needed. Bonus units are already reflected in your total unit count, which is captured in the current market value you enter as the final Money In row.
How accurate is this XIRR calculator?
This calculator uses Newton-Raphson iteration with six different starting points, converging to a tolerance of 10−9 (nine decimal places). It matches Excel's =XIRR() function to within rounding precision.
The only source of inaccuracy is the data you enter: make sure all dates and amounts are exact, and that the final Money In row uses today's date and the correct current market value.
How do I calculate XIRR for stocks with multiple buy and sell dates?
For each purchase: add a Money Out row with the trade date and total cost (price × quantity + brokerage + STT).
For each sale: add a Money In row with the settlement date and net sale proceeds (after brokerage and STT).
If you still hold shares: add a final Money In row with today's date and the current market value of your remaining holding.
The resulting XIRR reflects your true annualised return across the entire trading history of that position.
Last updated · site changelog