Year Over Year Growth Calculator

Frequently Asked Questions

What does year over year growth actually measure?

It measures the percentage change in a metric from one year to the next, comparing the same period in each year. YoY filters out seasonal effects and reveals the underlying trend, which shorter-interval comparisons often obscure.

How is YoY different from quarter over quarter?

YoY compares a period to the same period one year earlier, which removes seasonality. QoQ compares consecutive quarters, which captures short-term momentum but is distorted by seasonal patterns. Most businesses use both, QoQ for operational decisions and YoY for reporting.

What is CAGR and how is it different from average YoY?

CAGR is the compound annual growth rate, the single rate that, applied each year, would take you from the first value to the last. Average YoY is the arithmetic mean of each year’s change. CAGR is more useful for long-term trends because it accounts for compounding, while average YoY overstates growth when the series is volatile.

Can YoY growth be negative?

Yes. A negative YoY change means the metric declined relative to the prior year. The calculator reports it with a minus sign and colours the year red in the chart. Two consecutive negative years often signal a genuine downturn.

How many years of data do I need?

At least two, one prior year and one current year. That’s enough for a single YoY calculation. For CAGR and the average YoY to be meaningful, you want at least four to five years. Ten years or more gives a clearer picture of the long-term trend.

What should I use for the metric name?

Anything that describes what you’re tracking. “Annual Revenue”, “Active Users”, “GDP”, “Website Traffic”, “Units Sold”, or the name of a specific product line. The name appears in the output summary and in any text you copy or share.

What’s the difference between the value types?

Currency formats the output with the selected currency symbol and thousands separators. Number shows plain integer values with separators, useful for users, units, or any count. Percent treats the values as percentages themselves, useful for tracking rates like conversion or engagement.

Why is my latest YoY so different from the average YoY?

Because YoY is measured against the immediately preceding year, while the average spans the full period. If the prior year was unusually strong or weak, the latest YoY will be distorted. Comparing the two numbers is the fastest way to spot a genuine slowdown versus a normal fluctuation.

Does the calculator work for negative values?

Yes. The YoY percentage uses the absolute value of the prior year, so a metric moving from −$500,000 to −$300,000 correctly shows a +40% improvement rather than a misleading negative number. This is important for metrics like net income or profit that can be negative.

Can I compare more than one metric at a time?

No. The calculator handles one yearly series at a time. To compare two metrics, run each through the calculator separately and compare the CAGRs side by side. The consistency score is a useful secondary comparison when the growth rates are close.

What does the consistency score tell me?

It’s the percentage of years that were positive out of all the year-over-year transitions measured. A high score (say, above 70%) means the trend is durable, most years move in the same direction. A lower score means the metric is volatile and future years are harder to predict.

How do I interpret a CAGR above 20%?

A CAGR above 20% is strong growth, typically seen in early-stage companies or fast-expanding markets. Sustained for a decade, it would multiply the metric by more than six times. In practice, growth rates slow as the base grows, so a 20% CAGR over five years often moderates to a lower rate in subsequent years.