{"id":267115,"date":"2024-03-13T20:08:23","date_gmt":"2024-03-13T19:08:23","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=267115"},"modified":"2026-11-16T15:08:59","modified_gmt":"2026-11-16T14:08:59","slug":"analyse-de-scenarios","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/finance-processes\/scenario-analysis\/","title":{"rendered":"Analyse de sc\u00e9narios : guide complet (avec exemple)"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221; da_disable_devices=&#8221;off|off|off&#8221;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>The fact that we can\u2019t predict the future doesn\u2019t mean that we should stop trying to prepare for it. SMEs can be especially vulnerable to the effects of external forces, particularly when they\u2019re starting up. Using scenario analysis, you can explore the effects of different scenarios on your <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/financial-modeling-forecasting\/\">financial modeling<\/a>. This can help you come up with an effective strategy that achieves your objectives and minimizes your vulnerability.<\/p>\n<p>In this article, you will learn about scenario analysis and how it differs from sensitivity analysis, as well as the types of scenarios usually analyzed. You will also learn how to perform scenario analysis and see an example using Google Sheets.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;what-is-scenario-analysis&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>What is scenario analysis?<\/h2>\n<p>Scenario analysis is a very useful planning tool in any field, as it allows you to evaluate the effects of changes to key variables by analyzing multiple scenarios. While no tool can predict the future, scenario analysis can help you come up with more resilient or more adaptable strategies.<\/p>\n<p>Depending on the issue you want to focus on, you will need to use different types of specific scenarios. However, it\u2019s usually a good idea to include at least the three described in the next section.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;types-of-scenario&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Types of scenario<\/h2>\n<p>The purpose of scenario analysis is to contemplate multiple possibilities. This allows you to try different options to observe how any change to key variables can affect others. Ideally, you will analyze at least three scenarios: base, best, and worst. In all cases, talk to those who are directly involved, and can help you identify key assumptions and decide on values.<\/p>\n<h3>Base scenario<\/h3>\n<p>This is often the most reasonable or realistic scenario. The basic assumption is that no extreme or unexpected changes will occur. In other words, the values for the key variables will be what you could reasonably expect following previous behavior.<\/p>\n<h3>Best scenario<\/h3>\n<p>In this scenario, the assumption is that the values for key external variables are the best possible ones. If one of your key variables is the price of material X, assume it\u2019s the lowest possible price. However, remember to also consider the possibility of indirect consequences.<\/p>\n<h3>Worst scenario<\/h3>\n<p>This scenario contemplates the consequences of the worst possible set of circumstances: i.e., increased costs, production problems, etc. This can help you identify your biggest dependencies and weaknesses.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;how-to-perform-scenario-analysis&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to perform scenario analysis?<\/h2>\n<p>Follow the steps below to carry out your own scenario analysis. In the next section, you have an example of how to set it up in Google Sheets.<\/p>\n<h3>1. Define the issue<\/h3>\n<p>The first step is to define the issue you wish to analyze. Do you want to study how the addition of a new product or service might affect your company? Maybe you want to study what would happen if the cost of labor or raw materials changed.<\/p>\n<p>You need to be clear about the decisions you want to make based on your analysis of different potential scenarios. Remember to also keep track of any assumptions you are making regarding cause and effect, as you may have to change them.<\/p>\n<h3>2. Gather data<\/h3>\n<p>Next, you need to identify the key variables and metrics involved. Remember to keep track of which key variables you will modify for each scenario, such as the cost of raw materials, and which ones you control, like the price per unit. Remember to use metrics that are reliable indicators of what you want to analyze. These are the same inputs you use to calculate your <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/break-even-point\/\">break-even point<\/a>.<\/p>\n<h3>3. Create a scenario template<\/h3>\n<p>Once you have selected the metrics, you need to set up a template for the scenarios. Most of the time, you will be carrying out this analysis using existing financial documents and models, such as a <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/what-is-budget-forecasting\/\">budget forecast<\/a>. This means you can adapt the document for use as the scenario template, so it\u2019s easy to switch and update values.<\/p>\n<h3>4. Set up scenarios<\/h3>\n<p>Now that you have a template, you can set up each of the scenarios. This will include making assumptions about the values for the key variables in each scenario. Remember to think about less direct effects on other variables.<\/p>\n<p>For example, a shortage of a crucial raw material will also affect competitors: will demand remain steady and justify much higher selling prices? Will demand diminish as customers find alternative products?<\/p>\n<h3>5. Evaluate results<\/h3>\n<p>Once you have calculated and evaluated the different scenarios, you can start making decisions. As mentioned, it\u2019s best to evaluate at least three scenarios before making a decision.<\/p>\n<p>The base case should be the most realistic among these, but you also need to see what would happen to your model in extreme situations, whether positive or negative. However, you\u2019re not limited to those three scenarios: you should evaluate as many as you need to.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;how-to-perform-scenario-analysis-in-goog&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to perform scenario analysis in Google Sheets?<\/h2>\n<p>As you have seen, scenario analysis requires research and a lot of thinking. In fact, the majority of your time should be spent on thinking; this includes defining the problem, deciding on the metrics and scenario parameters, and interpreting the results of multiple scenarios.<\/p>\n<p>Fortunately, tools like Excel or Google Sheets make this thinking process easier as they allow you to set up templates and automate calculations. You will need to be careful setting up the formulas and cell references initially, and it\u2019s highly recommended to get help from people knowledgeable in spreadsheet software and financial metrics and analyses.<\/p>\n<p>I will use a simplified financial model for this example, but you can use the same method to build more detailed ones.<\/p>\n<p><strong>1.<\/strong> Gather the required data and set up the formulas. In the screenshot below, you can see that the last three rows are formulas that depend on the values in the first four rows.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/scenario-analysis-current-data.webp&#8221; alt=&#8221;Scenario analysis example \u2014 Google Sheets with current period selling price, units sold, unit cost and fixed cost, and formulas for variable cost, revenue and profit&#8221; title_text=&#8221;Google Sheets with current period selling price, units sold, unit cost and fixed cost, and formulas for variable cost, revenue and profit&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2.<\/strong> Copy the column with the current period data as many times as you need: one per scenario. Below, you can see I have modified the data for \u2018units sold\u2019, \u2018unit cost\u2019, and \u2018fixed cost\u2019 according to the expectations for each scenario.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/scenario-analysis-base-best-worst-scenarios.webp&#8221; alt=&#8221;Scenario analysis example \u2014 current period column copied into base, best and worst scenario columns with changed units sold, unit cost and fixed cost&#8221; title_text=&#8221;Current period column copied into base, best and worst scenario columns with changed units sold, unit cost and fixed cost&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3.<\/strong> To see the effects of changes in selling price, simply type it into the corresponding scenario in the cells highlighted in blue below.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/scenario-analysis-adjust-selling-price.webp&#8221; alt=&#8221;Financial scenario analysis \u2014 selling price changed to $5.99 in the base scenario, with the blue input cells and the recalculated profit row&#8221; title_text=&#8221;Selling price changed to $5.99 in the base scenario, with the blue input cells and the recalculated profit row&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>With <a href=\"https:\/\/www.sheetgo.com\/automations\/\">Sheetgo&#8217;s AI automations<\/a>, you can bring together data from different sources and in different formats. You can connect your spreadsheets and schedule updates so your scenarios always run on the latest data. For recurring finance work, <a href=\"https:\/\/www.sheetgo.com\/virtual-employees\/finance\/\">Sheetgo&#8217;s AI finance virtual employee<\/a> can gather the figures and keep your model up to date.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;scenario-analysis-vs-sensitivity-analysi&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Scenario analysis vs. sensitivity analysis<\/h2>\n<p>Both sensitivity and scenario analysis are popular types of <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/what-if-analysis-google-sheets\/\">what-if analysis<\/a>. While scenario analysis evaluates the effects of changing multiple variables in your model, sensitivity analysis focuses on one key variable at a time to see how the model responds. If you already know the result you want, <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/goal-seek-google-sheets\/\">goal seek in Google Sheets<\/a> finds the input value that gets you there.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;conclusion&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Conclusion<\/h2>\n<p>As you have seen, scenario analysis is a very useful planning tool, regardless of your industry. Common uses in finance include decision-making regarding new products or services, investments, or any changes to the existing business model. However, depending on the issue and the variables involved, it can be a complex and time-consuming process. Fortunately, Google Sheets and Sheetgo&#8217;s AI automations save you time and help you avoid mistakes.<\/p>\n<p>You now know about scenario analysis in finance and the types of scenarios usually used. Before embarking on a project, it\u2019s a good idea to evaluate different scenarios, covering the spectrum from the best case to the worst case. You also know how to perform scenario analysis and how Google Sheets and Sheetgo&#8217;s AI can help you automate tedious and error-prone tasks.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>L'analyse de sc\u00e9narios mesure l'effet des variables cl\u00e9s sur vos plans. D\u00e9couvrez les sc\u00e9narios de base, optimiste et pessimiste, avec un exemple dans Google Sheets.<\/p>","protected":false},"author":2,"featured_media":267119,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[36],"tags":[],"class_list":["post-267115","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-finance-processes"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/267115","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=267115"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/267115\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/267119"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=267115"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=267115"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=267115"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}