Scenario Modelling and Sensitivity Analysis
Scenario analysis tests a financial model's outcome under different sets of assumptions, a base case, upside cases and downside cases, so decision-makers see the range of outcomes rather than a single projection. Sensitivity analysis identifies which individual assumptions move the outcome most.
TEST THE DECISION BEFORE YOU MAKE IT
Every financial decision of consequence carries uncertainty. The revenue growth rate you have assumed might be right. It might be wrong. The customer acquisition cost you have modelled might reflect the market you face at your current scale. It might not reflect the market you face at three times your current scale. The interest rate on the debt facility you are about to draw might hold for the life of the facility. It might not.
Scenario modelling and sensitivity analysis are the tools that translate this uncertainty into a financial picture your decision-makers can work with. They do not eliminate uncertainty, nothing does. But they bound it. They show what the financial outcome looks like if things go well, if things go as planned, and if things go meaningfully worse than planned. They show which assumptions drive the outcome most, the ones where being wrong by 10 percent matters a great deal, and the ones where being wrong by 10 percent barely changes the answer.
Wiseworth builds scenario models and sensitivity analysis frameworks for Australian businesses facing decisions where the range of outcomes matters as much as the central estimate.
WHAT A SCENARIO MODEL IS
A scenario model is a financial model that captures multiple distinct views of the future simultaneously, typically a base case reflecting the management team's central expectations, upside cases reflecting a more favourable set of outcomes, and downside cases reflecting a genuinely adverse set of conditions, with a scenario selector that switches between them with a single input and updates all financial outputs simultaneously. Every scenario uses the same model structure and the same financial statement integration. Only the assumptions differ.
WHAT SENSITIVITY ANALYSIS ADDS
Sensitivity analysis tests how a key financial output changes as a specific assumption moves above and below its base case value. A two-way sensitivity table shows the output, typically revenue, EBITDA, or closing cash, across a matrix of two assumptions simultaneously. For a SaaS business: EBITDA across a range of customer acquisition costs on one axis and monthly churn rates on the other. For a property developer: project IRR across a range of construction costs and residential sale prices.
WHERE SCENARIO MODELLING FITS
Scenario and sensitivity analysis appear in most significant financial engagements, not as a standalone deliverable but as a layer built into a larger model. Two contexts where it is especially important are valuation and transactions.
In a business valuation modelling engagement, sensitivity analysis is the tool that turns a single-point valuation into a defensible range. No valuation assumption, discount rate, terminal growth rate, exit multiple, is known with certainty. A two-way sensitivity table showing, say, enterprise value across a range of discount rates and EBITDA exit multiples gives a buyer, seller, or investor a complete picture of where value sits and how sensitive it is to the assumptions they are most likely to contest.
In an M&A financial modelling context, scenario analysis does a different job: it models the deal itself under different structures. What does the combined entity look like if synergies are realised in year two rather than year one? What does the acquisition look like if the vendor's revenue projections come in 20 percent below expectation? What is the return profile across a range of purchase price multiples? These are the questions that scenario analysis answers before a deal is executed rather than after.
WHO WE WORK WITH
Wiseworth builds scenario models and sensitivity frameworks for Australian businesses across a wide range of sectors. Two industries where scenario analysis is especially critical are fintech and high-growth data businesses, where assumptions about customer acquisition, churn, and unit economics are genuinely uncertain at early stages and where investors will interrogate every assumption in the model, and infrastructure and energy projects, where long-run sensitivity to commodity prices, regulatory change, and construction costs can determine a project's viability across the full life of the asset.
FAQ
What is scenario analysis in financial modelling?
The practice of testing a financial model's outcome under different sets of assumptions, base case, upside and downside, to show the range of outcomes rather than a single projection.
What is the difference between scenario analysis and sensitivity analysis?
Scenario analysis changes multiple assumptions together to model a coherent story, such as a downturn or a competitor entering the market. Sensitivity analysis changes one assumption at a time to show how much that single variable moves the outcome.
Who needs scenario modelling?
Any business facing a decision where the range of outcomes matters. Capital raising, M&A, infrastructure investment, and board-level strategic planning are the most common contexts.
Can scenario analysis be added to an existing model?
Yes, provided the model's underlying structure supports it. If not, a financial model review will identify what needs to change first.
Does the downside case need to be genuinely adverse?
Yes. A downside case that is a cosmetically adjusted base case serves no analytical purpose. The downside should reflect conditions where the business is genuinely stressed, not just slightly inconvenienced.
See all financial modelling services.