10.16% a year, not 35.29%
The absolute return ignores timing. XIRR weighs every rupee by how long it was invested, so it is the figure that compares with an FD rate or a fund benchmark — the 35.29% cannot be compared with anything annual.
Free XIRR calculator
Enter every investment and withdrawal with its date, add what the holding is worth now, and see your XIRR — the annualised return that accounts for when each rupee went in — with the total invested, the gain, the absolute return and the FD comparison.
XIRR annualises short periods aggressively. A 5% gain in one month reads as about 80% a year. It is most meaningful over a year or more, and it ignores tax, charges and exit load.
Example cash flows are filled in. Replace them with your own investments and withdrawals, then add the current value.
XIRR is the rate r that makes Σ Ci ÷ (1 + r)^((di − d0) ÷ 365) = 0. For your flows it is 10.16% a year: at that rate the present value of every cash flow adds up to zero.
Total invested ₹1,70,000, total withdrawn ₹20,000, net invested ₹1,50,000, current value ₹2,10,000 on 2026-10-19. Total gain ₹60,000 (35.29% absolute), 1658 days held. The FD comparison grows every flow except the value at 7% a year to 2026-10-19: ₹1,89,548.
XIRR annualises short periods aggressively — a 5% gain in one month reads as about 80% a year — and it ignores tax, charges and exit load.
The table below works the sample through line by line, and the comparison table shows where XIRR sits against an FD at 7% a year. The figures are before tax.
Select Work out my XIRR to keep up to five checks while this page is open.
The sample, worked through
Every figure on the sample: the XIRR, the total invested and withdrawn, the gain, the absolute return, the FD comparison and the years held.
| Date | Type | Cash flow | Years to valuation |
|---|---|---|---|
| 2022-04-05 | Investment | −₹50,000 | 4.54 |
| 2022-10-12 | Investment | −₹25,000 | 4.02 |
| 2023-06-20 | Investment | −₹40,000 | 3.33 |
| 2024-01-15 | Withdrawal | ₹20,000 | 2.76 |
| 2024-08-02 | Investment | −₹30,000 | 2.21 |
| 2025-03-10 | Investment | −₹25,000 | 1.61 |
| 2026-10-19 | Current value | ₹2,10,000 | 0.00 |
The first date, 5 April 2022, is d0 — every other flow is measured from it in days ÷ 365.
| Item | Amount | How it is worked out |
|---|---|---|
| XIRR | 10.16% a year | The rate that makes the present value of all 7 cash flows add up to zero |
| Total invested | ₹1,70,000 | ₹50,000 + ₹25,000 + ₹40,000 + ₹30,000 + ₹25,000 across 5 investments |
| Total withdrawn | ₹20,000 | One withdrawal of ₹20,000 on 15 January 2024 |
| Net invested | ₹1,50,000 | ₹1,70,000 invested − ₹20,000 withdrawn |
| Current value | ₹2,10,000 | Valued on 19 October 2026, 1,658 days after the first investment |
| Total gain | ₹60,000 | ₹2,10,000 + ₹20,000 withdrawn − ₹1,70,000 invested |
| Absolute return | 35.29% | ₹60,000 gain ÷ ₹1,70,000 invested — no timing in this figure |
| FD at 7% a year | ₹1,89,548 | Every flow grown at 7% a year to 19 October 2026 — the withdrawal counts against it |
| Ahead of the FD | ₹20,452 | ₹2,10,000 current value − ₹1,89,548 the FD would have given |
| Years held | 4.54 years | 1,658 days from 5 April 2022 to 19 October 2026 |
The XIRR is worked out at the exact figure of 0.101628 and rounded for display; the FD value is ₹1,89,548.23, shown as ₹1,89,548, and the portfolio is ahead by ₹20,451.77, shown as ₹20,452. The absolute return is ₹60,000 ÷ ₹1,70,000 = 35.29%.
Understand the result
It finds the single yearly rate that makes the present value of all your dated cash flows add up to zero. On the sample, ₹1,70,000 went in across five investments, ₹20,000 came out once, and the holding is worth ₹2,10,000 — the absolute return is 35.29%, but the money was invested at different times over 4.54 years, so the annualised XIRR of 10.16% a year is the figure that compares with anything else. The same flows in an FD at 7% would be worth ₹1,89,548, so this portfolio is ahead by ₹20,452 before tax. And when there is only one investment and one value, XIRR is the same as CAGR — ₹1,00,000 growing to ₹1,33,100 over exactly three 365-day years is 10.00% by either measure.
The absolute return ignores timing. XIRR weighs every rupee by how long it was invested, so it is the figure that compares with an FD rate or a fund benchmark — the 35.29% cannot be compared with anything annual.
Every flow grown at 7% to the valuation date would be worth ₹1,89,548. The comparison is built in, so a return can be judged against the safe alternative, not in isolation — and the ₹20,000 withdrawal counts against the FD figure too.
Microsoft's own XIRR example — ₹10,000 in, ₹13,000 back over 15 months — gives 37.34% here and in Excel. Copy the flows into a sheet and =XIRR(values, dates) returns the same rate.
XIRR suits any investment with more than one dated flow — SIPs, top-ups, partial withdrawals, a portfolio built over years. It does not suit a single lumpsum, where the CAGR calculator gives the same answer more directly. For the future value of a regular SIP, use the SIP calculator; for a one-off investment, the lumpsum calculator; and for drawing an income from the holding, the SWP calculator.
How it works
Start with your cash flows, then the current value.
Date, invest or withdraw, and amount for each one. The sample — six flows from 5 April 2022 to 10 March 2025 — is filled in as the example.
What the holding is worth now — ₹2,10,000 in the sample — and the date it is valued on, 19 October 2026.
The sample gives 10.16% a year — 35.29% absolute, ₹60,000 of gain, and ₹20,452 ahead of an FD at 7%.
Copy the flows into a sheet, list investments as negative and receipts as positive, and use =XIRR(values, dates). It returns the same rate.
The formula
XIRR is the rate r that makes Σ Ci ÷ (1 + r)^((di − d0) ÷ 365) = 0, where Ci is each cash flow — negative when you invest, positive when you receive — di its date and d0 the first date. There is no closed form, so the calculator solves for r with Newton–Raphson from a 0.1 guess and falls back to bisection inside the bracket −0.999999 to 10. Total invested is the sum of the money put in; total withdrawn is the sum taken out; net invested is invested minus withdrawn; total gain is current value plus withdrawn minus invested; absolute return is total gain ÷ total invested. The FD comparison grows every flow except the final value at 7% a year to the valuation date. Years held is (valuation date − first date) ÷ 365. For a single lumpsum, XIRR equals CAGR when the holding period is a whole number of 365-day years; a span containing 29 February gives an XIRR a fraction lower than the calendar-year CAGR.
For a single lumpsum, XIRR equals CAGR only when the holding period is a whole number of 365-day years. CAGR counts whole calendar years, so a span containing 29 February gives an XIRR a fraction lower than the CAGR: ₹1,00,000 growing to ₹1,61,051 from 1 January 2020 to 1 January 2025 is 10.00% by CAGR and 9.99% by XIRR, because the span is 1,827 days rather than 1,825. The reference table below shows the same gap on every row that carries leap days.
XIRR has honest limits, and the page states them: it annualises short periods aggressively, so a 5% gain in one month reads as about 80% a year and a three-month-old SIP can show 50% or more from a small market move. It is most meaningful over a year or more. It ignores tax, charges and exit load — enter the value net of those if you want them reflected — and past performance is not a guarantee of future returns. And where no rate balances the flows, the calculator says there is no XIRR instead of inventing one.
Worked examples
Each example below is shown with the figures this calculator produces, so you can see the method in action. The first three were checked against the published XIRR pages of blogbanking.com, Microsoft and gopocket.in. Select any of the first three to load it into the calculator and check the working for yourself.
A portfolio built over four and a half years: ₹50,000 on 5 April 2022, ₹25,000 on 12 October 2022, ₹40,000 on 20 June 2023, a ₹20,000 withdrawal on 15 January 2024, ₹30,000 on 2 August 2024 and ₹25,000 on 10 March 2025 — ₹1,70,000 invested in all. Valued at ₹2,10,000 on 19 October 2026, the XIRR is 10.16% a year. The absolute return is 35.29% (₹60,000 of gain on ₹1,70,000 invested), but the money went in at different times over 4.54 years, so the annualised figure is the honest one. Had every investment earned 7% in an FD instead, it would be worth about ₹1,89,548 — this portfolio is ahead by ₹20,452 before tax. This is blogbanking.com's worked example, reproduced exactly.
XIRR 10.16% a year · Invested ₹1,70,000 · Gain +₹60,000 · Absolute 35.29%
Microsoft's own XIRR example: ₹10,000 invested on 1 January 2008, then ₹2,750 back on 1 March 2008, ₹4,250 on 30 October 2008, ₹3,250 on 15 February 2009 and ₹2,750 on 1 April 2009. The gain is ₹3,000 on ₹10,000 invested — an absolute return of 30.00% — and the XIRR is 37.34% a year, exactly the figure Microsoft's XIRR help page gives. The short holding period (1.25 years) is doing much of the work: the same gain spread over five years would annualise far lower.
XIRR 37.34% a year · Invested ₹10,000 · Gain +₹3,000 · Absolute 30.00%
A ₹10,000 monthly SIP for 3 years — 36 instalments from 1 April 2023 to 1 March 2026, ₹3,60,000 invested — growing at 1% a month is worth ₹4,35,076 one month after the last instalment, on 1 April 2026. Its XIRR is 12.68% a year, the effective yearly rate of 1% a month (1.01¹² − 1 = 12.68%). The absolute return is 20.85% (₹75,076 of gain), and at 7% in an FD the same instalments would be worth ₹4,00,255 — the SIP is ahead by ₹34,821. This is blogbanking.com's SIP example, with the instalments dated the 1st of each month.
XIRR 12.68% a year · Invested ₹3,60,000 · Gain +₹75,076 · Absolute 20.85%
One investment and one value: ₹1,00,000 on 1 January 2021, worth ₹1,33,100 on 1 January 2024. The XIRR is 10.00% a year — exactly the CAGR, because 1,095 days is exactly three 365-day years and there are no other cash flows. The absolute return is 33.10% on a gain of ₹33,100, and the same money in an FD at 7% would be worth ₹1,22,504. Use the CAGR calculator for lumpsums like this one; XIRR earns its keep when there is more than one flow.
XIRR 10.00% a year · Invested ₹1,00,000 · Gain +₹33,100 · Absolute 33.10%
A loss, stated plainly: ₹1,00,000 invested on 1 March 2021, worth ₹80,000 on 1 March 2024 — a loss of ₹20,000. The XIRR is −7.16% a year — the annual rate at which the money lost value — and the absolute return is −20.00%. The same ₹1,00,000 in an FD at 7% would be worth ₹1,22,527, so this holding is behind by ₹42,527. A negative XIRR is not an error: it is the correct answer when the value is below what was put in.
XIRR -7.16% a year · Invested ₹1,00,000 · Gain −₹20,000 · Absolute -20.00%
₹5,000 every month from 1 April 2020 to 1 March 2025 — 60 instalments, ₹3,00,000 invested — worth ₹5,00,000 on 1 April 2025. The XIRR is 20.53% a year and the absolute return is 66.67% (₹2,00,000 of gain). Treating the same ₹3,00,000 as a single lumpsum invested on day one would suggest a CAGR of only about 10.8% — it ignores that most of the money went in much later. At 7% in an FD the instalments would be worth ₹3,58,016, so this SIP is ahead by ₹1,41,984. This is gopocket.in's worked example, reproduced exactly.
XIRR 20.53% a year · Invested ₹3,00,000 · Gain +₹2,00,000 · Absolute 66.67%
₹5,000 on the 1st of every month in 2023 — 12 instalments, ₹60,000 invested — worth ₹64,163 on 1 January 2024. The XIRR is 13.00% a year and the absolute return is 6.94% (₹4,163 of gain). Each instalment was invested for a different period, which is why the XIRR is nearly double the absolute return over a single year. At 7% in an FD the same instalments would be worth ₹62,261. This is bajajamc.com's example, dated to 2023 — the page states 13% without naming the year, and these dates reproduce it.
XIRR 13.00% a year · Invested ₹60,000 · Gain +₹4,163 · Absolute 6.94%
XIRR, CAGR and absolute return
Three measures, three jobs. The sample's figures show why they disagree: XIRR 10.16% a year, CAGR would need a single lumpsum to even apply, and absolute return 35.29%.
| Measure | Best for | Accounts for timing? | Annualised? | What it means |
|---|---|---|---|---|
| XIRR | SIPs, top-ups, withdrawals, any dated flows | Every cash flow's own date | Yes | The standard measure for your personal return — AMCs report SIP returns as XIRR |
| CAGR | One lumpsum, start value to end value | Start and end dates only | Yes | The figure on a fund factsheet — it cannot see instalments or withdrawals |
| Absolute return | A quick snapshot, holdings under a year | None — gain ÷ invested | No | 35.29% on the sample says nothing about the 4.5 years it took |
Use XIRR for anything with more than one dated flow — that is every SIP. Use CAGR for a single lumpsum on a factsheet. Use absolute return only for a quick snapshot under a year, and never compare it with an annualised figure.
What is a good XIRR?
fundulator.in publishes these bands for equity mutual fund SIPs in India over long periods (5+ years). They are a guide, not a promise — judge any XIRR against the benchmark index over the same dates.
| XIRR | Verdict | What it means |
|---|---|---|
| Below 6% | Poor | Losing to inflation — your real wealth is not growing (fundulator.in) |
| 6–8% | Low | Comparable to an FD or PPF — safe, but a low return for equity risk (fundulator.in) |
| 8–12% | Decent | An average equity SIP over the long term (fundulator.in) |
| 12–15% | Good | A consistent large-cap mutual fund; the Nifty 50 SIP XIRR over 10+ years has historically been about 12–14% (fundulator.in) |
| 15–20% | Excellent | Mid-cap and small-cap outperformance over a long period (fundulator.in) |
| Above 20% | Exceptional — verify it | Check the dates first: a short period or a bull market can inflate it (fundulator.in) |
The sample's 10.16% sits in the Decent band (8–12%) — an average equity SIP, ahead of an FD at 7% but below the 12–15% a good large-cap fund delivers over the long term. The gopocket example's 20.53% sits in the Exceptional band — and the first thing to check there is the five-year holding period behind it.
XIRR against CAGR on single lumpsums
One investment, one value — the only case where CAGR applies. XIRR equals the calendar-year CAGR when the span is a whole number of 365-day years; a span containing 29 February gives an XIRR a fraction lower.
| Invested | From | To | Value | XIRR | CAGR | Days held |
|---|---|---|---|---|---|---|
| ₹1,00,000 | 2021-01-01 | 2024-01-01 | ₹1,33,100 | 10.00% | 10.00% | 1,095 days |
| ₹50,000 | 2022-06-15 | 2024-06-15 | ₹65,000 | 14.00% | 14.02% | 731 days |
| ₹1,00,000 | 2020-01-01 | 2025-01-01 | ₹1,61,051 | 9.99% | 10.00% | 1,827 days |
| ₹2,00,000 | 2019-04-01 | 2024-04-01 | ₹3,22,102 | 9.99% | 10.00% | 1,827 days |
| ₹75,000 | 2023-02-28 | 2025-02-28 | ₹90,750 | 9.99% | 10.00% | 731 days |
| ₹1,00,000 | 2021-03-01 | 2024-03-01 | ₹80,000 | -7.16% | -7.17% | 1,096 days |
The first row is the exact match: ₹1,00,000 to ₹1,33,100 over 1,095 days is 10.00% by both measures. Every other row carries leap days — 731 or 1,827 days — and the XIRR sits 0.01–0.02 points below the CAGR. The gap is the calendar, not an error.
Common mistakes
The calculation is short, but five readings trip people up. Each one can set the result several points wrong.
Investments are money out — negative — and receipts are money in — positive. Flip the signs and the equation has no solution, or solves to a nonsense rate. The form applies the sign from the Invest/Withdraw choice, so check the choice, not the sign.
XIRR needs a final positive flow: what the holding is worth now, with today's date. Without it every flow is money out and there is no return to measure — the calculator will say there is no XIRR.
The value belongs on the date it was measured — the NAV date on your statement, not the day you happen to open the calculator. A value dated a month early understates the holding period and overstates the XIRR.
Every actual payment counts: a skipped SIP month, a top-up, a partial redemption. Missing flows distort the result — fundulator.in warns that skipped months change the cash-flow pattern and the answer with it.
A 5% gain in one month annualises to about 80%. A new SIP can show 50% or more from a small market move. Judge XIRR over a year or more, and against the benchmark over the same dates.
Before you act on the number
Run every result through the same nine checks before you act on it.
Your questions, answered
XIRR (extended internal rate of return) is the single yearly rate that makes the present value of all your cash flows add up to zero, using the actual date of each one. It is the standard way to measure returns on SIPs, top-ups and partial withdrawals, because a simple gain ÷ invested figure ignores when each rupee went in. On the sample it is 10.16% a year, against an absolute return of 35.29%.
List investments as negative amounts and withdrawals or the current value as positive amounts in one column, their dates in another, then use =XIRR(values, dates). This calculator uses the same 365-day convention and gives the same answer — Microsoft's own example gives 37.34% in both. In Google Sheets the same function works.
CAGR measures growth between one start value and one end value, so it only fits a single lumpsum with no other cash flows. XIRR handles many cash flows on different dates, which is what a SIP is. For a single lumpsum held throughout, the two are the same — ₹1,00,000 growing to ₹1,33,100 over exactly three 365-day years is 10.00% by either measure. A span containing 29 February makes the XIRR a fraction lower than the calendar-year CAGR.
Absolute return is total gain ÷ total invested, with no regard to time: 35.29% on the sample. XIRR spreads that gain over how long each instalment was invested, so it is 10.16% a year. In a SIP the last instalments have been invested for only a short time, so the same gain over a shorter average period means a higher annualised XIRR.
Judge it against the right yardstick, over the same dates. fundulator.in puts it this way: below 6% is poor (losing to inflation), 6–8% is comparable to an FD or PPF, 8–12% is a decent average equity SIP, 12–15% is good for a consistent large-cap fund, 15–20% is excellent, and above 20% is exceptional — but verify it, because a short period can inflate it. The Nifty 50 SIP XIRR over 10+ years has historically been about 12–14%.
Yes. If the current value plus withdrawals is less than the total invested, the XIRR is negative — the annual rate at which the money lost value. A ₹1,00,000 investment worth ₹80,000 after three years has an XIRR of −7.16% a year. A negative XIRR is a correct answer, not an error.
XIRR needs at least one money-out and one money-in entry on different dates. If all amounts have the same sign, if every flow falls on the same date, or if the flows cannot balance at any rate — for example a withdrawal first, then investments, then a value that never covers them — there is no answer, and the calculator says so instead of inventing one.
XIRR annualises whatever happened, however short the period. A 5% gain in one month reads as about 80% a year, and a small market move in a three-month-old SIP can show 50% or more. The figure becomes meaningful over a year or more — fundulator.in warns that short-duration SIPs show annualised rates that look extreme for small actual gains.
No. XIRR works on the cash flows you enter: the current value already reflects the fund's expenses through the NAV, but exit load, transaction charges and tax on redemption are not in the figure unless you enter the value net of them. The FD comparison is before tax too.
No. Your cash flows and current value stay in your browser — the calculation runs entirely on this page, nothing is sent to a server, and reloading the page clears your entries. Past performance is not a guarantee of future returns.
XIRR is the rate r that makes Σ Ci ÷ (1 + r)^((di − d0) ÷ 365) = 0, where Ci is each cash flow — negative when you invest, positive when you receive — di its date and d0 the first date. There is no closed form, so the calculator solves for r with Newton–Raphson from a 0.1 guess and falls back to bisection inside the bracket −0.999999 to 10. Total invested is the sum of the money put in; total withdrawn is the sum taken out; net invested is invested minus withdrawn; total gain is current value plus withdrawn minus invested; absolute return is total gain ÷ total invested. The FD comparison grows every flow except the final value at 7% a year to the valuation date. Years held is (valuation date − first date) ÷ 365. Cash-flow dates must lie between 1990-01-01 and 2030-12-31; each flow is from ₹1 to ₹10,00,00,000; at most 120 flows, so a 10-year monthly SIP fits.
The formula is the one Excel's XIRR uses, and the figures were checked 13 November 2026 against four published XIRR pages. blogbanking.com reproduces exactly: six cash flows valued at ₹2,10,000 on 19 October 2026 give 10.16% a year, an absolute return of 35.29%, an FD value at 7% of about ₹1,89,548 and ₹20,452 ahead of the FD; its SIP example of ₹10,000 a month for 3 years, worth ₹4,35,076, gives 12.68%. Microsoft's XIRR help page gives 37.34% for its example, and this calculator returns 37.34%. gopocket.in gives 20.53% for ₹5,000 a month for 5 years, worth ₹5,00,000, and this calculator returns 20.53%. bajajamc.com gives 13% for ₹5,000 a month for 12 months, worth ₹64,163, and this calculator returns 13.00% on 2023 dates. fundulator.in publishes the good XIRR bands used on this page — below 6% poor, 6–8% comparable to an FD, 8–12% decent, 12–15% good, 15–20% excellent, above 20% exceptional — and the Nifty 50 SIP XIRR of about 12–14% over 10+ years. The figures are before tax, and past performance is not a guarantee. For the future value of a regular SIP, the SIP calculator; for a one-off investment, the lumpsum calculator; for the annual growth of a single holding, the CAGR calculator; for drawing an income, the SWP calculator; and for the loan behind the investment, the home loan EMI calculator.
Last updated 13 November 2026.
Try different figures — or run the same check with the related tools for your other plans.