Methodology

This page is not investment advice. It does not say what a share is worth, and it does not tell you to buy or sell. It shows figures a company filed with the SEC, plus a few totals calculated from those figures.

Back to the explorer

Where the figures come from

The US Securities and Exchange Commission publishes each company's XBRL facts. A ticker is turned into a CIK with the SEC's company list, which the SEC does not guarantee is complete. The facts themselves come from companyfacts for that CIK. The browser does not call the SEC. A function on this site does, sends a descriptive user agent with a contact email, and keeps a copy so the same company is not fetched again for twelve hours. The ticker list is refreshed daily. If the SEC does not answer, the page shows the last saved copy and says so.

The header links to the company's list of filings on EDGAR. A figure you click names the tag, the period, the form, the accession number and the filing index.

Which tag is used

Companies do not all use the same tag for the same line. The page tries a short list, in order, and takes the first tag that has a value for that period. A missing line stays “not reported”. It is not shown as zero.

  • Revenue: RevenueFromContractWithCustomerExcludingAssessedTax, then Revenues, then SalesRevenueNet.
  • Gross profit: GrossProfit.
  • Operating income: OperatingIncomeLoss.
  • Net income: NetIncomeLoss, then NetIncomeLossAvailableToCommonStockholdersBasic.
  • Operating cash flow: NetCashProvidedByUsedInOperatingActivities.
  • Capital expenditure: PaymentsToAcquirePropertyPlantAndEquipment.

Only 10-K and 10-Q facts are used, including amendments. When the same period is filed more than once, the later filing is kept. Version 1 shows companies that report these lines in US dollars. A company that reports in another currency is named, and its figures are not converted.

Fourth quarter and free cash flow

A flow such as revenue is a duration. The third-quarter report usually gives the first nine months, not only the quarter. Where the company also files the quarter on its own, that quarter is shown. The fourth quarter is not in the third-quarter report. It is the full year minus the first nine months, and it is marked derived.

A balance is a point in time. The year-end balance is the one in the annual report. It is not derived.

Free cash flow is operating cash flow minus capital expenditure. If either input is missing, free cash flow is not reported. Margins divide a profit line by revenue. Growth compares a year with the previous year in the table. Trailing twelve months is the sum of the last four quarters. A missing quarter stops that sum.

Prices

The share price is the daily close from Alpha Vantage, end of day, as traded. The free tier returns the latest 100 sessions from TIME_SERIES_DAILY with outputsize=compact. The full history and the split-adjusted series are not on that free tier, so the chart is not adjusted for splits and the range stops at about 100 trading days. A saved series is kept for a day, and the page stops asking for new prices before the free allowance of 25 calls a day is used up. If the key is not set, the allowance is used up, or Alpha Vantage answers with a limit note, the chart and the price ratios stay off and the filings remain.

P/E is the latest close divided by diluted earnings per share over the last four quarters. Price to sales and free cash flow yield use that close times the shares outstanding in the filing. The share count is CommonStockSharesOutstanding, or the diluted average when the outstanding count is missing. The price date is shown next to each ratio. None of this is a view on whether the shares are cheap.

What the checks cover

The reader is checked against Apple, Caterpillar and Walmart. Apple's year does not end in December. Caterpillar files revenue and recent net income under tags that are not the first choice. Walmart's year ends in January, and it does not file gross profit under the tag this page looks for.