CAGR Calculator for Excel

Find the compound annual growth rate (CAGR) from a start value, an end value and the number of years. The tool also gives you the Excel formula to copy.

Use 1.5 for 18 months.

Excel formula with cell references (start in B1, end in B2, years in B3)

Excel formula with your numbers

This calculator runs in your browser. Nothing you type is sent anywhere. CAGR needs a start value and an end value above zero.

How to use this CAGR calculator

  1. Type the start value.
  2. Type the end value.
  3. Type the number of years. Or tick “Use dates instead of years” and pick two dates.
  4. Click Calculate.
  5. Copy the Excel formula and paste it into your sheet.

Click Load example to see the numbers from our guide: start 10,000, end 16,000 and 5 years. The result is 9.86%.

What the calculator shows

  • CAGR: the steady yearly growth rate.
  • Total growth: the full change from start to end, as a percent.
  • Growth multiple: the end value divided by the start value.
  • Monthly growth rate: the same CAGR, shown for one month.
  • Year by year table: the value each year at a steady rate.

The math behind the tool

CAGR = (End value / Start value)^(1 / Years) – 1

In Excel, type =(B2/B1)^(1/B3)-1 with the start value in B1, the end value in B2 and the years in B3. In Excel 2016 and later you can also type =RRI(B3,B1,B2). For steps, screenshots and more methods, read the full guide: CAGR formula in Excel.

Forecast a value and find the years

Forecast a value. Pick the Forecast a value tab. Enter a start value, a CAGR percent and the years. The tool gives the end value.

Find the years. Pick the Find the years tab. Enter a start value, an end value and a CAGR percent. The tool gives how long it takes.

Limits of CAGR

CAGR uses only the first and last values. It hides ups and downs in between. It is not a forecast, and a past rate may not repeat. Compare CAGRs only over the same time span.

Questions

Does this calculator save my numbers?

No. It runs in your browser. Nothing you type is sent anywhere.

Why does it need values above zero?

A start value of zero cannot be divided. A start and end value with opposite signs give an error in Excel. Use the total change instead in those cases.

Does the formula work in Google Sheets?

The caret formula =(B2/B1)^(1/B3)-1 works the same way in Google Sheets.

More free Excel tools