The full guide
XIRR for irregular cash flows: a reproducible guide to money-weighted return
By TaprobaneFi Research Desk · Reviewed and updated July 20, 2026 · Global educational edition
XIRR estimates the annualized rate that makes the present value of all dated cash flows equal to zero. Unlike CAGR, it accounts for when each deposit and withdrawal occurred. That makes it useful for an account funded at irregular intervals, but it also means the result reflects both investment performance and the investor's cash-flow timing.
This calculator uses actual calendar dates, a 365-day year, and a bounded numerical search. It returns a result only when it finds one sign-changing interval; ambiguous or non-convergent patterns are rejected rather than presented as a precise answer.
Enter cash flows from one consistent viewpoint
Use negative amounts for money you put into the investment and positive amounts for money you receive. A current unsold holding is represented by a final positive cash flow equal to its market value on the valuation date. There must be at least one negative and one positive amount.
Every amount must be expressed in the same currency. If an account holds assets in several currencies, convert each external flow and the ending value using a documented, consistent policy before calculating. Otherwise exchange-rate movement becomes mixed into the result in an uncontrolled way.
Worked example with irregular dates
Suppose an investor contributes 10,000 on 15 January 2023, adds 2,000 on 1 October 2023, receives a 500 distribution on 20 June 2024, and values the remaining holding at 14,000 on 15 January 2026. Enter the two contributions as negative, the distribution as positive, and the final market value as positive.
XIRR discounts each amount according to the number of days from the first flow. The first contribution has almost the full period to work, while the later contribution receives less time. This is why dividing total profit by total contributions cannot produce the same annualized answer.
| Date | Amount | Treatment |
|---|---|---|
| 2023-01-15 | -10,000 | Initial contribution |
| 2023-10-01 | -2,000 | Additional contribution |
| 2024-06-20 | +500 | Cash distribution received |
| 2026-01-15 | +14,000 | Ending market value |
What the solver is doing
At any trial rate, the calculator discounts each flow by one plus the rate raised to its year fraction from the first date, then adds the discounted values. It searches rates from close to -100% through progressively large positive values and looks for a bracket where net present value changes sign. Bisection then narrows that bracket.
This approach is deliberately cautious. If the cash-flow pattern creates more than one sign-changing bracket, there may be multiple valid internal rates of return. The interface reports that no unique result was found rather than choosing one silently.
XIRR, CAGR, IRR, and time-weighted return
CAGR needs only two values and assumes no intermediate external flows. Periodic IRR assumes equally spaced periods. XIRR uses exact dates. All IRR-style measures are money-weighted, so large contributions have more influence than small ones.
A time-weighted return answers a different question: how did the underlying strategy perform after neutralizing the size and timing of external flows? XIRR is suitable for the investor's experienced return; it should not automatically be used to rank managers whose clients control deposit timing.
Diagnosing a missing or implausible result
First check signs, dates, duplicate distributions, and the final valuation entry. A reinvested distribution that is already included in ending market value should not also be entered as cash received. A cash distribution that left the account should be entered on its date.
Verification checklist
- Confirm at least one negative and one positive flow.
- Use the actual transaction dates and one clearly defined valuation date.
- Include fees and taxes consistently rather than selectively.
- Confirm all flows use one currency convention.
- Verify material decisions with an independent spreadsheet or financial system.
Limitations of the result
More than one change in cash-flow sign can create multiple mathematical roots, and some patterns have no root in the searched range. Very short measurement periods can annualize small gains into extreme rates. XIRR also says nothing by itself about volatility, drawdown, liquidity, or benchmark-relative performance.
The implementation aims for spreadsheet-style behavior but does not claim identical answers in every edge case. Treat it as an educational estimate and independently verify any result used in accounting, valuation, tax, or contractual work.
Sources & further reading
This guide is educational. Calculator outputs depend entirely on the assumptions entered and do not predict investment returns, inflation, fees, taxes, or market conditions. Rules and product terms differ by country; verify any decision with current primary sources and an appropriately qualified professional. Nothing here is financial, tax, legal, or investment advice.