How Mutual Fund Returns Are Calculated: CAGR vs XIRR

Mutual fund returns in India are calculated using three distinct methodologies—Absolute Returns, Compounded Annual Growth Rate (CAGR), and Extended Internal Rate of Return (XIRR)—with the correct choice determined entirely by your investment duration and cash flow frequency. Retail investors reviewing an account statement from an Asset Management Company (AMC) or platforms like MF Central, Zerodha Coin, and Groww often encounter disparate percentage figures for the exact same portfolio. Seeing an absolute gain of 35% alongside an annualized return of 11% frequently leads to confusion over how much wealth an investment is actually generating.

This discrepancy exists because capital does not behave identically across different investment structures. A single lump-sum deposit sitting undisturbed in an equity scheme for five years generates wealth along an unbroken compounding curve. In contrast, a monthly Systematic Investment Plan (SIP) or a series of intermittent redemptions introduces multiple cash inflows and outflows, meaning different tranches of your money spend vastly different amounts of time in the market. The Association of Mutual Funds in India (AMFI) establishes uniform reporting guidelines for fund factsheets, yet personal portfolio returns must reflect your individual transaction history.

Failing to apply the appropriate return metric can distort your financial planning. An investor who assesses an ongoing SIP using simple CAGR will systematically underestimate their portfolio’s annualized efficiency, while an investor relying on absolute returns over a multi-year horizon risks mistaking sluggish compounding for high performance. Understanding the mathematical framework behind each metric ensures you can accurately evaluate scheme performance, verify whether your portfolio is beating its benchmark index, and set realistic wealth accumulation targets.

Key takeaways

• Absolute Returns measure total point-to-point percentage gain without considering the time taken, making them suitable only for horizons under one year.
• CAGR calculates the constant annual growth rate of a lump-sum investment held for more than one year, smoothing out intermittent market volatility.
• XIRR is the gold standard for SIPs, Systematic Transfer Plans (STPs), and multi-transaction portfolios, calculating an individualized internal rate of return adjusted for exact transaction dates.
• Using CAGR for an ongoing SIP creates an artificially deflated return figure because later installments have not had sufficient time to compound.

Absolute Returns: The Short-Term Benchmark

Absolute return—frequently termed point-to-point return—is the simplest method of measuring investment performance. It calculates the percentage change in your capital from the date of purchase to the date of valuation, completely ignoring the duration of the investment.

The Absolute Return Formula

The mathematical calculation for absolute return is straightforward:

$$\text{Absolute Return (%)} = \left( \frac{\text{Current Value} - \text{Initial Investment}}{\text{Initial Investment}} \right) \times 100$$

Alternatively, using the Net Asset Value (NAV) of the mutual fund units:

$$\text{Absolute Return (%)} = \left( \frac{\text{Current NAV} - \text{Purchase NAV}}{\text{Purchase NAV}} \right) \times 100$$

Practical Example

Suppose an investor allocates Rs. 1,00,000 into an equity fund at an NAV of Rs. 50 on March 1. Seven months later, on October 1, the NAV reaches Rs. 58.

1. Initial Value = Rs. 1,00,000 (2,000 units at Rs. 50)
2. Current Value = Rs. 1,16,000 (2,000 units at Rs. 58)
3. Absolute Return = [(1,16,000 - 1,00,000) / 1,00,000] * 100 = 16%

When to Use Absolute Returns (and When to Avoid Them)

Absolute returns are standard for evaluation periods under 365 days. If you park short-term surplus funds in liquid funds, ultra-short duration funds, or arbitrage schemes for four to nine months, absolute returns offer a clean, unmanipulated snapshot of your nominal gain.

However, absolute returns become deceptive once an investment crosses the one-year mark. Consider two portfolios that both report an absolute gain of 100%:

• Portfolio A doubles an investment of Rs. 5,00,000 to Rs. 10,00,000 in 3 years.
• Portfolio B doubles an investment of Rs. 5,00,000 to Rs. 10,00,000 in 10 years.

On an absolute return basis, both portfolios show a 100% gain. Yet Portfolio A delivered an extraordinary annualized return of approximately 26%, whereas Portfolio B generated a modest 7.18% per year—barely keeping pace with inflation and fixed-income alternatives. For any holding period exceeding 12 months, time must be introduced as an active variable.

For those navigating low-volatility holdings, reviewing debt fund categories in India provides additional clarity on how duration impacts baseline returns across liquid and money market instruments.

Compounded Annual Growth Rate (CAGR): Standard for Lump-Sum Investments

When an investment extends beyond one year, capital does not simply grow linearly; it compounds. The Compounded Annual Growth Rate (CAGR) measures the geometric mean return of an investment over a multi-year horizon, representing the consistent annual rate at which your capital would have grown had it accumulated at a steady pace every year.

Markets do not rise in a straight line. An equity fund might rise 30% in year one, decline 12% in year two, and gain 18% in year three. CAGR dampens these fluctuations into a single, annualized benchmark number.

The CAGR Formula

The formula for calculating CAGR requires the beginning value, ending value, and the investment tenure expressed in years:

$$\text{CAGR} = \left( \frac{\text{Final Value}}{\text{Initial Value}} \right)^{\frac{1}{n}} - 1$$

Where:

• Final Value = Current portfolio value or redemption value
• Initial Value = Initial lump-sum capital invested
• n = Holding period in years (can include fractional years, such as 3.5 for 42 months)

Step-by-Step Calculation Example

Assume an investor deployed a lump-sum amount of Rs. 2,50,000 into a flexi-cap mutual fund on January 1, 2021. By January 1, 2026—a holding period of exactly 5 years—the portfolio value stands at Rs. 4,75,000.

1. Identify the inputs:
   • Initial Value = Rs. 2,50,000
   • Final Value = Rs. 4,75,000
   • $n$ = 5
2. Divide Final Value by Initial Value: $$\frac{4,75,000}{2,50,000} = 1.90$$
3. Raise 1.90 to the power of $(1 / 5)$, which is $0.2$: $$1.90^{0.2} \approx 1.13697$$
4. Subtract 1 and convert to a percentage: $$1.13697 - 1 = 0.13697 \text{ or } \mathbf{13.70%}$$

The portfolio expanded at a compounded annual rate of 13.70%. Notice that the absolute return over this 5-year period is 90% ([(4,75,000 - 2,50,000) / 2,50,000] * 100). Presenting the gain as “90%” sounds impressive, but the CAGR figure of 13.70% allows the investor to compare this performance directly against fixed deposits, provident fund yields, and benchmark indices like the Nifty 50.

The Structural Limitation of CAGR

CAGR relies on an essential premise: exactly two cash flow points (a single entry point and a single exit point).

If you make an initial deposit of Rs. 1,00,000, add Rs. 50,000 in month 14, withdraw Rs. 20,000 in month 28, and check the balance at month 36, standard CAGR cannot compute your return accurately. It has no mechanism to account for the intermediate cash movements or the different durations those tranches spent in the fund. Applying CAGR to recurring transactions produces distorted figures.

Extended Internal Rate of Return (XIRR): The Gold Standard for SIPs

Most retail investors in India do not invest exclusively through single lump sums. According to monthly industry data published by AMFI, mutual fund inflows are predominantly driven by Systematic Investment Plans. When investing Rs. 5,000 or Rs. 15,000 on the 5th or 10th of every month, your money enters the market at different dates, purchasing fund units at fluctuating NAVs.

This structure requires the Extended Internal Rate of Return (XIRR). XIRR is an aggregation of multiple Internal Rates of Return (IRR), adapted to calculate the annualized yield for irregular, dated cash flows.

Why Standard CAGR Fails for SIPs

Consider an investor who starts an equity SIP of Rs. 10,000 per month for 12 months, investing a total of Rs. 1,20,000. At the end of month 12, the portfolio valuation is Rs. 1,32,000.

If you mistakenly evaluate this using the lump-sum CAGR formula over one year: $$\text{Flawed Return} = \left( \frac{1,32,000}{1,20,000} \right)^1 - 1 = \mathbf{10%}$$

This 10% calculation is fundamentally incorrect because the entire Rs. 1,20,000 was not invested for the full 12 months:

• The first installment of Rs. 10,000 was invested for 12 months.
• The sixth installment was invested for only 7 months.
• The twelfth installment was invested for only 1 month.

On average, the investor’s capital was deployed in the market for roughly 6.5 months. Earning Rs. 12,000 on an average capital base of approximately Rs. 65,000 represents a substantially higher annualized performance than 10%. In this specific scenario, the XIRR calculation reveals a true annualized return of roughly 19.1%.

How XIRR Works Mathematically

XIRR solves for the discount rate ($r$) that brings the Net Present Value (NPV) of all cash flows (both inflows and outflows) to zero:

$$\sum_{i=1}^{N} \frac{C_i}{(1 + r)^{\frac{d_i - d_1}{365}}} = 0$$

Where:

• $C_i$ = Cash flow amount at step $i$ (outflows/investments are negative; current portfolio value/redemptions are positive)
• $d_i$ = Date of the $i$-th transaction
• $d_1$ = Date of the first transaction
• $r$ = The discount rate (XIRR) that satisfies the equation

Because this equation cannot be solved through simple algebraic rearrangement, financial software and spreadsheet engines use iterative numerical approximation algorithms (such as the Newton-Raphson method) to solve for $r$.

Learning how to track your mutual fund performance effectively requires verifying that your portfolio dashboard uses XIRR rather than simple averaging for all multi-date investments.

Comparison Table: Absolute Returns vs. CAGR vs. XIRR

The following table summarizes the operational differences, mathematical bases, and application boundaries for each return metric:

Practical Portfolio Scenarios: Choosing the Right Metric

Applying the wrong formula often leads investors to abandon sound strategies or retain underperforming funds. Here is how to apply these metrics across typical investing scenarios.

Scenario 1: The Three-Month Liquid Fund Parking

An investor places a surplus business bonus of Rs. 3,00,000 into an ultra-short-term liquid mutual fund on June 1 and redeems the balance on August 31 (91 days later) at Rs. 3,05,200.

• Calculation Method: Use Absolute Return for raw gains, then annualize for comparison.
• Absolute Gain: [(3,05,200 - 3,00,000) / 3,00,000] * 100 = 1.733%.
• Simple Annualized Equivalent: 1.733% * (365 / 91) = 6.95%.
• Takeaway: Calculating a 5-year CAGR here is meaningless. The investor earned 1.733% in three months, translating to a competitive 6.95% annualized yield, comfortably surpassing standard savings bank rates.

Scenario 2: Five-Year Lump-Sum in a Growth Fund

An investor deployed Rs. 5,00,000 into a fund on April 15, 2021, and did not add or withdraw any capital. On April 15, 2026, the fund balance reached Rs. 10,50,000.

• Calculation Method: CAGR.
• Evaluation: $$\text{CAGR} = \left(\frac{10,50,000}{5,00,000}\right)^{\frac{1}{5}} - 1 = (2.10)^{0.2} - 1 = \mathbf{15.99%}$$
• Takeaway: The absolute return is 110%, but the CAGR of 15.99% gives the precise metric needed to evaluate whether the fund generated sufficient alpha over its category benchmark.

Scenario 3: Five-Year SIP with Step-Ups and Partial Redemptions

An investor initiated a monthly SIP of Rs. 10,000 in 2021, stepped up the contribution by 10% annually, and withdrew Rs. 50,000 in Year 3 to cover an emergency expense.

• Calculation Method: XIRR exclusively.
• Evaluation: The transaction ledger contains over 60 distinct cash outflows (SIP debits) and at least two inflows (the Rs. 50,000 redemption and the final portfolio balance).
• Takeaway: Neither Absolute Return nor CAGR can process this history. Only XIRR can parse the dated ledger entries and yield an accurate annualized performance percentage.

When monitoring investments across high-conviction portfolios, such as top 5 mid cap fund picks for high growth in 2026, tracking XIRR is essential to assess whether periodic market volatility is truly translating into long-term compounding.

Factoring in Costs, Exit Loads, and Taxes

Reported mutual fund returns reflect published NAVs, which are already net of the scheme’s annual Total Expense Ratio (TER). Under regulations governed by the Securities and Exchange Board of India (SEBI), AMCs deduct management fees, operational charges, and distribution costs daily before striking the closing NAV.

However, your personal net return can differ from the NAV return due to external deductions:

Gross NAV Return
  └── Minus: Exit Loads (if redeemed within penalty window)
       └── Minus: Securities Transaction Tax (STT) & Stamp Duty
            └── Minus: Capital Gains Tax (LTCG / STCG)
                 └── Equals: Realized Net In-Hand Return

1. Exit Loads: If you redeem units before completing a mandated holding duration (typically 12 months for equity schemes, though variable for debt), the AMC deducts an exit load (e.g., 1%) from the prevailing NAV. Familiarizing yourself with understanding fund exit loads and charges ensures unexpected exit costs do not erode your performance figures.
2. Stamp Duty: A 0.005% stamp duty applies to all mutual fund purchases in India, marginally increasing the net purchase price per unit.
3. Capital Gains Taxation: Under prevailing Indian tax regulations as of 2026:
   • Equity Funds: Long-Term Capital Gains (LTCG) on units held over 12 months are taxed at 12.5% on gains exceeding Rs. 1.25 lakh in a financial year. Short-Term Capital Gains (STCG) on units held for 12 months or less are taxed at 20%.
   • Specified Debt Funds: Capital gains from debt schemes with equity exposure under 35% acquired on or after April 1, 2023, are added to the investor’s taxable income and taxed at applicable slab rates, irrespective of the holding duration.

Calculated returns from your broker or AMC show pre-tax performance. Your financial plans should always factor in the post-tax yield.

How to Calculate CAGR and XIRR Using Spreadsheets

You do not need specialized portfolio software to compute these metrics. Both Microsoft Excel and Google Sheets include native functions designed for return calculations.

1. Calculating CAGR in a Spreadsheet

In any empty cell, input the following formula structure:

=((Ending_Value / Beginning_Value) ^ (1 / Tenure_In_Years)) - 1

For an investment that grew from Rs. 1,00,000 (Cell A1) to Rs. 2,10,000 (Cell B1) over 4.5 years:

=((B1 / A1) ^ (1 / 4.5)) - 1

Format the target cell as a Percentage to view the resulting CAGR.

2. Calculating XIRR in a Spreadsheet

The XIRR formula requires two data columns: one for cash transaction amounts and one for transaction dates.

Critical Rule for XIRR: Every investment (cash leaving your bank account) must be formatted as a negative number (-). The terminal portfolio value or redemption payout (cash returning to you) must be formatted as a positive number (+).

Spreadsheet Setup Example:

In cell B8, write the formula:

=XIRR(B1:B7, A1:A7)

Format cell B8 as a percentage. The spreadsheet will output the exact annualized return of that investment sequence.

Common Return Calculation Pitfalls to Avoid

Even seasoned investors occasionally misinterpret mutual fund returns due to several recurring analytical errors:

1. Confusing Simple Annualized Return with CAGR

A common shortcut involves taking an absolute return and dividing it by the number of years. For example, if a fund delivers an absolute return of 60% over 4 years, an investor might assume the return is: $$\frac{60%}{4} = 15% \text{ per year}$$

This linear method ignores compounding. The true CAGR for a 60% gain over 4 years is: $$(1.60)^{0.25} - 1 = \mathbf{12.47%}$$ Linear division overstates true compounding by more than 2.5 percentage points annually, leading to unrealistic projections.

2. Point-to-Point Benchmark Distortion

When reviewing a fund factsheet, a fund manager might report a 5-year CAGR of 18%. While factually accurate, point-to-point CAGR depends heavily on the specific start and end dates.

If the start date coincides with a major market low and the end date lands at a bull market peak, the CAGR appears exceptionally high. Conversely, a sharp correction just before the end date can compress the reported CAGR, masking an otherwise solid track record. To evaluate long-term skill, financial analysts evaluate Rolling Returns—the average of multiple overlapping 3-year or 5-year CAGRs calculated daily over a decade—which eliminates entry-point bias.

3. Comparing an Investor’s SIP XIRR to an Index CAGR

Investors often evaluate their equity SIP by looking at the 3-year CAGR of the Nifty 50 on financial news portals. If their SIP reports an XIRR of 14% while the Nifty 50 reports a 3-year CAGR of 17%, they may assume their scheme underperformed.

This is an apples-to-oranges comparison. The Nifty 50’s 17% CAGR reflects a lump sum invested on day one. Had an investor run an identical SIP inside a Nifty 50 index fund over the same 3-year window, the index fund’s XIRR might have been only 13%. Always benchmark an SIP’s XIRR against the index’s equivalent SIP return, not against point-to-point index CAGR.

FAQ

Why is my SIP XIRR different from the fund’s 3-year CAGR shown on the factsheet?

The 3-year CAGR shown on an AMC factsheet measures the growth of a single lump sum invested exactly three years ago and left untouched. Your SIP XIRR reflects multiple smaller investments made on different dates across those three years, meaning each installment has spent a different amount of time compounding in the market.

Can XIRR show a negative percentage even if my total portfolio value is higher than my total invested capital?

Yes, this rare mathematical quirk can occur when early installments experience deep capital losses while a recent, very large installment pushes total portfolio value slightly above total invested cash. Because the older installments compounded negatively over a longer duration, the annualized time-weighted formula can produce a negative rate despite a nominal rupee profit.

Which return metric should I look at for funds held for less than one year?

For investment durations under 365 days, look at Absolute Return to see the exact percentage gain on your capital. To evaluate whether that return is competitive against short-term fixed deposits or savings instruments, multiply the absolute return by (365 / days held) to obtain the simple annualized yield.

Does XIRR include dividend payouts from IDCW mutual fund options?

Yes, provided the cash flows are recorded properly in the calculation. In an Income Distribution cum Capital Withdrawal (IDCW) plan, each dividend received in your bank account must be entered as a positive cash flow (+) on the date it was credited, ensuring the XIRR reflects total return rather than price return alone.

Conclusion

Accurately tracking mutual fund performance requires matching the metric to your investment style. Use Absolute Returns for short-term liquidity parking under twelve months, where duration compounding is negligible. Rely on CAGR when evaluating single lump-sum investments or comparing multi-year fund track records across standardized historical periods. Finally, depend on XIRR as your primary gauge for ongoing SIPs, STPs, and portfolios shaped by frequent contributions or withdrawals.

Knowing how these formulas work prevents the common mistake of comparing apples to oranges—such as measuring an SIP against a lump-sum benchmark. Before altering an asset allocation or replacing a fund manager, verify that your calculations account for transaction dates, ongoing expense ratios, and applicable taxes. When you evaluate your portfolio through the correct mathematical lens, your investment decisions remain grounded in real, actionable numbers.

• Tags:
• Mutual Funds
• Cagr
• Xirr
• Absolute Returns
• Investing in India
• Sip Returns