Lynch Screen

Peter Lynch's habit of dividing the price to earnings ratio by the growth rate sits at the core of this screen, with the PEG ratio placed next to trailing P/E for each candidate. Debt to equity keeps overleveraged names out, and inventory as a percentage of revenue is tracked historically because inventory piling up ahead of sales was one of Lynch's warning signs.

Quarterly revenue and the sector label complete each row, and a MarketXLS database query supplies the universe. Every metric refreshes from current filings when the sheet recalculates.