Re-runs extraction for each period with period-end year from max(2023, current year − 2) through the current year, oldest first (up to three reporting years). This can take a long time.
Aerospace and defense—engines, avionics, missiles, and cybersecurity (Collins, Pratt & Whitney).
Sector: Industrials
US_RTX
Net debt (table and EV/EBITDA): |short-term borrowings| + |long-term borrowings| + |other financial liabilities| when extracted + |non-controlling interest| when extracted − |cash and equivalents|; amounts in millions of the reporting currency.
Shares: yahoo_fundamentals_timeseries/RTX
| Period | Issues |
|---|---|
| 2023-03-31 Q1 | ✗Errors 1Warn 1 |
| 2023-06-30 Q2 | ⚠Warn 1 |
| 2023-09-30 Q3 | ✗Errors 2Warn 2 |
| 2023-12-31 FY | ⚠Warn 1 |
| 2024-03-31 Q1 | ✗Errors 3Warn 1 |
| 2024-06-30 Q2 | ⚠Warn 2 |
| 2024-09-30 Q3 | ⚠Warn 1 |
| 2024-12-31 FY | ⚠Warn 1 |
| 2025-03-31 Q1 | ✗Errors 1Warn 1 |
| 2025-06-30 Q2 | ⚠Warn 1 |
| 2025-09-30 Q3 | ✗Errors 1Warn 1 |
| 2025-12-31 FY | ✗Errors 1Warn 1 |
| 2026-03-31 Q1 | ✗Errors 1Warn 1 |
Monetary columns are in B USD, one decimal; scale (K/M/B/T) keeps values readable. For the period (default) shows P&L and cash flow for that row’s reporting window: quarterly amounts when the feed uses quarter-duration facts (typical US 10-Q revenue and income), quarterly cash flows after stripping YTD where only cumulative tags exist, and an implied Q4 on 31 Dec FY rows (P&L: FY minus Q1–Q3; operating / investing cash flow: FY 12m minus 9M YTD to 30 Sep when sourced from SEC builder evidence) so they match 10-Q scale. Some issuers still use cumulative YTD minus the prior row in the same calendar year. As reported shows values stored on each row (e.g. full-year on FY). Balance sheet is always as reported. Source JSON may use millions etc.; conversion uses amounts_unit per row.
| Date | Period | Status | RevenueB USD | Operating profitB USD | D&AB USD | EBITDAB USD | Net profitB USD | Operating CFB USD | Capex + M&AB USD | AssetsB USD | EquityB USD | ROE (annualized) | Net debtB USD | Source |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-03-31 | Q1 2026 (3M) | OK | 22.1 y/y 8.7% | 2.6 y/y 25.6% | 1.1 y/y 1.8% | 3.6 y/y 17.5% | 2.1 y/y 34.1% | 1.9 | -0.5 | 170.4 y/y 3.4% | 66.3 y/y 7.7% | 12.5% | 25.7 | Link |
| 2025-12-31 | Q4 2025 (3M) | OK | 24.2 y/y 12.1% | 2.6 y/y 23.0% | 1.2 y/y 1.8% | 3.8 y/y 15.5% | 1.6 y/y 9.4% | 4.2 | -1.0 | 171.1 y/y 5.0% | 65.2 y/y 8.5% | 10.4% | 26.8 | Link |
| 2025-09-30 | Q3 2025 (3M) | OK | 22.5 y/y 11.9% | 2.5 y/y 24.4% | 1.1 y/y -0.3% | 3.6 y/y 15.8% | 1.9 y/y 30.3% | 4.6 | -0.6 | 168.7 y/y 2.3% | 64.5 y/y 5.6% | 4.0% | 31.8 | Link |
| 2025-06-30 | Q2 2025 (3M) | OK | 21.6 y/y 9.4% | 2.1 y/y 305.7% | 1.1 y/y 0.4% | 3.2 y/y 101.2% | 1.7 y/y 1392.8% | 0.5 | -0.5 | 167.1 y/y 3.7% | 62.4 y/y 5.8% | 10.7% | 34.4 | Link |
| 2025-03-31 | Q1 2025 (3M) | OK | 20.3 y/y 5.2% | 2.0 y/y 8.8% | 1.1 y/y -0.7% | 3.1 y/y 5.4% | 1.5 y/y -10.2% | 1.3 | -0.5 | 164.9 y/y 2.9% | 61.5 y/y 1.7% | 10.1% | 32.6 | Link |
| 2024-12-31 | Q4 2024 (3M) | OK | 21.6 y/y 8.5% | 2.1 y/y 18.8% | 1.1 y/y -57.0% | 3.2 y/y -26.5% | 1.5 y/y 3.9% | 1.6 | -1.1 | 162.9 y/y 0.6% | 60.2 y/y 0.6% | 7.9% | 32.9 | Link |
| 2024-09-30 | Q3 2024 (3M) | OK | 20.1 y/y 49.2% | 2.0 y/y — | 1.1 y/y 100.7% | 3.1 y/y — | 1.5 y/y — | 2.5 | -0.6 | 164.8 y/y 1.5% | 61.1 y/y -12.2% | 3.3% | 31.6 | Link |
| 2024-06-30 | Q2 2024 (3M) | OK | 19.7 y/y 7.7% | 0.5 y/y -64.6% | 1.1 y/y 110.2% | 1.6 y/y -20.1% | 0.1 y/y -91.6% | 2.7 | -0.5 | 161.2 y/y -0.6% | 59.0 y/y -18.6% | 0.7% | 33.8 | Link |
| 2024-03-31 | Q1 2024 (3M) | OK | 19.3 y/y 12.1% | 1.9 y/y 10.8% | 1.1 y/y 108.1% | 2.9 y/y 33.4% | 1.7 y/y 19.8% | 0.3 | -0.5 | 160.2 y/y -0.9% | 60.5 y/y -16.9% | 11.4% | 36.2 | Link |
| 2023-12-31 | Q4 2023 (3M) | OK | 19.9 y/y — | 1.8 y/y — | 2.6 y/y — | 4.4 y/y — | 1.4 y/y — | 4.7 | -0.8 | 161.9 y/y — | 59.8 y/y — | 4.9% | 35.6 | Link |
| 2023-09-30 | Q3 2023 (3M) | OK | 13.5 y/y — | -1.4 y/y — | 0.5 y/y — | -0.9 y/y — | -1.0 y/y — | 3.3 | -0.6 | 162.4 y/y — | 69.6 y/y — | -1.8% | 27.7 | Link |
| 2023-06-30 | Q2 2023 (3M) | OK | 18.3 y/y — | 1.5 y/y — | 0.5 y/y — | 2.0 y/y — | 1.3 y/y — | 0.7 | -0.5 | 162.2 y/y — | 72.5 y/y — | 7.3% | 27.7 | Link |
| 2023-03-31 | Q1 2023 (3M) | OK | 17.2 y/y — | 1.7 y/y — | 0.5 y/y — | 2.2 y/y — | 1.4 y/y — | -0.9 | -0.5 | 161.6 y/y — | 72.8 y/y — | — | 26.3 | Link |
Quarterly values ($ mln)
Year-over-year change
FCF ($ mln)
Net debt / cash ($ mln)
Current 20.1x · 3-year average 20.5x
Value the company creates per year, as a % of market cap
Value created per year: +16.6%
| 1. EBITDA growth (latest quarter YoY, annualised) [EBITDA latest qtr − EBITDA year-ago qtr] × annualisation X (2026-03-31 vs 2025-03-31) = (3 626 − 3 087) × 3.92 | 2 113 |
| 2. Current EV/EBITDA (LTM) (Market cap + Net debt) ÷ EBITDA (LTM) = (248 940 + 25 688) ÷ 14 217 | 19.3x |
| 3. Target multiple (Current EV/EBITDA + 12) ÷ 2 = (19.3 + 12) ÷ 2 | 15.7x |
| 4. Cash flow (balance method, LTM) Net-debt reduction + dividends + buybacks − equity issuance = 6 929 + 3 649 + 0 − 0 | 10 578 |
| 4b. Share dilution (at market, LTM) Share-count growth over the year × Market cap = 0.9% × 248 940 | −2 357 |
| 5. Value created per year (EBITDA growth × Target multiple + Cash flow − Dilution) ÷ Market cap = (2 113 × 15.7 + 10 578 − 2 357) ÷ 248 940 | +16.6% |
Amounts in millions of the reporting currency. EBITDA growth is the latest quarter vs the same quarter a year ago, annualised.
Caveats:
No dividend rows found for this issuer (checked: Yahoo Finance (ex-div)).
Reporting forms detected in loaded periods: ✓ ✓ ✓ (Balance sheet / Profit or loss (P&L) / Cash flows)