CAGR Calculator

Growing from to over years is a compound annual growth rate (CAGR) of 12.14%, or 150% in all.

Start over
Spreadsheet

Free calculator by ROI.fyi

What CAGR tells you

CAGR, the compound annual growth rate, is the steady yearly rate that turns a starting value into an ending value over a set number of years. Real growth is never steady, so CAGR smooths out the bumps into one number you can compare. Our example grows $10,000 to $25,000 in 8 years. That is 150% growth in all, or a CAGR of 12.14% a year.

The formula is CAGR = (ending value / starting value)^(1 / years) - 1. Here, 25,000 / 10,000 = 2.5, and 2.5 raised to the power of 1/8 is 1.1214, so the rate is 12.14%. Dividing the 150% by 8 years gives 18.75%, which overstates the rate because it ignores that each year's growth builds on the last.

Under the result, the calculator shows how that rate compares with every 8-year run of the S&P 500 since 1872, with dividends reinvested. At 12.14% a year, the example beats about 67% of them. The table shows what the CAGR becomes if the ending value comes in 10% lower or higher, or the growth takes a year more or less. Ending at $22,500 instead drops it to 10.67%.

Use CAGR for anything that starts at one value and ends at another: an investment, a company's revenue, a home's price or a city's population. It doesn't fit money added or taken out along the way. For a balance with regular deposits, use the rate of return calculator, and for uneven cash flows, the IRR calculator.

The CAGR formula

\text{CAGR} = \left(\frac{\text{Ending value}}{\text{Starting value}}\right)^{1/\text{years}} - 1

Frequently Asked Questions

How do you calculate CAGR?

Divide the ending value by the starting value, raise the result to the power of 1 divided by the number of years, then subtract 1. For $10,000 that grows to $25,000 in 8 years: 25,000 / 10,000 = 2.5, 2.5^(1/8) = 1.1214, and 1.1214 - 1 = 12.14% a year.

How do I calculate CAGR in Excel?

Put the starting value in A1, the ending value in B1 and the years in C1. Then enter =(B1/A1)^(1/C1)-1 and format the cell as a percentage. Excel's RRI function gives the same answer: =RRI(C1, A1, B1). With dates instead of years, use =(B1/A1)^(365/(end date - start date))-1.

What is a good CAGR?

It depends on what you measure. For a stock portfolio, the S&P 500 has returned a median of about 10% a year with dividends over long stretches, so that is the bar to beat. A mature company growing revenue 5% to 10% a year is doing well, while a young company may need 20% or more. Always compare a CAGR with something of similar risk.

What is the difference between CAGR and average annual return?

The average annual return adds up each year's return and divides by the number of years. CAGR is the one steady rate that gets you to the same ending value. Ups and downs make the average higher than CAGR: +50% then -50% averages 0%, but $100 ends at $75, a CAGR of -13.4%. Our annualized return calculator shows both from a list of yearly returns.

Can CAGR be negative?

Yes. If the ending value is below the starting value, CAGR is negative. A $10,000 investment that falls to $8,000 over 3 years has a CAGR of -7.17% a year. If the ending value is zero, CAGR is -100%. The formula can't handle a starting value of zero or below, because there is nothing to grow from.

What are the limits of CAGR?

CAGR ignores the path. Two investments with the same 10% CAGR can have very different rides, and one may have dropped 40% along the way. It also uses only the first and last values, so a strong or weak final year can swing the result. It doesn't account for money added or taken out, and it says nothing about risk.

Is CAGR the same as IRR?

They match when you put money in once and take it out once. IRR also handles cash flows at different times, such as yearly deposits or dividends paid out, and finds the rate that makes them all break even. When cash moves in and out between the start and the end, IRR is the right measure.

How do you calculate CAGR for months instead of years?

Turn the months into years. 18 months is 1.5 years, so for $10,000 to $12,000 in 18 months: (12,000 / 10,000)^(1 / 1.5) - 1 = 12.92% a year. You can type a decimal number of years in the calculator above. Be careful annualizing very short periods, since a few good weeks can turn into a huge yearly figure.

What is revenue CAGR?

It is the CAGR of a company's sales. A business with $2 million in revenue in 2021 and $3.5 million in 2026 grew at (3.5 / 2)^(1/5) - 1 = 11.84% a year. Investors use it to compare growth across companies of different sizes. The same formula works for profits, customers or any other figure that grows over time.

How do you find the ending value from a CAGR?

Multiply the starting value by (1 + CAGR) raised to the number of years. $10,000 at 12.14% for 8 years is 10,000 x 1.1214^8 = $25,000. The year-by-year table under the calculator does this for every year, so you can see where the value would be at each point if it grew at a steady rate.

More return and interest calculators

Measure a return

Turn a result into a yearly rate: CAGR, a run of yearly returns, deposits along the way or uneven cash flows.

Plan a project

What future money is worth today, when a project pays back and how much you need to sell to break even.

Grow savings

What a balance becomes with compounding, an APY, monthly deposits and inflation.

Rates & APR

Simple interest, the rate between two amounts, or what a loan really costs with its fees.