Publication number: ELQ-63154-1
View all versions & Certificate
Comparable Company Analysis
Arrive at the right multiple (EV/Sales, P/E etc.) to prepare the comparable comps.
Dheeraj Vaidya CFA FRM offers you this Best Practice for free!
download for free
Add to bookmarks
4.6 / 5 (15 votes)
Write a review
People using this Best Practice also downloaded
Loan Amortization Schedule CalculatorSimple and effective tool for debt scheduling and loan amortization395add_shopping_cart
Box IPO (Initial Public Offering)Indepth analysis of BOX IPO with DCF and relative valuation536add_shopping_cart
Valuation Waterfall GraphShow your audience how the share price of a target company can be broken up in its sub-components1,196add_shopping_cart
Beta Calculation WorksheetCompute the Beta needed for your CAPM as to calculate the expected return of a company's share943add_shopping_cart
Private Equity Chart TemplateVisualize the Valuation multiple of Stock or Index over a period of time.775add_shopping_cart
Scenario Graph TemplateVisualize the different options a stock price can take according to a number of variables3,180add_shopping_cart
Private Equity Band Chart TemplateCompute the Price to Earnings (or other PE ratios) Band Chart for your target stock or index766add_shopping_cart
Football Field GraphRepresenting the spread of key PE ratios in floating columns/bars.382add_shopping_cart
Alibaba IPO Financial ModelA full IPO financial model ready to be adapted and tweaked to any other company1,268add_shopping_cart
Colgate Financial Model (Unsolved & Solved Versions)A full financial model ready to be adapted to any other company + a blank template1,442add_shopping_cart
Free Cash Flow (FCFF) TemplateCompute the FCFF for a firm through three different methods (EBIT, EBITDA and Net Income)604add_shopping_cart
Terminal Value Calculation Excel TemplateCompute the Terminal Value of a stock (Perpetuity and Exit Multiple Methods) with this excel spreadsheet3,688add_shopping_cart
Any questions on Comparable Company Analysis?
The user community and author are here to help. Go ahead!