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 (12 votes)- 58%
- 42%
- -
- -
- -
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.692Discussadd_shopping_cartfreeby Aswath Damodaran
Evaluating Financial Performance and Forecasting
Set of worksheets related to financial analysis and forecasting620Discussadd_shopping_cartfreeby Matt Evans
Scenario Graph Template
Visualize the different options a stock price can take according to a number of variables2,9672add_shopping_cartDiscounted Cash Flow (DCF) Analysis with IRR and NPV
Several spreadsheets that can be used for the analysis of a real estate investment from various perspectives15,2742add_shopping_cart$20.00by Norm Miller PhD
Free Cash Flow Valuation Excel Template
A Free Cash Flow Valuation Template to create a 5-year business plan312Discussadd_shopping_cartBridge between Equity value and Enterprise value - Illustration Model
This Excel model illustrates bridge between equity value and enterprise value.311Discussadd_shopping_cartfreeby Prof. Ed Bodmer
Bridge from Enterprise Value to Equity Value Excel Model
Excel file to demonstrate the bridge from enterprise value to equity value.373Discussadd_shopping_cartfreeTerminal Value Calculation Excel Template
Compute the Terminal Value of a stock (Perpetuity and Exit Multiple Methods) with this excel spreadsheet3,473Discussadd_shopping_cartHow to do a Comparable Company Analysis
A guide on how to valuate a company by using the comparable company method.246Discussadd_shopping_cartfreeby Street Of Walls
Amazon Case Study - Advanced Business Valuation Excel Model
Value Amazon's target share price using DCF analysis, comps analysis, WACC, and more992Discussadd_shopping_cart$100.00by CFI
More Best Practices from Dheeraj Vaidya CFA FRM
Loan Amortization Schedule Calculator
Simple and effective tool for debt scheduling and loan amortization312Discussadd_shopping_cartBox IPO (Initial Public Offering)
Indepth analysis of BOX IPO with DCF and relative valuation445Discussadd_shopping_cartValuation Waterfall Graph
Show your audience how the share price of a target company can be broken up in its sub-components1,005Discussadd_shopping_cartBeta Calculation Worksheet
Compute the Beta needed for your CAPM as to calculate the expected return of a company's share822Discussadd_shopping_cartPrivate Equity Chart Template
Visualize the Valuation multiple of Stock or Index over a period of time.672Discussadd_shopping_cartScenario Graph Template
Visualize the different options a stock price can take according to a number of variables2,9672add_shopping_cartPrivate Equity Band Chart Template
Compute the Price to Earnings (or other PE ratios) Band Chart for your target stock or index665Discussadd_shopping_cartFootball Field Graph
Representing the spread of key PE ratios in floating columns/bars.356Discussadd_shopping_cartAlibaba IPO Financial Model
A full IPO financial model ready to be adapted and tweaked to any other company1,060Discussadd_shopping_cartColgate Financial Model (Unsolved & Solved Versions)
A full financial model ready to be adapted to any other company + a blank template1,246Discussadd_shopping_cartFree Cash Flow (FCFF) Template
Compute the FCFF for a firm through three different methods (EBIT, EBITDA and Net Income)539Discussadd_shopping_cartTerminal Value Calculation Excel Template
Compute the Terminal Value of a stock (Perpetuity and Exit Multiple Methods) with this excel spreadsheet3,473Discussadd_shopping_cart
Any questions on Comparable Company Analysis?
The user community and author are here to help. Go ahead!
