How To Create A Football Field Chart In Excel For Financial Valuations The goal of the football field valuation chart summary is to sanity check various methodologies against one another. for example, a comparable company analysis might show high valuations during strong equity markets, while an intrinsic dcf valuation might show a lower valuation. the football field places those alternative valuation approaches. A quick video tutorial on how to create a football field chart in excel that can be useful to depict different valuation techniques. useful for finance stude.
How To Create A Football Field Chart In Excel Youtube 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. 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. Input your valuation data – set up your data with columns for valuation methodology, minimum value, and maximum value. select your data – highlight your input data to feed the football field chart. insert football field chart – go to charts > quick charts > football field. configure settings – select your data in the dialog box. A football field graph summarizes a range of values. the graph is widely used to compare the results of different valuation methodologies when applied to any given asset or business. in the finance world, it is used by business and asset valuators, investment bankers, and any other financial professionals who have a goal of summarizing.
How To Create Football Field Chart In Excel A Visual Reference Of Input your valuation data – set up your data with columns for valuation methodology, minimum value, and maximum value. select your data – highlight your input data to feed the football field chart. insert football field chart – go to charts > quick charts > football field. configure settings – select your data in the dialog box. A football field graph summarizes a range of values. the graph is widely used to compare the results of different valuation methodologies when applied to any given asset or business. in the finance world, it is used by business and asset valuators, investment bankers, and any other financial professionals who have a goal of summarizing. Follow along with the steps yourself using our downloadable football field chart template. football field valuation certificate if you are interested in this topic, look for our football field valuation certificate which reviews the different valuation methods, prepares valuation ranges for each valuation method, summarizes the valuation ranges, and interprets the results. Crafting the perfect football field chart. a football field chart combines various valuation methods in one view. it can show how different scenarios affect a company’s value. it’s best to create a clear, easy to understand chart. let’s dive into crafting a powerful football field chart that stands out for its precision and visual appeal.