Back to Community
How to retrieve for the entire universe past performance, shareholder friendliness and cheapness metrics?

I recently read Good Stocks Cheap (and took a course run by the author). I have summarised in a table attached to this post the past performance, shareholder friendliness and cheapness benchmarks he recommends. Does anyone know how to automatically extract companies meeting these benchmarks?

PAST PERFORMANCE

Should be at least 15%:

  1. ROCE with cash and cash equivalents, beginning of period.
  2. ROCE without cash and cash equivalents, beginning of period.
  3. ROCE with cash and cash equivalents, end of period.
  4. ROCE without cash and cash equivalents, end of period.

Should be at least 8%:

  1. FCFROCE beginning of period, with cash and cash equivalents.
  2. FCFROCE beginning of period, without cash and cash equivalents.
  3. FCFROCE end of period, with cash and cash equivalents.
  4. FCFROCE end of period, without cash and cash equivalents.

Should be at least 4%:

  1. Δ OI/FDS.
  2. Δ FCF/FDS.
  3. Δ BV/FDS.
  4. Δ TBV/FDS.

Not more than 200%, or 700% if otherwise great past performance:

Loan to equity ratio.

SHAREHOLDER FRIENDLINESS

  1. CEO salary: For US companies, should be less than $USD30,000,000.
  2. CEO salary compared to the lower of FCF or NI: Should be 5% of the lower of FCF or NI.
  3. Highest paid outside director: For US companies, preferably less than $USD250,000 and not more than $USD500,000.

CHEAPNESS

  1. MCAP/FCF: Should be no higher than 8.
  2. EV/OI with cash and cash equivalents: Should be no higher than 7, sell if >25.
  3. EV/OI without cash and cash equivalents: Should be no higher than 7, sell if >25.
  4. MCAP/BV: Should be no higher than 3.
  5. MCAP/TBV: Should be no higher than 3.

I have been applying this approach manually to assess companies for six months. In that time I have turned up only one buy: WW at $17.24. It immediately doubled in price from there. I lacked the courage to buy however due to a bad Q1 report.

Any help with a tool to automatically screen the entire universe of companies with these benchmarks would be appreciated. Past 10 years of past performance data is preferred, except for liabilities to equity ratio.