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).

Football Field Chart Example

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:

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:

  1. Create a table in Excel with the range of values
  2. Insert a stock chart type called Open-Low-High-Close
  3. Set the Open and Low values as being the same
  4. Set the High and Close values as being the same

Download the free Football Field Chart Template

Enter your name and email in the form below and download the free template now!

Football Field Chart Template Screenshot

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.

 

Financial Analyst certification curriculum

 

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:

 

0 search results for ‘