What it means
Dynamic analysis treats a financial model as a machine you can prod rather than a report you read once. You change one input, or several together, and watch how profit, cash flow or valuation responds.
The word dynamic points at the two things a static forecast leaves out: how variables interact, and how outcomes develop over time. It matters because a single-point forecast is almost certainly wrong, and the useful question is not what the number is but how far it can move.
Boards approve investment far more comfortably when they can see a downside case alongside the plan, and lenders frequently insist on one. The exercise also shows which two or three assumptions drive most of the answer, which tells management where to concentrate.
In practice it comes in three forms. Sensitivity analysis flexes one input at a time and reports the effect; scenario analysis moves a coherent set of inputs together to describe a recognisable future such as a mild recession; simulation runs thousands of randomised combinations to produce a distribution of outcomes.
All three need the model to be properly linked, so that changing a price assumption flows through revenue, tax, working capital and cash without anyone patching numbers by hand. Results are usually presented as a table or a chart rather than prose.
A two-way grid showing profit across a range of price and volume assumptions lets a board see the shape of the risk in seconds, and a tornado chart ranks the inputs by how much each one moves the answer. Presentation matters here because the output of the exercise is a decision, not a spreadsheet.
The main nuance is that dynamic analysis is only as honest as the ranges you feed it. Flexing sales by plus or minus 2% in a business that has historically swung by 20% produces false comfort, and moving inputs independently ignores the fact that price and volume usually weaken together.
Better practice is to set ranges from the company's own history and to include at least one scenario where several things go wrong at the same time.
In practice
Real-world examples.
Example
A hotel group modelling a new 120-room property flexes occupancy between 58% and 76% and average room rate between $110 and $150. The grid shows the project loses money below 62% occupancy at any realistic rate, so the board makes the deal conditional on a lower land price.
Example
A subscription software business tests its three-year cash forecast against monthly churn of 1.0%, 1.6% and 2.4%. At the worst rate the company runs out of cash two months before its funding round, so the finance team brings the round forward and adds a covenant test to the monthly reporting pack.
Example
A manufacturer with debt priced off a floating rate runs its covenant model at interest rates 1, 2 and 3 percentage points higher than today. The middle case already breaches the interest cover covenant, so the treasurer fixes half the debt before the next reporting date rather than after it.
Think of it
“Dynamic analysis studies how things change over time-not just a snapshot but the whole movie.
Formula
Calculation
Sensitivity factor = % change in output / % change in input
Worked example: a components maker sells 100,000 units at $60 each, with variable costs of $30 a unit and fixed costs of $1,800,000.
Base case contribution = (60 - 30) x 100,000 = $3,000,000, so operating profit = 3,000,000 - 1,800,000 = $1,200,000.
Now flex the selling price down by 5%, to $57. Contribution becomes (57 - 30) x 100,000 = $2,700,000 and profit becomes 2,700,000 - 1,800,000 = $900,000, a fall of $300,000 or 25%.
Sensitivity to price = -25% / -5% = 5.0, so each 1% move in price moves profit by about 5%.
Running the same 5% cut on volume instead gives (60 - 30) x 95,000 = $2,850,000 of contribution and profit of 2,850,000 - 1,800,000 = $1,050,000, a fall of 12.5%. Sensitivity to volume is 12.5% / 5% = 2.5, exactly half the price figure, which tells management that protecting price is worth twice as much effort as protecting units.Case study
Seen in the real world.
Cedarline Beverages is a fictional drinks producer used here as an illustrative example. It planned a $14,000,000 canning line on the strength of a single forecast showing payback in four years, built on 82% capacity utilisation and a stable aluminium price.
The new finance director rebuilt the model with linked drivers and ran a dynamic analysis before the board vote. Flexing utilisation between 65% and 90% moved payback between three years and nine years, and a 15% rise in aluminium costs pushed it past seven years on its own. Combining both downside moves produced a project that never paid back inside its useful life.
The board did not cancel the investment. It bought a smaller line for $9,000,000 with an option to add a second, and hedged eighteen months of aluminium purchases. In this illustrative case the analysis did not predict the future; it simply showed that the original plan only worked if two uncertain things both went right.
Watch out
Common mistakes.
- Flexing inputs by tiny amounts so every scenario still shows a profit, which turns the exercise into a presentation rather than a test.
- Changing inputs by typing over formulas, which breaks the links in the model and produces numbers that cannot be reproduced next month.
- Moving each input independently when they are related in real life, such as assuming volume holds up while price collapses.
Questions
People also ask.
How many scenarios should a board see?
Usually three or four named cases plus a sensitivity table; more than that and the discussion turns into a review of the spreadsheet rather than the decision.
Is dynamic analysis the same as stress testing?
They overlap, but stress testing deliberately picks severe and unlikely conditions to see whether the business survives, while dynamic analysis covers the whole plausible range.
Do you need special software?
No, a well-built spreadsheet with a data table handles most sensitivity and scenario work, and simulation tools only become worthwhile when many uncertain inputs interact.
From the founder's library
Take it further with the book.
Build your financial confidence beyond this definition. Shihan's full-length guide, Accounting Fundamentals, takes the same plain-English approach and turns it into a complete, practical playbook for non-finance managers, business owners and students - with chapter-end quiz answers and presentation slides included.
25% off with code MMHQ25, applied at checkout. Priced in USD - checkout may show the equivalent in your local currency.
View the book and save 25%