{"id":265269,"date":"2024-03-13T20:08:19","date_gmt":"2024-03-13T19:08:19","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=265269"},"modified":"2026-10-21T15:35:26","modified_gmt":"2026-10-21T13:35:26","slug":"calculer-croissance-glissement-annuel","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/finance-processes\/calculate-year-over-year-growth\/","title":{"rendered":"Comment calculer la croissance en glissement annuel (YOY)"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Although you can get useful information from studying weekly or monthly figures, it\u2019s important to get a longer and broader view of your business\u2019 growth. A useful metric in this respect is year-over-year growth. Whether you\u2019re looking at growth in terms of revenue, profit, production, or any other metric, year-on-year growth lets you assess actual growth without the effects of seasonality.<\/p>\n

In this article, you will learn how to calculate year-over-year growth for different metrics. You will also learn to use Google Sheets to set up templates so you can speed up calculations and keep a record of all calculated values.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”what-is-year-over-year-yoy-growth” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

What is year-over-year (YOY) growth?<\/h2>\n

Year over year growth is a financial metric used to express the percentage of change between values a year apart. For example, you can calculate it using the total revenue values for two different years to get year-on-year growth for yearly revenue.<\/p>\n

However, you can also calculate it using the monthly or quarterly values for those years. These values are often charted using different types of visualizations, such as a line graph<\/a>, to facilitate analysis.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”how-to-calculate-year-over-year-growth” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

How to calculate year-over-year growth?<\/h2>\n

To calculate year-over-year growth, you first need to select your chosen metric and gather values one year apart. Usually, monthly or quarterly values are used. Subtract the old value from the new one, then divide it by the old value and multiply by 100 to get the growth percentage.<\/p>\n

What is the formula for year-over-year growth?<\/h3>\n

Follow these steps to calculate YOY growth values.<\/p>\n

1.<\/strong> Select the comparison periods.<\/p>\n

2.<\/strong> Select the values for your chosen metric, which should be taken a year apart.<\/p>\n

3.<\/strong> Subtract the old value from the new value and divide the result by the old value to get a decimal.<\/p>\n

4.<\/strong> Multiply by 100 to get the percentage.<\/p>\n

5.<\/strong> That\u2019s it. You have your YOY percentage growth.<\/p>\n

\n

YOY growth = ((new value – old value) \/ old value) * 100<\/p>\n<\/blockquote>\n

[\/et_pb_text][et_pb_text module_id=”yoy-change-formula-increases-and-decreas” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

YOY change formula: increases and decreases year over year<\/h2>\n

The same formula works whether a metric goes up or down. When the new value is higher than the old one, the result is positive and shows growth. When the new value is lower, the result is negative and shows a decline.<\/p>\n

For example, if Company A’s December revenue had fallen from $59,880.00 to $55,443.89, the YOY change would be ((55,443.89 – 59,880.00) \/ 59,880.00) * 100 = -7.41%.<\/p>\n

Keep in mind that a rise and a fall of the same amount give different percentages, because each one is divided by its own starting value. Revenue grew 8% from December 2020 to December 2021, but a fall back to the 2020 figure would be a 7.41% decline. If the old value is zero, the formula can’t return a result, and if it’s negative, the percentage is misleading, so report the change in absolute numbers instead.<\/p>\n

Comparing values from the same period across years is a form of horizontal analysis<\/a>, and lining up several years of YOY figures is the starting point for trend analysis<\/a>.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”how-to-calculate-yoy-growth-for-3-years” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

How to calculate YOY growth for 3 years?<\/h2>\n

There are different ways to calculate yearly growth over a three-year period. If you have the values for all three years, you can calculate it using the previous formula. However, if you only have values two or three years apart, you can use the CAGR formula to estimate yearly growth.<\/p>\n

\n

CAGR = (EV \/ BV) ^ (1\/n) \u2013 1<\/p>\n<\/blockquote>\n