homefinance toolsxirr calculator

XIRR Calculator

Work out XIRR from dated investments and redemptions

Start from
Cash flows (4)
Minus for money you invested, plus for money you got back. Put today's value as the last row.
₹
₹
₹
₹
XIRR
11.61%a year
10 Apr 2023 to 16 Oct 2026 (1285 days)
Total invested
₹75,000
Total received
₹1,05,000
Absolute gain
₹30,000
40.00% on money in
Absolute gain ignores time. XIRR accounts for when each rupee went in and came out, which is why it is the fair way to compare a SIP with an FD.
Cash flows and growth at the XIRR
DateAmountInvested so farReceived so farValue before flow
10 Apr 2023-₹50,000₹50,000₹0₹0
15 Jan 2024-₹25,000₹75,000₹0₹54,396
02 Jun 2025₹15,000₹75,000₹15,000₹92,402
16 Oct 2026₹90,000₹75,000₹1,05,000₹90,000
"Value before flow" is what the money still invested would be worth on that date if it had grown at exactly the XIRR.

Runs entirely in your browser. Nothing you type or upload is sent to us or stored.

Results are estimates, not financial advice. Rates, charges and rules change, so confirm with your bank, post office or a financial adviser before you decide. Terms of use

How to Use

  1. If you like, start from a preset: Monthly SIP (amount, number of instalments and today's value), Lump sum + redemptions, or Paste from Excel for two columns of dates and amounts. Press Fill the table or Replace the table.
  2. Check the cash flows: one row per date. Put money you invested as a minus amount (-5000) and money you got back as a plus amount.
  3. Make the last row today's date with the current value of what you still hold, as a plus amount. Use add row and the ✕ button to add or remove rows.
  4. Your XIRR, total invested, total received and absolute gain update as you type. If the flows are equally spaced (a SIP on the same date every month), you also see the plain IRR.
  5. Scroll down for the cash flow table with the growth at the XIRR. Use copy or pdf to keep the result.

What XIRR tells you

XIRR is the yearly return on money that goes in and comes out on different dates. A SIP is the classic case: ₹5,000 goes in every month for three years, so the first instalment has been invested for 36 months and the last for one. The fund's 3-year CAGR doesn't describe your return, and neither does "I put in ₹1.8 lakh and it's now ₹2.2 lakh". This XIRR calculator gives one annual figure that accounts for the timing of every rupee, which is why mutual fund statements (CAS) and apps show XIRR for SIPs.

It works for anything with dated cash flows: SIPs with skipped months, top-ups and part withdrawals, ULIPs, chit funds, a rental flat you bought and later sold, or money lent to a friend and repaid in parts.

How it is calculated

XIRR is the rate r that makes the present value of all the cash flows add up to zero:

Σ amounti ÷ (1 + r)(di − d1) ÷ 365 = 0

Here d1 is the first date and each di is the date of a flow, counted in days with a 365-day year. That is exactly how Excel's XIRR works, so the answers match. There is no formula you can solve directly, so the calculator finds r by Newton-Raphson iteration and falls back to bisection if that doesn't settle. For Microsoft's own example (-10,000 on 1 Jan 2008, then 2,750, 4,250, 3,250 and 2,750 back over the next 15 months) it gives 37.34%, the same as Excel.

Plain IRR assumes every flow is exactly one period apart, which is true only for a SIP on the same date each month. When your flows are evenly spaced, the tool shows the IRR per period and its yearly equivalent next to the XIRR. They are close, but XIRR is the one to quote.

A worked example

Say you invested ₹50,000 on 10 April 2023 and another ₹25,000 on 15 January 2024, withdrew ₹15,000 on 2 June 2025, and the holding is worth ₹90,000 on 16 October 2026. You put in ₹75,000 and got or hold ₹1,05,000, an absolute gain of ₹30,000 or 40%. Spread over about three and a half years, and allowing for the withdrawal, the XIRR is about 11.6% a year. The absolute 40% sounds better than it is because it ignores time.

Signs and the last row

Cash flowSignExample
SIP instalment, lump sum, top-upMinus-5000
Redemption, dividend paid out, SWPPlus15000
Value of what you still hold, on today's datePlus90000

Without at least one minus and one plus amount there is no return to calculate. Leave out dividends that were reinvested (they are already inside the current value), and take the current value from your fund statement or app on the same date as the last row.

Things to keep in mind

  • Over less than a year, XIRR scales a short-term gain up to a yearly rate. A 3% gain in two months shows as roughly 19%, which won't last.
  • XIRR is before tax. Equity gains above ₹1.25 lakh a year are taxed at 12.5% (long term) or 20% (short term), so your post-tax return is lower.
  • Compare like with like: an FD at 7% is a 7% XIRR before tax, so you can line up your SIP's XIRR against it directly.
  • Pasting from Excel or Google Sheets works with tab, comma or semicolon separated columns. Dates are read day first (05/01/2026 is 5 January).

Frequently Asked Questions

It depends on the fund type and the period. Over 7 years or more, an equity SIP with an XIRR in the low teens has done well by Indian standards; over one or two years the figure swings a lot with the market. Compare it with what you could have earned elsewhere, such as a 7% FD or PPF at 7.1%, rather than with a fixed target.

CAGR works for one amount invested on one date and valued on another. XIRR handles many amounts on different dates, such as SIP instalments, top-ups and withdrawals. For a single lump sum with no other flows, the two give the same answer.

Usually because the period is short. XIRR turns the return into a yearly rate, so a 4% gain in one month becomes about 60% a year. Check the dates too: a missing minus sign or a wrong year changes the answer completely.

Yes. It uses the same 365-day count from the first date as Excel's XIRR function, and it matches Microsoft's published example to eight decimal places. Statements can differ slightly if they value your holding on a different date or include stamp duty and load in the amounts.

Choose Paste from Excel, then copy two columns (date and amount) from your sheet and paste them in. Tab, comma or semicolon separated lines all work, a header row is skipped, and dates like 2026-01-05, 05/01/2026 or 05-Jan-2026 are read day first.

You Might Also Need

Mutual Fund NAV and ReturnsCAGR CalculatorSIP CalculatorMutual Fund Return