Year-over-Year (YoY) Growth

As shown above, the current period amount is divided by the prior period amount, and then one is subtracted to get to a percentage rate.

For example, if a company’s revenue has grown from $25 million to $30 million, then the formula for the YoY growth rate is:

• Year-over-Year (YoY) Growth = ($30 million / $25 million) – 1 = 20.0%

Alternatively, another method to calculate the YoY growth is to subtract the prior period balance from the current period balance, and then divide that amount by the prior period balance.

• Year-over-Year (YoY) Growth = ($30 million – $25 million) / $25 million = 20.0%

Under either approach, the YoY growth rate comes out to 20.0%.

Interpreting Year-over-Year Growth Analysis

The main benefit of YoY growth analysis is how easy it is to track and compare the growth rates across several periods, which if annualized, removes the impact of monthly volatility.

Plus, any cyclical patterns will become apparent if the historical results reflect a full economic cycle.

While the intuition is easy to grasp for the two basic rules, you must perform deeper diligence into the company’s growth trajectory to identify the core underlying drivers behind the change before arriving at a definitive conclusion.

• Increased YoY Growth → Positive
• Decreased YoY Growth → Negative

To provide a brief example, consider a company whose revenue growth rate in the past year was 5%, but the growth rate is only 3% in the current year.

However, the quality of the revenue being generated could have improved despite the slightly lower growth rate (e.g. long-term contractual revenue, less churn, fewer customer acquisition costs).

It would be incorrect to assume that the current year was necessarily “worse” than the prior year without a deeper dive analysis.

In addition, another important consideration is that growth inevitably slows down eventually for all companies.

Mature companies with established market shares are less likely to fund growth and instead are more inclined to focus on:

• Issuing Dividends to Shareholders
• Improving Operational Efficiency
• Existing Customer Retention vs New Customer Acquisitions

Year-over-Year (YoY) Growth Excel Template

Now that we’ve defined the purpose of year-over-year (YoY) growth analyses, we can move on to a simple modeling exercise in Excel. To access the model template, fill out the form below:

Submit

Email provided

Your Download is Ready

Submitting ...

Year-over-Year (YoY) Growth Example Calculation

For our model, we’ll be assessing the annual growth rate for the following two metrics:

1. Revenue (i.e. Sales)
2. Operating Income (EBIT)

First, we’ll begin by projecting the revenue and EBIT of our company based on the provided assumptions.

Model Assumptions

• Revenue YoY Growth: +4%
• EBIT YoY Growth: -3%

If we multiply the prior period balance by (1 + growth rate assumption), we can calculate the projected current period balance.

Once we perform the same process for revenue in all forecasted periods, as well as for EBIT, the next part of our modeling exercise is to calculate the YoY growth rate.

Here, by dividing the current period amount by the prior period amount and then subtracting 1, we arrive at the implied growth rate.

In Year 1, we divide $104m by $100m and subtract one to get 4.0%, which reflects the growth rate from the preceding year.

• Compound Annual Growth Rate (CAGR)
• Bottoms-Up Forecasting
• Top-Down Forecasting
• LTM vs NTM Multiples