To calculate 3-year growth, you find the growth rate for each year individually using the standard YOY formula: [(Current Year Value - Previous Year Value) / Previous Year Value] * 100, then you can average these percentages for an average YOY growth, or calculate the Compound Annual Growth Rate (CAGR) for a single, smoothed rate over the three years by finding the Nth root (where N=3) of the total growth factor, providing a comprehensive view of the multi-year trend.
To calculate the growth rate, take the current value and subtract that from the previous value. Next, divide this difference by the previous value and multiply by 100 to get a percentage representation of the rate of growth.
Calculating percentage increase
Determine the number of years: Calculate the number of years between the starting and ending values. Apply the CAGR formula: Use the following formula to calculate the CAGR: CAGR = (Ending Value / Starting Value)^(1/n) – 1 Where: Ending Value = The final value in the time period.
The standard formula looks like this:
Revenue growth calculates by dividing the end revenue by start, then raising to power of 1/years. The example shows a 3-year compound annual growth rate of 14.5% using exponent and subtraction methods. Verify growth by recalculating yearly results; adjust the time frame by changing the exponent's denominator.
Calculating Annualized Returns
If you simply divide the total return of 25.7 percent by three years, the result would be 8.57 percent. This inflated view is known as a simple average, which doesn't take compounding into consideration. Calculating an annualized return gives you a more accurate measure of performance.
Calculate the YOY growth rate for each year by using the formula: ((Current Year Value – Previous Year Value) / Previous Year Value) x 100. Sum the YOY growth rates calculated for each period. Divide the total sum by the number of periods to get the average YOY growth rate.
To calculate Year-over-Year (YoY) growth, you use the formula: (Current Period Value - Previous Period Value) / Previous Period Value * 100, which shows the percentage change from the same period last year, effectively removing seasonality and revealing long-term trends. Simply subtract the prior year's figure from the current year's, divide that difference by the prior year's figure, and multiply by 100 to get your percentage growth rate.
To calculate YoY growth in Excel, use the formula =(Current Value - Previous Value) / Previous Value, referencing your cell data for the current and prior periods, then format the result as a percentage; this shows the growth rate from one year to the next, essential for trend analysis.
The CAGR effectively calculates the annual percentage change between two values but over several periods. The formula for CAGR is: (Ending Value/Beginning Value) ^ (1/No. of Periods) – 1.
To calculate the CAGR of an investment:
Percent change is the relative difference between an old value and a new value. Positive values represent an increase over time, while negative numbers indicate a reduction. For example, if the price of a candy bar changes from $1 to $1.10, it's a 10% increase.
The formula to calculate percentage change is (Final Value – Initial Value) ÷ | Initial Value | × 100 = PERCENTAGE CHANGE. From 2016 to 2021 total circulation of electronic materials more than doubled with a 116% increase.
A solid 3-year business growth plan goes beyond guesswork. It's about defining your business growth strategy, setting clear financial goals, understanding the drivers behind revenue, and ensuring your operations can scale with demand.
For example, if an investor invested $20,000 and receives $25,000 at the end of three years, the investment provided a total return of (25,000 – 20,000) / 20,000 = 0.25 (i.e., 25%). However, it does not consider the period of three years that the investor dedicated to the security.
How to Calculate YOY in Excel
CAGR Formula
YoY growth = (current period value / prior period value) – 1. The values used in this formula depend on the metric you want to calculate. If you're calculating your revenue growth, you'll divide the past year's revenue by the current year's revenue.
How to Calculate Average? We can easily calculate the average for a given set of values. We just have to add all the values and divide the outcome by the number of given values.
To calculate ROI, subtract the investment's total cost from the investment's proceeds or current value. Then, divide that amount by the investment's total cost and multiply the result by 100.
A 3-year annualized return shows the average yearly growth rate of an investment over three years. It reflects the hypothetical annual return if the investment had grown at a constant rate during that period, offering a clearer view of its potential growth.
How to Calculate CAGR in Excel
A = P (1+rt)