Stock Analysis on Net
Stock Analysis on Net

Warner Bros. Discovery Inc. (NASDAQ:WBD)

この会社は アーカイブに移されました! 財務データは2022年11月4日以降更新されていません。

デュポン分析: ROE、ROA、純利益率の内訳 
四半期データ

Microsoft Excel

ROE分解では、純利益を株主資本で割ったものを構成比率の積として表します。

ROEを2つのコンポーネントに分解

Warner Bros. Discovery Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2022/09/30 -10.78% = -3.85% × 2.80
2022/06/30 -5.39% = -1.95% × 2.77
2022/03/31 11.05% = 3.91% × 2.82
2021/12/31 8.67% = 2.92% × 2.97
2021/09/30 10.67% = 3.61% × 2.96
2021/06/30 11.99% = 4.00% × 3.00
2021/03/31 9.08% = 2.92% × 3.11
2020/12/31 11.65% = 3.58% × 3.26
2020/09/30 14.12% = 4.26% × 3.31
2020/06/30 14.05% = 4.19% × 3.35
2020/03/31 21.77% = 6.18% × 3.53
2019/12/31 20.92% = 6.13% × 3.41
2019/09/30 19.56% = 5.67% × 3.45
2019/06/30 17.85% = 5.07% × 3.52
2019/03/31 11.32% = 3.04% × 3.73
2018/12/31 7.08% = 1.82% × 3.88
2018/09/30 -10.09% = -2.49% × 4.06
2018/06/30 -9.05% = -2.14% × 4.22
2018/03/31 -7.10% = -1.62% × 4.39
2017/12/31 -7.31% = -1.49% × 4.89
2017/09/30 — = — × 4.03
2017/06/30 — = — × 2.92
2017/03/31 — = — × 2.97

レポートに基づく: 10-Q (報告日: 2022-09-30), 10-Q (報告日: 2022-06-30), 10-Q (報告日: 2022-03-31), 10-K (報告日: 2021-12-31), 10-Q (報告日: 2021-09-30), 10-Q (報告日: 2021-06-30), 10-Q (報告日: 2021-03-31), 10-K (報告日: 2020-12-31), 10-Q (報告日: 2020-09-30), 10-Q (報告日: 2020-06-30), 10-Q (報告日: 2020-03-31), 10-K (報告日: 2019-12-31), 10-Q (報告日: 2019-09-30), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31), 10-K (報告日: 2018-12-31), 10-Q (報告日: 2018-09-30), 10-Q (報告日: 2018-06-30), 10-Q (報告日: 2018-03-31), 10-K (報告日: 2017-12-31), 10-Q (報告日: 2017-09-30), 10-Q (報告日: 2017-06-30), 10-Q (報告日: 2017-03-31).

ROEを3つの要素に分解

Warner Bros. Discovery Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2022/09/30 -10.78% = -20.13% × 0.19 × 2.80
2022/06/30 -5.39% = -14.32% × 0.14 × 2.77
2022/03/31 11.05% = 10.53% × 0.37 × 2.82
2021/12/31 8.67% = 8.25% × 0.35 × 2.97
2021/09/30 10.67% = 10.42% × 0.35 × 2.96
2021/06/30 11.99% = 12.24% × 0.33 × 3.00
2021/03/31 9.08% = 9.11% × 0.32 × 3.11
2020/12/31 11.65% = 11.42% × 0.31 × 3.26
2020/09/30 14.12% = 13.36% × 0.32 × 3.31
2020/06/30 14.05% = 12.86% × 0.33 × 3.35
2020/03/31 21.77% = 18.54% × 0.33 × 3.53
2019/12/31 20.92% = 18.57% × 0.33 × 3.41
2019/09/30 19.56% = 16.81% × 0.34 × 3.45
2019/06/30 17.85% = 15.62% × 0.32 × 3.52
2019/03/31 11.32% = 9.00% × 0.34 × 3.73
2018/12/31 7.08% = 5.63% × 0.32 × 3.88
2018/09/30 -10.09% = -8.52% × 0.29 × 4.06
2018/06/30 -9.05% = -8.28% × 0.26 × 4.22
2018/03/31 -7.10% = -7.40% × 0.22 × 4.39
2017/12/31 -7.31% = -4.90% × 0.30 × 4.89
2017/09/30 — = — × — × 4.03
2017/06/30 — = — × — × 2.92
2017/03/31 — = — × — × 2.97

レポートに基づく: 10-Q (報告日: 2022-09-30), 10-Q (報告日: 2022-06-30), 10-Q (報告日: 2022-03-31), 10-K (報告日: 2021-12-31), 10-Q (報告日: 2021-09-30), 10-Q (報告日: 2021-06-30), 10-Q (報告日: 2021-03-31), 10-K (報告日: 2020-12-31), 10-Q (報告日: 2020-09-30), 10-Q (報告日: 2020-06-30), 10-Q (報告日: 2020-03-31), 10-K (報告日: 2019-12-31), 10-Q (報告日: 2019-09-30), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31), 10-K (報告日: 2018-12-31), 10-Q (報告日: 2018-09-30), 10-Q (報告日: 2018-06-30), 10-Q (報告日: 2018-03-31), 10-K (報告日: 2017-12-31), 10-Q (報告日: 2017-09-30), 10-Q (報告日: 2017-06-30), 10-Q (報告日: 2017-03-31).

ROEを5つの要素に分解

Warner Bros. Discovery Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 税負担 × 利息負担 × EBITマージン × 資産回転率 × 財務レバレッジ比率
2022/09/30 -10.78% = — × — × -19.11% × 0.19 × 2.80
2022/06/30 -5.39% = — × — × -11.89% × 0.14 × 2.77
2022/03/31 11.05% = 0.80 × 0.73 × 18.12% × 0.37 × 2.82
2021/12/31 8.67% = 0.81 × 0.66 × 15.38% × 0.35 × 2.97
2021/09/30 10.67% = 0.84 × 0.70 × 17.86% × 0.35 × 2.96
2021/06/30 11.99% = 0.88 × 0.71 × 19.66% × 0.33 × 3.00
2021/03/31 9.08% = 0.74 × 0.67 × 18.36% × 0.32 × 3.11
2020/12/31 11.65% = 0.77 × 0.71 × 20.99% × 0.31 × 3.26
2020/09/30 14.12% = 0.81 × 0.73 × 22.58% × 0.32 × 3.31
2020/06/30 14.05% = 0.74 × 0.74 × 23.47% × 0.33 × 3.35
2020/03/31 21.77% = 0.97 × 0.76 × 24.98% × 0.33 × 3.53
2019/12/31 20.92% = 0.96 × 0.76 × 25.37% × 0.33 × 3.41
2019/09/30 19.56% = 0.89 × 0.75 × 24.94% × 0.34 × 3.45
2019/06/30 17.85% = 0.93 × 0.72 × 23.07% × 0.32 × 3.52
2019/03/31 11.32% = 0.66 × 0.67 × 20.40% × 0.34 × 3.73
2018/12/31 7.08% = 0.64 × 0.56 × 15.77% × 0.32 × 3.88
2018/09/30 -10.09% = — × -4.54 × 1.34% × 0.29 × 4.06
2018/06/30 -9.05% = — × -7.43 × 0.91% × 0.26 × 4.22
2018/03/31 -7.10% = — × -4.50 × 1.35% × 0.22 × 4.39
2017/12/31 -7.31% = — × -0.51 × 4.57% × 0.30 × 4.89
2017/09/30 — = — × — × — × — × 4.03
2017/06/30 — = — × — × — × — × 2.92
2017/03/31 — = — × — × — × — × 2.97

レポートに基づく: 10-Q (報告日: 2022-09-30), 10-Q (報告日: 2022-06-30), 10-Q (報告日: 2022-03-31), 10-K (報告日: 2021-12-31), 10-Q (報告日: 2021-09-30), 10-Q (報告日: 2021-06-30), 10-Q (報告日: 2021-03-31), 10-K (報告日: 2020-12-31), 10-Q (報告日: 2020-09-30), 10-Q (報告日: 2020-06-30), 10-Q (報告日: 2020-03-31), 10-K (報告日: 2019-12-31), 10-Q (報告日: 2019-09-30), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31), 10-K (報告日: 2018-12-31), 10-Q (報告日: 2018-09-30), 10-Q (報告日: 2018-06-30), 10-Q (報告日: 2018-03-31), 10-K (報告日: 2017-12-31), 10-Q (報告日: 2017-09-30), 10-Q (報告日: 2017-06-30), 10-Q (報告日: 2017-03-31).

ROAを2つのコンポーネントに分解

Warner Bros. Discovery Inc.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 純利益率 × 資産回転率
2022/09/30 -3.85% = -20.13% × 0.19
2022/06/30 -1.95% = -14.32% × 0.14
2022/03/31 3.91% = 10.53% × 0.37
2021/12/31 2.92% = 8.25% × 0.35
2021/09/30 3.61% = 10.42% × 0.35
2021/06/30 4.00% = 12.24% × 0.33
2021/03/31 2.92% = 9.11% × 0.32
2020/12/31 3.58% = 11.42% × 0.31
2020/09/30 4.26% = 13.36% × 0.32
2020/06/30 4.19% = 12.86% × 0.33
2020/03/31 6.18% = 18.54% × 0.33
2019/12/31 6.13% = 18.57% × 0.33
2019/09/30 5.67% = 16.81% × 0.34
2019/06/30 5.07% = 15.62% × 0.32
2019/03/31 3.04% = 9.00% × 0.34
2018/12/31 1.82% = 5.63% × 0.32
2018/09/30 -2.49% = -8.52% × 0.29
2018/06/30 -2.14% = -8.28% × 0.26
2018/03/31 -1.62% = -7.40% × 0.22
2017/12/31 -1.49% = -4.90% × 0.30
2017/09/30 — = — × —
2017/06/30 — = — × —
2017/03/31 — = — × —

レポートに基づく: 10-Q (報告日: 2022-09-30), 10-Q (報告日: 2022-06-30), 10-Q (報告日: 2022-03-31), 10-K (報告日: 2021-12-31), 10-Q (報告日: 2021-09-30), 10-Q (報告日: 2021-06-30), 10-Q (報告日: 2021-03-31), 10-K (報告日: 2020-12-31), 10-Q (報告日: 2020-09-30), 10-Q (報告日: 2020-06-30), 10-Q (報告日: 2020-03-31), 10-K (報告日: 2019-12-31), 10-Q (報告日: 2019-09-30), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31), 10-K (報告日: 2018-12-31), 10-Q (報告日: 2018-09-30), 10-Q (報告日: 2018-06-30), 10-Q (報告日: 2018-03-31), 10-K (報告日: 2017-12-31), 10-Q (報告日: 2017-09-30), 10-Q (報告日: 2017-06-30), 10-Q (報告日: 2017-03-31).

ROAを4つの要素に分解

Warner Bros. Discovery Inc.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 税負担 × 利息負担 × EBITマージン × 資産回転率
2022/09/30 -3.85% = — × — × -19.11% × 0.19
2022/06/30 -1.95% = — × — × -11.89% × 0.14
2022/03/31 3.91% = 0.80 × 0.73 × 18.12% × 0.37
2021/12/31 2.92% = 0.81 × 0.66 × 15.38% × 0.35
2021/09/30 3.61% = 0.84 × 0.70 × 17.86% × 0.35
2021/06/30 4.00% = 0.88 × 0.71 × 19.66% × 0.33
2021/03/31 2.92% = 0.74 × 0.67 × 18.36% × 0.32
2020/12/31 3.58% = 0.77 × 0.71 × 20.99% × 0.31
2020/09/30 4.26% = 0.81 × 0.73 × 22.58% × 0.32
2020/06/30 4.19% = 0.74 × 0.74 × 23.47% × 0.33
2020/03/31 6.18% = 0.97 × 0.76 × 24.98% × 0.33
2019/12/31 6.13% = 0.96 × 0.76 × 25.37% × 0.33
2019/09/30 5.67% = 0.89 × 0.75 × 24.94% × 0.34
2019/06/30 5.07% = 0.93 × 0.72 × 23.07% × 0.32
2019/03/31 3.04% = 0.66 × 0.67 × 20.40% × 0.34
2018/12/31 1.82% = 0.64 × 0.56 × 15.77% × 0.32
2018/09/30 -2.49% = — × -4.54 × 1.34% × 0.29
2018/06/30 -2.14% = — × -7.43 × 0.91% × 0.26
2018/03/31 -1.62% = — × -4.50 × 1.35% × 0.22
2017/12/31 -1.49% = — × -0.51 × 4.57% × 0.30
2017/09/30 — = — × — × — × —
2017/06/30 — = — × — × — × —
2017/03/31 — = — × — × — × —

レポートに基づく: 10-Q (報告日: 2022-09-30), 10-Q (報告日: 2022-06-30), 10-Q (報告日: 2022-03-31), 10-K (報告日: 2021-12-31), 10-Q (報告日: 2021-09-30), 10-Q (報告日: 2021-06-30), 10-Q (報告日: 2021-03-31), 10-K (報告日: 2020-12-31), 10-Q (報告日: 2020-09-30), 10-Q (報告日: 2020-06-30), 10-Q (報告日: 2020-03-31), 10-K (報告日: 2019-12-31), 10-Q (報告日: 2019-09-30), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31), 10-K (報告日: 2018-12-31), 10-Q (報告日: 2018-09-30), 10-Q (報告日: 2018-06-30), 10-Q (報告日: 2018-03-31), 10-K (報告日: 2017-12-31), 10-Q (報告日: 2017-09-30), 10-Q (報告日: 2017-06-30), 10-Q (報告日: 2017-03-31).

純利益率の分解

Warner Bros. Discovery Inc.、純利益率の分解(四半期データ)

Microsoft Excel
純利益率 = 税負担 × 利息負担 × EBITマージン
2022/09/30 -20.13% = — × — × -19.11%
2022/06/30 -14.32% = — × — × -11.89%
2022/03/31 10.53% = 0.80 × 0.73 × 18.12%
2021/12/31 8.25% = 0.81 × 0.66 × 15.38%
2021/09/30 10.42% = 0.84 × 0.70 × 17.86%
2021/06/30 12.24% = 0.88 × 0.71 × 19.66%
2021/03/31 9.11% = 0.74 × 0.67 × 18.36%
2020/12/31 11.42% = 0.77 × 0.71 × 20.99%
2020/09/30 13.36% = 0.81 × 0.73 × 22.58%
2020/06/30 12.86% = 0.74 × 0.74 × 23.47%
2020/03/31 18.54% = 0.97 × 0.76 × 24.98%
2019/12/31 18.57% = 0.96 × 0.76 × 25.37%
2019/09/30 16.81% = 0.89 × 0.75 × 24.94%
2019/06/30 15.62% = 0.93 × 0.72 × 23.07%
2019/03/31 9.00% = 0.66 × 0.67 × 20.40%
2018/12/31 5.63% = 0.64 × 0.56 × 15.77%
2018/09/30 -8.52% = — × -4.54 × 1.34%
2018/06/30 -8.28% = — × -7.43 × 0.91%
2018/03/31 -7.40% = — × -4.50 × 1.35%
2017/12/31 -4.90% = — × -0.51 × 4.57%
2017/09/30 — = — × — × —
2017/06/30 — = — × — × —
2017/03/31 — = — × — × —

レポートに基づく: 10-Q (報告日: 2022-09-30), 10-Q (報告日: 2022-06-30), 10-Q (報告日: 2022-03-31), 10-K (報告日: 2021-12-31), 10-Q (報告日: 2021-09-30), 10-Q (報告日: 2021-06-30), 10-Q (報告日: 2021-03-31), 10-K (報告日: 2020-12-31), 10-Q (報告日: 2020-09-30), 10-Q (報告日: 2020-06-30), 10-Q (報告日: 2020-03-31), 10-K (報告日: 2019-12-31), 10-Q (報告日: 2019-09-30), 10-Q (報告日: 2019-06-30), 10-Q (報告日: 2019-03-31), 10-K (報告日: 2018-12-31), 10-Q (報告日: 2018-09-30), 10-Q (報告日: 2018-06-30), 10-Q (報告日: 2018-03-31), 10-K (報告日: 2017-12-31), 10-Q (報告日: 2017-09-30), 10-Q (報告日: 2017-06-30), 10-Q (報告日: 2017-03-31).