Annual Compound Growth Rate Formula in Excel (Step-by-Step)
You searched for “annual compound growth rate formula excel” because you need a number, and you need it fast. Maybe it’s for a boss who wants to know how fast sales grew. Maybe it’s for your own investments. Either way, you don’t want a finance lecture. You want the formula, a real example, and a way to check your work.
That’s what this article gives you. No jargon. No fluff. Just a clear path from “I have some numbers” to “I have my CAGR” in under five minutes.
What Is CAGR (Compound Annual Growth Rate)?
CAGR stands for Compound Annual Growth Rate. It answers one simple question: if something grew at the exact same rate every single year, what would that rate be?
Think of it like a smoothing tool. Real growth is messy. A business might grow 20% one year and only 2% the next. CAGR takes that bumpy ride and turns it into one steady, easy-to-compare number.
People use CAGR to track things like:
- How fast a stock or fund grew over several years
- How much a company’s revenue increased year over year
- How a savings account or investment performed compared to another
- Whether a business is hitting its growth targets
It’s one of the most trusted numbers in finance because it strips out the noise and shows the real trend.
The CAGR Formula Explained in Simple Steps
Here is the full formula:
CAGR = (Ending Value ÷ Beginning Value) ^ (1 ÷ Number of Years) − 1
Let’s break that into plain steps, because the symbols can look scarier than they really are.
- Take your ending value (what you have now) and divide it by your beginning value (what you started with).
- Raise that result to the power of 1 divided by the number of years.
- Subtract 1 from the result. It’s the same basic Excel command for subtraction you already know, just built into a larger formula.
- Multiply by 100 to turn it into a percentage.
That’s it. Three math steps and you have your growth rate. Now let’s put it into Excel.
How to Calculate CAGR in Excel: 3 Easy Methods
Excel doesn’t have one single “CAGR button,” but it gives you three simple ways to get the same answer. Pick whichever one feels easiest to you.
Method 1: The Manual Formula
This is the most common way people calculate CAGR, and it matches the formula you just learned above.
- Put your beginning value in one cell, for example B2.
- Put your ending value in another cell, for example B10.
- Count how many years are between them. If your data runs from 2017 to 2025, that’s 8 years. If your table grows and you need extra years later, the shortcut key for inserting a row in Excel keeps everything lined up without breaking your formula references.
- In an empty cell, type this formula, adjusting the cell references and year count to match your data:
=(B10/B2)^(1/8)-1
Press Enter, then format the cell as a percentage so it reads correctly. If you’d rather skip the mouse, one of the Microsoft Excel shortcuts, Ctrl+Shift+%, formats it instantly.
Method 2: Using the POWER Function
If the little “^” symbol confuses you, Excel’s POWER function does the exact same job in a way that reads more clearly.
=POWER(B10/B2,1/8)-1
This gives you the identical result to Method 1. Some people just find it easier to read and troubleshoot.
Method 3: Using the RRI Function
This is the method Microsoft itself recommends, and it’s arguably the fastest since it does the whole calculation in one clean step. RRI stands for “Rate of Return on Investment.”
=RRI(8,B2,B10)
Here, 8 is the number of years, B2 is your starting value, and B10 is your ending value. No exponents to worry about, no risk of a typo in the power sign. Microsoft’s official Excel support documentation lists this as the recommended function for CAGR-style calculations, which makes it a safe, dependable choice.
A Real Example You Can Copy
Numbers make everything click faster, so let’s walk through a real example.
Say your business made $50,000 in revenue in 2018. By 2025, revenue grew to $95,000. That’s a span of 7 years.
- Beginning value: $50,000
- Ending value: $95,000
- Number of years: 7
Your Excel formula would be:
=(95000/50000)^(1/7)-1
That gives you roughly 0.0966, or 9.66%. In plain words, your revenue grew at a steady rate of about 9.66% every year, even though the real year-to-year growth almost certainly bounced around.
Try it yourself with your own numbers. Swap in your starting value, ending value, and year count, and Excel will do the rest instantly.
CAGR vs. Average Growth Rate: What’s the Difference?
This trips up a lot of people, so it’s worth clearing up. Average growth rate just adds up each year’s percentage growth and divides by the number of years. CAGR is different because it accounts for compounding, meaning growth builds on top of previous growth.
This matters more than it might seem. Imagine an investment grows 50% in year one, then drops 50% in year two. A simple average would tell you the growth rate was 0%. But in reality, you lost money. CAGR captures that real outcome, while a plain average can be misleading.
If you only remember one thing from this section, remember this: CAGR tells you the true story. Average growth rate can lie to you without meaning to.
Common Excel Mistakes That Break Your CAGR Formula
Most CAGR errors in Excel come down to a handful of small, avoidable slips. Watch out for these:
- Wrong year count. If your data spans 2018 to 2025, that’s 7 years of growth, not 8. Count the gaps between years, not the number of data points.
- Missing parentheses. Excel follows strict order of operations. Leaving out a bracket can quietly give you a completely wrong number.
- Negative beginning values. If your starting number is zero or negative, the formula will break or return an error. CAGR only works cleanly with positive numbers.
- Forgetting to format as a percentage. Your formula might be correct, but the cell will show a strange decimal like 0.0966 instead of 9.66% until you format it properly.
- Mixing up beginning and ending values. Swapping these two by accident will flip your growth rate into a decline, or the other way around.
What Counts as a “Good” CAGR?
This depends heavily on what you’re measuring, but here are some general benchmarks people commonly use for comparison.
- The long-term stock market average CAGR sits around 7% to 10% per year, depending on the time period measured.
- A healthy small business often aims for a revenue CAGR between 10% and 20%.
- Fast-growing startups sometimes post CAGRs above 30%, though that pace is usually hard to sustain for long.
- Savings accounts and low-risk bonds typically produce a CAGR closer to 2% to 5%.
There’s no single “correct” number. A good CAGR is one that beats your specific goal, whether that’s beating inflation, beating a competitor, or simply beating what you earned last year.
The Limits of CAGR (What It Doesn’t Tell You)
CAGR is powerful, but it isn’t perfect. Keep these limitations in mind before you lean on it too heavily.
- It hides volatility. Two investments can have the same CAGR while one had wild swings and the other grew steadily. CAGR won’t show you that difference.
- It ignores extra cash added along the way. If you added money mid-way through the period, plain CAGR won’t account for that. You’d need a function like XIRR instead.
- It assumes steady compounding. Real life rarely grows in a perfectly smooth line, so treat CAGR as a helpful average, not a guarantee.
Frequently Asked Questions
Can CAGR be negative?
Yes. If your ending value is lower than your beginning value, your CAGR will come out negative, showing that the investment or metric declined over that time period.
Does Excel have a ready-made CAGR function?
Not one with that exact name, but the RRI function calculates it directly, and the POWER function or a manual formula can also get you the same result.
What’s the difference between CAGR and XIRR?
CAGR works best when you only have a single beginning value and a single ending value. XIRR is better when money was added or withdrawn multiple times during the period, since it accounts for the timing of each cash flow.
Can I calculate CAGR for months or quarters instead of years?
Yes. Just replace the number of years in the formula with the number of months or quarters, so the exponent still matches your actual time period.
Does this formula work in Google Sheets too?
Yes. Google Sheets uses the same basic formula and offers its own POWER and RRI-style functions, so the process barely changes. It’s worth learning a few Google Sheets hidden functions as well, especially if you often move data between the two tools.
Why is my CAGR formula showing an error in Excel?
This is almost always caused by a negative or zero value in your beginning number, or a small parenthesis mistake. Double-check both before assuming the formula itself is wrong.
Final Thoughts
Calculating CAGR in Excel really comes down to three simple ingredients: a starting value, an ending value, and a year count. Once you have those, the formula does all the heavy lifting.
Whether you use the manual formula, the POWER function, or the RRI function, you’ll land on the exact same answer. Pick whichever one feels most natural to you, plug in your own numbers, and you’ll have a reliable growth rate in seconds, not hours.
