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.7 / 5 (19 votes)- 68%
- 32%
- -
- -
- -
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,205Discussadd_shopping_cartfree
by Aswath Damodaran
Evaluating Financial Performance and Forecasting
Set of worksheets related to financial analysis and forecasting866Discussadd_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.876Discussadd_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,2672add_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.452Discussadd_shopping_cartfree
by Prof. Ed Bodmer
Free Cash Flow Valuation Excel Template
A Free Cash Flow Valuation Template to create a 5-year business plan720Discussadd_shopping_cartScenario Graph Template
Visualize the different options a stock price can take according to a number of variables3,4002add_shopping_cartTerminal Value Calculation Excel Template
Compute the Terminal Value of a stock (Perpetuity and Exit Multiple Methods) with this excel spreadsheet3,962Discussadd_shopping_cartHow to do a Comparable Company Analysis
A guide on how to valuate a company by using the comparable company method.386Discussadd_shopping_cartfree
by Street Of Walls
Finance Toolkit
Extensive business financing toolkit including 6 excel tools126Discussadd_shopping_cart$4.00
by David Connaughton
More Best Practices from Dheeraj Vaidya CFA FRM
Loan Amortization Schedule Calculator
Simple and effective tool for debt scheduling and loan amortization484Discussadd_shopping_cartBox IPO (Initial Public Offering)
Indepth analysis of BOX IPO with DCF and relative valuation730Discussadd_shopping_cartValuation Waterfall Graph
Show your audience how the share price of a target company can be broken up in its sub-components1,443Discussadd_shopping_cartBeta Calculation Worksheet
Compute the Beta needed for your CAPM as to calculate the expected return of a company's share1,134Discussadd_shopping_cartPrivate Equity Chart Template
Visualize the Valuation multiple of Stock or Index over a period of time.905Discussadd_shopping_cartScenario Graph Template
Visualize the different options a stock price can take according to a number of variables3,4002add_shopping_cartPrivate Equity Band Chart Template
Compute the Price to Earnings (or other PE ratios) Band Chart for your target stock or index907Discussadd_shopping_cartFootball Field Graph
Representing the spread of key PE ratios in floating columns/bars.428Discussadd_shopping_cartAlibaba IPO Financial Model
A full IPO financial model ready to be adapted and tweaked to any other company1,526Discussadd_shopping_cartColgate Financial Model (Unsolved & Solved Versions)
A full financial model ready to be adapted to any other company + a blank template1,661Discussadd_shopping_cartFree Cash Flow (FCFF) Template
Compute the FCFF for a firm through three different methods (EBIT, EBITDA and Net Income)702Discussadd_shopping_cartTerminal Value Calculation Excel Template
Compute the Terminal Value of a stock (Perpetuity and Exit Multiple Methods) with this excel spreadsheet3,962Discussadd_shopping_cart
Any questions on Comparable Company Analysis?
The user community and author are here to help. Go ahead!
