Stock Analysis on Net

Walt Disney Co. (NYSE:DIS)

Analysis of Geographic Areas 

Microsoft Excel

Area Profit Margin

Walt Disney Co., profit margin by geographic area

Microsoft Excel
Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018 Sep 30, 2017 Oct 1, 2016
Americas 11.66% 11.19% 19.10% 25.42% 26.05% 28.38%
Europe 11.96% 17.36% 30.39% 27.36% 27.70% 27.03%
Asia Pacific 9.92% 16.76% 27.80% 33.79% 32.04% 28.90%

Based on: 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), 10-K (reporting date: 2017-09-30), 10-K (reporting date: 2016-10-01).

Area profitability ratio Geographic area The company
Area profit margin Americas Americas area profit margin ratio deteriorated from 2019 to 2020 but then slightly improved from 2020 to 2021.
Europe Europe area profit margin ratio deteriorated from 2019 to 2020 and from 2020 to 2021.
Asia Pacific Asia Pacific area profit margin ratio deteriorated from 2019 to 2020 and from 2020 to 2021.

Area Profit Margin: Americas

Walt Disney Co.; Americas; area profit margin calculation

Microsoft Excel
Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018 Sep 30, 2017 Oct 1, 2016
Selected Financial Data (US$ in millions)
Segment operating income 6,314  5,819  10,268  11,915  11,337  12,582 
Revenues 54,157  51,992  53,768  46,877  43,521  44,336 
Area Profitability Ratio
Area profit margin1 11.66% 11.19% 19.10% 25.42% 26.05% 28.38%

Based on: 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), 10-K (reporting date: 2017-09-30), 10-K (reporting date: 2016-10-01).

1 2021 Calculation
Area profit margin = 100 × Segment operating income ÷ Revenues
= 100 × 6,314 ÷ 54,157 = 11.66%

Area profitability ratio Geographic area The company
Area profit margin Americas Americas area profit margin ratio deteriorated from 2019 to 2020 but then slightly improved from 2020 to 2021.

Area Profit Margin: Europe

Walt Disney Co.; Europe; area profit margin calculation

Microsoft Excel
Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018 Sep 30, 2017 Oct 1, 2016
Selected Financial Data (US$ in millions)
Segment operating income 800  1,273  2,433  1,922  1,812  1,815 
Revenues 6,690  7,333  8,006  7,026  6,541  6,714 
Area Profitability Ratio
Area profit margin1 11.96% 17.36% 30.39% 27.36% 27.70% 27.03%

Based on: 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), 10-K (reporting date: 2017-09-30), 10-K (reporting date: 2016-10-01).

1 2021 Calculation
Area profit margin = 100 × Segment operating income ÷ Revenues
= 100 × 800 ÷ 6,690 = 11.96%

Area profitability ratio Geographic area The company
Area profit margin Europe Europe area profit margin ratio deteriorated from 2019 to 2020 and from 2020 to 2021.

Area Profit Margin: Asia Pacific

Walt Disney Co.; Asia Pacific; area profit margin calculation

Microsoft Excel
Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018 Sep 30, 2017 Oct 1, 2016
Selected Financial Data (US$ in millions)
Segment operating income 652  1,016  2,167  1,869  1,626  1,324 
Revenues 6,571  6,063  7,796  5,531  5,075  4,582 
Area Profitability Ratio
Area profit margin1 9.92% 16.76% 27.80% 33.79% 32.04% 28.90%

Based on: 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), 10-K (reporting date: 2017-09-30), 10-K (reporting date: 2016-10-01).

1 2021 Calculation
Area profit margin = 100 × Segment operating income ÷ Revenues
= 100 × 652 ÷ 6,571 = 9.92%

Area profitability ratio Geographic area The company
Area profit margin Asia Pacific Asia Pacific area profit margin ratio deteriorated from 2019 to 2020 and from 2020 to 2021.

Area Return on Assets (Area ROA)

Walt Disney Co., ROA by geographic area

Microsoft Excel
Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018 Sep 30, 2017 Oct 1, 2016
Americas 4.36% 4.11% 7.40% 18.23% 18.47% 22.23%
Europe 9.74% 16.59% 22.54% 30.63% 22.08% 22.34%
Asia Pacific 5.43% 8.30% 17.06% 24.04% 19.84% 16.09%

Based on: 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), 10-K (reporting date: 2017-09-30), 10-K (reporting date: 2016-10-01).

Area profitability ratio Geographic area The company
Area ROA Americas Americas area ROA deteriorated from 2019 to 2020 but then slightly improved from 2020 to 2021.
Europe Europe area ROA deteriorated from 2019 to 2020 and from 2020 to 2021.
Asia Pacific Asia Pacific area ROA deteriorated from 2019 to 2020 and from 2020 to 2021.

Area ROA: Americas

Walt Disney Co.; Americas; area ROA calculation

Microsoft Excel
Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018 Sep 30, 2017 Oct 1, 2016
Selected Financial Data (US$ in millions)
Segment operating income 6,314  5,819  10,268  11,915  11,337  12,582 
Long-lived assets 144,788  141,674  138,674  65,376  61,370  56,598 
Area Profitability Ratio
Area ROA1 4.36% 4.11% 7.40% 18.23% 18.47% 22.23%

Based on: 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), 10-K (reporting date: 2017-09-30), 10-K (reporting date: 2016-10-01).

1 2021 Calculation
Area ROA = 100 × Segment operating income ÷ Long-lived assets
= 100 × 6,314 ÷ 144,788 = 4.36%

Area profitability ratio Geographic area The company
Area ROA Americas Americas area ROA deteriorated from 2019 to 2020 but then slightly improved from 2020 to 2021.

Area ROA: Europe

Walt Disney Co.; Europe; area ROA calculation

Microsoft Excel
Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018 Sep 30, 2017 Oct 1, 2016
Selected Financial Data (US$ in millions)
Segment operating income 800  1,273  2,433  1,922  1,812  1,815 
Long-lived assets 8,215  7,672  10,793  6,275  8,208  8,125 
Area Profitability Ratio
Area ROA1 9.74% 16.59% 22.54% 30.63% 22.08% 22.34%

Based on: 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), 10-K (reporting date: 2017-09-30), 10-K (reporting date: 2016-10-01).

1 2021 Calculation
Area ROA = 100 × Segment operating income ÷ Long-lived assets
= 100 × 800 ÷ 8,215 = 9.74%

Area profitability ratio Geographic area The company
Area ROA Europe Europe area ROA deteriorated from 2019 to 2020 and from 2020 to 2021.

Area ROA: Asia Pacific

Walt Disney Co.; Asia Pacific; area ROA calculation

Microsoft Excel
Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018 Sep 30, 2017 Oct 1, 2016
Selected Financial Data (US$ in millions)
Segment operating income 652  1,016  2,167  1,869  1,626  1,324 
Long-lived assets 12,012  12,235  12,703  7,775  8,196  8,228 
Area Profitability Ratio
Area ROA1 5.43% 8.30% 17.06% 24.04% 19.84% 16.09%

Based on: 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), 10-K (reporting date: 2017-09-30), 10-K (reporting date: 2016-10-01).

1 2021 Calculation
Area ROA = 100 × Segment operating income ÷ Long-lived assets
= 100 × 652 ÷ 12,012 = 5.43%

Area profitability ratio Geographic area The company
Area ROA Asia Pacific Asia Pacific area ROA deteriorated from 2019 to 2020 and from 2020 to 2021.

Area Asset Turnover

Walt Disney Co., asset turnover by geographic area

Microsoft Excel
Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018 Sep 30, 2017 Oct 1, 2016
Americas 0.37 0.37 0.39 0.72 0.71 0.78
Europe 0.81 0.96 0.74 1.12 0.80 0.83
Asia Pacific 0.55 0.50 0.61 0.71 0.62 0.56

Based on: 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), 10-K (reporting date: 2017-09-30), 10-K (reporting date: 2016-10-01).

Area activity ratio Geographic area The company
Area asset turnover Americas Americas area asset turnover ratio deteriorated from 2019 to 2020 but then slightly improved from 2020 to 2021.
Europe Europe area asset turnover ratio improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021 not reaching 2019 level.
Asia Pacific Asia Pacific area asset turnover ratio deteriorated from 2019 to 2020 but then slightly improved from 2020 to 2021.

Area Asset Turnover: Americas

Walt Disney Co.; Americas; area asset turnover calculation

Microsoft Excel
Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018 Sep 30, 2017 Oct 1, 2016
Selected Financial Data (US$ in millions)
Revenues 54,157  51,992  53,768  46,877  43,521  44,336 
Long-lived assets 144,788  141,674  138,674  65,376  61,370  56,598 
Area Activity Ratio
Area asset turnover1 0.37 0.37 0.39 0.72 0.71 0.78

Based on: 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), 10-K (reporting date: 2017-09-30), 10-K (reporting date: 2016-10-01).

1 2021 Calculation
Area asset turnover = Revenues ÷ Long-lived assets
= 54,157 ÷ 144,788 = 0.37

Area activity ratio Geographic area The company
Area asset turnover Americas Americas area asset turnover ratio deteriorated from 2019 to 2020 but then slightly improved from 2020 to 2021.

Area Asset Turnover: Europe

Walt Disney Co.; Europe; area asset turnover calculation

Microsoft Excel
Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018 Sep 30, 2017 Oct 1, 2016
Selected Financial Data (US$ in millions)
Revenues 6,690  7,333  8,006  7,026  6,541  6,714 
Long-lived assets 8,215  7,672  10,793  6,275  8,208  8,125 
Area Activity Ratio
Area asset turnover1 0.81 0.96 0.74 1.12 0.80 0.83

Based on: 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), 10-K (reporting date: 2017-09-30), 10-K (reporting date: 2016-10-01).

1 2021 Calculation
Area asset turnover = Revenues ÷ Long-lived assets
= 6,690 ÷ 8,215 = 0.81

Area activity ratio Geographic area The company
Area asset turnover Europe Europe area asset turnover ratio improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021 not reaching 2019 level.

Area Asset Turnover: Asia Pacific

Walt Disney Co.; Asia Pacific; area asset turnover calculation

Microsoft Excel
Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018 Sep 30, 2017 Oct 1, 2016
Selected Financial Data (US$ in millions)
Revenues 6,571  6,063  7,796  5,531  5,075  4,582 
Long-lived assets 12,012  12,235  12,703  7,775  8,196  8,228 
Area Activity Ratio
Area asset turnover1 0.55 0.50 0.61 0.71 0.62 0.56

Based on: 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), 10-K (reporting date: 2017-09-30), 10-K (reporting date: 2016-10-01).

1 2021 Calculation
Area asset turnover = Revenues ÷ Long-lived assets
= 6,571 ÷ 12,012 = 0.55

Area activity ratio Geographic area The company
Area asset turnover Asia Pacific Asia Pacific area asset turnover ratio deteriorated from 2019 to 2020 but then slightly improved from 2020 to 2021.

Revenues

Walt Disney Co., revenues by geographic area

US$ in millions

Microsoft Excel
Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018 Sep 30, 2017 Oct 1, 2016
Americas 54,157  51,992  53,768  46,877  43,521  44,336 
Europe 6,690  7,333  8,006  7,026  6,541  6,714 
Asia Pacific 6,571  6,063  7,796  5,531  5,075  4,582 
Total 67,418  65,388  69,570  59,434  55,137  55,632 

Based on: 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), 10-K (reporting date: 2017-09-30), 10-K (reporting date: 2016-10-01).


Segment operating income

Walt Disney Co., segment operating income by geographic area

US$ in millions

Microsoft Excel
Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018 Sep 30, 2017 Oct 1, 2016
Americas 6,314  5,819  10,268  11,915  11,337  12,582 
Europe 800  1,273  2,433  1,922  1,812  1,815 
Asia Pacific 652  1,016  2,167  1,869  1,626  1,324 
Total 7,766  8,108  14,868  15,706  14,775  15,721 

Based on: 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), 10-K (reporting date: 2017-09-30), 10-K (reporting date: 2016-10-01).


Long-lived assets

Walt Disney Co., long-lived assets by geographic area

US$ in millions

Microsoft Excel
Oct 2, 2021 Oct 3, 2020 Sep 28, 2019 Sep 29, 2018 Sep 30, 2017 Oct 1, 2016
Americas 144,788  141,674  138,674  65,376  61,370  56,598 
Europe 8,215  7,672  10,793  6,275  8,208  8,125 
Asia Pacific 12,012  12,235  12,703  7,775  8,196  8,228 
Total 165,015  161,581  162,170  79,426  77,774  72,951 

Based on: 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), 10-K (reporting date: 2017-09-30), 10-K (reporting date: 2016-10-01).