CAGR vs XIRR vs Absolute Return: Which Should You Trust?
When you open your mutual fund portfolio on platforms like Groww, Zerodha Coin, or Upstox, you are bombarded with different percentage numbers. Which one actually represents how much money you made? This guide demystifies financial jargon and shows you exactly how to measure your wealth.
Written by Rajat
Founder, StepupCalculator · 3 min read
The 30-Second Summary (TL;DR)
- Absolute Return: Shows raw profit percentage. Use it for investments held for less than 1 year.
- CAGR (Compound Annual Growth Rate): The standard for comparing funds. Use it ONLY for one-time lumpsum investments.
- XIRR (Extended Internal Rate of Return): The true metric for your portfolio. Use it for SIPs (Systematic Investment Plans) and irregular investments.
Deep Dive: Understanding Each Metric
Let's break down how the math works and why using the wrong metric can trick you into making terrible financial decisions.
Absolute Return
What is it used for?
Quick check — how much profit did I make in total? For instance, if you invest ₹1 Lakh and it becomes ₹1.5 Lakhs, your absolute return is 50%. This metric is completely unaware of time. It tells you the total wealth generated over the entire period of investment without standardizing it to a per-year basis. It is extremely useful when you just want to look at the absolute numbers in your bank account and feel good or bad about the total ₹ value gained.
When is it best?
Short-term lumpsum investments (<1 year) or simple P&L checks. If you buy a stock today for ₹1000 and sell it next month for ₹1100, the absolute return is 10%. In short timeframes, annualising returns (CAGR) can lead to absurdly high numbers (like 120% per year) which are misleading. Hence, absolute return is the king of short-term tracking.
The Critical Flaw
Ignores time entirely. Making 50% in 1 year looks mathematically identical to making 50% in 10 years, which is highly misleading. If it takes you 10 years to turn ₹1 Lakh into ₹1.5 Lakhs, that is a terrible investment that probably did not even beat Indian inflation. But the absolute return still proudly says 50%!
Real-World Example
You invest ₹1,00,000 and it becomes ₹1,50,000. Your absolute return is exactly 50%. Whether this took 1 month, 1 year, or 10 years, the absolute return remains 50%. This is why you must never use this to compare two different mutual funds over different timeframes.
CAGR (Compound Annual Growth Rate)
What is it used for?
Annualised return for a single, one-time lump sum investment. CAGR smooths out the extreme volatility of the Indian stock market. It tells you what your consistent annual growth rate would be if the investment grew at a steady, fixed rate every single year. For example, your ₹10 Lakhs growing to ₹2 Crores over 15 years.
When is it best?
Comparing the historical performance of two mutual funds over 3, 5, or 10 years. Whenever you see mutual fund advertisements claiming a "15% return over 5 years", they are talking about CAGR. It is the gold standard for measuring the performance of a Lumpsum investment.
The Critical Flaw
Cannot handle multiple investments at different times (like a SIP). Assumes you invested once and never added or withdrew money. If you try to calculate the CAGR of your monthly ₹10,000 SIP, the formula will completely break and give you a mathematically wrong, artificially low percentage.
Real-World Example
You invest ₹10,00,000 once. After 5 years, it is ₹20,11,357. Your CAGR is exactly 15% p.a. This means your wealth compounded at an average rate of 15% every single year for 5 years.
XIRR (Extended Internal Rate of Return)
What is it used for?
The true annualised return for SIPs, partial withdrawals, or any irregular investing. This is the only metric that understands the concept of cash flows happening on different dates. When you do a ₹5,000 monthly SIP, every single ₹5,000 tranche spends a different amount of time in the market. XIRR assigns a specific timeframe to each and calculates the aggregate return.
When is it best?
Tracking your actual portfolio performance on apps like Groww or Zerodha Coin. Since human beings rarely invest just once in their lives, we constantly add money when we get bonuses, or withdraw when we need cash. XIRR perfectly tracks this messy reality of personal finance.
The Critical Flaw
Requires complex computation (Excel, Google Sheets, or our calculators) — impossible to do manually. The formula requires solving a complex polynomial equation which computers can do in milliseconds but humans cannot do on paper.
Real-World Example
You invest ₹10,000 every month for 10 years. Total invested is ₹12,00,000. Current value is ₹23,24,432. Your XIRR is ~12.5% p.a. If you just did a raw CAGR on the total, it would look like you made less, which is mathematically false.
Why CAGR Fails Miserably for SIPs
The most common mistake amateur investors make is comparing the XIRR of their 2-year old SIP against the 10-year CAGR of a mutual fund shown on Google. This is like comparing your marathon pace to a sprinter's 100m dash.
The Timing Problem
CAGR assumes your entire capital was invested on Day 1. But in a SIP, you invest in monthly tranches. If you run a 5-year SIP, your very first ₹5,000 instalment compounds for a full 60 months. However, your last ₹5,000 instalment only compounds for 1 month!
Because a large portion of your SIP capital spends very little time in the market, calculating a raw CAGR on the final amount will make your returns look artificially terrible. XIRR fixes this by applying a separate CAGR calculation to every single monthly instalment based on exactly how many days it stayed in the market.
What Do Brokers Like Zerodha and Groww Show?
Your Personal Dashboard = XIRR
When you look at your own portfolio dashboard, the annualised return percentage shown is almost always XIRR. This is because you likely have a mix of SIPs, lump sums, and partial withdrawals. Only XIRR can handle this messy reality.
Fund Factsheets = CAGR
When you are researching a mutual fund (e.g., looking at "Parag Parikh Flexi Cap 5-Year Return"), the platform displays CAGR. They do this to standardize comparisons, assuming a hypothetical investor who put in a lumpsum 5 years ago and did nothing else.
Wealth Warning: Metrics are backward-looking. A fund with a 25% 3-year CAGR will likely regress to the mean. Do not chase historical returns without understanding the fund's strategy.Read our full disclaimer →
Calculate True Returns on Your Portfolio
Stop guessing your actual wealth growth. Use our free advanced calculators to measure exact CAGR and project future SIP wealth.