YoY and QoQ growth calculator

Calculate year-on-year (YoY) or quarter-on-quarter (QoQ) percentage change between two figures, and see when a percentage is not meaningful.

For example last year’s or last quarter’s revenue

The same measure for the later period

Percentage change
15.00%
Absolute change
180.00

Use the same period last year for YoY, and the immediately preceding quarter for QoQ. Results statements show "NM" or leave the cell blank when the earlier figure is zero or a loss.

How it works

Change (%) = (Latest − Earlier) ÷ Earlier × 100, shown only when the earlier figure is positive.

Assumptions

  • Both figures must measure the same thing over comparable periods, in the same units.
  • A large percentage on a very small base says little on its own; look at the absolute change too.

Read more

More tools

These tools do arithmetic on the numbers you enter. They are for illustration and education. They do not predict returns, and they are not investment, tax or financial advice. Returns are not guaranteed.