Stock Analysis on Net

Walt Disney Co. (NYSE:DIS)

Analysis of Reportable Segments

Microsoft Excel

Segment Profit Margin

Walt Disney Co., profit margin by reportable segment

Microsoft Excel
Sep 30, 2023 Oct 1, 2022 Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018
Entertainment 3.55% 5.37% 14.24%
Sports 14.41% 15.69% 16.85%
Experiences 27.51% 25.94% -0.75%

Based on: 10-K (reporting date: 2023-09-30), 10-K (reporting date: 2022-10-01), 10-K (reporting date: 2021-10-02), 10-K (reporting date: 2020-10-03), 10-K (reporting date: 2019-09-28), 10-K (reporting date: 2018-09-29).

Segment profitability ratio Reportable segment The company
Segment profit margin Entertainment Entertainment segment profit margin ratio deteriorated from 2021 to 2022 and from 2022 to 2023.
Sports Sports segment profit margin ratio deteriorated from 2021 to 2022 and from 2022 to 2023.
Experiences Experiences segment profit margin ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Profit Margin: Entertainment

Walt Disney Co.; Entertainment; segment profit margin calculation

Microsoft Excel
Sep 30, 2023 Oct 1, 2022 Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018
Selected Financial Data (US$ in millions)
Segment operating income 1,444 2,126 5,196
Revenues 40,635 39,569 36,489
Segment Profitability Ratio
Segment profit margin1 3.55% 5.37% 14.24%

Based on: 10-K (reporting date: 2023-09-30), 10-K (reporting date: 2022-10-01), 10-K (reporting date: 2021-10-02), 10-K (reporting date: 2020-10-03), 10-K (reporting date: 2019-09-28), 10-K (reporting date: 2018-09-29).

1 2023 Calculation
Segment profit margin = 100 × Segment operating income ÷ Revenues
= 100 × 1,444 ÷ 40,635 = 3.55%

Segment profitability ratio Reportable segment The company
Segment profit margin Entertainment Entertainment segment profit margin ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment Profit Margin: Sports

Walt Disney Co.; Sports; segment profit margin calculation

Microsoft Excel
Sep 30, 2023 Oct 1, 2022 Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018
Selected Financial Data (US$ in millions)
Segment operating income 2,465 2,710 2,690
Revenues 17,111 17,270 15,960
Segment Profitability Ratio
Segment profit margin1 14.41% 15.69% 16.85%

Based on: 10-K (reporting date: 2023-09-30), 10-K (reporting date: 2022-10-01), 10-K (reporting date: 2021-10-02), 10-K (reporting date: 2020-10-03), 10-K (reporting date: 2019-09-28), 10-K (reporting date: 2018-09-29).

1 2023 Calculation
Segment profit margin = 100 × Segment operating income ÷ Revenues
= 100 × 2,465 ÷ 17,111 = 14.41%

Segment profitability ratio Reportable segment The company
Segment profit margin Sports Sports segment profit margin ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment Profit Margin: Experiences

Walt Disney Co.; Experiences; segment profit margin calculation

Microsoft Excel
Sep 30, 2023 Oct 1, 2022 Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018
Selected Financial Data (US$ in millions)
Segment operating income 8,954 7,285 (120)
Revenues 32,549 28,085 15,961
Segment Profitability Ratio
Segment profit margin1 27.51% 25.94% -0.75%

Based on: 10-K (reporting date: 2023-09-30), 10-K (reporting date: 2022-10-01), 10-K (reporting date: 2021-10-02), 10-K (reporting date: 2020-10-03), 10-K (reporting date: 2019-09-28), 10-K (reporting date: 2018-09-29).

1 2023 Calculation
Segment profit margin = 100 × Segment operating income ÷ Revenues
= 100 × 8,954 ÷ 32,549 = 27.51%

Segment profitability ratio Reportable segment The company
Segment profit margin Experiences Experiences segment profit margin ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Return on Assets (Segment ROA)

Walt Disney Co., ROA by reportable segment

Microsoft Excel
Sep 30, 2023 Oct 1, 2022 Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018
Entertainment 1.27% 1.81% 4.43%
Sports 9.70% 10.85% 10.77%
Experiences 20.92% 17.36% -0.29%

Based on: 10-K (reporting date: 2023-09-30), 10-K (reporting date: 2022-10-01), 10-K (reporting date: 2021-10-02), 10-K (reporting date: 2020-10-03), 10-K (reporting date: 2019-09-28), 10-K (reporting date: 2018-09-29).

Segment profitability ratio Reportable segment The company
Segment ROA Entertainment Entertainment segment ROA deteriorated from 2021 to 2022 and from 2022 to 2023.
Sports Sports segment ROA improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.
Experiences Experiences segment ROA improved from 2021 to 2022 and from 2022 to 2023.

Segment ROA: Entertainment

Walt Disney Co.; Entertainment; segment ROA calculation

Microsoft Excel
Sep 30, 2023 Oct 1, 2022 Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018
Selected Financial Data (US$ in millions)
Segment operating income 1,444 2,126 5,196
Identifiable assets 113,307 117,184 117,184
Segment Profitability Ratio
Segment ROA1 1.27% 1.81% 4.43%

Based on: 10-K (reporting date: 2023-09-30), 10-K (reporting date: 2022-10-01), 10-K (reporting date: 2021-10-02), 10-K (reporting date: 2020-10-03), 10-K (reporting date: 2019-09-28), 10-K (reporting date: 2018-09-29).

1 2023 Calculation
Segment ROA = 100 × Segment operating income ÷ Identifiable assets
= 100 × 1,444 ÷ 113,307 = 1.27%

Segment profitability ratio Reportable segment The company
Segment ROA Entertainment Entertainment segment ROA deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment ROA: Sports

Walt Disney Co.; Sports; segment ROA calculation

Microsoft Excel
Sep 30, 2023 Oct 1, 2022 Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018
Selected Financial Data (US$ in millions)
Segment operating income 2,465 2,710 2,690
Identifiable assets 25,402 24,988 24,988
Segment Profitability Ratio
Segment ROA1 9.70% 10.85% 10.77%

Based on: 10-K (reporting date: 2023-09-30), 10-K (reporting date: 2022-10-01), 10-K (reporting date: 2021-10-02), 10-K (reporting date: 2020-10-03), 10-K (reporting date: 2019-09-28), 10-K (reporting date: 2018-09-29).

1 2023 Calculation
Segment ROA = 100 × Segment operating income ÷ Identifiable assets
= 100 × 2,465 ÷ 25,402 = 9.70%

Segment profitability ratio Reportable segment The company
Segment ROA Sports Sports segment ROA improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Segment ROA: Experiences

Walt Disney Co.; Experiences; segment ROA calculation

Microsoft Excel
Sep 30, 2023 Oct 1, 2022 Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018
Selected Financial Data (US$ in millions)
Segment operating income 8,954 7,285 (120)
Identifiable assets 42,808 41,969 41,969
Segment Profitability Ratio
Segment ROA1 20.92% 17.36% -0.29%

Based on: 10-K (reporting date: 2023-09-30), 10-K (reporting date: 2022-10-01), 10-K (reporting date: 2021-10-02), 10-K (reporting date: 2020-10-03), 10-K (reporting date: 2019-09-28), 10-K (reporting date: 2018-09-29).

1 2023 Calculation
Segment ROA = 100 × Segment operating income ÷ Identifiable assets
= 100 × 8,954 ÷ 42,808 = 20.92%

Segment profitability ratio Reportable segment The company
Segment ROA Experiences Experiences segment ROA improved from 2021 to 2022 and from 2022 to 2023.

Segment Asset Turnover

Walt Disney Co., asset turnover by reportable segment

Microsoft Excel
Sep 30, 2023 Oct 1, 2022 Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018
Entertainment 0.36 0.34 0.31
Sports 0.67 0.69 0.64
Experiences 0.76 0.67 0.38

Based on: 10-K (reporting date: 2023-09-30), 10-K (reporting date: 2022-10-01), 10-K (reporting date: 2021-10-02), 10-K (reporting date: 2020-10-03), 10-K (reporting date: 2019-09-28), 10-K (reporting date: 2018-09-29).

Segment activity ratio Reportable segment The company
Segment asset turnover Entertainment Entertainment segment asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.
Sports Sports segment asset turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.
Experiences Experiences segment asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Asset Turnover: Entertainment

Walt Disney Co.; Entertainment; segment asset turnover calculation

Microsoft Excel
Sep 30, 2023 Oct 1, 2022 Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018
Selected Financial Data (US$ in millions)
Revenues 40,635 39,569 36,489
Identifiable assets 113,307 117,184 117,184
Segment Activity Ratio
Segment asset turnover1 0.36 0.34 0.31

Based on: 10-K (reporting date: 2023-09-30), 10-K (reporting date: 2022-10-01), 10-K (reporting date: 2021-10-02), 10-K (reporting date: 2020-10-03), 10-K (reporting date: 2019-09-28), 10-K (reporting date: 2018-09-29).

1 2023 Calculation
Segment asset turnover = Revenues ÷ Identifiable assets
= 40,635 ÷ 113,307 = 0.36

Segment activity ratio Reportable segment The company
Segment asset turnover Entertainment Entertainment segment asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Asset Turnover: Sports

Walt Disney Co.; Sports; segment asset turnover calculation

Microsoft Excel
Sep 30, 2023 Oct 1, 2022 Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018
Selected Financial Data (US$ in millions)
Revenues 17,111 17,270 15,960
Identifiable assets 25,402 24,988 24,988
Segment Activity Ratio
Segment asset turnover1 0.67 0.69 0.64

Based on: 10-K (reporting date: 2023-09-30), 10-K (reporting date: 2022-10-01), 10-K (reporting date: 2021-10-02), 10-K (reporting date: 2020-10-03), 10-K (reporting date: 2019-09-28), 10-K (reporting date: 2018-09-29).

1 2023 Calculation
Segment asset turnover = Revenues ÷ Identifiable assets
= 17,111 ÷ 25,402 = 0.67

Segment activity ratio Reportable segment The company
Segment asset turnover Sports Sports segment asset turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.

Segment Asset Turnover: Experiences

Walt Disney Co.; Experiences; segment asset turnover calculation

Microsoft Excel
Sep 30, 2023 Oct 1, 2022 Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018
Selected Financial Data (US$ in millions)
Revenues 32,549 28,085 15,961
Identifiable assets 42,808 41,969 41,969
Segment Activity Ratio
Segment asset turnover1 0.76 0.67 0.38

Based on: 10-K (reporting date: 2023-09-30), 10-K (reporting date: 2022-10-01), 10-K (reporting date: 2021-10-02), 10-K (reporting date: 2020-10-03), 10-K (reporting date: 2019-09-28), 10-K (reporting date: 2018-09-29).

1 2023 Calculation
Segment asset turnover = Revenues ÷ Identifiable assets
= 32,549 ÷ 42,808 = 0.76

Segment activity ratio Reportable segment The company
Segment asset turnover Experiences Experiences segment asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Capital Expenditures to Depreciation

Walt Disney Co., capital expenditures to depreciation by reportable segment

Microsoft Excel
Sep 30, 2023 Oct 1, 2022 Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018
Entertainment 1.54 1.43 1.63
Sports 0.21 0.09 0.24
Experiences 1.13 1.47 1.00

Based on: 10-K (reporting date: 2023-09-30), 10-K (reporting date: 2022-10-01), 10-K (reporting date: 2021-10-02), 10-K (reporting date: 2020-10-03), 10-K (reporting date: 2019-09-28), 10-K (reporting date: 2018-09-29).

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Entertainment Entertainment segment capital expenditures to depreciation ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 not reaching 2021 level.
Sports Sports segment capital expenditures to depreciation ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 not reaching 2021 level.
Experiences Experiences segment capital expenditures to depreciation ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023 not reaching 2021 level.

Segment Capital Expenditures to Depreciation: Entertainment

Walt Disney Co.; Entertainment; segment capital expenditures to depreciation calculation

Microsoft Excel
Sep 30, 2023 Oct 1, 2022 Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018
Selected Financial Data (US$ in millions)
Capital expenditures 1,032 802 838
Depreciation expense 669 560 513
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.54 1.43 1.63

Based on: 10-K (reporting date: 2023-09-30), 10-K (reporting date: 2022-10-01), 10-K (reporting date: 2021-10-02), 10-K (reporting date: 2020-10-03), 10-K (reporting date: 2019-09-28), 10-K (reporting date: 2018-09-29).

1 2023 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation expense
= 1,032 ÷ 669 = 1.54

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Entertainment Entertainment segment capital expenditures to depreciation ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 not reaching 2021 level.

Segment Capital Expenditures to Depreciation: Sports

Walt Disney Co.; Sports; segment capital expenditures to depreciation calculation

Microsoft Excel
Sep 30, 2023 Oct 1, 2022 Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018
Selected Financial Data (US$ in millions)
Capital expenditures 15 8 24
Depreciation expense 73 90 100
Segment Financial Ratio
Segment capital expenditures to depreciation1 0.21 0.09 0.24

Based on: 10-K (reporting date: 2023-09-30), 10-K (reporting date: 2022-10-01), 10-K (reporting date: 2021-10-02), 10-K (reporting date: 2020-10-03), 10-K (reporting date: 2019-09-28), 10-K (reporting date: 2018-09-29).

1 2023 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation expense
= 15 ÷ 73 = 0.21

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Sports Sports segment capital expenditures to depreciation ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 not reaching 2021 level.

Segment Capital Expenditures to Depreciation: Experiences

Walt Disney Co.; Experiences; segment capital expenditures to depreciation calculation

Microsoft Excel
Sep 30, 2023 Oct 1, 2022 Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018
Selected Financial Data (US$ in millions)
Capital expenditures 3,025 3,447 2,272
Depreciation expense 2,680 2,342 2,269
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.13 1.47 1.00

Based on: 10-K (reporting date: 2023-09-30), 10-K (reporting date: 2022-10-01), 10-K (reporting date: 2021-10-02), 10-K (reporting date: 2020-10-03), 10-K (reporting date: 2019-09-28), 10-K (reporting date: 2018-09-29).

1 2023 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation expense
= 3,025 ÷ 2,680 = 1.13

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Experiences Experiences segment capital expenditures to depreciation ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023 not reaching 2021 level.

Revenues

Walt Disney Co., revenues by reportable segment

US$ in millions

Microsoft Excel
Sep 30, 2023 Oct 1, 2022 Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018
Entertainment 40,635 39,569 36,489
Sports 17,111 17,270 15,960
Experiences 32,549 28,085 15,961
Eliminations (1,397) (1,179) (992)
Total 88,898 83,745 67,418

Based on: 10-K (reporting date: 2023-09-30), 10-K (reporting date: 2022-10-01), 10-K (reporting date: 2021-10-02), 10-K (reporting date: 2020-10-03), 10-K (reporting date: 2019-09-28), 10-K (reporting date: 2018-09-29).


Segment operating income

Walt Disney Co., segment operating income by reportable segment

US$ in millions

Microsoft Excel
Sep 30, 2023 Oct 1, 2022 Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018
Entertainment 1,444 2,126 5,196
Sports 2,465 2,710 2,690
Experiences 8,954 7,285 (120)
Total 12,863 12,121 7,766

Based on: 10-K (reporting date: 2023-09-30), 10-K (reporting date: 2022-10-01), 10-K (reporting date: 2021-10-02), 10-K (reporting date: 2020-10-03), 10-K (reporting date: 2019-09-28), 10-K (reporting date: 2018-09-29).


Capital expenditures

Walt Disney Co., capital expenditures by reportable segment

US$ in millions

Microsoft Excel
Sep 30, 2023 Oct 1, 2022 Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018
Entertainment 1,032 802 838
Sports 15 8 24
Experiences 3,025 3,447 2,272
Corporate 897 686 444
Total 4,969 4,943 3,578

Based on: 10-K (reporting date: 2023-09-30), 10-K (reporting date: 2022-10-01), 10-K (reporting date: 2021-10-02), 10-K (reporting date: 2020-10-03), 10-K (reporting date: 2019-09-28), 10-K (reporting date: 2018-09-29).


Depreciation expense

Walt Disney Co., depreciation expense by reportable segment

US$ in millions

Microsoft Excel
Sep 30, 2023 Oct 1, 2022 Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018
Entertainment 669 560 513
Sports 73 90 100
Experiences 2,680 2,342 2,269
Corporate 204 191 186
Total 3,626 3,183 3,068

Based on: 10-K (reporting date: 2023-09-30), 10-K (reporting date: 2022-10-01), 10-K (reporting date: 2021-10-02), 10-K (reporting date: 2020-10-03), 10-K (reporting date: 2019-09-28), 10-K (reporting date: 2018-09-29).


Identifiable assets

Walt Disney Co., identifiable assets by reportable segment

US$ in millions

Microsoft Excel
Sep 30, 2023 Oct 1, 2022 Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018
Entertainment 113,307 117,184 117,184
Sports 25,402 24,988 24,988
Experiences 42,808 41,969 41,969
Corporate 24,062 19,490 19,490
Total 205,579 203,631 203,631

Based on: 10-K (reporting date: 2023-09-30), 10-K (reporting date: 2022-10-01), 10-K (reporting date: 2021-10-02), 10-K (reporting date: 2020-10-03), 10-K (reporting date: 2019-09-28), 10-K (reporting date: 2018-09-29).