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

Measure the investor's transaction experience

For a mutual-fund holding with contributions made on different dates, XIRR describes the annualized return associated with that investor's external cash flows and ending value. It differs from a fund's published performance series, which may use a different measurement method and does not necessarily match an individual purchase schedule. The local calculator needs the transaction amounts and dates supplied by you. It does not connect to a fund account, download net asset values or verify a statement. Start with the records for the exact holding and period you intend to measure.

Record contributions as negative and receipts as positive

From the investor's perspective, a purchase payment is negative because money leaves the investor. A redemption or cash distribution received is positive. Include the remaining holding's market value as a positive flow on the valuation date, even if it has not been sold. This final amount closes the measurement period. If the holding has been fully redeemed, use the actual redemption proceeds and do not add another ending value. Keep charges in the record consistently so the result's before-fee or after-fee basis is clear.

Work through a two-contribution example

Assume a contribution of 1,000 on 1 January 2023, another 1,000 on 1 January 2024 and a remaining value of 2,310 on 31 December 2024. These dates are each 365 days apart, including the chosen 2024 year-end date. The schedule is −1,000 at time zero, −1,000 after one year and +2,310 after two years under Actual/365. A 10% rate solves it because 1,000×1.1²+1,000×1.1=2,310. Enter the three dated lines to reproduce approximately 10.0000% annualized.

Compare that result with a simple gain ratio

Total contributions in the example are 2,000 and the ending value is 2,310, so the nominal gain is 310. Dividing 310 by 2,000 gives 15.5% across the contribution record. That is not the same measure as the 10% annualized money-weighted result, because the second 1,000 was invested for only one of the two years. Neither number should be relabeled as the other. The simple ratio summarizes gain relative to total contributed amounts; XIRR also uses how long the money was exposed to the investment.

Avoid counting internal gains as separate deposits

An increase in the value of existing fund units is reflected in the ending market value; it is not a new external contribution. Likewise, an internal reinvestment should not be added as an investor cash receipt and then ignored as a corresponding investment if no cash crossed the chosen portfolio boundary. Define whether the measurement covers one fund, a group of holdings or an entire account. A transfer between two included holdings may be internal to the combined portfolio, while the same transfer is an outflow from one separately measured fund.

Use transaction dates and an aligned valuation date

Changing a contribution date changes the time exponent in the calculation. Use a consistent source for dates and explain any settlement-date convention used in the record. The final market value must correspond to its stated valuation date; using today's date with an older statement value mixes two different snapshots. Enter each local-tool line as YYYY-MM-DD, amount, without commas inside the amount. The input parser requires a valid calendar date and both positive and negative flows. Multiple entries on the same date can be combined algebraically if their scope is consistent.

Interpret the annualized result within its limits

A short-period XIRR can look large because a small gain is expressed as an equivalent one-year rate. It does not promise that the same growth will continue. Withdrawals, new purchases, fees and valuations must all be complete for the calculation to represent the intended record. Unusual cash-flow patterns can also have multiple mathematical solutions. Preserve the dated schedule and check that the returned rate makes its discounted sum close to zero. Use the result to describe the measured investor experience, without treating it as a recommendation or a forecast of future fund performance.

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.

Weighted Portfolio Return: Formula and Worked Example

Calculate a portfolio’s single-period weighted return, reconcile it to values, and distinguish it from time-weighted and money-weighted performance.

SIP Calculation: Monthly Contributions and Timing

Reproduce the SIP calculator with monthly contributions, beginning-of-month timing and a stated return assumption, then compare zero return and end-of-month deposits.