Stock Analysis on Net
Stock Analysis on Net

Intel Corp. (NASDAQ:INTC)

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

Intel Corp., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
Dec 30, 2023 1.60% = 0.88% × 1.81
Sep 30, 2023 -1.61% = -0.87% × 1.85
Jul 1, 2023 -0.91% = -0.50% × 1.84
Apr 1, 2023 -2.91% = -1.54% × 1.89
Dec 31, 2022 7.90% = 4.40% × 1.80
Oct 1, 2022 13.32% = 7.61% × 1.75
Jul 2, 2022 18.88% = 11.21% × 1.68
Apr 2, 2022 23.87% = 13.96% × 1.71
Dec 25, 2021 20.83% = 11.80% × 1.77
Sep 25, 2021 23.42% = 12.56% × 1.86
Jun 26, 2021 21.78% = 12.00% × 1.81
Mar 27, 2021 23.30% = 12.35% × 1.89
Dec 26, 2020 25.79% = 13.65% × 1.89
Sep 26, 2020 29.44% = 15.11% × 1.95
Jun 27, 2020 28.85% = 15.51% × 1.86
Mar 28, 2020 29.78% = 15.39% × 1.93
Dec 28, 2019 27.16% = 15.42% × 1.76
Sep 28, 2019 — = — × 1.80
Jun 29, 2019 — = — × 1.74
Mar 30, 2019 — = — × 1.76

Based on: 10-K (reporting date: 2023-12-30), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-07-01), 10-Q (reporting date: 2023-04-01), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-10-01), 10-Q (reporting date: 2022-07-02), 10-Q (reporting date: 2022-04-02), 10-K (reporting date: 2021-12-25), 10-Q (reporting date: 2021-09-25), 10-Q (reporting date: 2021-06-26), 10-Q (reporting date: 2021-03-27), 10-K (reporting date: 2020-12-26), 10-Q (reporting date: 2020-09-26), 10-Q (reporting date: 2020-06-27), 10-Q (reporting date: 2020-03-28), 10-K (reporting date: 2019-12-28), 10-Q (reporting date: 2019-09-28), 10-Q (reporting date: 2019-06-29), 10-Q (reporting date: 2019-03-30).

Three-Component Disaggregation of ROE

Intel Corp., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Dec 30, 2023 1.60% = 3.11% × 0.28 × 1.81
Sep 30, 2023 -1.61% = -3.11% × 0.28 × 1.85
Jul 1, 2023 -0.91% = -1.71% × 0.29 × 1.84
Apr 1, 2023 -2.91% = -5.06% × 0.30 × 1.89
Dec 31, 2022 7.90% = 12.71% × 0.35 × 1.80
Oct 1, 2022 13.32% = 19.13% × 0.40 × 1.75
Jul 2, 2022 18.88% = 26.03% × 0.43 × 1.68
Apr 2, 2022 23.87% = 31.68% × 0.44 × 1.71
Dec 25, 2021 20.83% = 25.14% × 0.47 × 1.77
Sep 25, 2021 23.42% = 26.89% × 0.47 × 1.86
Jun 26, 2021 21.78% = 23.91% × 0.50 × 1.81
Mar 27, 2021 23.30% = 23.93% × 0.52 × 1.89
Dec 26, 2020 25.79% = 26.84% × 0.51 × 1.89
Sep 26, 2020 29.44% = 28.10% × 0.54 × 1.95
Jun 27, 2020 28.85% = 29.97% × 0.52 × 1.86
Mar 28, 2020 29.78% = 30.02% × 0.51 × 1.93
Dec 28, 2019 27.16% = 29.25% × 0.53 × 1.76
Sep 28, 2019 — = — × — × 1.80
Jun 29, 2019 — = — × — × 1.74
Mar 30, 2019 — = — × — × 1.76

Based on: 10-K (reporting date: 2023-12-30), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-07-01), 10-Q (reporting date: 2023-04-01), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-10-01), 10-Q (reporting date: 2022-07-02), 10-Q (reporting date: 2022-04-02), 10-K (reporting date: 2021-12-25), 10-Q (reporting date: 2021-09-25), 10-Q (reporting date: 2021-06-26), 10-Q (reporting date: 2021-03-27), 10-K (reporting date: 2020-12-26), 10-Q (reporting date: 2020-09-26), 10-Q (reporting date: 2020-06-27), 10-Q (reporting date: 2020-03-28), 10-K (reporting date: 2019-12-28), 10-Q (reporting date: 2019-09-28), 10-Q (reporting date: 2019-06-29), 10-Q (reporting date: 2019-03-30).

Two-Component Disaggregation of ROA

Intel Corp., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Dec 30, 2023 0.88% = 3.11% × 0.28
Sep 30, 2023 -0.87% = -3.11% × 0.28
Jul 1, 2023 -0.50% = -1.71% × 0.29
Apr 1, 2023 -1.54% = -5.06% × 0.30
Dec 31, 2022 4.40% = 12.71% × 0.35
Oct 1, 2022 7.61% = 19.13% × 0.40
Jul 2, 2022 11.21% = 26.03% × 0.43
Apr 2, 2022 13.96% = 31.68% × 0.44
Dec 25, 2021 11.80% = 25.14% × 0.47
Sep 25, 2021 12.56% = 26.89% × 0.47
Jun 26, 2021 12.00% = 23.91% × 0.50
Mar 27, 2021 12.35% = 23.93% × 0.52
Dec 26, 2020 13.65% = 26.84% × 0.51
Sep 26, 2020 15.11% = 28.10% × 0.54
Jun 27, 2020 15.51% = 29.97% × 0.52
Mar 28, 2020 15.39% = 30.02% × 0.51
Dec 28, 2019 15.42% = 29.25% × 0.53
Sep 28, 2019 — = — × —
Jun 29, 2019 — = — × —
Mar 30, 2019 — = — × —

Based on: 10-K (reporting date: 2023-12-30), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-07-01), 10-Q (reporting date: 2023-04-01), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-10-01), 10-Q (reporting date: 2022-07-02), 10-Q (reporting date: 2022-04-02), 10-K (reporting date: 2021-12-25), 10-Q (reporting date: 2021-09-25), 10-Q (reporting date: 2021-06-26), 10-Q (reporting date: 2021-03-27), 10-K (reporting date: 2020-12-26), 10-Q (reporting date: 2020-09-26), 10-Q (reporting date: 2020-06-27), 10-Q (reporting date: 2020-03-28), 10-K (reporting date: 2019-12-28), 10-Q (reporting date: 2019-09-28), 10-Q (reporting date: 2019-06-29), 10-Q (reporting date: 2019-03-30).