Comparable Company Analysis

Arrive at the right multiple (EV/Sales, P/E etc.) to prepare the comparable comps.

by Dheeraj Vaidya CFA FRM
Co-founder & CEO @ eduCBA & founder of WallStreetMojoFollow 171

19 reviews2,043 views|Start the discussion!|Bookmark download for free

Description
The key to preparing the comparable comps is the arrive at the right multiple (EV/Sales, P/E etc). This template provides you with the infrastructure to prepare the same.

Outputs:
- Stock Price
- 52 WK
- Equity Value
- Enterprise Value
- EV/Revenue (LTM, FY(year+1), FY (year+2))
- EV/ EBITDA (LTM, FY(year+1), FY (year+2))
- EV/ EBIT (LTM, FY(year+1), FY (year+2))

This Best Practice includes
1 Excel Model