How to Check Your Mutual Fund Returns Using XIRR and CAGR

If you have started investing in mutual funds, or are even just thinking about it, you have probably wondered, “How much money am I actually making?” It is a great question. We all want to know if our hard-earned cash is growing. But sometimes, looking at your mutual fund statement can feel a bit like trying to read a foreign language. You might see numbers like ‘CAGR’ and ‘XIRR’ and think, “What on earth do those mean?” and more importantly, in the debate of XIRR vs CAGR, which one should I care about?

Do not worry; you are not alone. It is not as complicated as it seems. In fact, understanding these two numbers is the secret to knowing exactly how your investments are performing. It is like having a fitness tracker for your money. Once you know how to read it, you can make better decisions, stay motivated, and reach your financial goals faster.

In this article, we will explore XIRR vs CAGR, understand what they are, why they differ, and when to use each one. Think of this as your friendly guide to becoming a savvy investor.

Why Tracking Your Returns Matters

Before diving into formulas, let’s keep it simple.

Tracking your returns helps you:

• Know if your investments are growing as expected
• Compare different mutual funds easily
• Make better decisions for future investments
• Stay aligned with your financial goals

Accurately measuring your returns is absolutely essential for evaluating how well your mutual fund is doing and for making smart choices about where to put your money next. 

If you want a quick way to estimate your future returns, you can try the Paytm Money SIP Calculator to visualise how your investments may grow over time. Now, let’s meet our two key measurement tools.

What Is CAGR in Mutual Funds?

CAGR stands for Compound Annual Growth Rate. The easiest way to think about CAGR is that it represents the smooth, steady road your investment would have taken if it grew by the exact same percentage every single year.

In reality, the stock market goes up and down, but CAGR smooths all that out. It does not look at the yearly ups and downs; it only cares about where you started, where you ended, and how long it took. This makes it a straightforward and very useful tool for understanding long-term performance. It provides a clean, average view of growth over time.

The Key Features of CAGR:

• Lump-sum Specialist: It is the perfect metric for evaluating a one-time, “lump-sum” investment. For example, if you invested a single amount of money five years ago and have not touched it since, CAGR is for you.
• Assumes No Changes: CAGR works on the assumption that you made one single investment at the start and have made no additional investments or withdrawals along the way.
• Great for Comparison: Because it is so simple, it makes it easy to compare the historical returns of different investment options, like comparing two different mutual funds over the same 5-year period.

When CAGR is Not the Best Tool

CAGR does not account for the timing or amount of any additional investments you make. Think about how most people actually invest. They do not just put in one large sum and forget about it. Instead, they might save a little bit every month. This is where a very popular strategy comes in: the Systematic Investment Plan, or SIP.

Since CAGR ignores these extra monthly payments, it is less suitable for investment methods that involve periodic contributions, such as SIPs. In fact, it can mislead you if you try to apply it to a SIP because it would only look at your first payment and your final balance, completely ignoring all the money you invested in between. For most modern investors, this makes CAGR less suitable.

Formula and Example of CAGR

For those who are curious, here is the basic formula for CAGR:

CAGR = (Ending Value / Starting Value)^(1 / Number of Years) – 1

Let’s see it in action with a simple example:

Let’s say you made a single investment of ₹50,000 in a mutual fund on January 1, 2015. By January 1, 2020, you check your balance, and it has grown to ₹65,000.

• Your Starting Value: ₹50,000
• Your Ending Value: ₹65,000
• Number of Years: 5

If you put those numbers into a calculator (or Excel), you would find that your CAGR is approximately 5.4%. This means that on average, your investment grew at a rate of 5.4% per year over those five years.

(Source: Paytm Money CAGR Calculator)

What Is XIRR in Mutual Funds?

Now, let’s meet the main event for most mutual fund investors. XIRR stands for Extended Internal Rate of Return. This may sound like a very technical and scary term, but it is actually your best friend.

Think of XIRR as a more sophisticated and personalized method. It is designed to calculate your actual investment return when you have multiple, and often irregular, cash flows. This means it perfectly handles real-life scenarios like:

• Monthly SIPs (Systematic Investment Plans)
• Partial withdrawals when you need some cash
• Additional, irregular lump-sum contributions whenever you have extra money to invest

Unlike CAGR, XIRR is not fooled by a smooth average. It is highly precise because it takes into account three crucial pieces of information for every single transaction:

• The exact date of the transaction.
• The precise amount of money you invested or withdrew.
• The time value of money.

Because it considers both the amount and timing of every payment, XIRR is able to tell you the true rate at which your money has grown, reflecting your unique and actual investment journey.

(Source: HSBC Mutual Fund, Kotak Mutual Fund)

The Key Features of XIRR

• SIP Superhero: It is the ideal and most effective metric for Systematic Investment Plans in India, where you invest a fixed amount regularly.
• Handles Real Life: It perfectly accounts for all your real-world cash flows, including additional deposits and withdrawals at irregular intervals.
• Personalized Performance: It offers a personalized return figure that is based on your real data, showing how your portfolio has truly performed.
• Industry Standard: Because it is so accurate for real-world scenarios, most online investment platforms and mutual fund statements provide XIRR to show you your personalized return.

Formula and Numeric Example of XIRR

XIRR: Sum of (Cash Flow / (1 + r)^(Days Difference / 365)) = 0

XIRR Formula for Excel: =XIRR(values, dates) 

Where:

• Values: This is a list of your cash flows. Money you invest is recorded as a negative number (because it’s an outflow), and money you receive back is recorded as a positive number (because it’s an inflow).
• Dates: This is a list of the exact dates on which each of those cash flows happened.

Let’s understand XIRR with a typical Systematic Investment Plan (SIP)

Investment Details

• Monthly SIP: ₹5,000
• Investment Period: 3 years (Jan 2020 to Dec 2022)
• Total Invested: ₹1,80,000
• Final Value: ₹2,40,000

To calculate XIRR:

• Enter all SIP instalments as negative values
• Enter final redemption value as a positive value
• Use exact transaction dates
• Apply Excel formula:=XIRR(values, dates)

Result: XIRR (annualised) when computed using Excel’s XIRR formula with exact cash flows, the return is ≈ 15.2% per annum.

XIRR is highly sensitive to timing, so even small changes in dates or cash flows can significantly impact the final return. Most modern platforms like Paytm Money automatically show your XIRR, so you do not have to calculate it manually.

Note: Online calculators estimate XIRR based on assumed growth rates. Actual XIRR may differ slightly depending on real market returns, NAV changes, and exact investment dates.

(Source: Online XIRR Calculator)

XIRR vs CAGR: Key Differences

To make it as simple as possible, let’s compare XIRR vs CAGR side-by-side:

(Source: HSBC Mutual Fund, Kotak Mutual Fund)

A Simple Decision Guide

Still not sure which one to use? Here is a simple rule of thumb:

• Use CAGR if you made a single, one-time investment (a lump sum) and have not made any other contributions or withdrawals since. It is great for looking back at long-term history, smooths out short-term fluctuations, and is perfect for comparing different funds on a clean slate.
• Use XIRR if you are investing through a Systematic Investment Plan (SIP) or have made any additional investments or withdrawals over time. This will be the case for the vast majority of mutual fund investors, making XIRR your go-to number for understanding how your unique portfolio has truly performed.

If you are planning to start investing, opening a Demat Account on a trusted platform like Paytm Money can help you track XIRR vs CAGR easily in one place.

Conclusion: Track Your Journey

Tracking your investments does not have to be stressful. By understanding these two key metrics, XIRR vs CAGR, you have the tools needed to accurately measure returns and evaluate mutual fund performance.

While CAGR gives a simplified average return for lump-sum investments, XIRR provides a more realistic and precise picture that reflects your actual investment journey, especially if you use strategies like SIPs. As more investors in India adopt disciplined approaches like Systematic Investment Plans, understanding XIRR is becoming increasingly important.

Knowing how your money has truly performed empowers you to take control. It helps you plan better, adjust your goals, and stay invested with confidence, knowing you are on the right track.

Disclaimer: Mutual fund investments are subject to market risks. Read all the related documents carefully before investing. This content is purely for information purpose only and in no way is to be considered as an advice or recommendation. The securities are quoted as an example and not as a recommendation. Investors are requested to do their own due diligence before investing.

SEBI Reg No.: Broking – INZ000240532, Research Analyst – INH000020086, Depository Participant – IN-DP-416-2019, Depository Participant Number: CDSL – 12088800, NSE (90165), BSE (6707), MCX (57525), NCDEX (1315), MSEI (85300).

Registered Office: 136, 1st Floor, Devika Tower, Nehru Place, Delhi – 110019.

For complete Terms & Conditions and Disclaimers, visit https://www.paytmmoney.com.

FAQs