CAGR calculator
The compound annual growth rate is the steady yearly rate that takes a start value to an end value over a number of years. Enter years or two dates; you get the CAGR, a year-by-year table and the RRI formula for your numbers.
- Years, fractions of years or two dates
- Year-by-year table that lands on your end value
- Handles a zero end, and refuses a negative start
The CAGR formula
The CAGR formula is (end / start)^(1 / years) - 1, times 100 for a percentage. The calculator's example uses the salary in the US Bureau of Labor Statistics paper Math calculations to better utilize CPI data: 35,000 in 2005 and 45,000 in 2015.
- Divide the end by the start: 45,000 / 35,000 = 1.28571.
- Take the root for the number of years, which is the power 1 / 10: 1.28571 ^ (1 / 10) = 1.02545.
- Subtract 1 and multiply by 100: +2.54% a year.
So a total rise of 28.57% over 10 years is the same as 2.54% a year, compounded. The table under the result shows each year at that rate, and the last row lands exactly on 45,000.
CAGR vs average annual return
Dividing the total change by the number of years gives 2.86% a year, which overstates the growth. Compounding 2.86% for 10 years would turn 35,000 into 46,389, not 45,000. The simple average ignores that each year's growth builds on the last.
The gap is starker when returns swing. An investment that gains 50% one year and loses 50% the next has an arithmetic average return of 0%, yet it ends at 0.75 times where it started, a loss of 25.00%. Its CAGR over the two years is -13.40%. CAGR is the geometric average, and it is the one that reproduces the actual end value.
RRI in Excel and Google Sheets
Both spreadsheets have a function for this, RRI. The arguments are the number of periods, then the start value, then the end value: =RRI(C2,A2,B2) (decimal comma locales: =RRI(C2;A2;B2)). Google's RRI help page gives three examples, which our engine reproduces to the last digit:
| Formula | Result | As a percentage |
|---|---|---|
=RRI(3, 2, 4) | 0.2599210499 | +25.99% |
=RRI(10.5, 10, 3) | -0.1083343751 | -10.83% |
=RRI(1, 10, 0) | -1 | -100.00% |
The second shows that fractional periods are fine and that a fall gives a negative rate. The third shows that an end value of zero gives -100%.
The Microsoft example, and why periods matter
Microsoft's RRI page shows =RRI(96,10000,11000) (decimal comma locales: =RRI(96;10000;11000)) returning 0.0009933, and describes it as an investment over 8 years with a rate of about 1.2%. Both can be true only if the 96 periods are months. RRI returns a rate per period: 0.0009933 is 0.0993% a month. Over 8 years, the yearly rate is 1.1985%, which rounds to Microsoft's 1.2%.
Give RRI the number of years for a yearly rate. Give it months and you get a monthly rate, which is not the CAGR.
Dates, fractions of a year and short periods
Switch the calculator to "Two dates" and it counts the exact days between them and divides by 365.25, the average length of a year including leap years. The working shows the day count, so you can check it.
For less than one year, a yearly rate assumes the same pace continues for twelve months, which can produce extreme figures from small moves. For monthly or quarterly data, the annualized change calculator follows the method statistics agencies use and warns about short periods.
When CAGR is not defined
- A start of zero: no rate can grow nothing into something. Report the end value or the absolute change.
- A negative start or end, such as a loss turning into a profit: there is no real-valued growth rate. Google's help page for RRI says the number of periods and the present value must be greater than zero.
- An end of zero: the rate is -100%, whatever the number of years.
The guide to negative numbers and zero suggests what to report instead.
Questions people ask
What is a good CAGR?
It depends on what is growing and over what period. Compare a CAGR only with rates for similar things over the same years, and remember that it hides the ups and downs along the way.
Is CAGR the same as average annual growth?
Not when "average" means the arithmetic mean. CAGR is the geometric mean, the steady rate that reaches the same end value.