XIRR Calculator
Find the annualized internal rate of return (XIRR) on irregular, dated cash flows — the single yearly rate that discounts every deposit and withdrawal to a net present value of zero.
How it works
XIRR solves 0 = Σ amountᵢ ÷ (1 + rate)^((dateᵢ − date₀) ÷ 365) for rate · date₀ = earliest cash-flow date · Solved numerically by Newton–Raphson with a bisection fallback
XIRR is the internal rate of return for cash flows that arrive on irregular dates rather than in neat annual steps — a SIP with uneven contributions, a private deal with staggered draws, a portfolio with sporadic buys and sells. It is the single annual rate that discounts every dated inflow and outflow back to a net present value of exactly zero, so it fully accounts for the time value of money: a dollar returned early is worth more than one returned late. There is no closed-form solution, so this tool searches for the rate numerically, starting with Newton–Raphson and falling back to bisection if that diverges. A negative amount is money leaving your pocket (an investment); a positive amount is money coming back (a distribution or sale).
Worked example
Investing $10,000 on 2023-01-01, then receiving $2,000 on 2023-06-01, $4,000 on 2024-01-01 and $6,000 on 2025-01-01 returns $12,000 in total against $10,000 invested. Because the $2,000 and $4,000 come back early and can be reinvested, the money-weighted annual rate that makes the discounted flows sum to zero — the XIRR — works out to roughly 12% a year, higher than the plain 20% total return spread naively over two years would suggest.
Sources: Internal rate of return — Wikipedia
Frequently asked questions
How is XIRR different from IRR or CAGR?
Plain IRR assumes cash flows land in equal annual periods, and CAGR assumes a single lump sum grows to one final value. XIRR uses the actual calendar dates of every flow, so it correctly handles irregular timing — the way real deposits, withdrawals and dividends actually occur. When flows happen to be exactly one year apart, XIRR and IRR give the same answer.
Why must I include a negative and a positive amount?
A rate of return only exists when money both goes out and comes back. If every amount is an outflow (or every amount an inflow) there is nothing to discount against, and the net-present-value equation has no meaningful root. Enter your investments as negative numbers and your returns as positive numbers.
What date format does it expect?
Each cash flow is written as "amount@YYYY-MM-DD" — for example "-10000@2023-01-01". Put one per line or separate them with commas. Amounts can include decimals, and negatives mark money you paid in. Days are measured on a 365-day year from the earliest date you enter.
Related calculators
Educational estimate, not investment, tax or financial advice. Option prices and returns are never guaranteed and past performance does not predict the future. Confirm figures with a licensed advisor.