Stock Analysis on Net

CVS Health Corp. (NYSE:CVS)

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

Microsoft Excel

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

CVS Health Corp.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2023/12/31 10.91% = 3.34% × 3.27
2023/09/30 11.57% = 3.42% × 3.38
2023/06/30 4.02% = 1.17% × 3.44
2023/03/31 5.57% = 1.66% × 3.35
2022/12/31 5.84% = 1.82% × 3.21
2022/09/30 4.46% = 1.36% × 3.27
2022/06/30 10.86% = 3.55% × 3.06
2022/03/31 10.83% = 3.43% × 3.15
2021/12/31 10.54% = 3.39% × 3.10
2021/09/30 10.20% = 3.23% × 3.16
2021/06/30 9.83% = 3.12% × 3.16
2021/03/31 10.44% = 3.22% × 3.24
2020/12/31 10.35% = 3.11% × 3.32
2020/09/30 11.56% = 3.41% × 3.38
2020/06/30 12.14% = 3.51% × 3.46
2020/03/31 11.08% = 3.13% × 3.54
2019/12/31 10.39% = 2.98% × 3.48
2019/09/30 = × 3.52
2019/06/30 = × 3.57
2019/03/31 = × 3.68

レポートに基づく: 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)が低下した主な理由は、財務レバレッジ比率の低下です。


ROEを3つの要素に分解

CVS Health Corp.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2023/12/31 10.91% = 2.34% × 1.43 × 3.27
2023/09/30 11.57% = 2.48% × 1.38 × 3.38
2023/06/30 4.02% = 0.86% × 1.35 × 3.44
2023/03/31 5.57% = 1.20% × 1.38 × 3.35
2022/12/31 5.84% = 1.29% × 1.41 × 3.21
2022/09/30 4.46% = 1.00% × 1.36 × 3.27
2022/06/30 10.86% = 2.66% × 1.33 × 3.06
2022/03/31 10.83% = 2.68% × 1.28 × 3.15
2021/12/31 10.54% = 2.72% × 1.25 × 3.10
2021/09/30 10.20% = 2.67% × 1.21 × 3.16
2021/06/30 9.83% = 2.60% × 1.20 × 3.16
2021/03/31 10.44% = 2.74% × 1.18 × 3.24
2020/12/31 10.35% = 2.68% × 1.16 × 3.32
2020/09/30 11.56% = 3.00% × 1.14 × 3.38
2020/06/30 12.14% = 3.14% × 1.12 × 3.46
2020/03/31 11.08% = 2.77% × 1.13 × 3.54
2019/12/31 10.39% = 2.59% × 1.15 × 3.48
2019/09/30 = × × 3.52
2019/06/30 = × × 3.57
2019/03/31 = × × 3.68

レポートに基づく: 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)が低下した主な理由は、純利益率で測定した収益性の低下です。


ROEを5つの要素に分解

CVS Health Corp.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 税負担 × 利息負担 × EBITマージン × 資産回転率 × 財務レバレッジ比率
2023/12/31 10.91% = 0.75 × 0.81 × 3.87% × 1.43 × 3.27
2023/09/30 11.57% = 0.74 × 0.82 × 4.06% × 1.38 × 3.38
2023/06/30 4.02% = 0.72 × 0.63 × 1.91% × 1.35 × 3.44
2023/03/31 5.57% = 0.72 × 0.71 × 2.37% × 1.38 × 3.35
2022/12/31 5.84% = 0.74 × 0.71 × 2.46% × 1.41 × 3.21
2022/09/30 4.46% = 0.77 × 0.64 × 2.04% × 1.36 × 3.27
2022/06/30 10.86% = 0.76 × 0.82 × 4.26% × 1.33 × 3.06
2022/03/31 10.83% = 0.77 × 0.81 × 4.30% × 1.28 × 3.15
2021/12/31 10.54% = 0.76 × 0.81 × 4.45% × 1.25 × 3.10
2021/09/30 10.20% = 0.75 × 0.80 × 4.45% × 1.21 × 3.16
2021/06/30 9.83% = 0.74 × 0.78 × 4.48% × 1.20 × 3.16
2021/03/31 10.44% = 0.74 × 0.78 × 4.73% × 1.18 × 3.24
2020/12/31 10.35% = 0.74 × 0.77 × 4.72% × 1.16 × 3.32
2020/09/30 11.56% = 0.73 × 0.79 × 5.21% × 1.14 × 3.38
2020/06/30 12.14% = 0.74 × 0.79 × 5.39% × 1.12 × 3.46
2020/03/31 11.08% = 0.73 × 0.77 × 4.92% × 1.13 × 3.54
2019/12/31 10.39% = 0.74 × 0.75 × 4.71% × 1.15 × 3.48
2019/09/30 = × × × × 3.52
2019/06/30 = × × × × 3.57
2019/03/31 = × × × × 3.68

レポートに基づく: 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)が低下した主な理由は、EBITマージン率で測定した営業利益率の低下です。


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

CVS Health Corp.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 純利益率 × 資産回転率
2023/12/31 3.34% = 2.34% × 1.43
2023/09/30 3.42% = 2.48% × 1.38
2023/06/30 1.17% = 0.86% × 1.35
2023/03/31 1.66% = 1.20% × 1.38
2022/12/31 1.82% = 1.29% × 1.41
2022/09/30 1.36% = 1.00% × 1.36
2022/06/30 3.55% = 2.66% × 1.33
2022/03/31 3.43% = 2.68% × 1.28
2021/12/31 3.39% = 2.72% × 1.25
2021/09/30 3.23% = 2.67% × 1.21
2021/06/30 3.12% = 2.60% × 1.20
2021/03/31 3.22% = 2.74% × 1.18
2020/12/31 3.11% = 2.68% × 1.16
2020/09/30 3.41% = 3.00% × 1.14
2020/06/30 3.51% = 3.14% × 1.12
2020/03/31 3.13% = 2.77% × 1.13
2019/12/31 2.98% = 2.59% × 1.15
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)が低下した主な理由は、純利益率で測定した収益性の低下です。


ROAを4つの要素に分解

CVS Health Corp.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 税負担 × 利息負担 × EBITマージン × 資産回転率
2023/12/31 3.34% = 0.75 × 0.81 × 3.87% × 1.43
2023/09/30 3.42% = 0.74 × 0.82 × 4.06% × 1.38
2023/06/30 1.17% = 0.72 × 0.63 × 1.91% × 1.35
2023/03/31 1.66% = 0.72 × 0.71 × 2.37% × 1.38
2022/12/31 1.82% = 0.74 × 0.71 × 2.46% × 1.41
2022/09/30 1.36% = 0.77 × 0.64 × 2.04% × 1.36
2022/06/30 3.55% = 0.76 × 0.82 × 4.26% × 1.33
2022/03/31 3.43% = 0.77 × 0.81 × 4.30% × 1.28
2021/12/31 3.39% = 0.76 × 0.81 × 4.45% × 1.25
2021/09/30 3.23% = 0.75 × 0.80 × 4.45% × 1.21
2021/06/30 3.12% = 0.74 × 0.78 × 4.48% × 1.20
2021/03/31 3.22% = 0.74 × 0.78 × 4.73% × 1.18
2020/12/31 3.11% = 0.74 × 0.77 × 4.72% × 1.16
2020/09/30 3.41% = 0.73 × 0.79 × 5.21% × 1.14
2020/06/30 3.51% = 0.74 × 0.79 × 5.39% × 1.12
2020/03/31 3.13% = 0.73 × 0.77 × 4.92% × 1.13
2019/12/31 2.98% = 0.74 × 0.75 × 4.71% × 1.15
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)が低下した主な理由は、EBITマージン率で測定した営業利益率の低下です。


純利益率の分解

CVS Health Corp.、純利益率の分解(四半期データ)

Microsoft Excel
純利益率 = 税負担 × 利息負担 × EBITマージン
2023/12/31 2.34% = 0.75 × 0.81 × 3.87%
2023/09/30 2.48% = 0.74 × 0.82 × 4.06%
2023/06/30 0.86% = 0.72 × 0.63 × 1.91%
2023/03/31 1.20% = 0.72 × 0.71 × 2.37%
2022/12/31 1.29% = 0.74 × 0.71 × 2.46%
2022/09/30 1.00% = 0.77 × 0.64 × 2.04%
2022/06/30 2.66% = 0.76 × 0.82 × 4.26%
2022/03/31 2.68% = 0.77 × 0.81 × 4.30%
2021/12/31 2.72% = 0.76 × 0.81 × 4.45%
2021/09/30 2.67% = 0.75 × 0.80 × 4.45%
2021/06/30 2.60% = 0.74 × 0.78 × 4.48%
2021/03/31 2.74% = 0.74 × 0.78 × 4.73%
2020/12/31 2.68% = 0.74 × 0.77 × 4.72%
2020/09/30 3.00% = 0.73 × 0.79 × 5.21%
2020/06/30 3.14% = 0.74 × 0.79 × 5.39%
2020/03/31 2.77% = 0.73 × 0.77 × 4.92%
2019/12/31 2.59% = 0.74 × 0.75 × 4.71%
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 四半期の純利益率の低下の主な理由は、EBITマージン率で測定した営業利益率の低下です。