XIRR Calculator

Calculate the annualized internal rate of return for irregularly dated cash flows, then compare it with XNPV at a chosen hurdle rate.

Solve annualized return from irregular cash-flow dates Enter one dated cash-flow line per row in YYYY-MM-DD, amount format. The calculator solves the annualized discount rate that makes XNPV equal zero, then compares the result with a hurdle rate.

Display currency

Change the currency formatting for cash-flow amounts and XNPV output without changing the underlying return math.

Assumptions

XIRR treats cash-flow timing by actual day count over a 365-day year. Like IRR, non-conventional cash-flow patterns can produce multiple valid solutions or no single conventional solution.

Result

18.62%

Annualized return for the dated cash-flow stream from Jan 1, 2026 through Nov 30, 2028, spanning 2.92 years.

XNPV at hurdle
$13,864.44
Profitability index
1.14
Undiscounted break-even
2.11 years
Total net cash
$35,000.00
XIRR is above the hurdle rate At these dated cash flows, the annualized return clears the hurdle by 8.62%.

Interpretation note

Discounted break-even at the hurdle rate is 2.49 years. That gives you a timing check alongside the annualized headline return.

Cash-flow sheet

DateAmountYears from startCumulativeDiscounted at hurdleDiscounted cumulative
Jan 1, 2026-$100,000.000-$100,000.00-$100,000.00-$100,000.00
Jun 30, 2026$25,000.000.49-$75,000.00$23,852.13-$76,147.87
Mar 31, 2027$30,000.001.24-$45,000.00$26,646.22-$49,501.65
Jan 15, 2028$42,000.002.04-$3,000.00$34,584.08-$14,917.57
Nov 30, 2028$38,000.002.92$35,000.00$28,782.01$13,864.44

Also in Valuation

Business Valuation Calculator IRR Calculator NPV Calculator Payback Period Calculator WACC Calculator

Irregular Cash Flows

XIRR calculator guide: annualized return for cash flows that land on real dates

An XIRR calculator solves the annualized internal rate of return for cash flows that do not arrive at equal intervals. It is useful when contributions, distributions, or project inflows land on real calendar dates rather than neat monthly or annual periods, because the timing itself changes the effective return.

Why XIRR exists

Standard IRR assumes cash flows are evenly spaced. That is fine for tidy annual or monthly models, but many real investments and business projects do not behave that way. Capital calls, milestone payments, partial exits, and uneven collections all create irregular timing.

XIRR solves the same NPV-equals-zero problem as IRR, but it measures the actual day gaps between the cash flows. That makes the result more useful when the spacing is irregular enough that a periodic IRR would hide a meaningful timing difference.

Core XIRR maths

XIRR discounts each cash flow using the fraction of a year between that cash flow’s date and the starting date. The solved annual rate is the one that brings the full dated stream back to a net present value of zero.

Because the exponent changes with each cash flow date, XIRR is solved numerically rather than by rearranging one simple closed-form formula. Spreadsheet tools and finance calculators typically find the result by iteration.

XNPV = Sum(CF_t / (1 + r)^(days_t / 365))

Discounts each dated cash flow by its actual year fraction from the start date.

XIRR solves for r when XNPV = 0

The annualized return is the rate that makes the full dated stream break even on a present-value basis.

Worked example: an uneven project timeline

Suppose a project spends 100,000 on 1 January 2026, collects 25,000 on 30 June 2026, 30,000 on 31 March 2027, 42,000 on 15 January 2028, and 38,000 on 30 November 2028. A periodic IRR would force those dates into artificial periods, but XIRR keeps the real spacing.

That matters because earlier cash inflows lift the annualized return more than later inflows. When the gaps are irregular, the difference between XIRR and a periodic IRR can be large enough to change whether the project appears to clear the hurdle rate.

When XIRR still needs caution

Like IRR, XIRR can become ambiguous if the cash-flow stream changes sign more than once. In that case the dated NPV equation may support more than one valid rate, or no single conventional rate in the usual search range.

That is why XIRR should still be checked against XNPV at a realistic required return. Rate-based summaries are useful, but the present-value surplus or deficit at a hurdle rate is often the stronger decision anchor when timing is messy.

Further reading

Frequently asked questions

What is the difference between IRR and XIRR?

IRR assumes cash flows are evenly spaced by period. XIRR uses actual calendar dates and annualizes the return from the real day gaps between those cash flows.

 Why can XIRR differ a lot from periodic IRR?

Because timing changes value. Earlier cash inflows push annualized return up, while later inflows pull it down. If the spacing is uneven, forcing the series into equal periods can materially distort the result.

 Can XIRR have multiple solutions?

Yes. If the cash-flow stream changes sign more than once, the dated NPV equation can cross zero more than once. In those cases, XNPV at a realistic hurdle rate is usually safer than relying on one rate alone.

 Should I use XIRR for private investments or business projects?

Yes, when cash flows happen on real dates and timing matters. It is especially useful for projects, private deals, and uneven contribution or distribution schedules where periodic IRR would be too crude.

Related

More from nearby categories

These related calculators come from the same leaf category, nearby sibling categories, or the same top-level topic.

IRR Calculator

Solve for the internal rate of return on one initial investment and an evenly spaced series of later cash flows, then compare it with a hurdle rate.

Open calculator

NPV Calculator

Calculate net present value by discounting an initial investment and later cash-flow series, then review profitability index and discounted payback.

Open calculator

Payback Period Calculator

Estimate how many months, quarters, or years projected cash inflows may need to recover an upfront investment cost.

Open calculator

DCF Calculator

Estimate enterprise value, equity value, and intrinsic value per share by discounting projected free cash flow and a terminal value.

Open calculator

Privacy choices

If you allow analytics, we may use Google Analytics and Microsoft Clarity to better understand how the site is used. Analytics remain off unless you accept.