← All financial models

RTX (RTX) Financial Model

📊 Download Model

Three-statement Excel model · 23 quarters and 5 fiscal years of history · 9 quarters and 5 fiscal years of projections

current ✓ C13 recon ✓ C14 trace ✓ C15 terminals

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.

History
23 quarters and 5 fiscal years
Projections
9 quarters and 5 fiscal years
KPI
Prior-year external product and service sales × segment-specific growth rates
Segments
3
Units
USD millions except per share amounts and share counts
Verified
Updated
File
Excel workbook (.xlsx), 235 KB
Access
Free account required: 3 different models a month at no charge, then $9 a month.

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 preview for RTX. USD millions except per share amounts and share counts. Actual fiscal years followed by our estimates.
Income Statement
ActualEstimate
2023202420252026E2027E2028E
Products sales$49,571.0$59,612.0$64,171.0$70,604.0$76,647.7$82,479.5
Services sales19,349.021,126.024,432.026,704.229,188.331,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 impairment0.00.00.0
Other income (expense), net86.0(132.0)413.0325.3286.2308.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 costs0.00.00.00.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 tax0.00.00.0
Income tax expense (benefit) from discontinued operations0.00.00.0
Net income (loss) from discontinued operations$0.0$0.0$0.0$0.0$0.0$0.0
Less: Noncontrolling interest in discontinued operations0.00.00.0
Discontinued operations attributable to common shareowners (net presentation)0.00.00.00.00.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 margin12.4%14.8%16.2%18.4%17.8%18.1%
Services gross margin30.7%31.1%30.3%29.6%29.5%29.7%
Gross margin17.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.

Download the full RTX model (xlsx)3 free models a month with an account, then $9 a month

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

All RTX research →

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.