XIRR Calculator Guide: The True Return on Irregular Cash Flows

Most return figures you see assume a tidy pattern: the same amount invested at regular intervals, or a single investment held for a whole number of years. Real investing is rarely tidy. You invest a lump sum, add more six months later, withdraw some money for an emergency, receive a dividend at an odd date, and sell part of a holding on a Tuesday. The internal rate of return for irregular cash flows, known as XIRR, is the tool that makes sense of that mess by converting a list of dated cash flows into a single annualised percentage.

This guide explains what XIRR is, how it differs from simpler return measures, and how to interpret its result. It works through a simple example whose answer can be verified by hand, and it explains the situations where XIRR misleads if it is used carelessly. Figures here are educational illustrations, not financial advice, and past returns do not predict future performance.

Why ordinary return measures fall short

A simple return divides profit by the amount invested, ignoring time. If you invest 10,000 and receive 11,000, the simple return is 10 percent, regardless of whether that took one year or ten years. That is clearly inadequate, because money received sooner is worth more than money received later, and a 10 percent gain over ten years is a poor result while a 10 percent gain over one year is respectable.

The compound annual growth rate, or CAGR, improves on simple return by annualising it, but it only works for a single investment and a single withdrawal. It cannot handle multiple investments and withdrawals at different dates, which is the normal pattern for a mutual fund investor making monthly contributions, or a business with irregular receipts.

XIRR solves that problem. It finds the annual rate at which the present value of all cash inflows equals the present value of all cash outflows, using the actual dates of each flow. In other words, it finds the rate that makes the net present value of the whole series zero. That rate is the annualised return on the irregular series, expressed as a percentage per year.

How XIRR works, in outline

Each cash flow is dated and signed: money you pay in is negative, money you receive is positive, or vice versa, as long as the convention is consistent. Each flow is discounted back to the date of the first flow, using the candidate rate, with the discount period measured in years as the number of days divided by 365. The rate that makes the sum of the discounted flows equal zero is the XIRR.

Finding that rate by hand requires iteration: try a rate, compute the sum, adjust the rate up or down depending on whether the sum is positive or negative, and repeat until the sum is close enough to zero. A spreadsheet function or a dedicated calculator does that iteration in milliseconds. Understanding that iteration is happening matters, because it explains why XIRR can sometimes fail to find a solution, or find more than one, when the cash flow pattern is unusual, for example when there are multiple changes of sign.

The use of 365 days in the denominator is a convention. Leap years are not given special treatment in the standard XIRR formula; a flow 366 days after the first flow is discounted for 366 divided by 365 years, which is slightly more than one year. That convention is consistent across spreadsheets, so results are comparable, but it means XIRR is an annualised figure under that convention, not a calendar-year figure in the strict sense.

A worked example you can verify

Take the simplest possible irregular series, which is actually regular in time but serves as a check. You invest 10,000 on 1 January 2026, and you receive 11,000 on 1 January 2027. There are 365 days between those dates, because 2026 is not a leap year. The XIRR should be 10 percent, because the investment grew by 10 percent over exactly one year.

Check it: at a rate of 10 percent, the present value of the inflow, discounted for one year, is 11,000 divided by 1.10, which equals 10,000. The outflow is 10,000, so the net present value is 10,000 minus 10,000, which equals zero. A rate of 10 percent therefore satisfies the XIRR definition exactly. If you try 9 percent, the present value of the inflow is 11,000 divided by 1.09, which equals about 10,091.74, giving a positive net present value of about 91.74, which tells you the true rate is higher than 9 percent. If you try 11 percent, the present value is 11,000 divided by 1.11, which equals about 9,909.91, giving a negative net present value, telling you the true rate is lower than 11 percent. The iteration converges on 10 percent, as expected.

Now consider a slightly more realistic series: invest 10,000 on 1 January 2026, invest a further 5,000 on 1 July 2026, and receive 17,000 on 1 January 2027. The total invested is 15,000, the total received is 17,000, and the simple return is 2,000 divided by 15,000, which is about 13.33 percent. But the second investment was only in place for about half a year, so the annualised return should be higher than a simple calculation suggests, because the money was not all invested for the full year. An XIRR Calculator will give a figure around 16 percent for this series, reflecting that the later money had less time to grow. The exact figure depends on the precise day counts, which is why a calculator is preferable to a rough estimate for any real series.

XIRR versus other measures

XIRR is sometimes confused with the internal rate of return, or IRR. IRR is the same concept, but it assumes cash flows occur at regular intervals, such as annually or monthly. XIRR generalises IRR to irregular dates, which is why it is the right tool for real investment histories. If your flows are regular, IRR and XIRR will agree, apart from day-count details.

XIRR is also different from absolute return, which ignores time, and from CAGR, which assumes a single holding period. A fund that reports a high absolute return over a long period may have a modest XIRR, because the money was tied up for a long time. Conversely, a short, sharp gain can produce a very high XIRR that would be misleading if annualised naively over a longer period. Always look at XIRR alongside the holding period and the amounts involved, not in isolation.

A further distinction is between XIRR and time-weighted return. Time-weighted return measures the performance of the investment itself, removing the effect of when you added or withdrew money. XIRR, or money-weighted return, measures your personal return, including the effect of your timing decisions. If you invested heavily just before a rise, your XIRR will be higher than the fund's time-weighted return; if you invested just before a fall, it will be lower. Both figures are useful, but they answer different questions, and comparing them directly is a mistake.

When XIRR misleads

XIRR assumes that intermediate cash flows are reinvested at the XIRR itself, which is a standard assumption for internal rates of return, but it is not always realistic. If a series includes a large early inflow that could not plausibly be reinvested at the same high rate, the XIRR may overstate the achievable return. That is a known limitation of all internal-rate measures, and it is why XIRR should be used alongside other measures for complex series.

Very short holding periods produce extreme XIRR figures. A gain of 1 percent over one week annualises to over 60 percent, because XIRR scales the weekly gain to a full year. That annualised figure is arithmetically correct but practically meaningless, because the gain is unlikely to repeat every week for a year. Treat XIRR figures for periods shorter than a year with particular caution, and always check the holding period before quoting the rate.

Multiple sign changes can produce multiple XIRR solutions or no solution. A series that alternates between inflows and outflows several times may satisfy the net-present-value equation at more than one rate. A calculator will usually return one of them, but it may not be the one you intend. For ordinary investment histories, with money going in and a final amount coming out, this problem rarely arises, but for business projects with irregular receipts and payments throughout, it is worth checking whether the solution is unique.

Finally, XIRR does not account for risk, fees, or taxes unless those are included as cash flows. A gross XIRR before fees and taxes will be higher than the net return you actually keep. Include fees as negative flows and taxes as they arise, where possible, to get a net figure that reflects your real experience.

Using an XIRR calculator well

Enter every cash flow with its correct date and sign, and double-check the dates, because a wrong year on one flow can change the result substantially. Include all flows: contributions, withdrawals, dividends received as cash, and the final value as a positive flow on the valuation date. If dividends were reinvested, they are not separate flows, because the reinvestment is already reflected in the holding's value; counting them separately would double-count.

Check the result for plausibility. Compare it with the simple return and the holding period: if the simple return is 13 percent over about a year with most money invested for the full period, an XIRR near 13 percent is plausible, while an XIRR of 50 percent suggests a data error. Check the total invested and total received, which a good calculator displays alongside the rate, because those totals anchor the percentage in real money.

For related calculations, the Compound Interest Calculator shows how a single sum grows at a fixed rate, and the Simple Interest Calculator covers the non-compounding case. The Compound Interest Calculator Guide explains compounding in depth, and the Percentage Calculator handles the simple return arithmetic that XIRR builds upon.

Disclaimer

This guide is educational information about a calculation method, not financial, investment, or tax advice. Investment returns depend on market conditions, fees, taxes, and individual circumstances, and a calculated XIRR for a past series does not predict future returns. Before making investment decisions, consider seeking advice from a qualified financial adviser, and verify any calculator result against a spreadsheet XIRR function for amounts that matter. Used with those cautions, XIRR is a powerful way to answer the question every investor eventually asks: given what I actually put in, when I put it in, and what I actually got back, what annual rate did I really earn?