Every financial model contains hundreds of assumptions.
Revenue growth rates, margin trajectories, working-capital days, capex intensity, discount rates, terminal growth, tax rates, debt service schedules. Most of them do not matter. Change them by 10%, and the valuation moves by 2%. The model is robust to their variation.
But inside every model, three to five assumptions carry disproportionate weight. Change any one of them by 10%, and the valuation moves by 20% or more. These are the load-bearing assumptions: the inputs on which the entire conclusion depends.
A sophisticated model does not merely produce a valuation. It identifies which assumptions can destroy it.
The Methodology
Step 1: Run a full sensitivity analysis
For every significant input in the model, vary it by plus and minus 10%, 20% and 30%. Record the valuation at each variation. The inputs whose variation produces the largest valuation change are the load-bearing assumptions.
Step 2: Identify the top three
In most models, three inputs dominate: typically some combination of revenue growth, operating margin, terminal growth rate, discount rate and working-capital intensity. These are the assumptions the board should focus its scrutiny on.
Step 3: Test each against evidence
For each load-bearing assumption, ask: what evidence supports this specific value? Is the evidence internal (management’s projection) or external (market data, competitor benchmarks, industry research)? If the evidence is purely internal, the assumption is a forecast. If it is supported by external evidence, the assumption is calibrated.
Step 4: Model the break-even
For each load-bearing assumption, calculate the value at which the investment thesis breaks: the valuation drops below the purchase price, the ROIC drops below WACC, or the DSCR drops below 1.0x. Then assess the probability that the assumption could reach the break-even value.
A model where a 15% decline in revenue growth (from 20% to 17%) destroys the investment thesis is a model that depends on the difference between 20% and 17% growth. If the historical range of the company’s growth rate includes values below 17%, the thesis is fragile.
The Terminal Value Problem
Terminal value typically represents 60% to 80% of total enterprise value in a DCF model. This means the valuation depends more on what the company earns in perpetuity (a guess) than on what it earns in the next five years (a projection).
A terminal growth rate of 3% versus 5% can shift the valuation by 30%. A terminal margin of 15% versus 12% can shift it by 25%. These are assumptions about the indefinite future, supported by no evidence, governed by no data, and responsible for the majority of the valuation conclusion.
The stress test for terminal value: calculate the enterprise value using terminal growth rates of 2%, 3%, 4% and 5%, and using terminal margins at the company’s current margin, the industry average margin and the 25th percentile margin. The range of valuations across these combinations reveals how sensitive the conclusion is to assumptions that no one can verify.
In Northrop Management Private Limited’s transaction advisory and due diligence work, every valuation is accompanied by a sensitivity matrix showing how the enterprise value changes across the most plausible range of each load-bearing assumption. The board or investor sees not just the valuation but the assumptions it depends on and the valuations it would produce if those assumptions were wrong.
Ashish Chaudhary, frames the modelling discipline directly: “A financial model that produces a single number is an opinion. A financial model that identifies which three assumptions can destroy the valuation is an analysis. The board should always ask for the second, because the first tells you what management wants the answer to be and the second tells you what the answer depends on.”
Questions for the Boardroom
- Which three assumptions in our financial model carry the largest impact on valuation
- For each, what is the break-even value at which the investment thesis fails?
- What evidence supports each load-bearing assumption, and is that evidence internal or external?
- What percentage of our enterprise value is attributable to terminal value, and how sensitive is it to the terminal growth rate and margin assumptions?
- If we varied each load-bearing assumption to the worst plausible value, would the investment still create value?
Closing Implication
A sophisticated financial model does not produce certainty. It identifies fragility. The three assumptions that carry the most weight are the three assumptions that deserve the most scrutiny, the most evidence and the most governance attention. Everything else in the model is noise.
