Can I use CAGR to forecast?

Asked by: Natasha Cruickshank  |  Last update: May 10, 2026
Score: 5/5 (3 votes)

Also, the CAGR can be used for the forecasting of future growth rates. However, one should be careful in using the compound growth rate in financial analysis. The metric smooths the historical data, omits the effect of volatility, and implies the steady growth of the data series.

When should you not use CAGR?

CAGR limitations to keep in mind
  1. It doesn't account for investment volatility. ...
  2. It doesn't account for added funds in an investment portfolio. ...
  3. It can only be used to compare identical time periods. ...
  4. It is less reliable for shorter investment periods.

How to apply CAGR to forecast in Excel?

Here are the steps you can take in Excel:
  1. Gather your Start and End Values. Start Value: $1,000. ...
  2. Calculate the Number of Periods. Periods are the # of years between the start and end dates. ...
  3. Plug in the values to our CAGR formula. CAGR = (1,330 / 1,000)^(1/3) – 1.
  4. Enter the formula in Excel. ...
  5. Format the result as a percentage.

How to use growth rate to forecast?

To forecast future revenues, take the previous year's figure and multiply it by the growth rate.

What can you use CAGR for?

It measures a smoothed rate of return. Investors can compare the CAGR of two or more alternatives to evaluate how well one stock performed against other stocks in a peer group or a market index. CAGR is thus a good way to evaluate how different investments have performed over time, or against a benchmark.

When to use CAGR for forecasting? | Advantages and disadvantages

37 related questions found

Can you use CAGR for forecasting?

Also, the CAGR can be used for the forecasting of future growth rates. However, one should be careful in using the compound growth rate in financial analysis. The metric smooths the historical data, omits the effect of volatility, and implies the steady growth of the data series.

Is CAGR a good indicator?

However, CAGR is a good indicator of overall scheme performance. You can compare CAGRs of different mutual fund schemes and make informed investment decisions. You should consult with your financial advisor if required.

What is the best forecasting method and why?

A causal model is the most sophisticated kind of forecasting tool. It expresses mathematically the relevant causal relationships, and may include pipeline considerations (i.e., inventories) and market survey information. It may also directly incorporate the results of a time series analysis.

What can growth rate be used to estimate?

Growth rates are used to express the annual change in a variable as a percentage. A positive growth rate indicates a variable is increasing over time; a negative growth rate indicates that it is decreasing. Growth rates can be beneficial in assessing a company's performance and predicting future performance.

How to do a forecast calculation?

A sales forecast formula is a math equation you use to predict how much money your customers will spend in the future. How do you calculate it? Simply multiply the number of customers you expect to do business with next month (or quarter or year) by how much money they'll spend on your products and services.

What is the difference between growth rate and CAGR?

Unlike the growth rate, which merely examines the percentage change in an investment's Value over a set period, CAGR provides a more nuanced insight. CAGR assesses and compares investments by calculating the average annual growth rate over a period, capturing the compounding impact for a comprehensive view.

How do you calculate projected CAGR?

To calculate the compounded annual growth rate on investment, use the CAGR calculation formula and perform the following steps:
  1. Divide the investment value at the end of the period by the initial value.
  2. Increase the result to the power of one divided by the tenure of the investment in years.
  3. Subtract one from the total.

How do you add CAGR to a graph?

Add CAGRs to chart and move between columns
  1. Right click on the chart and select 'Add CAGR'
  2. Move a CAGR by dragging a handle into position.
  3. Add a CAGR to specific columns, by selecting one segment on each column, right click and select 'Add CAGR'

What is a drawback of CAGR?

Disadvantage of CAGR: Smoothing and Risk

One disadvantage of the Compound Annual Growth Rate is that it assumes growth to be constant throughout the investment's time horizon. This smoothing mechanism may yield results that differ from the actual situation with a highly volatile investment.

What is the CAGR rule?

Calculate the total number of years or periods over which the growth occurred. Use the formula: CAGR = (Ending Value / Starting Value) ^(1 / Number of Years) – 1. Multiply the result by 100 to express the CAGR as a percentage.

How to use CAGR to calculate future value?

The formula to calculate CAGR divides the future value (FV) by the present value (PV), raises the figure to one divided by the number of compounding periods, and subtracts by one. Note: The difference between the CAGR formulas is merely the usage of financial jargon in the latter.

How to calculate forecast growth rate?

To calculate the percentage growth rate, use the basic growth rate formula: subtract the original from the new value and divide the results by the original value. To turn that into a percent increase, multiply the results by 100.

Can you use CAGR for sales?

The Sales 3 Year Compound Annual Growth Rate, or CAGR, measures the growth rate in sales over the longer run.

What is the rule of 70?

The rule of 70 is used to determine the number of years it takes for a variable to double by dividing the number 70 by the variable's growth rate. The rule of 70 is generally used to determine how long it would take for an investment to double given the annual rate of return.

Which is the #1 rule of forecasting?

RULE #1. Regardless of how sophisticated the forecasting method, the forecast will only be as accurate as the data you put into it. It doesn't matter how fancy your software or your formula is. If you feed it irrelevant, inaccurate, or outdated information, it won't give you good forecasts!

What is the best tool for forecasting?

The Best Forecasting Software And Tools For Finance Teams
  • Anaplan – Enterprise-grade financial forecasting solution. ...
  • Cube – Intuitive corporate budgeting and forecasting platform. ...
  • Adaptive by Workday – Enterprise forecasting solution. ...
  • Datarails – Comprehensive FP&A tool for forecasting.

What are the 2 main methods of forecasting?

Most businesses aim to predict future events so they can set goals and establish plans. Quantitative and qualitative forecasting are two major methods organizations use to develop predictions. Understanding how these two types of forecasting vary can help you decide when to use each one to develop reliable projections.

Why use CAGR instead of average?

CAGR is the best formula for evaluating how different investments have performed over time. It helps fix the limitations of the arithmetic average return. Investors can compare the CAGR to evaluate how well one stock performed against other stocks in a peer group or against a market index.

Is a CAGR of 7% good?

Usually, anything under an 8% CAGR is poor, but a good rate really does depend on the specific organisation. For example, companies who have been around for 10 or more years may see a CAGR of 8%-12% which is a good rate of sales for the amount of time they have been in business.

What does CAGR tell you?

CAGR stands for Compound Annual Growth Rate. It is a way to measure how an investment or business has grown over a specific period of time. It takes into account the effect of compounding, which means that the growth builds upon itself.