Finance calculator
XIRR Calculator - Irregular Cash Flow Return
Estimate annualized return from irregular investment cash flows with dated deposits, withdrawals, and an XNPV check.
Formula0 = sum(CF_i / (1 + r)^(days_i / 365))
Formula
XIRR equation
XIRR is a planning metric. Unusual cash-flow signs, short holding periods, fees, taxes, and valuation uncertainty can make the result misleading.
0 = sum(CF_i / (1 + r)^(days_i / 365))
A -50,000 investment followed by dated cash inflows is solved for the annual rate r that makes XNPV equal zero.
SourcesThis calculator includes source notes, assumptions, and exclusions so the result is easier to verify before use.
Sources and assumptions
Source notes
This calculator includes source notes, assumptions, and exclusions so the result is easier to verify before use.
- Effective year
- Current rules
- Last verified
- 2026-06-18
XIRR is a planning metric. Unusual cash-flow signs, short holding periods, fees, taxes, and valuation uncertainty can make the result misleading.
Assumptions
- Cash-flow dates are converted into year fractions using a 365-day year.
- The initial investment is treated as an outflow and later cash flows are entered as inflows or additional outflows.
- The XIRR estimate solves for the annual rate that makes dated net present value close to zero.
Not included
- Taxes, fees, reinvestment assumptions, day-count conventions other than 365 days, and multiple-root diagnostics for unusual cash-flow patterns.
FAQ7 common questions for this calculator.
FAQs
What is XIRR?+
XIRR is an annualized internal rate of return for cash flows that happen on irregular dates.
How is XIRR different from IRR?+
IRR assumes equal periods between cash flows. XIRR uses each cash-flow date, so it is better for real deposits, withdrawals, and exit proceeds.
Can XIRR be negative?+
Yes. If dated outflows exceed inflows on a present-value basis, the estimated annualized return can be negative.
How does the XIRR Calculator calculate the result?+
For the XIRR Calculator, it uses the XIRR equation: 0 = sum(CF_i / (1 + r)^(days_i / 365)). A -50,000 investment followed by dated cash inflows is solved for the annual rate r that makes XNPV equal zero.
What information do I need to use the XIRR Calculator?+
For the XIRR Calculator, enter irregular investment cash flows. Keep the units consistent with the calculator fields and compare your setup with the worked example on the page.
How accurate is the XIRR Calculator?+
XIRR Calculator is accurate for the rates, amounts, dates, and rules entered. It uses the XIRR equation shown on this page. Real products can differ because of fees, taxes, contract terms, or changing official thresholds.
What should I check before using the XIRR Calculator result?+
For the XIRR Calculator, check irregular investment cash flows, then compare the XIRR equation and worked example with the contract or source you will rely on. Fees, tax year, currency, and payment timing can change the final decision.
RelatedNearby finance calculators for the next step after XIRR Calculator.
Finance guide
How to use the XIRR Calculator
Estimate annualized return from irregular investment cash flows with dated deposits, withdrawals, and an XNPV check. The page also explains the XIRR equation and shows a practical example: A -50,000 investment followed by dated cash inflows is solved for the annual rate r that makes XNPV equal zero.
- 1
Enter your details
Enter irregular investment cash flows, then complete any other fields shown in the calculator.
- 2
Check the calculation
Review the result alongside the XIRR equation: 0 = sum(CF_i / (1 + r)^(days_i / 365)).
- 3
Compare scenarios
Change one or more inputs to see how they affect the XIRR Calculator result before you use the estimate.