How To Create A Football Profile

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 Valuation Methods When valuing a company as a going concern there are three main valuation methods used: DCF analysis, comparable companies, and precedent transactions . 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 Investment Banking Investment banking is the division of a bank or financial institution that serves governments, corporations, and institutions by providing underwriting (capital raising) and mergers and acquisitions (M&A) advisory services. Investment banks act as intermediaries , 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 Investment Pitch Deck Template This free pitch deck template is based on hundreds of investor presentations I've seen. Download the free template to build your investor pitch deck. or equity research report, summarizing the various valuation methods Valuation Methods When valuing a company as a going concern there are three main valuation methods used: DCF analysis, comparable companies, and precedent transactions that were used.

The range of valuation methods typically include:

Comparable Company Analysis Comparable Company Analysis This guide shows you step-by-step how to build comparable company analysis ("Comps") and includes a free template and many examples.
Precedent Transactions Precedent Transaction Analysis Precedent transaction analysis is a method of company valuation where past M&A transactions are used to value a comparable business today.
DCF Analysis DCF Model Training Free Guide A DCF model is a specific type of financial model used to value a business. The model is simply a forecast of a company's unlevered free cash flow
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!

Football Field Chart Template

Download the free Excel template now to advance your finance knowledge!

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 Become a Certified Financial Modeling & Valuation Analyst (FMVA)® CFI's Financial Modeling and Valuation Analyst (FMVA)® certification will help you gain the confidence you need in your finance career. Enroll today! , 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:

How to get a job in investment banking How to Get a Job in Investment Banking? This guide will outline how to get a job in investment banking using out top three tactics: networking and resume, interview prep, and technical skills
Investment banking interview questions Investment Banking Interview Questions & Answers Investment banking interview questions and answers. This real form was used by a bank to hire a new analyst or associate. IB interview insights & strategies. Questions are sorted into: bank and industry overview, employment history (resume), technical questions (finance, accounting, valuation), and behavioral (fit)
Excel formulas and functions Excel Formulas Cheat Sheet CFI's Excel formulas cheat sheet will give you all the most important formulas to perform financial analysis and modeling in Excel spreadsheets. If you want to become a master of Excel financial analysis and an expert on building financial models then you've come to the right place.
Lists of investment banks Careers Search CFI's career resources library. We've compiled the most important career resources for any job in corporate finance. From interview prep to resumes and job descriptions, we've got you covered to land your dream job. Explore guides, templates, and a wide range of free resources and tools