Free XIRR calculator

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.

✓ Free to use ✓ No signup ✓ Browser calculation
10.16% a year The sample's XIRR — 6 cash flows valued on 19 October 2026
₹60,000 gain · 35.29% absolute ₹1,70,000 invested, ₹20,000 withdrawn, worth ₹2,10,000
Figures checked 13 November 2026 Against blogbanking.com, Microsoft's XIRR example and gopocket.in

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.

Work out your XIRR

Main example — 6 cash flows, ₹2,10,000 on 19 Oct 2026

Example cash flows are filled in. Replace them with your own investments and withdrawals, then add the current value.

6 cash flows · up to 120 cash flows, so a 10-year monthly SIP fits

YOUR XIRR EXTENDED INTERNAL RATE OF RETURN · % A YEAR

Your XIRR

10.16%
10.16% a year XIRR
₹1,70,000 TOTAL INVESTED
₹20,000 TOTAL WITHDRAWN
₹2,10,000 CURRENT VALUE
+₹60,000 TOTAL GAIN
35.29% ABSOLUTE RETURN
Net invested ₹1,50,000 (71.4% of current value) Gain ₹60,000 (28.6% of current value)
Your XIRR at a glance Your XIRR is 10.16% a year — ₹60,000 of gain on ₹1,70,000 invested over 4.54 years. The absolute return is 35.29%, and at 7% in an FD the same flows would be worth ₹1,89,548 — you are ₹20,452 ahead of the FD before tax.

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.

Recent checks · this session

Select Work out my XIRR to keep up to five checks while this page is open.

The sample, worked through

The sample's XIRR: 10.16% a year, line by line

Every figure on the sample: the XIRR, the total invested and withdrawn, the gain, the absolute return, the FD comparison and the years held.

Cash flows in date order — money out is negative, money in is positive, as in Excel's XIRR.
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.

XIRR — sample: 6 cash flows, ₹2,10,000 on 19 October 2026.
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

What does an XIRR calculator do?

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.

01 / TIMING IS THE WHOLE POINT

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.

02 / JUDGED AGAINST THE SAFE ALTERNATIVE

₹20,452 ahead of an FD at 7%

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.

03 / THE SAME ANSWER AS EXCEL

37.34% on Microsoft's example

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

From cash flows to your XIRR

Start with your cash flows, then the current value.

01

Enter your cash flows

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.

02

Enter the current value

What the holding is worth now — ₹2,10,000 in the sample — and the date it is valued on, 19 October 2026.

03

Read your XIRR

The sample gives 10.16% a year — 35.29% absolute, ₹60,000 of gain, and ₹20,452 ahead of an FD at 7%.

04

Check it against Excel

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

How XIRR is worked out

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.

The XIRR equation Σ Ci ÷ (1 + r)^((di − d0) ÷ 365) = 0 · Ci is each cash flow, di its date, d0 the first date
1. The equation Σ Ci ÷ (1 + r)^((di − d0) ÷ 365) = 0 Each flow is discounted back to 5 April 2022, the first date, at the rate r. Investments are negative, receipts are positive, and the rate that makes them add up to zero is the XIRR.
2. Solving it At 10% the flows add up to ₹710; at 10.16% they add up to ₹0 There is no formula for r, so the calculator solves it with Newton–Raphson from a 0.1 guess, falling back to bisection inside the bracket −0.999999 to 10. It converges in a handful of steps.
3. The FD comparison Every flow at 7% to 19 October 2026: ₹1,89,548 ₹50,000 for 4.54 years, ₹25,000 for 4.02 years, ₹40,000 for 3.33 years, ₹30,000 for 2.21 years and ₹25,000 for 1.61 years, less the ₹20,000 withdrawal grown for 2.76 years — ₹1,89,548 in all, so the portfolio is ahead by ₹20,452.
10.16% a year — 35.29% absolute, ₹60,000 of gain, ₹20,452 ahead of an FD at 7%. The annualised figure is the one that compares: the absolute return says nothing about the 4.54 years it took.

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

Seven cash flows, seven answers

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.

6 flows · Invested ₹1,70,000 · Valued 2026-10-19

Main example — 6 cash flows, ₹2,10,000 on 19 Oct 2026

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%

4 flows · Invested ₹10,000 · Valued 2009-04-01

Microsoft Excel example — ₹10,000 in January 2008

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%

36 flows · Invested ₹3,60,000 · Valued 2026-04-01

₹10,000 monthly SIP for 3 years — ₹4,35,076

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%

1 flow · Invested ₹1,00,000 · Valued 2024-01-01

One lumpsum — ₹1,00,000 to ₹1,33,100 in 3 years

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%

1 flow · Invested ₹1,00,000 · Valued 2024-03-01

A loss — ₹1,00,000 down to ₹80,000 in 3 years

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%

60 flows · Invested ₹3,00,000 · Valued 2025-04-01

₹5,000 a month for 5 years — ₹5,00,000

₹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%

12 flows · Invested ₹60,000 · Valued 2024-01-01

₹5,000 a month for 12 months — ₹64,163

₹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

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%.

XIRR vs CAGR vs absolute return — which measure for which job.
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?

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.

Good XIRR bands for equity mutual fund SIPs in India (fundulator.in).
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

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.

One investment, one value — XIRR against the calendar-year CAGR.
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

Five mistakes that misread an XIRR

The calculation is short, but five readings trip people up. Each one can set the result several points wrong.

01 / SIGNS

Entering investments as positive numbers

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.

02 / THE VALUE

Forgetting the current value

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.

03 / THE DATE

Using the wrong valuation date

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.

04 / MISSING FLOWS

Leaving out a top-up or a withdrawal

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.

05 / SHORT PERIODS

Reading a three-month XIRR as a long-term return

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

The XIRR checklist

Run every result through the same nine checks before you act on it.

  • Is every investment and withdrawal in, with the right date? The sample has six flows from 5 April 2022 to 10 March 2025. A missing top-up or redemption changes the answer — check the list against your statement.
  • Is the sign right on each flow? Invest is money out, Withdraw is money in. The form applies the sign from your choice, so a flow marked Withdraw when it was an investment flips the result.
  • Is the current value the latest figure? Use the latest NAV × units, or the redemption amount if you sold. The sample uses ₹2,10,000 valued on 19 October 2026.
  • Is the valuation date the date of that value? The value belongs on the date it was measured. Dating it early shortens the holding period and overstates the XIRR.
  • Does the total invested match your statement? The sample's ₹1,70,000 is the five investments added up. If the tool's total differs from your statement, a flow is missing or doubled.
  • Is the holding over a year? XIRR is most meaningful over a year or more. Under a year, read the absolute return alongside it — a 5% gain in a month is about 80% annualised.
  • Have you compared with the FD figure? The sample is ₹20,452 ahead of an FD at 7%. The comparison is the test of whether the risk earned anything over the safe alternative.
  • Does the XIRR sit in a sensible band for the fund type? 12–15% is good for a large-cap equity SIP over the long term; above 20% deserves a check of the dates. Compare with the benchmark index over the same dates.
  • Will you re-check after the next statement? XIRR moves with every flow and every valuation. Re-enter the latest value when the next statement arrives — tax, charges and exit load are not in the figure.

Your questions, answered

XIRR calculator FAQs

What is XIRR?

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%.

How do I calculate XIRR in Excel?

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.

What is the difference between XIRR and CAGR?

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.

What is the difference between XIRR and absolute return?

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.

What is a good XIRR for a SIP in India?

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%.

Can XIRR be negative?

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.

Why does the calculator say there is no XIRR?

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.

Why is my SIP XIRR so high after only a few months?

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.

Does XIRR account for tax, charges and exit load?

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.

Does this calculator send my figures anywhere?

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.

About the method

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.

Check your SIP, lumpsum and CAGR next

Try different figures — or run the same check with the related tools for your other plans.

WAM to GPA CalculatorGPA to WAM CalculatorSSC Age CalculatorCGPA to Percentage CalculatorAge CalculatorUPSC Age CalculatorIBPS Age CalculatorRRB Age CalculatorEMI CalculatorSIP CalculatorBMI CalculatorPercentage CalculatorGST CalculatorPPF CalculatorFD CalculatorIncome Tax CalculatorRD CalculatorHome Loan EMI CalculatorGratuity CalculatorHRA CalculatorCompound Interest CalculatorEPF CalculatorNPS CalculatorSSY CalculatorNSC CalculatorSCSS CalculatorPost Office MIS CalculatorKVP CalculatorPersonal Loan EMI CalculatorPost Office Time Deposit CalculatorCar Loan EMI CalculatorAPY CalculatorSWP CalculatorWashing Machine Capacity CalculatorMattress Size FinderLaptop Budget CheckerEvent Planning Budget EstimatorRetirement CalculatorStep-up SIP CalculatorHome Loan Eligibility CalculatorLumpsum CalculatorEducation Loan EMI CalculatorBike Loan EMI CalculatorGold Loan CalculatorCredit Card EMI CalculatorSalary CalculatorSimple Interest CalculatorCAGR CalculatorBMR CalculatorBody Fat CalculatorTDS CalculatorRent vs Buy CalculatorPregnancy Due Date CalculatorOvulation Calculator — Fertile Window & Ovulation Date (India)Discount Calculator — Sale Price, Savings & GST (India)Date Calculator — Days Between Dates, Add Days & Countdown (India)Inflation Calculator — Future Cost, Value Today & CII (India)Stamp Duty Calculator — Property Registration Cost (India)Capital Gains Tax Calculator (India) — LTCG & STCG TaxFuel Cost Calculator (India)Share Average Calculator (India)Advance Tax Calculator (India)Brokerage Calculator (India)Leave Encashment Calculator (India)Rooftop Solar Calculator (India)Home Loan Prepayment Calculator (India)DA Calculator (India)Child Education Calculator (India)Sleep Calculator (India)Home Loan Tax Benefit CalculatorGold Price CalculatorAttendance CalculatorEmergency Fund CalculatorSilver Price CalculatorAC Tonnage CalculatorHouse Construction Cost CalculatorElectricity Bill CalculatorPaint CalculatorTerm Insurance CalculatorHealth Insurance Premium CalculatorTiles CalculatorCar Insurance Premium CalculatorTwo-Wheeler Insurance Premium CalculatorPeriod CalculatorConcrete CalculatorProtein CalculatorBrick Calculator