Football Field Chart Template
Downloadable Excel template
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.
What is a Football Field Chart?
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.
The range of valuation methods typically include:
- Comparable Company Analysis
- Precedent Transactions
- DCF Analysis
- Recent High and Low Share Prices
How do you make a valuation football field chart?
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.
More corporate finance resources
CFI is the official global provider of the Financial Modeling and Valuation Analyst (FMVA)™ certification, developed to transform anyone into a world-class financial analyst.
With that in mind, CFI’s vast library of resources to help you along your journey. Here are some useful we think you will find valuable:
Analyst Certification FMVA® Program
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:
- What is financial modeling?
- How do you build a DCF model?
- What is sensitivity analysis?
- How do you value a business?
