Stock Analysis on Net

Walgreens Boots Alliance Inc. (NASDAQ:WBA)

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

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

Microsoft Excel

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

Walgreens Boots Alliance Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2020/05/31 3.67% = 0.88% × 4.17
2020/02/29 14.73% = 3.88% × 3.79
2019/11/30 15.65% = 4.08% × 3.84
2019/08/31 16.94% = 5.89% × 2.88
2019/05/31 19.96% = 7.02% × 2.84
2019/02/28 20.72% = 7.29% × 2.84
2018/11/30 20.80% = 7.61% × 2.73
2018/08/31 19.32% = 7.37% × 2.62
2018/05/31 15.55% = 6.15% × 2.53
2018/02/28 15.11% = 5.84% × 2.59
2017/11/30 14.83% = 5.77% × 2.57
2017/08/31 14.85% = 6.18% × 2.40
2017/05/31 14.07% = 5.81% × 2.42
2017/02/28 14.13% = 5.86% × 2.41
2016/11/30 14.04% = 5.73% × 2.45
2016/08/31 13.97% = 5.74% × 2.43
2016/05/31 10.26% = 4.71% × 2.18
2016/02/29 11.41% = 5.07% × 2.25
2015/11/30 14.59% = 6.53% × 2.24
2015/08/31 13.67% = 6.14% × 2.23
2015/05/31 12.53% = 5.60% × 2.24
2015/02/28 10.95% = 4.73% × 2.32
2014/11/30 10.11% = 4.29% × 2.36
2014/08/31 9.44% = 5.20% × 1.82
2014/05/31 = × 1.75
2014/02/28 = × 1.78
2013/11/30 = × 1.82

レポートに基づく: 10-Q (報告日: 2020-05-31), 10-Q (報告日: 2020-02-29), 10-Q (報告日: 2019-11-30), 10-K (報告日: 2019-08-31), 10-Q (報告日: 2019-05-31), 10-Q (報告日: 2019-02-28), 10-Q (報告日: 2018-11-30), 10-K (報告日: 2018-08-31), 10-Q (報告日: 2018-05-31), 10-Q (報告日: 2018-02-28), 10-Q (報告日: 2017-11-30), 10-K (報告日: 2017-08-31), 10-Q (報告日: 2017-05-31), 10-Q (報告日: 2017-02-28), 10-Q (報告日: 2016-11-30), 10-K (報告日: 2016-08-31), 10-Q (報告日: 2016-05-31), 10-Q (報告日: 2016-02-29), 10-Q (報告日: 2015-11-30), 10-K (報告日: 2015-08-31), 10-Q (報告日: 2015-05-31), 10-Q (報告日: 2015-02-28), 10-Q (報告日: 2014-11-30), 10-K (報告日: 2014-08-31), 10-Q (報告日: 2014-05-31), 10-Q (報告日: 2014-02-28), 10-Q (報告日: 2013-11-30).

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


ROEを3つの要素に分解

Walgreens Boots Alliance Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2020/05/31 3.67% = 0.55% × 1.61 × 4.17
2020/02/29 14.73% = 2.52% × 1.54 × 3.79
2019/11/30 15.65% = 2.70% × 1.51 × 3.84
2019/08/31 16.94% = 2.91% × 2.02 × 2.88
2019/05/31 19.96% = 3.53% × 1.99 × 2.84
2019/02/28 20.72% = 3.77% × 1.93 × 2.84
2018/11/30 20.80% = 3.96% × 1.92 × 2.73
2018/08/31 19.32% = 3.82% × 1.93 × 2.62
2018/05/31 15.55% = 3.36% × 1.83 × 2.53
2018/02/28 15.11% = 3.33% × 1.75 × 2.59
2017/11/30 14.83% = 3.19% × 1.81 × 2.57
2017/08/31 14.85% = 3.45% × 1.79 × 2.40
2017/05/31 14.07% = 3.69% × 1.57 × 2.42
2017/02/28 14.13% = 3.66% × 1.60 × 2.41
2016/11/30 14.04% = 3.52% × 1.62 × 2.45
2016/08/31 13.97% = 3.56% × 1.61 × 2.43
2016/05/31 10.26% = 2.70% × 1.74 × 2.18
2016/02/29 11.41% = 2.89% × 1.76 × 2.25
2015/11/30 14.59% = 3.97% × 1.64 × 2.24
2015/08/31 13.67% = 4.08% × 1.50 × 2.23
2015/05/31 12.53% = 4.21% × 1.33 × 2.24
2015/02/28 10.95% = 3.99% × 1.19 × 2.32
2014/11/30 10.11% = 2.69% × 1.60 × 2.36
2014/08/31 9.44% = 2.53% × 2.05 × 1.82
2014/05/31 = × × 1.75
2014/02/28 = × × 1.78
2013/11/30 = × × 1.82

レポートに基づく: 10-Q (報告日: 2020-05-31), 10-Q (報告日: 2020-02-29), 10-Q (報告日: 2019-11-30), 10-K (報告日: 2019-08-31), 10-Q (報告日: 2019-05-31), 10-Q (報告日: 2019-02-28), 10-Q (報告日: 2018-11-30), 10-K (報告日: 2018-08-31), 10-Q (報告日: 2018-05-31), 10-Q (報告日: 2018-02-28), 10-Q (報告日: 2017-11-30), 10-K (報告日: 2017-08-31), 10-Q (報告日: 2017-05-31), 10-Q (報告日: 2017-02-28), 10-Q (報告日: 2016-11-30), 10-K (報告日: 2016-08-31), 10-Q (報告日: 2016-05-31), 10-Q (報告日: 2016-02-29), 10-Q (報告日: 2015-11-30), 10-K (報告日: 2015-08-31), 10-Q (報告日: 2015-05-31), 10-Q (報告日: 2015-02-28), 10-Q (報告日: 2014-11-30), 10-K (報告日: 2014-08-31), 10-Q (報告日: 2014-05-31), 10-Q (報告日: 2014-02-28), 10-Q (報告日: 2013-11-30).

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


ROEを5つの要素に分解

Walgreens Boots Alliance Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 税負担 × 利息負担 × EBITマージン × 資産回転率 × 財務レバレッジ比率
2020/05/31 3.67% = 0.81 × 0.59 × 1.15% × 1.61 × 4.17
2020/02/29 14.73% = 0.90 × 0.85 × 3.29% × 1.54 × 3.79
2019/11/30 15.65% = 0.89 × 0.85 × 3.53% × 1.51 × 3.84
2019/08/31 16.94% = 0.87 × 0.87 × 3.85% × 2.02 × 2.88
2019/05/31 19.96% = 0.87 × 0.89 × 4.56% × 1.99 × 2.84
2019/02/28 20.72% = 0.88 × 0.90 × 4.75% × 1.93 × 2.84
2018/11/30 20.80% = 0.85 × 0.91 × 5.13% × 1.92 × 2.73
2018/08/31 19.32% = 0.83 × 0.91 × 5.05% × 1.93 × 2.62
2018/05/31 15.55% = 0.82 × 0.89 × 4.62% × 1.83 × 2.53
2018/02/28 15.11% = 0.80 × 0.89 × 4.68% × 1.75 × 2.59
2017/11/30 14.83% = 0.83 × 0.87 × 4.38% × 1.81 × 2.57
2017/08/31 14.85% = 0.84 × 0.87 × 4.68% × 1.79 × 2.40
2017/05/31 14.07% = 0.84 × 0.88 × 4.99% × 1.57 × 2.42
2017/02/28 14.13% = 0.81 × 0.89 × 5.09% × 1.60 × 2.41
2016/11/30 14.04% = 0.80 × 0.89 × 4.96% × 1.62 × 2.45
2016/08/31 13.97% = 0.81 × 0.90 × 4.91% × 1.61 × 2.43
2016/05/31 10.26% = 0.81 × 0.85 × 3.90% × 1.74 × 2.18
2016/02/29 11.41% = 0.81 × 0.86 × 4.17% × 1.76 × 2.25
2015/11/30 14.59% = 0.83 × 0.89 × 5.38% × 1.64 × 2.24
2015/08/31 13.67% = 0.80 × 0.90 × 5.69% × 1.50 × 2.23
2015/05/31 12.53% = 0.73 × 0.93 × 6.20% × 1.33 × 2.24
2015/02/28 10.95% = 0.70 × 0.95 × 6.00% × 1.19 × 2.32
2014/11/30 10.11% = 0.59 × 0.95 × 4.77% × 1.60 × 2.36
2014/08/31 9.44% = 0.56 × 0.96 × 4.73% × 2.05 × 1.82
2014/05/31 = × × × × 1.75
2014/02/28 = × × × × 1.78
2013/11/30 = × × × × 1.82

レポートに基づく: 10-Q (報告日: 2020-05-31), 10-Q (報告日: 2020-02-29), 10-Q (報告日: 2019-11-30), 10-K (報告日: 2019-08-31), 10-Q (報告日: 2019-05-31), 10-Q (報告日: 2019-02-28), 10-Q (報告日: 2018-11-30), 10-K (報告日: 2018-08-31), 10-Q (報告日: 2018-05-31), 10-Q (報告日: 2018-02-28), 10-Q (報告日: 2017-11-30), 10-K (報告日: 2017-08-31), 10-Q (報告日: 2017-05-31), 10-Q (報告日: 2017-02-28), 10-Q (報告日: 2016-11-30), 10-K (報告日: 2016-08-31), 10-Q (報告日: 2016-05-31), 10-Q (報告日: 2016-02-29), 10-Q (報告日: 2015-11-30), 10-K (報告日: 2015-08-31), 10-Q (報告日: 2015-05-31), 10-Q (報告日: 2015-02-28), 10-Q (報告日: 2014-11-30), 10-K (報告日: 2014-08-31), 10-Q (報告日: 2014-05-31), 10-Q (報告日: 2014-02-28), 10-Q (報告日: 2013-11-30).

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


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

Walgreens Boots Alliance Inc.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 純利益率 × 資産回転率
2020/05/31 0.88% = 0.55% × 1.61
2020/02/29 3.88% = 2.52% × 1.54
2019/11/30 4.08% = 2.70% × 1.51
2019/08/31 5.89% = 2.91% × 2.02
2019/05/31 7.02% = 3.53% × 1.99
2019/02/28 7.29% = 3.77% × 1.93
2018/11/30 7.61% = 3.96% × 1.92
2018/08/31 7.37% = 3.82% × 1.93
2018/05/31 6.15% = 3.36% × 1.83
2018/02/28 5.84% = 3.33% × 1.75
2017/11/30 5.77% = 3.19% × 1.81
2017/08/31 6.18% = 3.45% × 1.79
2017/05/31 5.81% = 3.69% × 1.57
2017/02/28 5.86% = 3.66% × 1.60
2016/11/30 5.73% = 3.52% × 1.62
2016/08/31 5.74% = 3.56% × 1.61
2016/05/31 4.71% = 2.70% × 1.74
2016/02/29 5.07% = 2.89% × 1.76
2015/11/30 6.53% = 3.97% × 1.64
2015/08/31 6.14% = 4.08% × 1.50
2015/05/31 5.60% = 4.21% × 1.33
2015/02/28 4.73% = 3.99% × 1.19
2014/11/30 4.29% = 2.69% × 1.60
2014/08/31 5.20% = 2.53% × 2.05
2014/05/31 = ×
2014/02/28 = ×
2013/11/30 = ×

レポートに基づく: 10-Q (報告日: 2020-05-31), 10-Q (報告日: 2020-02-29), 10-Q (報告日: 2019-11-30), 10-K (報告日: 2019-08-31), 10-Q (報告日: 2019-05-31), 10-Q (報告日: 2019-02-28), 10-Q (報告日: 2018-11-30), 10-K (報告日: 2018-08-31), 10-Q (報告日: 2018-05-31), 10-Q (報告日: 2018-02-28), 10-Q (報告日: 2017-11-30), 10-K (報告日: 2017-08-31), 10-Q (報告日: 2017-05-31), 10-Q (報告日: 2017-02-28), 10-Q (報告日: 2016-11-30), 10-K (報告日: 2016-08-31), 10-Q (報告日: 2016-05-31), 10-Q (報告日: 2016-02-29), 10-Q (報告日: 2015-11-30), 10-K (報告日: 2015-08-31), 10-Q (報告日: 2015-05-31), 10-Q (報告日: 2015-02-28), 10-Q (報告日: 2014-11-30), 10-K (報告日: 2014-08-31), 10-Q (報告日: 2014-05-31), 10-Q (報告日: 2014-02-28), 10-Q (報告日: 2013-11-30).

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


ROAを4つの要素に分解

Walgreens Boots Alliance Inc.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 税負担 × 利息負担 × EBITマージン × 資産回転率
2020/05/31 0.88% = 0.81 × 0.59 × 1.15% × 1.61
2020/02/29 3.88% = 0.90 × 0.85 × 3.29% × 1.54
2019/11/30 4.08% = 0.89 × 0.85 × 3.53% × 1.51
2019/08/31 5.89% = 0.87 × 0.87 × 3.85% × 2.02
2019/05/31 7.02% = 0.87 × 0.89 × 4.56% × 1.99
2019/02/28 7.29% = 0.88 × 0.90 × 4.75% × 1.93
2018/11/30 7.61% = 0.85 × 0.91 × 5.13% × 1.92
2018/08/31 7.37% = 0.83 × 0.91 × 5.05% × 1.93
2018/05/31 6.15% = 0.82 × 0.89 × 4.62% × 1.83
2018/02/28 5.84% = 0.80 × 0.89 × 4.68% × 1.75
2017/11/30 5.77% = 0.83 × 0.87 × 4.38% × 1.81
2017/08/31 6.18% = 0.84 × 0.87 × 4.68% × 1.79
2017/05/31 5.81% = 0.84 × 0.88 × 4.99% × 1.57
2017/02/28 5.86% = 0.81 × 0.89 × 5.09% × 1.60
2016/11/30 5.73% = 0.80 × 0.89 × 4.96% × 1.62
2016/08/31 5.74% = 0.81 × 0.90 × 4.91% × 1.61
2016/05/31 4.71% = 0.81 × 0.85 × 3.90% × 1.74
2016/02/29 5.07% = 0.81 × 0.86 × 4.17% × 1.76
2015/11/30 6.53% = 0.83 × 0.89 × 5.38% × 1.64
2015/08/31 6.14% = 0.80 × 0.90 × 5.69% × 1.50
2015/05/31 5.60% = 0.73 × 0.93 × 6.20% × 1.33
2015/02/28 4.73% = 0.70 × 0.95 × 6.00% × 1.19
2014/11/30 4.29% = 0.59 × 0.95 × 4.77% × 1.60
2014/08/31 5.20% = 0.56 × 0.96 × 4.73% × 2.05
2014/05/31 = × × ×
2014/02/28 = × × ×
2013/11/30 = × × ×

レポートに基づく: 10-Q (報告日: 2020-05-31), 10-Q (報告日: 2020-02-29), 10-Q (報告日: 2019-11-30), 10-K (報告日: 2019-08-31), 10-Q (報告日: 2019-05-31), 10-Q (報告日: 2019-02-28), 10-Q (報告日: 2018-11-30), 10-K (報告日: 2018-08-31), 10-Q (報告日: 2018-05-31), 10-Q (報告日: 2018-02-28), 10-Q (報告日: 2017-11-30), 10-K (報告日: 2017-08-31), 10-Q (報告日: 2017-05-31), 10-Q (報告日: 2017-02-28), 10-Q (報告日: 2016-11-30), 10-K (報告日: 2016-08-31), 10-Q (報告日: 2016-05-31), 10-Q (報告日: 2016-02-29), 10-Q (報告日: 2015-11-30), 10-K (報告日: 2015-08-31), 10-Q (報告日: 2015-05-31), 10-Q (報告日: 2015-02-28), 10-Q (報告日: 2014-11-30), 10-K (報告日: 2014-08-31), 10-Q (報告日: 2014-05-31), 10-Q (報告日: 2014-02-28), 10-Q (報告日: 2013-11-30).

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


純利益率の分解

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

Microsoft Excel
純利益率 = 税負担 × 利息負担 × EBITマージン
2020/05/31 0.55% = 0.81 × 0.59 × 1.15%
2020/02/29 2.52% = 0.90 × 0.85 × 3.29%
2019/11/30 2.70% = 0.89 × 0.85 × 3.53%
2019/08/31 2.91% = 0.87 × 0.87 × 3.85%
2019/05/31 3.53% = 0.87 × 0.89 × 4.56%
2019/02/28 3.77% = 0.88 × 0.90 × 4.75%
2018/11/30 3.96% = 0.85 × 0.91 × 5.13%
2018/08/31 3.82% = 0.83 × 0.91 × 5.05%
2018/05/31 3.36% = 0.82 × 0.89 × 4.62%
2018/02/28 3.33% = 0.80 × 0.89 × 4.68%
2017/11/30 3.19% = 0.83 × 0.87 × 4.38%
2017/08/31 3.45% = 0.84 × 0.87 × 4.68%
2017/05/31 3.69% = 0.84 × 0.88 × 4.99%
2017/02/28 3.66% = 0.81 × 0.89 × 5.09%
2016/11/30 3.52% = 0.80 × 0.89 × 4.96%
2016/08/31 3.56% = 0.81 × 0.90 × 4.91%
2016/05/31 2.70% = 0.81 × 0.85 × 3.90%
2016/02/29 2.89% = 0.81 × 0.86 × 4.17%
2015/11/30 3.97% = 0.83 × 0.89 × 5.38%
2015/08/31 4.08% = 0.80 × 0.90 × 5.69%
2015/05/31 4.21% = 0.73 × 0.93 × 6.20%
2015/02/28 3.99% = 0.70 × 0.95 × 6.00%
2014/11/30 2.69% = 0.59 × 0.95 × 4.77%
2014/08/31 2.53% = 0.56 × 0.96 × 4.73%
2014/05/31 = × ×
2014/02/28 = × ×
2013/11/30 = × ×

レポートに基づく: 10-Q (報告日: 2020-05-31), 10-Q (報告日: 2020-02-29), 10-Q (報告日: 2019-11-30), 10-K (報告日: 2019-08-31), 10-Q (報告日: 2019-05-31), 10-Q (報告日: 2019-02-28), 10-Q (報告日: 2018-11-30), 10-K (報告日: 2018-08-31), 10-Q (報告日: 2018-05-31), 10-Q (報告日: 2018-02-28), 10-Q (報告日: 2017-11-30), 10-K (報告日: 2017-08-31), 10-Q (報告日: 2017-05-31), 10-Q (報告日: 2017-02-28), 10-Q (報告日: 2016-11-30), 10-K (報告日: 2016-08-31), 10-Q (報告日: 2016-05-31), 10-Q (報告日: 2016-02-29), 10-Q (報告日: 2015-11-30), 10-K (報告日: 2015-08-31), 10-Q (報告日: 2015-05-31), 10-Q (報告日: 2015-02-28), 10-Q (報告日: 2014-11-30), 10-K (報告日: 2014-08-31), 10-Q (報告日: 2014-05-31), 10-Q (報告日: 2014-02-28), 10-Q (報告日: 2013-11-30).

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