Year Over Year Percent Calculator: Formula & Use

This calculator works out the year-over-year (YoY) percentage change between two values, typically the same metric measured in two consecutive years. You enter the value from the earlier period and the value from the later period, and you get the percentage increase or decrease, plus the absolute difference. It is the standard tool for comparing annual performance in business, finance, and economics.

Formula

The year-over-year percent change is calculated as:

YoY % Change = ((Current Year Value − Prior Year Value) / Prior Year Value) × 100

Where:

• Current Year Value – the value in the later period (e.g., revenue in 2024).
• Prior Year Value – the value in the earlier period (e.g., revenue in 2023).
• YoY % Change – the percentage increase (positive) or decrease (negative) from the prior year.

The absolute change is simply the current value minus the prior value, expressed in the same units as the inputs.

Worked Example

Using the default values from the calculator:

1. Prior year value = 1,000
2. Current year value = 1,200
3. Difference = 1,200 − 1,000 = 200
4. Divide by prior year: 200 / 1,000 = 0.20
5. Multiply by 100: 0.20 × 100 = 20%

So the year-over-year change is +20%, and the absolute change is 200 units.

What Year-over-Year Change Tells You

Year-over-year growth is a way to compare performance over a full annual cycle, which smooths out seasonal patterns. For example, a retailer’s sales in December are always higher than in July, so comparing December to November is misleading. Comparing December of this year to December of last year gives a more meaningful picture of true growth.

This metric is widely used for:

• Revenue and profit growth of companies
• GDP growth of countries
• Inflation rates (CPI year-over-year)
• Website traffic or user growth
• Salary or rent increases

A positive percentage means growth, a negative percentage means a decline. A result of 0% means the value stayed exactly the same.

How to Choose the Right Values

To get a meaningful result, the two values must measure the same thing in the same units. For instance, if you compare total revenue in 2023 (in dollars) with revenue in 2024 (also in dollars), the calculation is valid. But if one value is in thousands of dollars and the other in dollars, the result will be wildly wrong.

Also decide whether you want to compare full years or the same month across years. The formula works for any time period, but the label “year-over-year” usually implies annual data. For monthly comparisons, you would use month-over-month, and for quarterly, quarter-over-quarter.

Common Mistakes and How to Avoid Them

• Reversing the order: Always subtract the prior year from the current year, not the other way around. Reversing gives you the wrong sign and a different magnitude.
• Dividing by the wrong number: The denominator is always the prior year value. Dividing by the current year gives a different percentage (called the “percentage change” relative to the later value).
• Using negative values: If the prior year value is negative (e.g., a loss), the formula produces a result that is mathematically correct but hard to interpret. For example, if prior year profit was −100 and current year profit is 100, the formula gives +200%, which is not a meaningful growth rate.
• Ignoring units: If your values are in thousands, keep them consistent. The percentage is unitless, so it is fine, but the absolute difference will be in thousands.
• Rounding too early: Do the division and multiplication first, then round to the desired decimal places. Rounding intermediate steps can cause errors.

Limitations of the Year-over-Year Formula

The formula gives a simple relative change, but it has limitations:

• Base effect: If the prior year value was unusually low (e.g., a bad year), the percentage change can be very large even if the absolute change is small. Similarly, a high prior year makes the growth rate look small.
• No context: A 10% increase could be great for a mature company but poor for a startup. The percentage alone does not tell you if the result is good or bad.
• Negative values: As noted, negative denominators produce misleading percentages.
• Does not account for inflation: A nominal increase in revenue might be a real decrease after adjusting for inflation. For real growth, you need to use inflation-adjusted values.

Related Metrics: CAGR and Absolute Change

Year-over-year change compares two points. For multi-year trends, the compound annual growth rate (CAGR) is more useful because it gives the average annual growth rate over a period. The formula for CAGR is:

CAGR = ((Ending Value / Beginning Value) ^ (1 / Number of Years)) − 1

For example, if revenue grew from 1,000 to 1,440 over 3 years, the CAGR is (1,440/1,000)^(1/3) − 1 = 0.129 = 12.9% per year. The year-over-year change for the last year alone might be different.

The absolute change (current − prior) is useful when the percentage is misleading due to a small base. For instance, if a company went from 1 to 2 customers, that is a 100% increase, but the absolute change is just 1 customer.

Frequently Asked Questions

What is the difference between year-over-year and month-over-month?

Year-over-year compares the same month or quarter in two consecutive years, removing seasonal effects. Month-over-month compares consecutive months, which is useful for short-term trends but heavily affected by seasonality (e.g., December retail sales vs. January).

Can I use this calculator for any two numbers?

Yes, the formula works for any two numbers, but the result is only meaningful if the numbers represent the same metric in comparable periods. For example, comparing revenue in 2023 to revenue in 2024 is fine; comparing revenue to profit is not.

What does a negative year-over-year percentage mean?

A negative percentage means the current value is lower than the prior year value, indicating a decline. For example, −5% means the value dropped by 5% compared to the previous year.

How do I calculate year-over-year growth in Excel?

In Excel, if cell A1 has the prior year value and B1 has the current year value, use the formula: =(B1-A1)/A1. Format the cell as a percentage. This gives the same result as this calculator.

Why is my year-over-year percentage so high or low?

This is often due to the base effect. If the prior year value was unusually small (e.g., a recession year), the percentage will be large. If the prior year was unusually high, the percentage will be small. Always consider the absolute change as well.

Related

• Percent Increase Calculator: Formula & Examples
• Mixed Number to Percent Calculator: How to Convert
• Molar to Percent Calculator: How to Convert

in prior | Prior year value | - | 1000 | 0
in current | Current year value | - | 1200 | 0
out pct | Year-over-year change | % | (current - prior) / prior * 100 | 2
out diff | Absolute change | - | current - prior | 2