Skip to main content
Back to Feed

Football Field Charts: Visualizing the Range

Comments
Your preferences have been saved

The "Football Field" chart is the gold standard for presenting a valuation summary. It is called a football field because the horizontal bars representing different valuation methods look like the yard lines on a field. The purpose of this chart is to show that valuation is not a single point, but a range of possibilities. By plotting the results of your DCF, your P/E Comps, your EV/EBITDA Comps, and perhaps Precedent Transactions all on one graph, you can identify the "overlap" where the most likely fair value resides .

Components: Building the Bars

To create a comprehensive football field, you need to pull data from every method you have used. Each "bar" on the chart represents the "Low" and "High" estimates for that specific method.

  1. Intrinsic Valuation (DCF): The range here usually comes from your sensitivity analysis (e.g., the values at different WACC and Growth intersections) .
  2. Comparable Company Analysis (Public Comps): You might use the 25th percentile and 75th percentile of your peer group's multiples (like P/E or EV/EBITDA) to create this range .
  3. Precedent Transactions: This bar shows what acquirers have paid for similar companies in the past. These often include a "Control Premium," meaning they are usually higher than public trading multiples .
  4. 52-Week High/Low: This provides market context, showing where the stock has actually traded over the past year.

Step-by-Step: Interpreting the Overlap

Once the bars are plotted, the analyst looks for "Convergence."

  • Step 1: Identify the Cluster. Look for the price range where the most bars overlap. For example, if the DCF says $80-$100, P/E says $85-$105, and EV/EBITDA says $82-$98, the "Cluster" is roughly $85-$95.
  • Step 2: Check for Outliers. If one bar is significantly higher or lower than the others, ask why. For instance, if Precedent Transactions are much higher, it might be because buyers are paying for "Synergies" (cost savings) that a regular investor wouldn't get .
  • Step 3: Compare to Current Price. Draw a vertical line through the chart representing the current market price. If the line is to the left of your cluster, the stock is "Undervalued." If it's to the right, it's "Overvalued."

Case Study: The Valuation Shift of X (Twitter)

The story of X (formerly Twitter) provides a perfect example of how valuation ranges can shift dramatically. When Elon Musk purchased Twitter for $44 billion in 2022, many analysts argued the price was too high based on traditional metrics like advertising revenue and user growth .

By 2024, institutional investors like Fidelity had marked down the value of their holdings in X by approximately 72% . If we were to look at a Football Field chart for X over time, we would see the bars shifting violently:

  • 2022 (Pre-Acquisition): Comps and DCF might have suggested a range of $25-$35 billion. The purchase price of $44 billion was an outlier, likely representing a "Strategic Premium" or "Synergy" value .
  • 2024 (Private): With advertising revenue dropping by 50% and high debt loads, the new DCF and Comps (comparing X to Meta or Snap) would show a range closer to $10-$15 billion .

This case illustrates that private company valuations often vary widely because they lack the "ready-made" stock price of public markets and require analysts to make more "educated guesses" .

Decision: The Buy, Sell, or Hold Framework

The final goal of the football field is to make a recommendation. This is where you apply your "Margin of Safety."

  • Buy: The current market price is significantly below your target range (e.g., 20% or more). This provides a cushion in case your assumptions are too optimistic.
  • Sell: The current market price is significantly above your target range. This suggests the market is "overheated" or pricing in growth that is unlikely to happen .
  • Hold: The current market price falls right in the middle of your valuation bars. The stock is "Fairly Valued," and there isn't enough potential upside to justify the risk of a new position.

Multiples: Choosing the Right Metric for the Field

Not all multiples are created equal. Depending on the industry, you should prioritize different bars on your football field:

  • P/E Ratio: Best for stable, profitable companies. It shows how much investors pay for $1 of earnings .
  • EV/EBITDA: Great for capital-intensive industries (like manufacturing) because it ignores debt structures and non-cash expenses .
  • Price-to-Book (P/B): Essential for banks and insurance companies where the value is tied to the balance sheet assets .
  • Price-to-Sales (P/S): Useful for high-growth tech startups that aren't profitable yet but have massive revenue .
Valuation Method Low Estimate High Estimate Why the Range?
DCF (Intrinsic) $82.00 $95.00 Based on 8%-10% WACC.
P/E Comps $88.00 $102.00 Based on 15x-18x Peer Average.
EV/EBITDA Comps $85.00 $98.00 Based on 10x-12x Peer Average.
Precedent Trans. $95.00 $115.00 Includes 20% Control Premium.
Current Price $78.00 $78.00 Market Price (BUY SIGNAL)

, ,

Summary: The Final Verdict

In the end, your valuation is a story told in numbers. The DCF tells the story of the company's internal health and its ability to generate cash . The Relative Valuation tells the story of the market's current mood and what other investors are doing . The Sensitivity Analysis tells the story of what could go wrong (or right) in an uncertain future . By synthesizing these stories into a single Football Field chart, you provide a clear, defensible, and professional "Final Verdict." Remember, the goal isn't to be "right" to the penny—the goal is to be "approximately right" and avoid being "precisely wrong." With a solid range and a healthy margin of safety, you are now equipped to make informed investment decisions in any market environment.

Was this article helpful?

References

[1]
Comparables Approach to Equity Valuation Explained
investopedia.com
[2]
Net Present Value (NPV): What It Means and Steps to Calculate It
investopedia.com
[3]
Relative Valuation Model: Definition, Steps, and Types of Models
investopedia.com
[4]
How to Value Private Companies
investopedia.com
[5]
Multiples Approach: Definition and Example
investopedia.com
[6]
Price-to-Book (P/B) Ratio: Meaning, Formula, and Example
investopedia.com
[7]
Free Cash Flow Yield: The Best Fundamental Indicator
investopedia.com
[8]
How to Create a Monte Carlo Simulation Using Excel
investopedia.com

Comments