XIRR Calculator – Internal Rate of Return for Irregular Cash Flows
An XIRR calculator finds the internal rate of return (IRR) when you have cash flows at irregular dates—for example, an initial investment plus several dividends or withdrawals at different times. XIRR is the same concept as Excel’s XIRR function: it gives you the annualized return that makes the net present value of all flows equal to zero. This article explains the XIRR formula, when to use XIRR vs CAGR, and links to our free XIRR calculator.
Quick Answer
| Label | Value |
|---|---|
| Initial investment | -$10,000 |
| Flows at 0.5, 1, 2 years | $2k, $3k, $6k |
| XIRR | 6.83%" |
How It Works
XIRR solves for the rate r such that NPV = Σ (cash flow ÷ (1+r)^years) = 0. Each cash flow is discounted by its time in years (you enter years and months; we convert to years). Use negative amounts for money out (e.g. initial investment) and positive for money in (dividends, withdrawals, final value). Same logic as Excel’s XIRR.
Additional Notes
For a single start and end value (no intermediate flows), use our CAGR Calculator instead. For regular periodic flows, IRR or XIRR both apply; XIRR handles irregular timing.
Use Our Calculator
Try our XIRR Calculator for your own numbers: /calculators/xirr-calculator
Related Calculators
XIRR (extended internal rate of return) is the annualized return that makes the net present value of all cash flows (at their actual or specified dates) equal to zero. It’s used when cash flows occur at irregular intervals.
Enter each cash flow and its time in years from the start. Use negative for outflows (e.g. initial investment) and positive for inflows. Our XIRR calculator solves for the rate numerically.
Use CAGR when you have one initial and one final value. Use XIRR when you have multiple cash flows at different times (e.g. several dividends or withdrawals).
Yes. Excel XIRR uses dates; we use years and months from start (e.g. 0 yr 6 mo for 6 months). The formula is the same: find the rate where NPV = 0.