Stock Analysis on Net

RTX Corp. (NYSE:RTX)

Analysis of Reportable Segments

Microsoft Excel

Segment Profit Margin

RTX Corp., profit margin by reportable segment

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Collins Aerospace 14.57% 11.38% 9.53% 7.60% 15.75%
Pratt & Whitney -7.95% 5.24% 2.50% -3.36% 7.98%
Raytheon 9.03% 9.81% 12.49% 8.46%

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

Segment profitability ratio Reportable segment The company
Segment profit margin Collins Aerospace Collins Aerospace segment profit margin ratio improved from 2021 to 2022 and from 2022 to 2023.
Pratt & Whitney Pratt & Whitney segment profit margin ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.
Raytheon Raytheon segment profit margin ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment Profit Margin: Collins Aerospace

RTX Corp.; Collins Aerospace; segment profit margin calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Operating profit (loss) 3,825 2,343 1,759 1,466 4,100
Net sales 26,253 20,597 18,449 19,288 26,028
Segment Profitability Ratio
Segment profit margin1 14.57% 11.38% 9.53% 7.60% 15.75%

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Segment profit margin = 100 × Operating profit (loss) ÷ Net sales
= 100 × 3,825 ÷ 26,253 = 14.57%

Segment profitability ratio Reportable segment The company
Segment profit margin Collins Aerospace Collins Aerospace segment profit margin ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Profit Margin: Pratt & Whitney

RTX Corp.; Pratt & Whitney; segment profit margin calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Operating profit (loss) (1,455) 1,075 454 (564) 1,668
Net sales 18,296 20,530 18,150 16,799 20,892
Segment Profitability Ratio
Segment profit margin1 -7.95% 5.24% 2.50% -3.36% 7.98%

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Segment profit margin = 100 × Operating profit (loss) ÷ Net sales
= 100 × -1,455 ÷ 18,296 = -7.95%

Segment profitability ratio Reportable segment The company
Segment profit margin Pratt & Whitney Pratt & Whitney segment profit margin ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Segment Profit Margin: Raytheon

RTX Corp.; Raytheon; segment profit margin calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Operating profit (loss) 2,379 2,861 3,837 1,904
Net sales 26,350 29,175 30,719 22,501
Segment Profitability Ratio
Segment profit margin1 9.03% 9.81% 12.49% 8.46%

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Segment profit margin = 100 × Operating profit (loss) ÷ Net sales
= 100 × 2,379 ÷ 26,350 = 9.03%

Segment profitability ratio Reportable segment The company
Segment profit margin Raytheon Raytheon segment profit margin ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment Return on Assets (Segment ROA)

RTX Corp., ROA by reportable segment

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Collins Aerospace 5.31% 3.50% 2.60% 2.13% 5.54%
Pratt & Whitney -3.57% 2.97% 1.36% -1.72% 5.33%
Raytheon 5.30% 5.84% 7.63% 3.74%

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

Segment profitability ratio Reportable segment The company
Segment ROA Collins Aerospace Collins Aerospace segment ROA improved from 2021 to 2022 and from 2022 to 2023.
Pratt & Whitney Pratt & Whitney segment ROA improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.
Raytheon Raytheon segment ROA deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment ROA: Collins Aerospace

RTX Corp.; Collins Aerospace; segment ROA calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Operating profit (loss) 3,825 2,343 1,759 1,466 4,100
Total assets 72,085 67,030 67,564 68,701 74,049
Segment Profitability Ratio
Segment ROA1 5.31% 3.50% 2.60% 2.13% 5.54%

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Segment ROA = 100 × Operating profit (loss) ÷ Total assets
= 100 × 3,825 ÷ 72,085 = 5.31%

Segment profitability ratio Reportable segment The company
Segment ROA Collins Aerospace Collins Aerospace segment ROA improved from 2021 to 2022 and from 2022 to 2023.

Segment ROA: Pratt & Whitney

RTX Corp.; Pratt & Whitney; segment ROA calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Operating profit (loss) (1,455) 1,075 454 (564) 1,668
Total assets 40,723 36,205 33,414 32,780 31,271
Segment Profitability Ratio
Segment ROA1 -3.57% 2.97% 1.36% -1.72% 5.33%

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Segment ROA = 100 × Operating profit (loss) ÷ Total assets
= 100 × -1,455 ÷ 40,723 = -3.57%

Segment profitability ratio Reportable segment The company
Segment ROA Pratt & Whitney Pratt & Whitney segment ROA improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Segment ROA: Raytheon

RTX Corp.; Raytheon; segment ROA calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Operating profit (loss) 2,379 2,861 3,837 1,904
Total assets 44,929 49,026 50,311 50,910
Segment Profitability Ratio
Segment ROA1 5.30% 5.84% 7.63% 3.74%

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Segment ROA = 100 × Operating profit (loss) ÷ Total assets
= 100 × 2,379 ÷ 44,929 = 5.30%

Segment profitability ratio Reportable segment The company
Segment ROA Raytheon Raytheon segment ROA deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment Asset Turnover

RTX Corp., asset turnover by reportable segment

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Collins Aerospace 0.36 0.31 0.27 0.28 0.35
Pratt & Whitney 0.45 0.57 0.54 0.51 0.67
Raytheon 0.59 0.60 0.61 0.44

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

Segment activity ratio Reportable segment The company
Segment asset turnover Collins Aerospace Collins Aerospace segment asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.
Pratt & Whitney Pratt & Whitney segment asset turnover ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.
Raytheon Raytheon segment asset turnover ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment Asset Turnover: Collins Aerospace

RTX Corp.; Collins Aerospace; segment asset turnover calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Net sales 26,253 20,597 18,449 19,288 26,028
Total assets 72,085 67,030 67,564 68,701 74,049
Segment Activity Ratio
Segment asset turnover1 0.36 0.31 0.27 0.28 0.35

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Segment asset turnover = Net sales ÷ Total assets
= 26,253 ÷ 72,085 = 0.36

Segment activity ratio Reportable segment The company
Segment asset turnover Collins Aerospace Collins Aerospace segment asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Asset Turnover: Pratt & Whitney

RTX Corp.; Pratt & Whitney; segment asset turnover calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Net sales 18,296 20,530 18,150 16,799 20,892
Total assets 40,723 36,205 33,414 32,780 31,271
Segment Activity Ratio
Segment asset turnover1 0.45 0.57 0.54 0.51 0.67

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Segment asset turnover = Net sales ÷ Total assets
= 18,296 ÷ 40,723 = 0.45

Segment activity ratio Reportable segment The company
Segment asset turnover Pratt & Whitney Pratt & Whitney segment asset turnover ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Segment Asset Turnover: Raytheon

RTX Corp.; Raytheon; segment asset turnover calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Net sales 26,350 29,175 30,719 22,501
Total assets 44,929 49,026 50,311 50,910
Segment Activity Ratio
Segment asset turnover1 0.59 0.60 0.61 0.44

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Segment asset turnover = Net sales ÷ Total assets
= 26,350 ÷ 44,929 = 0.59

Segment activity ratio Reportable segment The company
Segment asset turnover Raytheon Raytheon segment asset turnover ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment Capital Expenditures to Depreciation

RTX Corp., capital expenditures to depreciation by reportable segment

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Collins Aerospace 0.87 0.88 0.91 0.87 0.55
Pratt & Whitney 1.39 1.31 1.09 0.78 0.84
Raytheon 1.17 1.07 1.14 1.30

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Collins Aerospace Collins Aerospace segment capital expenditures to depreciation ratio deteriorated from 2021 to 2022 and from 2022 to 2023.
Pratt & Whitney Pratt & Whitney segment capital expenditures to depreciation ratio improved from 2021 to 2022 and from 2022 to 2023.
Raytheon Raytheon segment capital expenditures to depreciation ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.

Segment Capital Expenditures to Depreciation: Collins Aerospace

RTX Corp.; Collins Aerospace; segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Capital expenditures 628 655 665 638 959
Depreciation & amortization 724 742 728 736 1,749
Segment Financial Ratio
Segment capital expenditures to depreciation1 0.87 0.88 0.91 0.87 0.55

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation & amortization
= 628 ÷ 724 = 0.87

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Collins Aerospace Collins Aerospace segment capital expenditures to depreciation ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment Capital Expenditures to Depreciation: Pratt & Whitney

RTX Corp.; Pratt & Whitney; segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Capital expenditures 1,025 949 700 565 822
Depreciation & amortization 736 724 642 729 980
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.39 1.31 1.09 0.78 0.84

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation & amortization
= 1,025 ÷ 736 = 1.39

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Pratt & Whitney Pratt & Whitney segment capital expenditures to depreciation ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Capital Expenditures to Depreciation: Raytheon

RTX Corp.; Raytheon; segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Capital expenditures 637 580 592 498
Depreciation & amortization 544 542 520 382
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.17 1.07 1.14 1.30

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation & amortization
= 637 ÷ 544 = 1.17

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Raytheon Raytheon segment capital expenditures to depreciation ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.

Net sales

RTX Corp., net sales by reportable segment

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Otis 13,113
Carrier 18,608
Collins Aerospace 26,253 20,597 18,449 19,288 26,028
Pratt & Whitney 18,296 20,530 18,150 16,799 20,892
Raytheon 26,350 29,175 30,719 22,501
Total segment 70,899 70,302 67,318 58,588 78,641

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).


Operating profit (loss)

RTX Corp., operating profit (loss) by reportable segment

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Otis 1,948
Carrier 2,697
Collins Aerospace 3,825 2,343 1,759 1,466 4,100
Pratt & Whitney (1,455) 1,075 454 (564) 1,668
Raytheon 2,379 2,861 3,837 1,904
Total segment 4,749 6,279 6,050 2,806 10,413

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).


Total assets

RTX Corp., total assets by reportable segment

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Otis 9,973
Carrier 22,789
Collins Aerospace 72,085 67,030 67,564 68,701 74,049
Pratt & Whitney 40,723 36,205 33,414 32,780 31,271
Raytheon 44,929 49,026 50,311 50,910
Total segment 157,737 152,261 151,289 152,391 138,082

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).


Capital expenditures

RTX Corp., capital expenditures by reportable segment

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Otis 145
Carrier 243
Collins Aerospace 628 655 665 638 959
Pratt & Whitney 1,025 949 700 565 822
Raytheon 637 580 592 498
Total segment 2,290 2,184 1,957 1,701 2,169

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).


Depreciation & amortization

RTX Corp., depreciation & amortization by reportable segment

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Otis 337
Carrier 513
Collins Aerospace 724 742 728 736 1,749
Pratt & Whitney 736 724 642 729 980
Raytheon 544 542 520 382
Total segment 2,004 2,008 1,890 1,847 3,579

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).