football chart template

a football field chart is used to summarize a range of values for a business, based on different valuation methods. 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). 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.

below is a video tutorial on how to use a stock chart in excel to create a valuation football field chart. 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.

in this tutorial, you’ll learn how to create a flexible football field valuation template in excel, including a line for the company’s current share price that updates automatically when the share price changes – which is missing from most templates you’ll find. second, most templates do not support percentile ranges from different methodologies, such as the 25th, median, and 75th percentiles – but that’s what all banks do in real life.

third, most templates do not include support for a dynamic share price line that updates on the graph when the company’s current share price range. for example, you often show only the 25th percentile to 75th percentile and hide the rest: part 2 of the football field valuation chart involves adding the company’s current share price as a vertical line, which is much harder than it sounds: step 2.1: create a “dummy series” for the current share price under the main data area, and link to the current share price in the min to max columns and then a dummy number, such as 1,000, followed by 0’s: step 2.2: right-click the graph, go to select data, and then go to “add” under legend entries (series) and use “current share price” for the series name and the dummy series for the series values: step 2.3: now, left-click this new bar on the graph and manually change the series formula in the formula bar so that it has both x and y values. this is the trick: step 2.4: right-click the current share price bar in the football field valuation, go to change series chart type, and select “scatter with smooth lines and markers.” the secondary axis box will be checked automatically: step 2.5: right-click the graph, go to select data, and for the first “blank” series, change the horizontal axis labels to the names on the left-hand side, and click ok: in real life, you don’t have to complete this series of steps to create and format football field charts: you take a template from an existing file and modify the graph as necessary.

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 this football field chart template can be used to summarize a range of values for a business, based on different valuation methods. football field valuation: excel template for creating a football field valuation chart with a dynamic share-price line for use in investment banking., football chart excel, football chart excel, football field chart, horizontal football field chart excel, football field chart powerpoint.

the football field is a floating bar chart in excel that puts valuation analyses side-by-side, providing clients with the full context of a company’s value. football field graphs (american football) to illustrate ranges in value making the bar chart with the range of values is pretty simple. a quick tutorial on how to create a football field chart in, football field valuation summary, football field valuation chart, how to make football field chart, football field chart type, football field analysis, football field valuation investopedia, investment banking football field, football field chart google sheets, football field template pdf, lbo football field.

When you try to get related information on football chart template, you may look for related areas. football chart excel, football field chart, horizontal football field chart excel, football field chart powerpoint, football field valuation summary, football field valuation chart, how to make football field chart, football field chart type, football field analysis, football field valuation investopedia, investment banking football field, football field chart google sheets, football field template pdf, lbo football field.