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 business tool for free!
download for free
Add to bookmarks
People using this tool also downloaded
Scenario Graph TemplateVisualize the different options a stock price can take according to a number of variables2,452
Terminal Value Calculation Excel TemplateCompute the Terminal Value of a stock (Perpetuity and Exit Multiple Methods) with this excel spreadsheet3,179
Alibaba IPO Financial ModelA full IPO financial model ready to be adapted and tweaked to any other company847
Colgate Financial Model (Unsolved & Solved Versions)A full financial model ready to be adapted to any other company + a blank template1,053
NPV Calculator (Excel Template)Calculate Net Present Value with ease by using this Excel spreadsheet.1,317
Valuation Waterfall GraphShow your audience how the share price of a target company can be broken up in its sub-components836
Beta Calculation WorksheetCompute the Beta needed for your CAPM as to calculate the expected return of a company's share601
Private Equity Chart TemplateVisualize the Valuation multiple of Stock or Index over a period of time.554
Free Cash Flow (FCFF) TemplateCompute the FCFF for a firm through three different methods (EBIT, EBITDA and Net Income)433
Box IPO (Initial Public Offering)Indepth analysis of BOX IPO with DCF and relative valuation341
Private Equity Band Chart TemplateCompute the Price to Earnings (or other PE ratios) Band Chart for your target stock or index574
Loan Amortization Schedule in ExcelA loan amortization schedule template along with step-by-step instructions.251
Any questions on Comparable Company Analysis?
The user community and author are here to help. Go ahead!