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.
| Sector | US companies | Median, US | Middle half, US | Median, worldwide |
|---|---|---|---|---|
| Healthcare | 804 | 11.2% | -0.3% to 29.7% | 9.4% |
| Technology | 758 | 9.7% | 2.8% to 23.1% | 8.6% |
| Financial Services | 804 | 9.1% | 4.8% to 17.6% | 7.7% |
| Real Estate | 251 | 8% | 3.2% to 15.6% | 6.2% |
| Consumer Cyclical | 511 | 6.4% | 1.8% to 15.5% | 5.2% |
| Communication Services | 223 | 6.4% | 1% to 16.7% | 4.7% |
| Industrials | 640 | 5.8% | 1.5% to 12.6% | 5.9% |
| Utilities | 116 | 4.7% | 2.1% to 7.8% | 5.3% |
| Consumer Defensive | 227 | 4.6% | 0.9% to 10.7% | 4.8% |
| Energy | 233 | 4.1% | -3.4% to 17.7% | 3.1% |
| Basic Materials | 232 | 3.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.
| Industry | Last 5 years, US | Last 5 years, worldwide | Next 5 years, US |
|---|---|---|---|
| Basic Materials | |||
| Precious Metals | 46.0% | 37.5% | 19.3% |
| Chemical (Basic) | 13.9% | 10.2% | 15.0% |
| Steel | 11.4% | 11.4% | 4.9% |
| Metals & Mining | 8.7% | 25.6% | 34.4% |
| Chemical (Specialty) | 8.0% | 10.5% | 7.6% |
| Building Materials | 4.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 TV | 26.9% | 4.3% | −0.4% |
| Advertising | 17.7% | 7.7% | 9.2% |
| Software (Entertainment) | 16.7% | 16.5% | 7.8% |
| Entertainment | 16.4% | 9.9% | 7.2% |
| Telecom Services | 13.6% | 7.3% | 20.4% |
| Broadcasting | 8.4% | 4.4% | 1.6% |
| Telecom (Wireless) | 3.7% | 5.0% | −20.3% |
| Publishing & Newspapers | 0.0% | 3.1% | 3.2% |
| Consumer Cyclical | |||
| Hotel/Gaming | 21.8% | 18.4% | 8.8% |
| Auto Parts | 15.9% | 11.6% | 6.0% |
| Retail (Automotive) | 15.4% | 11.0% | 2.2% |
| Restaurant/Dining | 13.9% | 8.9% | 11.3% |
| Shoe | 12.4% | 6.4% | 2.6% |
| Homebuilding | 9.9% | 7.2% | 2.3% |
| Recreation | 9.1% | 8.8% | 0.6% |
| Auto & Truck | 8.6% | 14.2% | 10.3% |
| Apparel | 8.1% | 9.6% | 1.6% |
| Retail (Special Lines) | 7.0% | 8.6% | 0.1% |
| Packaging & Container | 4.7% | 7.9% | 2.2% |
| Home Furnishings | 1.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/Agriculture | 14.0% | 14.8% | 0.9% |
| Food Wholesalers | 13.3% | 17.6% | 3.0% |
| Retail (General) | 9.9% | 2.5% | 4.0% |
| Beverage (Soft) | 8.6% | 11.5% | 5.0% |
| Household Products | 8.1% | 8.2% | 4.3% |
| Education | 7.7% | 16.2% | 4.8% |
| Food Processing | 7.2% | 9.7% | 1.9% |
| Beverage (Alcoholic) | 3.4% | 8.6% | 0.4% |
| Tobacco | 2.9% | 19.8% | 2.4% |
| Retail (Grocery and Food) | −2.6% | 5.5% | 3.2% |
| Energy | |||
| Oil/Gas Distribution | 20.1% | 9.6% | 6.2% |
| Coal & Related Energy | 19.2% | 14.2% | 93.2% |
| Oil/Gas (Production and Exploration) | 17.6% | 22.5% | 5.7% |
| Oilfield Services & Equipment | 10.8% | 11.6% | 5.0% |
| Oil/Gas (Integrated) | 4.6% | 10.3% | −0.3% |
| Financial Services | |||
| Brokerage & Investment Banking | 35.5% | 20.6% | 5.7% |
| Insurance (General) | 11.8% | 11.4% | 8.3% |
| Financial Services (Non-bank) | 11.3% | 17.0% | 6.4% |
| Reinsurance | 9.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 Management | 5.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 Products | 18.4% | 14.9% | 34.7% |
| Hospitals/Healthcare Facilities | 15.9% | 14.3% | 3.8% |
| Healthcare Information and Technology | 15.6% | 13.0% | 7.4% |
| Healthcare Support Services | 13.1% | 9.9% | 6.2% |
| Industrials | |||
| Air Transport | 47.8% | 20.6% | 24.9% |
| Environmental & Waste Services | 21.7% | 12.3% | 19.9% |
| Electrical Equipment | 19.2% | 12.3% | 27.3% |
| Construction Supplies | 13.7% | 10.7% | 60.8% |
| Engineering/Construction | 11.7% | 10.4% | 6.3% |
| Aerospace/Defense | 11.1% | 10.0% | 19.8% |
| Machinery | 10.4% | 8.7% | 9.8% |
| Retail (Distributors) | 10.1% | 17.0% | 5.7% |
| Transportation | 9.1% | 8.4% | 27.2% |
| Diversified | 8.9% | 15.3% | 2.5% |
| Office Equipment & Services | 8.1% | 4.7% | 5.3% |
| Information Services | 6.8% | 10.5% | 2.1% |
| Business & Consumer Services | 5.8% | 8.3% | 2.5% |
| Transportation (Railroads) | 4.9% | 6.7% | 3.5% |
| Trucking | 3.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% |
| REITs | 12.6% | 11.5% | 3.0% |
| Real Estate (General/Diversified) | 9.6% | 11.7% | |
| Technology | |||
| Computer Services | 27.1% | 13.6% | 19.5% |
| Software (System & Application) | 19.6% | 14.8% | 12.3% |
| Semiconductor | 11.2% | 7.8% | 11.7% |
| Semiconductor Equipment | 9.4% | 11.1% | 10.0% |
| Electronics (General) | 7.3% | 6.8% | 13.8% |
| Computers/Peripherals | 6.7% | 3.3% | 9.9% |
| Telecom Equipment | 3.3% | 5.2% | 11.7% |
| Electronics (Consumer & Office) | −3.5% | 4.9% | 3.5% |
| Utilities | |||
| Green & Renewable Energy | 17.1% | 15.5% | 9.4% |
| Utility (Water) | 13.3% | 6.1% | 11.9% |
| Power | 6.7% | 10.2% | 3.8% |
| Utility (General) | 5.3% | 7.5% | 2.4% |
| All industries | 12.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.