Data last verified: June 2026
XIRR vs CAGR: Which is Better for Calculating Mutual Fund Returns?
Confused between XIRR and CAGR? Learn the exact differences, when to use each metric, and how to accurately calculate your mutual fund and SIP returns.
Jashmin is a finance professional and founder of AbacusHand. She specialises in EMI & loan planning, income tax under old and new regimes, and SIP investment analysis for Indian households. Every calculator and article on AbacusHand is personally reviewed by her for accuracy.
When you invest in mutual funds, tracking your portfolio's performance is crucial. But if you've ever looked at your investment dashboard, you've likely seen two different return metrics: CAGR and XIRR. Many investors mistakenly use them interchangeably, leading to a completely wrong understanding of how their money is growing. So, what is the actual difference between XIRR and CAGR, and which one should you use to evaluate your mutual fund returns? Let’s break it down.
What is CAGR (Compound Annual Growth Rate)?
CAGR stands for Compound Annual Growth Rate. It is a measure of how much an investment has grown on an annualized basis over a specific period, assuming the profits were reinvested at the end of each year. CAGR smooths out the volatility of returns and gives you a single, consistent growth rate. It is the most accurate metric for investments where you make a single, one-time payment and let it grow.
What is XIRR (Extended Internal Rate of Return)?
XIRR stands for Extended Internal Rate of Return. It is an advanced mathematical formula used to calculate the annualized return when there are multiple cash flows occurring at different intervals. In the context of mutual funds, if you are investing through a Systematic Investment Plan (SIP), your money is going in every month. Because each installment has a different time horizon, you cannot use CAGR. XIRR accounts for the time value of money for every single transaction, giving you the true annualized return of your portfolio.
XIRR vs CAGR: The Core Differences
Here is a quick comparison to help you understand how they differ:
- Cash Flows: CAGR only works with a single initial investment and a single final value. XIRR handles multiple investments and withdrawals over time.
- Best Used For: CAGR is ideal for lumpsum investments, fixed deposits, and real estate. XIRR is essential for SIPs, SWPs, and portfolios with staggered investments.
- Calculation: CAGR is a simple mathematical formula: [(Ending Value / Beginning Value)^(1/n)] - 1. XIRR requires an iterative process, usually calculated using financial calculators or spreadsheet software like Excel.
Why CAGR is Misleading for SIPs
Let’s look at a practical example. Suppose you start a ₹10,000 monthly SIP in an equity mutual fund. After 3 years, you have invested a total of ₹3,60,000, and your current portfolio value is ₹4,50,000. Your absolute return is 25%. If you try to apply the CAGR formula here, it will assume your entire ₹3,60,000 was invested on Day 1 for 3 years. This will give you a highly inaccurate annualized return (around 7.7%). In reality, your first ₹10,000 was invested for 36 months, but your last ₹10,000 was invested for only one month. Using our XIRR calculator, the true annualized return for this SIP is actually around 11.5%. This is why CAGR fails for SIPs.
When to Use CAGR and When to Use XIRR
To ensure you are evaluating your investments correctly, follow this simple rule of thumb:
- Use CAGR when: You made a lumpsum investment, you are comparing a mutual fund's historical 3-year or 5-year returns against its benchmark, or you are evaluating the growth of a single asset like a bond or FD.
- Use XIRR when: You are investing via SIPs, you have started multiple SIPs on different dates, you have made partial withdrawals from your portfolio, or you are calculating the overall return of a portfolio that includes both lumpsum and SIP investments.
How to Calculate XIRR and CAGR
Calculating these metrics manually can be tedious, but several tools make it effortless. For CAGR, you can simply use a CAGR calculator or apply the formula in Excel. For XIRR, you can use our dedicated XIRR calculator by entering your transaction dates and amounts. If you prefer Excel, you can use the manual formula for lumpsum returns, and the `=XIRR()` function for SIP returns by listing all your cash outflows (investments) as negative numbers and the final portfolio value as a positive number on today's date. Most modern investment apps like Zerodha Coin and Groww also automatically display XIRR for your mutual fund portfolios.
Pro Tip: If your SIP is less than a year old, your XIRR might show extreme volatility (either very high positive or deep negative returns) due to short-term market movements. It is highly recommended to wait until your SIP completes at least 12 to 18 months before drawing any conclusions about your fund's performance.
The Bottom Line: Which is Better?
Neither XIRR nor CAGR is universally 'better'—they simply serve different purposes. CAGR is the king of lumpsum investments, providing a clean, easy-to-understand growth rate. XIRR is the undisputed champion for SIPs and complex portfolios, ensuring that the timing of your cash flows is accurately accounted for. By using the right metric for the right investment type, you can make much more informed decisions about where to park your money next.
Want to know the exact annualized return of your mutual fund portfolio? Use our free calculators to find out in seconds.
Calculate Your Returns NowFrequently Asked Questions
No, CAGR assumes a single initial investment. For SIPs, you must use XIRR because each installment has a different time horizon. Using CAGR for a SIP will give you a highly inaccurate and usually lower return figure.
CAGR stands for Compound Annual Growth Rate, which measures the mean annual growth rate of an investment. XIRR stands for Extended Internal Rate of Return, which calculates annualized returns for multiple, staggered cash flows.
Mutual fund fact sheets usually show point-to-point CAGR returns for lumpsum investments over specific periods (like 3 or 5 years). Your personal XIRR reflects the specific dates, amounts, and market entry points of your individual SIP installments, which will naturally differ from the fund's benchmark CAGR.
In Excel, list all your investment dates in one column and the corresponding amounts (as negative values) in the adjacent column. In the next row, put today's date and your current portfolio value (as a positive value). Finally, use the formula `=XIRR(values_range, dates_range)` to get your annualized return.