DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin
Quarterly Data
Decomposing ROE involves expressing net income divided by shareholders’ equity as the product of component ratios.
Two-Component Disaggregation of ROE
Warner Bros. Discovery Inc., decomposition of ROE (quarterly data)
|
|
|
|
|
|
|
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)
|
|
|
|
|
|
|
|
|
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)
|
|
|
|
|
|
|
|
|
|
|
|
|
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)
|
|
|
|
|
|
|
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)
|
|
|
|
|
|
|
|
|
|
|
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)
|
|
|
|
|
|
|
|
|
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).