Intra Sector View on the basis of Market Cap

Within a single sector, this sheet sorts companies by market capitalization and shows what you pay and what you earn at each size: trailing price to earnings, dividend yield, return on equity and return on capital, with the last traded price beside each name.

The starting list comes from a MarketXLS database query, so a sector can be pulled in whole rather than typed by hand. Comparing the largest names with the small companies in the same business often explains why the sector average looks the way it does, and the layout is built for that comparison.