XIRR Calculator - Annualized Dated Cash Flow Returns

An xirr calculator measures the annualized return implied by investments, withdrawals, income, and ending value on different dates. It uses each row's date to discount the amount back to the first date instead of treating every entry as an equal-period event. Use it for brokerage deposits, uneven rent and sale proceeds, staged private funding, or irregular distributions.

• • Investment account history: Measure a money-weighted return after deposits, withdrawals, dividends, and a current account value occur on different dates.
• • Real estate cash flows: Include a purchase, renovation spending, uneven rent, and sale value in one dated schedule.
• • Private or business funding: Review staged capital calls and a later distribution when the project does not follow neat annual periods.
• • Return comparison: Put opportunities with different holding periods on an annualized basis before considering risk, liquidity, fees, and taxes.

Use one row per cash movement, the same currency throughout, the correct sign, and the actual movement date. The result is the rate that makes the dated net present value equal to zero. It is not a future-balance forecast or an investment recommendation.

Total invested is the absolute value of negative rows, total received is the sum of positive rows, and net gain or loss is received minus invested. These totals help audit the rate but do not account for timing. When every cash flow is periodic, the IRR Calculator is the closer companion.

XIRR solves for one annual rate by discounting every signed amount from the earliest date. The calendar gap, rather than a row number, supplies each cash flow's time exponent.

• Pᵢ: Signed amount on date dᵢ; an investment or other outflow is negative, while a receipt or other inflow is positive.
• dᵢ and d₀: The date for one row and the earliest valid date after sorting.
• r: Annual rate as a decimal; the display multiplies it by 100 to show a percentage.
• 365: The actual-day denominator used by the documented XIRR convention for succeeding payments.

Rows are sorted before solving, so entry order does not change the result. Date-only values are treated as UTC calendar dates to avoid a browser time-zone shift. Equal-date rows are allowed when the full schedule spans at least one day.

The solver searches in log(1 + r) space, brackets sign changes, and uses bisection while keeping the rate above -100%. It prefers a bracket near 10% when several are located. If no finite root is bracketed, the page shows an explanation instead of a numerical exception.

According to Microsoft Support, XIRR is intended for cash-flow schedules that are not necessarily periodic, succeeding payments use a 365-day year, and the function requires at least one positive and one negative value.

To inspect the dollar value at a chosen discount rate instead of solving for the rate, use the Net Present Value Calculator with a matching cash-flow schedule.

These four ideas explain what the percentage means and why the same total dollars can produce different annualized results.

Periodic IRR assigns equal time steps to rows: period 0, period 1, period 2, and so on. XIRR reads the dates. If a dividend arrives 17 days after a contribution, assigning it a whole year or month changes the implied rate. Microsoft describes IRR for periodic series and XIRR for a schedule that is not necessarily periodic.

Compare a money-weighted XIRR with a benchmark only after checking whether the benchmark is time-weighted, omits cash movements, or uses different fees and taxes. For separate finance and reinvestment assumptions, use the Modified IRR Calculator.

According to Corporate Finance Institute, XIRR assigns a specific date to each individual cash flow so unevenly timed cash flows can be modeled.

Build the rows from a statement, ledger, or project schedule. Entry order does not matter, but dates and signs do.

1. 1Add the first two rows: Keep at least two dated entries, usually a negative contribution and a positive value or distribution.
2. 2Enter actual dates: Use the day each payment, deposit, withdrawal, fee, or valuation occurred. Add material movements.
3. 3Apply the signs: Enter money paid out as negative and received as positive. A $5,000 contribution is -5000; a $750 distribution is 750.
4. 4Check the rows: Keep one currency, use valid dates, and include both signs.
5. 5Read the result: Review XIRR, invested, received, net, count, and elapsed-year outputs. Correct any error before interpreting the percentage.

For a savings review, enter a -$5,000 deposit on 2024-01-10, -$500 on 2024-03-04, $200 interest on 2024-12-31, and the $5,650 closing balance on 2025-01-10. Include the closing balance when it represents the value being measured.

After reconciling the dated rows, the Return on Investment Calculator can show a simpler gain-versus-cost view beside the time-aware return.

A dated return calculation is most helpful when the transaction history is more complicated than one purchase followed by one sale.

• • Respects transaction timing: Deposits and withdrawals receive their own calendar intervals instead of being forced into equal periods.
• • Makes sign logic visible: The row-by-row convention makes missing investments, reversed signs, and omitted distributions easier to catch.
• • Adds an audit trail: Invested, received, net, count, and elapsed-year outputs let you compare the calculation with a statement or ledger.
• • Supports uneven projects: Staged property costs, private funding rounds, renovation bills, rents, and sale proceeds can share one schedule.
• • Improves comparisons: An annualized rate gives a common scale for holding periods that do not end on the same date, while still requiring a risk and fee review.

These benefits are strongest when dates are complete and the ending value is recorded on its valuation or liquidation date. For an open portfolio, label the valuation date and treat the result as performance through that date.

Reconcile the dollar totals with the row list before comparing investments. A sharp change after one cash movement may be reasonable because XIRR responds to amount and timing. With only beginning and ending values, the CAGR Calculator provides a simpler comparison.

The percentage comes from the complete dated schedule, not just the final balance. Review these factors when a result looks surprising.

• • XIRR is an implied rate, not a risk measure. It does not account for volatility, liquidity, taxes, fees not entered as cash flows, inflation, or whether a future valuation can be realized.
• • The 365-day denominator is the stated convention for this calculator, not a claim that every investment report uses the same day-count rule.
• • When several roots exist, one displayed rate cannot describe every mathematical solution. Review alternating schedules before relying on one percentage.

A negative XIRR means the entered schedule requires a negative annual rate to make its dated net present value zero. Check whether a fee, contribution, withdrawal, or ending value was omitted before drawing a conclusion.

If no convergent XIRR appears, verify both signs, valid dates, and a range longer than one day. Alternating signs can remain ambiguous even when the totals look profitable.

According to Corporate Finance Institute, an unconventional cash-flow profile with several changes in direction can produce multiple internal rates of return. To test one future amount at a selected discount rate, the Present Value Calculator isolates that assumption.