Sensitivity Analysis Generator

Les modélisateurs financiers, analystes en investissement et DAF utilisent ce prompt pour construire la section d'analyse de sensibilité d'un modèle financier ou d'une présentation au conseil — montrant rapidement aux parties prenantes la robustesse ou la fragilité du scénario de base.

You are a financial modeling specialist. I need a structured sensitivity analysis framework for a [FINANCIAL MODEL TYPE] (e.g., DCF model, LBO model, project finance model, budget model). The primary output metric I want to stress-test is [OUTPUT METRIC] (e.g., NPV, IRR, EPS, EBITDA, free cash flow). The two key input variables I want to vary are [INPUT VARIABLE 1] and [INPUT VARIABLE 2].

Base case values:
- [INPUT VARIABLE 1] base case: [BASE VALUE 1]
- [INPUT VARIABLE 2] base case: [BASE VALUE 2]
- [OUTPUT METRIC] base case result: [BASE OUTPUT]

Sensitivity ranges to test:
- [INPUT VARIABLE 1]: [RANGE 1] (e.g., 6%, 8%, 10%, 12%, 14%)
- [INPUT VARIABLE 2]: [RANGE 2] (e.g., 5.0x, 5.5x, 6.0x, 6.5x, 7.0x)

Please produce the following:

1. **Data Table (5×5 Sensitivity Matrix)**
   Create a formatted two-dimensional data table showing [OUTPUT METRIC] for every combination of [INPUT VARIABLE 1] (rows) and [INPUT VARIABLE 2] (columns). Mark the base case cell clearly. Highlight cells that represent a 20%+ upside to base case (upside zone) and cells that represent a 20%+ downside (risk zone).

2. **Key Findings Narrative**
   Write a concise paragraph interpreting the sensitivity table:
   - Which input variable has the greater leverage on [OUTPUT METRIC]?
   - What is the range of outcomes from most bearish to most bullish scenario?
   - At what threshold of [INPUT VARIABLE 1] or [INPUT VARIABLE 2] does [OUTPUT METRIC] turn negative or breach a key hurdle rate?

3. **Scenario Labels**
   Map the corners of the table to named scenarios: Bull (top-right), Base (center), Bear (bottom-left), and a Stress Case (extreme bottom-left). Describe the real-world conditions that would correspond to each corner scenario.

4. **Model Robustness Assessment**
   State whether the [FINANCIAL MODEL TYPE] result is robust (base case holds positive even in most adverse combinations), moderately sensitive, or fragile (many combinations produce adverse outcomes). Recommend which combination of inputs management should monitor most closely.

5. **Extension Suggestions**
   Propose two additional input variable pairs that would be valuable to stress-test in a follow-up sensitivity analysis, with rationale.

Present the data table in plain-text grid format, clearly labeled with row and column headers.

Variables du Prompt

Remplacez chaque placeholder par vos informations spécifiques :

Ce que vous obtiendrez

Une matrice de sensibilité 5×5 formatée avec le cas de base mis en évidence et les zones de hausse/risque marquées; un récit des conclusions clés; des descriptions de scénarios nommés; une évaluation de la robustesse du modèle; et deux suggestions de paires de variables supplémentaires.

💡 Conseil d'Expert

Effectuez l'analyse de sensibilité avant de finaliser vos hypothèses de base — si le modèle est fragile aux petites variations d'un seul paramètre, cette hypothèse mérite une recherche plus approfondie.

Outils IA Compatibles

Prompts Associés

Ressources Associées