Login
Self-Study Courses
Virtual Boot Camps
1:1 Coaching
Corporate Training
On-Campus Training
Free Content
Support/Contact Us
About Wall Street Prep
Find the video exercise for this lesson below.
One of the most common slides in an investment banking pitchbook is the football field. The football field is a floating bar chart in Excel that puts several valuation analyses side-by-side to provide clients with the full context of a company’s value using a variety of methodologies and assumptions. A typical football field valuation matrix will include company value based on:
- DCF valuation
- LBO analysis
- Comparable company analysis
- Comparable transaction analysis
- Trading 52-week high and low
- Liquidation analysis (optional)
- Sum of the Parts Analysis (optional)
The purpose of the football field
The purpose of the football field valuation is to create a visual summary of all the valuation analyses that were performed on a company and to demonstrate a valuation range based on those valuation methodologies. The goal of the summary is to sanity check various methodologies against one another. For example, a comparable company analysis might show high valuations during strong equity markets while an intrinsic DCF valuation might show a lower valuation. The football field places those alternative valuation approaches side by side when arriving at a valuation range. In addition to being a staple of the investment banking pitchbook, it is also used in fairness opinions.
Excel Template and Video: Building the football field
Below is an excerpt from Wall Street Prep’s full Financial Modeling Training Package. Be sure to download the Excel Football Field template before watching:
