CAGR Calculation Formula in Excel: Examples and Tips

Formulas & functions · Updated November 21, 2026

In Excel, calculate CAGR by dividing the ending value by the beginning value, raising that ratio to the power of one divided by the number of years, then subtracting one. With the beginning value in A2, ending value in B2, and years in C2, enter =(B2/A2)^(1/C2)-1 and format the result as a percentage.

What CAGR measures

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 if growth compounded at the same rate each year. It is a useful way to summarize growth across periods of different lengths: a five-year change and a ten-year change can be expressed as annualized rates and compared more easily than their total percentage changes alone.

The word compound matters. Growth in one year applies to the value at the end of the previous year, rather than being calculated only on the original starting amount. CAGR is therefore a geometric annualized rate, not simply the total percentage increase divided by the number of years. It is a summary of two endpoints and a time span, not a claim that growth actually followed a smooth path.

People use CAGR to describe changes in business revenue, customer counts, sales, or other measures. It can also summarize the change in an account balance or asset value, but an endpoint-only calculation may exclude contributions, withdrawals, dividends, fees, or other cash flows. For financial decisions, treat a CAGR figure as a description of the inputs used, not a forecast or recommendation.

The basic Excel formula and cell layout

Put the beginning value in A2, ending value in B2, and elapsed years in C2. In D2, enter =(B2/A2)^(1/C2)-1. Excel evaluates the ratio first, applies the fractional exponent, and subtracts one to convert the cumulative growth factor into a rate. The dollar sign is not required in the formula; the cell values can be currency, units, or another consistent measure.

For example, if A2 is 10000, B2 is 16105.1, and C2 is 5, the result is 0.10, or 10% per year. The check is that multiplying 10,000 by 1.10 for five successive years gives 16,105.10. To display the result as a percentage, select D2 and choose Home > Number > Percent Style. Adjust the displayed decimal places with the increase or decrease decimal controls if needed; changing the display does not change the underlying result.

The Excel POWER function gives the same calculation. With the beginning value in A2, ending value in B2, and years in C2, enter =POWER(B2/A2,1/C2)-1. Some people find this version easier to read, while others prefer the caret exponent operator. Both are valid in Microsoft 365 for Windows.

Work through a practical example

Suppose a company’s annual revenue was 250,000 at the start of a period and 340,000 five years later. With the starting revenue in A2, ending revenue in B2, and elapsed years in C2, enter =(B2/A2)^(1/C2)-1. The ratio is 1.36, and its fifth root minus one is about 0.0636. The CAGR is therefore approximately 6.36% per year. The total increase is 36%, but dividing 36% by five would give 7.2%, which is not the compound annual rate.

The same formula can show a decline. With a starting value of 100 in D2, an ending value of 80 in E2, and two years in F2, enter =(E2/D2)^(1/F2)-1. Excel returns approximately -10.56% per year. That is the constant annual rate that would take 100 to 80 over two years. A negative CAGR is not an error when both endpoint values are positive; it indicates an overall decrease.

Keep the units consistent. If the beginning value is in dollars and the ending value is in thousands of dollars, convert one so both values use the same scale. A common multiplier applied to both endpoints cancels in the ratio, but mixed units do not. Also check that the period entered is the elapsed time between the observations, not the number of rows in a table.

Calculate CAGR from dates instead of typing years

When the start and end dates are known, Excel can calculate the elapsed fraction of a year. Put the beginning value in A2, ending value in B2, start date in C2, and end date in D2. With actual Excel dates in C2 and D2, enter =(B2/A2)^(1/YEARFRAC(C2,D2,1))-1. The final argument selects the actual/actual day-count basis. This is useful for periods that are not exactly a whole number of years and for dates that cross leap years.

YEARFRAC uses the dates to return a fraction of a year, so confirm that the date cells contain valid dates rather than text that merely looks like a date. The end date must be later than the start date. Date conventions can differ between financial contexts, so if a contract or reporting standard specifies a day-count basis, use that convention rather than assuming actual/actual is appropriate. For a period that is exactly five years, a manually entered 5 is also straightforward.

For yearly observations, count the intervals between them. Data labeled 2019, 2020, 2021, 2022, 2023, and 2024 contains six observations but only five elapsed years from the first date to the last. Using six as the duration would understate the annualized growth rate. If the observations are irregularly spaced, use their actual dates or carefully calculate the elapsed time rather than treating every row as one year.

Using monthly or quarterly observations

CAGR is annualized, so the duration must be expressed in years. If a dataset records the exact number of months between the endpoints, that duration can be converted into years inside the exponent. With the beginning value in A2, ending value in B2, and elapsed months in C2, enter =(B2/A2)^(12/C2)-1. For example, 36 months represents three years. Do not enter the number of monthly observations automatically: 36 monthly observations may span 35 intervals from the first observation to the last, depending on how the dates are defined.

For quarterly data, use the elapsed number of quarters divided by four as the year duration, or use actual start and end dates with YEARFRAC. A quarter-by-quarter growth rate is not the same as CAGR: CAGR expresses the whole-period change as an annual rate. If the business question instead asks for average quarter-over-quarter growth, calculate that separately and label it clearly. Matching the calculation to the reporting question prevents a correct formula from producing a misleadingly labeled result.

How to interpret the result—and what it leaves out

A CAGR of 10% means the starting value would reach the ending value if it grew at a constant compounded rate of 10% each year for the stated duration. It does not mean every observed year grew by 10%. A series might rise sharply, fall, and then recover while producing the same CAGR as a smooth series. Always review annual or quarterly figures when the path matters, such as when assessing volatility, a sudden disruption, or the timing of a change.

CAGR also uses only the beginning value, ending value, and elapsed time. It does not measure the variability between them, and it can hide a temporary peak or trough. For investment performance, a simple endpoint CAGR based on account values can be misleading if money was added or withdrawn during the period. Dividends and distributions matter too: comparing ending share prices alone does not include them. The calculation should match the specific performance measure being reported, and investment, tax, or other financial questions should be checked with a qualified professional.

For businesses, define the metric consistently across both endpoints. Revenue that changes because of acquisitions, divestitures, reclassification, or a change in accounting presentation may not be comparable without context. A mathematically accurate CAGR does not explain why growth occurred or whether it is likely to continue. Pair the summary rate with the underlying values and relevant business context.

Common formula errors and useful checks

  • Using the wrong duration: Count elapsed years or intervals, not observations. A start in 2020 and an end in 2025 span five years.
  • Reversing the endpoints: The ending value belongs in the numerator and the beginning value in the denominator. Reversing them calculates a different rate.
  • Entering zero or negative endpoints: The usual CAGR calculation requires positive beginning and ending values. A zero beginning value causes division by zero; negative values can make a fractional power undefined in real-number arithmetic. Choose a measure designed for the data instead of forcing the formula.
  • Entering zero years: The exponent divides by the duration, so the elapsed time must be greater than zero. Check that dates are in chronological order.
  • Confusing a decimal with a percentage: Excel stores 10% as 0.10. Format the result cell as a percentage; do not multiply by 100 and then also apply percentage formatting.
  • Mixing text and numbers: A value that looks numeric but is stored as text may cause unexpected results. Check the source cells, decimal separators, and date entries if Excel returns an error.

After calculating, verify the result in two ways: make sure its direction matches the endpoint change, and use the rate to reconstruct the ending value mentally or in a separate check. A positive rate should correspond to an ending value above the beginning value; a negative rate should correspond to a lower positive ending value. If the result seems implausibly large, inspect the scale, dates, and duration before concluding that the data itself is unusual.

CAGR compared with average growth

Arithmetic average growth and CAGR answer different questions. The arithmetic average takes the ordinary mean of period-by-period percentage changes. CAGR finds the single compounded rate connecting the beginning and ending values. When growth rates vary, the arithmetic average is often higher than the compounded rate because losses and gains compound asymmetrically. For example, a 50% rise followed by a 50% fall does not return a value to its starting point: 100 rises to 150, then falls to 75.

That example also shows why CAGR is not the same as averaging yearly percentages. Over the two periods, the ending value is below the starting value, so its CAGR is negative, even though the arithmetic average of the two annual changes is zero. Use CAGR when the question is the annualized rate implied by the endpoints. Use a period-by-period average only when that is the statistic you specifically intend to report, and state which method you used.

Frequently Asked Questions

What is the CAGR formula in Excel?
Divide the ending value by the beginning value, raise the result to one divided by the elapsed years, and subtract one. With beginning, ending, and years in A2, B2, and C2, use =(B2/A2)^(1/C2)-1.

How do I show CAGR as a percentage in Excel?
Select the result cell and choose Home > Number > Percent Style. Excel will display the decimal result as a percentage. Increase or decrease the displayed decimal places to suit your report.

Can CAGR be calculated when the starting value is zero?
Not with the standard CAGR formula. It divides the ending value by the starting value, so a zero starting value makes the calculation undefined. Use a different growth measure appropriate to the situation and explain its definition.

Should I count the start and end years as two years?
Count the elapsed time between the observations, not the number of calendar labels. From the beginning of 2020 to the beginning of 2025 is five years, even though six year labels may appear in a table covering 2020 through 2025.

Does CAGR show what happened in each year?
No. It compresses the endpoint change into one equivalent annual rate and ignores the route between those endpoints. Review the original period-by-period data if volatility, timing, or intermediate setbacks matter.

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.