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
Evaluating Financial Performance and Forecasting
Set of worksheets related to financial analysis and forecasting596Discussadd_shopping_cartfreeby Matt Evans
Dealing with Employee Options
Learn how to value employee options and inserting this share in the value of your equity per share.659Discussadd_shopping_cartfreeby Aswath Damodaran
Scenario Graph Template
Visualize the different options a stock price can take according to a number of variables2,8772add_shopping_cartFree Cash Flow Valuation Excel Template
A Free Cash Flow Valuation Template to create a 5-year business plan253Discussadd_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,1242add_shopping_cart$20.00by Norm Miller PhD
Bridge between Equity value and Enterprise value - Illustration Model
This Excel model illustrates bridge between equity value and enterprise value.302Discussadd_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.328Discussadd_shopping_cartfreeTerminal Value Calculation Excel Template
Compute the Terminal Value of a stock (Perpetuity and Exit Multiple Methods) with this excel spreadsheet3,420Discussadd_shopping_cartHow to do a Comparable Company Analysis
A guide on how to valuate a company by using the comparable company method.233Discussadd_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 more945Discussadd_shopping_cart$100.00by CFI
More Best Practices from Dheeraj Vaidya CFA FRM
Alibaba IPO Financial Model
A full IPO financial model ready to be adapted and tweaked to any other company1,019Discussadd_shopping_cartLoan Amortization Schedule Calculator
Simple and effective tool for debt scheduling and loan amortization285Discussadd_shopping_cartBox IPO (Initial Public Offering)
Indepth analysis of BOX IPO with DCF and relative valuation423Discussadd_shopping_cartValuation Waterfall Graph
Show your audience how the share price of a target company can be broken up in its sub-components972Discussadd_shopping_cartBeta Calculation Worksheet
Compute the Beta needed for your CAPM as to calculate the expected return of a company's share779Discussadd_shopping_cartPrivate Equity Chart Template
Visualize the Valuation multiple of Stock or Index over a period of time.648Discussadd_shopping_cartScenario Graph Template
Visualize the different options a stock price can take according to a number of variables2,8772add_shopping_cartPrivate Equity Band Chart Template
Compute the Price to Earnings (or other PE ratios) Band Chart for your target stock or index629Discussadd_shopping_cartFootball Field Graph
Representing the spread of key PE ratios in floating columns/bars.354Discussadd_shopping_cartColgate Financial Model (Unsolved & Solved Versions)
A full financial model ready to be adapted to any other company + a blank template1,205Discussadd_shopping_cartFree Cash Flow (FCFF) Template
Compute the FCFF for a firm through three different methods (EBIT, EBITDA and Net Income)522Discussadd_shopping_cartTerminal Value Calculation Excel Template
Compute the Terminal Value of a stock (Perpetuity and Exit Multiple Methods) with this excel spreadsheet3,420Discussadd_shopping_cart
Any questions on Comparable Company Analysis?
The user community and author are here to help. Go ahead!
