Stock Analysis on Net
Stock Analysis on Net

Walt Disney Co. (NYSE:DIS)

DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin 

Microsoft Excel

Decomposing ROE involves expressing net income divided by shareholders’ equity as the product of component ratios.

Two-Component Disaggregation of ROE

Walt Disney Co., decomposition of ROE

Microsoft Excel
ROE = ROA × Financial Leverage
Oct 2, 2021 2.25% = 0.98% × 2.30
Oct 3, 2020 -3.43% = -1.42% × 2.41
Sep 28, 2019 12.44% = 5.70% × 2.18
Sep 29, 2018 25.83% = 12.78% × 2.02
Sep 30, 2017 21.74% = 9.37% × 2.32
Oct 1, 2016 21.71% = 10.20% × 2.13

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

Three-Component Disaggregation of ROE

Walt Disney Co., decomposition of ROE

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Oct 2, 2021 2.25% = 2.96% × 0.33 × 2.30
Oct 3, 2020 -3.43% = -4.38% × 0.32 × 2.41
Sep 28, 2019 12.44% = 15.89% × 0.36 × 2.18
Sep 29, 2018 25.83% = 21.20% × 0.60 × 2.02
Sep 30, 2017 21.74% = 16.29% × 0.58 × 2.32
Oct 1, 2016 21.71% = 16.88% × 0.60 × 2.13

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

Five-Component Disaggregation of ROE

Walt Disney Co., decomposition of ROE

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Oct 2, 2021 2.25% = 0.99 × 0.57 × 5.29% × 0.33 × 2.30
Oct 3, 2020 -3.43% = — × — × -0.79% × 0.32 × 2.41
Sep 28, 2019 12.44% = 0.78 × 0.92 × 22.04% × 0.36 × 2.18
Sep 29, 2018 25.83% = 0.88 × 0.95 × 25.14% × 0.60 × 2.02
Sep 30, 2017 21.74% = 0.67 × 0.96 × 25.23% × 0.58 × 2.32
Oct 1, 2016 21.71% = 0.65 × 0.98 × 26.64% × 0.60 × 2.13

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

Two-Component Disaggregation of ROA

Walt Disney Co., decomposition of ROA

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Oct 2, 2021 0.98% = 2.96% × 0.33
Oct 3, 2020 -1.42% = -4.38% × 0.32
Sep 28, 2019 5.70% = 15.89% × 0.36
Sep 29, 2018 12.78% = 21.20% × 0.60
Sep 30, 2017 9.37% = 16.29% × 0.58
Oct 1, 2016 10.20% = 16.88% × 0.60

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

Four-Component Disaggregation of ROA

Walt Disney Co., decomposition of ROA

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Oct 2, 2021 0.98% = 0.99 × 0.57 × 5.29% × 0.33
Oct 3, 2020 -1.42% = — × — × -0.79% × 0.32
Sep 28, 2019 5.70% = 0.78 × 0.92 × 22.04% × 0.36
Sep 29, 2018 12.78% = 0.88 × 0.95 × 25.14% × 0.60
Sep 30, 2017 9.37% = 0.67 × 0.96 × 25.23% × 0.58
Oct 1, 2016 10.20% = 0.65 × 0.98 × 26.64% × 0.60

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

Disaggregation of Net Profit Margin

Walt Disney Co., decomposition of net profit margin ratio

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Oct 2, 2021 2.96% = 0.99 × 0.57 × 5.29%
Oct 3, 2020 -4.38% = — × — × -0.79%
Sep 28, 2019 15.89% = 0.78 × 0.92 × 22.04%
Sep 29, 2018 21.20% = 0.88 × 0.95 × 25.14%
Sep 30, 2017 16.29% = 0.67 × 0.96 × 25.23%
Oct 1, 2016 16.88% = 0.65 × 0.98 × 26.64%

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