Stock Analysis on Net

Walt Disney Co. (NYSE:DIS)

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

Microsoft Excel

Long-term Activity Ratios (Summary)

Walt Disney Co., long-term (investment) activity ratios (quarterly data)

Microsoft Excel
Dec 30, 2023 Sep 30, 2023 Jul 1, 2023 Apr 1, 2023 Dec 31, 2022 Oct 1, 2022 Jul 2, 2022 Apr 2, 2022 Jan 1, 2022 Oct 2, 2021 Jul 3, 2021 Apr 3, 2021 Jan 2, 2021 Oct 3, 2020 Jun 27, 2020 Mar 28, 2020 Dec 28, 2019 Sep 28, 2019 Jun 29, 2019 Mar 30, 2019 Dec 29, 2018 Sep 29, 2018 Jun 30, 2018 Mar 31, 2018 Dec 30, 2017
Net fixed asset turnover 2.52 2.54 2.54 2.52 2.47 2.46 2.42 2.33 2.23 2.07 1.96 1.82 1.88 2.04 2.19 2.43 2.36 2.20 2.06 1.93 1.99 2.01
Total asset turnover 0.45 0.43 0.43 0.42 0.42 0.41 0.40 0.38 0.36 0.33 0.31 0.29 0.30 0.32 0.34 0.38 0.37 0.36 0.31 0.28 0.59 0.60
Equity turnover 0.88 0.90 0.90 0.89 0.88 0.87 0.88 0.85 0.81 0.76 0.73 0.68 0.72 0.78 0.81 0.87 0.84 0.78 0.72 0.66 1.18 1.22

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

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Walt Disney Co. net fixed asset turnover ratio improved from Q3 2023 to Q4 2023 but then deteriorated significantly from Q4 2023 to Q1 2024.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Walt Disney Co. total asset turnover ratio improved from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Walt Disney Co. equity turnover ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.

Net Fixed Asset Turnover

Walt Disney Co., net fixed asset turnover calculation (quarterly data)

Microsoft Excel
Dec 30, 2023 Sep 30, 2023 Jul 1, 2023 Apr 1, 2023 Dec 31, 2022 Oct 1, 2022 Jul 2, 2022 Apr 2, 2022 Jan 1, 2022 Oct 2, 2021 Jul 3, 2021 Apr 3, 2021 Jan 2, 2021 Oct 3, 2020 Jun 27, 2020 Mar 28, 2020 Dec 28, 2019 Sep 28, 2019 Jun 29, 2019 Mar 30, 2019 Dec 29, 2018 Sep 29, 2018 Jun 30, 2018 Mar 31, 2018 Dec 30, 2017
Selected Financial Data (US$ in millions)
Revenues 23,549 21,241 22,330 21,815 23,512 20,150 21,504 19,249 21,819 18,534 17,022 15,613 16,249 14,707 11,779 18,025 20,877 19,100 20,245 14,922 15,303 14,307 15,228 14,548 15,351
Parks, resorts and other property, net 35,321 34,941 34,577 34,579 34,200 33,596 33,583 32,917 32,681 32,624 32,377 32,137 32,263 32,078 31,891 32,151 31,895 31,603 31,392 31,017 29,797 29,540 29,373 29,200 28,584
Long-term Activity Ratio
Net fixed asset turnover1 2.52 2.54 2.54 2.52 2.47 2.46 2.42 2.33 2.23 2.07 1.96 1.82 1.88 2.04 2.19 2.43 2.36 2.20 2.06 1.93 1.99 2.01
Benchmarks
Net Fixed Asset Turnover, Competitors2
Alphabet Inc. 2.29 2.36 2.39 2.42 2.51 2.60 2.62 2.59 2.64 2.53 2.40 2.25 2.15 2.10 2.11 2.17 2.20
Comcast Corp. 2.04 2.04 2.08 2.12 2.13 2.19 2.26 2.27 2.23 2.15 2.15 2.07 1.99 1.99 2.07 2.15 2.24 2.25
Meta Platforms Inc. 1.44 1.40 1.38 1.37 1.39 1.47 1.60 1.77 1.94 2.04 2.09 2.06 1.98 1.88 1.87 1.93 1.98 2.00
Netflix Inc. 23.27 22.61 21.85 21.83 22.58 22.61 22.93 22.78 21.97 22.44 23.47 24.91 25.99 26.03 28.76 30.09 32.90 35.66

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

1 Q1 2024 Calculation
Net fixed asset turnover = (RevenuesQ1 2024 + RevenuesQ4 2023 + RevenuesQ3 2023 + RevenuesQ2 2023) ÷ Parks, resorts and other property, net
= (23,549 + 21,241 + 22,330 + 21,815) ÷ 35,321 = 2.52

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. Walt Disney Co. net fixed asset turnover ratio improved from Q3 2023 to Q4 2023 but then deteriorated significantly from Q4 2023 to Q1 2024.

Total Asset Turnover

Walt Disney Co., total asset turnover calculation (quarterly data)

Microsoft Excel
Dec 30, 2023 Sep 30, 2023 Jul 1, 2023 Apr 1, 2023 Dec 31, 2022 Oct 1, 2022 Jul 2, 2022 Apr 2, 2022 Jan 1, 2022 Oct 2, 2021 Jul 3, 2021 Apr 3, 2021 Jan 2, 2021 Oct 3, 2020 Jun 27, 2020 Mar 28, 2020 Dec 28, 2019 Sep 28, 2019 Jun 29, 2019 Mar 30, 2019 Dec 29, 2018 Sep 29, 2018 Jun 30, 2018 Mar 31, 2018 Dec 30, 2017
Selected Financial Data (US$ in millions)
Revenues 23,549 21,241 22,330 21,815 23,512 20,150 21,504 19,249 21,819 18,534 17,022 15,613 16,249 14,707 11,779 18,025 20,877 19,100 20,245 14,922 15,303 14,307 15,228 14,548 15,351
Total assets 197,774 205,579 203,783 204,858 202,124 203,631 204,074 202,453 203,311 203,609 202,221 200,250 201,888 201,549 207,649 206,294 200,948 193,984 209,475 214,342 99,941 98,598 98,792 97,943 97,734
Long-term Activity Ratio
Total asset turnover1 0.45 0.43 0.43 0.42 0.42 0.41 0.40 0.38 0.36 0.33 0.31 0.29 0.30 0.32 0.34 0.38 0.37 0.36 0.31 0.28 0.59 0.60
Benchmarks
Total Asset Turnover, Competitors2
Alphabet Inc. 0.76 0.75 0.76 0.77 0.77 0.79 0.78 0.76 0.72 0.69 0.66 0.60 0.57 0.57 0.60 0.61 0.59
Comcast Corp. 0.46 0.46 0.46 0.46 0.46 0.47 0.48 0.46 0.44 0.42 0.41 0.39 0.37 0.38 0.39 0.40 0.41 0.41
Meta Platforms Inc. 0.64 0.59 0.59 0.58 0.64 0.63 0.66 0.70 0.73 0.71 0.66 0.61 0.58 0.54 0.54 0.54 0.53 0.53
Netflix Inc. 0.72 0.69 0.66 0.63 0.64 0.65 0.66 0.67 0.67 0.67 0.67 0.67 0.66 0.64 0.62 0.61 0.61 0.59

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

1 Q1 2024 Calculation
Total asset turnover = (RevenuesQ1 2024 + RevenuesQ4 2023 + RevenuesQ3 2023 + RevenuesQ2 2023) ÷ Total assets
= (23,549 + 21,241 + 22,330 + 21,815) ÷ 197,774 = 0.45

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. Walt Disney Co. total asset turnover ratio improved from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.

Equity Turnover

Walt Disney Co., equity turnover calculation (quarterly data)

Microsoft Excel
Dec 30, 2023 Sep 30, 2023 Jul 1, 2023 Apr 1, 2023 Dec 31, 2022 Oct 1, 2022 Jul 2, 2022 Apr 2, 2022 Jan 1, 2022 Oct 2, 2021 Jul 3, 2021 Apr 3, 2021 Jan 2, 2021 Oct 3, 2020 Jun 27, 2020 Mar 28, 2020 Dec 28, 2019 Sep 28, 2019 Jun 29, 2019 Mar 30, 2019 Dec 29, 2018 Sep 29, 2018 Jun 30, 2018 Mar 31, 2018 Dec 30, 2017
Selected Financial Data (US$ in millions)
Revenues 23,549 21,241 22,330 21,815 23,512 20,150 21,504 19,249 21,819 18,534 17,022 15,613 16,249 14,707 11,779 18,025 20,877 19,100 20,245 14,922 15,303 14,307 15,228 14,548 15,351
Total Disney Shareholders’ equity 100,721 99,277 97,610 97,859 96,149 95,008 92,500 90,636 89,864 88,553 86,741 85,540 84,071 83,583 85,866 90,407 89,757 88,877 90,472 89,938 50,316 48,773 46,088 45,151 43,289
Long-term Activity Ratio
Equity turnover1 0.88 0.90 0.90 0.89 0.88 0.87 0.88 0.85 0.81 0.76 0.73 0.68 0.72 0.78 0.81 0.87 0.84 0.78 0.72 0.66 1.18 1.22
Benchmarks
Equity Turnover, Competitors2
Alphabet Inc. 1.08 1.09 1.08 1.09 1.10 1.11 1.09 1.06 1.02 0.98 0.93 0.86 0.82 0.81 0.80 0.82 0.80
Comcast Corp. 1.48 1.47 1.46 1.43 1.46 1.50 1.51 1.33 1.27 1.21 1.19 1.15 1.13 1.15 1.21 1.26 1.33 1.32
Meta Platforms Inc. 0.95 0.88 0.89 0.90 0.94 0.93 0.95 0.95 0.97 0.94 0.84 0.76 0.71 0.67 0.67 0.68 0.70 0.70
Netflix Inc. 1.63 1.64 1.48 1.41 1.46 1.52 1.53 1.63 1.73 1.87 1.87 1.99 2.05 2.26 2.31 2.42 2.55 2.66

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

1 Q1 2024 Calculation
Equity turnover = (RevenuesQ1 2024 + RevenuesQ4 2023 + RevenuesQ3 2023 + RevenuesQ2 2023) ÷ Total Disney Shareholders’ equity
= (23,549 + 21,241 + 22,330 + 21,815) ÷ 100,721 = 0.88

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. Walt Disney Co. equity turnover ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.