Stock Analysis on Net
Microsoft Excel LibreOffice Calc

Eli Lilly & Co. (NYSE:LLY)

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

難易度が低い

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

Eli Lilly & Co.、ROE(四半期データ)の分解

Microsoft Excel LibreOffice Calc
ROE = ROA × 財務レバレッジ
2020/09/30 115.45% = 12.68% × 9.10
2020/06/30 137.26% = 13.39% × 10.25
2020/03/31 179.72% = 13.46% × 13.35
2019/12/31 319.09% = 21.17% × 15.07
2019/09/30 234.97% = 20.97% × 11.20
2019/06/30 282.08% = 20.28% × 13.91
2019/03/31 252.24% = 16.46% × 15.32
2018/12/31 32.88% = 7.36% × 4.47
2018/09/30 3.44% = 1.01% × 3.41
2018/06/30 -1.24% = -0.34% × 3.67
2018/03/31 7.74% = 2.53% × 3.05
2017/12/31 -1.76% = -0.45% × 3.88
2017/09/30 14.94% = 5.17% × 2.89
2017/06/30 17.35% = 5.98% × 2.90
2017/03/31 15.58% = 5.81% × 2.68
2016/12/31 19.54% = 7.05% × 2.77
2016/09/30 15.68% = 6.50% × 2.41
2016/06/30 16.85% = 6.76% × 2.49
2016/03/31 15.45% = 6.68% × 2.31
2015/12/31 16.53% = 6.77% × 2.44
2015/09/30 = × 2.39
2015/06/30 = × 2.46
2015/03/31 = × 2.39

ソース: Eli Lilly & Co. (NYSE:LLY) | DuPont analysis (Q) (www.stock-analysis-on.net)

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


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

Eli Lilly & Co.、ROE(四半期データ)の分解

Microsoft Excel LibreOffice Calc
ROE = 純利益率 × 資産回転率 × 財務レバレッジ
2020/09/30 115.45% = 24.01% × 0.53 × 9.10
2020/06/30 137.26% = 24.48% × 0.55 × 10.25
2020/03/31 179.72% = 23.97% × 0.56 × 13.35
2019/12/31 319.09% = 37.27% × 0.57 × 15.07
2019/09/30 234.97% = 35.10% × 0.60 × 11.20
2019/06/30 282.08% = 33.76% × 0.60 × 13.91
2019/03/31 252.24% = 26.12% × 0.63 × 15.32
2018/12/31 32.88% = 13.16% × 0.56 × 4.47
2018/09/30 3.44% = 1.85% × 0.54 × 3.41
2018/06/30 -1.24% = -0.60% × 0.56 × 3.67
2018/03/31 7.74% = 4.82% × 0.53 × 3.05
2017/12/31 -1.76% = -0.89% × 0.51 × 3.88
2017/09/30 14.94% = 9.90% × 0.52 × 2.89
2017/06/30 17.35% = 11.12% × 0.54 × 2.90
2017/03/31 15.58% = 10.13% × 0.57 × 2.68
2016/12/31 19.54% = 12.90% × 0.55 × 2.77
2016/09/30 15.68% = 11.73% × 0.55 × 2.41
2016/06/30 16.85% = 11.97% × 0.56 × 2.49
2016/03/31 15.45% = 11.49% × 0.58 × 2.31
2015/12/31 16.53% = 12.07% × 0.56 × 2.44
2015/09/30 = × × 2.39
2015/06/30 = × × 2.46
2015/03/31 = × × 2.39

ソース: Eli Lilly & Co. (NYSE:LLY) | DuPont analysis (Q) (www.stock-analysis-on.net)

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


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

Eli Lilly & Co.、ROA(四半期データ)の分解

Microsoft Excel LibreOffice Calc
ROA = 純利益率 × 資産回転率
2020/09/30 12.68% = 24.01% × 0.53
2020/06/30 13.39% = 24.48% × 0.55
2020/03/31 13.46% = 23.97% × 0.56
2019/12/31 21.17% = 37.27% × 0.57
2019/09/30 20.97% = 35.10% × 0.60
2019/06/30 20.28% = 33.76% × 0.60
2019/03/31 16.46% = 26.12% × 0.63
2018/12/31 7.36% = 13.16% × 0.56
2018/09/30 1.01% = 1.85% × 0.54
2018/06/30 -0.34% = -0.60% × 0.56
2018/03/31 2.53% = 4.82% × 0.53
2017/12/31 -0.45% = -0.89% × 0.51
2017/09/30 5.17% = 9.90% × 0.52
2017/06/30 5.98% = 11.12% × 0.54
2017/03/31 5.81% = 10.13% × 0.57
2016/12/31 7.05% = 12.90% × 0.55
2016/09/30 6.50% = 11.73% × 0.55
2016/06/30 6.76% = 11.97% × 0.56
2016/03/31 6.68% = 11.49% × 0.58
2015/12/31 6.77% = 12.07% × 0.56
2015/09/30 = ×
2015/06/30 = ×
2015/03/31 = ×

ソース: Eli Lilly & Co. (NYSE:LLY) | DuPont analysis (Q) (www.stock-analysis-on.net)

2020年第3四半期に比べて資産収益率(ROA)が低下する主な理由は、資産回転率の低下です。