Listed US companies file their financial statements with the Securities and Exchange Commission (SEC) four times a year: three quarterly reports on Form 10-Q and one annual report on Form 10-K. Since 2011 the figures in them have been tagged in machine-readable form (XBRL). Revenue, profit, cash flow and balance sheet of hundreds of companies can therefore be read straight from the source, without a data vendor in between.
Most metrics are not in the report itself but are calculated from its figures. Some relate the market value to an item from the report, such as the P/E ratio. Others describe how much cash the business generates, how the company is financed or how much flows back to shareholders.
This guide explains the main groups, how the values are assembled from the reports and where they are easily misread. The individual terms are described in detail in the glossary. At the end you will find how the fundamentals screener in Foliograph assembles the figures from the SEC data.
From the reports to a metric
The basis is the income statement, the cash-flow statement and the balance sheet. Income statement and cash-flow statement show what happened during a period (such as a quarter's revenue). The balance sheet shows the position on one day (such as debt at quarter end). So that metrics do not depend on the season or on a company's fiscal year, items from a period are summed over the last four quarters (TTM). Balance sheet values such as equity or debt apply at the end of the last quarter instead.
Assembling them is not entirely simple. US reports usually do not show a separate fourth quarter, the annual report covers the whole year. For items that add up, it follows as the annual value minus the first nine months. The cash-flow statement in the quarterly report also usually shows only year-to-date months, that is three, six or nine. The cash flow of a single quarter only appears by subtracting the previous period.
Not every item can be split this way. The diluted share count is an average over the period. An annual average and a nine-month average do not give an average for the fourth quarter. When a company restates earlier quarters, for example after a spin-off, older and newer figures also do not fit together for a while. Sums over four quarters are only comparable again once all of them are on the same basis.
Valuation: market value in relation
Valuation metrics connect the report with the share price. The starting point is market capitalization, the price times the number of shares outstanding. Divided by net income it gives the P/E ratio, by revenue the P/S ratio, by equity the P/B ratio and by free cash flow price to free cash flow. A P/E of 20 means that the market value equals twenty times the profit of the last twelve months.
Market value only covers the equity. Two companies with the same market value can carry very different amounts of debt. Enterprise value therefore adds net debt, minority interests and preferred stock. EV/EBIT relates it to operating income, the result before interest and taxes. Numerator and denominator then both stand for the whole business, not only for the shareholders.
The metrics differ in which item is in the denominator and how much it fluctuates:
| Metric | Denominator | What affects the item |
|---|---|---|
| P/E | Net income | Interest, taxes, depreciation, one-off items |
| P/S | Revenue | Few one-off items, says nothing about the margin |
| P/B | Equity | Valued at historical cost, buybacks lower it |
| P/FCF | Free cash flow | Capital expenditure and working capital, stock-based compensation does not reduce it |
| EV/EBIT | Operating income | Independent of interest, taxes and financing |
When the denominator is zero or negative, a ratio gives no meaningful value. That is why there is no P/E with a loss. The inverse values can still be calculated: the FCF yield relates free cash flow to market value and can also be negative. An FCF yield of 5% equals a P/FCF of 20.
Valuation metrics differ widely between industries. A software maker with a high margin and few tangible assets typically has a different P/S and P/B than a power utility. Comparisons therefore work best among companies of the same industry. Even then a metric only describes the ratio of two figures at one point in time. Whether a value is high or low depends on growth, risk and interest rates, which none of these metrics contains.
Cash flow and accounting profit
Net income follows the rules of accounting. Revenue is recorded when the service is delivered, not when the cash arrives. Investments are depreciated over years. Operating cash flow instead shows how much cash actually came in from the ongoing business. Subtracting capital expenditure leaves free cash flow. It is available for dividends, buybacks, paying down debt or acquisitions.
Profit and cash flow can drift apart. When receivables and inventories grow faster than revenue, profit is above cash flow. The difference of net income and operating cash flow relative to total assets is called accruals. Richard Sloan found in 1996 that the part of profit from such accounting entries continued less in the following years than the part from cash flows. For a single company the figure describes the gap. It says nothing about the next quarters.
A special case is stock-based compensation. When a company pays employees with shares or options, profit falls but no cash leaves the company. The cash-flow statement therefore adds the amount back to operating cash flow. Shareholders bear the cost through additional shares. At companies paying a lot in shares, free cash flow after subtracting this compensation shows how much would be left without it.
Profitability, margins and debt
Margins describe how much of each dollar of revenue is left at the different stages of the income statement. Gross margin subtracts only the direct cost of the goods and services sold, operating margin also administration, sales and research, net margin in addition interest and taxes. Banks and insurers have no gross profit, the first stage is missing for them.
Returns relate a result to the capital employed. Return on equity divides net income by average equity. It also rises when equity shrinks, for example after large buybacks, and is not meaningful with negative equity. ROIC relates operating income after taxes to the capital of both shareholders and lenders. It therefore depends less directly on how the company is financed.
For debt, what matters is what is left after subtracting the available funds. Net debt subtracts cash and short-term investments from financial debt. Negative means more cash than debt. Relative to operating income before depreciation (EBITDA) it shows how many years of earnings the debt amounts to. Interest coverage divides operating income by interest expense. Which lease liabilities are included in debt differs between companies and data vendors. Foliograph never counts operating leases as financial debt.
What flows back to shareholders
Companies return cash to shareholders in two ways: as dividends and through the repurchase of own shares. The cash-flow statement shows the amount spent on buybacks. The payout ratio relates dividends to net income. Shareholder yield counts dividends and net buybacks, that is buybacks minus the proceeds from newly issued shares, and relates them to market value.
The buyback amount and the share count do not tell the same story. Many companies issue new shares to employees all the time. Part of the buybacks then only offsets this issuance and the share count falls less than the amount suggests. The diluted share count also includes the shares that can still arise from options and convertible bonds. It therefore also changes with the share price, without any shares being bought or issued.
A comparison over one year shows how the share count changed overall. If it falls while profit stays the same and positive, earnings per share rise even without growth in the business. Announced buyback programs are intentions instead. They appear only as text in the reports and only the cash-flow statement of the following quarters shows whether they are used.
Change over several quarters
A single point in time shows a state. Many questions concern the development, though: is revenue growing faster than a year ago? Has the margin risen over several quarters? Such comparisons use the same quarter one year earlier. Seasonal effects such as the holiday business in retail carry less weight than in a comparison with the quarter before.
Streaks can be built from this: how many quarters in a row a condition has held, for example a positive free cash flow or a higher gross margin than in the year-ago quarter. A streak describes the past. It does not say how long it will last.
The Piotroski F-score goes one step further. In 2000 Joseph Piotroski combined nine simple conditions on profit, debt and efficiency into one number: positive profit and cash flow, higher return on assets, cash flow above profit, lower leverage, higher liquidity, no new shares, higher gross margin and higher asset turnover. He used it to study companies with a low P/B ratio. The number describes how many of the conditions the reports meet and is not a rating of the stock.
Limits of the metrics
Every metric is only as good as the figures behind it. Companies do not always name the same item the same way and the same line can be defined differently at two companies. One-off items such as the gain from selling a business or a large write-down change profit and returns for four quarters. Adjusted figures from press releases follow the companies' own definitions and are not part of the financial statements.
Banks and insurers follow a logic of their own. Deposits, loans and insurance reserves are part of the business, so their cash flow and their debt cannot be read like those of an industrial company. Metrics such as free cash flow, net debt or EV/EBIT are not meaningful for them. For real estate investment trusts (REITs) profit says little because of depreciation on buildings, so they also report funds from operations (FFO).
All metrics here look back. Estimates for future quarters, such as a forward P/E, rest on forecasts by analysts or companies and are not part of the reports. The figures describe what a company has reported. What follows from them depends on your own approach, time horizon and risk capacity.
Frequently asked questions
Where do the figures in the fundamentals screener come from?
From the quarterly and annual reports the companies file with the SEC. Foliograph reads the machine-readable XBRL data of the SEC (companyfacts) and missing reports directly from the filing. For valuation metrics such as P/E the share price from the RSL ranking is added, for which TWS supplies the prices.
Why is the P/E empty for some companies?
A P/E exists only with a positive profit. With a loss or a profit of zero the cell stays empty, as it does without a price from the RSL ranking. The same applies to P/FCF with a free cash flow of zero or below. The FCF yield, by contrast, can be negative and is shown.
Why does a value differ from other finance portals?
Data vendors define items differently, for example leases in debt or adjusted earnings. They use other prices, dates or share counts and sometimes estimates. Foliograph only uses the reported figures of the last four quarters. The tooltip names the price, its date and the basis of the value.
Which companies does the screener cover?
The members of the S&P 500 or the Nasdaq-100, read from the latest NPORT-P filing of the SPY and QQQ ETFs. Companies without quarterly figures under US GAAP, mainly foreign issuers with IFRS statements or only an annual report on Form 20-F or 40-F, show "No data".
Does the screener need TWS?
Not for the figures from the reports, they come straight from the SEC. TWS supplies the prices for the RSL ranking, from which the valuation metrics take the newest price. Without loaded RSL prices, P/E, P/S, P/B, P/FCF, FCF yield and EV/EBIT stay empty.
Does Foliograph show analyst estimates?
No. The screener only shows figures from the reported filings and ratios built from them. The Outlook button shows the outlook a company gives itself in its earnings press release as a quote with a link to the document.
How current are the figures?
As current as the company's latest report. Depending on the filer category, quarterly reports are due 40 to 45 days after the quarter end, annual reports 60 to 90 days after the fiscal year end. Every six hours Foliograph checks which companies filed a new report. The Quarter column shows the end of the latest reported quarter, its tooltip the filing date.
Terms on this page
- Accruals (Accrual ratio)
- Diluted share count (Diluted shares, weighted average diluted shares)
- SEC EDGAR (Database of the US securities regulator)
- Enterprise value (EV)
- Earnings per share (EPS)
- EV/EBIT (Enterprise value to EBIT)
- FCF yield (Free cash flow yield)
- Form 10-K (Annual report, 10-K)
- Form 10-Q (Quarterly report, 10-Q)
- Form 4 (Insider filing, Statement of Changes in Beneficial Ownership)
- Form 8-K (Current report)
- Free cash flow (FCF)
- Gross margin (Gross profit margin)
- Interest coverage (Interest coverage ratio, times interest earned)
- Market capitalization (Market cap)
- Net debt (Net financial debt)
- Operating margin (EBIT margin)
- Payout ratio (Dividend payout ratio)
- P/B ratio (Price-book ratio, price to book)
- P/E ratio (Price-earnings ratio, PER)
- Piotroski F-score (F-score by Joseph Piotroski)
- P/FCF (Price to free cash flow)
- P/S ratio (Price-sales ratio, price to sales)
- Return on equity (ROE)
- ROIC (Return on invested capital)
- Share buyback (Share repurchase, stock buyback)
- Shareholder yield (Total payout yield)
- Stock-based compensation (SBC, share-based compensation)
- TTM (Trailing twelve months, LTM)
- XBRL (eXtensible Business Reporting Language)
Read next
- Trading journal software: local or cloud? What a journal has to deliver, how desktop apps differ from cloud services and how the import from Interactive Brokers works.
- ETF screener with options data Anyone trading options on ETFs should, among other things, watch the current volatility relative to its own history and the liquidity of the option chain. This guide explains these and other key figures.
- Market overview How much volatility is the market pricing in? Are the major stock indices above or below their moving average and where do US rates stand? A market overview brings these figures onto one page. This guide explains how to read them together.
- Futures dashboard: CoT, term structure and IV rank With futures there is more information about the market environment than the price: the positioning of large market participants, the prices of different expiry months and the implied volatility of the options. This guide explains how CoT data, term structure, open interest and volatility figures can be read together.
- Trading metrics: win rate, profit factor and drawdown A trading journal collects trades. Only the evaluation shows how gains and losses are distributed across many trades. This guide explains the key metrics, how they relate to each other and where they are easily misread.
- Option portfolio risk: premium, max loss and margin The running profit and loss of an option portfolio shows only part of the risk taken on. This guide explains which figures describe a portfolio of short options, how they relate and where their limits are.
- Reading SEC filings: 10-K, 10-Q, 8-K and Form 4 What a listed US company has to disclose ends up in the database of the Securities and Exchange Commission. This guide explains which filings exist, when they are due, what they contain and what they do not show.
- Enable the TWS API: allow software to read from the Trader Workstation
- Fundamentals screener Companies of the S&P 500 or the Nasdaq-100 with figures from their SEC filings, filterable by cash flow, earnings and share buybacks. Plus the outlook from the two most recent earnings releases, when they contain one.
- RSL ranking in Foliograph The S&P 500 and Nasdaq-100 stocks sorted by Levy's Relative Strength, with a freely selectable RSL period and individually defined highlights.
All market and analytical information is provided for educational and analytical purposes only and does not constitute investment advice or a trading recommendation.