YoY % Change Formula & How to Calculate It
- Absolute change
- Result
- Earlier value
- 1000
- You entered
- Later value
- 1250
- You entered
This calculator works out the year-over-year (YoY) percentage change between two values, such as revenue, website traffic, or any metric you compare across a 12-month gap. You enter the earlier period’s value and the later period’s value, and you get the percentage change, showing whether it grew or shrank and by how much. The result is a single number that tells you the relative difference, which is far more useful than the raw difference when comparing metrics of different sizes.
Formula
The year-over-year percentage change is calculated with this standard formula:
YoY % Change = ((Later Value − Earlier Value) / Earlier Value) × 100
Where:
- Earlier Value – the value from the previous year (or previous period) – any unit (dollars, units, visits, etc.)
- Later Value – the value from the current year – same unit as the earlier value
- YoY % Change – the percentage increase (positive) or decrease (negative) from the earlier to the later value
If the result is positive, the metric grew; if negative, it declined. A result of 0% means no change. The formula works for any pair of numbers, but it is most meaningful when the earlier value is not zero (division by zero is undefined).
Worked Example
Using the calculator’s default values: earlier value = 1000, later value = 1250.
- Subtract the earlier value from the later value: 1250 − 1000 = 250
- Divide that difference by the earlier value: 250 ÷ 1000 = 0.25
- Multiply by 100 to get a percentage: 0.25 × 100 = 25%
So the YoY change is 25%. The absolute change is 250 units. This matches the calculator’s output for the same inputs.
Why Use Year-Over-Year Instead of Month-over-Month?
Year-over-year comparisons are popular because they automatically smooth out seasonal patterns. For example, a retailer’s sales in December are usually much higher than in February. Comparing December of this year to November of this year would show a huge jump that has nothing to do with business performance – it’s just the holiday season. Comparing December to last December removes that seasonal noise, giving a clearer picture of true growth or decline.
YoY is also useful for metrics that have natural cycles, such as tourism, agriculture, or any business with quarterly or annual rhythms. It answers the question: “How are we doing compared to the same point last year?� That is often more relevant than a sequential month-over-month change, which can be misleading due to calendar effects.
How to Interpret the Result
A positive YoY % change means the later value is higher than the earlier value. For instance, a 25% increase in revenue means you earned 25% more than you did in the same period last year. A negative result means a decline – e.g., −10% indicates a 10% drop. The magnitude of the percentage tells you the size of the change relative to the base.
Be careful when the earlier value is small. A change from 10 to 20 is a 100% increase, which sounds dramatic, but the absolute difference is only 10 units. Conversely, a change from 10,000 to 10,500 is only 5%, but the absolute difference is 500 units. Always consider both the percentage and the raw difference when evaluating significance.
Also note that the percentage change is not symmetric: a 50% increase followed by a 50% decrease does not bring you back to the original value. For example, 100 increased by 50% is 150, then decreased by 50% is 75 – a net loss of 25%. This is a common trap when interpreting successive changes.
Common Mistakes and Pitfalls
- Using the wrong base – The denominator must be the earlier value, not the later value. Swapping them gives a different percentage.
- Mixing units – Both values must be in the same unit. Comparing dollars to thousands of dollars will give a wildly wrong result.
- Ignoring zero or negative bases – If the earlier value is zero, the formula is undefined. If it’s negative, the percentage change can be confusing (e.g., from −10 to −5 is a 50% increase, but the values are still negative).
- Rounding too early – Round only the final result, not intermediate steps, to avoid accumulating errors.
- Forgetting to multiply by 100 – The formula gives a decimal; you must multiply by 100 to express it as a percentage.
When YoY Is Not the Best Choice
Year-over-year is ideal for stable, recurring metrics. However, for rapidly changing situations, month-over-month or quarter-over-quarter might be more responsive. For example, if you launch a new product and want to see immediate traction, comparing to last month is more relevant than comparing to last year, because last year’s baseline may not reflect current market conditions.
YoY also fails when the earlier period is atypical – such as a year with a major disruption (e.g., a natural disaster or a pandemic). In such cases, the comparison may be misleading because the baseline is abnormal. Some analysts use a “two-year stack� (comparing to two years ago) to smooth out such anomalies.
Frequently Asked Questions
What if the earlier value is zero?
If the earlier value is zero, the formula divides by zero, which is undefined. In practice, you cannot calculate a meaningful percentage change from zero. Instead, report the absolute change or state that the metric went from zero to a positive number, which is an infinite percentage increase conceptually.
Can YoY be negative?
Yes, the result can be negative, indicating a decrease. For example, if last year’s value was 200 and this year’s is 150, the YoY change is ((150−200)/200)×100 = −25%. A negative percentage means the later value is lower than the earlier value.
How is YoY different from QoQ?
YoY compares the same period in consecutive years (e.g., Q3 2024 vs. Q3 2023). QoQ (quarter-over-quarter) compares consecutive quarters (e.g., Q3 2024 vs. Q2 2024). QoQ is more volatile and sensitive to seasonal changes, while YoY smooths out seasonality.
Does YoY use the exact same calendar dates?
Typically, yes – you compare the same months or quarters. For example, January 2024 to January 2025. This ensures that any seasonal effects are aligned. Some companies use a 52-week comparison to avoid calendar quirks like leap years, but the standard is same-month comparison.
What does a 100% YoY increase mean?
A 100% increase means the later value is double the earlier value. For example, from 50 to 100 is a 100% increase. It’s a common benchmark for “doubling� in business metrics.
Can I use this formula for any time period?
Yes, the mathematical formula works for any two values, regardless of time span. However, it is specifically called “year-over-year� when the two periods are exactly one year apart. For other spans, you’d call it month-over-month or quarter-over-quarter, but the calculation is identical.
Related
Formula used
in a | Earlier value | - | 1000 | 0 in b | Later value | - | 1250 | 0 out pct | YoY % change | % | (b - a) / a * 100 | 2 out diff | Absolute change | - | b - a | 2
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.