Stock Analysis on Net
Stock Analysis on Net

Express Scripts Holding Co. (NASDAQ:ESRX)

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

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

Microsoft Excel

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

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

Express Scripts Holding Co.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2018/09/30 23.82% = 8.84% × 2.70
2018/06/30 24.11% = 8.54% × 2.82
2018/03/31 24.91% = 8.60% × 2.90
2017/12/31 24.93% = 8.33% × 2.99
2017/09/30 22.77% = 7.08% × 3.22
2017/06/30 22.27% = 6.94% × 3.21
2017/03/31 21.51% = 6.71% × 3.21
2016/12/31 20.97% = 6.58% × 3.19
2016/09/30 17.58% = 5.39% × 3.26
2016/06/30 17.41% = 5.27% × 3.30
2016/03/31 17.26% = 5.01% × 3.44
2015/12/31 14.25% = 4.65% × 3.06
2015/09/30 13.81% = 4.39% × 3.14
2015/06/30 13.94% = 4.25% × 3.28
2015/03/31 10.29% = 4.09% × 2.52
2014/12/31 10.01% = 3.73% × 2.68
2014/09/30 9.56% = 3.61% × 2.65
2014/06/30 8.66% = 3.24% × 2.67
2014/03/31 8.23% = 3.41% × 2.41
2013/12/31 8.45% = 3.44% × 2.45
2013/09/30 — = — × 2.31
2013/06/30 — = — × 2.29
2013/03/31 — = — × 2.35

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

2018年第3 四半期の株主資本利益率(ROE)が低下した主な理由は、財務レバレッジ比率の低下です。

ROEを3つの要素に分解

Express Scripts Holding Co.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2018/09/30 23.82% = 4.83% × 1.83 × 2.70
2018/06/30 24.11% = 4.65% × 1.84 × 2.82
2018/03/31 24.91% = 4.59% × 1.88 × 2.90
2017/12/31 24.93% = 4.51% × 1.84 × 2.99
2017/09/30 22.77% = 3.64% × 1.94 × 3.22
2017/06/30 22.27% = 3.50% × 1.99 × 3.21
2017/03/31 21.51% = 3.42% × 1.96 × 3.21
2016/12/31 20.97% = 3.39% × 1.94 × 3.19
2016/09/30 17.58% = 2.70% × 2.00 × 3.26
2016/06/30 17.41% = 2.64% × 1.99 × 3.30
2016/03/31 17.26% = 2.52% × 1.99 × 3.44
2015/12/31 14.25% = 2.43% × 1.91 × 3.06
2015/09/30 13.81% = 2.24% × 1.96 × 3.14
2015/06/30 13.94% = 2.15% × 1.98 × 3.28
2015/03/31 10.29% = 2.08% × 1.97 × 2.52
2014/12/31 10.01% = 1.99% × 1.88 × 2.68
2014/09/30 9.56% = 1.92% × 1.88 × 2.65
2014/06/30 8.66% = 1.76% × 1.84 × 2.67
2014/03/31 8.23% = 1.77% × 1.93 × 2.41
2013/12/31 8.45% = 1.77% × 1.94 × 2.45
2013/09/30 — = — × — × 2.31
2013/06/30 — = — × — × 2.29
2013/03/31 — = — × — × 2.35

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

2018年第3 四半期の株主資本利益率(ROE)が低下した主な理由は、財務レバレッジ比率の低下です。

ROEを5つの要素に分解

Express Scripts Holding Co.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 税負担 × 利息負担 × EBITマージン × 資産回転率 × 財務レバレッジ比率
2018/09/30 23.82% = 1.03 × 0.88 × 5.31% × 1.83 × 2.70
2018/06/30 24.11% = 0.98 × 0.88 × 5.35% × 1.84 × 2.82
2018/03/31 24.91% = 0.95 × 0.89 × 5.43% × 1.88 × 2.90
2017/12/31 24.93% = 0.92 × 0.89 × 5.52% × 1.84 × 2.99
2017/09/30 22.77% = 0.75 × 0.89 × 5.43% × 1.94 × 3.22
2017/06/30 22.27% = 0.76 × 0.87 × 5.32% × 1.99 × 3.21
2017/03/31 21.51% = 0.76 × 0.87 × 5.20% × 1.96 × 3.21
2016/12/31 20.97% = 0.77 × 0.86 × 5.08% × 1.94 × 3.19
2016/09/30 17.58% = 0.66 × 0.86 × 4.76% × 2.00 × 3.26
2016/06/30 17.41% = 0.66 × 0.89 × 4.52% × 1.99 × 3.30
2016/03/31 17.26% = 0.65 × 0.88 × 4.39% × 1.99 × 3.44
2015/12/31 14.25% = 0.64 × 0.88 × 4.27% × 1.91 × 3.06
2015/09/30 13.81% = 0.64 × 0.88 × 4.00% × 1.96 × 3.14
2015/06/30 13.94% = 0.66 × 0.85 × 3.80% × 1.98 × 3.28
2015/03/31 10.29% = 0.67 × 0.85 × 3.66% × 1.97 × 2.52
2014/12/31 10.01% = 0.66 × 0.84 × 3.59% × 1.88 × 2.68
2014/09/30 9.56% = 0.66 × 0.83 × 3.50% × 1.88 × 2.65
2014/06/30 8.66% = 0.61 × 0.85 × 3.38% × 1.84 × 2.67
2014/03/31 8.23% = 0.62 × 0.85 × 3.35% × 1.93 × 2.41
2013/12/31 8.45% = 0.63 × 0.83 × 3.41% × 1.94 × 2.45
2013/09/30 — = — × — × — × — × 2.31
2013/06/30 — = — × — × — × — × 2.29
2013/03/31 — = — × — × — × — × 2.35

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

2018年第3 四半期の株主資本利益率(ROE)が低下した主な理由は、財務レバレッジ比率の低下です。

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

Express Scripts Holding Co.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 純利益率 × 資産回転率
2018/09/30 8.84% = 4.83% × 1.83
2018/06/30 8.54% = 4.65% × 1.84
2018/03/31 8.60% = 4.59% × 1.88
2017/12/31 8.33% = 4.51% × 1.84
2017/09/30 7.08% = 3.64% × 1.94
2017/06/30 6.94% = 3.50% × 1.99
2017/03/31 6.71% = 3.42% × 1.96
2016/12/31 6.58% = 3.39% × 1.94
2016/09/30 5.39% = 2.70% × 2.00
2016/06/30 5.27% = 2.64% × 1.99
2016/03/31 5.01% = 2.52% × 1.99
2015/12/31 4.65% = 2.43% × 1.91
2015/09/30 4.39% = 2.24% × 1.96
2015/06/30 4.25% = 2.15% × 1.98
2015/03/31 4.09% = 2.08% × 1.97
2014/12/31 3.73% = 1.99% × 1.88
2014/09/30 3.61% = 1.92% × 1.88
2014/06/30 3.24% = 1.76% × 1.84
2014/03/31 3.41% = 1.77% × 1.93
2013/12/31 3.44% = 1.77% × 1.94
2013/09/30 — = — × —
2013/06/30 — = — × —
2013/03/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), 10-K (報告日: 2016-12-31), 10-Q (報告日: 2016-09-30), 10-Q (報告日: 2016-06-30), 10-Q (報告日: 2016-03-31), 10-K (報告日: 2015-12-31), 10-Q (報告日: 2015-09-30), 10-Q (報告日: 2015-06-30), 10-Q (報告日: 2015-03-31), 10-K (報告日: 2014-12-31), 10-Q (報告日: 2014-09-30), 10-Q (報告日: 2014-06-30), 10-Q (報告日: 2014-03-31), 10-K (報告日: 2013-12-31), 10-Q (報告日: 2013-09-30), 10-Q (報告日: 2013-06-30), 10-Q (報告日: 2013-03-31).

2018年第3 四半期の総資産利益率(ROA)が上昇した主な理由は、純利益率で測定した収益性の向上です。

ROAを4つの要素に分解

Express Scripts Holding Co.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 税負担 × 利息負担 × EBITマージン × 資産回転率
2018/09/30 8.84% = 1.03 × 0.88 × 5.31% × 1.83
2018/06/30 8.54% = 0.98 × 0.88 × 5.35% × 1.84
2018/03/31 8.60% = 0.95 × 0.89 × 5.43% × 1.88
2017/12/31 8.33% = 0.92 × 0.89 × 5.52% × 1.84
2017/09/30 7.08% = 0.75 × 0.89 × 5.43% × 1.94
2017/06/30 6.94% = 0.76 × 0.87 × 5.32% × 1.99
2017/03/31 6.71% = 0.76 × 0.87 × 5.20% × 1.96
2016/12/31 6.58% = 0.77 × 0.86 × 5.08% × 1.94
2016/09/30 5.39% = 0.66 × 0.86 × 4.76% × 2.00
2016/06/30 5.27% = 0.66 × 0.89 × 4.52% × 1.99
2016/03/31 5.01% = 0.65 × 0.88 × 4.39% × 1.99
2015/12/31 4.65% = 0.64 × 0.88 × 4.27% × 1.91
2015/09/30 4.39% = 0.64 × 0.88 × 4.00% × 1.96
2015/06/30 4.25% = 0.66 × 0.85 × 3.80% × 1.98
2015/03/31 4.09% = 0.67 × 0.85 × 3.66% × 1.97
2014/12/31 3.73% = 0.66 × 0.84 × 3.59% × 1.88
2014/09/30 3.61% = 0.66 × 0.83 × 3.50% × 1.88
2014/06/30 3.24% = 0.61 × 0.85 × 3.38% × 1.84
2014/03/31 3.41% = 0.62 × 0.85 × 3.35% × 1.93
2013/12/31 3.44% = 0.63 × 0.83 × 3.41% × 1.94
2013/09/30 — = — × — × — × —
2013/06/30 — = — × — × — × —
2013/03/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), 10-K (報告日: 2016-12-31), 10-Q (報告日: 2016-09-30), 10-Q (報告日: 2016-06-30), 10-Q (報告日: 2016-03-31), 10-K (報告日: 2015-12-31), 10-Q (報告日: 2015-09-30), 10-Q (報告日: 2015-06-30), 10-Q (報告日: 2015-03-31), 10-K (報告日: 2014-12-31), 10-Q (報告日: 2014-09-30), 10-Q (報告日: 2014-06-30), 10-Q (報告日: 2014-03-31), 10-K (報告日: 2013-12-31), 10-Q (報告日: 2013-09-30), 10-Q (報告日: 2013-06-30), 10-Q (報告日: 2013-03-31).

2018年第3 四半期の総資産利益率(ROA)が上昇した主な理由は、税負担率で測定した税の影響の増加です。

純利益率の分解

Express Scripts Holding Co.、純利益率の分解(四半期データ)

Microsoft Excel
純利益率 = 税負担 × 利息負担 × EBITマージン
2018/09/30 4.83% = 1.03 × 0.88 × 5.31%
2018/06/30 4.65% = 0.98 × 0.88 × 5.35%
2018/03/31 4.59% = 0.95 × 0.89 × 5.43%
2017/12/31 4.51% = 0.92 × 0.89 × 5.52%
2017/09/30 3.64% = 0.75 × 0.89 × 5.43%
2017/06/30 3.50% = 0.76 × 0.87 × 5.32%
2017/03/31 3.42% = 0.76 × 0.87 × 5.20%
2016/12/31 3.39% = 0.77 × 0.86 × 5.08%
2016/09/30 2.70% = 0.66 × 0.86 × 4.76%
2016/06/30 2.64% = 0.66 × 0.89 × 4.52%
2016/03/31 2.52% = 0.65 × 0.88 × 4.39%
2015/12/31 2.43% = 0.64 × 0.88 × 4.27%
2015/09/30 2.24% = 0.64 × 0.88 × 4.00%
2015/06/30 2.15% = 0.66 × 0.85 × 3.80%
2015/03/31 2.08% = 0.67 × 0.85 × 3.66%
2014/12/31 1.99% = 0.66 × 0.84 × 3.59%
2014/09/30 1.92% = 0.66 × 0.83 × 3.50%
2014/06/30 1.76% = 0.61 × 0.85 × 3.38%
2014/03/31 1.77% = 0.62 × 0.85 × 3.35%
2013/12/31 1.77% = 0.63 × 0.83 × 3.41%
2013/09/30 — = — × — × —
2013/06/30 — = — × — × —
2013/03/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), 10-K (報告日: 2016-12-31), 10-Q (報告日: 2016-09-30), 10-Q (報告日: 2016-06-30), 10-Q (報告日: 2016-03-31), 10-K (報告日: 2015-12-31), 10-Q (報告日: 2015-09-30), 10-Q (報告日: 2015-06-30), 10-Q (報告日: 2015-03-31), 10-K (報告日: 2014-12-31), 10-Q (報告日: 2014-09-30), 10-Q (報告日: 2014-06-30), 10-Q (報告日: 2014-03-31), 10-K (報告日: 2013-12-31), 10-Q (報告日: 2013-09-30), 10-Q (報告日: 2013-06-30), 10-Q (報告日: 2013-03-31).

2018年第3 四半期に比べて純利益率が上昇した主な理由は、税負担率で測定した税効果の増加です。