YoY Percentage: How to Calculate It

This guide shows you how to calculate year-over-year (YoY) percentage change, a common metric used to compare a value (like sales, revenue, or website traffic) in one period to the same period in the previous year. You’ll need the current period’s value and the value from the same period one year earlier. The result is a percentage that tells you whether the metric grew, shrank, or stayed the same.

Formula

The year-over-year percentage change is calculated using this formula:

YoY Change (%) = ((Current Period Value – Previous Year Value) / Previous Year Value) × 100

Where:

• Current Period Value – the value for the current period (e.g., this month, this quarter, this year).
• Previous Year Value – the value for the same period one year earlier.
• YoY Change (%) – the percentage increase or decrease from the previous year to the current period.

Worked Example

Using the default values from the calculator: Current period value = 12,000, Previous year value = 10,000.

1. Subtract the previous year value from the current period value: 12,000 – 10,000 = 2,000.
2. Divide the difference by the previous year value: 2,000 ÷ 10,000 = 0.20.
3. Multiply by 100 to get the percentage: 0.20 × 100 = 20%.

So the YoY change is 20%, meaning the current period value is 20% higher than the same period last year.

When to Use YoY Percentage

YoY percentage is most useful when you want to compare performance over a full year cycle, which smooths out seasonal fluctuations. For example, comparing retail sales in December 2024 to December 2023 is a YoY comparison. It’s commonly used in finance, business analytics, and economics to assess growth trends. Use it when you have data for the same period in two consecutive years.

How to Read the Result

A positive YoY percentage means the current value is higher than the previous year’s value (growth). A negative percentage means the current value is lower (decline). A zero means no change. For example, a YoY change of -5% indicates a 5% decrease from the previous year.

Common Mistakes

• Using non-comparable periods: Ensure you are comparing the same time frame (e.g., January 2024 vs. January 2023, not January 2024 vs. February 2023).
• Dividing by the wrong number: The denominator must be the previous year’s value, not the current value. For example, if current = 120 and previous = 100, the change is (120-100)/100 = 20%, not (120-100)/120 = 16.67%.
• Forgetting to multiply by 100: The raw ratio (0.20) is not a percentage; you must multiply by 100 to express it as a percentage.
• Using negative values incorrectly: If the previous year’s value is negative (e.g., a loss), the formula still works mathematically but the interpretation can be tricky. For instance, a change from -100 to -50 gives a YoY of 50% (because (-50 – (-100)) / -100 = 50%), but this is not a “growth” in the usual sense; it’s a reduction in the loss.
• Rounding too early: If you round intermediate numbers, you may get a slightly different final percentage. Keep full precision until the final step.

Tips

• Always label which period you are comparing (e.g., “Q3 2024 vs Q3 2023”) to avoid confusion.
• Use the same data source for both periods to ensure consistency.
• If you’re comparing currency amounts, adjust for inflation if you want a real growth rate, but for a simple nominal change, the raw numbers are fine.
• For a quick estimate, you can use the formula in a spreadsheet: =(A2-B2)/B2*100 where A2 is current and B2 is previous.
• If the previous year value is zero, the formula is undefined (division by zero). In that case, you cannot calculate a meaningful percentage; consider using an absolute change instead.

Troubleshooting

If you get a division by zero error: This happens when the previous year value is 0. In this case, no percentage change can be calculated. You can report the absolute change (current – previous) or state that the value grew from zero, but a percentage is not mathematically defined.

If your result seems too large or too small: Double-check that you used the correct values. For example, a change from 100 to 150 is 50%, but if you mistakenly used 150 as the denominator, you’d get 33.33%. Also verify that you multiplied by 100.

If the sign is opposite of what you expected: If you expect growth but get a negative number, you may have swapped the current and previous values in the formula. Re-read the formula and ensure the current period is the numerator’s first part.

If you’re comparing different lengths of time: YoY only works for the same period length. If you’re comparing a single month to a full year, that’s not a YoY comparison. Use a different metric like month-over-month or year-to-date.

Frequently Asked Questions

What does YoY stand for?

YoY stands for “year-over-year,” which compares a metric for a specific period (e.g., a month, quarter, or year) to the same period in the previous year.

Can YoY be negative?

Yes, a negative YoY percentage indicates a decrease from the previous year. For example, a YoY of -10% means the current value is 10% lower than last year.

What is the difference between YoY and QoQ?

YoY compares the same period in consecutive years (e.g., Q1 2024 vs Q1 2023), while QoQ (quarter-over-quarter) compares consecutive quarters (e.g., Q1 2024 vs Q4 2023). YoY is less affected by seasonality.

How do I calculate YoY growth in Excel?

Use the formula =(current - previous) / previous * 100. For example, if current is in cell A2 and previous is in B2, enter =(A2-B2)/B2*100 in a new cell.

Is YoY the same as annual growth rate?

Not exactly. Annual growth rate can refer to the growth over a single year, but YoY specifically compares the same period in two consecutive years. For example, a monthly YoY compares this month to the same month last year, not the entire year’s growth.

What if the previous year’s value is zero?

You cannot calculate a percentage change because division by zero is undefined. In that case, report the absolute difference or simply state that the value increased from zero.

Related

• NC State Employee Pay Calculator: How to Use It
• Slope to Angle Formula: Convert Rise/Run to Degrees
• Liters per Minute to m3/s Conversion

in current | Current period value | - | 12000 | 0
in previous | Previous year value | - | 10000 | 0
out yoy | YoY change (%) | % | ((current - previous) / previous) * 100 | 2
out diff | Absolute change | - | current - previous | 2