CAGR Calculation in Excel: Formula, Steps, and Examples

Formulas & functions · Updated November 21, 2026

To calculate CAGR in Excel, divide the ending value by the starting value, raise the result to the power of one divided by the number of years, then subtract 1. If the starting value is in B2, the ending value is in B3, and the number of years is in C2, enter =(B3/B2)^(1/C2)-1 in another cell and format it as a percentage.

CAGR means compound annual growth rate. It expresses the steady yearly growth rate that would take an initial value to a final value over a set period, assuming growth compounded annually. It is a useful summary for comparing growth across different time spans, but it does not describe what happened in each individual year.

What CAGR Measures

CAGR converts a start value, an end value, and a duration into one annualized rate. For example, a business metric that rises from 100 to 150 over three years has a CAGR of about 14.47%. That rate is not the same as dividing the 50% total increase by three. Compounding means each year’s growth applies to a changing base, so the annual rate is calculated using a root rather than simple division.

The calculation effectively asks: what constant annual percentage change would produce the observed final value if it were applied repeatedly for the stated number of years? Actual results may have been uneven. A company could grow quickly in one year, decline in the next, and recover later while still having the same CAGR as another company whose growth was smooth.

CAGR is often used for revenue, customer counts, sales, assets, or other measures that have meaningful positive starting and ending values. It is a descriptive calculation, not a forecast or guarantee that the same rate will continue. For investment figures, it also does not capture the timing of deposits, withdrawals, or the path of returns.

Set Up the Excel Cells

A straightforward worksheet keeps the inputs separate so the calculation is easy to check and update. In a blank Microsoft Excel for Microsoft 365 worksheet on Windows, enter the labels and values in this layout:

  • A1: Starting value; B1: Ending value; C1: Number of years; D1: CAGR.
  • A2: 10000; B2: 14641; C2: 4.

In this layout, the starting value is in A2, the ending value is in B2, and the number of years is in C2. Enter the formula in D2: =(B2/A2)^(1/C2)-1. The calculated result is 0.10, or 10% when shown as a percentage. You can replace the example inputs with your own values while keeping the references aligned.

Labeling the units and period helps prevent mistakes. If the values are in dollars, say so in the headings or nearby notes; if they represent thousands of dollars, use the same scale for both endpoints. The formula only uses the ratio of the two values, so matching units cancel out, but mixing units—for example, entering 10,000 for the start and 14.641 for an end value expressed in thousands—will give a meaningless answer.

Understand the Formula

The formula has three parts. First, ending value divided by starting value gives the total growth multiple. Second, raising that multiple to 1 divided by the number of years converts the total change into a per-year compound rate. Finally, subtracting 1 changes the annual growth factor into a rate. If the ending value is 1.4641 times the starting value after four years, the annual growth factor is 1.10 and the CAGR is 0.10, or 10%.

For a worksheet with the starting value in B2, ending value in B3, and number of periods in C2, the equivalent formula is =POWER(B3/B2,1/C2)-1. POWER is an Excel function that raises a number to a power. This version gives the same result as using the caret operator in =(B3/B2)^(1/C2)-1; some people prefer POWER because its purpose is explicit, while the caret version is shorter.

The number of periods must match the interval represented by the values. If annual figures span from the end of 2020 to the end of 2024, there are four annual periods, not five, even though five calendar-year labels may appear when counting both endpoints. For monthly data, use the number of months divided by 12 to express the duration in years, or calculate a monthly compound rate separately if that is the rate you need.

Worked Example: From 10,000 to 14,641

Suppose an account balance or business measure begins at 10,000 and ends at 14,641 exactly four years later, with no additional cash flows included in the comparison. The total multiple is 14,641 divided by 10,000, which equals 1.4641. The fourth root of 1.4641 is 1.10; subtracting 1 gives 0.10. Therefore, the CAGR is 10% per year.

With the starting value in B2, ending value in B3, and elapsed years in C2, use =(B3/B2)^(1/C2)-1. Enter 10000 in B2, 14641 in B3, and 4 in C2. Excel returns 0.1 as the underlying decimal, which displays as 10% after percentage formatting. If you instead type 10% as an input and then multiply it by 100 for display, the sheet may show 1000%; leave the formula result as a decimal and use cell formatting.

A decline also produces a valid CAGR when both values are positive. If a measure falls from 5,000 to 4,000 over three years, the ending-to-starting ratio is 0.8. Its CAGR is approximately -7.17% per year: applying that annual decrease for three periods takes 5,000 to about 4,000. A negative CAGR describes an average compounded decline, not necessarily a decline of exactly 7.17% in each observed year.

Calculate CAGR from Dates

If your worksheet has actual start and end dates rather than a pre-entered year count, the elapsed time can be calculated from those dates. This is helpful when the dates are not exactly an integer number of years apart. YEARFRAC returns a year fraction between two dates; its basis argument controls the day-count convention. Basis 1 uses the actual number of days and an actual-year convention.

Assume A2 contains the starting date, A3 contains the ending date, B2 contains the starting value, and B3 contains the ending value. To calculate a date-based annualized rate using YEARFRAC with basis 1, enter =(B3/B2)^(1/YEARFRAC(A2,A3,1))-1. Format the result as a percentage. For example, if A2 is 1/1/2020, A3 is 1/1/2024, B2 is 10000, and B3 is 14641, the result is 10% because the dates span four years.

Date-based results can differ slightly from calculations that use a manually entered whole number of years, especially for partial years or leap-year intervals. Choose a convention that fits the data and apply it consistently. If the question is specifically growth across four annual reporting periods, using 4 as the period count may be clearer than using dates. If dates vary or periods are partial, a year-fraction method makes the elapsed time explicit.

Format and Check the Result

Excel stores a percentage as a decimal: 0.1 is 10%, and 1 is 100%. To display the CAGR clearly, select the result cell and choose Home > Number > Percent Style. Increase or decrease decimal places as needed with the decimal-place controls in the Number group. You can also open Format Cells with Ctrl+1 on Windows and select Percentage. In Excel for Mac, Command+1 opens Format Cells; the ribbon options are similar, though the exact arrangement can vary by update.

Two decimal places are often useful when comparing similar rates, while whole percentages may be sufficient for a high-level summary. Do not round the formula’s intermediate steps by replacing them with rounded values; format the displayed result instead. Excel will keep the underlying precision for later calculations.

Check the result by reversing the calculation conceptually. Multiply the starting value by one plus the CAGR, raised to the number of years; the result should be approximately the ending value. Also confirm that the rate’s sign makes sense: an ending value above a positive starting value should yield a positive CAGR, while a smaller positive ending value should yield a negative one. Minor display differences can result from rounding.

Common Errors and Limitations

  • Counting periods incorrectly: The exponent uses the number of intervals, not simply the number of year labels shown. A value measured at the end of year 1 and again at the end of year 5 spans four annual intervals.
  • Using zero or negative endpoints: Standard CAGR is not defined when the starting value is zero, and the conventional real-valued calculation generally does not work with negative endpoints. Do not force a percentage result in these cases; choose a measure suited to the data, such as an absolute change, and explain the limitation.
  • Mixing units or periods: Both endpoints must use the same units, and the period count must match them. Comparing monthly values while entering a count of years creates an incorrect rate.
  • Confusing CAGR with an arithmetic average: CAGR is a geometric annualized rate derived from endpoints. It is not the average of each year’s percentage changes. For instance, a 50% gain followed by a 50% loss does not return an investment to its starting value, even though the arithmetic average of those two rates is zero.
  • Ignoring cash flows: A start-to-end CAGR treats the endpoints as though the value grew between them without accounting for when money was added or removed. For investment performance with contributions or withdrawals, CAGR may not represent the investor’s actual experience; a cash-flow-aware measure may be needed.
  • Assuming a smooth path: CAGR summarizes the whole span and hides volatility, interruptions, and intermediate results. Review the yearly or monthly data too when those details matter.

For financial examples, treat the numbers here as illustrative calculations, not investment, tax, or financial advice. Actual product terms and cash-flow details can change what a useful performance measure means; check real terms with the lender or a qualified professional where relevant.

CAGR Compared with Other Growth Measures

Total growth is simply the ending value divided by the starting value minus 1. In the 10,000-to-14,641 example, total growth is 46.41%; CAGR expresses that same endpoint change as a 10% annual compound rate over four years. Total growth is easier to interpret for a fixed span, while CAGR is more convenient for comparing spans of different lengths.

An arithmetic average annual return is the sum of the annual returns divided by the number of years. It describes an average of the observed yearly rates, but it does not necessarily match the compounded growth of the starting amount. CAGR is based on the beginning and ending values and represents the equivalent compound rate. When a series of annual returns is available, the geometric mean of those returns is closely related to CAGR if the periods and assumptions align.

Neither measure tells the full story by itself. CAGR is useful for concise comparisons, but it omits volatility and the route between endpoints. An arithmetic average can describe the average yearly percentage change, but can overstate realized compound growth when returns fluctuate. Choose based on the question: endpoint annualization, average yearly change, or the experience of cash flows over time are different questions.

Frequently Asked Questions

What is the simplest CAGR formula in Excel?
With the starting value in A2, ending value in B2, and number of years in C2, use =(B2/A2)^(1/C2)-1. Format the result as a percentage.

How do I calculate CAGR when I have dates?
Use YEARFRAC to calculate the elapsed years from the dates, then use that result as the exponent denominator. For example, if A2 and A3 contain the dates and B2 and B3 contain the corresponding values, use =(B3/B2)^(1/YEARFRAC(A2,A3,1))-1.

Can CAGR be negative?
Yes. If both endpoint values are positive and the ending value is lower than the starting value, CAGR is negative and represents an annualized compound decline.

Why does my Excel CAGR show as a decimal?
Excel returns a decimal rate, so 0.1 means 10%. Apply Percentage formatting to show it as a percent; do not multiply the formula result by 100 unless you specifically need a numeric value rather than a formatted percentage.

Can I use CAGR if the starting value is zero?
No. The standard calculation divides the ending value by the starting value, so a zero starting value makes that ratio undefined. Use another measure, such as absolute change, and make clear that it answers a different question.

Is CAGR the same as the average annual return?
Not always. CAGR is the constant compound rate implied by the beginning and ending values. An arithmetic average is the average of annual percentage changes, and fluctuating returns can make it differ from the compound rate.

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.