Stock Analysis on Net
Stock Analysis on Net

Sherwin-Williams Co. (NYSE:SHW)

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

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

Microsoft Excel

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

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

Sherwin-Williams Co.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2022/06/30 78.89% = 7.96% × 9.91
2022/03/31 81.71% = 8.40% × 9.73
2021/12/31 76.50% = 9.02% × 8.48
2021/09/30 73.13% = 9.49% × 7.71
2021/06/30 76.43% = 10.58% × 7.22
2021/03/31 68.81% = 10.37% × 6.64
2020/12/31 56.23% = 9.95% × 5.65
2020/09/30 44.49% = 9.00% × 4.95
2020/06/30 45.03% = 8.50% × 5.30
2020/03/31 49.19% = 7.86% × 6.25
2019/12/31 37.38% = 7.52% × 4.97
2019/09/30 34.64% = 6.68% × 5.19
2019/06/30 31.25% = 5.53% × 5.65
2019/03/31 31.90% = 5.27% × 6.06
2018/12/31 29.72% = 5.79% × 5.13
2018/09/30 47.93% = 9.53% × 5.03
2018/06/30 49.84% = 9.27% × 5.38
2018/03/31 48.33% = 8.76% × 5.52
2017/12/31 48.00% = 8.88% × 5.41
2017/09/30 — = — × 7.58
2017/06/30 — = — × 8.66
2017/03/31 — = — × 3.38

レポートに基づく: 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).

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

ROEを3つの要素に分解

Sherwin-Williams Co.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2022/06/30 78.89% = 8.45% × 0.94 × 9.91
2022/03/31 81.71% = 9.00% × 0.93 × 9.73
2021/12/31 76.50% = 9.35% × 0.97 × 8.48
2021/09/30 73.13% = 10.00% × 0.95 × 7.71
2021/06/30 76.43% = 11.05% × 0.96 × 7.22
2021/03/31 68.81% = 11.23% × 0.92 × 6.64
2020/12/31 56.23% = 11.06% × 0.90 × 5.65
2020/09/30 44.49% = 10.41% × 0.86 × 4.95
2020/06/30 45.03% = 9.83% × 0.87 × 5.30
2020/03/31 49.19% = 8.98% × 0.88 × 6.25
2019/12/31 37.38% = 8.61% × 0.87 × 4.97
2019/09/30 34.64% = 7.81% × 0.86 × 5.19
2019/06/30 31.25% = 6.61% × 0.84 × 5.65
2019/03/31 31.90% = 6.27% × 0.84 × 6.06
2018/12/31 29.72% = 6.32% × 0.92 × 5.13
2018/09/30 47.93% = 10.92% × 0.87 × 5.03
2018/06/30 49.84% = 10.84% × 0.85 × 5.38
2018/03/31 48.33% = 11.02% × 0.79 × 5.52
2017/12/31 48.00% = 11.83% × 0.75 × 5.41
2017/09/30 — = — × — × 7.58
2017/06/30 — = — × — × 8.66
2017/03/31 — = — × — × 3.38

レポートに基づく: 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).

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

ROEを5つの要素に分解

Sherwin-Williams Co.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 税負担 × 利息負担 × EBITマージン × 資産回転率 × 財務レバレッジ比率
2022/06/30 78.89% = 0.83 × 0.86 × 11.89% × 0.94 × 9.91
2022/03/31 81.71% = 0.83 × 0.87 × 12.52% × 0.93 × 9.73
2021/12/31 76.50% = 0.83 × 0.87 × 12.95% × 0.97 × 8.48
2021/09/30 73.13% = 0.81 × 0.88 × 14.11% × 0.95 × 7.71
2021/06/30 76.43% = 0.80 × 0.89 × 15.48% × 0.96 × 7.22
2021/03/31 68.81% = 0.80 × 0.89 × 15.76% × 0.92 × 6.64
2020/12/31 56.23% = 0.81 × 0.88 × 15.57% × 0.90 × 5.65
2020/09/30 44.49% = 0.81 × 0.87 × 14.76% × 0.86 × 4.95
2020/06/30 45.03% = 0.81 × 0.86 × 14.04% × 0.87 × 5.30
2020/03/31 49.19% = 0.78 × 0.86 × 13.44% × 0.88 × 6.25
2019/12/31 37.38% = 0.78 × 0.85 × 13.02% × 0.87 × 4.97
2019/09/30 34.64% = 0.78 × 0.83 × 12.00% × 0.86 × 5.19
2019/06/30 31.25% = 0.78 × 0.80 × 10.47% × 0.84 × 5.65
2019/03/31 31.90% = 0.81 × 0.79 × 9.77% × 0.84 × 6.06
2018/12/31 29.72% = 0.82 × 0.79 × 9.85% × 0.92 × 5.13
2018/09/30 47.93% = 1.24 × 0.81 × 10.94% × 0.87 × 5.03
2018/06/30 49.84% = 1.20 × 0.81 × 11.15% × 0.85 × 5.38
2018/03/31 48.33% = 1.20 × 0.82 × 11.20% × 0.79 × 5.52
2017/12/31 48.00% = 1.19 × 0.85 × 11.68% × 0.75 × 5.41
2017/09/30 — = — × — × — × — × 7.58
2017/06/30 — = — × — × — × — × 8.66
2017/03/31 — = — × — × — × — × 3.38

レポートに基づく: 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).

2022年第2 四半期に比べて株主資本利益率(ROE)が低下した主な理由は、EBITマージン率で測定した営業収益性の低下です。

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

Sherwin-Williams Co.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 純利益率 × 資産回転率
2022/06/30 7.96% = 8.45% × 0.94
2022/03/31 8.40% = 9.00% × 0.93
2021/12/31 9.02% = 9.35% × 0.97
2021/09/30 9.49% = 10.00% × 0.95
2021/06/30 10.58% = 11.05% × 0.96
2021/03/31 10.37% = 11.23% × 0.92
2020/12/31 9.95% = 11.06% × 0.90
2020/09/30 9.00% = 10.41% × 0.86
2020/06/30 8.50% = 9.83% × 0.87
2020/03/31 7.86% = 8.98% × 0.88
2019/12/31 7.52% = 8.61% × 0.87
2019/09/30 6.68% = 7.81% × 0.86
2019/06/30 5.53% = 6.61% × 0.84
2019/03/31 5.27% = 6.27% × 0.84
2018/12/31 5.79% = 6.32% × 0.92
2018/09/30 9.53% = 10.92% × 0.87
2018/06/30 9.27% = 10.84% × 0.85
2018/03/31 8.76% = 11.02% × 0.79
2017/12/31 8.88% = 11.83% × 0.75
2017/09/30 — = — × —
2017/06/30 — = — × —
2017/03/31 — = — × —

レポートに基づく: 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).

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

ROAを4つの要素に分解

Sherwin-Williams Co.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 税負担 × 利息負担 × EBITマージン × 資産回転率
2022/06/30 7.96% = 0.83 × 0.86 × 11.89% × 0.94
2022/03/31 8.40% = 0.83 × 0.87 × 12.52% × 0.93
2021/12/31 9.02% = 0.83 × 0.87 × 12.95% × 0.97
2021/09/30 9.49% = 0.81 × 0.88 × 14.11% × 0.95
2021/06/30 10.58% = 0.80 × 0.89 × 15.48% × 0.96
2021/03/31 10.37% = 0.80 × 0.89 × 15.76% × 0.92
2020/12/31 9.95% = 0.81 × 0.88 × 15.57% × 0.90
2020/09/30 9.00% = 0.81 × 0.87 × 14.76% × 0.86
2020/06/30 8.50% = 0.81 × 0.86 × 14.04% × 0.87
2020/03/31 7.86% = 0.78 × 0.86 × 13.44% × 0.88
2019/12/31 7.52% = 0.78 × 0.85 × 13.02% × 0.87
2019/09/30 6.68% = 0.78 × 0.83 × 12.00% × 0.86
2019/06/30 5.53% = 0.78 × 0.80 × 10.47% × 0.84
2019/03/31 5.27% = 0.81 × 0.79 × 9.77% × 0.84
2018/12/31 5.79% = 0.82 × 0.79 × 9.85% × 0.92
2018/09/30 9.53% = 1.24 × 0.81 × 10.94% × 0.87
2018/06/30 9.27% = 1.20 × 0.81 × 11.15% × 0.85
2018/03/31 8.76% = 1.20 × 0.82 × 11.20% × 0.79
2017/12/31 8.88% = 1.19 × 0.85 × 11.68% × 0.75
2017/09/30 — = — × — × — × —
2017/06/30 — = — × — × — × —
2017/03/31 — = — × — × — × —

レポートに基づく: 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).

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

純利益率の分解

Sherwin-Williams Co.、純利益率の分解(四半期データ)

Microsoft Excel
純利益率 = 税負担 × 利息負担 × EBITマージン
2022/06/30 8.45% = 0.83 × 0.86 × 11.89%
2022/03/31 9.00% = 0.83 × 0.87 × 12.52%
2021/12/31 9.35% = 0.83 × 0.87 × 12.95%
2021/09/30 10.00% = 0.81 × 0.88 × 14.11%
2021/06/30 11.05% = 0.80 × 0.89 × 15.48%
2021/03/31 11.23% = 0.80 × 0.89 × 15.76%
2020/12/31 11.06% = 0.81 × 0.88 × 15.57%
2020/09/30 10.41% = 0.81 × 0.87 × 14.76%
2020/06/30 9.83% = 0.81 × 0.86 × 14.04%
2020/03/31 8.98% = 0.78 × 0.86 × 13.44%
2019/12/31 8.61% = 0.78 × 0.85 × 13.02%
2019/09/30 7.81% = 0.78 × 0.83 × 12.00%
2019/06/30 6.61% = 0.78 × 0.80 × 10.47%
2019/03/31 6.27% = 0.81 × 0.79 × 9.77%
2018/12/31 6.32% = 0.82 × 0.79 × 9.85%
2018/09/30 10.92% = 1.24 × 0.81 × 10.94%
2018/06/30 10.84% = 1.20 × 0.81 × 11.15%
2018/03/31 11.02% = 1.20 × 0.82 × 11.20%
2017/12/31 11.83% = 1.19 × 0.85 × 11.68%
2017/09/30 — = — × — × —
2017/06/30 — = — × — × —
2017/03/31 — = — × — × —

レポートに基づく: 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).

2022年第2 四半期に純利益率が低下した主な理由は、EBITマージン比率で測定した営業利益率の低下です。