How to Use the XIRR Formula to Measure Your Mutual Fund Returns

Vikram checks his mutual fund app every few months and sees a number labelled "XIRR" next to his SIP portfolio. He has never known exactly what it means, only that a higher number seems to be better. If you have felt the same way, you are not alone, and understanding this one number will change how you evaluate every SIP you ever run.

What is XIRR? #

XIRR (Extended Internal Rate of Return) is the annualised return of an investment that has multiple cash flows happening on different dates, in different amounts, in either direction (money going in or coming out).

This is exactly what a SIP looks like. Every month you invest a fresh instalment on a different date. If you have ever paused a SIP, increased it, added a lumpsum top-up, or made a partial withdrawal, your investment has an even messier pattern of cash flows. CAGR cannot handle this because CAGR assumes one single starting amount and one single ending amount. XIRR is built specifically to handle multiple, irregularly timed cash flows and still give you one meaningful annualised return number.

How XIRR is calculated #

Unlike CAGR, which has a simple formula you can compute by hand, XIRR does not have a straightforward algebraic formula. It works by finding the discount rate that makes the net present value (NPV) of all your cash flows, each one dated on the day it actually happened, equal to zero.

In plain terms: XIRR asks, "at what single annual rate would all my investments, if grown from their individual dates to today, add up to exactly my current portfolio value?" Then it solves for that rate using trial and error (technically called iteration), which is why every mutual fund app, and the XIRR calculator, computes it for you rather than expecting you to do it by hand.

The three ingredients XIRR needs for each SIP instalment are:

1. The date the investment was made (negative cash flow, money going out of your pocket)
2. The amount invested on that date
3. The final date and value, the current worth of your holding (positive cash flow, money notionally coming back to you today)

A real example with Indian numbers #

Suppose you started a SIP of ₹5,000 a month in an equity fund on the 5th of every month, starting 5 April 2023, and you want to check your returns as of 5 April 2025, exactly 24 monthly instalments later.

Your cash flows look like this:

• 5 April 2023: -₹5,000
• 5 May 2023: -₹5,000
• 5 June 2023: -₹5,000
• ... (continuing every month) ...
• 5 March 2025: -₹5,000
• 5 April 2025: -₹5,000 (the 24th and final instalment)
• 5 April 2025: +₹1,42,000 (current value of your holding, all 24 instalments combined)

Total invested over 24 months: ₹1,20,000. Current value: ₹1,42,000. Absolute return looks like a healthy 18.3%, but that number does not tell you the annualised rate, because your instalments went in at different times; the first instalment has had a full 2 years to grow, while the last instalment has had almost no time at all.

Feeding these exact dated cash flows into the XIRR calculator (the same set-up used in this worked example at SIP 5,000 monthly for 2 years) gives an XIRR of approximately 17.2%. That 17.2% is the single annualised rate that fairly accounts for the fact that your money went in gradually over 2 years, not all at once.

Compare this to what CAGR would have wrongly suggested if you mistakenly treated the ₹1,20,000 as a single lumpsum invested exactly 2 years ago: CAGR = (1,42,000/1,20,000)^(1/2) - 1 = about 8.8%. That number is wrong for a SIP and dramatically understates your actual annualised performance, because it assumes all your money was invested from day one, when in fact most of it was invested much more recently and simply has not had time to grow yet.

Why XIRR matters for you #

It is the only fair way to measure SIP returns. Since every SIP instalment is essentially its own mini-investment with its own start date, XIRR is the metric built to average all of them into one honest number.

It handles irregular investing, not just SIPs. If you invest a bonus as a lumpsum in December, then resume your regular SIP in January, then skip two months due to a cash crunch, XIRR still works, because it only needs the date and amount of every cash flow, regardless of pattern.

It works for ELSS tax-saving funds too. Since ELSS SIPs have a 3-year lock-in calculated per instalment, XIRR is especially useful here to check your true annualised return once instalments start maturing out of lock-in, as shown in this ELSS tax-saving SIP example.

It lets you compare a SIP against other investments fairly. Once you have your SIP's XIRR, you can compare it directly to a fixed deposit's interest rate, another fund's XIRR, or a target return you are chasing for a financial goal, because XIRR expresses everything in the same "annualised percentage" language.

Common mistakes and myths about XIRR #

Mistake 1: Confusing XIRR with CAGR and using them interchangeably. As shown above, applying CAGR to a SIP badly understates your actual return, because it assumes a lumpsum investment that never happened. Always use XIRR for SIPs and other multi-date cash flows, and reserve CAGR for genuine single lumpsum investments.

Mistake 2: Forgetting to include the current value as a final positive cash flow. XIRR calculations fail or give nonsensical results if you only list your outgoing instalments without including today's portfolio value as the final incoming cash flow. Every XIRR calculation needs at least one negative and one positive cash flow.

Mistake 3: Assuming a high XIRR over a very short period means the fund is genuinely great. A SIP running for only 6-8 months can show an unusually high or low XIRR simply because there has not been enough time for short-term market swings to average out. Give XIRR at least 2-3 years of data before drawing strong conclusions.

Mistake 4: Not accounting for exit load or taxes. The XIRR your mutual fund app shows is usually calculated on the current NAV, before any exit load or capital gains tax you would pay on actually redeeming. Your real, in-hand XIRR after selling will be slightly lower.

Tips and best practices #

• Use XIRR whenever your investment has more than one cash flow date: SIPs, step-up SIPs, lumpsum top-ups, or partial withdrawals.
• Always double-check that your dates are entered correctly; XIRR is sensitive to the exact number of days between cash flows, especially for shorter investment periods.
• Compare your fund's XIRR to its benchmark index's XIRR over the same exact dates and period, not to a generic market average, for a fair comparison.
• Recalculate XIRR periodically (once or twice a year) rather than obsessing over it monthly, since short-term market noise can swing it significantly.
• Use the XIRR calculator rather than a manual spreadsheet formula unless you are comfortable with Excel's iterative XIRR function and how to format dates correctly.

Where XIRR fits with your other tools #

If you are still in the planning stage and want to project a future SIP's growth rather than measure a past one's actual return, the SIP calculator is the right tool, since it works forward from an assumed rate of return. Once your SIP has been running for a while and you want to check how it has actually performed, switch to the XIRR calculator. And if you ever invested a single lumpsum with no further contributions, CAGR is the simpler, correct metric to use instead of XIRR.

Frequently asked questions #

What is a good XIRR for a SIP in India? #

For equity mutual fund SIPs held over 5 years or more, an XIRR in the range of 12-15% is generally considered healthy in the Indian market, though this varies with market conditions during the specific period measured.

Can XIRR be negative? #

Yes. If the current value of your investments is lower than what you put in, XIRR will show a negative percentage, reflecting an annualised loss over the period measured.

Is XIRR the same as the return shown in my mutual fund app? #

Most Indian mutual fund apps and platforms display XIRR specifically for SIP and other multi-date investments, and label it as such, though some apps use the term "annualised return" instead. If the app shows a single number for a SIP portfolio, it is almost certainly using XIRR under the hood.

Why is my SIP's XIRR lower than the fund's advertised 5-year CAGR? #

The fund's advertised CAGR usually reflects the return on a lumpsum invested at the very start of the 5-year period. Your SIP instalments went in gradually, so most of your money has had less time to grow than a lumpsum would have, which typically results in an XIRR different from the fund's headline CAGR.

Do I need to calculate XIRR manually every month? #

No. Mutual fund platforms, the AMC's own app, and the XIRR calculator on AwesomeCalcs all compute this automatically once you provide the cash flow dates and amounts, or in the app's case, automatically from your transaction history.

Check your actual SIP returns #

If you have been running a SIP for a while and only ever look at the current value versus what you invested, you are missing the real picture of how well your money has performed. Use the XIRR calculator with your actual instalment dates and amounts to see the one number that fairly captures your annualised return, and compare it honestly against your goals.