Comparable Sector Analysis

Pick a company and this sheet sets it beside its sector peers on the same measures: return on equity, trailing price to earnings, dividend yield, and price returns over seven days, one month and one year.

Comparison is what turns a raw multiple into information. A P/E of thirty is expensive in one sector and unremarkable in another, and the return columns show whether a valuation gap has just opened or has been there for a year. Replace the tickers in the peer column to build the comparison around a different name, and MarketXLS formulas refill every metric.