Originally published: 02/08/2016 09:00
Publication number: ELQ-63154-1
View all versions & Certificate
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
Reviews
4.6 / 5 (17 votes)- 65%
- 35%
- -
- -
- -
Write a review
People using this Best Practice also downloaded
Dealing with Employee Options
Learn how to value employee options and inserting this share in the value of your equity per share.1,134Discussadd_shopping_cartfree
by Aswath Damodaran
Evaluating Financial Performance and Forecasting
Set of worksheets related to financial analysis and forecasting824Discussadd_shopping_cartfree
by Matt Evans
Bridge from Enterprise Value to Equity Value Excel Model
Excel file to demonstrate the bridge from enterprise value to equity value.810Discussadd_shopping_cartfree
by Prof. Ed Bodmer
Discounted Cash Flow (DCF) Analysis with IRR and NPV
Several spreadsheets that can be used for the analysis of a real estate investment from various perspectives16,1222add_shopping_cartfree
by Norm Miller PhD
Bridge between Equity value and Enterprise value - Illustration Model
This Excel model illustrates bridge between equity value and enterprise value.430Discussadd_shopping_cartfree
by Prof. Ed Bodmer
Free Cash Flow Valuation Excel Template
A Free Cash Flow Valuation Template to create a 5-year business plan651Discussadd_shopping_cartScenario Graph Template
Visualize the different options a stock price can take according to a number of variables3,3282add_shopping_cartTerminal Value Calculation Excel Template
Compute the Terminal Value of a stock (Perpetuity and Exit Multiple Methods) with this excel spreadsheet3,890Discussadd_shopping_cartHow to do a Comparable Company Analysis
A guide on how to valuate a company by using the comparable company method.363Discussadd_shopping_cartfree
by Street Of Walls
TMX Group Limited DCF and Comparables Model
DCF and Comparables Valuation Model (Capital IQ Plug-in) for TMX Group Limited.1161add_shopping_cart$5.00
by Justin Ho
More Best Practices from Dheeraj Vaidya CFA FRM
Loan Amortization Schedule Calculator
Simple and effective tool for debt scheduling and loan amortization457Discussadd_shopping_cartBox IPO (Initial Public Offering)
Indepth analysis of BOX IPO with DCF and relative valuation626Discussadd_shopping_cartValuation Waterfall Graph
Show your audience how the share price of a target company can be broken up in its sub-components1,360Discussadd_shopping_cartBeta Calculation Worksheet
Compute the Beta needed for your CAPM as to calculate the expected return of a company's share1,074Discussadd_shopping_cartPrivate Equity Chart Template
Visualize the Valuation multiple of Stock or Index over a period of time.860Discussadd_shopping_cartScenario Graph Template
Visualize the different options a stock price can take according to a number of variables3,3282add_shopping_cartPrivate Equity Band Chart Template
Compute the Price to Earnings (or other PE ratios) Band Chart for your target stock or index875Discussadd_shopping_cartFootball Field Graph
Representing the spread of key PE ratios in floating columns/bars.419Discussadd_shopping_cartAlibaba IPO Financial Model
A full IPO financial model ready to be adapted and tweaked to any other company1,452Discussadd_shopping_cartColgate Financial Model (Unsolved & Solved Versions)
A full financial model ready to be adapted to any other company + a blank template1,596Discussadd_shopping_cartFree Cash Flow (FCFF) Template
Compute the FCFF for a firm through three different methods (EBIT, EBITDA and Net Income)659Discussadd_shopping_cartTerminal Value Calculation Excel Template
Compute the Terminal Value of a stock (Perpetuity and Exit Multiple Methods) with this excel spreadsheet3,890Discussadd_shopping_cart
Any questions on Comparable Company Analysis?
The user community and author are here to help. Go ahead!
