Excel CAGR Formula: How to Calculate Compound Annual Growth Rate (with Template)

If you need a fast way to measure annualized growth in Excel, the CAGR formula is the one to use: =(End/Start)^(1/Years)-1. It takes the beginning value, the ending value, and the number of years, then smooths the change into a single yearly rate.

That makes CAGR useful for sales growth, revenue trends, customer counts, portfolio returns, and almost any other metric that moves over time. It is not a year-by-year story. It is the cleanest summary of how much something grew per year if the growth had happened at a steady pace.

Sourced note: Investopedia describes CAGR as the rate that takes an investment from beginning value to ending value over a set period, which is why the formula is so useful for turning noisy growth into one annualized number. Investopedia

Quick answer: if your start value is in B3, your end value is in B4, and the number of years is in B5, the Excel CAGR formula is:

=(B4/B3)^(1/B5)-1

For a cleaner version, I often use:

=POWER(B4/B3,1/B5)-1

And if I want a built-in cross-check, I use:

=RRI(B5,B3,B4)

What is the Excel CAGR formula?

The Excel CAGR formula is just the standard compound annual growth rate equation written in spreadsheet form. In plain English, it asks: if a value started at one number and ended at another number over a certain number of years, what constant annual rate would produce that same result?

The core formula is:

=(Ending Value / Beginning Value)^(1 / Number of Years) - 1

In Excel, the caret version and the POWER version return the same answer:

If your numbers are in a simple annual table, CAGR is usually the right metric. It gives you one rate that is easy to compare across companies, products, or time periods.

How do I calculate CAGR step by step in Excel?

The fastest way to calculate CAGR in Excel is to enter the start value, the end value, and the number of years, then apply the formula to those cells. For a worked example, I usually keep the inputs separate so the formula is easy to audit later.

Here is the example used in the downloadable template:

• Start value: 10,000
• End value: 17,500
• Years: 5

The formula is:

=(17500/10000)^(1/5)-1

That returns 11.84%.

The worksheet setup I use

If I were building this by hand, I would lay it out like this:

That layout keeps the logic obvious:

1. Put the starting value in one cell.
2. Put the ending value in another cell.
3. Put the number of annual periods in a third cell.
4. Calculate CAGR with a single formula.
5. Cross-check the answer with RRI.

Why the formula works

CAGR reverses compounding. If an amount grows by the same percentage every year, the end value is the start value multiplied by that growth rate repeatedly. CAGR solves the opposite problem: it takes the start and end values and backs into the constant rate that would connect them.

That is why the exponent is 1/Years. It spreads the total change evenly across the whole period.

Which Excel function should I use: POWER, caret, or RRI?

For most people, the POWER version is the best balance of readability and simplicity. The caret version is shorter, and RRI is a good built-in cross-check, but POWER usually makes the logic easier to understand when someone opens the workbook later.

My practical rule is simple:

• Use ^ when you want the shortest formula.
• Use POWER when you want the clearest formula.
• Use RRI when you want to verify the result.

RRI is especially useful when you are auditing a workbook and want to confirm that your manual CAGR math is correct. It returns an equivalent rate for a constant growth path, so the answer should match the manual formula if your inputs are the same.

If your growth dates are irregular, CAGR is not the right tool. In that case, compare this guide with my XIRR vs IRR walkthrough because XIRR handles uneven dates much better.

When should you not use CAGR?

CAGR is not the right metric for every dataset. It works best when you have one beginning value, one ending value, and a clean time span. If the values bounce around a lot, contain negative numbers, or come from irregular cash flows, another approach is better.

Here are the main cases where I avoid CAGR:

• Irregular dates or cash flows: use XIRR or another date-aware return metric.
• Zero or negative start values: the formula will break or become misleading.
• Very short periods: one unusual month or quarter can distort the annualized result.
• Highly volatile series: CAGR hides the path and only shows the endpoints.

That last point is important. CAGR is excellent for reporting, but it does not tell you what happened in the middle. A business could grow 50%, fall 20%, then recover again and still end up with the same CAGR as a smoother business.

If you need the full story, pair CAGR with a chart or a year-by-year table.

What mistakes cause CAGR formulas to fail?

The most common CAGR mistakes are simple cell-reference errors and bad inputs. If the start value is zero, negative, or blank, the formula cannot produce a meaningful result. If the number of years is wrong, the annualized rate will also be wrong.

I see these problems most often:

1. Using the wrong period count

   If you measured growth over 18 months but typed 1 instead of 1.5, the rate will be inflated.

2. Mixing up start and end values

   The formula assumes the first number is the beginning value and the second number is the ending value.

3. Forgetting to convert months into years

   If the data is monthly, divide the months by 12 before you annualize.

4. Using CAGR on negative values

   CAGR is not a fix for negative or zero values. In those cases, the math does not represent a useful growth rate.

5. Comparing CAGR to raw growth

   Raw growth and CAGR are not the same. Raw growth is the total change. CAGR is the annualized equivalent.

If you want a monthly example, the logic is the same, but the exponent changes. For a monthly period count, annualize like this:

=(End/Start)^(12/Months)-1

How do I calculate CAGR for monthly or quarterly data?

You can still use CAGR when the source data is monthly or quarterly, but you need to translate the period count into years before you annualize it. The trick is to keep the math on a yearly basis even when the raw data arrives in shorter chunks.

For example:

• 12 monthly periods = 1 year
• 6 quarterly periods = 1.5 years
• 36 monthly periods = 3 years

If you have monthly data and want an annualized rate, the formula becomes:

=(End/Start)^(12/Months)-1

If you have quarterly data, use:

=(End/Start)^(4/Quarters)-1

The same idea applies to any period length. Convert the period count first, then apply the CAGR formula. That keeps the result comparable to annual targets and annual reports.

A simple check helps here: if the answer seems way too high or low, ask whether you counted periods correctly. A 24-month span is 2 years, not 24 years, and that mistake alone can throw the result off by a lot.

A quick side-by-side comparison

How is CAGR different from average growth or year-over-year growth?

CAGR answers a different question from average growth. Average growth looks at the change in each period and averages the results. CAGR looks only at the start and end values and turns the total change into one annualized rate.

That difference matters because the two numbers can disagree by a lot when the path is uneven. A business can spike early, flatten later, and still end with the same CAGR as a steadier business that grew every year.

Here is the practical way to think about the three metrics:

• Year-over-year growth shows what happened in each individual year.
• Average growth shows the average period change.
• CAGR shows the smoothed annual rate from start to finish.

If you need to explain a trend to a stakeholder, CAGR is usually the cleanest headline number. If you need to manage performance, year-over-year growth gives more detail. If you need to understand the middle of the journey, use both.

Worked example: three different ways to describe the same series

Imagine a metric that moves like this:

• Year 1: 10,000
• Year 2: 14,000
• Year 3: 13,000
• Year 4: 17,500

The year-over-year changes are messy, but the CAGR between 10,000 and 17,500 still gives you one annualized rate for the whole four-year span. That is why it is so common in finance and operating reviews: it makes comparison easier without pretending the path was smooth.

How do I present CAGR in a report?

CAGR is most useful when you want one headline number that a manager, client, or investor can scan quickly. The trick is to pair the rate with the actual start and end values so the number does not float away from the business context.

A good reporting line looks like this:

• Revenue grew from $10,000 to $17,500 over five years.
• That works out to an 11.84% CAGR.
• The year-by-year path still matters, so keep the supporting table or chart nearby.

If you are adding CAGR to a dashboard, I recommend showing three things together:

1. The start value.
2. The end value.
3. The CAGR result.

That combination answers the obvious follow-up question: “11.84% of what, exactly?” It also keeps the metric honest, because CAGR alone can hide volatility. When a stakeholder can see the endpoints and the compounding rate side by side, the number becomes much easier to trust.

Download the Excel CAGR template

The downloadable workbook gives you a ready-to-use CAGR calculator with sample inputs, a manual formula check, an RRI check, and a simple growth projection table. I built it so you can replace the sample values with your own numbers and immediately see the annualized result.

Download the Excel CAGR template

The workbook includes:

• A calculator sheet with start value, end value, and years
• A manual CAGR formula
• An RRI cross-check
• A year-by-year projection table
• Formatting that makes the inputs and outputs easy to scan

FAQ

What is the formula for CAGR in Excel?

Use =(End/Start)^(1/Years)-1 or =POWER(End/Start,1/Years)-1.

Is RRI the same as CAGR?

For a clean start value, end value, and period count, RRI gives you the same kind of annualized result as CAGR.

Can I use CAGR for monthly growth?

Yes. Convert the period count properly before annualizing, or use a version of the formula that reflects the correct number of months.

Is CAGR better than average growth?

Usually yes. CAGR smooths the full growth path into one rate, while a simple average can overstate or understate the real annualized change.

If you want a separate way to compare annualized growth with irregular returns, see my XIRR vs IRR guide and the yield to maturity tutorial.