Want to know the real annual return on your investment — not just the total gain? Enter your numbers and get your true CAGR in seconds.
CAGR (Compound Annual Growth Rate) is the rate at which an investment grows each year over a set period — assuming returns are reinvested throughout. Think of it as the smoothed-out annual growth rate: real-world returns bounce up and down each year, but CAGR cuts through that noise and gives you one clean number. Unlike simple returns, it accounts for compounding, so you're seeing the true annualised picture.
Investors use CAGR everywhere — to judge stocks, mutual funds, real estate, even business revenue growth. It answers one simple question: "At what steady annual rate did my investment actually grow?" Once you know that, comparing very different investments becomes straightforward.
It takes three numbers and gives you the rest instantly:
Everything updates instantly as you move the sliders — no need to hit calculate.
The formula looks like this:
CAGR = [(Final Value / Initial Value)^(1 / Number of Years) - 1] × 100
Let's walk through a real example:
Step 1: Divide the final value by the initial value
₹5,00,000 ÷ ₹1,00,000 = 5
Step 2: Raise that to the power of (1 ÷ number of years)
5^(1/5) = 5^0.2 = 1.3797
Step 3: Subtract 1 and multiply by 100 to get the percentage
(1.3797 - 1) × 100 = 37.97%
Result: CAGR = 37.97%
So your investment grew at an average of 37.97% per year over those 5 years — even if individual years were all over the place.
Here's why CAGR is worth understanding:
For instance, if one fund has a 5-year CAGR of 15% and another has a 3-year CAGR of 12%, you can compare them fairly — even though the periods are different.
CAGR vs Absolute Return
Absolute return is just the raw percentage gain — no time factored in. A 100% return looks the same whether it happened in 1 year or 10 years. CAGR fixes this by expressing it as an annual rate, so the comparison is actually meaningful.
CAGR vs Average Return
The simple average of annual returns looks tidy but can be misleading — it ignores the compounding effect of losses. CAGR uses the geometric mean, which gives you a far more accurate picture of what actually happened to your money.
CAGR vs XIRR
CAGR is built for lumpsum investments — one amount in, one amount out. XIRR handles irregular cash flows, like a SIP where you're putting money in at different dates every month. Use CAGR for lumpsum, XIRR for SIP.
A quick example to show the difference:
Simple Average = (30 - 10 + 20) ÷ 3 = 13.33%
CAGR = [(1.30 × 0.90 × 1.20)^(1/3) − 1] × 100 = 11.59%
CAGR is lower — and more accurate — because it properly accounts for the drag that a 10% loss creates on subsequent gains.
Stocks
Mutual Funds
Real Estate
Business Revenue
"Good" is relative — it depends on the asset and the time period. Here's a rough guide:
Useful benchmarks to keep in mind:
For your investments to actually build wealth, your CAGR should comfortably beat inflation. A 15% CAGR with 6% inflation gives you a real return of 9% — that's where genuine wealth creation happens.
CAGR stands for Compound Annual Growth Rate — it tells you at what annual rate your investment grew, on average. The formula: CAGR = [(Final Value ÷ Initial Value)^(1/Years) − 1] × 100. Quick example: you put in ₹1 lakh and it became ₹2 lakh in 5 years. CAGR = [(2÷1)^(1/5) − 1] × 100 = 14.87%. That means your money grew at a steady 14.87% per year — even if individual years were up 30% or down 5%. The key difference from simple returns is that CAGR accounts for compounding: your gains themselves earn more gains. Use CAGR for lumpsum investments (one entry, one exit). For SIP with multiple investment dates, XIRR is the right tool.
Absolute return tells you the total percentage gain without caring about how long it took: (Final − Initial) ÷ Initial × 100. CAGR is the annualised version — it factors in time. Same numbers, very different story: ₹1 lakh becoming ₹2 lakh is always 100% absolute return. But as a CAGR, it's 100% if it happened in 1 year, 14.87% over 5 years, and just 7.18% over 10 years. This is why "200% returns!" claims need scrutiny. Over 20 years, that's a 5.6% CAGR — pretty underwhelming. Over 2 years, it's 73% — impressive. Time is the context absolute return hides, and CAGR reveals.
Yes, CAGR can be negative — it just means you've been losing money on average each year. Example: ₹10 lakh invested in 2019, worth ₹7 lakh in 2024. CAGR = −8.4% per year. How worried should you be? Short-term negative (under 1 year) in equity is common and usually fine — markets are volatile. Negative over 1–3 years is concerning but potentially explainable if the broader market is down. Negative beyond 3 years is a serious red flag — consider exiting. A negative CAGR in a debt fund is unacceptable, since debt is meant to preserve capital. Always compare against the benchmark: if Nifty fell 5% but your fund fell 15%, that's a fund problem, not a market problem. Don't wait and hope — consistently underperforming investments deserve a clean exit.
CAGR is a powerful tool for working backwards from a financial goal. Say you need ₹50 lakh in 10 years and have ₹10 lakh today. Required CAGR = [(50÷10)^(1/10) − 1] × 100 = 17.5%. Is that achievable? Equity has historically delivered 15–18%, so it's possible — though not guaranteed. You can also use it the other way: have ₹5 lakh now, expecting 14% CAGR over 15 years? Future value = ₹5L × (1.14)^15 = ₹35.8 lakh. If that falls short of your goal, you either invest more now or extend the timeline. Quick shortcut: the Rule of 72. Divide 72 by your CAGR to get the approximate doubling time. At 12% CAGR, your money doubles every 6 years. Track your actual portfolio CAGR annually — if you're falling behind the required rate, adjust early rather than late.
Here's the historical context: Nifty 50 has delivered roughly 14–15% CAGR over the last 5 years (2019–2024), 12–13% over 10 years, and 14–15% over 20 years. Sensex numbers are similar — around 13–14% over 5 years and 12–14% long-term. As a rule of thumb, plan for 12–15% from Indian equity over the long run. Use 13% as your benchmark: if your equity fund is delivering less, it's underperforming the index — and you'd be better off in an index fund. If it's delivering more, you've found a genuinely good fund. One important caveat: the period matters a lot. The decade 2000–2010 was rough — only 3–5% CAGR. 2010–2020 bounced back to 10–12%. 2020–2024 has been strong at 14–16%. Set realistic expectations and don't extrapolate short-term numbers into permanent truths.
There are three easy ways to calculate CAGR in Excel. Method 1 (simplest): use the RRI function — =RRI(years, initial_value, final_value). Example: =RRI(5, 100000, 500000) gives 0.3797; multiply by 100 for 37.97% CAGR. Method 2 (direct formula): =((final_value/initial_value)^(1/years)−1)×100. Same example gives 37.97%. Method 3 (date-based, most precise): calculate years as (End_Date − Start_Date)/365, then plug into Method 2. For a reusable template: put your initial investment in A1, final value in A2, years in A3, and in A4 enter =RRI(A3,A1,A2)×100. Change the three inputs for any new investment. One reminder: for SIP investments with multiple cash flows, use the XIRR function instead — CAGR will give you a misleading answer.
For SIP investments, always use XIRR — never CAGR. Here's why CAGR breaks down for SIP: it assumes a single investment at the start. But in a SIP, each instalment has been in the market for a different length of time. Your January 2020 instalment has had 5 full years to grow; your December 2024 instalment has had barely a month. CAGR can't distinguish between these. Concrete example: monthly ₹10K SIP for 5 years = ₹6 lakh invested, now worth ₹8 lakh. Applying CAGR gives [(8÷6)^(1/5)−1]×100 = 5.9%. The correct XIRR is 9–11%. CAGR dramatically understates the real return. Use CAGR for: lumpsum investments, stocks bought and sold at a single point, property. Use XIRR for: SIP, multiple investments at different dates, portfolios with withdrawals. Your mutual fund statement shows XIRR for this exact reason.
CAGR is the cleanest tool for comparing mutual funds head-to-head. Always look at 3-year and 5-year CAGR at minimum — one-year numbers are too noisy to mean much. Example: Fund A at 14%, Fund B at 11%, Fund C at 16% over 5 years. Fund C wins, but always ask the next question: does it beat its benchmark? A large-cap fund should beat Nifty 50 (roughly 13% CAGR). If it doesn't, an index fund would serve you better at a fraction of the cost. Expense ratio is another lever worth checking: a regular plan with 2% expense effectively reduces your CAGR by 2%, while a direct plan at 0.5% gives you 1.5% more every year. On ₹10 lakh over 20 years, that difference compounds to roughly ₹19 lakh. What to look for: 5-year CAGR above 15% for equity, consistent performance across periods (not just one great year), and outperformance of the benchmark by 1–2%. If a fund has delivered under 8% CAGR for 3+ years, it's time to exit.
The Rule of 72 is a quick mental shortcut: divide 72 by your CAGR to get the approximate number of years it takes for money to double. At 12% CAGR, money doubles every 6 years. At 6%, every 12 years. At 18%, every 4 years. It's more useful than it sounds: say you need ₹50 lakh and have ₹12.5 lakh today. You need it to double twice (₹12.5L → ₹25L → ₹50L). At 12% CAGR, that's 6 years per doubling = 12 years total. Inflation works the same way — at 6% inflation, purchasing power halves every 12 years. So even at 12% CAGR, your money nominally doubles in 6 years, but in real purchasing power terms it only doubles in 12. A 2% CAGR difference matters more than most people realize: 10% doubles in 7.2 years, 12% doubles in 6. Over 30 years, that seemingly small gap translates into a dramatically different wealth outcome.
Five practical ways to improve your portfolio's CAGR: First, exit underperformers without sentiment — any fund delivering under 8% CAGR over 3 years should be replaced with one targeting 12–15%. Review every 6 months. Second, switch from regular to direct plans — same fund, same fund manager, but 1.5% higher CAGR because you're not paying distributor commission. Takes 5 minutes and adds roughly ₹19 lakh over 20 years on a ₹10 lakh investment. Third, increase equity allocation if your age and risk tolerance allow — debt averages 7% CAGR, equity averages 14%. A 70% equity portfolio delivers around 12% CAGR vs 10.5% for a 50-50 split. Fourth, add a small-cap slice (10–15% of portfolio) — small-caps have historically delivered 18–20% CAGR, which nudges overall portfolio CAGR up by 0.5–1%. Fifth, simply hold longer — at 12% CAGR, ₹1 lakh becomes ₹3.1 lakh in 10 years, ₹9.6 lakh in 20 years, ₹29.9 lakh in 30 years. Starting a decade earlier is worth more than any tactical tweak.
