Mutual funds
What Is XIRR and How to Read SIP Returns Correctly
Learn what XIRR means, why simple returns mislead for SIPs, how to check your own XIRR, and how it differs from CAGR, with a clear worked example.
WealthDox Editorial · Published 5/11/2026 · 7 min read · Updated 5/11/2026
Why Simple Returns Mislead for SIP Investors
- Simple return
- total gain divided by total invested
- XIRR
- annualised return that accounts for each SIP date
- Best for
- monthly SIPs and extra lump sums
- Check
- your fund statement or portfolio tracker
Many investors judge a SIP by one number: how much the portfolio is worth compared with how much was invested. This is a simple return, and it ignores when each instalment went in.
A SIP adds money every month. Early instalments have had more time to grow than recent ones, so one total-gain figure can hide what really happened.
- Simple return ignores timing, so a SIP running for 2 years and one running for 10 years can show similar percentages.
- It does not show an annual rate, which makes comparison with fixed deposits or other funds difficult.
- It can look strong after a short rally and weak after a long flat period.
XIRR was built to solve this problem. It gives one annual rate that matches all the money going in with the final value coming out, with each date weighted correctly.
Tip
Ask two questions about any SIP number: how much was invested in total, and over what period? Without both, the return figure has little meaning.
What XIRR Measures in Mutual Fund SIPs
XIRR stands for Extended Internal Rate of Return. It is the annual rate at which the present value of all your cash flows adds up to zero.
In simple terms, XIRR asks: what yearly growth rate would explain the path from your monthly payments to today's value? Each payment is treated as a separate investment with its own date.
For a SIP, the cash flows usually look like this:
- Each monthly SIP instalment is an outflow with its exact date.
- Any partial withdrawal or switch-out is an inflow on its date.
- The current value of your units, on today's date, is a final inflow.
The table below shows how a typical SIP maps into XIRR inputs.
| Cash flow | Date | Sign in XIRR |
|---|---|---|
| Monthly SIP of Rs 10,000 | 5th of every month | Negative |
| Partial withdrawal | Date of redemption | Positive |
| Current portfolio value | Today | Positive |
Most fund houses and portfolio tools report XIRR for your schemes, and you can recalculate it yourself in a spreadsheet using the XIRR function. You can read more about fund basics on our mutual fund guide.
Worked SIP Example: Reading XIRR With Illustrative Numbers
The example below uses illustrative numbers only. It does not refer to any real fund, and it is not a forecast of how any scheme will perform.
Assume an investor puts Rs 10,000 into a Regular plan SIP on 1 January, 1 February and 1 March. The units are worth Rs 31,500 on 31 March.
| Date | Cash flow (Rs) | Days from first SIP |
|---|---|---|
| 1 January | -10,000 | 0 |
| 1 February | -10,000 | 31 |
| 1 March | -10,000 | 59 |
| 31 March | +31,500 | 89 |
To read the result, follow these steps:
- Total invested is Rs 30,000, and the value is Rs 31,500.
- Simple return is 31,500 divided by 30,000, minus 1, which equals 5 per cent.
- XIRR works on the timing of each payment and gives roughly annualised for this illustrative case.
XIRR Versus CAGR: Which Return Number to Use
CAGR stands for Compound Annual Growth Rate. It works well when you invest one amount on one date and withdraw it on another date.
For example, Rs 1,00,000 invested as a lump sum that grows to Rs 1,61,051 after 5 years has a CAGR of 10 per cent. XIRR gives the same 10 per cent for these two cash flows, because there is only one entry and one exit.
The difference appears when money goes in at many dates. CAGR assumes one start date, so it does not fit a SIP well. XIRR handles many dates naturally.
| Feature | CAGR | XIRR |
|---|---|---|
| Number of investment dates | One | Many |
| Typical use | Lump sum investments | SIPs and staggered investments |
| Input needed | Start value, end value, years | Each cash flow with its date |
| Works for SIPs | Not directly | Yes |
Tip
Use CAGR for a lump sum and XIRR for a SIP. Using them the other way round gives misleading comparisons.
How to Check Your Own SIP XIRR Step by Step
Checking your own XIRR takes about 15 minutes with a statement and a spreadsheet. The steps below work for most mutual fund SIPs held in India.
- Download your consolidated account statement or transaction statement covering all SIP dates.
- List each SIP date and amount in one column, with the amount entered as a negative number.
- Add a final row with today's date and the current value of your units as a positive number.
- In a spreadsheet, use the formula =XIRR(values, dates) with the two columns selected.
- Compare your result with the XIRR shown for that scheme. Small differences can arise from unit allotment timing and rounding.
Plan type matters here. A Regular plan includes distributor commission in its expense ratio, so its net return is lower than the Direct plan of the same scheme. Check the plan name printed on your statement before comparing numbers.
- Compare XIRR only between the same plan type, such as Regular with Regular or Direct with Direct.
- Include any exit load or tax effect if you want the net amount you could take home.
Limits of XIRR You Should Know Before Relying on It
XIRR is a useful tool, but it has clear limits. Reading it alone can give an incomplete view of a fund.
The table below lists the most common limits and what they mean for your decisions.
| Limit | What it means for you |
|---|---|
| Assumes the final value is realised on that date | Actual exit may be lower after taxes or exit load |
| Short periods inflate annualised figures | Judge SIPs over longer tenures, such as 5 years or more |
| Ignores risk | Two schemes with similar XIRR can have very different ups and downs |
| Sensitive to lump sum timing | One large top-up can change the XIRR sharply |
XIRR also tells you nothing about the quality of the fund's holdings, its management team or its cost structure. These need separate checks.
For a wider comparison that includes risk and cost, read our mutual fund basics guide.
Watch out
Past XIRR does not predict future XIRR. A strong past figure can be followed by weak returns, and a weak past figure can be followed by better ones.
Disclaimer
This article is written for general educational purposes for Indian retail investors. It does not constitute investment advice, a recommendation or an offer to buy or sell any security or mutual fund scheme.
All numerical examples are illustrative and have been created only to explain the XIRR calculation. They do not represent any real fund, and they are not forecasts of future returns.
Mutual fund investments are subject to market risks. Read all scheme-related documents carefully before investing, and consider consulting a SEBI-registered investment adviser based on your own financial situation and goals.