CAGR Calc Excel Formula: Calculate Annual Growth Rate

Formulas & functions · Updated November 21, 2026

If the beginning value is in B2, the ending value is in C2, and the number of years is in D2, calculate CAGR in Excel with =(C2/B2)^(1/D2)-1. For example, growth from $10,000 to $16,000 over five years gives a compound annual growth rate of about 9.86%.

What CAGR means

CAGR stands for compound annual growth rate. It describes the steady annual rate that would take a starting value to an ending value over a specified period, assuming growth compounds from year to year. It is a convenient way to summarize growth across multiple years in one annualized figure.

The word “steady” matters: CAGR is a calculated average, not evidence that the value actually increased by the same percentage every year. A business might have had several strong years and one decline, yet its start and end values still produce a single CAGR. That makes the measure useful for comparing long-term growth, but incomplete as a description of what happened along the way.

You can use CAGR for values such as revenue, customer counts, or an investment’s beginning and ending balance, provided the values and time period are meaningful and positive. CAGR does not account for contributions or withdrawals made during the period. For investment decisions, it is a descriptive calculation rather than financial advice; check actual account terms and consult a qualified professional where appropriate.

The CAGR formula and how it works

The calculation divides the ending value by the beginning value, raises that ratio to the reciprocal of the number of years, and subtracts one. The exponent converts the total growth across the full period into an equivalent annual rate. Subtracting one changes the annual growth factor into a percentage return: a factor of 1.10 means growth of 10% per year.

In the example, $16,000 divided by $10,000 is 1.6. Taking the fifth root of 1.6 gives approximately 1.09856; subtracting one gives 0.09856, or 9.856%. Rounded to two decimal places, the answer is 9.86% per year. As a check, applying that rate for five compounding periods brings $10,000 to approximately $16,000.

The period must match the values. If the start and end figures are five years apart, enter 5—not the number of calendar labels in a report, and not the number of observations if those observations cover a different span. For quarterly or monthly data, either express the elapsed time in years or calculate a period rate and annualize it correctly; do not treat 20 quarters as 20 years.

Enter and format CAGR in Excel

In Microsoft Excel for Microsoft 365 on Windows, put the beginning value in B2, ending value in C2, and elapsed years in D2. With B2 set to 10000, C2 set to 16000, and D2 set to 5, enter the formula from the opening example in another cell. The result is approximately 0.09856 as a decimal, which is the same as 9.856%.

To display it as a percentage, select the result cell and choose Home > Number > Percent Style. Increase or decrease the displayed decimal places as needed. Showing two decimal places gives 9.86%; displaying more places can help when checking calculations, although the underlying stored value is not rounded just because the cell shows fewer digits.

The formula uses ordinary Excel arithmetic operators and works in current desktop Excel, Excel for Mac, and Excel for the web. In some regional settings, Excel expects semicolons rather than commas between function arguments, but this calculation has no function arguments to separate. Make sure the inputs are numeric values rather than text that only looks like a number. Currency symbols applied through cell formatting are fine; typing a symbol into a text value can cause problems.

Use actual dates for uneven time spans

If the elapsed period is not a whole number of years, using an approximate year count can distort the annualized rate. You can calculate the fraction of a year between two dates with Excel’s YEARFRAC function. For example, put the start date in A2, end date in B2, beginning value in C2, and ending value in D2; enter the dates as real Excel dates, not text. With January 1, 2020 and January 1, 2025 as the dates, and values of $10,000 and $16,000, use:

With the start date in A2, end date in B2, beginning value in C2, and ending value in D2, the date-based formula is =(D2/C2)^(1/YEARFRAC(A2,B2,1))-1. In this example the elapsed time is exactly five years, so the result is approximately 9.86%, just like the whole-year calculation.

The final argument, 1, tells YEARFRAC to use its actual/actual day-count basis. Different day-count conventions can produce slightly different fractions for periods that include partial years. Choose a basis that suits the reporting convention you need, and use the same convention when comparing results. For an exact whole-number period, entering that number directly is simpler and avoids introducing a date convention unnecessarily.

Read the result in context

A CAGR of 9.86% means the specified beginning and ending values are equivalent to growing at 9.86% annually with compounding. It does not mean every year’s measured growth was 9.86%, nor does it forecast that future growth will match. If the underlying series fluctuates, examine its annual values as well as the summary rate.

It can also help to distinguish percentage growth from the dollar increase. In the example, the total increase is $6,000, while CAGR describes the annualized pace over five years. Two businesses can have the same CAGR but very different starting sizes and dollar gains. Conversely, a larger dollar increase does not necessarily mean a faster rate of growth.

When comparing organizations, products, or periods, use consistent definitions and comparable time spans. A revenue CAGR based on fiscal-year revenue is not automatically comparable to one based on calendar-year revenue if the periods differ. Confirm that the start and end values use the same currency, measurement method, and scope before interpreting small differences between rates.

Common errors and limitations

  • Using the wrong number of years: Count elapsed time between the observations, rather than simply counting the rows in a table. For example, values recorded at the ends of 2020 and 2025 are five years apart.
  • Reversing the values: The ending value belongs in the numerator and the beginning value in the denominator. Reversing them calculates a different quantity.
  • Omitting parentheses: Keep the ratio grouped before raising it to the reciprocal of the time period. Excel follows operator precedence, so a differently arranged expression may return a different answer.
  • Entering zero or negative endpoint values: The standard CAGR calculation requires a positive beginning value and a positive ending value. A beginning value of zero makes the ratio undefined; negative endpoints do not yield a meaningful conventional growth rate.
  • Confusing a percentage with a decimal: A result of 0.09856 is 9.856%, not 0.09856%. Apply percentage formatting to make the rate easier to read.
  • Ignoring cash flows: If money is added to or withdrawn from an account during the period, the change in its balance is not solely investment growth. An endpoint-only CAGR treats the entire difference as growth and can therefore mislead.

If a business starts with no revenue, a CAGR from that zero base is not defined by this standard formula. Report the absolute change, explain the new revenue level, or choose another measure suited to the situation instead of inserting an arbitrary small starting value. Changing the starting point to avoid the mathematical limitation can make the result appear more meaningful than it is.

CAGR compared with average growth and cash-flow returns

CAGR is not the same as the arithmetic average of yearly percentage changes. Consider a value that rises 50% in one year and falls 50% in the next. The arithmetic average of those yearly changes is 0%, but a starting value of 100 becomes 150 and then 75. Across the two years, the compound annual rate is about −13.4%, because the ending value is 25% below the starting value and compounding is multiplicative.

For a sequence with deposits, withdrawals, or other dated cash flows, an endpoint CAGR cannot separate performance from the timing and size of those flows. Excel’s IRR function is intended for regularly spaced cash flows, while XIRR is designed for cash flows on specific dates. These measures answer a different question from endpoint CAGR and depend on the cash-flow entries and their signs. Use the measure that matches the data rather than treating the names as interchangeable.

For operating metrics with no cash flows, CAGR is often useful for summarizing a multi-year trend. It can be paired with a year-by-year table, a chart, or separate measures of volatility and total change. One figure is easy to compare, but the underlying path provides context that an annualized average leaves out.

Frequently Asked Questions

Can I calculate CAGR in Excel without a special function?
Yes. The standard calculation uses division, an exponent, and subtraction, so it does not require a dedicated CAGR function. Enter the beginning value, ending value, and elapsed years in separate cells, then use the formula shown above.

Should I format the CAGR result as a percentage?
Usually, yes. The formula returns a decimal rate, so percentage formatting makes a result such as 0.09856 display as 9.86%. Formatting changes how the number appears, not the calculated value.

Can CAGR be negative?
Yes. If both endpoint values are positive and the ending value is lower than the beginning value, CAGR is negative. It represents an equivalent annual decline over the period, not an error by itself.

Why does my CAGR formula return an error?
Check that the beginning value and years are greater than zero, the ending value is positive, and all inputs are numeric. Also check that the year count is not blank or zero and that dates, if used, are recognized by Excel as dates.

Does CAGR show what happened each year?
No. It compresses the change between two endpoints into one smoothed annual rate. To see individual gains and losses, inspect the annual data or calculate each year’s change separately.

Can I use CAGR when there were deposits or withdrawals?
You can calculate an endpoint rate, but it may wrongly attribute those cash flows to growth. For dated cash flows, consider a cash-flow return measure such as XIRR and make sure the inputs represent each contribution and withdrawal correctly.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.