keepcalculator

08 Work and Ops Metrics

Year over Year Sales Growth Calculator

Card No. 08·0036 · Updated · Standard formula, shown below

Year-over-year growth 15.00 %
Change
18,000.00
Result
Ratio this year ÷ last year
1.1500
Result
Last year's sales
120000
You entered
You enter
Last year's sales, This year's sales
You get
Year-over-year growth, Change, Ratio this year ÷ last year
Rounding
2 dp · 4 dp

This calculator finds the year-over-year (YoY) growth of sales: enter last year’s figure and this year’s figure for the same period. You get the growth rate in percent, the change and the ratio between the two years.

Formula

YoY growth = (this year − last year) ÷ last year × 100. A negative result is a decline.

  • a: sales in the earlier period (must not be 0)
  • b: sales in the same period one year later

Worked Example

Last year 120,000, this year 138,000.

  1. Change = 138,000 − 120,000 = 18,000.00
  2. 18,000 ÷ 120,000 = 0.15, × 100 = 15.00%
  3. Ratio = 138,000 ÷ 120,000 = 1.1500

Limits and common mistakes

  • Compare like with like: the same months or quarters, so seasons do not distort the figure.
  • Growth of 15% then a fall of 15% does not return to the start (1.15 × 0.85 = 0.9775).
  • Over several years use the average yearly rate (ratio^(1/years) − 1), not the total divided by years.
Formula used
in a | Last year's sales | - | 120000 | 0
in b | This year's sales | - | 138000 | 0
out g | Year-over-year growth | % | (b - a) / a * 100 | 2
out ch | Change | - | b - a | 2
out r | Ratio this year ÷ last year | - | b / a | 4

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Photo collage: stacked shipping boxes growing in height from left to right in a warehouse.
Save this card: a 1000 × 1500 image of Year over Year Sales Growth Calculator.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.

More cards in this drawer

The whole Work and Ops Metrics drawer →