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.

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Microsoft Excel

Long-term Activity Ratios (Summary)

Western Digital Corp., long-term (investment) activity ratios (quarterly data)

Microsoft Excel
Dec 29, 2023 Sep 29, 2023 Jun 30, 2023 Mar 31, 2023 Dec 30, 2022 Sep 30, 2022 Jul 1, 2022 Apr 1, 2022 Dec 31, 2021 Oct 1, 2021 Jul 2, 2021 Apr 2, 2021 Jan 1, 2021 Oct 2, 2020 Jul 3, 2020 Apr 3, 2020 Jan 3, 2020 Oct 4, 2019 Jun 28, 2019 Mar 29, 2019 Dec 28, 2018 Sep 28, 2018 Jun 29, 2018 Mar 30, 2018 Dec 29, 2017 Sep 29, 2017
Net fixed asset turnover 3.40 3.36 3.40 3.86 4.27 4.70 5.12 5.50 5.63 5.54 5.31 5.32 5.60 5.74 5.86 5.88 5.72 5.57 5.83 5.96 6.30 6.71 6.67
Total asset turnover 0.46 0.47 0.50 0.56 0.63 0.68 0.72 0.75 0.73 0.68 0.65 0.64 0.64 0.65 0.65 0.63 0.60 0.59 0.63 0.67 0.69 0.71 0.71
Equity turnover 1.03 1.03 1.05 1.14 1.30 1.44 1.54 1.60 1.58 1.59 1.58 1.64 1.66 1.74 1.75 1.74 1.66 1.63 1.66 1.77 1.78 1.80 1.79

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).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Western Digital Corp. net fixed asset turnover ratio deteriorated from Q4 2023 to Q1 2024 but then improved from Q1 2024 to Q2 2024 not reaching Q4 2023 level.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Western Digital Corp. total asset turnover ratio deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Western Digital Corp. equity turnover ratio deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024.

Net Fixed Asset Turnover

Western Digital Corp., net fixed asset turnover calculation (quarterly data)

Microsoft Excel
Dec 29, 2023 Sep 29, 2023 Jun 30, 2023 Mar 31, 2023 Dec 30, 2022 Sep 30, 2022 Jul 1, 2022 Apr 1, 2022 Dec 31, 2021 Oct 1, 2021 Jul 2, 2021 Apr 2, 2021 Jan 1, 2021 Oct 2, 2020 Jul 3, 2020 Apr 3, 2020 Jan 3, 2020 Oct 4, 2019 Jun 28, 2019 Mar 29, 2019 Dec 28, 2018 Sep 28, 2018 Jun 29, 2018 Mar 30, 2018 Dec 29, 2017 Sep 29, 2017
Selected Financial Data (US$ in millions)
Revenue, net 3,032 2,750 2,672 2,803 3,107 3,736 4,528 4,381 4,833 5,051 4,920 4,137 3,943 3,922 4,287 4,175 4,234 4,040 3,634 3,674 4,233 5,028 5,117 5,013 5,336 5,181
Property, plant and equipment, net 3,315 3,371 3,620 3,668 3,688 3,718 3,670 3,488 3,367 3,260 3,188 3,061 2,918 2,897 2,854 2,735 2,722 2,796 2,843 3,031 3,077 3,054 3,095 3,011 3,054 3,048
Long-term Activity Ratio
Net fixed asset turnover1 3.40 3.36 3.40 3.86 4.27 4.70 5.12 5.50 5.63 5.54 5.31 5.32 5.60 5.74 5.86 5.88 5.72 5.57 5.83 5.96 6.30 6.71 6.67
Benchmarks
Net Fixed Asset Turnover, Competitors2
Apple Inc. 8.76 8.83 8.77 8.82 8.87 9.02 9.36 9.61 9.82 9.64 9.28 8.99 8.61 7.75 7.47 7.67 7.47 7.23 6.96
Arista Networks Inc. 65.55 62.08 57.69 54.54 51.74 49.98 46.11 40.75 38.14 36.13 37.49 36.78 81.23 75.84 71.90 68.00 64.39 61.85 61.38
Cisco Systems Inc. 28.55 28.96 27.34 26.82 27.07 26.52 25.82 25.21 24.09 22.69 21.31 20.64 20.13 19.93 20.10 19.95 19.67 19.48 18.61
Dell Technologies Inc. 14.97 15.51 16.48 18.00 18.53 18.99 18.69 14.34 14.47 14.48 14.65 14.52 14.34 15.11 15.22
Super Micro Computer Inc. 31.14 25.34 24.54 22.67 22.98 20.69 18.17 16.40 14.88 13.47 12.95 12.74 12.77 13.65 14.28 14.31 14.82 15.67 16.88

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).

1 Q2 2024 Calculation
Net fixed asset turnover = (Revenue, netQ2 2024 + Revenue, netQ1 2024 + Revenue, netQ4 2023 + Revenue, netQ3 2023) ÷ Property, plant and equipment, net
= (3,032 + 2,750 + 2,672 + 2,803) ÷ 3,315 = 3.40

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Western Digital Corp. net fixed asset turnover ratio deteriorated from Q4 2023 to Q1 2024 but then improved from Q1 2024 to Q2 2024 not reaching Q4 2023 level.

Total Asset Turnover

Western Digital Corp., total asset turnover calculation (quarterly data)

Microsoft Excel
Dec 29, 2023 Sep 29, 2023 Jun 30, 2023 Mar 31, 2023 Dec 30, 2022 Sep 30, 2022 Jul 1, 2022 Apr 1, 2022 Dec 31, 2021 Oct 1, 2021 Jul 2, 2021 Apr 2, 2021 Jan 1, 2021 Oct 2, 2020 Jul 3, 2020 Apr 3, 2020 Jan 3, 2020 Oct 4, 2019 Jun 28, 2019 Mar 29, 2019 Dec 28, 2018 Sep 28, 2018 Jun 29, 2018 Mar 30, 2018 Dec 29, 2017 Sep 29, 2017
Selected Financial Data (US$ in millions)
Revenue, net 3,032 2,750 2,672 2,803 3,107 3,736 4,528 4,381 4,833 5,051 4,920 4,137 3,943 3,922 4,287 4,175 4,234 4,040 3,634 3,674 4,233 5,028 5,117 5,013 5,336 5,181
Total assets 24,385 24,001 24,429 25,151 25,047 25,686 26,259 25,699 26,025 26,391 26,132 25,409 25,552 25,402 25,662 25,509 25,860 26,280 26,370 26,913 27,939 28,705 29,235 29,004 29,840 30,505
Long-term Activity Ratio
Total asset turnover1 0.46 0.47 0.50 0.56 0.63 0.68 0.72 0.75 0.73 0.68 0.65 0.64 0.64 0.65 0.65 0.63 0.60 0.59 0.63 0.67 0.69 0.71 0.71
Benchmarks
Total Asset Turnover, Competitors2
Apple Inc. 1.13 1.09 1.09 1.15 1.16 1.12 1.12 1.15 1.10 0.99 1.04 1.05 0.97 0.83 0.85 0.86 0.84 0.79 0.77
Arista Networks Inc. 0.54 0.58 0.59 0.62 0.64 0.64 0.65 0.64 0.60 0.52 0.51 0.51 0.50 0.50 0.49 0.50 0.52 0.57 0.58
Cisco Systems Inc. 0.57 0.59 0.56 0.56 0.55 0.56 0.55 0.56 0.55 0.53 0.51 0.52 0.50 0.51 0.52 0.55 0.57 0.56 0.53
Dell Technologies Inc. 1.09 1.15 1.14 1.24 1.20 1.18 1.09 0.73 0.79 0.78 0.76 0.77 0.75 0.77 0.78
Super Micro Computer Inc. 1.71 1.80 1.94 2.06 2.16 1.82 1.62 1.51 1.56 1.58 1.59 1.69 1.72 1.82 1.74 1.68 1.81 1.96 2.08

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).

1 Q2 2024 Calculation
Total asset turnover = (Revenue, netQ2 2024 + Revenue, netQ1 2024 + Revenue, netQ4 2023 + Revenue, netQ3 2023) ÷ Total assets
= (3,032 + 2,750 + 2,672 + 2,803) ÷ 24,385 = 0.46

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Western Digital Corp. total asset turnover ratio deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024.

Equity Turnover

Western Digital Corp., equity turnover calculation (quarterly data)

Microsoft Excel
Dec 29, 2023 Sep 29, 2023 Jun 30, 2023 Mar 31, 2023 Dec 30, 2022 Sep 30, 2022 Jul 1, 2022 Apr 1, 2022 Dec 31, 2021 Oct 1, 2021 Jul 2, 2021 Apr 2, 2021 Jan 1, 2021 Oct 2, 2020 Jul 3, 2020 Apr 3, 2020 Jan 3, 2020 Oct 4, 2019 Jun 28, 2019 Mar 29, 2019 Dec 28, 2018 Sep 28, 2018 Jun 29, 2018 Mar 30, 2018 Dec 29, 2017 Sep 29, 2017
Selected Financial Data (US$ in millions)
Revenue, net 3,032 2,750 2,672 2,803 3,107 3,736 4,528 4,381 4,833 5,051 4,920 4,137 3,943 3,922 4,287 4,175 4,234 4,040 3,634 3,674 4,233 5,028 5,117 5,013 5,336 5,181
Shareholders’ equity 10,944 10,989 11,723 12,487 12,115 12,107 12,221 11,984 12,018 11,361 10,721 9,949 9,829 9,576 9,551 9,243 9,379 9,566 9,967 10,214 10,912 11,375 11,531 11,300 11,272 12,059
Long-term Activity Ratio
Equity turnover1 1.03 1.03 1.05 1.14 1.30 1.44 1.54 1.60 1.58 1.59 1.58 1.64 1.66 1.74 1.75 1.74 1.66 1.63 1.66 1.77 1.78 1.80 1.79
Benchmarks
Equity Turnover, Competitors2
Apple Inc. 5.14 5.21 6.17 6.37 6.20 6.83 7.78 6.67 5.73 5.26 5.80 5.40 4.70 4.44 4.20 3.79 3.42 2.99 2.88
Arista Networks Inc. 0.75 0.77 0.81 0.86 0.90 0.91 0.90 0.90 0.87 0.76 0.74 0.72 0.71 0.71 0.70 0.72 0.75 0.82 0.83
Cisco Systems Inc. 1.24 1.28 1.29 1.30 1.28 1.30 1.30 1.28 1.31 1.19 1.21 1.21 1.23 1.26 1.30 1.42 1.45 1.51 1.55
Dell Technologies Inc. 11.09 19.97 27.22 38.01 104.35
Super Micro Computer Inc. 3.01 3.41 3.61 3.72 3.65 3.70 3.64 3.63 3.51 3.38 3.25 3.21 3.06 3.08 3.13 3.18 3.26 3.43 3.72

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).

1 Q2 2024 Calculation
Equity turnover = (Revenue, netQ2 2024 + Revenue, netQ1 2024 + Revenue, netQ4 2023 + Revenue, netQ3 2023) ÷ Shareholders’ equity
= (3,032 + 2,750 + 2,672 + 2,803) ÷ 10,944 = 1.03

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Western Digital Corp. equity turnover ratio deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024.