Over 1.8 million professionals use CFI to learn accounting, financial analysis, modeling and more. Start with a free account to explore 20+ always-free courses and hundreds of finance templates and cheat sheets.
A football field chart is used to summarize a range of values for a business, based on different valuation methods. This guide includes a free Football Field Chart Template to download at the end of the page. The purpose of the chart is to show how much a buyer might be willing to pay for a business, whether acquiring all of it, part of it, or even a single share (depending on the audience).
Why is it called a valuation football field?
The chart is called this because the bars look like yard lines on an actual football field, and hence the name. Also, the graph is commonly used in investment banking, and bankers like sports analogies.
Why use a football field chart?
The reason they’re used is to visually show what the range of values for business are and see where, an average, a target valuation lies compared to several alternatives. It’s common to see these charts in an investment banking pitch book or equity research report, summarizing the various valuation methods that were used.
Football fields are easy to make in Excel using the stock chart option.
Here are the steps of how to make a football field chart in Excel:
Create a table in Excel with the range of values
Insert a stock chart type called Open-Low-High-Close
Set the Open and Low values as being the same
Set the High and Close values as being the same
Download the free template
Enter your name and email in the form below and download the free template now!
Valuation Football Field Chart – Excel Video Tutorial
Below is a video tutorial on how to use a stock chart in Excel to create a valuation football field chart. This is one of the lessons of our Business Valuation Modeling Course.
Below is a break down of subject weightings in the FMVA® financial analyst program. As you can see there is a heavy focus on financial modeling, finance, Excel, business valuation, budgeting/forecasting, PowerPoint presentations, accounting and business strategy.
A well rounded financial analyst possesses all of the above skills!
Additional Questions & Answers
CFI is the global institution behind the financial modeling and valuation analyst FMVA® Designation. CFI is on a mission to enable anyone to be a great financial analyst and have a great career path. In order to help you advance your career, CFI has compiled many resources to assist you along the path.
In order to become a great financial analyst, here are some more questions and answers for you to discover:
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.