Growth over time

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

Examples and sources checked on November 21, 2026.

Time
CAGR (per year)+2.54%Increase

Growing from 35,000 to 45,000 over 10 years is a total change of +28.57%, the same as a steady +2.54% a year, compounded.

Total change+28.57%
Simple average a year (not compounded)+2.86%
Multiplierx1.28571

Year by year at +2.54%

YearValueChange from start
Year 035,000.000.00%
Year 135,890.75+2.54%
Year 236,804.16+5.15%
Year 337,740.82+7.83%
Year 438,701.32+10.58%
Year 539,686.27+13.39%
Year 640,696.28+16.28%
Year 741,732.00+19.23%
Year 842,794.07+22.27%
Year 943,883.18+25.38%
Year 1045,000.00+28.57%

Working

  1. Ratio: 45,000 / 35,000 = 1.285714
  2. Root for the years: 1.285714 ^ (1 / 10) = 1.02545
  3. Minus 1, times 100: (1.02545 - 1) x 100 = +2.54%

Spreadsheet formula Excel and Google Sheets

Put 35,000 in A2, 45,000 in B2 and 10 (years) in C2.

RRI function=RRI(C2,A2,B2)
Same, written out=(B2/A2)^(1/C2)-1
With your numbers=RRI(10,35000,45000)

Decimal comma form (semicolons): =RRI(10;35000;45000)

RRI takes the number of periods first. Give it years for a yearly rate; give it months and you get a monthly rate.

Reverse check

35,000 x 1.02545 ^ 10 = 45,000, the end value.

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.

  1. Divide the end by the start: 45,000 / 35,000 = 1.28571.
  2. Take the root for the number of years, which is the power 1 / 10: 1.28571 ^ (1 / 10) = 1.02545.
  3. 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:

FormulaResultAs 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.