← All tools/Calculators/Finance/XIRR Calculator

XIRR Calculator

The annualised return of investments with irregular cash flows and dates — like Excel’s XIRR, in your browser.

Negative = money you put in, positive = money you got back. Use YYYY-MM-DD dates.

Estimate only, not financial advice. XIRR assumes the same annual rate compounds over the whole period — real returns vary year to year.

XIRR — annualised return

—

InvestedGain
Your cash flows, discounted

How it works

XIRR is the rate r that solves:
Σ CF_i ÷ (1 + r)^((d_i − d_0) ÷ 365) = 0
where CF_i is the cash flow on date d_i and d_0 is the first date (actual/365 day count).
Solved iteratively with Newton–Raphson from a 10% starting guess, as in Excel’s XIRR.
It needs at least one positive and one negative cash flow — otherwise no rate exists.

XIRR is the single annual rate that makes all your cash flows balance to zero. Each cash flow, CF, is divided by (1 + r) raised to the number of days since the first date, divided by 365 — this is the actual/365 day count, so a flow 182 days after the first is discounted by (1 + r) raised to about 0.5. Money invested is negative, money received is positive. The rate r is the answer when the sum of all those discounted flows equals zero: at that rate, the present value of everything you received exactly equals the present value of everything you put in. There is no direct formula for r, so the calculator finds it by Newton–Raphson iteration, starting from a 10% guess and refining it until the sum is zero — the same method Excel’s XIRR uses. The method applies whenever investments and withdrawals happen on irregular dates. It needs at least one negative and one positive flow, and it assumes money received along the way is reinvested at the XIRR itself.

Worked example: invest ₹10,000 on 1 January 2008, then receive ₹2,750 on 1 March 2008, ₹4,250 on 30 October 2008, ₹3,250 on 15 February 2009 and ₹2,750 on 1 April 2009. Total invested ₹10,000, total received ₹13,000, over 456 days — and the XIRR is 37.34% a year, the same figure Microsoft’s own example gives. Change the last receipt to ₹2,000 and the XIRR falls to 28.55%.

Second worked example: an investor in Mumbai puts ₹50,000 into a fund on 1 January 2025, then takes out ₹20,000 on 1 July 2025, ₹20,000 on 1 January 2026 and ₹20,000 on 1 July 2026. She put in ₹50,000 and got back ₹60,000 — a ₹10,000 gain over 18 months. The XIRR that balances those flows is 20.41% a year. That is higher than the simple gain of 20% over 18 months would suggest as an annual rate, because part of the money came back early and could have been put to work again.

Method: the rate r that solves Σ CF ÷ (1+r)^((date − first date)/365) = 0, found by Newton–Raphson from a 10% starting guess — the same method as Excel’s XIRR.

What the result means

An XIRR of 20% does not mean your money grew by 20% — it means it behaved as if it had earned a steady 20% a year, with every rupee received along the way reinvested at that same rate. That assumption is also its weakness: if you took ₹20,000 out after six months and left it in a savings account at 3%, your real return was lower than the XIRR suggests. So always read XIRR next to the absolute gain. In the example above, the absolute gain is ₹10,000 on ₹50,000 — useful, but modest in rupees even though 20.41% sounds spectacular. Compare XIRR with the right benchmark: a fund XIRR of 12% over five years beats a fixed deposit at 7%, but only if the risk was comparable and the period is long enough to mean something — an XIRR over three months can be wild, because a small gain annualises into a huge rate. Use XIRR to compare two investments over the same period, to check whether a fund beat its benchmark, and to judge an SIP, where the dates are irregular by nature. For a single lump sum held to maturity, the simpler CAGR tells the same story with fewer assumptions.

Frequently asked questions

What is XIRR, in plain words?

The single annual rate that makes all your money in and money out balance. If you had earned that fixed rate every year, you would end up with exactly what you actually got. It is the right measure when investments and withdrawals happen on irregular dates.

How is XIRR different from CAGR?

CAGR only works for one investment and one withdrawal — it ignores everything in between. XIRR handles every cash flow on its real date, so it suits SIPs, top-ups and partial withdrawals, where CAGR cannot be used at all.

Why does XIRR need both a negative and a positive flow?

A rate only exists when money went both ways. All investments and no returns means a loss with no meaningful rate; all returns and no investment means an infinite rate. The calculator says so instead of guessing.

Can XIRR be negative?

Yes — if you got back less than you put in, the rate is negative. A −10% XIRR means your money shrank by about 10% a year over the period.

Does XIRR assume I reinvest at the same rate?

Yes — like IRR, it assumes interim cash flows are reinvested at the XIRR itself. That is why it can flatter a lumpy return; use it alongside the absolute gain, not instead of it.

More tools

Tell us what you think

Loving this tool, or stuck on something? Tell us — it takes a minute.

We’ll only use your name and email to reply if needed. The tool and page are filled in for you.