Stock Analysis on Net
Stock Analysis on Net

CrowdStrike Holdings Inc. (NASDAQ:CRWD)

DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin

Microsoft Excel

Decomposing ROE involves expressing net income divided by shareholders’ equity as the product of component ratios.

Two-Component Disaggregation of ROE

CrowdStrike Holdings Inc., decomposition of ROE

Microsoft Excel
ROE = ROA × Financial Leverage
Jan 31, 2024 3.88% = 1.34% × 2.88
Jan 31, 2023 -12.52% = -3.65% × 3.43
Jan 31, 2022 -22.89% = -6.49% × 3.53
Jan 31, 2021 -10.64% = -3.39% × 3.14
Jan 31, 2020 -19.10% = -10.09% × 1.89

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31).

Three-Component Disaggregation of ROE

CrowdStrike Holdings Inc., decomposition of ROE

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Jan 31, 2024 3.88% = 2.92% × 0.46 × 2.88
Jan 31, 2023 -12.52% = -8.18% × 0.45 × 3.43
Jan 31, 2022 -22.89% = -16.18% × 0.40 × 3.53
Jan 31, 2021 -10.64% = -10.59% × 0.32 × 3.14
Jan 31, 2020 -19.10% = -29.45% × 0.34 × 1.89

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31).

Five-Component Disaggregation of ROE

CrowdStrike Holdings Inc., decomposition of ROE

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Jan 31, 2024 3.88% = 0.73 × 0.83 × 4.82% × 0.46 × 2.88
Jan 31, 2023 -12.52% = — × — × -6.05% × 0.45 × 3.43
Jan 31, 2022 -22.89% = — × — × -9.45% × 0.40 × 3.53
Jan 31, 2021 -10.64% = — × — × -9.87% × 0.32 × 3.14
Jan 31, 2020 -19.10% = — × — × -28.94% × 0.34 × 1.89

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31).

Two-Component Disaggregation of ROA

CrowdStrike Holdings Inc., decomposition of ROA

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Jan 31, 2024 1.34% = 2.92% × 0.46
Jan 31, 2023 -3.65% = -8.18% × 0.45
Jan 31, 2022 -6.49% = -16.18% × 0.40
Jan 31, 2021 -3.39% = -10.59% × 0.32
Jan 31, 2020 -10.09% = -29.45% × 0.34

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31).

Four-Component Disaggregation of ROA

CrowdStrike Holdings Inc., decomposition of ROA

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Jan 31, 2024 1.34% = 0.73 × 0.83 × 4.82% × 0.46
Jan 31, 2023 -3.65% = — × — × -6.05% × 0.45
Jan 31, 2022 -6.49% = — × — × -9.45% × 0.40
Jan 31, 2021 -3.39% = — × — × -9.87% × 0.32
Jan 31, 2020 -10.09% = — × — × -28.94% × 0.34

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31).

Disaggregation of Net Profit Margin

CrowdStrike Holdings Inc., decomposition of net profit margin ratio

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Jan 31, 2024 2.92% = 0.73 × 0.83 × 4.82%
Jan 31, 2023 -8.18% = — × — × -6.05%
Jan 31, 2022 -16.18% = — × — × -9.45%
Jan 31, 2021 -10.59% = — × — × -9.87%
Jan 31, 2020 -29.45% = — × — × -28.94%

Based on: 10-K (reporting date: 2024-01-31), 10-K (reporting date: 2023-01-31), 10-K (reporting date: 2022-01-31), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-01-31).