What Is XIRR in Mutual Funds? Meaning, Formula, Calculation and Benefits

When you invest in mutual funds through SIPs, your money is invested at regular intervals rather than all at once. You may also increase your SIP, pause it for a few months, make an additional lump sum investment, or redeem part of your investment. In such cases, simply looking at the total profit may not show the complete picture.

This is where XIRR in mutual funds becomes useful. XIRR stands for Extended Internal Rate of Return. In simple terms, XIRR meaning refers to the annualised return on your investment after considering both the amount invested and the exact date of each transaction.

This is especially relevant for SIP investors because each instalment remains invested for a different period. For example, an SIP instalment made three years ago has had more time to grow than one made last month. XIRR adjusts for this difference and provides a more realistic view of your actual investment performance.

By understanding XIRR, you can evaluate mutual fund returns more precisely and make better-informed decisions aligned with your long-term financial goals.

What Is XIRR?

When you invest in mutual funds through a SIP, you usually invest every month. Each instalment is invested on a different date and at a different Net Asset Value (NAV). Over the years, you may also increase your SIP, pause it for a few months, make additional lump sum investments, or redeem part of your investment. In such situations, calculating your actual returns becomes slightly more complex.

XIRR means Extended Internal Rate of Return. It is an annualised rate of return that considers every investment, redemption and other cash flows along with their exact dates. When applied to all your cash flows, XIRR calculates the annualised return that equates your investments and withdrawals with your current portfolio value.

In simple terms, XIRR is your personal rate of return. It shows the actual return you have earned based on when you invested and how much you invested. XIRR uses a financial formula to account for irregular cash flows made on different dates, making it suitable for investments with multiple transactions.

Unlike basic return calculations, XIRR accounts for the timing of each investment. For example, ₹10,000 invested five years ago has had more time to grow than ₹10,000 invested recently. XIRR adjusts for this timing difference and provides a more realistic view of your investment performance.

In mutual funds, XIRR is widely used to calculate annualised returns for SIPs and investments involving multiple transactions. That is why returns for mutual fund SIPs are commonly presented using XIRR, as it reflects your actual investment experience more accurately.

Why XIRR is important for mutual fund investors?

When you invest in mutual funds, your transactions are rarely uniform. You may begin with a SIP of ₹7,000 per month, later increase it to ₹9,500, add a lump sum of ₹60,000 during a market correction, or redeem ₹35,000 for a short-term need. Over seven years, these varied contributions may grow into a corpus of ₹2,40,000.

In such cases, a simple return calculation does not capture the full picture. ₹20,000 invested seven years ago has had more time to grow than ₹20,000 invested just two years ago. This difference in investment duration is exactly what makes XIRR more useful than simple return calculations.

XIRR considers every investment, redemption and other cash flows along with their respective dates, and converts them into a single annualised rate of return. It is particularly useful for calculating SIP returns because each instalment remains invested for a different period.

This is why XIRR in mutual funds is widely used to measure the annualised return on investments involving multiple transactions. It provides an accurate and practical way to measure your actual mutual fund investment performance across multiple and uneven transactions.

How to calculate XIRR in Excel?

If you invest through SIPs or make multiple transactions in a mutual fund, Microsoft Excel can help you calculate XIRR without manually applying a complex formula. Excel has a built-in XIRR function that is designed for investments with irregular cash flows and different transaction dates.

1. Enter your transaction details

Open Microsoft Excel and create two columns:

Follow this rule while entering the cash flows:

For example, if you invest ₹8,000, enter it as -8,000. If you redeem ₹44,500, enter it as 44,500.

2. Add the final value

If you have redeemed your investment, enter the redemption amount with the redemption date as a positive value. If you are still invested, enter the current market value of your portfolio with today’s date as the final positive cash flow. This helps Excel calculate the return based on all investments made and the current value of your holdings.

3. Apply the XIRR formula

In an empty cell, type:

=XIRR(values, dates, guess)

Here:
• Values: Refers to the range of cells containing your cash flow amounts (investments and redemptions).
• Dates: Refers to the range of cells containing the corresponding transaction dates.
• Guess: An optional estimate of the expected rate of return. In most cases, you can leave this blank, and Excel will calculate the XIRR automatically.

For example, if your cash flows are in cells B2 to B7 and your dates are in cells A2 to A7, the formula will be:

=XIRR(B2:B7, A2:A7)

Press Enter, and Excel will display the annualised XIRR. If the result appears as a decimal, format the cell as a percentage.

XIRR calculation example in Excel

Let us take a simple example of a five-month SIP:

• SIP amount: ₹8,000 per month
• Investment period: 01-02-2024 to 01-06-2024
• Redemption date: 01-07-2024
• Amount received: ₹44,500

Enter the data exactly as shown below:

Here:

• Column A contains all transaction dates
• Column B contains all cash flows
• Investments are negative values
• Redemption is positive

Click on any empty cell, for example B9, and type:

=XIRR(B2:B7, A2:A7)

• B2:B7 represents the cash flow values
• A2:A7 represents the corresponding dates

Press Enter, and Excel will display the annualised XIRR percentage, which represents your actual return after accounting for both the timing and amount of each transaction.

The calculator is an aid, not a prediction tool. It may provide only an indicative picture.

Important points to remember

• Always enter investments as negative values
• Always enter redemption or portfolio value as positive
• Ensure dates are entered in proper date format
• Include all transactions for accurate results

While manual calculation of XIRR is mathematically complex, Excel or a reliable online calculator makes the process simple and practical for everyday investors.

How to use Bajaj Finserv AMC’s online XIRR calculator?

By entering your investment details correctly in the XIRR calculator, you can quickly understand your actual annual return across multiple transactions:

1. Enter the first investment date in the ‘Investment Date’ field to record when your initial amount was invested
2. Enter the corresponding amount in the ‘Investment Amount’ field as the money you invested on that date
3. Use the slider if needed to quickly adjust and match the exact investment amount
4. Click on ‘Add More Investments +’ if you have invested on more than one occasion
5. Enter the date and amount for each additional investment to capture all your cash outflows
6. Use the delete option to remove or correct any entry if you notice an error
7. Enter the ‘Returns Date’ to indicate when you redeemed your investment or checked its current value
8. Enter the total ‘Returns Amount’ received or the present value of your holdings as the final inflow
9. Click on ‘Calculate XIRR’ to compute your annualised return across all transactions
10. View the XIRR result displayed on the right side as your percentage return per annum

The calculator is an aid, not a prediction tool. It may provide only an indicative picture.

Benefits of using XIRR in mutual funds

Understanding how XIRR improves return measurement can help you evaluate your mutual fund performance more realistically and confidently:

Accurate measurement of real returns

XIRR considers both the amount and timing of every investment and withdrawal, giving you a more precise annual return than simple averages or CAGR.

Suitable for SIPs and multiple transactions

XIRR works well when you invest at different dates or amounts, making it ideal for tracking SIPs, additional purchases, and partial redemptions.

Reflects annualised performance clearly

XIRR presents your return as an annualised percentage, allowing you to compare mutual funds with other instruments that also quote yearly returns.

Helps you make informed decisions

By showing your actual return experience, XIRR enables you to review performance objectively and decide whether to continue, rebalance, or reassess your investments.

Brings clarity to irregular cash flows

XIRR simplifies complex cash flow patterns into one meaningful figure, helping you understand how your money has truly grown over time.

Limitations of XIRR in mutual funds

While XIRR is useful for measuring returns across multiple transactions, you should be aware of certain practical limitations:

• Does not reflect investment risk: XIRR shows the return earned but does not indicate volatility or potential downside risk.
• Does not adjust for inflation: The return calculated is nominal and does not account for changes in purchasing power.
• Excludes taxes unless adjusted manually: Tax impact and exit loads are not considered unless included in the cash flow entries.
• Assumes reinvestment at the same rate: It presumes interim cash flows are reinvested at the calculated return, which may not match real conditions.
• Can be sensitive to timing: Large investments or withdrawals made at specific market levels can materially influence the result.

XIRR vs CAGR: Key differences

When you evaluate mutual fund returns, both CAGR and XIRR are commonly used metrics, but they serve different purposes depending on how you invest:

When should you use CAGR instead of XIRR?

You can use CAGR, but only in certain situations. CAGR measures the annual growth between a starting amount and an ending amount over a fixed period. For example, if ₹20,000 invested four years ago grows to ₹31,600, the annual return can be expressed as a single CAGR figure.

This works well when you invest a lump sum once and remain invested without adding or withdrawing money.

However, if you invest ₹8,000 every month for four years, each instalment stays invested for a different duration. The first instalment gets four full years to grow, while the last instalment may get only one month.

In such cases, calculating one simple CAGR does not accurately reflect your real return.

XIRR solves this by considering the amount and timing of every investment and withdrawal, and then presenting one annualised return.

So, CAGR is suitable for one-time investments and scheme performance, while XIRR is generally more appropriate for personal investments involving SIPs or multiple transactions.

Conclusion

XIRR helps you understand the true annual return on your mutual fund investments when money moves in and out at different times. It converts multiple SIPs, lump sums, and withdrawals into one clear percentage, making performance easier to interpret. While it has certain limitations, using XIRR thoughtfully allows you to track progress better and stay aligned with your long-term financial goals.

FAQs

Why is XIRR important for SIP investors?

SIPs involve investing fixed amounts at regular intervals, but each instalment stays invested for a different duration. XIRR accounts for this timing difference and gives you a more accurate annual return than simple averages or point-to-point returns.

What does a 10% XIRR mean?

A 10% XIRR means your investment has grown at an annualised rate of 10% per year, after considering all contributions, withdrawals, and their respective dates.

Is a 12% XIRR good?

Whether 12% XIRR is good depends on the type of fund, market conditions, your time horizon, and risk tolerance. It should ideally be compared with inflation, benchmark returns, and similar funds before drawing conclusions.

Can XIRR be negative?

Yes, XIRR can be negative if the current value of your investment is lower than the total amount invested. This indicates that your investment has generated a loss over the selected period.

Is XIRR effective for short term investments?

XIRR may be less effective for short-term investments because it annualises returns, which can exaggerate gains or losses over brief holding periods. For investments held for less than one year, absolute return is often a more practical measure, while XIRR is generally better suited for long-term investments involving multiple transactions such as SIPs or partial withdrawals.

How is XIRR different from CAGR?

CAGR measures the growth between a beginning value and an ending value over a fixed period. XIRR, however, considers every individual investment and withdrawal, making it more suitable for SIPs and irregular cash flows.

Is XIRR better than CAGR for SIPs?

For SIPs, XIRR is generally more appropriate than CAGR because it factors in multiple investment dates and amounts. CAGR works better for one-time lump sum investments held for a fixed duration.

What is the difference between XIRR and absolute return?

Absolute return shows the total percentage gain or loss without considering time. XIRR converts your gains into an annualised return, reflecting both the duration and timing of your investments.

Should you rely only on XIRR to evaluate performance?[

No, XIRR measures return but does not reflect risk, volatility, taxation, or inflation. You should review it alongside other performance and risk indicators before making financial decisions.