Stock Analysis on Net

Etsy Inc. (NASDAQ:ETSY)

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

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

Microsoft Excel

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

Etsy Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2022/09/30 = -26.21% ×
2022/06/30 70.66% = 11.39% × 6.21
2022/03/31 64.39% = 11.64% × 5.53
2021/12/31 78.51% = 12.88% × 6.10
2021/09/30 90.04% = 13.72% × 6.56
2021/06/30 90.87% = 14.66% × 6.20
2021/03/31 70.27% = 19.24% × 3.65
2020/12/31 47.04% = 14.52% × 3.24
2020/09/30 34.80% = 10.48% × 3.32
2020/06/30 29.58% = 8.80% × 3.36
2020/03/31 18.89% = 5.06% × 3.73
2019/12/31 23.58% = 6.22% × 3.79
2019/09/30 27.19% = 7.06% × 3.85
2019/06/30 25.08% = 10.86% × 2.31
2019/03/31 22.88% = 9.79% × 2.34
2018/12/31 19.33% = 8.59% × 2.25
2018/09/30 20.52% = 8.93% × 2.30
2018/06/30 23.48% = 10.04% × 2.34
2018/03/31 24.76% = 10.94% × 2.26
2017/12/31 20.61% = 13.51% × 1.53
2017/09/30 = × 1.65
2017/06/30 = × 1.80
2017/03/31 = × 1.80

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


ROEを3つの要素に分解

Etsy Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2022/09/30 = -25.94% × 1.01 ×
2022/06/30 70.66% = 17.01% × 0.67 × 6.21
2022/03/31 64.39% = 18.49% × 0.63 × 5.53
2021/12/31 78.51% = 21.19% × 0.61 × 6.10
2021/09/30 90.04% = 21.55% × 0.64 × 6.56
2021/06/30 90.87% = 22.45% × 0.65 × 6.20
2021/03/31 70.27% = 23.46% × 0.82 × 3.65
2020/12/31 47.04% = 20.24% × 0.72 × 3.24
2020/09/30 34.80% = 16.83% × 0.62 × 3.32
2020/06/30 29.58% = 13.78% × 0.64 × 3.36
2020/03/31 18.89% = 8.76% × 0.58 × 3.73
2019/12/31 23.58% = 11.72% × 0.53 × 3.79
2019/09/30 27.19% = 14.14% × 0.50 × 3.85
2019/06/30 25.08% = 15.83% × 0.69 × 2.31
2019/03/31 22.88% = 14.74% × 0.66 × 2.34
2018/12/31 19.33% = 12.84% × 0.67 × 2.25
2018/09/30 20.52% = 15.00% × 0.60 × 2.30
2018/06/30 23.48% = 17.52% × 0.57 × 2.34
2018/03/31 24.76% = 20.46% × 0.53 × 2.26
2017/12/31 20.61% = 18.54% × 0.73 × 1.53
2017/09/30 = × × 1.65
2017/06/30 = × × 1.80
2017/03/31 = × × 1.80

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


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

Etsy Inc.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 純利益率 × 資産回転率
2022/09/30 -26.21% = -25.94% × 1.01
2022/06/30 11.39% = 17.01% × 0.67
2022/03/31 11.64% = 18.49% × 0.63
2021/12/31 12.88% = 21.19% × 0.61
2021/09/30 13.72% = 21.55% × 0.64
2021/06/30 14.66% = 22.45% × 0.65
2021/03/31 19.24% = 23.46% × 0.82
2020/12/31 14.52% = 20.24% × 0.72
2020/09/30 10.48% = 16.83% × 0.62
2020/06/30 8.80% = 13.78% × 0.64
2020/03/31 5.06% = 8.76% × 0.58
2019/12/31 6.22% = 11.72% × 0.53
2019/09/30 7.06% = 14.14% × 0.50
2019/06/30 10.86% = 15.83% × 0.69
2019/03/31 9.79% = 14.74% × 0.66
2018/12/31 8.59% = 12.84% × 0.67
2018/09/30 8.93% = 15.00% × 0.60
2018/06/30 10.04% = 17.52% × 0.57
2018/03/31 10.94% = 20.46% × 0.53
2017/12/31 13.51% = 18.54% × 0.73
2017/09/30 = ×
2017/06/30 = ×
2017/03/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), 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年第3 四半期の総資産利益率(ROA)の低下の主な理由は、純利益率で測定した収益性の低下です。