Financial modelling7 min read
DCF Model Review: 5 Checks Before You Trust the Value
A DCF model can show a value precise to the nearest thousand euros and still rest on a badly built cash flow. Here are the five checks to run before you believe the result, with an example where they take €3.1m off the equity value.

Why a DCF model review comes before reading the value
A DCF (discounted cash flows) values a company by adding up the cash flows it will produce, brought back to today's value. The result sits in a single cell. Behind that cell are hundreds of formulas, and one construction error is enough to move the value by 20%. Before you present or accept a figure, a DCF model review should follow the order in which the model is built: cash flow, assumptions, reinvestment, discounting, then terminal value.
The five checks below take an hour on a model of around ten tabs. They apply equally to a sell-side adviser's model and to one you built yourself.
The example: a distributor whose model shows €15.0m
Take Distribution Morel, a fictional distributor of industrial supplies. The model you receive assumes:
- revenue of €20.0m in year 0, growing 8%, 7%, 6%, 4% and then 2% over five years;
- an EBITDA margin (operating profit before depreciation and amortisation) of 12% and depreciation of 3% of revenue;
- corporation tax of 25%;
- a WACC (weighted average cost of capital) of 10%, perpetual growth of 2% and net debt of €5.0m.
The model concludes with an enterprise value of €20.0m and an equity value of €15.0m. Let us put it through the checks.
Check 1: does the cash flow start from the right profit?
The cash flow discounted at the WACC is the free cash flow available to all providers of capital, shareholders and banks alike. It is calculated as follows:
Free cash flow = operating profit × (1 − tax rate) + depreciation − capital expenditure − increase in working capital
Working capital is the cash tied up in inventory and trade receivables, net of trade payables. For the corrected year 1 of Distribution Morel: €1,944k of operating profit × 0.75 = €1,458k, plus €648k of depreciation, less €968k of capital expenditure and €240k of working capital increase, giving €898k.
Three errors come up often:
- Starting from net income. It is calculated after interest. Discounting it at the WACC and then deducting net debt counts the cost of debt twice.
- Calculating tax on EBITDA. Depreciation reduces tax; ignoring it overstates tax and understates the cash flow.
- Reversing the sign of working capital. An increase in working capital consumes cash, so it is deducted.
Also check that the forecast balance sheet balances every year. A gap points to a broken formula between the three financial statements, which our article on the three financial statements explains in detail.
Check 2: do the assumptions hold up against history?
Set the last three actual years beside the five plan years, on four ratios:
| Ratio | History (3 years) | Plan | Question to ask |
|---|---|---|---|
| Revenue growth | 5% a year | 8% then 7% | Which contract or market explains the acceleration? |
| EBITDA margin | 10 to 11% | 12% from year 1 | Which cost saving is already committed? |
| Capital expenditure / revenue | 4 to 5% | 3% | Why would the company invest less while growing faster? |
| Working capital in days of revenue | 55 days | not modelled | Will customers pay faster? |
A break from the past is not an error in itself. It must rest on a verifiable fact: a signed contract, a price rise already passed on, a factory already built. The shape to watch for is the hockey stick: a flat history, then a curve that climbs from year 1 of the plan. Here, the capital expenditure line gives away the next problem. To build a plan that survives this check, see our method for a business plan for valuation.
Check 3: does reinvestment follow growth?
A growing company has to fund its equipment and its working capital. In the model you received, capital expenditure equals depreciation and working capital does not move, even though revenue rises from €20.0m to €26.0m in five years (+30%). That is impossible: every extra euro of revenue ties up inventory and receivables.
For Distribution Morel, history shows that each extra euro of revenue requires €0.15 of working capital (55 days, or 15% of revenue) and €0.20 of equipment and warehousing. The table corrects the cash flows (in €k):
| Year | 1 | 2 | 3 | 4 | 5 |
|---|---|---|---|---|---|
| Revenue | 21,600 | 23,112 | 24,499 | 25,479 | 25,988 |
| Cash flow in the model received | 1,458 | 1,560 | 1,654 | 1,720 | 1,754 |
| Growth capital expenditure | −320 | −302 | −277 | −196 | −102 |
| Increase in working capital | −240 | −227 | −208 | −147 | −76 |
| Corrected cash flow | 898 | 1,031 | 1,169 | 1,377 | 1,576 |
The sum of discounted cash flows falls from €6.12m to €4.47m. The year 5 cash flow, which is the base for the terminal value, drops from €1,754k to €1,576k. Because year 5 growth equals perpetual growth (2%), this corrected cash flow is consistent with what follows: it includes exactly the reinvestment that 2% growth requires. Our article on working capital and business valuation explains the calculation in days.
Check 4: the discount rate and the timing
Three points to verify in the discounting lines:
- The right rate for the right cash flow. A cash flow available to all providers of capital is discounted at the WACC, not at the cost of equity. Also check that the WACC rests on a target capital structure rather than today's debt (see our article on WACC calculation).
- The right exponents. The year 1 factor is 1 ÷ 1.10 = 0.909, and the year 5 factor is 1 ÷ 1.10⁵ = 0.621. A frequent error discounts the terminal value over six years instead of five: on Distribution Morel, the enterprise value would fall from €16.94m to €15.81m, €1.1m lower for no reason.
- The timing convention. If the model assumes cash received mid-year (the mid-year convention), each cash flow is discounted half a year earlier, which lifts its value by about 4.9% at a WACC of 10% (1.10^0.5 = 1.049). Both conventions are defensible; the model must choose one, state it and apply it throughout.
Check 5: the terminal value and the bridge to equity
The terminal value summarises all the cash flows after year 5. With the corrected cash flow: 1,576 × 1.02 ÷ (10% − 2%) = €20.09m at the end of year 5, or €12.48m discounted. It represents 74% of the enterprise value. Two questions:
- Is its share reasonable? Between 60% and 80% is common. Above that, the plan stops too early.
- Is the implied multiple credible? 20.09 ÷ €3.12m of year 5 EBITDA = 6.4x. Compare it with sector multiples. The model you received showed 7.2x, because its cash flow ignored reinvestment.
Our article on the terminal value of a DCF explains these cross-checks in detail. That leaves the bridge to equity: deduct net debt at the valuation date (€5.0m here), not at the end of the plan, and check that debt-like items (pension provisions, declared but unpaid dividends) are included.
Finally, look at the sensitivity. On the corrected model, a WACC of 9% lifts the enterprise value to €19.5m, and a WACC of 11% brings it down to €14.9m. Perpetual growth of 2.5% instead of 2% adds €0.9m.
What the five checks change
| Model received | Corrected model | |
|---|---|---|
| Sum of discounted cash flows | €6.12m | €4.47m |
| Discounted terminal value | €13.89m | €12.48m |
| Enterprise value | €20.01m | €16.94m |
| Net debt | €5.00m | €5.00m |
| Equity value | €15.01m | €11.94m |
| Implied exit multiple | 7.2x | 6.4x |
A single construction error, forgetting reinvestment, takes €3.1m off the equity value, or 20%. The margin and growth assumptions from check 2 still need to be justified: if the margin falls back to 11%, the value drops further.
The checklist to keep to hand
- The cash flow starts from operating profit after tax, and the balance sheet balances every year.
- The plan's growth, margin, capital expenditure and working capital are compared with history, and every break has a written reason.
- Capital expenditure and working capital rise with revenue.
- The cash flow is discounted at the WACC, with the right exponents and a single timing convention.
- The terminal value is under 80% of the total, its implied multiple fits the sector, and net debt is taken at the valuation date.
Our Excel DCF model calculates free cash flow line by line, ties capital expenditure and working capital to growth, and shows the terminal value share, its implied multiple and a sensitivity table. It is a calculation tool: the result remains an estimate that depends on your assumptions, and is neither a certified valuation nor investment advice.


