Stock Analysis on Net
Stock Analysis on Net

ONEOK Inc. (NYSE:OKE)

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

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

Microsoft Excel

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

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

ONEOK Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2023/06/30 33.72% = 10.12% × 3.33
2023/03/31 33.37% = 9.73% × 3.43
2022/12/31 26.52% = 7.06% × 3.75
2022/09/30 25.61% = 6.62% × 3.87
2022/06/30 25.79% = 6.43% × 4.01
2022/03/31 25.10% = 6.27% × 4.00
2021/12/31 24.93% = 6.35% × 3.93
2021/09/30 24.45% = 5.98% × 4.09
2021/06/30 22.82% = 5.75% × 3.97
2021/03/31 18.71% = 4.92% × 3.80
2020/12/31 10.14% = 2.66% × 3.82
2020/09/30 10.17% = 2.74% × 3.71
2020/06/30 9.96% = 2.70% × 3.68
2020/03/31 14.38% = 3.64% × 3.95
2019/12/31 20.54% = 5.86% × 3.50
2019/09/30 20.12% = 5.86% × 3.43
2019/06/30 19.77% = 6.36% × 3.11
2019/03/31 19.01% = 6.47% × 2.94
2018/12/31 17.50% = 6.32% × 2.77
2018/09/30 — = — × 2.69
2018/06/30 — = — × 2.54
2018/03/31 — = — × 2.45

レポートに基づく: 10-Q (報告日: 2023-06-30), 10-Q (報告日: 2023-03-31), 10-K (報告日: 2022-12-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).

2023年第2 四半期に株主資本利益率(ROE)が増加した主な理由は、総資産利益率(ROA)で測定される収益性の増加です。

ROEを3つの要素に分解

ONEOK Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2023/06/30 33.72% = 12.68% × 0.80 × 3.33
2023/03/31 33.37% = 11.09% × 0.88 × 3.43
2022/12/31 26.52% = 7.69% × 0.92 × 3.75
2022/09/30 25.61% = 7.10% × 0.93 × 3.87
2022/06/30 25.79% = 7.37% × 0.87 × 4.01
2022/03/31 25.10% = 8.01% × 0.78 × 4.00
2021/12/31 24.93% = 9.07% × 0.70 × 3.93
2021/09/30 24.45% = 10.43% × 0.57 × 4.09
2021/06/30 22.82% = 11.91% × 0.48 × 3.97
2021/03/31 18.71% = 11.88% × 0.41 × 3.80
2020/12/31 10.14% = 7.17% × 0.37 × 3.82
2020/09/30 10.17% = 7.24% × 0.38 × 3.71
2020/06/30 9.96% = 7.13% × 0.38 × 3.68
2020/03/31 14.38% = 8.40% × 0.43 × 3.95
2019/12/31 20.54% = 12.58% × 0.47 × 3.50
2019/09/30 20.12% = 11.76% × 0.50 × 3.43
2019/06/30 19.77% = 10.67% × 0.60 × 3.11
2019/03/31 19.01% = 9.98% × 0.65 × 2.94
2018/12/31 17.50% = 9.15% × 0.69 × 2.77
2018/09/30 — = — × — × 2.69
2018/06/30 — = — × — × 2.54
2018/03/31 — = — × — × 2.45

レポートに基づく: 10-Q (報告日: 2023-06-30), 10-Q (報告日: 2023-03-31), 10-K (報告日: 2022-12-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).

2023年第2 四半期に株主資本利益率(ROE)が増加した主な理由は、純利益率で測定した収益性の増加です。

ROEを5つの要素に分解

ONEOK Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 税負担 × 利息負担 × EBITマージン × 資産回転率 × 財務レバレッジ比率
2023/06/30 33.72% = 0.76 × 0.82 × 20.12% × 0.80 × 3.33
2023/03/31 33.37% = 0.76 × 0.82 × 17.63% × 0.88 × 3.43
2022/12/31 26.52% = 0.77 × 0.77 × 13.07% × 0.92 × 3.75
2022/09/30 25.61% = 0.76 × 0.76 × 12.38% × 0.93 × 3.87
2022/06/30 25.79% = 0.76 × 0.75 × 13.03% × 0.87 × 4.01
2022/03/31 25.10% = 0.76 × 0.73 × 14.42% × 0.78 × 4.00
2021/12/31 24.93% = 0.76 × 0.73 × 16.43% × 0.70 × 3.93
2021/09/30 24.45% = 0.76 × 0.72 × 19.06% × 0.57 × 4.09
2021/06/30 22.82% = 0.76 × 0.71 × 22.12% × 0.48 × 3.97
2021/03/31 18.71% = 0.76 × 0.67 × 23.60% × 0.41 × 3.80
2020/12/31 10.14% = 0.76 × 0.53 × 17.74% × 0.37 × 3.82
2020/09/30 10.17% = 0.76 × 0.55 × 17.17% × 0.38 × 3.71
2020/06/30 9.96% = 0.77 × 0.57 × 16.32% × 0.38 × 3.68
2020/03/31 14.38% = 0.77 × 0.67 × 16.34% × 0.43 × 3.95
2019/12/31 20.54% = 0.77 × 0.77 × 21.08% × 0.47 × 3.50
2019/09/30 20.12% = 0.77 × 0.77 × 19.77% × 0.50 × 3.43
2019/06/30 19.77% = 0.77 × 0.78 × 17.89% × 0.60 × 3.11
2019/03/31 19.01% = 0.77 × 0.77 × 16.78% × 0.65 × 2.94
2018/12/31 17.50% = 0.76 × 0.76 × 15.76% × 0.69 × 2.77
2018/09/30 — = — × — × — × — × 2.69
2018/06/30 — = — × — × — × — × 2.54
2018/03/31 — = — × — × — × — × 2.45

レポートに基づく: 10-Q (報告日: 2023-06-30), 10-Q (報告日: 2023-03-31), 10-K (報告日: 2022-12-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).

2023年第2 四半期に株主資本利益率(ROE)が増加した主な理由は、EBITマージン率で測定した営業利益率の増加です。

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

ONEOK Inc.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 純利益率 × 資産回転率
2023/06/30 10.12% = 12.68% × 0.80
2023/03/31 9.73% = 11.09% × 0.88
2022/12/31 7.06% = 7.69% × 0.92
2022/09/30 6.62% = 7.10% × 0.93
2022/06/30 6.43% = 7.37% × 0.87
2022/03/31 6.27% = 8.01% × 0.78
2021/12/31 6.35% = 9.07% × 0.70
2021/09/30 5.98% = 10.43% × 0.57
2021/06/30 5.75% = 11.91% × 0.48
2021/03/31 4.92% = 11.88% × 0.41
2020/12/31 2.66% = 7.17% × 0.37
2020/09/30 2.74% = 7.24% × 0.38
2020/06/30 2.70% = 7.13% × 0.38
2020/03/31 3.64% = 8.40% × 0.43
2019/12/31 5.86% = 12.58% × 0.47
2019/09/30 5.86% = 11.76% × 0.50
2019/06/30 6.36% = 10.67% × 0.60
2019/03/31 6.47% = 9.98% × 0.65
2018/12/31 6.32% = 9.15% × 0.69
2018/09/30 — = — × —
2018/06/30 — = — × —
2018/03/31 — = — × —

レポートに基づく: 10-Q (報告日: 2023-06-30), 10-Q (報告日: 2023-03-31), 10-K (報告日: 2022-12-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).

2023年第2 四半期に総資産利益率(ROA)が増加した主な理由は、純利益率で測定した収益性の増加です。

ROAを4つの要素に分解

ONEOK Inc.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 税負担 × 利息負担 × EBITマージン × 資産回転率
2023/06/30 10.12% = 0.76 × 0.82 × 20.12% × 0.80
2023/03/31 9.73% = 0.76 × 0.82 × 17.63% × 0.88
2022/12/31 7.06% = 0.77 × 0.77 × 13.07% × 0.92
2022/09/30 6.62% = 0.76 × 0.76 × 12.38% × 0.93
2022/06/30 6.43% = 0.76 × 0.75 × 13.03% × 0.87
2022/03/31 6.27% = 0.76 × 0.73 × 14.42% × 0.78
2021/12/31 6.35% = 0.76 × 0.73 × 16.43% × 0.70
2021/09/30 5.98% = 0.76 × 0.72 × 19.06% × 0.57
2021/06/30 5.75% = 0.76 × 0.71 × 22.12% × 0.48
2021/03/31 4.92% = 0.76 × 0.67 × 23.60% × 0.41
2020/12/31 2.66% = 0.76 × 0.53 × 17.74% × 0.37
2020/09/30 2.74% = 0.76 × 0.55 × 17.17% × 0.38
2020/06/30 2.70% = 0.77 × 0.57 × 16.32% × 0.38
2020/03/31 3.64% = 0.77 × 0.67 × 16.34% × 0.43
2019/12/31 5.86% = 0.77 × 0.77 × 21.08% × 0.47
2019/09/30 5.86% = 0.77 × 0.77 × 19.77% × 0.50
2019/06/30 6.36% = 0.77 × 0.78 × 17.89% × 0.60
2019/03/31 6.47% = 0.77 × 0.77 × 16.78% × 0.65
2018/12/31 6.32% = 0.76 × 0.76 × 15.76% × 0.69
2018/09/30 — = — × — × — × —
2018/06/30 — = — × — × — × —
2018/03/31 — = — × — × — × —

レポートに基づく: 10-Q (報告日: 2023-06-30), 10-Q (報告日: 2023-03-31), 10-K (報告日: 2022-12-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).

2023年第2 四半期に総資産利益率(ROA)が上昇した主な理由は、EBITマージン率で測定した営業利益率の増加です。

当期純利益率の分解

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

Microsoft Excel
純利益率 = 税負担 × 利息負担 × EBITマージン
2023/06/30 12.68% = 0.76 × 0.82 × 20.12%
2023/03/31 11.09% = 0.76 × 0.82 × 17.63%
2022/12/31 7.69% = 0.77 × 0.77 × 13.07%
2022/09/30 7.10% = 0.76 × 0.76 × 12.38%
2022/06/30 7.37% = 0.76 × 0.75 × 13.03%
2022/03/31 8.01% = 0.76 × 0.73 × 14.42%
2021/12/31 9.07% = 0.76 × 0.73 × 16.43%
2021/09/30 10.43% = 0.76 × 0.72 × 19.06%
2021/06/30 11.91% = 0.76 × 0.71 × 22.12%
2021/03/31 11.88% = 0.76 × 0.67 × 23.60%
2020/12/31 7.17% = 0.76 × 0.53 × 17.74%
2020/09/30 7.24% = 0.76 × 0.55 × 17.17%
2020/06/30 7.13% = 0.77 × 0.57 × 16.32%
2020/03/31 8.40% = 0.77 × 0.67 × 16.34%
2019/12/31 12.58% = 0.77 × 0.77 × 21.08%
2019/09/30 11.76% = 0.77 × 0.77 × 19.77%
2019/06/30 10.67% = 0.77 × 0.78 × 17.89%
2019/03/31 9.98% = 0.77 × 0.77 × 16.78%
2018/12/31 9.15% = 0.76 × 0.76 × 15.76%
2018/09/30 — = — × — × —
2018/06/30 — = — × — × —
2018/03/31 — = — × — × —

レポートに基づく: 10-Q (報告日: 2023-06-30), 10-Q (報告日: 2023-03-31), 10-K (報告日: 2022-12-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).

2023年第2 四半期に純利益率が上昇した主な理由は、EBITマージン率で測定した営業利益率の増加です。