When you invest in mutual funds or track a Systematic Investment Plan, you can come across two return measures: XIRR and CAGR. Both express how an investment has performed, yet they serve different purposes and apply to different situations. CAGR works well for a single, one-time investment held over a fixed period, while XIRR is built for investments made at multiple points in time, such as monthly SIP instalments. Understanding the distinction matters because using the wrong measure can give you a misleading picture of your actual returns. This guide sets out the formula for each, walks through a worked example, and compares the two side by side so you can pick the right one for your portfolio.]]]
What is XIRR?
XIRR is an extension of the Internal Rate of Return (IRR) that calculates annualised returns for investments with cash flows occurring on irregular dates. It is a method to find out the annualised return where the money is invested in more than one time. Instead of taking the assumption of a single lump sum investment which remains untouched, XIRR takes into account all the cash flows which could be a new SIP investment, top up or withdrawal along with its respective date.
XIRR is the calculation of annualised return for investments involving multiple cash flows made on different dates and considers the amount as well as the time period of each and every investment or redemption. This is the reason why the fund house and the brokers consider it as the investor-specific annualised return.
What is CAGR?
CAGR refers to the compound annual growth rate. CAGR represents the constant annualised rate of return that would take an investment from its beginning value to its ending value over the investment period, regardless of the actual year-to-year fluctuations. This measure works when an investor makes only one investment at a particular point in time and holds onto it until another particular point in time.
Because CAGR smooths out year-to-year ups and downs into one average figure, it tells you what your annual growth rate would have needed to be, on average, to get from your starting amount to your final amount. It doesn't account for money added or withdrawn in between, which is exactly where its limitation shows up against irregular cash flows.
XIRR Formula
The standard way to work out XIRR is through spreadsheet rather than by hand, since it involves solving for a rate through trial and error. The XIRR formula in Excel is: =XIRR(values, dates, guess)
Here, "values" refers to the column containing each cash flow (investments as negative numbers, redemptions or the current value as a positive number), and "dates" refers to the corresponding column of transaction dates. The "guess" entry is optional; Excel defaults to 10% if left blank.
CAGR Formula
CAGR is calculated with a simpler, direct formula:
CAGR = [(Ending Value ÷ Beginning Value) ^ (1 ÷ Number of Years)] − 1
You take the ratio of final value to initial value, raise it to the power of one divided by the number of years, then subtract one. Multiply the result by 100 to express it as a percentage.
Example: XIRR Calculation
Suppose you invest SIPs of ₹4,000, ₹9,000, ₹5,000, ₹4,000 and ₹6,500 across five years and receive ₹53,000 at the end of five years. Each instalment goes in on a different date, so a plain return calculation won't capture the real picture. Entering these amounts and their exact dates into the XIRR function gives an annualised figure that fairly represents your actual investment journey, taking into account that some money was invested earlier and had longer to grow, while other amounts were invested later.
Example: CAGR Calculation
Now consider a straightforward case. You invest ₹1,00,000 as a lump sum, and after three years, it grows to ₹1,33,100.
CAGR = [(1,33,100 ÷ 1,00,000) ^ (1/3)] − 1
CAGR = (1.331) ^ (0.333) − 1
CAGR = 1.10 − 1
CAGR = 0.10, or 10%
Your investment grew at a steady annual rate of 10% over the three years. Because there was one entry point and one exit point, CAGR gives a clean, easy-to-read figure.
XIRR vs CAGR: Key Differences
Basis | XIRR | CAGR |
Cash flow pattern | Multiple, irregular transactions | Single lump sum |
Best suited for | SIPs, top-ups, partial withdrawals | One-time investments |
Timing sensitivity | Accounts for exact dates of each transaction | Represents the equivalent constant annual growth rate between the beginning and ending values |
Calculation method | Solved through iteration (spreadsheet function) | Direct formula |
Reflects | Your personal, transaction-based return | Overall growth rate of the investment |
While XIRR may be seen to work well over CAGR for investments where the cash flows are not regular, such as SIPs, since it takes into account the varying dates of investments, CAGR assumes that there is a fixed rate of return every year.
When to Use XIRR vs CAGR
Use XIRR when your investment involves several transactions spread across time. This covers SIPs, staggered lump sums, additional purchases, and partial redemptions. Since it weighs each cash flow by when it actually occurred, it gives a fair reading of how your money has genuinely worked for you.
You can consider CAGR when you've made one investment and left it untouched until a set date. It suits fixed deposits, a single lump-sum mutual fund purchase, or comparing the long-term growth of an index over a fixed window.
Conclusion
CAGR and XIRR both measure investment growth, but they're built for different circumstances. CAGR suits a single investment with one entry and one exit point, giving you a clean average annual growth rate. XIRR suits SIPs and any pattern of multiple, irregularly timed cash flows, giving you a return figure grounded in your own transaction history.
Before you check your fund's performance, look at how you invested. A one-time purchase calls for CAGR. Regular contributions call for XIRR. Getting this choice right means the return figure you see actually reflects the performance of your investments, rather than a number based on assumptions that don't match your investment style.
FAQs on XIRR vs CAGR
When should I use XIRR instead of CAGR?
Use XIRR whenever your investment involves multiple transactions at different times, such as SIP instalments, top-ups, or partial withdrawals. CAGR only works well for a single lump sum held between one start date and one end date.
Can XIRR be negative?
Yes. If your current value is lower than the total amount invested, XIRR returns a negative percentage, showing that the investment has lost money on an annualised basis.
Which metric is better for SIP returns?
XIRR. It accounts for the exact date and amount of each SIP instalment, giving a true picture of returns rather than treating every payment as if made on the same day.
How is XIRR calculated?
Enter each cash flow (investments as negative values, the current value or redemption as positive) alongside its exact date, then apply the formula =XIRR(values, dates, guess) in Excel or a similar spreadsheet tool.
Why is XIRR preferred for SIP investments?
Because SIPs involve regular but separately dated instalments, XIRR weighs each contribution by how long it has been invested, giving a fair, annualised return rather than a distorted average.
How is CAGR calculated manually?
Divide the ending value by the beginning value, raise the result to the power of one divided by the number of years, then subtract one. Multiply by 100 to get the percentage.
Disclaimer:
The information contained in this newsletter (“Newsletter”) is for general informational purposes only. Northern Arc Capital Limited (“Northern Arc”) does not make any warranties about the completeness, reliability, and accuracy of this information. Any action you take upon the information contained in this Newsletter is strictly at your own risk, and Northern Arc will not be liable for any losses and damages in connection with the use of our Newsletter.
The data included in this Newsletter has been obtained from sources that are believed to be reliable and accurate at the time of publication. However, Northern Arc does not guarantee the accuracy or completeness of any information, nor does it assume any responsibility or liability for any errors or omissions therein. Any opinions expressed herein are subject to change without notice and Northern Arc is under no obligation to update or keep current the information contained in this Newsletter.
This Newsletter is not intended to constitute, and should not be construed as, investment advice or a recommendation to purchase, sell, or hold any security or to engage in any investment strategy or transaction. Readers should not rely solely on the information provided in this Newsletter for making investment decisions and should conduct their own due diligence or seek the advice of a qualified professional.
The content of this Newsletter is for informational purposes only and is not a solicitation or an offer to buy or sell any securities or financial instruments. Northern Arc is not responsible for any investment decisions made by the recipients of this Newsletter. Readers should take independent financial advice from a qualified professional in connection with, or independently research and verify, any information that is provided in this Newsletter and wish to rely upon, whether for the purpose of making an investment decision or otherwise.
Northern Arc and its affiliates, directors, employees, and agents expressly disclaim any and all liability for any direct or indirect losses, damages, or expenses of any kind arising out of or relating to the use of this Newsletter, including but not limited to, any losses related to the accuracy, completeness, timeliness, or reliability of such information.
This Newsletter may contain forward-looking statements that are based on current expectations, estimates, forecasts, and projections about the markets in which Northern Arc operates, as well as management’s beliefs and assumptions. Forward-looking statements are not guarantees of future performance and involve certain risks and uncertainties, which are difficult to predict. Past performance is not indicative of future results.
This report is intended solely for the recipient and is not for further circulation. Any distribution, modification, reproduction, or disclosure of the contents of this Newsletter, in whole or in part, without the prior written consent of Northern Arc, is strictly prohibited.