Investment bankers often need to present a range of valuations for a company based on different methodologies like comparable companies analysis, precedent transactions analysis, DCF analysis, and LBO analysis.
One effective way to visually present these valuation ranges is through a football field chart (also known as a floating bar or column chart). This chart allows you to easily compare multiple valuation ranges in a clean graphical format.
In this post, I’ll walk you through step-by-step how to build a football field chart in Excel to showcase valuation ranges in investment banking.
- Why Use a Football Chart
- How to Build Your Football Field Chart in Excel
- Building a Football Field Chart Faster with Macabacus