Bufetico Join the waitlist

CAGR calculator

Find out how fast something really grew each year, before and after inflation. Paste a whole series and see what one bad year does to the rate.

Want these tools on your phone? They’re coming to the Bufetico app. Join the waitlist »

bufetico.com/tools/cagr-calculator ·

An educational tool, not investment advice. The result comes from the numbers you put in and, if you pick them, US consumer prices. The page shows it next to S&P 500 history and Bufetico’s sector data.

Your numbers

What it was at the start: a price, sales, a portfolio.

What it was at the end.

Decimals work: 18 months is 1.5.

The total you got in cash. Leave it empty for the price alone.

Or use two dates
%

2% is the Fed’s target in the US. Leave it empty to skip it. With US prices between your dates, this rate only covers the months after the latest data.

US prices only work with USD as the currency and dates.

From Bufetico’s data on US companies.

In the second tab, the comparison uses the same years as your series.

Your growth rate

7.18% a year

From 10,000 to 20,000 in 10 years: 2 times the start, a 100% change in total.

(20,000 / 10,000)^(1 / 10) - 1 = 7.18%

Take out 2% a year for inflation and it’s 5.08% a year in what the money buys.

At that rate it doubles about every 10 years.

From the end of 2015 to the end of 2025, the S&P 500 returned 14.68% a year with dividends put back in, and 12.85% on price alone.

Your rate is lower than the S&P 500 with dividends.

S&P 500 data: Aswath Damodaran, NYU Stern, updated January 2026. S&P 500 is a registered trademark of Standard & Poor’s Financial Services LLC, and the index is a product of S&P Dow Jones Indices LLC. Bufetico isn’t affiliated with them or endorsed by them.

Year by year at that rate

YearValue
010,000
110,717.73
211,486.98
312,311.44
413,195.08
514,142.14
615,157.17
716,245.05
817,411.01
918,660.66
1020,000

Did you add or take out money along the way? Then this rate mixes that money with the growth. The third tab counts each deposit and withdrawal on its date.

How this calculator works

CAGR stands for compound annual growth rate. It’s the one steady yearly rate that takes you from the start value to the end value. Divide the end by the start, raise it to the power of one over the number of years, and subtract one: CAGR = (end / start)^(1 / years) - 1.

With the numbers already in the boxes, 10,000 that became 20,000 in 10 years grew 7.18% a year. Take out 2% a year for inflation and it’s 5.08% a year in what the money buys.

The first tab also works backward: give it a rate and it finds the end value, the years or the start value. In the second tab you paste the value for every year. It works out the rate from the first to the last, and next to it the median and the average of each year’s change. That’s where you see it if the first or the last year was a bad one.

Why the average lies

Say a stock goes up 50% one year and down 50% the next. The average of the two years is zero. But 100 dollars turns into 150 and then 75, so a quarter of the money is gone. The CAGR is about -13.4% a year. When someone quotes you an average return, ask for the CAGR.

When you keep adding money

You probably don’t put money in just once. You add some every month or every year, and take some out now and then. A plain CAGR gets that wrong, because it treats all the money as if it went in on the first day. The third tab counts each deposit and withdrawal on its date and finds the one yearly rate that fits all of them. Spreadsheets call it XIRR. It’s the same math.

In that tab’s example, 1,000 a year for five years ends up worth 6,200. Counting the dates, that’s 7.26% a year. A plain CAGR on the same 5,000 says 4.4%.

The two years you pick decide the answer

A CAGR only looks at two numbers, the first and the last. Everything in between is thrown away. If the last year was a bad one, the rate can say the business is shrinking when it isn’t.

In the second tab there’s a made-up company whose sales grow for nine years and drop in the tenth. From first to last, the rate is 4.61% a year. The median year grew 8.04%. Drop the last year and the rate jumps to 9.39%.

I learned this the hard way. When I measured Amazon’s cash from first to last, my model once said the company was shrinking 21.6% a year. You can read what happened, and the story of a farmer who had the same problem.

How fast sales grow, sector by sector

If you’re measuring a company’s sales, it helps to know what normal looks like. This table comes from Bufetico’s own data on 26,105 companies, measured on 15 October 2026. For each company I take the median of its yearly sales changes over its recent years, so one odd year doesn’t decide. Then I take the company in the middle of each sector.

SectorUS companiesMedian, USMiddle half, USMedian, worldwide
Healthcare80411.2%-0.3% to 29.7%9.4%
Technology7589.7%2.8% to 23.1%8.6%
Financial Services8049.1%4.8% to 17.6%7.7%
Real Estate2518%3.2% to 15.6%6.2%
Consumer Cyclical5116.4%1.8% to 15.5%5.2%
Communication Services2236.4%1% to 16.7%4.7%
Industrials6405.8%1.5% to 12.6%5.9%
Utilities1164.7%2.1% to 7.8%5.3%
Consumer Defensive2274.6%0.9% to 10.7%4.8%
Energy2334.1%-3.4% to 17.7%3.1%
Basic Materials2323.3%-0.7% to 9%4.3%

US means listed on the NYSE or Nasdaq, in dollars. The worldwide column counts 26,105 companies, each in its own currency and before inflation. Debt, return on capital and dividends by sector.

Sales growth in 94 industries

This table shows yearly sales growth over the last five years, and what analysts expect for the next five. Each figure adds up every company in the industry, as of January 2026, so the biggest ones weigh the most. That’s why a figure can sit far from its sector’s median, the company in the middle.

IndustryLast 5 years, USLast 5 years, worldwideNext 5 years, US
Basic Materials
Precious Metals46.0%37.5%19.3%
Chemical (Basic)13.9%10.2%15.0%
Steel11.4%11.4%4.9%
Metals & Mining8.7%25.6%34.4%
Chemical (Specialty)8.0%10.5%7.6%
Building Materials4.1%6.2%3.1%
Chemical (Diversified)1.4%8.7%1.7%
Paper/Forest Products−0.3%6.9%1.7%
Communication Services
Software (Internet)29.2%14.1%17.7%
Cable TV26.9%4.3%−0.4%
Advertising17.7%7.7%9.2%
Software (Entertainment)16.7%16.5%7.8%
Entertainment16.4%9.9%7.2%
Telecom Services13.6%7.3%20.4%
Broadcasting8.4%4.4%1.6%
Telecom (Wireless)3.7%5.0%−20.3%
Publishing & Newspapers0.0%3.1%3.2%
Consumer Cyclical
Hotel/Gaming21.8%18.4%8.8%
Auto Parts15.9%11.6%6.0%
Retail (Automotive)15.4%11.0%2.2%
Restaurant/Dining13.9%8.9%11.3%
Shoe12.4%6.4%2.6%
Homebuilding9.9%7.2%2.3%
Recreation9.1%8.8%0.6%
Auto & Truck8.6%14.2%10.3%
Apparel8.1%9.6%1.6%
Retail (Special Lines)7.0%8.6%0.1%
Packaging & Container4.7%7.9%2.2%
Home Furnishings1.0%5.8%2.4%
Retail (Building Supply)0.7%4.4%3.2%
Rubber & Tires−13.2%9.2%−0.2%
Consumer Defensive
Farming/Agriculture14.0%14.8%0.9%
Food Wholesalers13.3%17.6%3.0%
Retail (General)9.9%2.5%4.0%
Beverage (Soft)8.6%11.5%5.0%
Household Products8.1%8.2%4.3%
Education7.7%16.2%4.8%
Food Processing7.2%9.7%1.9%
Beverage (Alcoholic)3.4%8.6%0.4%
Tobacco2.9%19.8%2.4%
Retail (Grocery and Food)−2.6%5.5%3.2%
Energy
Oil/Gas Distribution20.1%9.6%6.2%
Coal & Related Energy19.2%14.2%93.2%
Oil/Gas (Production and Exploration)17.6%22.5%5.7%
Oilfield Services & Equipment10.8%11.6%5.0%
Oil/Gas (Integrated)4.6%10.3%−0.3%
Financial Services
Brokerage & Investment Banking35.5%20.6%5.7%
Insurance (General)11.8%11.4%8.3%
Financial Services (Non-bank)11.3%17.0%6.4%
Reinsurance9.4%8.3%6.9%
Bank (Money Center)9.1%19.2%3.1%
Insurance (Prop/Cas.)8.8%12.8%5.2%
Banks (Regional)8.1%8.4%17.8%
Investments & Asset Management5.7%17.8%6.4%
Insurance (Life)2.5%6.2%3.2%
Healthcare
Drugs (Biotechnology)28.9%27.5%51.5%
Drugs (Pharmaceutical)18.4%14.1%33.6%
Healthcare Products18.4%14.9%34.7%
Hospitals/Healthcare Facilities15.9%14.3%3.8%
Healthcare Information and Technology15.6%13.0%7.4%
Healthcare Support Services13.1%9.9%6.2%
Industrials
Air Transport47.8%20.6%24.9%
Environmental & Waste Services21.7%12.3%19.9%
Electrical Equipment19.2%12.3%27.3%
Construction Supplies13.7%10.7%60.8%
Engineering/Construction11.7%10.4%6.3%
Aerospace/Defense11.1%10.0%19.8%
Machinery10.4%8.7%9.8%
Retail (Distributors)10.1%17.0%5.7%
Transportation9.1%8.4%27.2%
Diversified8.9%15.3%2.5%
Office Equipment & Services8.1%4.7%5.3%
Information Services6.8%10.5%2.1%
Business & Consumer Services5.8%8.3%2.5%
Transportation (Railroads)4.9%6.7%3.5%
Trucking3.3%7.9%3.8%
Shipbuilding & Marine−0.1%9.8%
Real Estate
Real Estate (Development)28.6%10.9%6.3%
Retail (REITs)13.1%10.1%4.7%
Real Estate (Operations & Services)12.6%10.7%7.5%
REITs12.6%11.5%3.0%
Real Estate (General/Diversified)9.6%11.7%
Technology
Computer Services27.1%13.6%19.5%
Software (System & Application)19.6%14.8%12.3%
Semiconductor11.2%7.8%11.7%
Semiconductor Equipment9.4%11.1%10.0%
Electronics (General)7.3%6.8%13.8%
Computers/Peripherals6.7%3.3%9.9%
Telecom Equipment3.3%5.2%11.7%
Electronics (Consumer & Office)−3.5%4.9%3.5%
Utilities
Green & Renewable Energy17.1%15.5%9.4%
Utility (Water)13.3%6.1%11.9%
Power6.7%10.2%3.8%
Utility (General)5.3%7.5%2.4%
All industries12.8%11.8%15.7%

What a CAGR doesn’t see

Of the things a CAGR misses, these trip people up the most.

  • Money added or taken out. If you kept adding money, the end value includes your deposits, and the rate makes the investment look better than it did. Take money out and it looks worse. That’s what the third tab is for.
  • The ride along the way. Two investments with the same CAGR can feel completely different. One climbs steadily. The other falls by half and comes back. The CAGR doesn’t tell you which one you could have held through. The second tab shows the worst year and how much the years swing.
  • Comparing with the index the wrong way. Most charts of the S&P 500 show the price alone. From the end of 2015 to the end of 2025, leaving out the dividends cost almost two points a year: 14.68% with them, 12.85% on price alone. The first two tabs show both, over the same years as yours.
  • A loss at either end. A growth rate stops working when the first or the last year is below zero. From a loss to a profit, no growth rate means anything.
  • Inflation. 7% a year with 3% inflation is about 4% in what the money buys. That’s why the calculator shows both. For amounts in dollars with dates, it takes how much US prices rose between your dates, from the consumer price index.
  • Currency. Sales reported in another currency can grow just because the exchange rate moved. You can see how much of Inditex’s growth came from the currency.
  • Growth bought, not earned. A company can grow its sales by buying other companies. Home Depot is a good example.

The full list of what I correct in my own numbers is on the Method page.

Questions people ask

How do I calculate CAGR in Excel?

Type =(end/start)^(1/years)-1, or use the RRI function: =RRI(years, start, end). Both give the same number. With deposits on different dates, use XIRR.

What’s the difference between CAGR and XIRR?

A CAGR uses two numbers, a start and an end. XIRR uses every deposit and withdrawal with its date. With a single deposit at the start and nothing taken out, the two give almost the same answer.

What is a good CAGR?

It depends on what you measure. For a stock, compare it with what the whole market did over the same years. For a company’s sales, take out inflation first: sales that grow 3% a year with 3% inflation aren’t really growing.

Can a CAGR be negative?

Yes. It means the value shrank. If 100 becomes 80 in five years, that’s about -4.4% a year.

Can I use months or exact dates?

Yes. Put in the years with decimals (18 months is 1.5), or open “Or use two dates” and the calculator counts the days for you.

Should I include dividends?

For a stock, yes, if you want what you really earned. If you got them in cash, put them in their own box. If they went back into more shares, use what your shares are worth now as the end value. The price alone leaves them out.

How many years should I use?

The more years, the less one odd year can move it. However many years you use, look at the years in between too. I go through how to read a company’s growth in the course.

Before you decide

This calculator is an educational tool. It does the math on the numbers you enter. It also shows data from other sources, like the history of the S&P 500. And it shows figures measured in Bufetico’s own data. This page gives the source and date of each one. That data can have errors and can go out of date. The past doesn’t tell you what comes next. The calculator doesn’t know your situation. Its result is hypothetical and changes with every input. It doesn’t guarantee anything. None of this is investment, tax or legal advice, or a recommendation to buy, hold or sell any security. Neither Bufetico nor JH Grandgerard is a registered investment adviser, a broker or a tax adviser. Bufetico sells a subscription to a stock screener, and this page links to it.

Terms for the free tools

Sold too early, or held on too long?

Join the waitlist and I'll email you when Bufetico opens, plus a new article or tool now and then.

No more than one email a week. You can unsubscribe anytime, and the Privacy Policy explains how we handle your name and email.

Can't tell a cheap stock from a dying one?

The Bufetico Filter checks more than 30,000 companies against six layers and shows you only the ones that pass. You decide how strict each layer is. Bufetico opens soon.

Join the waitlist »