GLOSSARY DEEP DIVE

XIRR: The Correct Way to Measure Your Real Investment Return

Almost no real investor puts in a single lump sum and leaves it untouched; most add money from paychecks over time and occasionally withdraw for expenses. A simple percentage-gain calculation quietly breaks down the moment cash moves in and out at irregular times, which is precisely the problem XIRR exists to solve.

Deep dive8 min readUpdated 2026
In this article

The core principle

XIRR stands for extended internal rate of return. It calculates the single annualized growth rate that, when applied to every individual cash flow on its actual calendar date, makes the present value of all those flows sum to zero against your current balance. Unlike a basic return calculation, which only compares a starting value to an ending value, XIRR accounts for exactly when each contribution or withdrawal occurred, giving money that was invested longer more weight in the calculation than money that was only invested briefly.

This matters because a naive percentage calculation, ending value minus total contributions, divided by total contributions, silently assumes every dollar was invested for the entire period being measured. In reality, a contribution made in July has had roughly half the time to compound that a contribution made in January had, and treating them as equivalent produces a return figure that misrepresents what actually happened to the money.

Most spreadsheet programs include a built-in XIRR function that accepts a list of dates paired with cash flow amounts: contributions are entered as negative numbers (money leaving your pocket), withdrawals and the current ending balance are entered as positive numbers (money effectively returned to you), and the function solves for the single annualized rate that reconciles them all.

Mechanically, there is no closed-form algebraic solution for the rate in most real-world cash flow sequences; the calculation is solved iteratively, with the software testing successive candidate rates and narrowing in on the one that drives the net present value of every cash flow to zero, the same underlying approach used to compute a bond's yield to maturity or a business project's internal rate of return in corporate finance. This is worth knowing mainly because it explains why XIRR can occasionally fail to converge or return an error on unusual cash flow patterns, such as a sequence with no sign change at all, which the underlying math genuinely cannot solve for a meaningful single rate.

Key idea XIRR answers a genuinely different question than a fund's published total return. A fund's total return typically assumes a single lump sum held for the full period; XIRR answers "what annualized rate did my actual money, invested exactly when I invested it, actually earn."

How the math works

Example 1: why the naive calculation understates the true rate. An investor puts $10,000 into an account on January 1, adds another $5,000 on July 1, and the account is worth $17,000 on December 31 of the same year. A naive calculation compares $15,000 total contributed to $17,000 final value: ($17,000 − $15,000) / $15,000 = 13.3%. But the $5,000 contribution was only invested for roughly half the year, meaning less total capital-time actually went into producing the $2,000 of growth than the naive calculation assumes. Solving the underlying XIRR equation, −$10,000 − $5,000 / (1+r)181/365 + $17,000 / (1+r)364/365 = 0, for the rate that balances it, gives an annualized return of approximately 16.1%, meaningfully higher than the naive 13.3% figure, precisely because less money was actually deployed for the full year than the simple calculation implicitly assumed.

Example 2: a scenario with a mid-stream withdrawal. An investor contributes $50,000 at the start, withdraws $10,000 exactly two years later, and the account is worth $55,000 at the three-year mark. The cash flows for XIRR purposes are: −$50,000 at year 0, +$10,000 at year 2 (a withdrawal, entered as a positive inflow to the investor), and +$55,000 at year 3 (the ending value, treated as if fully realized). Solving −$50,000 + $10,000 / (1+r)2 + $55,000 / (1+r)3 = 0 for r gives an annualized return of approximately 9.7%. Notice that a naive calculation ignoring timing, treating the net $45,000 remaining as simply having grown from $50,000 minus $10,000, would badly misstate this figure, since it fails to account for the fact that the $10,000 withdrawal happened before the account had two more years to grow, and had already captured two years of that growth before leaving.

How it shows up in real portfolios

The most common real-world use of XIRR is measuring the true annualized return of a taxable brokerage account or 401(k) that receives regular payroll contributions throughout the year, rather than a single lump sum at the start. A dollar-cost-averaging investor contributing every two weeks has dozens of distinct cash flows in a given year, each invested for a different length of time, and only a proper XIRR calculation, or the equivalent money-weighted return a brokerage statement sometimes provides, correctly reflects the investor's actual experience.

A high-earning-professional scenario shows why this distinction matters beyond mere curiosity: a physician evaluating whether an aggressive after-tax 401(k) contribution strategy, contributing large lump sums irregularly throughout the year as cash flow allows rather than smooth biweekly amounts, actually outperformed a simpler, steadier contribution schedule needs XIRR, not a simple percentage calculation, to make a fair comparison, since the irregular lump-sum pattern invests different amounts of money for different lengths of time in a way a naive return calculation cannot properly account for.

XIRR is also the right tool for comparing a real estate investment's return against a stock portfolio's return, since real estate cash flows, a down payment, periodic rental income, a refinance, an eventual sale, rarely arrive on a tidy annual schedule the way a simple return calculation assumes.

A further practical use case is evaluating whether a specific large, one-time financial decision, exercising employee stock options at a particular date, prepaying a mortgage early, making an unusually large charitable contribution from an investment account, actually made sense in hindsight once the timing of every associated cash flow is properly weighted, rather than judging it against a rough mental estimate that treats all the surrounding money as though it moved on a single, uniform date.

Key idea Never compare your personal XIRR directly to a fund's published total return without checking what each figure actually measures. A fund's total return usually assumes a single lump sum invested at the start of the period; your XIRR reflects your actual, irregular cash flow pattern, and the two numbers answer different questions even when they describe the same underlying investment.

Actionable breakdown

  • To calculate your own XIRR, gather:
    • Every contribution, entered as a negative cash flow with its exact date.
    • Every withdrawal, entered as a positive cash flow with its exact date.
    • Your current balance, entered as a final positive value, dated today.
    • A spreadsheet's built-in XIRR function to solve for the rate.
  • Watch for these common errors:
    • Missing or approximate dates, which distort the entire calculation.
    • Comparing your XIRR directly to a fund's lump-sum total return figure.
    • Forgetting to include a mid-year withdrawal as a positive cash flow.
    • Recalculating rarely, letting the figure grow stale after new contributions.
  • Recalculate periodically as new contributions or withdrawals occur.
  • Use XIRR, not a naive percentage, whenever cash flows arrive irregularly.
  • Apply the same method to real estate and other irregular-cash-flow investments.

A related, sometimes confused figure is time-weighted return, the standard used to evaluate a fund manager's skill independent of when outside investors happened to add or remove money. Time-weighted return strips out the effect of cash flow timing entirely, which is exactly the right choice for judging a manager who has no control over when clients deposit or withdraw, and exactly the wrong choice for judging your own personal outcome, which is precisely why your own contribution and withdrawal timing matters and a fund's time-weighted marketing figure is not a substitute for your own XIRR.

Common pitfalls

  • Using a simple total-return percentage when contributions were made at different times, which distorts the true annualized performance in either direction.
  • Forgetting to include a contribution or withdrawal date accurately, which throws off the entire calculation even when the amounts themselves are correct.
  • Comparing your personal XIRR directly to a fund's published total return, which usually assumes a single lump sum investment rather than your actual, irregular cash flow pattern.
  • Treating a mid-stream withdrawal incorrectly, forgetting that it should be entered as a positive cash flow, not simply subtracted from total contributions.

For the underlying mechanism XIRR is measuring the annualized rate of, see compound interest. For the contribution pattern that most commonly produces irregular cash flows in the first place, see dollar-cost averaging. For how to interpret the resulting figure after accounting for inflation, see real return and nominal return.

The bottom line

XIRR gives you your true personal annualized return by weighing every contribution and withdrawal by the exact date it actually happened, which a simple percentage calculation cannot do.

Back to the full glossary