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.
| quarter_end | quarter_label | total_debt_bn | cash_bn | net_debt_bn |
|---|---|---|---|---|
| 2024-03-31 | 31.03.2024 | 59.5 | 24 | 35.5 |
| 2024-06-30 | 30.06.2024 | 56.5 | 18.8 | 37.8 |
| 2024-09-30 | 30.09.2024 | 56.6 | 19 | 37.6 |
| 2024-12-31 | 31.12.2024 | 55 | 20.8 | 34.1 |
| 2025-03-31 | 31.03.2025 | 63.3 | 17.5 | 45.8 |
| 2025-06-30 | 30.06.2025 | 64.2 | 15.4 | 48.7 |
| 2025-09-30 | 30.09.2025 | 63.1 | 20 | 43.1 |
| 2025-12-31 | 31.12.2025 | 61.3 | 21.8 | 39.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
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
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
Work with this data in your AI assistant
Opens ready to query, with this page's data. Free, no account.