
Originally published: 02/08/2016 09:01
Last version published: 26/01/2017 15:13
Publication number: ELQ-71651-2
View all versions & Certificate
Last version published: 26/01/2017 15:13
Publication number: ELQ-71651-2
View all versions & Certificate

Football Field Graph
Representing the spread of key PE ratios in floating columns/bars.
Dheeraj Vaidya CFA FRM offers you this Best Practice for free!
download for free
Add to bookmarks
Reviews
Write a review
People using this Best Practice also downloaded
More Best Practices from Dheeraj Vaidya CFA FRM
Loan Amortization Schedule Calculator
Simple and effective tool for debt scheduling and loan amortization427Discussadd_shopping_cartBox IPO (Initial Public Offering)
Indepth analysis of BOX IPO with DCF and relative valuation591Discussadd_shopping_cartComparable Company Analysis
Arrive at the right multiple (EV/Sales, P/E etc.) to prepare the comparable comps.1,667Discussadd_shopping_cartValuation Waterfall Graph
Show your audience how the share price of a target company can be broken up in its sub-components1,285Discussadd_shopping_cartBeta Calculation Worksheet
Compute the Beta needed for your CAPM as to calculate the expected return of a company's share1,009Discussadd_shopping_cartPrivate Equity Chart Template
Visualize the Valuation multiple of Stock or Index over a period of time.822Discussadd_shopping_cartScenario Graph Template
Visualize the different options a stock price can take according to a number of variables3,2562add_shopping_cartPrivate Equity Band Chart Template
Compute the Price to Earnings (or other PE ratios) Band Chart for your target stock or index830Discussadd_shopping_cartAlibaba IPO Financial Model
A full IPO financial model ready to be adapted and tweaked to any other company1,385Discussadd_shopping_cartColgate Financial Model (Unsolved & Solved Versions)
A full financial model ready to be adapted to any other company + a blank template1,508Discussadd_shopping_cartFree Cash Flow (FCFF) Template
Compute the FCFF for a firm through three different methods (EBIT, EBITDA and Net Income)636Discussadd_shopping_cartTerminal Value Calculation Excel Template
Compute the Terminal Value of a stock (Perpetuity and Exit Multiple Methods) with this excel spreadsheet3,814Discussadd_shopping_cart
Any questions on Football Field Graph?
The user community and author are here to help. Go ahead!