Maaz Zindani

Loading the index…

↑↓ move↵ openesc close3993 pages

Free tool · Finance calculators

CAGR calculator

Enter a start value, an end value and the time between them to get the steady yearly rate that links the two. You can also start from a rate to find the end value, or the number of years a value needs to reach a goal.

  • Free
  • No sign-up
  • Runs in your browser

By Maaz Zindani · Updated

What do you want to find?
An investment, a revenue figure, a number of users: any amount that grows or falls.
Time
Decimals are fine: 2.5 is two and a half years.
Compound annual growth rate

20.11% a yearfrom $10,000.00 to $25,000.00 in 5 years

  • Total growth 150.00%
  • Value × 2.5
  • 5 years
Start value
$10,000.00
End value
$25,000.00
Time
5 years
Total growth
150.00%
Total growth ÷ years
30.00%
CAGR
20.11%

Formula: CAGR = (end value ÷ start value)1 ÷ years − 1. In a spreadsheet: =(B2/B1)^(1/years)-1.

Your numbers: (25,000.00 ÷ 10,000.00)1 ÷ 5 − 1 = 2.50.2 − 1 = 1.20112 − 1 = 20.11%. The total growth of 150.00% spread evenly over 5 years would be 30.00% a year, but that ignores compounding; CAGR is the rate that compounds to the same end value.

The smooth path this rate implies, year by year
YearValueChange
0$10,000.00
1$12,011.24$2,011.24
2$14,427.00$2,415.75
3$17,328.62$2,901.62
4$20,813.83$3,485.21
5$25,000.00$4,186.17

CAGR smooths the ups and downs into one steady yearly rate: it describes the past, it is not a forecast, and it says nothing about the path in between. An estimate from the figures you typed, not financial advice.

How to use the CAGR Calculator

  1. Choose what to find under What do you want to find?: CAGR, the end value or the years needed.
  2. Type the Start value and the End value, or the Growth rate % a year for the two reverse modes.
  3. Give the Time as a Number of years or pick Two dates and choose the start and end dates.
  4. Read the answer, the formula with your numbers and the year-by-year table of the smooth path the rate implies.

What is the CAGR formula?

CAGR stands for compound annual growth rate: the single yearly rate that would take a start value to an end value if it grew by the same percentage every year. The formula is CAGR = (end value ÷ start value)1 ÷ years − 1. Divide the end by the start to get the growth multiple, raise it to the power of one over the number of years to get the yearly multiple, and subtract 1 to turn it into a rate.

For a start value of 10,000, an end value of 25,000 and 5 years, the multiple is 25,000 ÷ 10,000 = 2.5. The yearly multiple is 2.50.2 = 1.2011, so the CAGR is 20.11% a year. The total growth is 150%, and a simple split of 150% over 5 years would give 30% a year. That is more than the CAGR because growth compounds: each year grows from a bigger base. A value that falls gives a negative CAGR, and a value that drops to zero gives −100%. In a spreadsheet you can type =(B2/B1)^(1/years)-1, with the end value in B2, the start value in B1 and the number of years in place of "years".

How do I calculate CAGR with dates instead of years?

Choose Two dates under Time and pick the start and end dates. The calculator counts the whole days between them and divides by 365.25, the average length of a calendar year once leap years are included. From 1 January 2020 to 1 January 2025 that is 1,827 days, or 5.0021 years, so the same 10,000 to 25,000 gives 20.10% instead of 20.11%. Dividing by 365 would give a slightly different answer, which is why the day count is stated on the page.

Dates matter when the period is not a round number of years, such as a fund opened in March and valued in October three years later. If you only know the years as a rounded figure, type them in the years box; decimals such as 2.5 are accepted. Either way the answer is only as precise as the start and end values you supply.

How is CAGR different from average annual return?

An average annual return adds up the yearly returns and divides by the number of years, so it ignores the order in which they come. CAGR looks only at where you started and where you ended. Suppose 100 grows by 50% in year one to 150 and then falls by 50% in year two to 75. The average of +50% and −50% is 0%, yet you lost a quarter of your money. The CAGR is (75 ÷ 100)1 ÷ 2 − 1 = −13.40% a year, which is the rate that actually links 100 to 75 in two years.

That is why CAGR is useful for comparing two investments, a company's revenue or a number of users over different periods. It is also why it can mislead: it hides how bumpy the ride was, and it says nothing about the future. There is no universal "good" CAGR. Whether 8% or 20% is good depends on what you need, what else you could have done with the money, and the inflation over the same period. The table under the result shows the smooth path that your CAGR implies, which is not the path anything actually followed.

How do I find the end value or the years needed from a CAGR?

Switch to End value to run the formula forwards: end value = start value × (1 + CAGR)years. With 10,000 at 8% a year for 5 years, 1.085 = 1.4693, so the end value is 14,693.28. Switch to Years needed to solve for the time: years = ln(end ÷ start) ÷ ln(1 + CAGR). Growing 10,000 to 25,000 at 8% takes ln(2.5) ÷ ln(1.08) = 11.91 years, about 11 years and 11 months.

The calculator will tell you when no answer exists. A rate of 0 never changes the value, and a positive rate can never bring the value down to a smaller end value, so those inputs give a message instead of a number. The result assumes the rate stays the same every year, which real returns do not. Treat it as an illustration, not a forecast and not financial advice.

Use it with

Questions

What is the CAGR formula?

CAGR = (end value ÷ start value)^(1 ÷ years) − 1. For 10,000 growing to 25,000 in 5 years it is 2.5^0.2 − 1 = 20.11% a year.

How do I calculate CAGR in Excel?

Type =(end/start)^(1/years)-1, for example =(B2/B1)^(1/5)-1 with the start value in B1 and the end value in B2, and format the cell as a percentage.

How do I calculate CAGR with dates?

Count the days between the two dates, divide by 365.25 to get years, and use that in the formula. From 1 January 2020 to 1 January 2025 is 1,827 days, or 5.0021 years.

How is CAGR different from the average annual return?

The average adds the yearly returns and divides by the years; CAGR links only the start and end values. A year of +50% followed by a year of −50% averages 0% but has a CAGR of −13.40%, because 100 ends at 75.

What is a good CAGR?

There is no single answer. It depends on your goal, the alternatives you had and the inflation over the period. CAGR describes the past and is not a forecast.

How many years will it take to reach a goal at a given CAGR?

Years = ln(end ÷ start) ÷ ln(1 + CAGR). To grow 10,000 to 25,000 at 8% a year takes about 11.91 years.

How this page was made: the tool's results are computed in your browser by the code on this page; the explanations were drafted with AI help and checked against the tool's own output.