Financial modelling6 min read
Football Field Valuation: Presenting a Valuation Range
A football field chart summarises a valuation: one horizontal bar per method, running from the low value to the high value. Well built, it shows at a glance where the methods overlap and which range to adopt.

What a football field valuation is for
No single method gives the value of a company on its own. A DCF (discounting future cash flows) depends on the discount rate and growth rate chosen, trading comparables on the sample, and precedent transactions on the deals of the moment. A football field valuation brings them together on one chart: each method becomes a horizontal bar running from its low value to its high value, on a single axis in millions of euros. The bars, stacked one under the other, look like the yard lines of an American football field, hence the name.
It is the page found in almost every investment banking book: a board presentation, a fairness opinion on the price of an offer, a sell-side memorandum. It answers the question the reader asks before any other: between which bounds does the value sit, and which methods pull it up or down?
The bars of a football field chart
Each bar summarises one method and its assumptions. The most common ones:
| Bar | What it measures | What moves the bar |
|---|---|---|
| DCF | The value of the company's future cash flows | The cost of capital and the terminal growth rate, in a sensitivity table |
| Trading comparables | The price the stock market pays for similar companies | The first and third quartile of the sample's multiples |
| Precedent transactions | The price paid when similar companies were acquired | The range of exit multiples, control premium included |
| LBO | The price a private equity fund can pay by financing part of it with debt | The fund's target rate of return |
| 52-week trading range | The share's lowest and highest prices over the past year | Listed companies only |
| Analyst price targets | The published target prices | Listed companies only |
For an unlisted company, keep the first four. All bars must express the same measure: either enterprise value (the value of the business to shareholders and lenders) or equity value (what belongs to shareholders). Mixing the two on one axis shifts the bars by the whole of the net debt.
Worked example: the Novatherm range
Let us return to Novatherm, the fictional manufacturer of thermal equipment from our article on trading comparables: expected 2026 EBITDA of €24m (operating profit before depreciation and amortisation), net debt of €40m. Each bar is calculated as an enterprise value.
Trading comparables
The sample's first quartile is 6.23 times EBITDA and the third is 7.33 times. Applied to €24m of EBITDA: €149.5m to €175.9m.
The DCF
Free cash flow of €12m in the first year, growing 4% a year over five years (€12.0m, €12.5m, €13.0m, €13.5m, €14.0m), then a terminal value calculated with the Gordon growth model. The cost of capital is varied from 9% to 10% and the terminal growth rate from 1.5% to 2.5%:
| Cost of capital | Growth 1.5% | Growth 2.0% | Growth 2.5% |
|---|---|---|---|
| 9.0% | 173.7 | 183.2 | 194.1 |
| 9.5% | 162.7 | 170.8 | 180.1 |
| 10.0% | 153.0 | 160.0 | 168.0 |
The bar runs between the two corners of the table: €153.0m to €194.1m, with a central value of €170.8m. Our article on the DCF terminal value explains why it accounts for more than 70% of the total here.
Precedent transactions
Recent acquisitions of companies in the sector were made at between 7.0 and 8.5 times EBITDA. These multiples are higher than those of the stock market, because the buyer pays for control of the company and for the savings it expects to make. On €24m: €168.0m to €204.0m.
The LBO
A fund finances the purchase with €96m of debt (4 times EBITDA). EBITDA grows 4% a year and reaches €29.2m in five years; the fund then sells at 6.9 times, or €201.5m, and the debt has fallen to €50m thanks to cash flow. Its equity is therefore worth €151.5m at exit. For an annual return (IRR) of 20%, it can put in 151.5 ÷ 1.2⁵ = €60.9m at the start; for 25%, €49.6m. Added to the €96m of debt: €145.6m to €156.9m. The method is detailed in our article on the paper LBO.
The chart and the range adopted
| Method | Low | High | Implied EBITDA multiple |
|---|---|---|---|
| LBO (IRR 20 to 25%) | 145.6 | 156.9 | 6.1x to 6.5x |
| Trading comparables (quartiles) | 149.5 | 175.9 | 6.2x to 7.3x |
| DCF (9 to 10%; 1.5 to 2.5%) | 153.0 | 194.1 | 6.4x to 8.1x |
| Precedent transactions | 168.0 | 204.0 | 7.0x to 8.5x |
Read off the chart, the result is clear. The LBO forms the floor: it is the price beyond which a financial buyer stops following. Transactions form the ceiling: a trade buyer can go that far if it counts on economies of scale. If it is listed, it will also check what that price does to its earnings per share, which is what the accretion dilution test measures. The DCF and the trading comparables overlap between €153m and €176m.
A defensible range sits in that zone: €160m to €175m of enterprise value, or 6.7 to 7.3 times EBITDA. After deducting the €40m of net debt, equity is worth €120m to €135m. This range is drawn as a vertical band on the chart, so that the reader sees which methods it covers.
Building a football field chart in Excel
Excel has no "football field" chart type. You build it from a horizontal stacked bar chart:
- Prepare three columns: the method, the low value, and the spread (high value minus low value). For the DCF: 153.0 and 41.1.
- Insert a stacked bar chart on those three columns. Each method becomes a bar in two pieces.
- Make the first piece invisible: right-click the "low value" series, fill "none", border "none". Only the spread remains visible, and it starts at the low value.
- Reverse the order of the categories (vertical axis format, "categories in reverse order") so that the first row of the table is at the top.
- Fix the horizontal axis at round bounds (here €140m and €210m) instead of starting from zero, otherwise the bars bunch up on the right.
- Add the labels: low value on the left, high value on the right, and the assumption under the name of the method ("IRR 20 to 25%").
- Draw the adopted range or the offer price with a scatter series on the secondary axis, or with two vertical lines.
Link the table's cells to each method's worksheets rather than retyping the values. When an assumption changes, the chart follows.
Mistakes that undermine a football field
- Bars that are too wide. A sensitivity table running from 7% to 12% cost of capital gives a bar that covers the whole chart and says nothing. Limit each variation to what you can justify.
- Bars that are too narrow. Conversely, a DCF bar reduced to a single point suggests a precision that does not exist.
- Mixing enterprise value and equity value. Put all bars on the same measure, and show the bridge from one to the other under the chart.
- Drawing the adopted range before the bars. If you adjust the assumptions so that each method lands in the range you want, the chart no longer proves anything.
- Forgetting what each method includes. Transactions include a control premium, the stock market does not. Placing their bars side by side without saying so leads the reader to average things that are different.
- Not dating it. Prices and multiples change: state the date of the share prices and accounts used.
Our football field Excel model brings together the ranges from the DCF, trading comparables, transactions and LBO, calculates the implied multiples and draws the chart with the adopted range. It is a calculation tool: the result remains an estimate that depends on your assumptions, and is neither a certified valuation nor investment advice.


