Stock Analysis on Net
Stock Analysis on Net

Western Digital Corp. (NASDAQ:WDC)

This company has been moved to the archive! The financial data has not been updated since February 12, 2024.

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

Western Digital Corp., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
Dec 29, 2023 -20.64% = -9.26% × 2.23
Sep 29, 2023 -22.00% = -10.07% × 2.18
Jun 30, 2023 -14.55% = -6.98% × 2.08
Mar 31, 2023 -5.53% = -2.74% × 2.01
Dec 30, 2022 -0.77% = -0.37% × 2.07
Sep 30, 2022 7.57% = 3.57% × 2.12
Jul 1, 2022 12.27% = 5.71% × 2.15
Apr 1, 2022 15.20% = 7.09% × 2.14
Dec 31, 2021 16.58% = 7.66% × 2.17
Oct 1, 2021 13.12% = 5.65% × 2.32
Jul 2, 2021 7.66% = 3.14% × 2.44
Apr 2, 2021 3.49% = 1.37% × 2.55
Jan 1, 2021 1.70% = 0.65% × 2.60
Oct 2, 2020 -0.36% = -0.13% × 2.65
Jul 3, 2020 -2.62% = -0.97% × 2.69
Apr 3, 2020 -6.44% = -2.33% × 2.76
Jan 3, 2020 -12.72% = -4.61% × 2.76
Oct 4, 2019 -16.11% = -5.86% × 2.75
Jun 28, 2019 -7.56% = -2.86% × 2.65
Mar 29, 2019 1.95% = 0.74% × 2.63
Dec 28, 2018 7.71% = 3.01% × 2.56
Sep 28, 2018 4.44% = 1.76% × 2.52
Jun 29, 2018 5.85% = 2.31% × 2.54
Mar 30, 2018 — = — × 2.57
Dec 29, 2017 — = — × 2.65
Sep 29, 2017 — = — × 2.53

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

Three-Component Disaggregation of ROE

Western Digital Corp., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Dec 29, 2023 -20.64% = -20.07% × 0.46 × 2.23
Sep 29, 2023 -22.00% = -21.34% × 0.47 × 2.18
Jun 30, 2023 -14.55% = -13.85% × 0.50 × 2.08
Mar 31, 2023 -5.53% = -4.87% × 0.56 × 2.01
Dec 30, 2022 -0.77% = -0.59% × 0.63 × 2.07
Sep 30, 2022 7.57% = 5.25% × 0.68 × 2.12
Jul 1, 2022 12.27% = 7.98% × 0.72 × 2.15
Apr 1, 2022 15.20% = 9.49% × 0.75 × 2.14
Dec 31, 2021 16.58% = 10.52% × 0.73 × 2.17
Oct 1, 2021 13.12% = 8.26% × 0.68 × 2.32
Jul 2, 2021 7.66% = 4.85% × 0.65 × 2.44
Apr 2, 2021 3.49% = 2.13% × 0.64 × 2.55
Jan 1, 2021 1.70% = 1.02% × 0.64 × 2.60
Oct 2, 2020 -0.36% = -0.20% × 0.65 × 2.65
Jul 3, 2020 -2.62% = -1.49% × 0.65 × 2.69
Apr 3, 2020 -6.44% = -3.70% × 0.63 × 2.76
Jan 3, 2020 -12.72% = -7.66% × 0.60 × 2.76
Oct 4, 2019 -16.11% = -9.89% × 0.59 × 2.75
Jun 28, 2019 -7.56% = -4.55% × 0.63 × 2.65
Mar 29, 2019 1.95% = 1.10% × 0.67 × 2.63
Dec 28, 2018 7.71% = 4.34% × 0.69 × 2.56
Sep 28, 2018 4.44% = 2.46% × 0.71 × 2.52
Jun 29, 2018 5.85% = 3.27% × 0.71 × 2.54
Mar 30, 2018 — = — × — × 2.57
Dec 29, 2017 — = — × — × 2.65
Sep 29, 2017 — = — × — × 2.53

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

Five-Component Disaggregation of ROE

Western Digital Corp., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Dec 29, 2023 -20.64% = — × — × -16.21% × 0.46 × 2.23
Sep 29, 2023 -22.00% = — × — × -17.53% × 0.47 × 2.18
Jun 30, 2023 -14.55% = — × — × -10.13% × 0.50 × 2.08
Mar 31, 2023 -5.53% = — × — × -0.15% × 0.56 × 2.01
Dec 30, 2022 -0.77% = -0.20 × 0.62 × 4.86% × 0.63 × 2.07
Sep 30, 2022 7.57% = 0.61 × 0.84 × 10.29% × 0.68 × 2.12
Jul 1, 2022 12.27% = 0.71 × 0.87 × 12.91% × 0.72 × 2.15
Apr 1, 2022 15.20% = 0.82 × 0.88 × 13.12% × 0.75 × 2.14
Dec 31, 2021 16.58% = 0.91 × 0.87 × 13.25% × 0.73 × 2.17
Oct 1, 2021 13.12% = 0.91 × 0.84 × 10.82% × 0.68 × 2.32
Jul 2, 2021 7.66% = 0.89 × 0.74 × 7.40% × 0.65 × 2.44
Apr 2, 2021 3.49% = 0.67 × 0.61 × 5.21% × 0.64 × 2.55
Jan 1, 2021 1.70% = 0.53 × 0.47 × 4.07% × 0.64 × 2.60
Oct 2, 2020 -0.36% = -0.18 × 0.33 × 3.39% × 0.65 × 2.65
Jul 3, 2020 -2.62% = — × -0.13 × 2.19% × 0.65 × 2.69
Apr 3, 2020 -6.44% = — × — × -1.63% × 0.63 × 2.76
Jan 3, 2020 -12.72% = — × — × -4.92% × 0.60 × 2.76
Oct 4, 2019 -16.11% = — × — × -4.06% × 0.59 × 2.75
Jun 28, 2019 -7.56% = — × -1.58 × 1.10% × 0.63 × 2.65
Mar 29, 2019 1.95% = 0.22 × 0.66 × 7.66% × 0.67 × 2.63
Dec 28, 2018 7.71% = 0.66 × 0.71 × 9.14% × 0.69 × 2.56
Sep 28, 2018 4.44% = 0.26 × 0.77 × 12.42% × 0.71 × 2.52
Jun 29, 2018 5.85% = 0.32 × 0.76 × 13.37% × 0.71 × 2.54
Mar 30, 2018 — = — × — × — × — × 2.57
Dec 29, 2017 — = — × — × — × — × 2.65
Sep 29, 2017 — = — × — × — × — × 2.53

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

Two-Component Disaggregation of ROA

Western Digital Corp., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Dec 29, 2023 -9.26% = -20.07% × 0.46
Sep 29, 2023 -10.07% = -21.34% × 0.47
Jun 30, 2023 -6.98% = -13.85% × 0.50
Mar 31, 2023 -2.74% = -4.87% × 0.56
Dec 30, 2022 -0.37% = -0.59% × 0.63
Sep 30, 2022 3.57% = 5.25% × 0.68
Jul 1, 2022 5.71% = 7.98% × 0.72
Apr 1, 2022 7.09% = 9.49% × 0.75
Dec 31, 2021 7.66% = 10.52% × 0.73
Oct 1, 2021 5.65% = 8.26% × 0.68
Jul 2, 2021 3.14% = 4.85% × 0.65
Apr 2, 2021 1.37% = 2.13% × 0.64
Jan 1, 2021 0.65% = 1.02% × 0.64
Oct 2, 2020 -0.13% = -0.20% × 0.65
Jul 3, 2020 -0.97% = -1.49% × 0.65
Apr 3, 2020 -2.33% = -3.70% × 0.63
Jan 3, 2020 -4.61% = -7.66% × 0.60
Oct 4, 2019 -5.86% = -9.89% × 0.59
Jun 28, 2019 -2.86% = -4.55% × 0.63
Mar 29, 2019 0.74% = 1.10% × 0.67
Dec 28, 2018 3.01% = 4.34% × 0.69
Sep 28, 2018 1.76% = 2.46% × 0.71
Jun 29, 2018 2.31% = 3.27% × 0.71
Mar 30, 2018 — = — × —
Dec 29, 2017 — = — × —
Sep 29, 2017 — = — × —

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

Four-Component Disaggregation of ROA

Western Digital Corp., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Dec 29, 2023 -9.26% = — × — × -16.21% × 0.46
Sep 29, 2023 -10.07% = — × — × -17.53% × 0.47
Jun 30, 2023 -6.98% = — × — × -10.13% × 0.50
Mar 31, 2023 -2.74% = — × — × -0.15% × 0.56
Dec 30, 2022 -0.37% = -0.20 × 0.62 × 4.86% × 0.63
Sep 30, 2022 3.57% = 0.61 × 0.84 × 10.29% × 0.68
Jul 1, 2022 5.71% = 0.71 × 0.87 × 12.91% × 0.72
Apr 1, 2022 7.09% = 0.82 × 0.88 × 13.12% × 0.75
Dec 31, 2021 7.66% = 0.91 × 0.87 × 13.25% × 0.73
Oct 1, 2021 5.65% = 0.91 × 0.84 × 10.82% × 0.68
Jul 2, 2021 3.14% = 0.89 × 0.74 × 7.40% × 0.65
Apr 2, 2021 1.37% = 0.67 × 0.61 × 5.21% × 0.64
Jan 1, 2021 0.65% = 0.53 × 0.47 × 4.07% × 0.64
Oct 2, 2020 -0.13% = -0.18 × 0.33 × 3.39% × 0.65
Jul 3, 2020 -0.97% = — × -0.13 × 2.19% × 0.65
Apr 3, 2020 -2.33% = — × — × -1.63% × 0.63
Jan 3, 2020 -4.61% = — × — × -4.92% × 0.60
Oct 4, 2019 -5.86% = — × — × -4.06% × 0.59
Jun 28, 2019 -2.86% = — × -1.58 × 1.10% × 0.63
Mar 29, 2019 0.74% = 0.22 × 0.66 × 7.66% × 0.67
Dec 28, 2018 3.01% = 0.66 × 0.71 × 9.14% × 0.69
Sep 28, 2018 1.76% = 0.26 × 0.77 × 12.42% × 0.71
Jun 29, 2018 2.31% = 0.32 × 0.76 × 13.37% × 0.71
Mar 30, 2018 — = — × — × — × —
Dec 29, 2017 — = — × — × — × —
Sep 29, 2017 — = — × — × — × —

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

Disaggregation of Net Profit Margin

Western Digital Corp., decomposition of net profit margin ratio (quarterly data)

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Dec 29, 2023 -20.07% = — × — × -16.21%
Sep 29, 2023 -21.34% = — × — × -17.53%
Jun 30, 2023 -13.85% = — × — × -10.13%
Mar 31, 2023 -4.87% = — × — × -0.15%
Dec 30, 2022 -0.59% = -0.20 × 0.62 × 4.86%
Sep 30, 2022 5.25% = 0.61 × 0.84 × 10.29%
Jul 1, 2022 7.98% = 0.71 × 0.87 × 12.91%
Apr 1, 2022 9.49% = 0.82 × 0.88 × 13.12%
Dec 31, 2021 10.52% = 0.91 × 0.87 × 13.25%
Oct 1, 2021 8.26% = 0.91 × 0.84 × 10.82%
Jul 2, 2021 4.85% = 0.89 × 0.74 × 7.40%
Apr 2, 2021 2.13% = 0.67 × 0.61 × 5.21%
Jan 1, 2021 1.02% = 0.53 × 0.47 × 4.07%
Oct 2, 2020 -0.20% = -0.18 × 0.33 × 3.39%
Jul 3, 2020 -1.49% = — × -0.13 × 2.19%
Apr 3, 2020 -3.70% = — × — × -1.63%
Jan 3, 2020 -7.66% = — × — × -4.92%
Oct 4, 2019 -9.89% = — × — × -4.06%
Jun 28, 2019 -4.55% = — × -1.58 × 1.10%
Mar 29, 2019 1.10% = 0.22 × 0.66 × 7.66%
Dec 28, 2018 4.34% = 0.66 × 0.71 × 9.14%
Sep 28, 2018 2.46% = 0.26 × 0.77 × 12.42%
Jun 29, 2018 3.27% = 0.32 × 0.76 × 13.37%
Mar 30, 2018 — = — × — × —
Dec 29, 2017 — = — × — × —
Sep 29, 2017 — = — × — × —

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