The Football Field Chart Excel Template is a popular tool used by finance professionals in investment banking, private equity, or other areas of corporate finance to summarize a range of stock price values for a company derived from various valuation methods. This type of charts allows investors to determine the appropriate price to pay for the acquisition of a business or a single share. A football field chart usually shows results from valuation methods including the discounted cash flow (DCF) analysis, precedent transactions (Precedents), comparable company analysis (Comps), and recent high and low share prices. Football field charts can be built in Excel using a stacked bar chart or the stock chart option. This template uses the latter method to create a football field chart in the following steps:
- Create a table with ranges of values from all valuation methods.
- Select the entire table and insert a stock chart type called Open-Low-High-Close.
- Set the Open and Low values to be the same.
- Set the High and Close values to be the same.