Stock Analysis on Net
Stock Analysis on Net

Boeing Co. (NYSE:BA)

DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin
Quarterly Data

Microsoft Excel

Decomposing ROE involves expressing net income divided by shareholders’ equity as the product of component ratios.

Two-Component Disaggregation of ROE

Boeing Co., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
Mar 31, 2024 — = -1.60% × —
Dec 31, 2023 — = -1.62% × —
Sep 30, 2023 — = -2.11% × —
Jun 30, 2023 — = -3.32% × —
Mar 31, 2023 — = -3.03% × —
Dec 31, 2022 — = -3.60% × —
Sep 30, 2022 — = -6.14% × —
Jun 30, 2022 — = -3.90% × —
Mar 31, 2022 — = -3.60% × —
Dec 31, 2021 — = -3.03% × —
Sep 30, 2021 — = -5.77% × —
Jun 30, 2021 — = -5.92% × —
Mar 31, 2021 — = -7.85% × —
Dec 31, 2020 — = -7.80% × —
Sep 30, 2020 — = -2.77% × —
Jun 30, 2020 — = -1.75% × —
Mar 31, 2020 — = -2.39% × —
Dec 31, 2019 — = -0.48% × —
Sep 30, 2019 — = — × —
Jun 30, 2019 — = — × —
Mar 31, 2019 — = — × 961.67

Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

Three-Component Disaggregation of ROE

Boeing Co., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Mar 31, 2024 — = -2.81% × 0.57 × —
Dec 31, 2023 — = -2.86% × 0.57 × —
Sep 30, 2023 — = -3.74% × 0.56 × —
Jun 30, 2023 — = -6.08% × 0.55 × —
Mar 31, 2023 — = -5.86% × 0.52 × —
Dec 31, 2022 — = -7.41% × 0.49 × —
Sep 30, 2022 — = -13.75% × 0.45 × —
Jun 30, 2022 — = -8.69% × 0.45 × —
Mar 31, 2022 — = -8.00% × 0.45 × —
Dec 31, 2021 — = -6.75% × 0.45 × —
Sep 30, 2021 — = -13.50% × 0.43 × —
Jun 30, 2021 — = -14.30% × 0.41 × —
Mar 31, 2021 — = -20.87% × 0.38 × —
Dec 31, 2020 — = -20.42% × 0.38 × —
Sep 30, 2020 — = -7.34% × 0.38 × —
Jun 30, 2020 — = -4.27% × 0.41 × —
Mar 31, 2020 — = -4.84% × 0.49 × —
Dec 31, 2019 — = -0.83% × 0.57 × —
Sep 30, 2019 — = — × — × —
Jun 30, 2019 — = — × — × —
Mar 31, 2019 — = — × — × 961.67

Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

Five-Component Disaggregation of ROE

Boeing Co., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Mar 31, 2024 — = — × -3.64 × 0.67% × 0.57 × —
Dec 31, 2023 — = — × -4.19 × 0.61% × 0.57 × —
Sep 30, 2023 — = — × — × -0.15% × 0.56 × —
Jun 30, 2023 — = — × — × -2.83% × 0.55 × —
Mar 31, 2023 — = — × — × -1.76% × 0.52 × —
Dec 31, 2022 — = — × — × -3.56% × 0.49 × —
Sep 30, 2022 — = — × — × -10.42% × 0.45 × —
Jun 30, 2022 — = — × — × -5.83% × 0.45 × —
Mar 31, 2022 — = — × — × -5.50% × 0.45 × —
Dec 31, 2021 — = — × — × -3.63% × 0.45 × —
Sep 30, 2021 — = — × — × -9.80% × 0.43 × —
Jun 30, 2021 — = — × — × -11.03% × 0.41 × —
Mar 31, 2021 — = — × — × -19.29% × 0.38 × —
Dec 31, 2020 — = — × — × -21.07% × 0.38 × —
Sep 30, 2020 — = — × — × -10.60% × 0.38 × —
Jun 30, 2020 — = — × — × -7.21% × 0.41 × —
Mar 31, 2020 — = — × — × -7.40% × 0.49 × —
Dec 31, 2019 — = — × — × -2.01% × 0.57 × —
Sep 30, 2019 — = — × — × — × — × —
Jun 30, 2019 — = — × — × — × — × —
Mar 31, 2019 — = — × — × — × — × 961.67

Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

Two-Component Disaggregation of ROA

Boeing Co., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Mar 31, 2024 -1.60% = -2.81% × 0.57
Dec 31, 2023 -1.62% = -2.86% × 0.57
Sep 30, 2023 -2.11% = -3.74% × 0.56
Jun 30, 2023 -3.32% = -6.08% × 0.55
Mar 31, 2023 -3.03% = -5.86% × 0.52
Dec 31, 2022 -3.60% = -7.41% × 0.49
Sep 30, 2022 -6.14% = -13.75% × 0.45
Jun 30, 2022 -3.90% = -8.69% × 0.45
Mar 31, 2022 -3.60% = -8.00% × 0.45
Dec 31, 2021 -3.03% = -6.75% × 0.45
Sep 30, 2021 -5.77% = -13.50% × 0.43
Jun 30, 2021 -5.92% = -14.30% × 0.41
Mar 31, 2021 -7.85% = -20.87% × 0.38
Dec 31, 2020 -7.80% = -20.42% × 0.38
Sep 30, 2020 -2.77% = -7.34% × 0.38
Jun 30, 2020 -1.75% = -4.27% × 0.41
Mar 31, 2020 -2.39% = -4.84% × 0.49
Dec 31, 2019 -0.48% = -0.83% × 0.57
Sep 30, 2019 — = — × —
Jun 30, 2019 — = — × —
Mar 31, 2019 — = — × —

Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

Four-Component Disaggregation of ROA

Boeing Co., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Mar 31, 2024 -1.60% = — × -3.64 × 0.67% × 0.57
Dec 31, 2023 -1.62% = — × -4.19 × 0.61% × 0.57
Sep 30, 2023 -2.11% = — × — × -0.15% × 0.56
Jun 30, 2023 -3.32% = — × — × -2.83% × 0.55
Mar 31, 2023 -3.03% = — × — × -1.76% × 0.52
Dec 31, 2022 -3.60% = — × — × -3.56% × 0.49
Sep 30, 2022 -6.14% = — × — × -10.42% × 0.45
Jun 30, 2022 -3.90% = — × — × -5.83% × 0.45
Mar 31, 2022 -3.60% = — × — × -5.50% × 0.45
Dec 31, 2021 -3.03% = — × — × -3.63% × 0.45
Sep 30, 2021 -5.77% = — × — × -9.80% × 0.43
Jun 30, 2021 -5.92% = — × — × -11.03% × 0.41
Mar 31, 2021 -7.85% = — × — × -19.29% × 0.38
Dec 31, 2020 -7.80% = — × — × -21.07% × 0.38
Sep 30, 2020 -2.77% = — × — × -10.60% × 0.38
Jun 30, 2020 -1.75% = — × — × -7.21% × 0.41
Mar 31, 2020 -2.39% = — × — × -7.40% × 0.49
Dec 31, 2019 -0.48% = — × — × -2.01% × 0.57
Sep 30, 2019 — = — × — × — × —
Jun 30, 2019 — = — × — × — × —
Mar 31, 2019 — = — × — × — × —

Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

Disaggregation of Net Profit Margin

Boeing Co., decomposition of net profit margin ratio (quarterly data)

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Mar 31, 2024 -2.81% = — × -3.64 × 0.67%
Dec 31, 2023 -2.86% = — × -4.19 × 0.61%
Sep 30, 2023 -3.74% = — × — × -0.15%
Jun 30, 2023 -6.08% = — × — × -2.83%
Mar 31, 2023 -5.86% = — × — × -1.76%
Dec 31, 2022 -7.41% = — × — × -3.56%
Sep 30, 2022 -13.75% = — × — × -10.42%
Jun 30, 2022 -8.69% = — × — × -5.83%
Mar 31, 2022 -8.00% = — × — × -5.50%
Dec 31, 2021 -6.75% = — × — × -3.63%
Sep 30, 2021 -13.50% = — × — × -9.80%
Jun 30, 2021 -14.30% = — × — × -11.03%
Mar 31, 2021 -20.87% = — × — × -19.29%
Dec 31, 2020 -20.42% = — × — × -21.07%
Sep 30, 2020 -7.34% = — × — × -10.60%
Jun 30, 2020 -4.27% = — × — × -7.21%
Mar 31, 2020 -4.84% = — × — × -7.40%
Dec 31, 2019 -0.83% = — × — × -2.01%
Sep 30, 2019 — = — × — × —
Jun 30, 2019 — = — × — × —
Mar 31, 2019 — = — × — × —

Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).