1. Home
  2. Blog
  3. SIP XIRR
TagImage
logoimg
Prudent Corporate

28 Sep 2026

When to Use CAGR and XIRR in Mutual Funds?

Have you ever looked at a mutual fund’s published factsheet, checked your own portfolio statement, and wondered why the two figures don’t match? It is a common scenario. This difference does not mean your fund house made an error. This discrepancy between fund returns and investor returns is one of the most discussed points in personal finance. It comes from one distinct factor: The mathematical difference between how fund performance is reported vs how your money is deployed (CAGR and XIRR). Let’s understand! The Math: XIRR and CAGR A big reason people get confused about their returns is that they measure them the wrong way. What Is CAGR (Compounded Annual Growth Rate)? CAGR measures the annual rate at which an investment grows from a single starting value to a single ending value. It assumes profits are reinvested each year.  When does CAGR work? CAGR is useful for evaluating one-time lumpsum investments held without any deposits or withdrawals over n years. Where does CAGR not work? CAGR cannot evaluate Systematic Investment Plans (SIPs). If you invest ₹10,000 every month for five years, your first installment stays invested for 60 months, but your 60th installment stays invested for only 30 days. Applying a single point-to-point CAGR across all those varying timeframes is mathematically invalid. So, when multiple cash flows happen within a time period, XIRR comes into picture. What Is XIRR (Extended Internal Rate of Return)? XIRR shows your yearly return when you invest money on different dates. Unlike a single deposit, it tracks every SIP installment and withdrawal to calculate your true annual gain. Every time you invest via SIP, buy an additional tranche, receive a dividend payout, or make a partial redemption, XIRR assigns a specific date to that cash flow and calculates the exact annualized rate of return across the entire series. CAGR vs. XIRR Example: How the Return Gap Happens in Real Life Consider an investor evaluating a mid-cap mutual fund over a three-year cycle: Year 1: Fund NAV rises from ₹100 to ₹140 (+40%). The investor watches from the sidelines, sees the 40% return, and decides to invest ₹5,00,000 at the ₹140 peak. Year 2: The market corrects. Fund NAV drops from ₹140 to ₹105 (-25%). Uncomfortable with the paper loss, the investor pauses further contributions. Year 3: The market recovers. Fund NAV rebounds from ₹105 to ₹155 (+47.6%). The Outcome The Fund’s 3-Year CAGR: The NAV moved from ₹100 to ₹155 over three years, delivering 7% CAGR. The Investor’s Personal Return: The investor purchased units at ₹140 at the end of Year 1. Over the remaining two years, their investment moved from ₹140 to ₹155, yielding an annualized return of 2%. The fund delivered nearly 16% annualized return. But the investor walked away with 5.2%. The only reason was because the capital entered the market at the wrong point in the cycle. Frequently Asked Questions (FAQs) 1. Why is My Mutual Fund Portfolio Return Different from the Fund's 3-Year Return? The 3-year return on a factsheet is a point-to-point CAGR assuming a single lumpsum deposit on day one. If you are investing via monthly SIPs, your money was deployed across different dates and varying NAVs, resulting in an XIRR that reflects your actual cash flows. 2. Is XIRR Always Lower than CAGR? No, XIRR is not always lower than CAGR. They serve different purposes: CAGR (Compound Annual Growth Rate) evaluates a single point-to-point investment, whereas XIRR (Extended Internal Rate of Return) accounts for multiple cash flows occurring at different dates, such as an SIP. 3. How Do I Calculate XIRR for My Investments? Most mutual fund platforms and distributor portals calculate XIRR automatically. You can also calculate it manually in Microsoft Excel or Google Sheets using the =XIRR(values, dates) formula. Enter your investments as negative numbers (since it's an outflow of money), redemptions/current value as positive numbers, and their corresponding transaction dates. Disclaimer: Mutual fund investments are subject to market risks. Please read all scheme-related documents carefully before investing. Historical performance and point-to-point CAGR metrics are illustrative and do not guarantee future returns.