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 business tool for free!
download for free
Add to bookmarks
Reviews
People using this tool also downloaded
Evaluating Financial Performance and Forecasting
Set of worksheets related to financial analysis and forecasting456Discussfree
by Matt Evans
Dealing with Employee Options
Learn how to value employee options and inserting this share in the value of your equity per share.505DiscussScenario Graph Template
Visualize the different options a stock price can take according to a number of variables2,4522Free Cash Flow Valuation Excel Template
A Free Cash Flow Valuation Template to create a 5-year business plan76DiscussDiscounted Cash Flow (DCF) Analysis with IRR and NPV
Several spreadsheets that can be used for the analysis of a real estate investment from various perspectives14,1722$20.00
by Prof. Norm Miller PhD
Bridge between Equity value and Enterprise value - Illustration Model
This Excel model illustrates bridge between equity value and enterprise value.244Discussfree
by Prof. Ed Bodmer
Terminal Value Calculation Excel Template
Compute the Terminal Value of a stock (Perpetuity and Exit Multiple Methods) with this excel spreadsheet3,179DiscussBridge from Enterprise Value to Equity Value Excel Model
Excel file to demonstrate the bridge from enterprise value to equity value.198Discussfree
by Prof. Ed Bodmer
Amazon Case Study - Advanced Business Valuation Excel Model
Value Amazon's target share price using DCF analysis, comps analysis, WACC, and more734Discuss$100.00
by CFI
Finance Toolkit
Extensive business financing toolkit including 6 excel tools55Discuss$4.00
by David Connaughton
More tools from Dheeraj Vaidya CFA FRM
Scenario Graph Template
Visualize the different options a stock price can take according to a number of variables2,4522Terminal Value Calculation Excel Template
Compute the Terminal Value of a stock (Perpetuity and Exit Multiple Methods) with this excel spreadsheet3,179DiscussAlibaba IPO Financial Model
A full IPO financial model ready to be adapted and tweaked to any other company847DiscussColgate Financial Model (Unsolved & Solved Versions)
A full financial model ready to be adapted to any other company + a blank template1,053DiscussNPV Calculator (Excel Template)
Calculate Net Present Value with ease by using this Excel spreadsheet.1,317DiscussValuation Waterfall Graph
Show your audience how the share price of a target company can be broken up in its sub-components836DiscussBeta Calculation Worksheet
Compute the Beta needed for your CAPM as to calculate the expected return of a company's share601DiscussPrivate Equity Chart Template
Visualize the Valuation multiple of Stock or Index over a period of time.554DiscussFree Cash Flow (FCFF) Template
Compute the FCFF for a firm through three different methods (EBIT, EBITDA and Net Income)433DiscussBox IPO (Initial Public Offering)
Indepth analysis of BOX IPO with DCF and relative valuation341DiscussPrivate Equity Band Chart Template
Compute the Price to Earnings (or other PE ratios) Band Chart for your target stock or index574DiscussLoan Amortization Schedule in Excel
A loan amortization schedule template along with step-by-step instructions.251Discuss
Any questions on Comparable Company Analysis?
The user community and author are here to help. Go ahead!
