Comparable Analysis Valutation Model R

A comparable companies analysis is assembled here from enterprise value, market capitalization, trailing and quarterly revenue, EBIT margin and last quarter EBITDA margin, grouped with each company's sector.

Margins carried alongside the multiples are what stop a comps table from misleading: a business trading at a lower EV to sales figure than its peers often earns less on every dollar of that revenue. Enter the target and its peer set as tickers and MarketXLS formulas populate each column, so the implied valuation range can be read off the peer median.