Skip to content
value.today

Formula screener

Write the conditions a company must meet, with the names of figures from its filings. The address keeps your formula, columns and sort: bookmark it or send it.

The figures you can use

Names are not case-sensitive; each also answers to the other names shown. Click a name for its definition.

Size

Market capUS$ millions
Market value of all the company's shares, on the date shown with it. Also: market capitalisation, market capitalization, mcap, market value.
Market cap agedays
Days since the date of the market cap: outside the US, India, Taiwan and Russia many are months old. Also: market cap days old, days since market cap.
RevenueUS$ millions
Revenue of the latest fiscal year. Also: sales, turnover.
Revenue TTMUS$ millions
Revenue over the last twelve months (four quarters), where quarters are on file. Also: revenue last 12 months, sales ttm, trailing revenue.
Net incomeUS$ millions
Net income of the latest fiscal year. Also: profit, net profit, earnings.
Net income TTMUS$ millions
Net income over the last twelve months, where quarters are on file. Also: profit ttm, earnings ttm, trailing net income.
Operating incomeUS$ millions
Operating income of the latest fiscal year. Also: operating profit, ebit.
Total assetsUS$ millions
Total assets at the latest balance-sheet date. Also: assets.
Total liabilitiesUS$ millions
Total liabilities at the latest balance-sheet date. Also: liabilities.
EquityUS$ millions
Shareholders' equity (book value) at the latest balance-sheet date. Also: shareholders equity, shareholders' equity, book value, total equity.
Employeescount
People employed, as last reported. Also: staff, headcount, workforce.
Revenue per employeeUS$
Revenue divided by employees, in US dollars. Also: sales per employee.
Profit per employeeUS$
Net income divided by employees, in US dollars. Also: net income per employee.
World rankcount
Place among all companies by market cap (1 is the largest). Also: rank.

Valuation

P/Emultiple · has medians
Market value divided by net income over the last twelve months; profitable companies only. Also: pe, p/e ratio, pe ratio, price to earnings.
Price to salesmultiple · has medians
Market value divided by revenue over the last twelve months. Also: p/s, ps, price/sales, ps ratio.
Price to bookmultiple · has medians
Market value divided by shareholders' equity. Also: p/b, pb, price/book, pb ratio.
Free cash flow yield% · has medians
Free cash flow as a share of the market value. Also: fcf yield.

Profitability

Gross margin% · has medians
Gross profit as a share of revenue. Also: gpm.
Operating margin% · has medians
Operating income as a share of revenue. Also: opm, ebit margin, operating profit margin.
Net margin% · has medians
Net income as a share of revenue. Also: npm, net profit margin, profit margin.
Return on equity% · has medians
Net income as a share of shareholders' equity (the average of the start and the end of the year). Not given when equity is negative. Also: roe.
Return on assets% · has medians
Net income as a share of total assets (average of the year). Also: roa.
Return on invested capital% · has medians
Operating income after tax, as a share of debt plus equity less cash (average of the year). The tax rate is the year's own: income tax over pre-tax income. Also: roic, return on capital.
Asset turnovermultiple · has medians
Revenue divided by total assets (average of the year).

Growth

Revenue growth% · has medians
Revenue against the year before. Also: sales growth, revenue growth 1 year, sales growth 1 year.
Revenue growth 3 years% · has medians
The yearly rate that takes revenue of three years earlier to this year's. Also: revenue growth 3 years, sales growth 3 years, revenue cagr 3 years, revenue growth 3y.
Revenue growth 5 years% · has medians
The yearly rate that takes revenue of five years earlier to this year's. Also: revenue growth 5 years, sales growth 5 years, revenue cagr 5 years, revenue growth 5y.
Net income growth% · has medians
Net income against the year before. Only when both years were profitable. Also: profit growth, net profit growth, earnings growth.
EPS growth% · has medians
Diluted earnings per share against the year before. Only when both were positive. Also: eps growth.

Financial health

Debt to equitymultiple · has medians
Total debt divided by shareholders' equity. Not given when equity is negative. Also: d/e, debt/equity, de ratio, debt equity.
Net debtUS$ millions · has medians
Total debt less cash. Negative means more cash than debt.
Net debt to EBITDAmultiple · has medians
Debt less cash, divided by operating income plus depreciation and amortization: roughly the years of operating earnings needed to repay it. Also: net debt/ebitda, leverage.
Interest covermultiple · has medians
Operating income divided by the interest paid on debt. Also: interest coverage, times interest earned.
Current ratiomultiple · has medians
Assets due within a year divided by liabilities due within a year.
Equity ratio% · has medians
Shareholders' equity as a share of total assets. Also: equity share of assets.

Cash flow

Free cash flowUS$ millions · has medians
Cash from operations less capital spending. Also: fcf, free cashflow.
Free cash flow margin% · has medians
Free cash flow as a share of revenue. Also: fcf margin.
Cash conversion% · has medians
Cash from operations as a share of net income. Only when the year was profitable.
Capital spending to revenue% · has medians
Capital spending as a share of revenue. Also: capex to revenue, capex/revenue.

Shareholder returns

Dividend yield% · has medians
Dividends paid in the fiscal year as a share of today's market value. Also: yield, div yield.
Buyback yield% · has medians
Shares bought back in the fiscal year as a share of today's market value.
Shareholder yield% · has medians
Dividends plus buybacks as a share of today's market value.
Dividend payout% · has medians
Dividends paid as a share of net income. Only when the year was profitable. Also: payout ratio, dividend payout ratio.
Share count change% · has medians
Diluted shares against the year before. Negative: fewer shares. Also: change in share count, dilution, share count change.

Scores

Fiscal yearyear
The fiscal year the ratios and scores describe. Also: ratios year, year of figures.
Piotroski F-scorepoints
Nine pass-or-fail tests of profitability, cash, debt, liquidity and efficiency (0 to 9); blank unless all nine could be worked out. Also: f-score, f score, piotroski, piotroski score.
Altman Z-scoremultiple
Bankruptcy-risk score of working capital, retained earnings, operating income, market value and sales against assets; below 1.81 is the distress zone. Also: z-score, z score, altman, altman z.
Scorecardpoints
Checks passed of the company scorecard's thirty (valuation, growth, profitability, financial health, shareholder returns), of those that could be worked out. Also: scorecard passes, checks passed.
Scorecard checks knowncount
How many of the thirty scorecard checks could be worked out. Also: checks known.
Valuation scorepoints
Scorecard valuation checks passed (of six). Also: valuation checks.
Growth scorepoints
Scorecard growth checks passed (of six). Also: growth checks.
Profitability scorepoints
Scorecard profitability checks passed (of six). Also: profitability checks.
Financial health scorepoints
Scorecard financial-health checks passed (of six). Also: health score, financial health checks.
Shareholder returns scorepoints
Scorecard shareholder-return checks passed (of six). Also: returns score, shareholder returns checks.

Ownership and trading

Short interest%
Shares sold short as a share of shares outstanding, on FINRA's latest settlement date. Also: short interest %, shares short, short percent.
Institutional ownership%
Shares held by the institutions that report to the SEC on Form 13F, as a share of shares outstanding, at the latest quarter end. Also: institutional holding, held by institutions, institutions %.
Institutional holderscount
Institutions reporting a position on Form 13F at the latest quarter end. Also: number of institutions.
Dividend growth yearscount
Calendar years in a row the dividend per share rose (SEC filers). Also: dividend streak, years of dividend growth, dividend raises in a row.
Insider buyingyes or no
Three or more insiders bought within 30 days, 100,000 dollars or more together, in the last 90 days (SEC Form 4). Also: insider cluster buying, cluster buying, insiders buying.

Company

Countryname
Headquarters country. Also: headquarters country, hq country.
Sectorname
The company's sector.
Industryname
The company's industry.
Regionname
UN world region of the headquarters (Africa, Americas, Asia, Europe, Oceania). Also: world region.
Sub-regionname
UN world sub-region of the headquarters, e.g. Western Europe. Also: subregion, world subregion.
Continentname
Continent of the headquarters.
Indexname
Member of an index list: S&P 500, Nasdaq-100, Dow Jones, Nifty 50 and the others. Also: index member, member of.
Foundedyear
Year the company was founded. Also: founded year, year founded.
IPO yearyear
Year of the first listing. Also: listed since, year listed.

How formulas are read

Compare a figure with a number or with another figure: P/E < 15, Free cash flow / Market cap > 0.05.

Join conditions with AND and OR; AND binds first, and brackets group: ROE > 20 OR (ROIC > 15 AND Net margin > 10).

Compare with the company's peers: P/E < Industry median P/E. Sector and Country medians work the same way.

Names: Country = India, Sector IN (Technology, Healthcare), Index = "S&P 500". Yes-or-no figures stand alone: Insider buying.

Amounts are US dollars: write 2B, 500M or 1.5T. Percentages are plain numbers: 15 is 15%.

A company that lacks a figure your formula needs is left out rather than counted as zero. Ratios come from the newest fiscal year on file; most are worked out for companies whose statements the SEC or the EU's ESEF reports hold.

The screener in the methodology · Ready-made screens