What is XIRR in Mutual Fund? Meaning, Formula & Calculation
When you invest in mutual funds, understanding your returns is as important as choosing the right fund. However, calculating returns is not always simple, especially if you invest through a Systematic Investment Plan (SIP). This is because every SIP instalment is invested on a different date. For example, the ₹5,000 you invested in January has spent more time in the market than the ₹5,000 invested in December. This is where XIRR in mutual funds helps calculate annualised returns by considering both the amount invested and the timing of every investment.
In this blog, see why XIRR in SIP is actually an important metric.
What is XIRR in Mutual Fund?
XIRR’s full form is Extended Internal Rate of Return.
It is a method used to calculate the annualised return of investments where multiple transactions happen on different dates.
In mutual funds, investors may invest through monthly SIPs, make additional investments, or withdraw money at different times. Since every transaction has a different investment period, a simple return calculation may not reflect the actual performance.
XIRR considers:
- Investment amount
- Investment dates
- Withdrawals
- Current investment value
How XIRR Works in a Mutual Fund
XIRR works by treating every transaction as either money going out or money coming in.
| Transaction | Treatment |
| SIP investment | Negative cash flow |
| Additional investment | Negative cash flow |
| Redemption or withdrawal | Positive cash flow |
| Current portfolio value | Positive cash flow |
For example:
- January: Invest ₹10,000
- March: Invest ₹15,000
- December portfolio value: ₹30,000
XIRR calculates the annualised return by considering the exact investment dates and cash flows.
What is the XIRR formula?
The XIRR formula calculates the rate at which the net present value of all cash flows becomes zero.
Formula:
XIRR = Σ [Cash Flow ÷ (1 + Rate)^(Days/365)] = 0
Where:
- Cash Flow means the investment or withdrawal amount
- Days represent the time between transactions
- The rate represents the annualised return
Although the formula may look complex, investors usually calculate XIRR using Excel or Google Sheets.
How to Calculate XIRR in a Mutual Fund?
You can calculate XIRR easily using Excel or Google Sheets.
Follow these steps:
- Create one column for transaction dates.
- Create another column for cash flows.
- Enter investments as negative values.
- Enter withdrawals and current value as positive values.
- Apply the XIRR formula.
XIRR Formula:
=XIRR(values, dates)
XIRR in mutual fund example:
| Date | Amount |
| 1 January 2025 | -₹5,000 |
| 1 February 2025 | -₹5,000 |
| 1 March 2025 | -₹5,000 |
| 31 December 2025 | ₹18,000 |
The result will show the annualised return on your investment.
What is a Good XIRR?
A good XIRR in mutual funds depends on the fund type, investment period, and market conditions. Generally, a higher XIRR than the fund’s benchmark or category average indicates better investment performance.
| Mutual Fund Type | XIRR Range Often Considered Favourable |
| Equity Mutual Funds | Around 12% to 15% or higher over the long term |
| Hybrid Mutual Funds | Around 10% to 12% over the long term |
| Debt Mutual Funds | Around 6% to 8%, depending on interest rate conditions |
However, these ranges are only general references and not guaranteed returns. Investors should evaluate XIRR along with risk level, consistency, financial goals, and investment duration.
Why is XIRR Used in Mutual Funds?
XIRR is used because mutual fund investments usually involve multiple transactions. It helps investors calculate returns more accurately when money moves in and out of an investment at different times.
Some key reasons why XIRR is useful include:
1. Tracks Multiple Investments
In SIP investing, every monthly contribution is a separate investment. XIRR calculates returns by considering all these investments together.
2. Considers Investment Timing
The duration for which money stays invested impacts returns. XIRR includes transaction dates while calculating performance.
3. Measures SIP Performance Better
Since SIPs involve regular investments, XIRR provides a more practical return calculation compared to methods that assume a single investment date.
4. Helps Compare Investments
XIRR gives an annualised percentage return, making it easier to compare different investment options.
Understand the detailed difference between SIP and lumpsum mutual funds.
What is the Difference Between XIRR Return and Mutual Fund Return
Mutual fund return is a broad term that may include different return calculations such as absolute return, CAGR, annualised return, or trailing return.
XIRR return specifically represents the investor’s actual annualised return based on their investment dates, withdrawals, and current portfolio value.
XIRR vs CAGR – How Do They Differ?
Both XIRR and CAGR measure investment returns, but they are used in different situations.
| Factor | XIRR | CAGR |
| Full form | Extended Internal Rate of Return | Compound Annual Growth Rate |
| Suitable for | Multiple transactions | Single investment |
| Commonly used for | SIP investments | Lump sum investments |
| Cash flow timing | Considered | Not considered |
| Return type | Personalised return | Overall growth rate |
CAGR works well when you invest once and stay invested. XIRR works better when there are multiple investments or withdrawals.
Want to understand how technology is reshaping investing and financial decision-making?
Explore how AI is transforming modern investing strategies in India in our guide on AI and Future of Finance in India and see how smarter tools are changing the way investors analyze returns, risks, and financial goals.
XIRR vs Absolute Return
Absolute return only shows how much your investment has increased or decreased. It does not consider time.
For example:
If ₹1 lakh becomes ₹1.5 lakh:
Absolute return = 50%
However, it does not explain whether this growth happened in one year or five years.
XIRR considers the investment period and shows the annualised return.
| Factor | XIRR | Absolute Return |
| Measures | Annualised performance | Total gain or loss |
| Considers time | Yes | No |
| Suitable for | Long-term tracking | Basic return calculation |
Explore Investment Choices with jUMPP
With this investment app, you can explore Direct Mutual Funds, start SIPs in seconds, buy digital gold, and view your investment portfolio in one place as you move closer to your financial goals.
Disclaimer- The rankings and figures in this article have been compiled from multiple verified reports, credible news sources, and public financial data available as of 2026.
All values are approximate and may vary with newer updates, revisions, or changes in official records.
FAQs
A 12% XIRR means your investment has generated an annualised return of approximately 12%, considering the amount and timing of all investments and withdrawals. In mutual funds, XIRR helps calculate actual returns when there are multiple transactions, such as SIP investments.
There is no fixed XIRR that is considered good for all mutual funds. It depends on factors like fund category, investment duration, market conditions, and risk level. Investors usually compare XIRR with similar funds and benchmarks to evaluate performance.
A 20% XIRR means your investment has delivered an annualised return of around 20% based on your investment dates and cash flows. However, investors should also consider consistency, investment period, and market conditions before judging performance.
The 15-15-15 rule is a popular investment concept that suggests investing ₹15,000 every month for 15 years with an assumed annual return of 15% could help create a large investment corpus. However, actual returns depend on market performance and are not guaranteed.
Both CAGR and XIRR are useful for different types of investments. CAGR is suitable for measuring returns on a one-time investment, while XIRR is generally preferred for SIPs and investments with multiple transactions.
A 13.5% XIRR may be considered good depending on the type of mutual fund, investment duration, and market conditions. It should be compared with the fund category average and the relevant benchmark.
Yes, XIRR can be negative. A negative XIRR means the current value of your investment is lower than the amount invested after considering all cash flows and transaction dates.
No, XIRR is not limited to one year. It calculates annualised returns for investments across different time periods and is especially useful for long-term investments with multiple transactions.
