Stock Analysis on Net

Cigna Group (NYSE:CI)

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

Microsoft Excel

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

Cigna Group、 ROE の分解(四半期データ)

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2023/12/31 11.17% = 3.38% × 3.30
2023/09/30 11.61% = 3.54% × 3.28
2023/06/30 14.64% = 4.43% × 3.30
2023/03/31 15.17% = 4.56% × 3.33
2022/12/31 14.86% = 4.63% × 3.21
2022/09/30 14.69% = 4.59% × 3.20
2022/06/30 11.94% = 3.59% × 3.33
2022/03/31 11.69% = 3.53% × 3.31
2021/12/31 11.39% = 3.46% × 3.29
2021/09/30 17.68% = 5.44% × 3.25
2021/06/30 16.73% = 5.29% × 3.17
2021/03/31 17.52% = 5.55% × 3.16
2020/12/31 16.81% = 5.44% × 3.09
2020/09/30 11.03% = 3.31% × 3.33
2020/06/30 11.11% = 3.30% × 3.37
2020/03/31 10.91% = 3.18% × 3.43
2019/12/31 11.26% = 3.28% × 3.44
2019/09/30 = × 3.46
2019/06/30 = × 3.52
2019/03/31 = × 3.64

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

2023年第4 四半期の株主資本利益率(ROE)が低下した主な理由は、総資産利益率(ROA)で測定した収益性の低下です。


ROEを3つの要素に分解

Cigna Group、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2023/12/31 11.17% = 2.66% × 1.27 × 3.30
2023/09/30 11.61% = 2.81% × 1.26 × 3.28
2023/06/30 14.64% = 3.59% × 1.23 × 3.30
2023/03/31 15.17% = 3.71% × 1.23 × 3.33
2022/12/31 14.86% = 3.72% × 1.25 × 3.21
2022/09/30 14.69% = 3.69% × 1.24 × 3.20
2022/06/30 11.94% = 3.08% × 1.17 × 3.33
2022/03/31 11.69% = 3.07% × 1.15 × 3.31
2021/12/31 11.39% = 3.11% × 1.11 × 3.29
2021/09/30 17.68% = 4.97% × 1.09 × 3.25
2021/06/30 16.73% = 4.93% × 1.07 × 3.17
2021/03/31 17.52% = 5.22% × 1.06 × 3.16
2020/12/31 16.81% = 5.31% × 1.02 × 3.09
2020/09/30 11.03% = 3.40% × 0.97 × 3.33
2020/06/30 11.11% = 3.43% × 0.96 × 3.37
2020/03/31 10.91% = 3.22% × 0.99 × 3.43
2019/12/31 11.26% = 3.35% × 0.98 × 3.44
2019/09/30 = × × 3.46
2019/06/30 = × × 3.52
2019/03/31 = × × 3.64

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

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


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

Cigna Group、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 純利益率 × 資産回転率
2023/12/31 3.38% = 2.66% × 1.27
2023/09/30 3.54% = 2.81% × 1.26
2023/06/30 4.43% = 3.59% × 1.23
2023/03/31 4.56% = 3.71% × 1.23
2022/12/31 4.63% = 3.72% × 1.25
2022/09/30 4.59% = 3.69% × 1.24
2022/06/30 3.59% = 3.08% × 1.17
2022/03/31 3.53% = 3.07% × 1.15
2021/12/31 3.46% = 3.11% × 1.11
2021/09/30 5.44% = 4.97% × 1.09
2021/06/30 5.29% = 4.93% × 1.07
2021/03/31 5.55% = 5.22% × 1.06
2020/12/31 5.44% = 5.31% × 1.02
2020/09/30 3.31% = 3.40% × 0.97
2020/06/30 3.30% = 3.43% × 0.96
2020/03/31 3.18% = 3.22% × 0.99
2019/12/31 3.28% = 3.35% × 0.98
2019/09/30 = ×
2019/06/30 = ×
2019/03/31 = ×

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

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