XIRR Meaning in Mutual Funds: Formula & Examples

By Tanish Sadh, Founder & Principal Officer, WorthOS Technologies Private Limited. MSc in Venture Capital and Private Equity (FinTech), University College London; NISM-certified Investment Adviser Level 1 and Level 2.

Why you can trust this guide

The calculation instructions use Microsoft's XIRR documentation, supported by investor education from mutual-fund providers and Zerodha. The examples are illustrations, not client results. Their cash flows and calculations are shown so you can reproduce them. XIRR describes recorded performance; it does not predict returns or measure investment risk.

Suppose you invest on the first of every month. Your January instalment has more time to grow than your June instalment. Dividing the profit by the total money invested does not account for that difference.

The dates matter even if every instalment is identical. Months have different lengths, and holidays can shift transaction dates. Mirae Asset's explanation of XIRR highlights why actual dates are useful even for a regular monthly SIP.

Think of the distinction this way: total gain answers "How much did I make?" XIRR answers "What annualised rate describes the growth of these dated contributions?" Both figures are useful, but they answer different questions.

Your account statement supplies the transaction dates and amounts. To measure an investment you still hold, you also need its value on a stated valuation date.

This is an independently calculated illustration, not an actual investment or a forecast. Assume you make six contributions and then leave the money invested until the valuation date. There are no withdrawals or separate cash charges in this example.

The contributions total ₹30,000. The assumed final value is ₹33,600, so the rupee gain is ₹3,600.

With no withdrawals, the simple gain percentage is:

₹3,600 ÷ ₹30,000 × 100 = 12%

Using the exact dates above, XIRR is approximately 15.31% a year.

The difference is not an extra profit. Much of the ₹30,000 was invested for less than a year. XIRR accounts for that shorter investment time and expresses the result on an annual basis.

Do not multiply ₹30,000 by 15.31% to work out your profit here. That would treat the entire amount as if it had been invested for a full year. The actual illustrative gain remains ₹3,600.

The final positive entry represents the value still held. It does not mean you must redeem the investment to calculate XIRR.

To reproduce the example, enter Date in A1 and Cash flow in B1. Put the seven dates in A2:A8 and their numeric amounts in B2:B8. Enter amounts without typed currency symbols so the cells remain numeric.

In another cell, enter:

=XIRR(B2:B8,A2:A8)

Format that result cell as Percentage with two decimal places. It should display 15.31%. Before percentage formatting, the underlying result is approximately 0.15311456.

Do not both multiply the formula by 100 and apply percentage formatting. That would display a result 100 times too large.

Use real spreadsheet dates. For example, =DATE(2025,1,1) creates 1 January 2025 without relying on whether your locale interprets a typed date as day-first or month-first.

Microsoft documents the syntax as XIRR(values, dates, [guess]). The optional guess is a starting estimate, not a promised return.

What is the XIRR formula doing?

The calculation finds a rate r that balances the dated cash flows:

Σ [cash flow ÷ (1 + r)^(days since first cash flow / 365)] = 0

Each contribution, withdrawal and ending value has its own time adjustment. Software searches for the rate that makes their discounted sum zero. This is why XIRR is not a simple average of individual returns. Microsoft documents its relationship with XNPV, which equals zero at that rate.

Use the investor's perspective consistently: money you put in is negative; money you receive is positive. For an investment still held, include the remaining value once at the end. Mirae Asset discusses these entries and the treatment of reinvestments and switches.

For example, if you withdraw ₹4,000 and still hold units worth ₹20,000 later, the calculation needs both entries on their respective dates. These figures are illustrative, not a second performance example.

A reinvested distribution is not an additional external contribution from your bank account. Avoid counting it as fresh money while also including the units it purchased in your ending value.

Decide whether you are measuring one scheme or your entire portfolio. A switch leaves one scheme and enters another, but does not necessarily move money outside the overall portfolio. Treating internal transfers as new external deposits can distort the result.

CAGR is useful for a single investment held over time. Applying it directly to the total contributions in a SIP treats those contributions as though they were all present at the start. Tata Mutual Fund explains the distinction between point-to-point growth and dated cash-flow returns.

For the same lump sum, ending value and matching time convention, CAGR and XIRR can agree. XIRR is useful because it can also handle the additional cash flows that a basic CAGR calculation does not.

If you want to model future contributions instead of measuring recorded returns, Worth's mutual fund calculator serves that separate purpose.

The verified SIP example makes this distinction concrete: 15.31% annualised XIRR accompanies a 12% total gain. Always read the rate alongside the invested amount, withdrawals, current value and investment period.

Why short-term XIRR can look unusually high

Consider a separate illustration: ₹10,000 becomes ₹10,500 in exactly 30 days, with no other cash flows. The gain is ₹500, or 5%. Annualising it using a 365-day basis produces approximately 81.05%.

Calculation: (10,500 / 10,000)^(365 / 30) − 1.

The annualised figure does not mean you earned ₹8,105 or can repeat that return over a year. Zerodha specifically cautions that short holding periods can produce unusual XIRR figures.

Is there a "good XIRR" for everyone?

There is no single threshold this guide recommends. Interpret performance in the context of the investment period, asset type, risks and your objectives. A personal return should not be treated as a complete score for a fund manager.

Two investors in the same fund can have different XIRRs because their transaction dates and amounts differ. Likewise, comparing your SIP XIRR with a fund's published lump-sum return does not isolate the effect of fund selection. The underlying cash-flow patterns are different.

Microsoft lists the Excel error conditions in its function documentation. An error can also occur when the numerical search cannot find a solution. For cash flows with repeated changes between positive and negative amounts, more than one solution may exist; a different guess can return a different result.

Start with the underlying entries rather than changing the guess until the percentage looks attractive. Save the statement and valuation date used, so you can reproduce the result later.

• XIRR uses both amounts and dates to measure annualised performance.
• Rupee profit, total gain and XIRR describe different aspects of the result.
• Include withdrawals and the remaining value without double counting.
• Short-period annualisation can exaggerate the apparent scale of a gain.
• A return percentage alone does not establish whether an investment suits you.