Year Over Year Sales Formula: How to Calculate YoY Growth

This calculator works out your year-over-year (YoY) sales growth percentage. You enter the current period’s sales and the previous period’s sales, and it returns the percentage change, showing whether sales increased or decreased compared with the same period last year.

Formula

The year-over-year sales growth formula is:

YoY Growth (%) = (Current Period Sales − Previous Period Sales) ÷ Previous Period Sales × 100

Where:

• Current Period Sales – the sales figure for the most recent period (e.g., this month, this quarter, this year).
• Previous Period Sales – the sales figure for the same period one year earlier.

The result is a percentage. A positive number means growth; a negative number means a decline. The absolute change (in dollars) is simply the difference between the two figures.

Worked Example

Using the default values from the calculator:

• Current period sales = $120,000
• Previous period sales = $100,000

Step 1: Subtract previous from current: $120,000 − $100,000 = $20,000

Step 2: Divide by previous: $20,000 ÷ $100,000 = 0.20

Step 3: Multiply by 100: 0.20 × 100 = 20%

The YoY growth is 20%, and the absolute change is $20,000.

Why Use Year-over-Year Instead of Month-over-Month?

Year-over-year (YoY) compares the same period in two consecutive years. It is widely used in business and finance because it smooths out seasonal patterns. For example, a retailer might see a huge spike in December and a dip in January. Comparing December 2024 to November 2024 would be misleading, but comparing December 2024 to December 2023 gives a fair picture of actual growth. YoY also removes the effect of the number of trading days in a month, holidays, and weather patterns that repeat annually. This makes it a reliable metric for tracking long-term trends, setting budgets, and evaluating the health of a business.

How to Read the Result

The output is a percentage that tells you the relative change from the prior year. A 20% YoY growth means sales are 20% higher than they were in the same period last year. A −10% means sales are 10% lower. The absolute change (in dollars) tells you the raw dollar difference, which is useful when the percentage is misleading – for instance, a small company might show 100% growth on a tiny base, while a large company shows 5% growth on a huge base. Always look at both numbers to understand the real magnitude.

Common Mistakes & How to Avoid Them

• Comparing different periods: Ensure the current and previous periods are exactly the same length and align (e.g., Q1 2024 vs. Q1 2023, not Q1 2024 vs. Q4 2023).
• Using the wrong base: The denominator is always the previous period’s sales, not the current period. If you divide by current, you get a different (and incorrect) percentage.
• Ignoring negative previous values: If the previous period had zero or negative sales (e.g., a new product line), the formula breaks down. In that case, report the absolute change or use a different metric.
• Rounding too early: Do the division and multiplication first, then round to your desired decimal places. Rounding intermediate steps can skew the final result.

Limitations of the Formula

The YoY formula is simple and powerful, but it has limitations. It only compares two points in time; it does not show the trend within the year. A company could have a strong Q1 and a weak Q4, yet the YoY for the full year might look fine. Also, YoY does not account for inflation, price changes, or changes in the number of units sold. If you need to see whether growth is due to price increases or volume, you should also track units sold and average price per unit. Finally, the formula assumes the previous period is a valid baseline – if the company underwent a major acquisition or divestiture, the comparison may not be meaningful.

Alternatives to YoY Growth

Depending on your goal, other metrics may be more useful:

• Month-over-month (MoM): Compares consecutive months. Useful for spotting short-term trends but noisy due to seasonality.
• Quarter-over-quarter (QoQ): Compares consecutive quarters. Smoother than MoM but still affected by seasonal patterns.
• Compound Annual Growth Rate (CAGR): Measures the average annual growth rate over multiple years, useful for long-term investments.
• Revenue per customer: Shows if growth is coming from more customers or more spending per customer.

Frequently Asked Questions

What if the previous period sales are zero?

If the previous period had zero sales, the formula divides by zero, so the growth percentage is undefined. In that case, you cannot calculate a meaningful percentage. Instead, report the absolute dollar increase or simply state that sales went from $0 to $X, which is a 100% increase only if you treat the base as 1 (but that is not standard).

Can I use this formula for any period (month, quarter, year)?

Yes. The formula works for any period as long as you compare the same period in two consecutive years. For example, you can calculate YoY growth for a single month (e.g., March 2024 vs. March 2023) or for a full year (2024 vs. 2023). Just make sure the periods are identical in length.

Is YoY growth the same as annual growth?

Not exactly. Annual growth typically means the growth from one full year to the next. YoY growth can be measured for any period (month, quarter, etc.) compared to the same period a year earlier. However, when people say “annual growth” they often mean the YoY growth for the entire year.

How do I calculate YoY growth in Excel?

In Excel, if your current period sales are in cell A1 and previous period sales are in cell B1, the formula would be: =(A1-B1)/B1. Format the cell as a percentage to see the result. For example, =(120000-100000)/100000 gives 0.20, which displays as 20% when formatted as a percentage.

What does a negative YoY growth mean?

A negative percentage means sales decreased compared to the same period last year. For example, −10% means sales are 10% lower. This is often called a “decline” or “negative growth.” It is important to investigate the cause, such as market conditions, loss of a major customer, or a one-time event.

Related

• Gemini Veo vs Runway: Which AI Video Tool to Use
• First Light Pre-Order Guide: What to Know
• Make a Video Tutorial: Plan, Record, and Edit

in current | Current period sales | $ | 120000 | 0
in previous | Previous period sales | $ | 100000 | 0
out yoy | Year-over-year growth | % | (current - previous) / previous * 100 | 2
out diff | Absolute change | $ | current - previous | 2