Football Field Chart Template

Downloadable Excel template

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 someone 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 football field?

The bars look like yard lines on a 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 it’s used is to visually show what the range of values for a 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.

 

How do you make a 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 Football Field Chart Template File

Download Football Field Chart Template

 

Football Field Chart Template

 

More corporate finance resources

At CFI our mission is to help you advance your career. With that in mind, we’ve created a vast library of resources to help you along your journey. Here are some useful we think you will find valuable:

For more career development, check out our interactive Career Map.