Bridgesheet

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.

Calculator and pen resting on a sheet of squared paper covered in notes
Photo: Unknown · CC0 · Rawpixel

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:

  1. operating profit grows at the long-term rate: 1,269 × 1.02 = €1,294k;
  2. investment equals depreciation and amortisation;
  3. 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.