How to Calculate Compound Annual Growth: A Practical Guide

Do not index

To get a truly accurate picture of your investment's growth, you need to know three things: its Beginning Value, its Ending Value, and the Number of Years in between. With these, you can calculate the Compound Annual Growth Rate (CAGR), a metric that provides a smoothed-out growth rate, giving you a much clearer picture of performance than a simple average.

What Is CAGR and Why Does It Matter for Investors

Before we jump into the math, let's get a feel for what CAGR actually represents. Think of it as the imaginary, steady rate at which an investment would need to grow each year to get from its starting point to its final value. This is a world away from a simple average, which can often paint a misleading picture.

For instance, imagine a stock soars 50% one year, only to drop 20% the next. A simple average would suggest a nice 15% annual return, but that math doesn't align with the actual cash in your account. CAGR is designed to smooth out this kind of volatility and give you a more realistic performance figure.

The Value of a Standardized Metric

The real power of CAGR is that it gives us a standardized benchmark to compare the performance of totally different assets over time. It levels the playing field. Whether you're analyzing stocks, a company's revenue, or even industry trends, CAGR provides a true apples-to-apples comparison.

This makes it an essential tool for a few key tasks:

Evaluating Investment Performance: You can quickly gauge how well a stock, mutual fund, or your entire portfolio has actually done over several years.

Comparing Different Opportunities: Trying to decide between two investments? Comparing their historical CAGR is a great place to start.

Assessing Business Health: Companies lean on CAGR to track the growth of vital metrics like sales, customer acquisition, or profits.

At its core, CAGR is a key financial metric used to measure the mean annual growth rate of an investment over multiple years, accounting for the effect of compounding. Its formula ensures growth is smoothed out, removing the volatility of interim fluctuations. You can find a detailed breakdown of the CAGR formula and its applications on Wall Street Prep.

The Core Components of the CAGR Formula

To calculate CAGR, you only need three pieces of information. The most important part of the process is making sure these numbers are accurate.

Here’s a quick breakdown of the variables you'll be plugging into the formula.

Component	Description	Example
Beginning Value	The starting value of the investment or metric.	A stock's price was $100 on January 1, 2020.
Ending Value	The final value at the end of the measurement period.	The same stock's price was $180 on December 31, 2024.
Number of Years	The total duration of the investment period.	From the start of 2020 to the end of 2024 is 5 years.

With these three inputs—the start, the end, and the time it took to get there—you have everything you need to calculate an investment's true annualized growth.

Getting to Grips with the CAGR Formula

At first glance, the Compound Annual Growth Rate formula can look a little daunting. Don't worry, it's actually quite straightforward once you understand the pieces.

The formula is: (Ending Value / Beginning Value)^(1 / Number of Years) - 1.

Essentially, you just need three key bits of information: a starting value, an ending value, and the time that passed between them. This simple flow shows how those elements come together.

As you can see, you grab the two main values of your investment first, then use the time period to smooth out the growth rate on an annual basis.

Finding Your Beginning and Ending Values

The first two inputs are the easy part. The Beginning Value (BV) is simply the value of your asset at the start of whatever period you're measuring. This could be a stock's closing price on January 1, 2020, or your company's revenue for the first quarter of that year.

Likewise, the Ending Value (EV) is the value at the very end of your chosen timeframe. If you started on January 1, 2020, your ending value might be the price on December 31, 2024. The key here is consistency—make sure both points represent the exact same type of data (e.g., closing price on the last day of the year).

The core of the formula—(Ending Value / Beginning Value)—is what gives you the total growth multiple. For instance, if a stock grew from 180, this part of the equation would give you 1.8. It simply means the investment grew to 1.8 times its original size.

The Most Common Stumbling Block: The Number of Years

This is where I see people get tripped up all the time. The Number of Years (n) isn't a count of how many data points you have; it's the total duration of the period. This is a critical distinction, and getting it wrong will throw off your entire calculation.

Let's walk through a classic example:

End of Year 2020

End of Year 2021

End of Year 2022

End of Year 2023

End of Year 2024

Even though you have five data points here, the total time that has actually passed from your starting point (end of 2020) to your endpoint (end of 2024) is exactly four years.

If you were to plug "5" into the formula, you would be incorrectly watering down the growth rate. Always calculate the total duration, not the number of entries. This is the single most important detail to get right when you're figuring out how to calculate compound annual growth.

Putting CAGR to Work with a Real Stock Example

Formulas on a page are one thing, but seeing how they work with real numbers is where the magic happens. Let's get our hands dirty and calculate the CAGR for a well-known company: Microsoft (MSFT). We'll look at its performance over a five-year stretch to see what the smoothed-out growth rate really looks like.

First things first, we need the data. For stock analysis, a reliable source like Yahoo Finance is perfect for pulling historical prices.

Here's a snapshot of the historical data for MSFT. We just need to find the right starting and ending prices for our chosen period.

From this chart, we can grab the exact adjusted closing prices we need.

Finding Our Key Numbers

With the historical data in front of us, we can pull out the three variables needed for the CAGR formula. I'm going to look at the period from the beginning of 2019 to the very end of 2023.

Beginning Value (BV): On January 2, 2019, MSFT’s adjusted closing price was $99.19.

Ending Value (EV): Fast forward to December 29, 2023, and the adjusted close hit $375.34.

Number of Years (n): The time between the start of 2019 and the end of 2023 is exactly 5 years.

That’s it. We have everything we need to plug into the formula: CAGR = (EV / BV)^(1 / n) - 1.

Calculating Microsoft's Five-Year CAGR

Now, let's slot those numbers into the equation and break it down step-by-step.

First, we divide the Ending Value by the Beginning Value: $375.34 / $99.19 = 3.784 This initial result shows the stock's value multiplied by nearly 3.8 times over the period.

Next, we handle the exponent part, which annualizes the growth: 1 / 5 years = 0.2

Now, apply that exponent to our growth multiple: 3.784 ^ 0.2 = 1.305 This number represents the annualized growth factor.

Finally, subtract 1 to isolate the growth rate and turn it into a percentage: 1.305 - 1 = 0.305 0.305 * 100 = 30.5%

Over this five-year span, Microsoft's stock produced a Compound Annual Growth Rate of 30.5%. This is a powerful metric because it smooths out all the wild ups and downs of the market, giving you a single, consistent number to represent the stock's performance.

Being able to calculate CAGR is a cornerstone of financial analysis. If you're building more sophisticated valuation tools, this growth rate is a key input. You can see how it fits into a larger framework with our guide to building a DCF model in Excel.

Using CAGR Beyond Just Stock Performance

While CAGR is a go-to metric for stock analysis, its true strength is its adaptability. You can apply the exact same formula to get a bird's-eye view of an entire market or industry, giving you a much richer context for your investment decisions.

Take the global financial services industry, for instance. Analysts often use CAGR to chart a course for future market growth. This sector jumped from 33.5 trillion in 2024 and is on track to hit $44.9 trillion by 2028.

That works out to a compound annual growth rate of about 7.6%—a powerful number that tells a story of steady, sustained expansion. You can discover more insights about the global financial industry report to see how analysts build these kinds of forecasts.

Bringing CAGR In-House for Business Analytics

CAGR isn't just for looking outward; it’s an incredibly useful tool for measuring your own business's pulse. It cuts through the noise of year-to-year fluctuations and gives you a standardized way to talk about performance across the entire company.

Think about it—you can apply the CAGR formula to almost any key performance indicator (KPI) you’re already tracking.

Revenue Growth: What’s the smoothed-out annual growth of your total sales over the last five years?

User Acquisition: How steadily has your customer base been compounding year after year?

Website Traffic: Are your unique visitor numbers growing at a consistent clip?

By using CAGR for these internal metrics, you build a common language for performance. Suddenly, the marketing team, the sales department, and the C-suite are all on the same page, setting realistic goals based on actual, long-term momentum.

This consistent approach provides a much clearer picture of your operational health. Of course, smart investors never rely on a single metric. To get a different angle on profitability, you might want to explore other key investment metrics like Internal Rate of Return.

Understanding your company's internal growth also helps frame other financial calculations. Seeing how these concepts fit together is crucial, so be sure to check out our guide on the return on investment calculation.

Understanding the Limitations of CAGR

While learning to calculate compound annual growth is a huge step, an experienced investor knows it's just as crucial to understand what the number doesn't tell you. The metric’s biggest strength—smoothing out performance over time—is also its most significant weakness.

At its core, CAGR completely ignores the real-world volatility that happens between your start and end dates. It draws a straight line through what was likely a very bumpy ride.

Let's imagine two different stocks. Both start at 15,000 over three years. On paper, they have the exact same CAGR. But what if one grew steadily year-over-year, while the other shot up to $30,000 before a dramatic crash? CAGR treats both scenarios as identical, completely hiding the massive difference in risk and the sleepless nights that second investment would have caused.

The Timeframe You Choose Matters—A Lot

Another major blind spot is how sensitive CAGR is to the dates you plug in. If you're analyzing a volatile stock, shifting your timeframe by just a few months can produce a wildly different result.

For example, starting your calculation from a market low and ending at a peak will give you a fantastic-looking CAGR. But if you measure from a peak to a trough, the number will look disastrous. This makes it easy for the metric to be manipulated to paint an overly rosy or unfairly negative picture of performance.

CAGR provides a hypothetical, steady growth rate. It assumes the investment grew in a straight line, which is never the reality. It's a rearview mirror metric that tells you the 'what' but not the 'how' or the 'why' of the journey.

Because of these inherent drawbacks, you should never rely on CAGR in isolation. To get the full story, it’s best to pair it with other metrics that capture volatility and recent momentum. For a more complete picture, consider looking into methods for evaluating year-to-date stock performance.

This combined approach gives you a much more balanced and realistic assessment of an asset’s true behavior.

Wrapping Up: Common Questions on CAGR

As you get more comfortable with the CAGR formula, a few common questions tend to pop up. Let's run through them to clear up any final fuzzy spots.

Can I Use CAGR for a Period Shorter Than One Year?

You really shouldn't. The "A" in CAGR stands for Annual, so the whole concept is built around a yearly time horizon.

If you try to apply the formula to a few months or weeks, you'll get a wildly inflated number. The calculation would essentially project that short-term growth across an entire year, which is rarely a realistic scenario. Stick to timeframes of one year or longer for meaningful results.

So, What's a "Good" CAGR Anyway?

This is the classic "it depends" answer, but it's the truth. A "good" CAGR is all about context.

A 10% CAGR for a stable, dividend-paying utility stock might be fantastic. For a venture capital investment in a new tech startup, that same 10% would be a major disappointment. You always need to compare an asset's CAGR against its direct peers, the broader industry average, and historical market performance to judge whether it's truly a strong number.

The most important thing to remember is that CAGR gives you a smoothed-out growth rate. Unlike a simple average, it accounts for the effects of compounding and gives you a much truer sense of how an investment has actually performed over the long haul.