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

$
$
Time between them
years
months
Adjust for inflation See your real growth after rising prices
%
Use the average yearly inflation rate for the same period and country

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 result — Enter your numbers, then press Calculate to see your results.
—
—
—

Growth path At CAGRActual

Same result in Excel or Google Sheets

Show the working
    How to use it

    Three ways to use this CAGR calculator

    Pick the tab that matches the question you are trying to answer.

    1. 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. 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. 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.

    CAGR explained

    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

    Year 0$10,000
    Year 1$11,000
    Year 3$13,310
    Year 5$16,105

    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.

    The formula

    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

    CAGR = (End ÷ Start)1 ÷ n − 1

    Reverse CAGR: future value

    End = Start × (1 + CAGR)n

    Years needed to reach a target

    n = ln(End ÷ Start) ÷ ln(1 + CAGR)

    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%
    Spreadsheets

    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.

    FormulaWhat it doesWorks in
    =RRI(D2, B2, C2)Built in growth rate function. The shortest option.Excel 2013 and later, Google Sheets
    =(C2/B2)^(1/D2)-1The 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)^D2Reverse 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.

    The average return trap

    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.

    Simple average return0%(+50% − 50%) ÷ 2. Looks like you broke even.
    CAGR−13.40%(75 ÷ 100)1 ÷ 2 − 1. You lost a quarter of your money.

    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.

    Related measures

    CAGR vs XIRR, and real CAGR after inflation

    CAGRXIRRReal CAGR
    Use it forOne start value and one end valueMoney added or withdrawn at different dates, like monthly investmentsGrowth after removing the effect of inflation
    NeedsStart, end, yearsEvery cash flow with its dateCAGR and the average inflation rate
    Formula(End ÷ Start)1 ÷ n − 1Excel =XIRR(values, dates)(1 + CAGR) ÷ (1 + inflation) − 1
    Example$10,000 to $16,105 in 5 years: 10%Monthly deposits into a fund8% 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.

    Quick chart

    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).

    CAGRRule of 72 estimateExact years to doubleValue of $10,000 after 10 years
    3%24.023.4$13,439
    5%14.414.2$16,289
    7%10.310.2$19,672
    8%9.09.0$21,589
    10%7.27.3$25,937
    12%6.06.1$31,058
    15%4.85.0$40,456
    20%3.63.8$61,917
    Avoid these

    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.

    From the accounts side

    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 .

    FAQ

    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.

    Need a calculator we do not have yet?

    Tell us what you work out by hand, and we may build it next.

    Suggest a calculator