What is XIRR in Mutual Funds and how it works?

Investing in mutual funds requires a proper understanding of the return. Most investors invest at different times, either through SIPs or occasional lump-sum investments. In such cases, the calculation of returns using simple methods gives an incorrect picture. This is where XIRR becomes useful.
XIRR helps investors understand the actual annual return on their mutual fund investment by considering both the amount invested and the time of investment. In this blog, we will cover XIRR in mutual funds in detail.
What is XIRR in mutual fund investments?
XIRR is an abbreviation for Extended Internal Rate of Return. XIRR is the technique applied to find the annual returns when investments and withdrawals are made on various dates.
Simply put, the formula for XIRR calculates the annual rate of return based on the transactions’ exact dates. Therefore, it is more accurate compared to other methods of calculating returns.
Why is XIRR important for mutual fund investors?
Typically, the investment in mutual funds is not done in one go. Many investors opt for the SIP system or invest whenever they have surplus funds. Due to this, each investment has a different investment duration.
XIRR is significant because:
- It considers multiple investment dates.
- It provides a realistic rate of return on an annual basis.
- It assists in measuring the performance of SIPs.
- It enables equal comparison of funds.
Without XIRR, it would be difficult for an investor to know the actual performance.
How XIRR works in SIP investments
In SIP, the investments are made with a fixed amount on a regular basis. Each instalment gets invested at different market values, along with the different durations for which the instalment gets invested.
XIRR combines all these instalments and calculates one annual return. This is why SIP returns are always shown using XIRR instead of simple return methods. It gives a clearer picture of long-term investment performance.
👉🏻 Check out our XIRR Calculator to calculate the returns in seconds!
How to calculate XIRR in Mutual Funds
Although most platforms calculate XIRR automatically, understanding the calculation method helps investors trust and interpret the number correctly.
Step by step XIRR calculation in Excel
XIRR can be calculated easily using Microsoft Excel by following these steps:
List all your transactions
Add every investment and every redemption. A missing transaction can cause errors.
Enter cash flows correctly
- The investments must be recorded as negative values.
- The redemption and maturity amounts must be entered as positive values.
Record transaction dates
Enter the exact date of each transaction using a proper date format, such as 10 Jan 2024.
Apply the XIRR formula
Use the Excel formula to calculate returns.
Example of how to use the XIRR function in Excel
Let's get it with a simple example.
You invested:
- ₹20,000 on 5 January 2024
- ₹18,000 on 15 March 2024
- ₹22,000 on 25 June 2024
You redeemed:
- ₹65,000 on 30 August 2025.
Excel formula used: =XIRR(values, dates)
Excel will calculate the annualised return, taking into consideration all the dates of investment and the value at redemption. The result will be the XIRR of your mutual fund investment.
Points to be noted when calculating XIRR in Excel
While calculating XIRR, some considerations must be taken into account to avoid mistakes and wrong calculation outputs. These considerations include:
- It is important to ensure that the dates are accurate and in the correct order, as XIRR is quite sensitive to the transaction dates.
- The investments should be recorded as negative amounts only, and the redemptions or maturity amounts should be recorded as positive amounts only.
- If it is still an investment, add the current portfolio value or NAV as a positive cash flow. This is to enable estimation of the returns up to the current date.
These considerations ensure your result for the XIRR function is correct and valid.
Common mistakes people make with XIRR
Understanding XIRR is important, but its incorrect usage may be misleading and lead to wrong investment decisions. Take a look at some common errors that you must avoid:
- Analysing XIRR over various periods of time: A one-year XIRR should not be directly compared with a five-year XIRR, as the duration of investment plays a major role in return calculation.
- Assuming XIRR guarantees returns: XIRR reflects past performance and does not guarantee future returns because mutual funds are subject to market performance.
- Overlooking key context in XIRR: Analysing only XIRR without taking into consideration the time of investment, risk levels, and market conditions could lead to misinterpretations.
Can we use CAGR instead of XIRR?
The Compound Annual Growth Rate (CAGR) method is effective for single investments, when the investment is held for a fixed period. The CAGR formula does not yield correct results for multiple investments or when investments are made at regular intervals, for example, in SIPs and partial withdrawals.
For instance, where there are multiple cash flows, like in the case of mutual fund investments, XIRR is a more suitable formula. This is because XIRR takes into consideration the date and the amount of all the transactions made. This is why XIRR is preferred over CAGR.
Conclusion
Knowledge of what is XIRR in mutual funds helps in calculating the actual investment performance. XIRR helps in measuring how effectively funds are increasing each year, no matter when investments have been made.
For SIP investors and planners, XIRR is a game-changer. When you understand how XIRR functions, tracking mutual fund returns becomes simpler and more meaningful. By utilising XIRR, SIP investors can make wise decisions and plan for their financial goals with certainty. You can use Dhan’s mutual fund calculator to understand how your investments will turn out in the future.
FAQs
1. Is a higher XIRR value always an advantage?
Partially true. An increasing XIRR indicates stronger past performance, although it is important to consider the timing of the investments.
2. Is XIRR only applicable to SIP investments?
XIRR is applicable to SIPs, lump-sum investments, or any investment where there are multiple cash flows.
3. How frequently is the XIRR rate checked?
Once or twice a year is enough for long-term mutual fund investors.
4. Can XIRR be negative?
Yes. XIRR may be negative if the value of the investment is less than the actual investment amount.
5. Is XIRR better than CAGR?
XIRR functions well when there are multiple investments, such as SIPs, while CAGR is more suited for a single investment.











