STRASMORE/EXPLORE 3,293 QUERIES

net_debt

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×5read in context →
net_debt — 8 rows by 5 columns, computed from US exchange, SIP and OPRA data.
quarter_endquarter_labeltotal_debt_bncash_bnnet_debt_bn
2024-03-3131.03.202459.52435.5
2024-06-3030.06.202456.518.837.8
2024-09-3030.09.202456.61937.6
2024-12-3131.12.20245520.834.1
2025-03-3131.03.202563.317.545.8
2025-06-3030.06.202564.215.448.7
2025-09-3030.09.202563.12043.1
2025-12-3131.12.202561.321.839.5
Rows × columns
8 × 5
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 net_debt, 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…)
total_debt_bn number 55 to 64.2
cash_bn number 15.4 to 24
net_debt_bn number 34.1 to 48.7

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(debt_current), filing_date), 0)
           + ifNull(argMax(toFloat64(long_term_debt_and_capital_lease_obligations), filing_date), 0)) / 1e9, 1) AS total_debt_bn,
    round((ifNull(argMax(toFloat64(cash_and_equivalents), filing_date), 0)
           + ifNull(argMax(toFloat64(short_term_investments), filing_date), 0)) / 1e9, 1)                       AS cash_bn,
    round((ifNull(argMax(toFloat64(debt_current), filing_date), 0)
           + ifNull(argMax(toFloat64(long_term_debt_and_capital_lease_obligations), filing_date), 0)
           - ifNull(argMax(toFloat64(cash_and_equivalents), filing_date), 0)
           - ifNull(argMax(toFloat64(short_term_investments), filing_date), 0)) / 1e9, 1)                       AS net_debt_bn
FROM global_markets.stocks_balance_sheets
WHERE has(tickers, 'IBM')
  AND timeframe IN ('quarterly', 'annual')
  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.