Conducting a sensitivity analysis is a critical step in the financial evaluation of a project. It allows you to move from a “static” calculation (a fixed forecast) to a “dynamic” understanding of risks and opportunities.

Here is the methodology for achieving it and the strategic lessons to be learned, based on the sources provided:

1. Methodology: How to carry out the analysis?

The objective is not to question the robustness of the assumptions, but to understand the impact of a forecasting error on value creation (NPV).

Step 1: List and qualify the parameters (Risky vs. Sensitive) It is essential to distinguish between two concepts that are often confused:

• A risky parameter is a parameter that is subject to high variability or volatility (high standard deviation).
• A sensitive parameter is a parameter whose variation, even a small one, leads to a significant change in the Net Present Value (NPV) of the project.

Concrete example: In an industrial project, the residual value of a machine in 10 years is often a very risky parameter  (its future value is unknown), but not significant (its impact on the current NPV is negligible due to discounting). Conversely, the volume of sales and the operating margin are often extremely sensitive.

Step 2: Build economic scenarios (not just mathematical) It is not enough to mechanically vary the parameters by +/- 10% in a spreadsheet. The analysis must be based on concrete business scenarios.

• It is necessary to identify the real causes of the variation (e.g. arrival of a new competitor, technological breakthrough, evolution of the price of a commodity).
• It is crucial to question the “owner” of the parameter (the one who provided the figure: marketing, purchasing, HR) to validate the consistency of the scenarios.

Step 3: Calculate Critical Thresholds (Break-Evens) The analysis should determine the project’s profitability limits:

• The Discounted Break-Even Point (Project): Unlike the accounting break-even point (which looks for zero net income), this threshold indicates the minimum volume of sales for the NPV to be equal to 0. This is the level of activity required to remunerate shareholders at the required rate (WACC). This threshold is always higher than the accounting break-even point.
• Discounted Payback : The minimum term must be calculated so that the cumulative and discounted cash flows cover the initial investment.

2. Lessons: What do we learn from them?

Sensitivity analysis is not only used to validate figures, it is a decision-making and management tool.

A. Identify the actual risk profile of the project

The analysis reveals whether the value of the project is based on solid or weak foundations. If a small drop in volumes or a slight increase in costs destroys the entire NPV, the project is hyper-sensitive.

• This allows the Weighted Average Cost of Capital (WACC) to be adjusted: if the project has a specific risk profile that is very different from the rest of the group, it may require an individualized discount rate.

B. Trigger management actions (Hedging and Trading):

Once the sensitive parameters have been identified, the company can act upstream:

• If the cost of a raw material is significant, the company can try to negotiate price revision clauses with its customers or use hedging instruments.
• If accounts payable is sensitive, the negotiation of payment terms becomes a strategic priority.

C. Revealing the Need for Flexibility (Optional Approach):

This is the most sophisticated teaching. Sensitivity analysis often shows that rigidity destroys value in the event of an adverse scenario (e.g., a factory that is too large if the market collapses).

• This encourages the introduction of flexibility (Real Options): invest in stages, defer investment, or design a plant capable of changing inputs or products.

Example: Faced with uncertainty about volumes, it may be preferable to build a reduced capacity (500k units) that can be expanded, rather than an immediate total capacity (1000k). Even if it costs more in total investment, the reduction of the risk of loss (downside) increases the average project value (NPV).

D. Structure the project’s management control:

The parameters identified as sensitive become the key indicators (KPIs) to be monitored as a priority.

• Continuous management: Reporting  must focus on these variables to detect drifts as early as possible.

Post-audit: At the end of the project, the analysis of the variances on these parameters helps to improve the quality of the forecasts for future projects.