XIRR versus IRR: Dates, Periods and Annualization

Choose the time model before calculating a return

IRR and XIRR both seek a discount rate that makes a sequence of cash flows have zero net present value. Their timing assumptions differ. IRR treats successive entries as equally spaced periods; it does not read calendar dates. XIRR uses the actual dates attached to the amounts and reports an annualized rate under a stated day-count basis. The local XIRR Calculator uses Actual/365. Selecting between them begins with the schedule, not with which result appears larger or which acronym is more familiar.

Use IRR for an explicit equal-period sequence

Consider −1,000 followed by +1,100 one period later. The IRR equation is −1,000+1,100/(1+r)=0, giving r=10% per period. If that period is one year, the result is 10% per year. If the period is one month, it is 10% per month. The two numbers alone do not establish the unit of time. A monthly periodic IRR can be converted to an effective annual rate with (1+r)^12−1, which would be approximately 213.8428% in this deliberately large illustrative example.

Attach dates to the same two cash flows

Now date the −1,000 at 1 January 2025 and the +1,100 at 1 January 2026. The interval is 365 days, so Actual/365 XIRR is 10% annually. Move the receipt to 2 July 2025, 182 days after the initial flow, and the annualized rate becomes 1.1^(365/182)−1, approximately 21.0634%. The investor still gains 100, or 10% of the initial 1,000. The annualized result is higher because the same gain occurs in a shorter stated holding period, not because the cash profit has increased.

Do not force irregular dates into equal rows

Suppose contributions occur in January, March and December. Placing those three amounts in consecutive IRR rows treats the gaps as equal, even though the actual intervals differ substantially. Adding zero rows can model missing periods only when a consistent discrete interval is deliberately used. It does not make monthly spacing identical to actual calendar-day spacing. A dated XIRR schedule is the more direct representation when the question concerns the precise transaction dates. Conversely, a theoretical annual model can properly use IRR without inventing calendar dates that were never part of the assumptions.

Keep an ending value and intermediate receipts distinct

For an ongoing investment, include its current value as a positive cash flow at the chosen valuation date. Include actual distributions and withdrawals on their own dates. If distributions were reinvested within the investment and are already reflected in ending value, avoid counting them again as external receipts unless the chosen cash-flow treatment explicitly represents both sides. Both methods require consistent signs from one perspective. Changing an investment outflow to positive merely to obtain a desired rate changes the equation rather than correcting the interpretation.

Compare annual IRR and dated XIRR carefully

Annual dates do not always produce the same result as equal one-year periods because Actual/365 counts leap days. A receipt exactly one calendar year after a date in a leap-year interval may be 366 days later. XIRR accounts for that additional day, while annual IRR treats the interval as one period. This small difference can be correct. Monthly dates also have unequal day counts. Align the convention and use the full precision of the input schedule before interpreting a slight difference between a spreadsheet and a browser calculator.

Check whether a reported solution is meaningful

Repeated sign changes can create multiple roots, and some schedules do not yield a useful rate. Neither method automatically measures investment risk, liquidity or the reliability of forecast cash flows. Recompute net present value at the candidate rate and inspect the timeline. Keep the periodic unit with every IRR result and label XIRR as annualized with its day-count basis. Simple ROI answers a different question about total gain relative to cost; it can be reported alongside these timing-sensitive measures without treating the percentages as interchangeable.

Related guides

XIRR Formula: Discount Dated Cash Flows to Zero

Write the Actual/365 XIRR equation, solve a two-cash-flow example, and check signs, dates and the numerical residual.

XIRR in Mutual Funds: Build the Investor’s Cash-Flow Record

Calculate an investor’s annualized return from dated mutual-fund contributions, withdrawals and ending value, without double counting fund gains.

Annual CAGR: Measure Compounded Growth Between Two Values

Calculate annual CAGR from beginning value, ending value and elapsed years, check negative growth, and separate compounded return from an arithmetic average.