Valuation Model and Scenario Engine
The split-it thesis at full scale. The model builds a deterministic DCF skeleton, you validate the math against an assumptions ledger, and then the model writes the sensitivity narrative and the board pre-read framing. Assumptions traceability, sensitivities that bracket the base case, and narrative numbers that tie.
130 min
6
18
5
Learning Objectives
By the end of this chapter you should be able to:
- 1Define what a "board-ready" discounted-cash-flow valuation means, and why each figure tracing to the assumptions ledger comes before any sensitivity narrative.
- 2Apply the deterministic split at full scale: design the workflow so the model builds the DCF skeleton, the five-year free-cash-flow build and the terminal value, and narrates only after the base is validated.
- 3Assemble the minimal folder, the assumptions ledger and three years of historicals, and build the free-cash-flow projection and Gordon-growth terminal value from it.
- 4Run the red-lines check for valuation inputs, which can be material nonpublic information, and keep an AI-assisted valuation inside the normal corporate-development and finance review.
- 5Validate enterprise value by independently recomputing the discounted five-year free cash flow plus the discounted terminal value, and trace each component back to a ledger assumption.
- 6Recognize the failure modes of an AI-built DCF (an untied base, a terminal growth rate at or above the WACC, a sensitivity table that does not bracket the base, and a narrative written on an unvalidated model) and correct them.
- 7Reason about sensitivity and frame a board pre-read that leads with the base-case enterprise value and the swing factors, with each figure tied to the model.
- 8Recap the discounted-cash-flow model, free cash flow, the WACC, and terminal value, along with the established best practices for a defensible DCF: consistent cash flows and discount rate, a disciplined terminal value, grounded assumptions, and a sensitivity range, drawing on Damodaran's Investment Valuation, the McKinsey Valuation text (Koller, Goedhart, and Wessels), and the CFA Institute curriculum.
Part One: The Discounted Cash Flow, and What Makes One Defensible. Section 1 of 6.
Part One · The Discounted Cash Flow, and What Makes One Defensible
The Discounted Cash Flow, and What Makes One Defensible
Part One
The Discounted Cash Flow, and What Makes One Defensible
Before a tool builds anything, you have to be able to build it by hand and defend it. This part recaps the discounted cash flow: what it claims, the moving parts that drive it, and the practices that separate a valuation a board can lean on from one that only looks precise. The question of where a tool helps comes up at the end, once the work itself is clear.
What a discounted cash flow actually claims
A discounted cash flow (DCF) rests on a single claim: the value of a business is the present value of the cash it is expected to generate in the future, discounted at a rate that reflects the risk of those cash flows. Aswath Damodaran frames this as intrinsic valuation, value that comes from a company's own expected cash flows and risk rather than from what the market happens to be paying for similar assets today. It is the counterpart to relative valuation, where a business is priced off multiples of comparable companies. Both have a place, and a DCF is the one that forces you to state, explicitly, what you believe about the business.
This matters because the DCF sits under some of the highest-stakes decisions in corporate finance. It is how deal teams frame what a target is worth, how a board weighs a capital commitment, how a fairness opinion is supported, and how an impairment test is anchored. When the number is wrong, the decision it informs tends to be wrong, and the error is rarely obvious on the page, because a DCF is a chain of arithmetic where one broken link quietly corrupts everything downstream of it.
The moving parts: free cash flow, the discount rate, and the terminal value
A DCF has a small number of load-bearing parts, and getting each one internally consistent is most of the craft.
Free cash flow is the cash a business throws off after it has paid to keep running and to grow: operating profit after tax, plus non-cash charges, less reinvestment in working capital and capital expenditure. In an enterprise DCF, the convention followed in Koller, Goedhart, and Wessels is to project unlevered free cash flow, the cash available to all capital providers before financing, so that the effect of leverage lives in the discount rate rather than in the cash flows themselves.
The discount rate converts future cash into today's dollars. For unlevered free cash flow it is the weighted average cost of capital (WACC), the blended after-tax cost of debt and cost of equity, weighted by the firm's target capital structure. The CFA Institute curriculum states the consistency rule plainly: free cash flow to the firm is discounted at the WACC, and free cash flow to equity at the cost of equity. Mixing the two, discounting equity cash flows at a WACC, is one of the more common ways a model quietly overstates or understates value.
The terminal value captures everything beyond the explicit forecast. Because you cannot project year by year indefinitely, you forecast a handful of years explicitly, until the business reaches a steady state, and then capitalize the final year with a continuing value. The constant-growth (Gordon growth) form grows the final-year free cash flow one period and divides by the spread between the discount rate and the perpetual growth rate. That single figure often accounts for a large share of the total value, which is why its assumptions deserve the most scrutiny rather than the least.
What separates a defensible valuation from a plausible one
The difference between a valuation a board can lean on and one that only looks precise comes down to discipline on a few points that the sources return to again and again.
- Keep the cash flows and the discount rate consistent. Nominal cash flows go with a nominal rate, a given currency with its own rate, and unlevered cash flows with the WACC. Damodaran treats this internal consistency as one of the first things to check, because a mismatch can move the answer more than any single assumption.
- Discipline the terminal value. The perpetual growth rate has to sit below the discount rate, or the Gordon denominator collapses, and Koller and colleagues caution that a company is unlikely to outgrow the broad economy indefinitely, so a sensible terminal growth rate is bounded by long-run nominal economic growth. A useful check is to see what share of enterprise value sits in the continuing value, and to look at the growth and returns that value implies.
- Ground the assumptions rather than reverse-engineer them. Growth, margin, and reinvestment should trace to the company's own history and to the economics of its industry, not be tuned backward to hit a number someone already had in mind.
- Show the range, not a false point. A DCF output is an estimate carrying real uncertainty, so sound practice pairs the base case with sensitivity and scenario analysis on the assumptions that move it most, typically the discount rate and terminal growth.
- State every input. A reviewer should be able to see each assumption and follow it into the model. An answer no one can trace is an answer no one can challenge.
Meridian's board, and why the work splits
Hold that standard against a live task. You are on the corporate development team at Meridian Components, a mid-market industrial parts manufacturer weighing a strategic investment. The board meets in a week and wants a valuation: what the business is worth on a discounted-cash-flow basis, what moves that number, and where the base case is exposed. The deliverable is a written pre-read a director will skim in about five minutes.
Board-ready is a standard, not a spreadsheet, and it has four properties. A board-ready valuation is traceable, so each figure ties back to a stated assumption; it recomputes, so an independent recalculation of the discounted cash flows lands on the same enterprise value; it is bounded, so a sensitivity view shows how the value flexes rather than presenting one point as certain; and it is framed, reading as a pre-read that leads with the base case and the swing factors rather than a raw model dump. Two of those properties depend on an assumptions ledger: the single record of each input, growth, margin, tax, capital intensity, discount rate, and terminal growth, that every figure in the model traces back to. Pinning that ledger down is the analyst's job, not the tool's.
Notice how the work divides. The middle of a DCF, projecting free cash flow, capitalizing a terminal value, discounting at the WACC, and summing to enterprise value, is a long, deterministic calculation with one right answer for a given ledger. The judgment sits at the two ends, in the assumptions that feed the model and in the narrative that frames the result. That clean split, a mechanical model in the center and judgment at the edges, is what makes this task a good candidate for AI assistance, and it is the design the next part builds on.
Check Your Understanding
Knowledge Check 1
Valuation & DCF
A discounted cash flow model projects free cash flow of $20,000 thousand in the final explicit year. Cash flow is assumed to grow at 2.5% per year in perpetuity thereafter, and the discount rate (WACC) is 10%. Using the Gordon growth method, what is the terminal value as of the end of the final explicit year?