ttm_coverage

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

WITH cf AS
(
    SELECT
        period_end,
        ifNull(argMax(toFloat64(net_cash_from_operating_activities), filing_date), 0)
          - abs(ifNull(argMax(toFloat64(purchase_of_property_plant_and_equipment), filing_date), 0)) AS fcf,
        abs(ifNull(argMax(toFloat64(dividends), filing_date), 0))                                     AS divs
    FROM global_markets.stocks_cash_flow_statements
    WHERE has(tickers, 'IBM')
      AND timeframe = 'quarterly'
      AND period_end >= '2023-01-01'
      AND period_end <= today()
    GROUP BY period_end
),
rolling AS
(
    SELECT
        period_end,
        sum(fcf)  OVER (ORDER BY period_end ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS fcf_ttm,
        sum(divs) OVER (ORDER BY period_end ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS divs_ttm,
        count()   OVER (ORDER BY period_end ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS quarters_in_window
    FROM cf
)
SELECT
    toString(period_end)                     AS quarter_end,
    formatDateTime(period_end, '%d.%m.%Y')   AS quarter_label,
    round(fcf_ttm / 1e9, 2)                  AS fcf_ttm_bn,
    round(divs_ttm / 1e9, 2)                 AS dividends_ttm_bn,
    round((fcf_ttm - divs_ttm) / 1e9, 2)     AS headroom_bn,
    round(divs_ttm / fcf_ttm * 100, 1)       AS payout_ttm_pct
FROM rolling
WHERE quarters_in_window = 4
  AND period_end >= '2024-01-01'
ORDER BY period_end