YoY Change Calculation: Formula & Examples

Year-over-year (YoY) change measures how a value in one period compares to the same period one year earlier, expressed as a percentage. To calculate it, subtract last year’s value from this year’s value, divide by last year’s value, and multiply by 100. This calculator works out that percentage automatically: enter the current period value and the prior-year value, and you get the YoY change as a percentage, plus the absolute difference.

Formula

The YoY change formula is written as:

YoY Change (%) = [(Current Period Value − Prior-Year Value) / Prior-Year Value] × 100

• Current Period Value: the metric in the current period (e.g., revenue in Q3 2025).
• Prior-Year Value: the same metric in the same period one year earlier (e.g., revenue in Q3 2024).
• YoY Change: the percentage increase (positive) or decrease (negative) from the prior year to the current period.

The result is unitless (a percentage), so it works for any metric measured in dollars, units, kilograms, or any other unit. The absolute difference (current − previous) is also computed; it carries the same unit as the inputs.

Worked Example

Using the calculator defaults: current value = 1200, prior-year value = 1000.

1. Subtract prior from current: 1200 − 1000 = 200.
2. Divide by prior-year value: 200 ÷ 1000 = 0.2.
3. Multiply by 100: 0.2 × 100 = 20%.

So the YoY change is 20%, meaning the current value is 20% higher than the same period last year. The absolute difference is 200 (in the same units as the inputs).

Why Use YoY Instead of Month-over-Month?

YoY comparisons are popular in business and finance because they remove seasonal effects. For example, a retailer’s sales in December are almost always higher than in July; comparing December to November (month-over-month) would show a large jump that is not meaningful. Comparing December 2025 to December 2024 tells you whether the holiday season actually improved. The same logic applies to quarterly data: Q4 always has holiday spending, so Q4 2025 vs. Q4 2024 is a fair comparison, while Q4 2025 vs. Q3 2025 is not.

YoY is also useful for tracking long-term trends because it smooths out short-term volatility. A single month’s dip might be a blip, but a YoY decline over several quarters signals a real change.

How to Read the Result

A positive YoY percentage means growth; a negative percentage means decline. A result of exactly 0% means no change. The magnitude tells you the size of the change relative to the base year. For example:

• YoY = +10%: current value is 10% higher than last year.
• YoY = −5%: current value is 5% lower than last year.
• YoY = 0%: current value equals last year’s value.

Be careful when the prior-year value is zero or negative. If last year’s value is zero, the formula divides by zero and the result is undefined. If the prior value is negative (e.g., a company’s profit was −$100,000 and now it is +$50,000), the formula still produces a number, but the percentage is not intuitive and is often reported as “not meaningful” in financial statements. In such cases, report the absolute change instead.

Common Mistakes and Pitfalls

• Using the wrong base: Always divide by the prior-year value, not the current value. Dividing by the current value gives a different percentage (the change as a proportion of the new value), which is not YoY change.
• Mixing time periods: Ensure both values cover the same length of time (e.g., full year vs. full year, or Q1 vs. Q1). Comparing a full year to a single quarter produces a meaningless result.
• Ignoring units: The percentage is unitless, but the absolute difference carries the unit. If you input dollars, the difference is in dollars; if you input thousands of dollars, the difference is in thousands of dollars.
• Rounding too early: Round only the final percentage, not intermediate steps, to avoid rounding errors.
• Negative prior values: As noted, the formula breaks down when the prior value is negative or zero. In those cases, present the absolute change and mention the base issue.

Alternatives to YoY Change

Depending on your goal, other comparisons may be more appropriate:

• Month-over-Month (MoM): Compares consecutive months. Useful for spotting short-term trends but noisy and seasonal.
• Quarter-over-Quarter (QoQ): Compares consecutive quarters. Similar to MoM but with less noise; still seasonal.
• Compound Annual Growth Rate (CAGR): The average annual growth rate over multiple years, assuming steady growth. Useful for long-term investments.
• Sequential Growth: A generic term for comparing one period to the immediately preceding period (MoM or QoQ).

YoY is the best choice when you want to eliminate seasonality and focus on underlying trends. If you need to measure growth over several years, CAGR gives a smoother picture than individual YoY figures.

Limitations of YoY Change

YoY change is a simple, powerful metric, but it has limits:

• It ignores the base: A 50% increase from $2 to $3 is not the same as a 50% increase from $1,000 to $1,500, even though the percentage is identical.
• It can mislead with small bases: A tiny change in a very small number can produce a huge percentage. For example, going from 1 to 2 is a 100% increase, but the absolute change is only 1 unit.
• It does not explain why: YoY tells you what happened, not why. External factors (economy, policy, competition) are not captured.
• It is backward-looking: YoY reflects the past; it does not predict future performance.

Use YoY change alongside absolute values and other metrics (e.g., profit margin, market share) for a fuller picture.

Frequently Asked Questions

What is the difference between YoY and YTD?

YoY compares a full period (e.g., Q3 2025) to the same full period last year (Q3 2024). YTD (year-to-date) compares the start of the current year up to a certain date (e.g., Jan 1 to Sep 30, 2025) to the same period last year (Jan 1 to Sep 30, 2024). YTD is a partial-year comparison, while YoY is a full-period comparison.

Can YoY change be negative?

Yes. A negative YoY change means the current value is lower than the prior-year value. For example, if revenue fell from $1,000 to $900, the YoY change is −10%.

How do I calculate YoY growth in Excel?

In Excel, if the current value is in cell A1 and the prior-year value is in cell B1, the formula is: =(A1-B1)/B1. Format the cell as a percentage to display the result as a percentage. For example, if A1=1200 and B1=1000, the formula returns 0.2, which displays as 20%.

What does “YoY” stand for?

YoY stands for “year-over-year.” It is also called “year-on-year” or “annual change.” All terms mean the same thing: comparing a metric in one period to the same period one year earlier.

Is YoY the same as annual growth rate?

Not exactly. Annual growth rate can refer to the growth over a single year (which is the same as YoY if the period is one year). But “annual growth rate” is also used for the average growth per year over multiple years (CAGR). YoY always compares two specific periods one year apart.

Related

• Time Clock In Clock Out Calculator: How to Use
• Time Speed Up Calculator: Does It Exist?
• Time Calculator From Speed and Distance

in current | Current period value | - | 1200 | 0
in previous | Prior-year value | - | 1000 | 0
out yoy | YoY change | % | ((current - previous) / previous) * 100 | 2
out diff | Absolute difference | - | current - previous | 2