A football field puts every valuation method on one chart: a horizontal bar per method, from its low value to its high, with the offer price as a vertical line. Boards and buyers read it at a glance.
The work is in the table behind it, because the methods come out on different bases:
- Enterprise value ranges (comps, precedents, DCF) need the bridge: (EV - net debt) / diluted shares.
- Equity value ranges (P / E comps) only need dividing by shares.
- Per-share ranges (the 52-week trading range, analyst targets) are already there.
A Basis column and one IF formula convert every row to the same scale, so a new method only needs its basis typed in. For the chart, each bar starts at the low value and has a width of high minus low: in a stacked bar chart the first series is invisible and the second is the bar.
Mixing bases is the classic mistake: an EV range plotted next to per-share prices makes the company look many times more valuable than it is.