Financial modelling7 min read
Business Plan for Valuation: Build a 5-Year DCF Forecast
In a DCF, the business plan weighs more than the discount rate. Here is how to build five years of cash flows from the drivers of the business, using a manufacturing SME valued at €9.8m.

Business plan for valuation: what a DCF expects from the plan
A DCF (discounted cash flows) estimates the value of a company by adding up the cash it will produce, brought back to today's value. In this valuation, the business plan supplies the cash flows: five years of revenue, costs, investment and working capital. One extra point of margin in the plan moves the value more than half a point of discount rate.
The plan handed over by an owner often fits on two lines: "8% growth a year, 15% margin in five years". A buyer or an auditor cannot check anything in those two lines. A credible business plan for a valuation starts from the drivers of the business (volumes, prices, contracts, headcount, machines) and lets the margin come out of the calculation. The method takes six steps.
The example: Mécanique Vasseur, €12.0m of revenue
Mécanique Vasseur is a fictional precision machining subcontractor. Its last three financial years give the starting point:
- revenue of €11.2m, €11.6m then €12.0m, which is 3.5% growth a year;
- EBITDA (operating profit before depreciation and amortisation) of €1.32m in the latest year, or 11% of revenue;
- materials and subcontracting: 45% of revenue;
- payroll of €4.2m, other fixed costs of €1.08m;
- working capital (stock and trade receivables, minus trade payables) of 16% of revenue, or 58 days;
- net debt of €2.0m.
The owner has just signed a contract with an aerospace equipment maker: €1.0m of revenue a year from the middle of year 2.
Step 1: revenue, driver by driver
Separate the existing business from what is new, and tie each line to a fact.
- Existing business. It extends the history: 3.5% for the first two years (2% volume, 1.5% price), then 3%, 2.5% and 2%. Growth slows towards the long-term rate that the terminal value will use.
- New contract. €0.5m in year 2 (six months), €1.0m a year after that. The contract is signed, so it goes into the central scenario. A tender still in progress would belong in the high scenario.
Revenue goes from €12.0m to €14.84m in five years, an average of 4.3% a year. The 7.5% jump in year 2 has a written cause.
Step 2: costs, with variable and fixed kept apart
A margin set as a percentage hides how costs actually work. Model three blocks:
- Variable costs: 45% of revenue, as in the history.
- Payroll: +3% a year, plus the hires tied to the contract. Three operators in year 2 and a fourth in year 3, at €55k fully loaded each.
- Other fixed costs: +2% a year.
| In €k | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| Revenue | 12,420 | 13,355 | 14,240 | 14,571 | 14,843 |
| Variable costs | 5,589 | 6,010 | 6,408 | 6,557 | 6,679 |
| Payroll | 4,326 | 4,621 | 4,815 | 4,959 | 5,108 |
| Other fixed costs | 1,102 | 1,124 | 1,146 | 1,169 | 1,192 |
| EBITDA | 1,403 | 1,600 | 1,871 | 1,886 | 1,864 |
| EBITDA margin | 11.3% | 12.0% | 13.1% | 12.9% | 12.6% |
The margin rises from 11% to 13.1% because the contract is added to fixed costs that are already being paid. It then falls back: salaries rise by 3% a year while revenue grows by only 2%. A plan with an imposed margin would have missed this reversal.
Step 3: investment and working capital follow growth
A growing company has to fund machines, stock and receivables. Build three lines:
- Maintenance investment: 3.5% of revenue, the historical level.
- Growth investment: a €600k machining centre in year 2 to serve the contract, depreciated over eight years (€75k a year).
- Increase in working capital: 16% of the additional revenue. Our article on normalised working capital explains the calculation in days.
Step 4: from profit to free cash flow
The cash flow discounted in a DCF belongs to all the providers of capital, shareholders and banks alike:
Free cash flow = operating profit − tax + depreciation and amortisation − investment − increase in working capital
Tax is calculated on operating profit, at a rate of 25%.
| In €k | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| EBITDA | 1,403 | 1,600 | 1,871 | 1,886 | 1,864 |
| Depreciation and amortisation | 435 | 542 | 573 | 585 | 595 |
| Operating profit | 968 | 1,058 | 1,298 | 1,301 | 1,269 |
| Tax (25%) | −242 | −264 | −324 | −325 | −317 |
| Investment | −435 | −1,067 | −498 | −510 | −520 |
| Increase in working capital | −67 | −150 | −142 | −53 | −44 |
| Free cash flow | 659 | 119 | 907 | 998 | 983 |
Year 2 releases only €119k: the machine and the contract's working capital absorb the cash before the contract pays back. A plan showing cash flows that rise steadily has forgotten this lean year.
Step 5: a normalised year for the terminal value
The terminal value sums up the cash flows after year 5. It rests on a "normalised" cash flow, that of a cruising year. The common mistake is to extend the year 5 cash flow as it stands. Yet in that year Mécanique Vasseur invests €520k and depreciates €595k: it wears out its equipment faster than it replaces it, which cannot go on for ever.
The normalised year corrects three points:
- operating profit grows at the long-term rate: 1,269 × 1.02 = €1,294k;
- investment equals depreciation and amortisation;
- working capital grows with revenue: 2% × €2,375k = €47k.
Normalised cash flow: 1,294 − 324 of tax − 47 = €923k, against €1,003k if year 5 is simply extended. The €80k gap represents €0.6m of enterprise value. Our article on the terminal value of a DCF compares this formula with the exit multiple.
Step 6: test the consistency of the plan
Before discounting, compare the plan with the history on four ratios:
| Ratio | History | Plan | Justification |
|---|---|---|---|
| Revenue growth | 3.5% a year | 4.3% a year | Signed contract of €1.0m |
| EBITDA margin | 11% | 12.6% in year 5 | Fixed costs better absorbed |
| Investment / revenue | 3.5% | 3.5% + €600k in year 2 | Machine dedicated to the contract |
| Working capital in days of revenue | 58 days | 58 days | No change in payment terms |
Add a fifth test: the margin on the additional revenue. EBITDA gains €544k on €2,843k of extra sales, or 19%. Variable costs leave 55% of each sale; hires and pay rises absorb the difference. A plan that converted 40% of new sales into EBITDA would assume a factory with no hiring and no pay rises.
From the plan to the value
With a cost of capital (WACC) of 10% and long-term growth of 2%:
| Amount | |
|---|---|
| Sum of discounted cash flows (years 1 to 5) | €2.67m |
| Terminal value: 923 ÷ (10% − 2%) = €11.54m, discounted | €7.16m |
| Enterprise value | €9.83m |
| Net debt | −€2.00m |
| Equity value | €7.83m |
The terminal value makes up 73% of enterprise value and equals 6.2 times the year 5 EBITDA, two benchmarks to compare with sector multiples.
The owner's "8% a year, 15% margin" plan would give €17.6m of revenue in year 5 and an enterprise value of €15.1m, with the same investment and working capital rules. The €5.3m gap rests on two percentages that nobody can tie to a contract or a hire.
Scenarios: move the drivers
A scenario changes one fact, and the lines of the plan follow. Two examples on Mécanique Vasseur:
| Scenario | Assumption changed | EBITDA margin in year 5 | Enterprise value |
|---|---|---|---|
| Low | Contract lost, growth of 2% a year, no machine | 9.2% | €6.4m |
| Central | Signed contract of €1.0m | 12.6% | €9.8m |
| High | Contract raised to €1.5m from year 3, one more hire | 13.6% | €11.3m |
The low scenario shows a risk that the two-line plan hid: without growth above the rate of salary increases, the margin falls from 11% to 9.2%. Our article on reviewing a DCF model lists the checks to run next on the full model.
Pitfalls to avoid
- The hockey stick. A flat history followed by acceleration from year 1, with no contract or launch to explain it.
- The imposed margin. It hides the hires and pay rises that growth requires.
- Frozen working capital. Each extra euro of sales ties up €0.16 of stock and receivables here.
- Year 5 mistaken for a cruising year. Check that investment covers depreciation and amortisation and that growth has reached the long-term rate.
- A plan that is too short. If the company is still growing by 8% in year 5, extend the plan until growth settles.
Our Excel DCF model builds free cash flow line by line from your assumptions on growth, margin, investment and working capital, then shows the terminal value, its weight and a sensitivity table. It is a calculation tool: the result remains an estimate that depends on your plan, and is neither a certified valuation nor investment advice.


