Stock Analysis on Net

First Solar Inc. (NASDAQ:FSLR)

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

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

Microsoft Excel

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

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

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2023/03/31 0.71% = 0.49% × 1.46
2022/12/31 -0.76% = -0.54% × 1.41
2022/09/30 1.63% = 1.26% × 1.29
2022/06/30 3.21% = 2.55% × 1.26
2022/03/31 3.67% = 2.92% × 1.26
2021/12/31 7.86% = 6.32% × 1.24
2021/09/30 7.77% = 6.23% × 1.25
2021/06/30 9.73% = 7.77% × 1.25
2021/03/31 9.08% = 7.28% × 1.25
2020/12/31 7.22% = 5.60% × 1.29
2020/09/30 4.14% = 3.20% × 1.29
2020/06/30 1.89% = 1.40% × 1.35
2020/03/31 0.84% = 0.62% × 1.34
2019/12/31 -2.26% = -1.53% × 1.47
2019/09/30 -0.07% = -0.05% × 1.36
2019/06/30 0.46% = 0.33% × 1.39
2019/03/31 -0.12% = -0.09% × 1.41
2018/12/31 2.77% = 2.03% × 1.37
2018/09/30 = × 1.37
2018/06/30 = × 1.37
2018/03/31 = × 1.33

レポートに基づく: 10-Q (報告日: 2023-03-31), 10-K (報告日: 2022-12-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).


ROEを3つの要素に分解

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

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2023/03/31 0.71% = 1.49% × 0.33 × 1.46
2022/12/31 -0.76% = -1.69% × 0.32 × 1.41
2022/09/30 1.63% = 3.75% × 0.34 × 1.29
2022/06/30 3.21% = 7.63% × 0.33 × 1.26
2022/03/31 3.67% = 8.68% × 0.34 × 1.26
2021/12/31 7.86% = 16.03% × 0.39 × 1.24
2021/09/30 7.77% = 17.26% × 0.36 × 1.25
2021/06/30 9.73% = 18.96% × 0.41 × 1.25
2021/03/31 9.08% = 17.34% × 0.42 × 1.25
2020/12/31 7.22% = 14.69% × 0.38 × 1.29
2020/09/30 4.14% = 6.38% × 0.50 × 1.29
2020/06/30 1.89% = 3.17% × 0.44 × 1.35
2020/03/31 0.84% = 1.42% × 0.44 × 1.34
2019/12/31 -2.26% = -3.75% × 0.41 × 1.47
2019/09/30 -0.07% = -0.14% × 0.33 × 1.36
2019/06/30 0.46% = 0.95% × 0.35 × 1.39
2019/03/31 -0.12% = -0.28% × 0.30 × 1.41
2018/12/31 2.77% = 6.43% × 0.32 × 1.37
2018/09/30 = × × 1.37
2018/06/30 = × × 1.37
2018/03/31 = × × 1.33

レポートに基づく: 10-Q (報告日: 2023-03-31), 10-K (報告日: 2022-12-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).


ROEを5つの要素に分解

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

Microsoft Excel
ROE = 税負担 × 利息負担 × EBITマージン × 資産回転率 × 財務レバレッジ比率
2023/03/31 0.71% = 0.39 × 0.91 × 4.18% × 0.33 × 1.46
2022/12/31 -0.76% = -5.14 × 0.41 × 0.79% × 0.32 × 1.41
2022/09/30 1.63% = 0.52 × 0.94 × 7.68% × 0.34 × 1.29
2022/06/30 3.21% = 0.65 × 0.96 × 12.17% × 0.33 × 1.26
2022/03/31 3.67% = 0.85 × 0.95 × 10.70% × 0.34 × 1.26
2021/12/31 7.86% = 0.82 × 0.98 × 20.02% × 0.39 × 1.24
2021/09/30 7.77% = 1.00 × 0.97 × 17.82% × 0.36 × 1.25
2021/06/30 9.73% = 0.94 × 0.97 × 20.98% × 0.41 × 1.25
2021/03/31 9.08% = 0.95 × 0.96 × 18.98% × 0.42 × 1.25
2020/12/31 7.22% = 1.37 × 0.92 × 11.62% × 0.38 × 1.29
2020/09/30 4.14% = 1.47 × 0.86 × 5.01% × 0.50 × 1.29
2020/06/30 1.89% = 24.72 × 0.18 × 0.71% × 0.44 × 1.35
2020/03/31 0.84% = × × -0.86% × 0.44 × 1.34
2019/12/31 -2.26% = × × -3.05% × 0.41 × 1.47
2019/09/30 -0.07% = -0.19 × 0.33 × 2.25% × 0.33 × 1.36
2019/06/30 0.46% = 0.74 × 0.49 × 2.65% × 0.35 × 1.39
2019/03/31 -0.12% = × -1.05 × 0.68% × 0.30 × 1.41
2018/12/31 2.77% = 0.98 × 0.85 × 7.74% × 0.32 × 1.37
2018/09/30 = × × × × 1.37
2018/06/30 = × × × × 1.37
2018/03/31 = × × × × 1.33

レポートに基づく: 10-Q (報告日: 2023-03-31), 10-K (報告日: 2022-12-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).


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

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

Microsoft Excel
ROA = 純利益率 × 資産回転率
2023/03/31 0.49% = 1.49% × 0.33
2022/12/31 -0.54% = -1.69% × 0.32
2022/09/30 1.26% = 3.75% × 0.34
2022/06/30 2.55% = 7.63% × 0.33
2022/03/31 2.92% = 8.68% × 0.34
2021/12/31 6.32% = 16.03% × 0.39
2021/09/30 6.23% = 17.26% × 0.36
2021/06/30 7.77% = 18.96% × 0.41
2021/03/31 7.28% = 17.34% × 0.42
2020/12/31 5.60% = 14.69% × 0.38
2020/09/30 3.20% = 6.38% × 0.50
2020/06/30 1.40% = 3.17% × 0.44
2020/03/31 0.62% = 1.42% × 0.44
2019/12/31 -1.53% = -3.75% × 0.41
2019/09/30 -0.05% = -0.14% × 0.33
2019/06/30 0.33% = 0.95% × 0.35
2019/03/31 -0.09% = -0.28% × 0.30
2018/12/31 2.03% = 6.43% × 0.32
2018/09/30 = ×
2018/06/30 = ×
2018/03/31 = ×

レポートに基づく: 10-Q (報告日: 2023-03-31), 10-K (報告日: 2022-12-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).


ROAを4つの要素に分解

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

Microsoft Excel
ROA = 税負担 × 利息負担 × EBITマージン × 資産回転率
2023/03/31 0.49% = 0.39 × 0.91 × 4.18% × 0.33
2022/12/31 -0.54% = -5.14 × 0.41 × 0.79% × 0.32
2022/09/30 1.26% = 0.52 × 0.94 × 7.68% × 0.34
2022/06/30 2.55% = 0.65 × 0.96 × 12.17% × 0.33
2022/03/31 2.92% = 0.85 × 0.95 × 10.70% × 0.34
2021/12/31 6.32% = 0.82 × 0.98 × 20.02% × 0.39
2021/09/30 6.23% = 1.00 × 0.97 × 17.82% × 0.36
2021/06/30 7.77% = 0.94 × 0.97 × 20.98% × 0.41
2021/03/31 7.28% = 0.95 × 0.96 × 18.98% × 0.42
2020/12/31 5.60% = 1.37 × 0.92 × 11.62% × 0.38
2020/09/30 3.20% = 1.47 × 0.86 × 5.01% × 0.50
2020/06/30 1.40% = 24.72 × 0.18 × 0.71% × 0.44
2020/03/31 0.62% = × × -0.86% × 0.44
2019/12/31 -1.53% = × × -3.05% × 0.41
2019/09/30 -0.05% = -0.19 × 0.33 × 2.25% × 0.33
2019/06/30 0.33% = 0.74 × 0.49 × 2.65% × 0.35
2019/03/31 -0.09% = × -1.05 × 0.68% × 0.30
2018/12/31 2.03% = 0.98 × 0.85 × 7.74% × 0.32
2018/09/30 = × × ×
2018/06/30 = × × ×
2018/03/31 = × × ×

レポートに基づく: 10-Q (報告日: 2023-03-31), 10-K (報告日: 2022-12-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).


純利益率の分解

First Solar Inc.、純利益率の分解(四半期データ)

Microsoft Excel
純利益率 = 税負担 × 利息負担 × EBITマージン
2023/03/31 1.49% = 0.39 × 0.91 × 4.18%
2022/12/31 -1.69% = -5.14 × 0.41 × 0.79%
2022/09/30 3.75% = 0.52 × 0.94 × 7.68%
2022/06/30 7.63% = 0.65 × 0.96 × 12.17%
2022/03/31 8.68% = 0.85 × 0.95 × 10.70%
2021/12/31 16.03% = 0.82 × 0.98 × 20.02%
2021/09/30 17.26% = 1.00 × 0.97 × 17.82%
2021/06/30 18.96% = 0.94 × 0.97 × 20.98%
2021/03/31 17.34% = 0.95 × 0.96 × 18.98%
2020/12/31 14.69% = 1.37 × 0.92 × 11.62%
2020/09/30 6.38% = 1.47 × 0.86 × 5.01%
2020/06/30 3.17% = 24.72 × 0.18 × 0.71%
2020/03/31 1.42% = × × -0.86%
2019/12/31 -3.75% = × × -3.05%
2019/09/30 -0.14% = -0.19 × 0.33 × 2.25%
2019/06/30 0.95% = 0.74 × 0.49 × 2.65%
2019/03/31 -0.28% = × -1.05 × 0.68%
2018/12/31 6.43% = 0.98 × 0.85 × 7.74%
2018/09/30 = × ×
2018/06/30 = × ×
2018/03/31 = × ×

レポートに基づく: 10-Q (報告日: 2023-03-31), 10-K (報告日: 2022-12-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).