Every serious investor in India has at some point asked the same question: ‘My SIP has grown nicely, but what is my actual return?’ Or: ‘The mutual fund says 18% CAGR — but I have been doing SIPs for years at different amounts — is that really my return?’ These two scenarios call for two very different financial metrics — CAGR and XIRR — and confusing them can lead to badly misinformed investment decisions.

In this comprehensive guide, CleverCoins breaks down XIRR and CAGR in complete detail — their formulas, their use cases, their limitations, and most importantly, when YOU should use which metric. Whether you are a stock market investor, mutual fund SIP investor, or a financial planner advising MSMEs in Thane or across India, this guide will change how you evaluate investment performance forever.

What Is CAGR – Compound Annual Growth Rate?

CAGR stands for Compound Annual Growth Rate. It is the rate at which an investment would have grown if it grew at a steady annual rate from a single lump-sum investment. In other words, CAGR assumes you invested once and let it compound — no additional investments, no withdrawals in between.

CAGR Formula

CAGR – Practical Example with Indian Rupees

Suppose you invested Rs. 2,00,000 as a lump sum in a mutual fund on 1st April 2021. On 31st March 2026, the value of your investment is Rs. 3,50,000. What is your CAGR?

1. Ending Value = Rs. 3,50,000 | Beginning Value = Rs. 2,00,000 | Number of Years = 5
2. CAGR = (3,50,000 / 2,00,000) ^ (1/5) – 1
3. CAGR = (1.75) ^ (0.20) – 1 = 1.1183 – 1 = 0.1183
4. CAGR = 11.83% per annum

This means your Rs. 2 lakh investment grew at a compounded rate of 11.83% per year over 5 years — clean, simple, single-transaction return.

When Is CAGR Most Useful?

• Evaluating lump sum equity investments over a fixed period
• Comparing mutual fund performance benchmarked against Nifty 50 or Sensex
• Tracking business revenue or profit growth over multiple years
• Comparing two investment options where both involve a single starting investment
• Evaluating real estate appreciation over holding periods
• Calculating Fixed Deposit effective yield over multi-year periods

Limitations of CAGR

• Completely ignores the timing and size of multiple cash flows
• Cannot be used for SIPs, step-up SIPs, or irregular investments
• Masks volatility — a fund may have been negative for 3 years then shot up in Year 4 and 5, yet CAGR shows a smooth return
• Does not account for withdrawals or partial redemptions
• Gives a misleadingly optimistic picture for SIP investors comparing their SIP performance with fund-quoted CAGR

What Is XIRR – Extended Internal Rate of Return?

XIRR stands for Extended Internal Rate of Return. Unlike CAGR, XIRR is designed specifically for situations where there are multiple cash flows happening at irregular intervals — exactly the situation with SIPs, step-up SIPs, lump sum top-ups, and partial withdrawals.

XIRR calculates the single discount rate that makes the Net Present Value (NPV) of all your cash flows — including the final redemption value — equal to zero. In simpler terms, it finds the true annualised return that accounts for exactly when and how much money went in and came out.

XIRR Formula – Conceptual

XIRR – Practical SIP Example with Indian Rupees

Ms. Priya Desai from Thane did monthly SIPs of Rs. 5,000 in an equity mutual fund from April 2024 to March 2026 (24 installments). In April 2026, she redeems everything and receives Rs. 1,38,500.

5. Total invested = 24 x Rs. 5,000 = Rs. 1,20,000
6. Value on redemption = Rs. 1,38,500
7. Absolute gain = Rs. 18,500 (15.4% absolute return)
8. Correct XIRR = approximately 15.8% per annum (this is the TRUE annualised return)

Simple CAGR on this would give a completely distorted picture because it cannot account for the 24 different investment dates. XIRR is the only correct metric here.

How to Calculate XIRR in Excel / Google Sheets

9. List all investment dates in Column A (as dates), all outflows as negative values in Column B
10. Add the final redemption date and value as a positive number at the bottom of Column B
11. In any empty cell, type: =XIRR(B1:B25, A1:A25)
12. Excel/Sheets will return the annualised XIRR — multiply by 100 for percentage
13. For step-up SIPs or lump sum top-ups, add those as additional rows with their respective dates and negative values

When Is XIRR Most Useful?

• Calculating SIP returns in mutual funds — monthly, quarterly, or step-up
• Evaluating portfolio returns where multiple purchases were made at different times
• Calculating returns on REITs with regular distributions
• Business investment analysis with irregular cash inflows and outflows
• Evaluating NPS contributions and projected corpus
• Insurance-linked investment plans (ULIPs) with irregular premium payments
• Any investment scenario involving partial redemptions and reinvestments

Limitations of XIRR

• Requires accurate date-wise records of every transaction — sloppy bookkeeping leads to wrong XIRR
• Can give misleading results if the holding period is very short (less than 1 year)
• Does not distinguish between good performance and the timing luck of the investor

CAGR vs XIRR – The Complete Side-by-Side Comparison

Real-World Scenarios – CAGR vs XIRR in Action

Scenario 1: Mutual Fund Lump Sum Investment (Use CAGR)

Mr. Rahul Mehta from Mumbai invested Rs. 10,00,000 in SBI Bluechip Fund on 1st January 2021. On 1st January 2026, his investment is worth Rs. 19,85,000.

• CAGR = (19,85,000 / 10,00,000) ^ (1/5) – 1 = 14.7% per annum
• This is perfectly accurate because it is a single lump sum with one entry and one exit point
• XIRR and CAGR give the same result in this single-cash-flow scenario

Scenario 2: Monthly SIP in Equity Fund (Use XIRR – CAGR is Wrong)

Ms. Anjali Sharma from Thane runs a Rs. 10,000/month SIP in Parag Parikh Flexi Cap Fund since January 2022. She has invested for 4 years (48 months). Total invested = Rs. 4,80,000. Current value = Rs. 7,20,000.

• Naive CAGR (WRONG): (7,20,000/4,80,000) ^ (1/4) – 1 = 10.67% — This is INCORRECT
• Correct XIRR: Approximately 18.2% — because each SIP installment had a different investment horizon
• The difference is 7.53% — a massive gap that completely changes the investment assessment

Scenario 3: Direct Equity Portfolio with Averaging (Use XIRR)

Mr. Vikram Joshi from Navi Mumbai bought shares of Infosys over multiple dates:

• Total invested = Rs. 62,500 + Rs. 56,800 + Rs. 94,800 = Rs. 2,14,100
• Sale proceeds = Rs. 2,85,000 | Absolute return = Rs. 70,900 (33.1%)
• XIRR (considering exact investment dates) = approximately 22.4% per annum
• If wrongly calculated as CAGR from Jun 2023 to Apr 2026: approximately 11.2% — deeply misleading

Scenario 4: NPS Contribution Analysis (Use XIRR)

A salaried employee contributes Rs. 6,000/month to NPS (Tier 1) from April 2020 to March 2026 — 72 months. Total contribution = Rs. 4,32,000. NPS corpus value as on 31 March 2026 = Rs. 7,85,000. XIRR = approximately 19.6% per annum — a very strong return that simple absolute or CAGR calculation would not accurately capture.

Using XIRR for Tax Planning – The CleverCoins Approach

One area where XIRR becomes a critical professional tool is tax planning — specifically for optimising redemption strategies. At CleverCoins, we use XIRR calculations to help our clients make smarter redemption decisions. Here is how:

Equity Mutual Fund Capital Gains Tax in 2026 (Post Finance Act 2024)

Under the Finance (No. 2) Act 2024, equity mutual fund capital gains taxation was revised. As of FY 2025-26 and AY 2026-27, the rules are:

How XIRR Helps Optimise Redemption Timing

Consider an investor with a large SIP portfolio nearing the LTCG threshold. Using XIRR, their CA or financial advisor can:

14. Calculate the exact XIRR of each tranche of units and identify units near the 12-month LTCG boundary
15. Estimate the approximate capital gain amount before redemption
16. Plan partial redemptions across two financial years to stay below the Rs. 1.25 lakh LTCG exemption limit
17. Compare the post-tax XIRR of different redemption strategies to pick the most tax-efficient one
18. Use tax loss harvesting — selling loss-making units — to offset LTCG from profitable units

XIRR in Business Context – For MSMEs, Startups, and Freelancers

XIRR is not just for personal investing — it is an essential tool for business decision-making. At CleverCoins, we use XIRR to help our MSME clients evaluate business investments, loan decisions, and franchise ROI analysis.

1. Project Return Analysis

An MSME in Thane invested Rs. 15,00,000 in a manufacturing upgrade project over 3 phases: Rs. 5 lakh upfront (January 2024), Rs. 6 lakh in July 2024, and Rs. 4 lakh in January 2025. The project generated net inflows of Rs. 3,50,000 per quarter from April 2025 to March 2026 (Rs. 14,00,000 received). Using XIRR on these irregular cash flows gives an IRR of approximately 16.8% — far more accurate than any CAGR-style calculation.

2. Loan vs Own Funds Decision

An entrepreneur deciding between a bank loan at 11% per annum or deploying own capital should compare the XIRR of their business deployment against the post-tax cost of the loan. If the XIRR of business use exceeds the loan rate, external borrowing is justified. CAGR cannot make this analysis because business cash flows are always irregular.

3. Franchise or Dealership Investment Evaluation

Franchise businesses — particularly popular in Mumbai MMR (dealerships, retail outlets, fast food) — involve a large upfront security deposit, monthly royalties (outflows), and monthly sales revenue (inflows). XIRR is the only tool that can accurately evaluate the true return on such complex, multi-cash-flow business models.

Common Misconceptions About CAGR and XIRR – Clarified

Misconception 1: XIRR is Always Higher Than CAGR for SIPs

Not necessarily. XIRR can be higher or lower than a naive CAGR depending on the sequence of market returns. If early SIP installments were made when markets were low (buying cheap), XIRR tends to be higher. If early installments were made when markets were high and then markets fell, XIRR could be lower than a simple absolute return calculation might suggest.

Misconception 2: I Can Directly Compare My XIRR With the Fund’s CAGR

This is a partially valid but dangerous comparison. A fund’s CAGR is calculated on a lump sum invested at a specific point. Your XIRR depends on when your SIP installments were made. You could have invested in the same fund and had a different XIRR than the fund’s CAGR — both higher and lower — depending purely on market timing.

Misconception 3: CAGR is More Reliable Than XIRR

CAGR is simpler, not more reliable. For lump sum scenarios, both are equally reliable. For SIPs and irregular flows, CAGR is simply the wrong tool — it does not account for the problem being solved. XIRR is more complex but is the correct metric for multi-cash-flow analysis.

Misconception 4: XIRR of 25% is Always Better Than XIRR of 18%

Not always — you need to consider risk, time horizon, and investment size. An XIRR of 25% on a Rs. 1 lakh portfolio over 1 year is very different from an XIRR of 18% on Rs. 50 lakh over 10 years. The second creates far more actual wealth. Always evaluate XIRR in context.

Misconception 5: XIRR Cannot Handle Dividend Reinvestment in Mutual Funds

It can — but each dividend reinvestment shows up as an additional purchase transaction (outflow) in your mutual fund account statement. You must include each dividend reinvestment as a separate negative cash flow row in your XIRR calculation. Ignoring these leads to significantly understated XIRR.

Tools to Calculate XIRR and CAGR in India – 2026

1. Microsoft Excel / Google Sheets

The most reliable tools. Enter dates in Column A, cash flows in Column B (outflows negative, inflows positive), and type =XIRR(B1:B25, A1:A25) in any empty cell. Excel has supported XIRR since Excel 2010. Google Sheets has identical syntax.

2. Zerodha Coin / Groww Portfolio Tracker

Both platforms display XIRR automatically for your mutual fund portfolio in real time. The app fetches each transaction date and NAV and computes XIRR — no manual calculation needed for retail SIP investors.

3. Kuvera and ET Money

Premium portfolio tracking platforms that display XIRR per fund, per asset class, and for your total portfolio. ET Money’s goal-based investing features also use XIRR as the primary return metric.

4. AMFI Mutual Fund Calculator at amfiindia.com

The Association of Mutual Funds in India (AMFI) offers a free online SIP returns calculator that uses XIRR methodology behind the scenes. A good starting point for retail investors who do not want to use Excel.

5. ClearTax Portfolio Tracker

ClearTax provides a capital gains and XIRR breakdown useful for tax filing. Particularly helpful during ITR filing season (July–August) when you need to report actual returns from equity and debt investments.

Quick Reference: When to Use CAGR vs XIRR – Decision Framework

Conclusion – Know Your Number, Make Smarter Decisions

CAGR and XIRR are both powerful — but they are designed for very different scenarios. Using the wrong metric is not just an academic error; it can lead to overestimating or underestimating your actual investment performance by several percentage points, leading to poorly timed redemptions, tax inefficiencies, and misaligned financial planning.

The rule of thumb is simple: Single investment, single exit — use CAGR. Multiple investments or withdrawals at different times — use XIRR. And if you are ever unsure about which metric applies to your portfolio, or if you want a professional tax and investment analysis, CleverCoins is here to help.

We are Chartered Accountants and financial advisors based in Mumbra, Thane, serving traders, MSMEs, freelancers, and salaried professionals across the Mumbai Metropolitan Region and pan-India via remote consultation. Visit us at clevercoins.org to book a consultation.