Business and finance

CAGR Calculator (Compound Annual Growth Rate)

The compound annual growth rate (CAGR) is the constant yearly rate that takes a starting value to an ending value. Going from 50,000 to 80,000 in 5 years is 60% total growth but a CAGR of 9.86%.

Compound annual growth rate between two values.

Compound annual growth

≈ 9.86%

Total growth
60%

Formula

CAGR = (Ending value ÷ Starting value)^(1 ÷ years) − 1

Step by step

  1. Ratio: 80,000 ÷ 50,000 = 1.6
  2. Take the 5th root: 1.6^(1/5) = 1.098561
  3. Subtract 1 and multiply by 100: (1.098561 − 1) × 100 = 9.86%
50,000 → 54,928.03 → 60,341.76 → 66,289.08 → 72,822.57 → 80,00050,000Start54,928.03Step 160,341.76Step 266,289.08Step 372,822.57Step 480,000Step 5
Visual representation

Formula

CAGR = (Ending value ÷ Starting value)^(1 ÷ years) − 1

It is the geometric mean of the yearly growth rates. Dividing total growth by the years (60% ÷ 5 = 12%) overstates the pace because it ignores that each year grows from a larger base.

The chart shows the theoretical path at a constant rate. Real yearly values may have varied a lot; CAGR summarizes the result, not the journey.

How to use this calculator

  1. Enter the starting and ending values.
  2. Enter the number of years (decimals such as 2.5 are fine).
  3. Read the yearly rate and the total growth.

Worked examples

Revenue grows from $50,000 to $80,000 in 5 years.

Solution: Compound annual growth: 9.86%

  1. Ratio: 80,000 ÷ 50,000 = 1.6
  2. Take the 5th root: 1.6^(1/5) = 1.098561
  3. Subtract 1 and multiply by 100: (1.098561 − 1) × 100 = 9.86%

A town grows from 12,400 to 15,100 people in 10 years.

Solution: Compound annual growth: 1.99%

  1. Ratio: 15,100 ÷ 12,400 = 1.217742
  2. Take the 10th root: 1.217742^(1/10) = 1.019895
  3. Subtract 1 and multiply by 100: (1.019895 − 1) × 100 = 1.99%

A portfolio goes from $10,000 to $9,200 in 2 years.

Solution: Compound annual growth: -4.08%

  1. Ratio: 9,200 ÷ 10,000 = 0.92
  2. Take the 2th root: 0.92^(1/2) = 0.959166
  3. Subtract 1 and multiply by 100: (0.959166 − 1) × 100 = -4.08%

Common mistakes

  • Using the arithmetic mean

    +50% then −50% averages 0%, but the value fell 25%. CAGR captures that.

  • Miscounting the years

    From 2020 to 2025 there are 5 years of growth, not 6.

  • Using negative values

    CAGR is undefined if either value is negative or the start is 0.

When to use it

  • Business

    Medium-term growth in revenue, customers or profit.

  • Investing

    Average yearly return of a fund or a home.

  • Economics

    Growth of population, GDP or prices.

Frequently asked questions

What does CAGR stand for?

Compound Annual Growth Rate.

How do I calculate CAGR in Excel?

Use =(B2/A2)^(1/C2)-1, with A2 the start, B2 the end and C2 the years. Excel also has the RRI function.

How is CAGR different from ROI?

ROI is the total return; CAGR spreads it into a comparable yearly rate. The ROI calculator shows both.

Methodology

Standard geometric mean. Requires positive values and years above 0. For fractional periods the chart adds the ending value as the last point.

Calculation Methodology — Percentage Calculator

References