CAGR Calculator with Reverse CAGR and Yearly Growth
Use this free CAGR calculator to find the compound annual growth rate between any two values, project a future value with reverse CAGR, or enter a value for each year to see how your real growth compares with a simple average.
- Free, no sign-upNo sign-up
- Excel formula includedExcel formula
- Every step shownSteps shown
Start value, end value and time
Enter one value per year, such as revenue, profit or a portfolio balance. You need at least two years.
Adjust for inflation See your real growth after rising prices
Have a value for every year? Use Year by year to see how your CAGR compares with the simple average growth, which is often higher than what you really earned.
Your numbers changed. Press Calculate to update the results.
Growth path At CAGRActual
Same result in Excel or Google Sheets
Show the working
Three ways to use this CAGR calculator
Pick the tab that matches the question you are trying to answer.
- 1
Find CAGR
You know where a value started and where it ended. Enter both with the time between them, in years and months or exact dates, to get the compound annual growth rate.
- 2
Reverse CAGR
You know the growth rate and want to plan ahead. Find a future value, the start value you need for a target, or how many years a target will take.
- 3
Year by year
You have a value for every year, like annual revenue. See the CAGR, the growth in each year and how both compare with a simple average.
What is CAGR, and why do people use it?
A plain English guide for investors, business owners, students and finance teams.
CAGR in one sentence
CAGR, or compound annual growth rate, is the steady yearly rate at which a value would have to grow to go from its start value to its end value over a period.
Real growth is rarely steady. A business might grow 20% one year and 2% the next. CAGR smooths those ups and downs into one yearly figure, so you can compare growth across different periods, investments or companies.
It is called compound because each year's growth builds on the year before, just like interest on savings.
How 10% a year compounds
Growth in year 5 is bigger than in year 1, even at the same rate, because it builds on a larger value.
Why people use CAGR
Fair comparisons
Compare an investment held for 3 years with one held for 7, or two companies of different sizes, on the same yearly basis.
Smooths the noise
One good or bad year does not distort the picture. CAGR shows the underlying pace of growth across the whole period.
Honest return figure
Unlike a simple average, CAGR always links the first value to the last one, so it cannot overstate what you really earned.
Planning and targets
Turn a growth target into numbers: what revenue you need in five years, or how long savings take to reach a goal.
Standard in reports
Annual reports, investor decks and board packs use CAGR to show revenue, profit and customer growth over several years.
Quick doubling check
With CAGR you can estimate how long it takes a value to double, using the Rule of 72 or the exact formula shown in this calculator.
Who uses CAGR
Investors
Compare funds, shares and portfolios held over different periods.
Business owners
Track how fast sales, customers or profit have really grown.
Financial analysts
Build forecasts and valuation models from historical growth.
Accountants
Show multi-year revenue and margin trends in client reports.
Founders
Present growth to investors in a format they recognise.
Students
Solve finance and economics questions with every step shown.
Savers
Check what a savings plan or property has returned each year.
Researchers
Measure growth in markets, populations or prices over time.
Where CAGR falls short
- It hides the ride. Two investments with the same CAGR can have very different ups and downs along the way.
- It ignores money added or taken out during the period. For regular deposits or withdrawals, use XIRR instead.
- It depends heavily on the start and end dates. Starting at a low point makes growth look stronger than it was.
- It does not work when the start value is zero or negative, which is common for young companies' profits.
Use CAGR with the year by year numbers, not instead of them. The Year by year tab shows both together.
How to calculate CAGR
Divide the end value by the start value, raise the result to the power of one divided by the number of years, then subtract one.
CAGR formula
Reverse CAGR: future value
Years needed to reach a target
n is the number of years between the two values. For 2021 to 2026, n is 5, not 6.
Worked example
A company's revenue grew from $2.0 million in 2020 to $3.2 million in 2025.
- Growth multiple3.2 ÷ 2.0 = 1.6
- Years (n)2025 − 2020 = 5
- Raise to 1 ÷ 51.60.2 = 1.0986
- CAGR1.0986 − 1 = 9.86%
- Total growth60%
How to calculate CAGR in Excel and Google Sheets
With the start value in B2, the end value in C2 and the number of years in D2, any of these formulas returns the CAGR. Format the cell as a percentage.
| Formula | What it does | Works in |
|---|---|---|
=RRI(D2, B2, C2) | Built in growth rate function. The shortest option. | Excel 2013 and later, Google Sheets |
=(C2/B2)^(1/D2)-1 | The CAGR formula written out by hand. | All versions, Google Sheets |
=RATE(D2, 0, -B2, C2) | Treats growth like an investment with no payments in between. | All versions, Google Sheets |
=B2*(1+E2)^D2 | Reverse CAGR: future value, with the CAGR in E2. | All versions, Google Sheets |
After every calculation, this CAGR calculator also shows the exact Excel formula with your own numbers, ready to copy.
CAGR vs average annual return
A simple average of yearly returns can look healthy even when you lost money. CAGR cannot, because it always connects the first and last values.
You invest $100. In year one it rises 50% to $150. In year two it falls 50% to $75.
This is why fund factsheets and annual reports quote compound or annualised returns. When you have yearly figures, the Year by year tab shows both numbers side by side.
CAGR vs XIRR, and real CAGR after inflation
| CAGR | XIRR | Real CAGR | |
|---|---|---|---|
| Use it for | One start value and one end value | Money added or withdrawn at different dates, like monthly investments | Growth after removing the effect of inflation |
| Needs | Start, end, years | Every cash flow with its date | CAGR and the average inflation rate |
| Formula | (End ÷ Start)1 ÷ n − 1 | Excel =XIRR(values, dates) | (1 + CAGR) ÷ (1 + inflation) − 1 |
| Example | $10,000 to $16,105 in 5 years: 10% | Monthly deposits into a fund | 8% CAGR with 3% inflation: 4.85% |
Open Adjust for inflation in the calculator to see your real CAGR. A real CAGR shows how much your buying power actually grew, which matters more than the headline number over long periods.
How long does it take to double? The Rule of 72
Divide 72 by the yearly growth rate to estimate the years needed to double a value. The exact answer is ln(2) ÷ ln(1 + CAGR).
| CAGR | Rule of 72 estimate | Exact years to double | Value of $10,000 after 10 years |
|---|---|---|---|
| 3% | 24.0 | 23.4 | $13,439 |
| 5% | 14.4 | 14.2 | $16,289 |
| 7% | 10.3 | 10.2 | $19,672 |
| 8% | 9.0 | 9.0 | $21,589 |
| 10% | 7.2 | 7.3 | $25,937 |
| 12% | 6.0 | 6.1 | $31,058 |
| 15% | 4.8 | 5.0 | $40,456 |
| 20% | 3.6 | 3.8 | $61,917 |
Common CAGR mistakes
Counting the years wrong
From the end of 2020 to the end of 2025 is 5 years of growth, not 6. Count the gaps between values, not the values themselves.
Averaging yearly growth
A simple average of +50% and −50% is 0%, but the money fell from $100 to $75. Use CAGR, which links the real start and end values.
Ignoring deposits and withdrawals
If you added money along the way, part of the end value is your own cash, not growth. Use XIRR for investments with regular cash flows.
Picking flattering dates
Starting at a market low or a weak year makes any CAGR look impressive. Check a few different periods before trusting one number.
Using CAGR for revenue and profit growth
In management reports and board packs, CAGR is most useful for showing multi-year trends in revenue, gross profit, customer numbers or EBITDA. A line such as "revenue grew at a 9.9% CAGR from 2020 to 2025" is clearer than five separate growth figures.
Two rules keep it honest. First, measure revenue and profit on the same basis every year, so a change in accounting policy does not look like growth. Second, do not quote a CAGR for profit when the starting profit was very small or negative, because the result becomes meaningless. Show the yearly figures instead, or measure the CAGR of revenue.
How this calculator works
- Uses the standard CAGR, reverse CAGR and real return formulas shown on this page
- Every result checked against hand-worked examples and Excel's RRI function
- Runs in your browser; your numbers are never sent or saved
- For planning and learning only, not financial or investment advice
Built and checked by Ahmad Hussain, AI specialist and finance professional. Last reviewed .
CAGR calculator questions
What is a good CAGR?
It depends on what you are measuring and when. The fair test is to compare your CAGR with a benchmark for the same period, such as inflation, a market index or similar businesses. A CAGR that beats inflation means real growth, and one that beats your benchmark means you did better than the alternative.
How do I calculate CAGR?
Divide the end value by the start value, raise the result to the power of one divided by the number of years, then subtract one. For $10,000 growing to $16,105 in 5 years: (16,105 ÷ 10,000)^(1 ÷ 5) − 1 = 10%.
What is reverse CAGR?
Reverse CAGR works the formula backwards. Instead of finding the growth rate, you use a known rate to find a future value, the start value needed for a target, or the number of years a target will take. Future value = start × (1 + CAGR)^years.
Can CAGR be negative?
Yes. If the end value is lower than the start value, CAGR is negative. A fall from $100 to $75 over 2 years is a CAGR of −13.40%, meaning the value shrank by 13.40% a year on average.
How do I calculate CAGR for months or days?
Turn the period into years first. Divide months by 12, or days by 365, then use that number as n in the CAGR formula. This calculator does it for you when you enter years and months or exact dates.
What is the difference between CAGR and average annual return?
A simple average adds up each year's return and divides by the number of years, which ignores compounding and can overstate results. CAGR is the single steady rate that connects the first and last values, so it reflects what you actually earned.
What is the difference between CAGR and XIRR?
CAGR uses only a start value and an end value. XIRR also accounts for money added or withdrawn on different dates, so it is the right measure for regular investments or withdrawals.
Can I calculate CAGR with a negative or zero start value?
No. The formula divides by the start value and takes a root, so it only works when the start value is above zero. For profits that started negative, compare the yearly figures instead, or measure the CAGR of revenue.
How do I calculate CAGR in Excel?
Use =RRI(years, start, end), for example =RRI(5, 10000, 16105), which returns 10%. You can also write =(end/start)^(1/years)-1. Both work in Google Sheets too.
More free business calculators
Markup Calculator
Markup, selling price and real profit after fees and discounts.
Open calculatorBreak Even Calculator
How many units you need to sell before you start making money.
Open calculatorEBITDA Calculator
Operating profit before interest, tax, depreciation and amortisation.
Open calculatorInventory Turnover Ratio
How fast your stock sells, with a free calculator inside the guide.
Read the guideNeed a calculator we do not have yet?
Tell us what you work out by hand, and we may build it next.