✉ in

Corporate finance 29 September 2026 7 min read

Compound Annual Growth Rate (CAGR) Formula: A Practical Guide

Q: What is the formula for compound annual growth rate (CAGR)?

The CAGR formula is CAGR = (EV / BV)^(1/n) – 1, where EV is Ending Value, BV is Beginning Value, and n is the number of compounding periods (years).

Q: How do you calculate CAGR in Excel?

The simplest method is using the RRI function: =RRI(nper, pv, fv). Alternatively, use the POWER formula: =POWER(fv/pv, 1/nper) – 1 or the caret operator: =((fv/pv)^(1/nper))-1.

Q: What is the difference between CAGR and a simple average growth rate?

CAGR is a geometric average that accounts for compounding over multiple periods, producing a smoothed annualized rate. Simple average (AAGR) is an arithmetic average that ignores compounding and can distort true returns in volatile conditions.

Q: Can the CAGR be negative, and what does it mean?

Yes, CAGR can be negative whenever the ending value is less than the beginning value. A negative CAGR reflects the constant annual rate of capital contraction over the measured timeline.

Q: What is considered a good CAGR for an investment?

A ‘good’ CAGR depends on asset class, risk profile, and market environment. For public equity portfolios, matching or exceeding the S&P 500’s historical ~10% CAGR is standard, whereas private equity or tech startups often target CAGRs exceeding 20% to 30%.

Q: Why do you subtract 1 in the CAGR formula?

Subtracting 1 removes the principal baseline factor (converting a total growth factor like 1.15 into 0.15) to express the growth strictly as a net percentage return.

Q: What are the main limitations of using CAGR for analysis?

The primary limitations are that CAGR smooths out interim volatility (masking portfolio risk), assumes straight-line growth, and cannot account for periodic cash additions or withdrawals.

Q: How do you calculate CAGR for a period of less than a year?

For time periods under 12 months, express n as a fraction of a year (e.g., n = 0.5 for 6 months or n = 90/365 for 90 days) within the standard formula exponent.

Q: Is CAGR the same as the internal rate of return (IRR)?

No. CAGR measures annualized return for a single lump sum with zero cash flow interventions. IRR accounts for multiple ongoing capital injections and cash distributions over time.

Measuring the true expansion of a business or investment over multiple years requires a metric that strips away short-term noise and accounts for the compounding effect. Compound Annual Growth Rate (CAGR) is a key metric for measuring an investment’s annual growth over a specific period, assuming profits are reinvested. Unlike simple percentage changes or arithmetic averages, CAGR provides a smoothed, annualized figure that allows corporate executives, private equity investors, and financial analysts to compare disparate assets on an equal footing.

In this comprehensive guide for 2026, we explore the theoretical foundations, manual calculations, spreadsheet implementations, and strategic nuances of the compound annual growth rate formula. Whether you are analyzing portfolio returns, modeling corporate annual recurring revenue (ARR) growth, or evaluating strategic M&A targets, mastering CAGR is essential for precise investment analysis and business planning.

What Is the Compound Annual Growth Rate (CAGR) Formula?

The compound annual growth rate formula is a mathematical equation used to calculate the constant geometric rate at which an investment grows from its initial value to its final value over a given time horizon. Mathematically, the formula is expressed as:

CAGR = (EV / BV)^(1/n) – 1

Where EV = Ending Value, BV = Beginning Value, and n = Number of Periods (Years).

Conceptually, the formula determines the steady annualized rate of return that would be required for an initial lump-sum investment to grow to its ending balance, assuming all earnings, interest, and dividends are continuously reinvested at the end of each period.

The formula at a glance

Base Growth Ratio (EV / BV): Divides ending value by beginning value to determine the total cumulative growth factor.
Annualization Factor ^(1/n): Applies exponentiation to compute the geometric mean across n compounding periods.
Percentage Isolation (- 1): Subtracts the base principal factor of 1 to yield the net percentage growth rate.

Breaking Down the Formula Components

To ensure flawless application, it is critical to understand each variable in the formula:

Beginning Value (BV): The initial capital investment or starting revenue figure at the outset of the measurement period. It must always be a positive number greater than zero.
Ending Value (EV): The total market value of the investment or revenue generated at the conclusion of the specified timeframe.
Number of Periods (n): The total number of compounding intervals (usually years) between the starting and ending dates. A common point of confusion is determining n. When evaluating a timeline from 2021 to 2026, n is calculated as 2026 – 2021 = 5 periods, not 6 calendar years.
Exponentiation: The mathematical operation of raising the growth factor ratio to the fractional power of 1/n. This step extracts the geometric mean across the time horizon.

How to Calculate CAGR: A Step-by-Step Example

To illustrate how the compound annual growth rate formula functions in practice, let us examine a real-world case study of a major enterprise technology company’s revenue expansion from fiscal year 2021 to fiscal year 2026.

Case Study Data:

Fiscal Year 2021 Revenue (BV): $50.0 Billion
Fiscal Year 2026 Revenue (EV): $95.0 Billion
Time Horizon (n): 5 Years (2021 to 2026)

Follow these four steps to calculate annualized growth manually:

Calculate the total growth ratio (EV / BV). Divide the ending value by the beginning value. Ratio = 95.0 / 50.0 = 1.90 (representing a 90% total cumulative return).
Determine the exponent (1 / n). Divide 1 by the number of years. Exponent = 1 / 5 = 0.20.
Raise the ratio to the exponent (1.90^0.20). Use exponentiation to calculate the geometric growth factor. 1.90^0.20 ≈ 1.13697.
Subtract 1 to isolate the rate and convert to a percentage. CAGR = 1.13697 – 1 = 0.13697, or 13.70%.

The company expanded its top-line revenue at a Compound Annual Growth Rate of 13.70% over the 5-year period.

Using the Compound Annual Growth Rate Formula in Excel & Google Sheets

Modern financial modeling relies on spreadsheet software to automate growth rate computations. Both Microsoft Excel and Google Sheets offer native functions to handle this efficiently.

Method 1: The RRI Function (Recommended)

The RRI function is a built-in spreadsheet tool designed to return an equivalent interest rate for the growth of an investment over a specific number of periods.

Syntax: =RRI(nper, pv, fv)
Parameters: nper = Number of periods (5) · pv = Present value / Beginning Value ($50.0) · fv = Future value / Ending Value ($95.0)
Formula Entry: =RRI(5, 50, 95) → Output: 13.70%

Method 2: Using the POWER Function or Caret (^) Operator

For users working with custom financial modeling templates or legacy software, direct mathematical modeling using the POWER function or the caret (^) operator provides maximum transparency.

Direct Caret Formula: =((C5/C4)^(1/C6))-1
POWER Function Formula: =POWER(C5/C4, 1/C6)-1

Where Cell C4 = $50.0 (BV), Cell C5 = $95.0 (EV), and Cell C6 = 5 (n).

CAGR vs. Average Annual Growth Rate (AAGR): Key Differences

Financial analysts often confuse CAGR with the Average Annual Growth Rate (AAGR). While both measure growth over time, they employ fundamentally different mathematical principles: CAGR relies on the geometric mean (accounting for compounding), while AAGR uses the arithmetic mean (ignoring compounding).

Metric	Calculation Method	Accounts for Compounding?	Best Use Case	Volatility Impact
CAGR (Compound Annual Growth Rate)	Geometric Mean: (EV/BV)^(1/n) – 1	Yes	Multi-year investment performance, ARR growth, M&A valuation	Smooths out volatility into a steady equivalent rate
AAGR (Average Annual Growth Rate)	Arithmetic Mean: Σ(Annual Growth Rates) / n	No	Analyzing historical annual variance, short-term trends	Highly sensitive to volatile spikes; often overstates growth

To see why this distinction matters, consider a volatile asset that starts at $100 in Year 0, surges 100% to $200 in Year 1, and then plummets 50% back to $100 in Year 2. The arithmetic average (AAGR) yields: (100% – 50%) / 2 = +25% per year. However, the investor made zero net profit. The CAGR accurately reflects reality: (100/100)^(1/2) – 1 = 0.0%.

Practical Applications of the CAGR Formula

In corporate finance and wealth management, CAGR is applied across a wide variety of operational and strategic scenarios:

Comparing Investment Funds: Evaluating the 5-year CAGR of two competing mutual funds or ETFs to assess relative manager performance on an equalized basis.
Corporate Revenue Planning: Forecasting a SaaS company’s annual recurring revenue (ARR) trajectory in a 2026 business plan based on historical 3-year performance.
Benchmark Index Tracking: Benchmarking institutional portfolio performance against the historical decade-long CAGR of the S&P 500 (which has historically averaged around 10%).
Evaluating Asset Turnarounds: Measuring the negative CAGR of a declining business unit or retail segment to plan structural restructuring.
Non-Financial KPI Growth: Tracking audience growth metrics, such as a social media channel’s active user base growing from 100,000 to 450,000 followers over 3 years (CAGR = 65.10%).
Real Estate Appreciation: Calculating the annualized capital appreciation of commercial real estate holdings across multi-decade holding periods.

Interpreting CAGR Results & Common Pitfalls

Interpreting CAGR requires understanding the underlying trend behind the number:

Positive CAGR: Indicates that the underlying metric or capital balance experienced continuous net geometric growth over the timeframe.
Negative CAGR: Demonstrates that the asset or business unit suffered net annualized losses. For instance, a capital allocation shrinking from $10,000 to $6,400 over 3 years represents a CAGR of −13.91%.
Flat CAGR (0%): Signifies that the ending value exactly matched the starting value, regardless of intermediate market gyrations.

In our advisory practice at Investec, we frequently observe analysts falling into predictable analytical traps. The primary mistakes to avoid include:

Miscounting the period parameter n (e.g., entering 6 periods for a 5-year span).
Assuming CAGR represents actual year-by-year steady progress rather than an aggregated mathematical abstraction.
Extrapolating historical CAGR indefinitely into future projections without accounting for market saturation or competitive pressure.

Limitation: CAGR Smooths Volatility

Volatility is the degree of variation in trading prices or performance metrics over time. The greatest inherent limitation of CAGR is that it completely smooths out volatility. Consider an investment that moves from $100 to $200 in Year 1, drops to $50 in Year 2, and recovers to $150 in Year 3. The calculated 3-year CAGR is 14.47%. While this rate accurately reflects the final destination, it completely masks the extreme drawdown risk experienced during Year 2.

Advanced Use: When to Use IRR Instead of the CAGR Formula

CAGR is ideal for evaluating “buy-and-hold” lump-sum investments with no intermediate cash adjustments. However, when an investor regularly injects fresh capital, receives dividend payouts, or sells partial stakes, CAGR breaks down. The Internal Rate of Return (IRR) is an advanced financial metric that calculates the annualized discount rate that equates the net present value of all intermediate cash flows to zero. As noted in guidelines from the CFA Institute, when interim cash inflows and outflows occur, IRR must be used instead of CAGR to capture the true dollar-weighted performance of the portfolio.

Preparing a valuation, a growth plan or an acquisition case? An early conversation with our team costs nothing.

Contact our team

Conclusion & Strategic Summary

The compound annual growth rate formula remains an indispensable foundational tool in modern finance. By calculating the geometric mean of growth, CAGR enables analysts, business owners, and investors to evaluate historical performance, benchmark competing opportunities, and formulate 2026 strategic plans without being misled by short-term market noise or simple arithmetic averages.

However, successful financial management requires recognizing CAGR’s boundaries. While it excels at providing a clear baseline for lump-sum investments and revenue trends, it must be paired with volatility metrics and IRR when analyzing complex cash flow streams. Incorporating CAGR into your analytical toolkit ensures more rigorous valuation, clearer investor communications, and better-informed financial decision-making for 2026 and beyond.