Key Takeaways
- CAGR smooths the path: It converts uneven multi-year growth into one equivalent annual compound rate.
- The formula needs three inputs: Beginning value, ending value, and the number of years.
- Simple averages are different: CAGR is a geometric growth rate tied to the start and end values.
- Volatility is hidden: Two investments can have the same CAGR and very different year-to-year risk.
- Cash flows can make CAGR misleading: IRR or XIRR is usually more appropriate when money is added or withdrawn during the measurement period.
How CAGR Works
CAGR answers a hypothetical question: what steady annual compound rate would produce the same ending value as the actual multi-year result?
The real path does not have to be steady. An investment could rise 25% one year, fall 15% the next, and recover later. By ignoring those swings, CAGR reports the single annual rate that connects the starting and ending values.
That makes CAGR useful for comparing long-term growth in investments, revenue, users, sales, or other quantities that change over time. It is closely related to compound interest.
CAGR Formula
Beginning and ending values must use the same units. The time period should be expressed consistently in years; a 3.5-year period can use 3.5 as the exponent denominator.
Example: An investment grows from $10,000 to $16,000 in five years.
CAGR = (16,000 / 10,000)1/5 – 1 = about 9.86%.
That constant 9.86% annual compound rate would therefore reproduce the same start-to-finish growth.
Why CAGR Is Different From a Simple Average
A simple arithmetic average adds annual percentage changes and divides by the number of periods. That can be useful for some statistical purposes, but it does not necessarily reproduce the growth of money over time.
Example: An investment rises 50% in year one and falls 50% in year two. The arithmetic average return is 0%, but $100 becomes $150 and then $75. Over the two years, CAGR is about -13.4%, which reflects the actual ending value.
Compounding is why the geometric approach matters. Losses and gains apply to changing balances, not to the original amount every year.
When CAGR Is Useful
Use CAGR when you want a clean start-to-finish comparison and there are no material cash flows in or out during the period.
- Multi-year investment growth
- Company revenue or earnings growth
- Customer or user growth across periods
- Long-term growth for planning or reporting
Using the same time horizon is important. A three-year CAGR and a ten-year CAGR can reflect very different business cycles or market environments.
What CAGR Does Not Show
CAGR tells you nothing about the sequence of returns between the first and last value. It does not reveal volatility, drawdowns, or how difficult the path was for an investor to tolerate.
Two portfolios can finish with identical CAGRs while one experiences much larger losses along the way. Pairing CAGR with a risk measure such as standard deviation can provide more context.
CAGR vs. IRR and XIRR
| Metric | Best use | Main limitation |
|---|---|---|
| CAGR | Start-to-finish growth with no material interim cash flows | Ignores cash-flow timing and volatility |
| IRR | Series of cash flows occurring at regular intervals | Can produce difficult or multiple results for unusual cash-flow patterns |
| XIRR | Cash flows occurring on specific, irregular dates | Requires dated cash-flow data |
If you contribute to an investment account, withdraw money, or receive distributions during the measurement period, start-to-finish CAGR can confuse investment performance with the effect of those cash flows. IRR or XIRR is usually better suited to that problem.
How to Calculate CAGR in Excel
Excel’s RRI function returns an equivalent interest rate for growth from a present value to a future value over a specified number of periods:
=RRI(nper, pv, fv)For the $10,000-to-$16,000 example over five years, =RRI(5,10000,16000) returns approximately 9.86%.
The explicit formula also works in a spreadsheet:
=POWER(ending_value/beginning_value,1/years)-1Use IRR for cash flows at regular intervals and XIRR when the dates are irregular.
CAGR Edge Cases
- One year: CAGR equals the one-year percentage change.
- Ending value below beginning value: CAGR is negative.
- Beginning value of zero: CAGR is undefined because the formula requires division by the beginning value.
- Negative beginning or ending values: Standard CAGR may not produce a meaningful real-number result and usually is not the right metric.
For business metrics that cross zero, absolute changes, margins, or another measure may communicate the trend more clearly than forcing a CAGR calculation.
Frequently Asked Questions (FAQs)
Is CAGR the same as an average annual return?
Not usually. CAGR is the geometric annual rate that connects the beginning and ending values. Simple arithmetic averages of yearly returns can produce a different number.
Does CAGR include volatility?
No. It smooths the entire period into one annualized rate and hides the size and timing of gains and losses between the endpoints.
When should I use XIRR instead of CAGR?
Use XIRR when cash moves into or out of the investment on specific, irregular dates. A start-to-finish CAGR assumes a simple beginning and ending value without accounting for those dated flows.
Can CAGR be used for revenue?
Yes. Any positive metric that grows from a beginning value to an ending value over multiple years can be summarized with CAGR when the start-to-finish framework is appropriate.