How to Make a Football Field Chart in Excel

A football field chart is a really nice way to visually display a range of valuations for a company or investment opportunity. It is super useful to demonstrating consistency in valuation methods and that you’ve thought about how sensitive your valuation is to different assumptions (i.e., a sensitivity analysis). Unfortunately, putting together a football field chart is kind of tricky. This video is a super basic example of how to get started making a football field chart. The final chart is not formatted well, but the point is just to give you a jumping off point to making a proper football field chart.