Three-statement Excel model · 23 quarters and 5 fiscal years of history · 9 quarters and 5 fiscal years of projections
About the RTX model
This three-statement Excel model covers RTX Corporation (RTX): its income statement, balance sheet and cash flow statement. It holds 23 quarters and 5 fiscal years of history and 9 quarters and 5 fiscal years of projections.
Projected revenue is built from KPI drivers: Prior-year external product and service sales × segment-specific growth rates, across 3 segments.
Beyond the income statement, the workbook has these sections: Non-GAAP Reconciliation, KPI Drivers, Balance Sheet and Cash Flow Statement.
Model thesis: Raytheon backlog conversion and Pratt aftermarket growth drive sales as Collins growth normalizes.
On November 14, 2026, the model passed checks C13 (every subtotal reconciles to the reported figure at $0), C14 (every projected revenue cell traces to a KPI driver row) and C15 (each driver ends in a rate, a count or a historical anchor, never a typed-in projected dollar level). It was last updated November 14, 2026.
Income statement preview
Columns 2023–2025 are actual results and 2026E–2028E are our estimates. Figures were recalculated in Excel on November 14, 2026. USD millions except per share amounts and share counts.
| Income Statement | ||||||
|---|---|---|---|---|---|---|
| Actual | Estimate | |||||
| 2023 | 2024 | 2025 | 2026E | 2027E | 2028E | |
| Products sales | $49,571.0 | $59,612.0 | $64,171.0 | $70,604.0 | $76,647.7 | $82,479.5 |
| Services sales | 19,349.0 | 21,126.0 | 24,432.0 | 26,704.2 | 29,188.3 | 31,740.8 |
| Total net sales | $68,920.0 | $80,738.0 | $88,603.0 | $97,308.2 | $105,836.0 | $114,220.2 |
| Cost of sales - products | ($43,425.0) | ($50,768.0) | ($53,780.0) | ($57,633.6) | ($62,985.7) | ($67,530.5) |
| Cost of sales - services | (13,406.0) | (14,560.0) | (17,034.0) | (18,797.3) | (20,590.0) | (22,311.2) |
| Research and development | (2,805.0) | (2,934.0) | (2,807.0) | (2,881.9) | (3,083.2) | (3,350.3) |
| Selling, general, and administrative | (5,809.0) | (5,806.0) | (6,095.0) | (6,879.5) | (7,004.4) | (7,467.9) |
| Total costs and expenses | ($65,445.0) | ($74,068.0) | ($79,716.0) | ($86,192.3) | ($93,663.2) | ($100,659.9) |
| Goodwill impairment | 0.0 | 0.0 | 0.0 | |||
| Other income (expense), net | 86.0 | (132.0) | 413.0 | 325.3 | 286.2 | 308.9 |
| Operating profit | $3,561.0 | $6,538.0 | $9,300.0 | $11,441.3 | $12,459.0 | $13,869.2 |
| Non-service pension income | $1,780.0 | $1,518.0 | $1,182.0 | $1,324.0 | $1,370.8 | $1,365.2 |
| Debt extinguishment costs | 0.0 | 0.0 | 0.0 | 0.0 | ||
| Interest expense, net | (1,505.0) | (1,862.0) | (1,749.0) | (1,589.1) | (1,546.3) | (1,508.5) |
| Total non-operating expense (income), net | $275.0 | ($344.0) | ($567.0) | ($265.0) | ($175.6) | ($143.3) |
| Income before income taxes | $3,836.0 | $6,194.0 | $8,733.0 | $11,176.3 | $12,283.4 | $13,725.9 |
| Income tax expense | (456.0) | (1,181.0) | (1,664.0) | (1,984.7) | (2,272.4) | (2,539.3) |
| Net income | $3,380.0 | $5,013.0 | $7,069.0 | $9,191.5 | $10,011.0 | $11,186.6 |
| Less: Noncontrolling interest in subsidiaries’ earnings | (185.0) | (239.0) | (337.0) | (453.9) | (500.6) | (540.2) |
| Net income from continuing operations attributable to common shareowners | $3,195.0 | $4,774.0 | $6,732.0 | $8,737.7 | $9,510.4 | $10,646.4 |
| Income (loss) from discontinued operations, before tax | 0.0 | 0.0 | 0.0 | |||
| Income tax expense (benefit) from discontinued operations | 0.0 | 0.0 | 0.0 | |||
| Net income (loss) from discontinued operations | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 |
| Less: Noncontrolling interest in discontinued operations | 0.0 | 0.0 | 0.0 | |||
| Discontinued operations attributable to common shareowners (net presentation) | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| Discontinued operations attributable to common shareowners | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 |
| Net income attributable to common shareowners | $3,195.0 | $4,774.0 | $6,732.0 | $8,737.7 | $9,510.4 | $10,646.4 |
| Basic EPS from continuing operations | $2.24 | $3.58 | $5.02 | $6.47 | $7.01 | $7.81 |
| Basic EPS from discontinued operations | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Basic earnings per share | $2.24 | $3.58 | $5.02 | $6.47 | $7.01 | $7.81 |
| Diluted EPS from continuing operations | $2.23 | $3.55 | $4.96 | $6.40 | $6.93 | $7.72 |
| Diluted EPS from discontinued operations | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Diluted earnings per share | $2.23 | $3.55 | $4.96 | $6.40 | $6.93 | $7.72 |
| Ratios & Assumptions | ||||||
| Revenue growth (YoY) | 2.8% | 17.1% | 9.7% | 9.8% | 8.8% | 7.9% |
| Products gross margin | 12.4% | 14.8% | 16.2% | 18.4% | 17.8% | 18.1% |
| Services gross margin | 30.7% | 31.1% | 30.3% | 29.6% | 29.5% | 29.7% |
| Gross margin | 17.5% | 19.1% | 20.1% | 21.5% | 21.0% | 21.3% |
| Incremental gross margin (YoY) | (85.5%) | 28.1% | 30.2% | 35.5% | 16.2% | 25.3% |
The full workbook adds 23 historical and 9 projected quarters, plus Non-GAAP Reconciliation · KPI Drivers · Balance Sheet · Cash Flow Statement — every subtotal a live formula, every projection traced to a driver.
RTX research
Aardvark Labs Capital Research has published 5 reports on RTX (RTX). The latest is the Q3 2026 Earnings Recap, published October 25, 2026, rated Outperform.
A $51 Billion Backlog Jump Meets a Defense De-Rating: Maintaining Outperform on RTX as Valuation Stops Being the Constraint
Methodology
Every projected revenue cell traces to a KPI/driver row (C14). Terminal driver cells are rates, counts, or historical anchors — never typed-in projected dollar levels (C15). Every subtotal-vs-reported reconciliation row ties to $0 (C13). Each model is written per-ticker against its actual schema — no cloning, no level-input shortcuts.