Change Over Year Formula: Calculate YoY Growth

This calculator works out the year-over-year (YoY) percentage change between two values, typically from one year to the next. You enter the earlier value (e.g., last year’s revenue) and the later value (this year’s revenue), and you get the percentage change, which shows whether the value increased or decreased. The result is expressed as a percentage, with positive numbers indicating growth and negative numbers indicating a decline.

Formula

The change over year formula compares a value from one period to the same value from the previous period. It is most commonly called year-over-year (YoY) growth or annual change. The formula is:

Change over year (%) = ((Current Year Value − Previous Year Value) / Previous Year Value) × 100

Where:

• Current Year Value – the value from the more recent period (e.g., this year’s sales).
• Previous Year Value – the value from the same period one year earlier (e.g., last year’s sales).
• Change over year (%) – the percentage increase or decrease from the previous year to the current year.

The same formula works for any time period—month-over-month, quarter-over-quarter, or week-over-week—as long as you compare the same two periods. For example, comparing January 2024 to January 2023 uses the identical calculation.

Worked Example

Let’s use the default values from the calculator: earlier value = 1000, later value = 1200.

1. Subtract the earlier value from the later value: 1200 − 1000 = 200.
2. Divide the difference by the earlier value: 200 ÷ 1000 = 0.2.
3. Multiply by 100 to get a percentage: 0.2 × 100 = 20%.

So the change over year is 20%. The absolute difference is 200. This matches the calculator’s output exactly.

When to Use This Formula

The change-over-year formula is used in finance, economics, retail, and any field that tracks performance over time. It answers questions like:

• Did revenue grow or shrink compared to last year?
• How much did website traffic change year over year?
• What is the annual growth rate of a portfolio or investment?
• How did quarterly profits compare to the same quarter last year?

YoY is particularly useful because it automatically smooths out seasonal patterns. For example, a retail store always sees higher sales in December; comparing December 2024 to December 2023 is more meaningful than comparing December 2024 to June 2024.

How to Read the Result

A positive percentage means the later value is higher than the earlier value—growth. A negative percentage means the later value is lower—a decline. A result of 0% means no change.

For example, if revenue was $500,000 last year and $450,000 this year, the change is ((450,000 − 500,000) / 500,000) × 100 = −10%. That indicates a 10% drop.

Keep in mind that the percentage change depends heavily on the base (earlier) value. A 50% increase from a very small base (e.g., from 2 to 3) is a tiny absolute change, while a 5% increase from a huge base (e.g., from 1,000,000 to 1,050,000) is a large absolute change. Always consider the absolute difference alongside the percentage.

Common Mistakes and Pitfalls

• Reversing the order: The earlier value must be in the denominator. If you swap them, you get a different (and often misleading) result.
• Dividing by the later value: Some people mistakenly use the later value as the denominator. That gives the percentage change relative to the new value, not the original—this is a different metric (often called “percentage of� or “relative change� with a different base).
• Mixing units: Ensure both values are in the same units. If one is in thousands and the other in millions, convert first.
• Ignoring negative bases: If the earlier value is negative (e.g., a loss), the formula still works mathematically, but the interpretation becomes tricky. A change from −100 to −50 is a 50% increase, but the absolute improvement is only 50. In such cases, it’s often clearer to report the absolute difference as well.
• Rounding too early: Round only the final percentage, not intermediate steps, to avoid small errors.

Limits of the Formula

The change-over-year formula is simple and powerful, but it has limitations:

• It only compares two points in time—it doesn’t show trends within the year.
• It is sensitive to the base value. If the base is very small, even a tiny absolute change can produce a huge percentage.
• It does not account for inflation, currency fluctuations, or other external factors. For example, a 5% increase in nominal revenue might actually be a decrease in real terms if inflation was 7%.
• It assumes the earlier value is a valid baseline. If the earlier year was unusually high or low (e.g., a one-time event), the percentage change can be misleading.

For these reasons, analysts often use additional metrics like compound annual growth rate (CAGR) for multi-year trends, or compare YoY changes alongside absolute values.

Alternatives and Related Formulas

Depending on what you need, other formulas may be more appropriate:

• Compound Annual Growth Rate (CAGR): Used when you want the average annual growth rate over multiple years. Formula: ((Ending Value / Beginning Value)^(1 / Number of Years)) − 1.
• Month-over-Month (MoM): Same formula but comparing consecutive months instead of years.
• Quarter-over-Quarter (QoQ): Compares consecutive quarters.
• Percentage Change (general): The same formula works for any two periods, not just years.
• Absolute Change: Simply the difference between the two values (later − earlier), which is useful when percentages are misleading.

For example, if a company’s revenue grew from $1M in 2020 to $1.5M in 2023, the YoY change for each year might vary, but the CAGR over the three-year period is ((1.5/1)^(1/3)) − 1 = 14.47% per year.

Frequently Asked Questions

What is the difference between YoY and QoQ?

YoY compares the same period in two consecutive years (e.g., Q3 2024 vs. Q3 2023). QoQ compares consecutive quarters (e.g., Q3 2024 vs. Q2 2024). YoY is less affected by seasonality, while QoQ can reveal short-term trends but may be distorted by seasonal patterns.

Can I use this formula for negative values?

Yes, the formula works mathematically with negative numbers, but the interpretation becomes tricky. For example, a change from −10 to −5 is a 50% increase (because the absolute value of the base is 10 and the change is +5), but the actual improvement is only 5. In such cases, it’s often better to report the absolute change as well.

How do I calculate YoY growth in Excel?

In Excel, if the previous year value is in cell A1 and the current year value is in cell B1, the formula is: =(B1-A1)/A1. Format the cell as a percentage. This gives the same result as the calculator above.

What does a 0% change over year mean?

It means the later value is exactly equal to the earlier value. No growth and no decline. This can be a sign of stagnation, but in some contexts (e.g., a stable metric like population) it may be perfectly normal.

Is the change over year the same as growth rate?

Yes, when the earlier value is positive, “change over year� and “growth rate� are essentially the same. Growth rate is often expressed as a percentage, while “change� can be absolute or relative. The formula is identical.

What if the earlier value is zero?

If the earlier value is zero, the formula divides by zero, which is undefined. In that case, you cannot calculate a percentage change. Instead, report the absolute change (later value − 0 = later value) and note that the base was zero.

Related

• VAT Code Calculator: How to Find It
• Visual Basic Calculator Code: How to Build One
• Time Clock In Clock Out Calculator: How to Use

in earlier | Earlier value | - | 1000 | 0
in later | Later value | - | 1200 | 0
out pct_change | Change over year | % | ((later - earlier) / earlier) * 100 | 2
out diff | Absolute difference | - | later - earlier | 2