Why CAGR Is the Only Growth Rate That Actually Tells You the Truth
If you've searched "CAGR calculator," "how to calculate compound annual growth rate," "what is CAGR," or "CAGR formula with example," you're probably trying to cut through misleading growth numbers. A company might say its revenue "grew 300% over five years" — which sounds dramatic — but that tells you nothing about the year-on-year pace of that growth, whether it was steady or lumpy, or how it compares to another investment that grew 250% over three years.
CAGR — Compound Annual Growth Rate — solves exactly this problem. It gives you a single, clean annual growth rate that represents the smoothed rate at which a value would have had to grow every year to get from its starting point to its ending point over a given number of years. It is the standard metric used by investors, analysts, and CFOs to compare growth across different time periods and different assets on equal footing.
This guide explains what CAGR is, how the formula works, walks through real calculation examples, covers common mistakes, and shows you how to calculate CAGR in seconds using our free tool.
What Is CAGR? (Plain Language Definition)
CAGR is the rate at which an investment or metric would have grown each year — compounded — if it had grown at a perfectly steady pace from start to finish. It does not mean the value actually grew at that rate every single year. In reality, growth is lumpy: some years up 40%, some years down 10%. CAGR smooths all of that out into one representative annual figure.
Think of it this way: if you invested ₹1,00,000 in 2019 and it became ₹2,00,000 by 2024 — a clean doubling in 5 years — the CAGR tells you the equivalent steady annual growth rate that would produce that same result. That number is 14.87% per year, compounded. Whether your portfolio actually hit exactly 14.87% each year is irrelevant — CAGR gives you a single number to compare against another investment, a benchmark index, or an industry average.
The CAGR Formula
The formula for CAGR is:
CAGR = (Ending Value / Beginning Value) ^ (1 / Number of Years) − 1
Where:
- Ending Value = the final value at the end of the period
- Beginning Value = the starting value at the beginning of the period
- Number of Years = the total number of years in the period
- ^ (1 / n) = the nth root of the ratio (this is what makes it "compound")
The result is a decimal — multiply by 100 to express it as a percentage.
CAGR Calculation: Step-by-Step Worked Examples
Example 1: Investment Growth
You invested ₹50,000 in a mutual fund in 2020. By 2025, it is worth ₹90,000. What is the CAGR over 5 years?
CAGR = (90,000 / 50,000) ^ (1/5) − 1
= (1.8) ^ (0.2) − 1
= 1.1247 − 1
= 0.1247 = 12.47% per year
That means your investment grew at an equivalent rate of 12.47% compounded annually over those five years.
Example 2: Business Revenue Growth
A startup had revenue of ₹20 lakh in FY2021 and ₹75 lakh in FY2024. What is the CAGR over 3 years?
CAGR = (75 / 20) ^ (1/3) − 1
= (3.75) ^ (0.333) − 1
= 1.5548 − 1
= 0.5548 = 55.48% per year
This is useful when pitching to investors or comparing against industry benchmarks — a single number that describes three years of growth cleanly.
Example 3: SIP / Portfolio Comparison
Fund A grew from ₹1,00,000 to ₹1,95,000 in 6 years. Fund B grew from ₹1,00,000 to ₹1,80,000 in 4 years. Which performed better annually?
Fund A CAGR = (1,95,000 / 1,00,000) ^ (1/6) − 1 = (1.95) ^ (0.1667) − 1 = 11.76%
Fund B CAGR = (1,80,000 / 1,00,000) ^ (1/4) − 1 = (1.80) ^ (0.25) − 1 = 15.83%
Fund B delivered better annual growth despite the lower absolute gain — because it achieved it in less time. Without CAGR, this comparison is impossible to make fairly.
How to Calculate CAGR in Seconds — Using Our Free CAGR Calculator
Manual CAGR calculation requires computing an nth root, which is cumbersome without a scientific calculator or spreadsheet. Our free CAGR Calculator handles it instantly:
- Enter your beginning value (starting investment, revenue, or any metric)
- Enter your ending value (final value at the end of the period)
- Enter the number of years (or select start and end years)
- Get your CAGR percentage instantly — along with a year-by-year growth projection showing what the value looks like at the calculated rate each year
No sign-up, no spreadsheet, no formula memorization. The calculation runs entirely in your browser.
CAGR vs Absolute Return vs Average Annual Return: What Is the Difference?
These three metrics are frequently confused — and using the wrong one leads to very different (and often misleading) conclusions:
- Absolute Return is simply the total percentage gain from start to finish, with no regard for time. A 100% return sounds great — but not if it took 20 years.
- Average Annual Return (Simple Average) adds up yearly returns and divides by the number of years. This overstates performance when returns are volatile because it ignores the compounding effect of losses. A year with +50% followed by a year with −50% gives a simple average of 0% — but the actual value is down 25%.
- CAGR (Compound Annual Growth Rate) only looks at the starting value, the ending value, and the number of years in between. It correctly accounts for compounding and gives the true equivalent annual growth rate regardless of year-to-year volatility.
For investment analysis, CAGR is always the more honest and comparable metric. Simple average annual return almost always flatters performance relative to what CAGR shows.
Where CAGR Is Used in the Real World
- Mutual fund and stock performance: Every fund fact sheet and performance comparison uses CAGR over 1-year, 3-year, 5-year, and 10-year periods as the standard benchmark.
- Startup pitch decks: Revenue CAGR over the last 2–3 years is one of the first numbers investors look for — it summarises growth trajectory in a single defensible figure.
- Market size projections: Industry reports state market growth as CAGR — "the EV market is projected to grow at a CAGR of 26% through 2030" means the market is expected to compound at 26% per year from the base year to 2030.
- Personal finance and goal planning: If you want your savings to grow from ₹10 lakh to ₹50 lakh in 10 years, CAGR tells you you need approximately 17.46% annual growth — letting you assess whether that target is realistic for your chosen instruments.
- SIP return comparison: Comparing two SIPs or two time periods of the same fund is only meaningful when done on a CAGR basis, not absolute returns.
CAGR Limitations: What It Does Not Tell You
CAGR is a powerful metric, but it has real blind spots that every user should understand:
- It hides volatility. Two investments with identical CAGR can have wildly different risk profiles — one could be a straight line, the other a rollercoaster that happened to start and end at the same points. CAGR tells you nothing about the journey, only the destination.
- It is sensitive to the start and end points chosen. A bad starting year (market crash) or a good ending year (market peak) can make CAGR look artificially high. Always check the time period being used before comparing CAGRs from different sources.
- It does not account for cash flows. If you are adding money to an investment over time (like a SIP), CAGR on the total portfolio value is not the right measure. Use XIRR (Extended Internal Rate of Return) instead, which accounts for the timing and size of each cash flow.
- It assumes continuous compounding from one point to another. It says nothing about what happened in between — a company could have gone bankrupt and recovered, and CAGR would still show a positive number if the ending value is higher than the starting value.
CAGR Formula in Excel and Google Sheets
If you prefer to calculate CAGR inside a spreadsheet, here is the exact formula syntax:
Excel / Google Sheets:
=(ending_value/beginning_value)^(1/number_of_years)-1
Format the result cell as a percentage. Example with cell references:
=(B2/B1)^(1/B3)-1 where B1 = beginning value, B2 = ending value, B3 = number of years.
There is no dedicated CAGR function in Excel or Google Sheets — the formula above is the standard approach used by financial analysts.
Frequently Asked Questions
What is a good CAGR for an investment?
It depends on the asset class and time period. As a rough benchmark: Indian equity mutual funds have historically delivered 12–15% CAGR over long periods. Fixed deposits deliver 6–7%. A CAGR above 15% over 5+ years for an equity investment is generally considered strong. For a startup's revenue, investors typically look for 30–50%+ CAGR in early stages.
Can CAGR be negative?
Yes. If the ending value is lower than the beginning value, CAGR will be negative — indicating the investment or metric declined at that annualised rate over the period.
What is the difference between CAGR and IRR?
CAGR measures growth between two fixed points with no intermediate cash flows. IRR (Internal Rate of Return) accounts for multiple cash flows at different points in time — making it the right metric for SIPs, business projects, or any scenario where money is added or withdrawn during the period. For a lump-sum investment with no additions or withdrawals, CAGR and IRR give the same result.
How is CAGR different from XIRR?
XIRR is the Excel function that calculates IRR when cash flows occur at irregular intervals — which is exactly the case for SIPs where monthly contributions happen on different dates. Use XIRR for SIP return calculations, CAGR for lump-sum investment or revenue growth comparisons.
Can I calculate CAGR for less than one year?
Technically yes — enter a decimal for the number of years (e.g., 0.5 for six months). However, annualising returns over very short periods can be misleading since it amplifies short-term volatility into a number that implies long-term performance.
Conclusion
CAGR is the most honest, most comparable, and most widely used measure of growth in finance and business — because it accounts for compounding and strips out the noise of year-to-year fluctuations. Whether you are evaluating a mutual fund, measuring your startup's revenue growth, or comparing two investment options over different time periods, CAGR gives you the one number that makes those comparisons fair and meaningful. Use our free CAGR Calculator to get your compound annual growth rate instantly — just enter your starting value, ending value, and number of years.