Highlights

  • Understand the fundamental difference between CAGR and XIRR for irregular cash flows.
  • Learn how the XIRR formula accounts for the timing of every SIP instalment.
  • Discover why XIRR provides a more realistic picture of your actual wealth creation.

Introduction

Ever wondered why your mutual fund app shows a return that doesn’t quite feel right?

When you invest in a mutual fund, you aren’t usually just making a one-time deposit. You might be starting a Monthly SIP, pausing it, making occasional lump sum additions, or withdrawing small amounts when you’re short on cash.

Because these “cash flows” happen at different times, a simple percentage return doesn’t tell the whole story. That’s where XIRR comes in.

What is XIRR?

XIRR stands for Extended Internal Rate of Return.

In the world of mutual funds, it is the most practical and widely accepted way to calculate the real-time performance of your investments when your transactions are spread out over time. While a standard “Point-to-Point” return only considers the start and end dates, XIRR accounts for the timing of every rupee that enters or leaves your portfolio.

Why XIRR Matters:  If you invest ₹10,000 every month for a year, your first ₹10,000 has 12 months to grow, while your last ₹10,000 has only one month. You can’t just average those returns. XIRR treats each instalment as a mini-investment and calculates a single, consolidated annual rate that reflects your actual gain.

Why XIRR is Important for Mutual Fund Investors

Knowing why XIRR matters is important because it reflects how your money actually worked for you.

Here’s why XIRR is preferred:

  • Accounts for timing: Investing ₹10,000 last year and ₹10,000 last month should not be treated equally.
  • Ideal for SIPs: SIPs have multiple investment dates, making CAGR (Compounded Annual Growth Rate) inaccurate.
  • Better comparison: Helps compare two funds even if investments were made at different times.
  • Realistic view: Shows true performance instead of inflated or misleading returns.
  • Practical for real portfolios: Works well for SIPs, STPs, SWPs, and partial redemptions.

Why CAGR isn’t Enough for SIP Investors

Most investors are familiar with CAGR. While CAGR is excellent for comparing the performance of two funds over a fixed period (lump sum), it falls short for SIPs.

  • CAGR assumes a single investment at the start and a single withdrawal at the end.
  • XIRR accounts for the specific date of every buy and sell transaction, making it the gold standard for real-world portfolio tracking.

Understanding the XIRR Formula

The XIRR formula extends the Internal Rate of Return (IRR) to handle irregular cash flows. Mathematically, it solves for the discount rate r that makes the Net Present Value (NPV) of all cash flows equal to zero:

Where:

  • Pᵢ is the iᵗʰ cash flow (investment or withdrawal).
  • dᵢ is the iᵗʰ payment date.
  • d₁ is the first payment date.
  • r is the XIRR.

How to Calculate XIRR for Your Investments

You don’t need to be a math wizard to find your XIRR. Here is how you can do it using a simple spreadsheet:

  1. List the Dates: In one column, enter the dates of every SIP instalment and any additional lump sum purchases.
  2. List the Amounts: In the next column, enter the investment amounts as negative numbers (since money is going out of your pocket).
  3. Current Value: For the final entry, use today’s date and the current market value of your investment as a positive number.
  4. The Formula: Use the formula = XIRR(values_range, dates_range).

Moving Toward Clarity in Your Wealth Journey

Understanding metrics like XIRR helps you move from a passive observer to a confident, self-directed investor by cutting through market jargon and focusing on what truly matters—your actual returns. By tracking real performance instead of market noise, XIRR builds the discipline and patience needed for long-term wealth creation, acting as a reliable compass whether you’re starting your first SIP or managing a diversified portfolio of WealthBaskets.

FAQs

1. What is a good XIRR in mutual funds?

A “good” XIRR depends on the asset class and your financial goals. For equity mutual funds in India, many investors aim for an XIRR that beats inflation and the benchmark index (like Nifty 50) over 5-7 years.

2. Can XIRR be negative?

Yes. If the current market value of your total investment is less than the total amount you have invested, the XIRR will be negative, reflecting a temporary loss in the portfolio.

3. Is XIRR better than CAGR?

For SIPs and portfolios with multiple buy/sell transactions, XIRR is significantly better because CAGR cannot account for the timing of cash flows.

4. How often should I check my XIRR?

While XIRR is useful for tracking performance, checking it daily can lead to emotional decisions. Reviewing your XIRR quarterly or annually is sufficient for long-term wealth building.