Stock Analysis on Net

Fortinet Inc. (NASDAQ:FTNT)

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

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

Microsoft Excel

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

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

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2023/03/31 8,478.95% = 14.15% × 599.32
2022/12/31 = 13.77% ×
2022/09/30 = 13.92% ×
2022/06/30 = 12.73% ×
2022/03/31 293.06% = 11.29% × 25.96
2021/12/31 77.63% = 10.25% × 7.57
2021/09/30 49.59% = 9.29% × 5.34
2021/06/30 49.02% = 9.26% × 5.29
2021/03/31 50.07% = 9.30% × 5.39
2020/12/31 57.07% = 12.08% × 4.72
2020/09/30 64.08% = 12.74% × 5.03
2020/06/30 76.01% = 12.41% × 6.12
2020/03/31 69.42% = 11.61% × 5.98
2019/12/31 24.70% = 8.40% × 2.94
2019/09/30 32.81% = 11.11% × 2.95
2019/06/30 33.22% = 11.06% × 3.00
2019/03/31 33.02% = 10.90% × 3.03
2018/12/31 32.88% = 10.79% × 3.05
2018/09/30 = × 3.10
2018/06/30 = × 3.30
2018/03/31 = × 3.46

レポートに基づく: 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つの要素に分解

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

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2023/03/31 8,478.95% = 20.46% × 0.69 × 599.32
2022/12/31 = 19.41% × 0.71 ×
2022/09/30 = 18.12% × 0.77 ×
2022/06/30 = 17.66% × 0.72 ×
2022/03/31 293.06% = 17.79% × 0.63 × 25.96
2021/12/31 77.63% = 18.16% × 0.56 × 7.57
2021/09/30 49.59% = 17.73% × 0.52 × 5.34
2021/06/30 49.02% = 17.69% × 0.52 × 5.29
2021/03/31 50.07% = 18.01% × 0.52 × 5.39
2020/12/31 57.07% = 18.83% × 0.64 × 4.72
2020/09/30 64.08% = 18.57% × 0.69 × 5.03
2020/06/30 76.01% = 17.54% × 0.71 × 6.12
2020/03/31 69.42% = 16.46% × 0.71 × 5.98
2019/12/31 24.70% = 15.14% × 0.55 × 2.94
2019/09/30 32.81% = 19.23% × 0.58 × 2.95
2019/06/30 33.22% = 19.07% × 0.58 × 3.00
2019/03/31 33.02% = 18.64% × 0.58 × 3.03
2018/12/31 32.88% = 18.44% × 0.59 × 3.05
2018/09/30 = × × 3.10
2018/06/30 = × × 3.30
2018/03/31 = × × 3.46

レポートに基づく: 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つの要素に分解

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

Microsoft Excel
ROE = 税負担 × 利息負担 × EBITマージン × 資産回転率 × 財務レバレッジ比率
2023/03/31 8,478.95% = 0.94 × 0.98 × 22.12% × 0.69 × 599.32
2022/12/31 = 0.97 × 0.98 × 20.51% × 0.71 ×
2022/09/30 = 0.97 × 0.98 × 19.18% × 0.77 ×
2022/06/30 = 1.02 × 0.97 × 17.84% × 0.72 ×
2022/03/31 293.06% = 1.01 × 0.97 × 18.12% × 0.63 × 25.96
2021/12/31 77.63% = 0.98 × 0.98 × 19.02% × 0.56 × 7.57
2021/09/30 49.59% = 0.94 × 0.98 × 19.20% × 0.52 × 5.34
2021/06/30 49.02% = 0.91 × 0.99 × 19.59% × 0.52 × 5.29
2021/03/31 50.07% = 0.90 × 1.00 × 19.97% × 0.52 × 5.39
2020/12/31 57.07% = 0.90 × 1.00 × 20.88% × 0.64 × 4.72
2020/09/30 64.08% = 0.92 × 1.00 × 20.23% × 0.69 × 5.03
2020/06/30 76.01% = 0.87 × 1.00 × 20.14% × 0.71 × 6.12
2020/03/31 69.42% = 0.85 × 1.00 × 19.32% × 0.71 × 5.98
2019/12/31 24.70% = 0.86 × 1.00 × 17.59% × 0.55 × 2.94
2019/09/30 32.81% = 1.15 × 1.00 × 16.77% × 0.58 × 2.95
2019/06/30 33.22% = 1.21 × 1.00 × 15.79% × 0.58 × 3.00
2019/03/31 33.02% = 1.27 × 1.00 × 14.64% × 0.58 × 3.03
2018/12/31 32.88% = 1.32 × 1.00 × 13.93% × 0.59 × 3.05
2018/09/30 = × × × × 3.10
2018/06/30 = × × × × 3.30
2018/03/31 = × × × × 3.46

レポートに基づく: 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つのコンポーネントに分解

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

Microsoft Excel
ROA = 純利益率 × 資産回転率
2023/03/31 14.15% = 20.46% × 0.69
2022/12/31 13.77% = 19.41% × 0.71
2022/09/30 13.92% = 18.12% × 0.77
2022/06/30 12.73% = 17.66% × 0.72
2022/03/31 11.29% = 17.79% × 0.63
2021/12/31 10.25% = 18.16% × 0.56
2021/09/30 9.29% = 17.73% × 0.52
2021/06/30 9.26% = 17.69% × 0.52
2021/03/31 9.30% = 18.01% × 0.52
2020/12/31 12.08% = 18.83% × 0.64
2020/09/30 12.74% = 18.57% × 0.69
2020/06/30 12.41% = 17.54% × 0.71
2020/03/31 11.61% = 16.46% × 0.71
2019/12/31 8.40% = 15.14% × 0.55
2019/09/30 11.11% = 19.23% × 0.58
2019/06/30 11.06% = 19.07% × 0.58
2019/03/31 10.90% = 18.64% × 0.58
2018/12/31 10.79% = 18.44% × 0.59
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).

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


ROAを4つの要素に分解

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

Microsoft Excel
ROA = 税負担 × 利息負担 × EBITマージン × 資産回転率
2023/03/31 14.15% = 0.94 × 0.98 × 22.12% × 0.69
2022/12/31 13.77% = 0.97 × 0.98 × 20.51% × 0.71
2022/09/30 13.92% = 0.97 × 0.98 × 19.18% × 0.77
2022/06/30 12.73% = 1.02 × 0.97 × 17.84% × 0.72
2022/03/31 11.29% = 1.01 × 0.97 × 18.12% × 0.63
2021/12/31 10.25% = 0.98 × 0.98 × 19.02% × 0.56
2021/09/30 9.29% = 0.94 × 0.98 × 19.20% × 0.52
2021/06/30 9.26% = 0.91 × 0.99 × 19.59% × 0.52
2021/03/31 9.30% = 0.90 × 1.00 × 19.97% × 0.52
2020/12/31 12.08% = 0.90 × 1.00 × 20.88% × 0.64
2020/09/30 12.74% = 0.92 × 1.00 × 20.23% × 0.69
2020/06/30 12.41% = 0.87 × 1.00 × 20.14% × 0.71
2020/03/31 11.61% = 0.85 × 1.00 × 19.32% × 0.71
2019/12/31 8.40% = 0.86 × 1.00 × 17.59% × 0.55
2019/09/30 11.11% = 1.15 × 1.00 × 16.77% × 0.58
2019/06/30 11.06% = 1.21 × 1.00 × 15.79% × 0.58
2019/03/31 10.90% = 1.27 × 1.00 × 14.64% × 0.58
2018/12/31 10.79% = 1.32 × 1.00 × 13.93% × 0.59
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).

2023年第1 四半期に総資産利益率(ROA)が上昇した主な理由は、EBITマージン率で測定した営業利益率の増加です。


当期純利益率の分解

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

Microsoft Excel
純利益率 = 税負担 × 利息負担 × EBITマージン
2023/03/31 20.46% = 0.94 × 0.98 × 22.12%
2022/12/31 19.41% = 0.97 × 0.98 × 20.51%
2022/09/30 18.12% = 0.97 × 0.98 × 19.18%
2022/06/30 17.66% = 1.02 × 0.97 × 17.84%
2022/03/31 17.79% = 1.01 × 0.97 × 18.12%
2021/12/31 18.16% = 0.98 × 0.98 × 19.02%
2021/09/30 17.73% = 0.94 × 0.98 × 19.20%
2021/06/30 17.69% = 0.91 × 0.99 × 19.59%
2021/03/31 18.01% = 0.90 × 1.00 × 19.97%
2020/12/31 18.83% = 0.90 × 1.00 × 20.88%
2020/09/30 18.57% = 0.92 × 1.00 × 20.23%
2020/06/30 17.54% = 0.87 × 1.00 × 20.14%
2020/03/31 16.46% = 0.85 × 1.00 × 19.32%
2019/12/31 15.14% = 0.86 × 1.00 × 17.59%
2019/09/30 19.23% = 1.15 × 1.00 × 16.77%
2019/06/30 19.07% = 1.21 × 1.00 × 15.79%
2019/03/31 18.64% = 1.27 × 1.00 × 14.64%
2018/12/31 18.44% = 1.32 × 1.00 × 13.93%
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).

2023年第1 四半期から純利益率が上昇した主な理由は、EBITマージン率で測定した営業利益率の増加です。