Stock Analysis on Net

Warner Bros. Discovery Inc. (NASDAQ:WBD)

This company has been moved to the archive! The financial data has not been updated since November 4, 2022.

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

Microsoft Excel

Two-Component Disaggregation of ROE

Warner Bros. Discovery Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
Sep 30, 2022 -10.78% = -3.85% × 2.80
Jun 30, 2022 -5.39% = -1.95% × 2.77
Mar 31, 2022 11.05% = 3.91% × 2.82
Dec 31, 2021 8.67% = 2.92% × 2.97
Sep 30, 2021 10.67% = 3.61% × 2.96
Jun 30, 2021 11.99% = 4.00% × 3.00
Mar 31, 2021 9.08% = 2.92% × 3.11
Dec 31, 2020 11.65% = 3.58% × 3.26
Sep 30, 2020 14.12% = 4.26% × 3.31
Jun 30, 2020 14.05% = 4.19% × 3.35
Mar 31, 2020 21.77% = 6.18% × 3.53
Dec 31, 2019 20.92% = 6.13% × 3.41
Sep 30, 2019 19.56% = 5.67% × 3.45
Jun 30, 2019 17.85% = 5.07% × 3.52
Mar 31, 2019 11.32% = 3.04% × 3.73
Dec 31, 2018 7.08% = 1.82% × 3.88
Sep 30, 2018 -10.09% = -2.49% × 4.06
Jun 30, 2018 -9.05% = -2.14% × 4.22
Mar 31, 2018 -7.10% = -1.62% × 4.39
Dec 31, 2017 -7.31% = -1.49% × 4.89
Sep 30, 2017 = × 4.03
Jun 30, 2017 = × 2.92
Mar 31, 2017 = × 2.97

Based on: 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).


Three-Component Disaggregation of ROE

Warner Bros. Discovery Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Sep 30, 2022 -10.78% = -20.13% × 0.19 × 2.80
Jun 30, 2022 -5.39% = -14.32% × 0.14 × 2.77
Mar 31, 2022 11.05% = 10.53% × 0.37 × 2.82
Dec 31, 2021 8.67% = 8.25% × 0.35 × 2.97
Sep 30, 2021 10.67% = 10.42% × 0.35 × 2.96
Jun 30, 2021 11.99% = 12.24% × 0.33 × 3.00
Mar 31, 2021 9.08% = 9.11% × 0.32 × 3.11
Dec 31, 2020 11.65% = 11.42% × 0.31 × 3.26
Sep 30, 2020 14.12% = 13.36% × 0.32 × 3.31
Jun 30, 2020 14.05% = 12.86% × 0.33 × 3.35
Mar 31, 2020 21.77% = 18.54% × 0.33 × 3.53
Dec 31, 2019 20.92% = 18.57% × 0.33 × 3.41
Sep 30, 2019 19.56% = 16.81% × 0.34 × 3.45
Jun 30, 2019 17.85% = 15.62% × 0.32 × 3.52
Mar 31, 2019 11.32% = 9.00% × 0.34 × 3.73
Dec 31, 2018 7.08% = 5.63% × 0.32 × 3.88
Sep 30, 2018 -10.09% = -8.52% × 0.29 × 4.06
Jun 30, 2018 -9.05% = -8.28% × 0.26 × 4.22
Mar 31, 2018 -7.10% = -7.40% × 0.22 × 4.39
Dec 31, 2017 -7.31% = -4.90% × 0.30 × 4.89
Sep 30, 2017 = × × 4.03
Jun 30, 2017 = × × 2.92
Mar 31, 2017 = × × 2.97

Based on: 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).


Five-Component Disaggregation of ROE

Warner Bros. Discovery Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Sep 30, 2022 -10.78% = × × -19.11% × 0.19 × 2.80
Jun 30, 2022 -5.39% = × × -11.89% × 0.14 × 2.77
Mar 31, 2022 11.05% = 0.80 × 0.73 × 18.12% × 0.37 × 2.82
Dec 31, 2021 8.67% = 0.81 × 0.66 × 15.38% × 0.35 × 2.97
Sep 30, 2021 10.67% = 0.84 × 0.70 × 17.86% × 0.35 × 2.96
Jun 30, 2021 11.99% = 0.88 × 0.71 × 19.66% × 0.33 × 3.00
Mar 31, 2021 9.08% = 0.74 × 0.67 × 18.36% × 0.32 × 3.11
Dec 31, 2020 11.65% = 0.77 × 0.71 × 20.99% × 0.31 × 3.26
Sep 30, 2020 14.12% = 0.81 × 0.73 × 22.58% × 0.32 × 3.31
Jun 30, 2020 14.05% = 0.74 × 0.74 × 23.47% × 0.33 × 3.35
Mar 31, 2020 21.77% = 0.97 × 0.76 × 24.98% × 0.33 × 3.53
Dec 31, 2019 20.92% = 0.96 × 0.76 × 25.37% × 0.33 × 3.41
Sep 30, 2019 19.56% = 0.89 × 0.75 × 24.94% × 0.34 × 3.45
Jun 30, 2019 17.85% = 0.93 × 0.72 × 23.07% × 0.32 × 3.52
Mar 31, 2019 11.32% = 0.66 × 0.67 × 20.40% × 0.34 × 3.73
Dec 31, 2018 7.08% = 0.64 × 0.56 × 15.77% × 0.32 × 3.88
Sep 30, 2018 -10.09% = × -4.54 × 1.34% × 0.29 × 4.06
Jun 30, 2018 -9.05% = × -7.43 × 0.91% × 0.26 × 4.22
Mar 31, 2018 -7.10% = × -4.50 × 1.35% × 0.22 × 4.39
Dec 31, 2017 -7.31% = × -0.51 × 4.57% × 0.30 × 4.89
Sep 30, 2017 = × × × × 4.03
Jun 30, 2017 = × × × × 2.92
Mar 31, 2017 = × × × × 2.97

Based on: 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).


Two-Component Disaggregation of ROA

Warner Bros. Discovery Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Sep 30, 2022 -3.85% = -20.13% × 0.19
Jun 30, 2022 -1.95% = -14.32% × 0.14
Mar 31, 2022 3.91% = 10.53% × 0.37
Dec 31, 2021 2.92% = 8.25% × 0.35
Sep 30, 2021 3.61% = 10.42% × 0.35
Jun 30, 2021 4.00% = 12.24% × 0.33
Mar 31, 2021 2.92% = 9.11% × 0.32
Dec 31, 2020 3.58% = 11.42% × 0.31
Sep 30, 2020 4.26% = 13.36% × 0.32
Jun 30, 2020 4.19% = 12.86% × 0.33
Mar 31, 2020 6.18% = 18.54% × 0.33
Dec 31, 2019 6.13% = 18.57% × 0.33
Sep 30, 2019 5.67% = 16.81% × 0.34
Jun 30, 2019 5.07% = 15.62% × 0.32
Mar 31, 2019 3.04% = 9.00% × 0.34
Dec 31, 2018 1.82% = 5.63% × 0.32
Sep 30, 2018 -2.49% = -8.52% × 0.29
Jun 30, 2018 -2.14% = -8.28% × 0.26
Mar 31, 2018 -1.62% = -7.40% × 0.22
Dec 31, 2017 -1.49% = -4.90% × 0.30
Sep 30, 2017 = ×
Jun 30, 2017 = ×
Mar 31, 2017 = ×

Based on: 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).


Four-Component Disaggregation of ROA

Warner Bros. Discovery Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Sep 30, 2022 -3.85% = × × -19.11% × 0.19
Jun 30, 2022 -1.95% = × × -11.89% × 0.14
Mar 31, 2022 3.91% = 0.80 × 0.73 × 18.12% × 0.37
Dec 31, 2021 2.92% = 0.81 × 0.66 × 15.38% × 0.35
Sep 30, 2021 3.61% = 0.84 × 0.70 × 17.86% × 0.35
Jun 30, 2021 4.00% = 0.88 × 0.71 × 19.66% × 0.33
Mar 31, 2021 2.92% = 0.74 × 0.67 × 18.36% × 0.32
Dec 31, 2020 3.58% = 0.77 × 0.71 × 20.99% × 0.31
Sep 30, 2020 4.26% = 0.81 × 0.73 × 22.58% × 0.32
Jun 30, 2020 4.19% = 0.74 × 0.74 × 23.47% × 0.33
Mar 31, 2020 6.18% = 0.97 × 0.76 × 24.98% × 0.33
Dec 31, 2019 6.13% = 0.96 × 0.76 × 25.37% × 0.33
Sep 30, 2019 5.67% = 0.89 × 0.75 × 24.94% × 0.34
Jun 30, 2019 5.07% = 0.93 × 0.72 × 23.07% × 0.32
Mar 31, 2019 3.04% = 0.66 × 0.67 × 20.40% × 0.34
Dec 31, 2018 1.82% = 0.64 × 0.56 × 15.77% × 0.32
Sep 30, 2018 -2.49% = × -4.54 × 1.34% × 0.29
Jun 30, 2018 -2.14% = × -7.43 × 0.91% × 0.26
Mar 31, 2018 -1.62% = × -4.50 × 1.35% × 0.22
Dec 31, 2017 -1.49% = × -0.51 × 4.57% × 0.30
Sep 30, 2017 = × × ×
Jun 30, 2017 = × × ×
Mar 31, 2017 = × × ×

Based on: 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).


Disaggregation of Net Profit Margin

Warner Bros. Discovery Inc., decomposition of net profit margin ratio (quarterly data)

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Sep 30, 2022 -20.13% = × × -19.11%
Jun 30, 2022 -14.32% = × × -11.89%
Mar 31, 2022 10.53% = 0.80 × 0.73 × 18.12%
Dec 31, 2021 8.25% = 0.81 × 0.66 × 15.38%
Sep 30, 2021 10.42% = 0.84 × 0.70 × 17.86%
Jun 30, 2021 12.24% = 0.88 × 0.71 × 19.66%
Mar 31, 2021 9.11% = 0.74 × 0.67 × 18.36%
Dec 31, 2020 11.42% = 0.77 × 0.71 × 20.99%
Sep 30, 2020 13.36% = 0.81 × 0.73 × 22.58%
Jun 30, 2020 12.86% = 0.74 × 0.74 × 23.47%
Mar 31, 2020 18.54% = 0.97 × 0.76 × 24.98%
Dec 31, 2019 18.57% = 0.96 × 0.76 × 25.37%
Sep 30, 2019 16.81% = 0.89 × 0.75 × 24.94%
Jun 30, 2019 15.62% = 0.93 × 0.72 × 23.07%
Mar 31, 2019 9.00% = 0.66 × 0.67 × 20.40%
Dec 31, 2018 5.63% = 0.64 × 0.56 × 15.77%
Sep 30, 2018 -8.52% = × -4.54 × 1.34%
Jun 30, 2018 -8.28% = × -7.43 × 0.91%
Mar 31, 2018 -7.40% = × -4.50 × 1.35%
Dec 31, 2017 -4.90% = × -0.51 × 4.57%
Sep 30, 2017 = × ×
Jun 30, 2017 = × ×
Mar 31, 2017 = × ×

Based on: 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).