Relative Valuation (Ratios)

Enterprise value, market capitalization, trailing twelve month revenue, trailing EBITDA and the trailing price to earnings ratio populate for each company, which is everything needed to build EV to EBITDA, EV to sales and P/E side by side across a peer group.

Ratios computed from the same source on the same date are what makes a comparison mean anything, and that consistency is the reason for the layout. Add tickers to the input column and MarketXLS formulas fill the rest, so a comps table for a new sector takes minutes rather than an afternoon.