A single-point forecast tells the business what is expected to happen, but the future is uncertain, and the most valuable financial planning acknowledges that uncertainty rather than pretending it away. Scenario and sensitivity analysis are the disciplines through which FP&A explores the range of possible outcomes rather than a single prediction, showing how the business’s finances would unfold under different assumptions and how sensitive the outcomes are to the things that could change. This transforms financial planning from a forecast into a genuine understanding of the risks and the possibilities, which is far more useful for decision-making. For the FP&A professional, the ability to do scenario and sensitivity analysis well is a defining skill, and one that distinguishes planning that genuinely informs decisions from planning that merely predicts.
This guide is written for FP&A professionals who want to do scenario and sensitivity analysis well. It covers what these analyses are and why they matter, the distinction between sensitivity and scenario analysis, how to build them on a sound model, how to use them to support decisions, and the principles that make them genuinely useful rather than a mechanical exercise. The aim is the practical understanding an FP&A professional needs to move beyond single-point forecasting to a genuine analysis of uncertainty, which is one of the most valuable contributions FP&A makes to the business’s understanding of its own future.
The guide goes beyond the principles with illustrative worked figures that add up, so you can see how a sensitivity table, a tornado chart and a set of scenarios are built and read. It also covers how the analysis feeds the directors’ going concern assessment, how it connects to the budget and reforecast, and what FP&A professionals who do this well are paid.
Why Single-Point Forecasts Are Not Enough
A single-point forecast — a single set of numbers representing the expected outcome — has a fundamental limitation: it presents one version of a future that is genuinely uncertain, and it gives no sense of the range of outcomes that could actually occur or of how confident the business should be in the prediction. Reality rarely matches the forecast exactly, and a business that plans only on a single forecast is unprepared for the outcomes that differ from it, which is most of them. The single-point forecast also conceals the risk: it does not reveal how much worse things could be if the downside materialises, or how the outcome depends on the assumptions, which is exactly what a business managing risk needs to know.
Scenario and sensitivity analysis address this by exploring the range of outcomes rather than a single point. They show how the finances would unfold under different assumptions, revealing the range of possibilities, the sensitivity of the outcomes to the key drivers, and the downside risks the business faces. This gives the business a far richer understanding than a single forecast — not just what is expected, but what could happen, how likely the various outcomes are, and what drives the difference. The FP&A professional who provides this analysis of uncertainty, rather than a single-point forecast, gives the business the understanding it needs to manage risk and make decisions in an uncertain world. Recognising that the single-point forecast is insufficient, and that the analysis of uncertainty is what the business genuinely needs, is the foundation of valuing scenario and sensitivity analysis.
Sensitivity Analysis Versus Scenario Analysis
Sensitivity analysis and scenario analysis are related but distinct, and understanding the difference helps the FP&A professional use each appropriately. Sensitivity analysis examines how the outcome changes as a single assumption varies, holding the others constant — how profit changes as the sales price varies, for instance, or how cash changes as collections slow. It isolates the effect of each assumption, revealing which assumptions the outcome is most sensitive to and therefore which carry the most risk. Sensitivity analysis answers the question of how much the outcome depends on each individual driver, which identifies where the risk and the leverage lie.
Scenario analysis, by contrast, examines coherent combinations of assumptions — whole scenarios in which several assumptions move together in a consistent way — representing different versions of how the future might unfold. A downside scenario might combine lower sales, slower collections and cost pressure into a coherent adverse case; an upside scenario might combine favourable assumptions. Scenario analysis answers the question of how the business would fare under different plausible futures, each represented by a consistent set of assumptions, rather than isolating individual drivers. The two are complementary: sensitivity analysis identifies the assumptions that matter most, and scenario analysis explores coherent combinations of them into plausible futures. The FP&A professional who understands the distinction uses each for its purpose — sensitivity to find the key drivers and the risks, scenarios to explore the plausible futures — and together they provide a rich analysis of the uncertainty the business faces.
Scenario, Sensitivity and Stress Testing Compared
The terms are often used loosely, so it is worth setting out how they differ. All three use the same model; what changes is the question being asked.
| Technique | What moves | Question answered | Typical use |
|---|---|---|---|
| Sensitivity analysis | One assumption at a time | Which drivers matter most? | Prioritising risks; tornado charts; deciding what to monitor |
| Scenario analysis | Several assumptions together, consistently | How would we fare in this plausible future? | Budget downside and upside cases; investment decisions |
| Stress testing | Severe but plausible combinations | Do we survive a bad year? | Going concern support; lender and board resilience discussions |
| Reverse stress testing | Works backwards from failure | What would have to happen to break us? | Finding the covenant or cash breaking point and how likely it is |
Stress testing is most developed in banking, where the Bank of England runs regular stress tests of the largest lenders, but the same logic applies to any business with debt, thin margins or concentrated customers.
Building the Analysis on a Sound Model
Scenario and sensitivity analysis depend on the model they are built on, and a sound, well-structured model is the foundation. The analysis works by varying the assumptions and observing the effect on the outcomes, which requires the model to be driven by clear, identifiable assumptions that can be varied, and to flow the effect of changed assumptions correctly through to the outcomes. A model with this structure — clear assumptions that drive the outcomes through sound logic — supports scenario and sensitivity analysis naturally, because changing an assumption flows through to show the effect. A model that lacks this structure, where the assumptions are buried or the logic does not flow correctly, cannot support the analysis reliably.
This is why the discipline of good modelling, covered in our guide on building a three-statement financial model, underpins scenario and sensitivity analysis: the analysis is only as good as the model it runs on. A driver-based model, in particular, lends itself well to scenario and sensitivity analysis, because it is built from explicit drivers that can be flexed, and the integrated three-statement model shows the full financial consequences — profit, cash and balance sheet — of each scenario. The FP&A professional building scenario and sensitivity analysis should ensure the underlying model is sound and structured for the purpose, because a weak model produces unreliable analysis however sophisticated the scenarios. The model is the foundation, and building it well for the purpose is the first step in sound scenario and sensitivity analysis.
For a deeper look at drivers, see our guides to driver-based planning and building driver trees. In practice, a model built for scenario work has a single assumptions sheet, a scenario selector that switches between named cases, and outputs that never contain hard-coded numbers.
A Worked Sensitivity Table
Take an illustrative business with a base-case budget of £20.0m revenue, a 40% gross margin (so cost of sales of £12.0m, all variable with volume), and overheads of £6.0m. Base-case EBITDA is £8.0m gross profit less £6.0m overheads, which is £2.0m. The table flexes one driver at a time and leaves everything else at base.
| Driver flexed | How it flows through | EBITDA (£m) | Change (£m) |
|---|---|---|---|
| Base case | £20.0m × 40% = £8.0m GP, less £6.0m | 2.0 | – |
| Selling price –5% | Revenue £19.0m; cost of sales unchanged at £12.0m; GP £7.0m | 1.0 | –1.0 |
| Volume –10% | Revenue £18.0m; GP 40% = £7.2m | 1.2 | –0.8 |
| Gross margin –2 points | £20.0m × 38% = £7.6m GP | 1.6 | –0.4 |
| Overheads +5% | Overheads £6.3m | 1.7 | –0.3 |
| Debtor days +15 | No profit effect; £20.0m ÷ 365 × 15 = about £0.82m more cash tied up | 2.0 | 0.0 (cash –0.82) |
The same flexes in the favourable direction give the mirror image: price +5% adds £1.0m, volume +10% adds £0.8m, margin +2 points adds £0.4m and overheads –5% adds £0.3m. Two lessons stand out. A 5% price move is worth more than a 10% volume move, because a price cut falls straight to the bottom line while lost volume also saves its cost of sales. And the debtor days line shows why sensitivity analysis has to look at cash as well as profit: a change that leaves EBITDA untouched can still put pressure on the bank balance, which is the job of the 13-week cash flow forecast.
Reading it as a tornado chart
A tornado chart shows each driver as a horizontal bar spanning its downside and upside effect, sorted with the widest bar at the top, so the chart narrows like a tornado. Here the order would be: selling price (a swing of £2.0m, from £1.0m to £3.0m EBITDA), volume (£1.6m swing, £1.2m to £2.8m), gross margin (£0.8m, £1.6m to £2.4m) and overheads (£0.6m, £1.7m to £2.3m). The message for the board is immediate: pricing discipline and volume deserve most management attention, and overhead control, while worthwhile, moves the result least. The ranges you flex must be realistic for each driver; flexing every driver by the same percentage is convenient but can mislead if price is far more stable than volume in your market.
From sensitivities to scenarios
Scenarios combine the drivers into coherent stories. In the illustration, a downside of volume –10%, gross margin –2 points and overheads +5% gives revenue of £18.0m, gross profit of £6.84m (38%), overheads of £6.3m and EBITDA of £0.54m. An upside of volume +10%, margin +1 point and overheads +3% gives revenue of £22.0m, gross profit of £9.02m (41%), overheads of £6.18m and EBITDA of £2.84m.
| £m | Downside | Base | Upside |
|---|---|---|---|
| Revenue | 18.00 | 20.00 | 22.00 |
| Gross profit | 6.84 | 8.00 | 9.02 |
| Overheads | (6.30) | (6.00) | (6.18) |
| EBITDA | 0.54 | 2.00 | 2.84 |
Note that the downside reduces EBITDA by £1.46m, slightly less than the £1.50m you get by adding the three individual sensitivities (£0.8m + £0.4m + £0.3m), because the margin squeeze applies to a smaller revenue base. Interactions like this are why scenarios must be run through the model rather than assembled by adding up sensitivities. If the business has a leverage covenant, the next step is to translate each scenario’s EBITDA and cash into covenant headroom, as shown in our guide to AI for covenant and KPI tracking.
Using the Analysis to Support Decisions
The purpose of scenario and sensitivity analysis is to support decisions, and the FP&A professional should conduct and present it with the decisions in mind. The analysis informs decisions in several ways. It reveals the risks — particularly the downside scenarios that show how bad things could get and what would drive them — which allows the business to assess and prepare for the risks it faces. It identifies the key drivers, through sensitivity analysis, which shows the business where to focus its attention and its risk management. And it shows how decisions would play out under different futures, which supports the choice between options by revealing how each performs across the range of scenarios, not just in the expected case.
Presenting the analysis to support decisions means drawing out what it implies rather than just showing the numbers. The downside scenario is most valuable when its implications are clear — what it would mean for the business, what would trigger it, what could be done about it. The sensitivity analysis is most useful when it highlights the drivers that matter and what the business should watch or manage. The scenario analysis of a decision is most useful when it shows clearly how the decision fares across the futures and what that implies for the choice. The FP&A professional who presents the analysis this way — with the implications for the decision drawn out — makes it genuinely useful; one who presents the scenarios as a mass of numbers without the implications leaves the business to extract the meaning, which reduces the value. Using scenario and sensitivity analysis to support decisions, with the implications made clear, is what turns the analysis from an exercise into a genuine contribution to the business’s decision-making.
Hiring an FP&A professional who can model uncertainty? — 0204 553 8893
We place FP&A analysts, managers and heads of FP&A who build sound models and turn scenarios into decisions. Permanent, interim and fractional, with a response the same working day.
Making the Analysis Genuinely Useful
Scenario and sensitivity analysis can be done mechanically, producing scenarios that look sophisticated but add little, or genuinely, producing analysis that informs the business’s understanding and decisions. The difference lies in several principles. The scenarios must be plausible and meaningful — representing genuine possibilities the business could face, grounded in realistic combinations of assumptions, rather than arbitrary variations that do not correspond to real risks. A downside scenario should reflect the things that could genuinely go wrong, in plausible combination; an arbitrary scenario that does not correspond to a real risk adds little. The FP&A professional must think about what scenarios genuinely matter to the business, rather than mechanically flexing assumptions.
The analysis must also focus on what matters — the assumptions and scenarios that are significant, rather than an exhaustive analysis of every variation that buries the important in the trivial. And it must be communicated clearly, with the key findings and their implications drawn out, rather than presented as an overwhelming mass of numbers. The FP&A professional who applies these principles — plausible and meaningful scenarios, focus on what matters, clear communication of the implications — produces scenario and sensitivity analysis that genuinely informs the business; one who applies the techniques mechanically produces analysis that looks sophisticated but adds little. The value lies not in the technique itself but in the judgement about what scenarios matter, what the analysis reveals, and what it implies for the business — which is exactly the judgement that distinguishes a strong FP&A professional. Making scenario and sensitivity analysis genuinely useful, rather than merely technically correct, is the real skill, and it draws on the understanding of the business and the decisions it faces that the best FP&A professionals bring.
Monte Carlo Simulation in Plain English
Scenarios give you three or four snapshots. Monte Carlo simulation gives you a distribution. Instead of fixing each assumption at a single value, you describe it as a range with a likely shape: volume might be anywhere between –15% and +10% of budget, most likely around –2%; gross margin between 37% and 42%, most likely 40%. The model is then recalculated thousands of times, each time drawing a random value for every assumption from its range. The result is a spread of outcomes from which you can read statements such as “in roughly 80% of runs EBITDA is above £1.2m” or “about one run in ten breaches the leverage covenant”.
It is powerful but easy to misuse. The output is only as good as the ranges and the correlations you set (volume and margin often fall together in a downturn, and treating them as independent understates the risk). It also produces a precise-looking probability that a board may over-trust. For most mid-sized businesses, a well-chosen set of scenarios plus a reverse stress test answers the important questions; Monte Carlo earns its place where there are many uncertain drivers, such as project finance, commodity exposure or large capital decisions. Spreadsheet add-ins and some planning platforms support it, as covered in our review of FP&A tooling, and AI assistants can now help set up the simulation, although the assumptions still need FP&A judgement (see AI for FP&A forecasting).
The Downside Scenario and Stress Testing
Of all the scenarios an FP&A professional builds, the downside is often the most valuable, because it reveals the risks the business most needs to understand and prepare for. A well-constructed downside scenario combines the things that could plausibly go wrong — weaker demand, slower collections, cost pressure, a lost customer — into a coherent adverse case, and shows what it would do to the business: the effect on profit, on cash, on the balance sheet, on any covenants or financing constraints. This is exactly the analysis a business needs to assess its resilience and to know in advance where the pressure points lie, rather than discovering them when the downside actually materialises.
Stress testing takes this further, examining how the business would fare under severe but possible conditions, and identifying the point at which the business would face genuine difficulty — where it would breach a covenant, run short of cash, or face a serious problem. This reveals the business’s genuine resilience and the margin it has against adverse conditions, which is valuable for risk management and for the conversations with lenders and investors that a prudent business has before a crisis rather than during one. The FP&A professional who builds genuine downside scenarios and stress tests — grounded in plausible adverse conditions, showing the full consequences, identifying the pressure points — provides the business with an understanding of its risks that single-point forecasting cannot, and that is among the most valuable contributions scenario analysis makes. Understanding the downside is often more valuable than refining the central case, because it is the downside that threatens the business.
Scenario Analysis and the Going Concern Assessment
One of the most important uses of downside and stress scenarios is supporting the directors’ assessment of whether the business is a going concern. Under FRS 102, directors look at least twelve months from the date the financial statements are authorised for issue; under IFRS the period is at least twelve months from the end of the reporting period. In practice that assessment rests on a cash flow forecast and a credible downside: can the business meet its liabilities and stay within its covenants if trading is materially worse than budget, and what mitigating actions are available and within management’s control?
The FRC’s Guidance on the Going Concern Basis of Accounting and Related Reporting, including Solvency and Liquidity Risks, updated in February 2025, is non-mandatory but gives a proportionate framework for companies of different sizes. On the audit side, auditors evaluate management’s assessment under ISA (UK) 570. The FRC has published a revised ISA (UK) 570 (March 2026), which applies to audits of periods beginning on or after 15 December 2026 and strengthens how auditors evaluate going concern. Finance teams should expect auditors to examine the assumptions behind the forecast and the downside scenario closely, so the scenarios need to be documented, plausible and tied to the model.
A reverse stress test is particularly useful here. Working backwards from the point where cash runs out or a covenant breaks, and then asking how plausible that combination is, gives directors and auditors a clear sense of the margin of safety. If the breaking point sits close to the base case, it may point to a material uncertainty that has to be disclosed, which is a judgement for the directors with their auditors and advisers.
Communicating Uncertainty Without Overwhelming
A practical challenge in scenario and sensitivity analysis is communicating the uncertainty it reveals without overwhelming the audience, and an FP&A professional must handle this well for the analysis to be useful. Presenting a business with dozens of scenarios and an exhaustive sensitivity analysis can obscure rather than illuminate, leaving the audience unable to see what matters in the mass of possibilities. The skill is to distil the analysis to what genuinely matters — the few scenarios that represent the meaningful possibilities, the key sensitivities that drive the outcomes, the central messages about the range of outcomes and the risks — and to present these clearly, rather than overwhelming the audience with every variation.
This means making choices about what to present: the central case, a meaningful downside and perhaps an upside, rather than every conceivable scenario; the key sensitivities that matter, rather than the sensitivity to every assumption; and the clear messages about what the analysis reveals, rather than a mass of numbers for the audience to interpret. The FP&A professional who communicates the uncertainty this way — distilled to what matters, presented clearly, with the key messages drawn out — makes the analysis genuinely useful to the audience; one who presents everything overwhelms them and obscures the insight. Communicating uncertainty well is part of making scenario and sensitivity analysis valuable, because analysis that the audience cannot absorb does not inform their decisions however sophisticated it is. The goal is to give the business a clear understanding of the range of outcomes and the key risks, not to bury it in possibilities, and achieving that clarity is part of the FP&A professional’s skill.
Linking Scenarios to Cash Forecasting and Budgeting
Scenario analysis is most useful when it is part of the planning cycle rather than a one-off exercise. In the budget, the downside and upside cases set the range within which management agrees trigger points and pre-planned actions: if volume runs 8% behind for two months, a hiring freeze starts; if it runs ahead, capacity spend is released. Our budgeting and reforecasting guide covers building those cases into the annual budget, and a rolling forecast lets you update the scenarios as the year unfolds.
On the cash side, the short-term cash forecast should carry at least a base and a downside, because cash is where a downside becomes a crisis. Monthly variance analysis then closes the loop by showing which scenario reality is tracking, so the board sees early whether the downside is materialising. Presenting this compactly in the board pack (see board pack preparation) is usually a single page: the range, the key sensitivities, the triggers and where the business is tracking.
FP&A Roles That Do This Work, and What They Pay
Scenario and sensitivity analysis is a core skill at every level of FP&A, and how much of it a role owns rises with seniority. Our house ranges for London are:
| Role | Typical scenario work | London salary |
|---|---|---|
| FP&A Analyst | Builds and maintains the model, runs sensitivities, prepares tables and charts | £48k–£62k |
| FP&A Manager | Designs scenarios with the business, owns the forecast, presents to the leadership team | £62k–£82k |
| Head of FP&A | Sets the planning framework, stress tests for the board, lenders and going concern | £80k–£108k |
| Finance Business Partner | Applies scenarios to commercial decisions in a business unit | £52k–£62k / £62k–£80k / £78k–£100k by seniority |
Ranges outside London are typically lower. For more detail see the FP&A Analyst job description and salary, the FP&A Manager salary guide and when to create a Head of FP&A role. Interim FP&A cover through budget season is common; our page on interim FP&A day rates sets out what to expect. Candidates preparing for interviews will find scenario questions in our FP&A interview questions. Where the scenario work feeds a refinancing or a CFO-level decision, our sister firm FD Capital handles FD and CFO searches. Professional bodies such as ICAEW’s Corporate Finance Faculty publish further material on financial modelling.
Frequently Asked Questions
What is the difference between scenario and sensitivity analysis?
Sensitivity analysis changes one assumption at a time to see which drivers matter most. Scenario analysis changes several assumptions together to describe a coherent possible future, such as a downside or upside case.
How many scenarios should we present to the board?
Usually three: a base case, a meaningful downside and an upside, plus a stress or reverse stress test where resilience is in question. More than that tends to obscure the message.
What is a tornado chart?
A chart showing the effect of flexing each driver up and down, as horizontal bars sorted from largest swing to smallest. It shows at a glance which assumptions the result depends on most.
What is reverse stress testing?
Starting from an outcome the business could not survive, such as running out of cash or breaching a covenant, and working backwards to identify what combination of events would cause it and how plausible that is.
Do we need Monte Carlo simulation?
Not usually. Most mid-sized businesses are well served by a few well-built scenarios and a reverse stress test. Monte Carlo helps where many uncertain drivers interact and the ranges and correlations can be estimated sensibly.
How does scenario analysis relate to going concern?
Directors usually support their going concern assessment with a cash flow forecast and downside scenarios covering at least twelve months, and auditors evaluate that assessment under ISA (UK) 570. Well-documented scenarios make that process much smoother.
Adrian Lawrence FCA — Founder, Accountancy Capital
Fellow of the ICAEW | Chartered Accountant holding an ICAEW practising certificate | Part of FD Capital Group
Adrian is a former listed-company Finance Director who became an FD at 28, and holds a BSc from Queen Mary College, University of London. He founded FD Capital in 2018 and later Accountancy Capital, where our recruitment team places FP&A analysts, managers and heads of FP&A who can build sound models and turn scenario analysis into decisions.
Related Pages and Resources
Forecasting and Budgeting
Where scenarios feed the planning cycle.
→ Budgeting and reforecasting guide
FP&A Careers and Pay
Roles, salaries and progression.
Hiring FP&A
Permanent, interim and fractional.
Talk to Accountancy Capital — 0204 553 8893
Whether you need an FP&A Analyst to build the model, a Head of FP&A to stress test for the board or interim cover through budget season, our recruitment team responds the same working day. Permanent shortlists typically within one to two weeks; interim and fractional within days. Email recruitment@accountancycapital.co.uk.