STRASMORE/EXPLORE 3,293 QUERIES

fcf_quarters

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-10-24, from ibm-dividend-2026-forecast.

as of table 8×6read in context →
fcf_quarters — 8 rows by 6 columns, computed from US exchange, SIP and OPRA data.
quarter_endquarter_labelocf_bncapex_bnfcf_bndividends_bn
2024-03-3131.03.20244.170.243.931.52
2024-06-3030.06.20242.060.221.841.54
2024-09-3030.09.20242.880.292.61.54
2024-12-3131.12.20244.330.34.031.55
2025-03-3131.03.20254.370.244.131.55
2025-06-3030.06.20251.70.211.491.56
2025-09-3030.09.20253.080.262.831.57
2025-12-3131.12.20254.040.383.661.57
Rows × columns
8 × 6
Period covered
to
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for fcf_quarters, derived from the stored result.
ColumnTypeRangeNotes
quarter_end date 2024-03-31 to 2025-12-31
quarter_label text 8 distinct values (30.06.2024, 30.06.2025, 30.09.2024…)
ocf_bn number 1.7 to 4.37
capex_bn number 0.21 to 0.38
fcf_bn number 1.49 to 4.13
dividends_bn number 1.52 to 1.57

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

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.

SELECT
    toString(period_end)                                                                                  AS quarter_end,
    formatDateTime(period_end, '%d.%m.%Y')                                                                AS quarter_label,
    round(ifNull(argMax(toFloat64(net_cash_from_operating_activities), filing_date), 0) / 1e9, 2)         AS ocf_bn,
    round(abs(ifNull(argMax(toFloat64(purchase_of_property_plant_and_equipment), filing_date), 0)) / 1e9, 2) AS capex_bn,
    round((ifNull(argMax(toFloat64(net_cash_from_operating_activities), filing_date), 0)
           - abs(ifNull(argMax(toFloat64(purchase_of_property_plant_and_equipment), filing_date), 0))) / 1e9, 2) AS fcf_bn,
    round(abs(ifNull(argMax(toFloat64(dividends), filing_date), 0)) / 1e9, 2)                             AS dividends_bn
FROM global_markets.stocks_cash_flow_statements
WHERE has(tickers, 'IBM')
  AND timeframe = 'quarterly'
  AND period_end >= '2024-01-01'
  AND period_end <= today()
GROUP BY period_end
ORDER BY period_end
⌘/Ctrl + Enter

Arbeiten Sie mit diesen Daten in Ihrem KI-Assistenten

Öffnet sich abfragebereit, mit den Daten dieser Seite. Kostenlos, ohne Konto.