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.
What is CAGR? In demand forecasting, CAGR is a useful metric to project the expected growth rate of demand for a product or service over a specified time period. This can help businesses plan for future production needs, inventory levels, and staffing requirements.
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.
Choose a forecasting method
Formula: Sales forecast = total value of current deals in sales cycle x close rate. Best for: Businesses with well-defined sales pipelines and historical data.
Compound Annual Growth Rate or CAGR is the annual growth of your investments over a specific period of time. In other words, it is a measure of how much you have earned on your investments every year during a given interval.
For this method, you assume past growth rates will continue, so you multiply your revenue from the latest year by your company's current growth rate. This means if you want to know your projected revenue for the coming year, you could look at revenue in each of the past two years.
The CAGR formula is equal to (Ending Value/Beginning Value) ^ (1/No. of Periods) – 1.
Average annual growth rate (AAGR) is the average increase. It is a linear measure and does not take into account compounding. Meanwhile, the compound annual growth rate (CAGR) does and it smooths out an investment's returns, diminishing the effect of return volatility.
To calculate CAGR in Excel use the following formula: (Ending Balance/Starting Balance)˄(1/Number of Years) – 1.
The future value formula is FV=PV*(1+r)^n, where PV is the present value of the investment, r is the annual interest rate, and n is the number of years the money is invested. The Excel function FV can be used when there is a constant interest rate.
Absolute return measures the total gain or loss of an investment over a specific period. In contrast, CAGR shows the average annual growth rate, offering a smoother view of performance over time. Absolute return and compound annual growth rate (CAGR) are essential metrics for evaluating investment performance.
If the initial value is negative, the CAGR formula returns a result of "0". This is obviously not a meaningful number as it does not indicate a growth rate.
The traditional formula in Excel for YoY growth is =(C6-C5)/C5 . Apply this formula to compare the data from the current year (C6) against the previous year (C5) and derive the growth percentage.
Forecasting future values based on the CAGR of a data series (you find future values by multiplying the last datum of the series by (1 + CAGR) as many times as years required). As with every forecasting method, this method has a calculation error associated.
Four of the main forecast methodologies are: the straight-line method, using moving averages, simple linear regression, and multiple linear regression. Both the straight-line and moving average methods assume the company's historical results will generally be consistent with future results.
The formula to calculate the growth rate across two periods is equal to the ending value divided by the beginning value, subtracted by one. For example, if a company's revenue was $100 million in 2023 and grew to $120 million in 2024, its year-over-year (YoY) growth rate is 20%.
By using a reverse CAGR calculator, you provide the initial investment amount and CAGR. Assume initially you invested ₹50,000. This therefore implies that after 5 years at an annual compounded growth rate of 8%, your investment would bring in approximately Rs. 73,467.
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.
Similarly, for small businesses, a CAGR of 15% to 30% is satisfactory. Furthermore, a company's CAGR must be consistent over time.
Multiply your average monthly sales rate by the number of months left in the year to calculate your projected sales revenue for the rest of the year. Add your total sales revenue so far to your projected sales revenue for the rest of the year to calculate your annual sales forecast.
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.
The formula for revenue growth takes your current revenue amount over the specified period and multiplies it by the projected growth rate percentage for every week, month, or year, to determine your revenue projection.