Stock Analysis on Net

Fortinet Inc. (NASDAQ:FTNT)

$22.49

This company has been moved to the archive! The financial data has not been updated since May 8, 2023.

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

Microsoft Excel

Paying user area

The data is hidden behind: . Unhide it.

This is a one-time payment. There is no automatic renewal.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Two-Component Disaggregation of ROE

Fortinet Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
Mar 31, 2023 = ×
Dec 31, 2022 = ×
Sep 30, 2022 = ×
Jun 30, 2022 = ×
Mar 31, 2022 = ×
Dec 31, 2021 = ×
Sep 30, 2021 = ×
Jun 30, 2021 = ×
Mar 31, 2021 = ×
Dec 31, 2020 = ×
Sep 30, 2020 = ×
Jun 30, 2020 = ×
Mar 31, 2020 = ×
Dec 31, 2019 = ×
Sep 30, 2019 = ×
Jun 30, 2019 = ×
Mar 31, 2019 = ×

Based on: 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).


The quarterly financial data reveals notable trends in profitability and leverage ratios over the analyzed periods. The return on assets (ROA) exhibits a generally positive trajectory, with some fluctuations. Initially, ROA maintained a steady range around 10-11%, dipped slightly to 8.4% at the end of 2019, and subsequently climbed to peak values around 14% by the first quarter of 2023, indicating improving asset efficiency and profitability over time.

Financial leverage shows a more volatile pattern. The ratio started at approximately 3.0, suggesting moderate use of debt relative to equity. During 2020, the leverage ratio increased significantly, reaching values near 6.0 and above, with noticeable peaks including a sharp escalation to 25.96 in early 2022, culminating in an extraordinarily high value of 599.32 by March 2023. This increase implies a substantial rise in the company's reliance on debt financing over equity, which may raise concerns about financial risk and solvency.

Return on equity (ROE) initially exhibits strong performance, hovering around the low 30% range through 2019. There is a marked increase during 2020, with ROE values climbing to over 70%, followed by some decrease but remaining elevated in the 40-50% range through 2021. A dramatic surge is observed in 2022 and early 2023, with ROE reaching extraordinarily high levels of 293.06 and 8478.95 respectively. Such spikes likely correlate with the sharp increases in financial leverage, as ROE is amplified by higher leverage; however, extreme values warrant scrutiny concerning sustainability and underlying financial structure.

Overall Profitability (ROA)
Shows steady improvement with a peak above 14%, indicating enhanced asset utilization and earning capacity.
Financial Leverage
Displays significant growth, particularly from 2020 onward, culminating in extremely high leverage ratios, suggesting increased debt usage and potential risk.
Return on Equity (ROE)
Increases substantially in line with leverage, with exceptionally high values in recent quarters, implying amplified returns due to financial structure changes rather than operational efficiency alone.

In summary, the analyzed data points to enhanced asset profitability and sharply increased financial leverage over time, leading to very high and potentially unsustainable returns on equity. This pattern reflects a financial strategy that heavily utilizes debt, which may improve equity returns but also escalates financial risk. Continuous monitoring of leverage and its impact on financial stability is advised.


Three-Component Disaggregation of ROE

Fortinet Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Mar 31, 2023 = × ×
Dec 31, 2022 = × ×
Sep 30, 2022 = × ×
Jun 30, 2022 = × ×
Mar 31, 2022 = × ×
Dec 31, 2021 = × ×
Sep 30, 2021 = × ×
Jun 30, 2021 = × ×
Mar 31, 2021 = × ×
Dec 31, 2020 = × ×
Sep 30, 2020 = × ×
Jun 30, 2020 = × ×
Mar 31, 2020 = × ×
Dec 31, 2019 = × ×
Sep 30, 2019 = × ×
Jun 30, 2019 = × ×
Mar 31, 2019 = × ×

Based on: 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).


The financial data reveals several notable trends across the analyzed periods.

Net Profit Margin
The net profit margin remained relatively stable between 15% and 20% throughout the periods, with a slight dip observed toward the end of 2019, bottoming at 15.14%. Subsequent quarters showed a steady recovery and gradual increase, reaching a peak of 20.46% in the first quarter of 2023. This indicates a consistent ability to convert revenue into profit over time, with improvements noted in more recent quarters.
Asset Turnover
Asset turnover exhibited modest fluctuations over the periods. Initially steady at 0.58, it increased significantly in early 2020 reaching a high of 0.71, followed by a temporary decline in mid to late 2020. Afterward, the ratio showed a recovery trend, peaking at 0.77 in the third quarter of 2022. The trend suggests improving efficiency in using assets to generate sales, particularly evident from mid-2021 onwards.
Financial Leverage
Financial leverage figures displayed considerable volatility and remarkable spikes. Early periods show values close to 3, which doubled and peaked around 6 in mid-2020, followed by a decline to under 5 by the end of 2020. Starting in 2021, a dramatic increase is observed, with leverage rising sharply to 25.96 in early 2022 and surging to an exceptionally high value of 599.32 in the first quarter of 2023. Such a spike suggests a significant increase in debt levels or other liabilities relative to equity, potentially indicating higher financial risk or changes in capital structure.
Return on Equity (ROE)
ROE has generally trended upward, albeit with fluctuations. Early periods reveal consistent returns around 30%, which experienced a sharp increase in 2020 to above 60%, peaking at 77.63% in late 2021. A substantial surge occurred in early 2022, hitting an extraordinary 293.06%, and further soaring to an anomalous 8478.95% in the first quarter of 2023. This extreme increase likely correlates with the spike in financial leverage and suggests a highly leveraged equity base that amplified returns dramatically, though it might also indicate data irregularities or one-off events impacting equity.

Five-Component Disaggregation of ROE

Fortinet Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Mar 31, 2023 = × × × ×
Dec 31, 2022 = × × × ×
Sep 30, 2022 = × × × ×
Jun 30, 2022 = × × × ×
Mar 31, 2022 = × × × ×
Dec 31, 2021 = × × × ×
Sep 30, 2021 = × × × ×
Jun 30, 2021 = × × × ×
Mar 31, 2021 = × × × ×
Dec 31, 2020 = × × × ×
Sep 30, 2020 = × × × ×
Jun 30, 2020 = × × × ×
Mar 31, 2020 = × × × ×
Dec 31, 2019 = × × × ×
Sep 30, 2019 = × × × ×
Jun 30, 2019 = × × × ×
Mar 31, 2019 = × × × ×

Based on: 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).


The financial data reveals several key trends in profitability, efficiency, leverage, and return for the periods analyzed.

Tax Burden
The tax burden ratio displayed a decreasing trend initially from 1.27 in early 2019 to 0.86 by the end of 2019, indicating a reduced tax impact on earnings over this time. It then fluctuated around values just below or near 1.0 through to early 2023, suggesting relative stability in tax effects on profits during the latter periods.
Interest Burden
The interest burden remained consistently close to 1.0 across most periods, indicating minimal interest expenses relative to earnings before interest and taxes. A minor decline is observable from mid-2021 onward, reflecting a slight increase in interest impact but generally maintaining strong interest coverage.
EBIT Margin
There was a positive trend in EBIT margin from 14.64% at the beginning of 2019 rising steadily and peaking at 22.12% in Q1 2023. This shows improving profitability and operational efficiency over the period, with a small dip around 2022 but a notable recovery and further improvement by early 2023.
Asset Turnover
Asset turnover fluctuated moderately, starting at 0.58 in early 2019 and peaking around 0.77 in late 2022 before slightly declining again. The trend suggests variable but generally improving efficiency in generating sales from assets, particularly stronger in the later years post-2020.
Financial Leverage
Financial leverage saw substantial variation. It was stable just below 3 in 2019, then more than doubled by mid-2020 to around 6, experienced fluctuations thereafter, and displayed an extreme increase by 2023, reaching an unusually high 599.32. This suggests significant changes in capital structure or a reporting anomaly in the last period, indicating extraordinarily high leverage levels.
Return on Equity (ROE)
ROE followed a variable but largely increasing pattern. It began around 33% in early 2019, surged above 69% in mid-2020, and fluctuated significantly before dramatically rising to 293.06% in early 2022 and an extraordinary 8478.95% in early 2023. These spikes align with the leverage increases, potentially amplified by the leveraged capital structure impacting equity returns.

Overall, the company demonstrated improved operating profitability and asset utilization throughout the periods. However, the substantial volatility and extreme jumps in financial leverage and ROE toward the end of the timeline highlight considerable financial risk or atypical accounting events impacting equity returns. The consistency in interest and tax burdens suggests operational stability despite these financial structure changes.


Two-Component Disaggregation of ROA

Fortinet Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Mar 31, 2023 = ×
Dec 31, 2022 = ×
Sep 30, 2022 = ×
Jun 30, 2022 = ×
Mar 31, 2022 = ×
Dec 31, 2021 = ×
Sep 30, 2021 = ×
Jun 30, 2021 = ×
Mar 31, 2021 = ×
Dec 31, 2020 = ×
Sep 30, 2020 = ×
Jun 30, 2020 = ×
Mar 31, 2020 = ×
Dec 31, 2019 = ×
Sep 30, 2019 = ×
Jun 30, 2019 = ×
Mar 31, 2019 = ×

Based on: 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).


The analysis of the financial ratios over the reviewed quarters reveals distinct trends in profitability, asset utilization, and overall asset returns.

Net Profit Margin (%)
The net profit margin experienced moderate fluctuations throughout the period. Initially, it maintained a range around 18-19% through 2019. A slight dip occurred at the end of 2019 to approximately 15%, followed by a gradual recovery through 2020, stabilizing near 18-19%. During 2021, the margin mostly hovered around 18%, showing resilience despite minor decreases mid-year. From early 2022 onward, the margin showed a gradual upward trend, culminating in the highest observed figure of approximately 20.46% by the first quarter of 2023, indicating improving profitability margins.
Asset Turnover (ratio)
The asset turnover ratio showed variability indicative of changes in asset utilization efficiency. It remained stable at approximately 0.58 during the first three quarters of 2019 and then slightly declined by the year-end to 0.55. A marked improvement occurred throughout 2020, peaking mid-year around 0.71 before a mild decline at year-end. The ratio decreased notably in 2021, consistently remaining around 0.52-0.56. However, starting in early 2022, there was a steady increase, reaching a peak of 0.77 in the third quarter of 2022, before a slight decrease toward the end of the period. This pattern suggests phases of enhanced efficiency in asset use, followed by periodic moderation.
Return on Assets (ROA) (%)
The ROA metric reflected trends coherent with the earlier ratios. It began around 11% in early 2019, dipped to 8.4% at the end of that year, then rebounded significantly through 2020, reaching above 12%. In 2021, ROA remained relatively stable in the 9.3% to 10.25% range, indicating some pressure on asset returns. Starting in 2022, there was a notable improvement in ROA, with figures rising from approximately 11.3% to nearly 14.2% by early 2023. This upward trajectory suggests enhanced profitability and efficient asset management during the later periods.

Overall, the data display resilience in profitability margins, coupled with periods of fluctuating asset efficiency. The most recent quarters show improved profitability and stronger returns on assets, supported by increasing asset turnover ratios, which may reflect optimized operations or enhanced revenue generation relative to asset base.


Four-Component Disaggregation of ROA

Fortinet Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Mar 31, 2023 = × × ×
Dec 31, 2022 = × × ×
Sep 30, 2022 = × × ×
Jun 30, 2022 = × × ×
Mar 31, 2022 = × × ×
Dec 31, 2021 = × × ×
Sep 30, 2021 = × × ×
Jun 30, 2021 = × × ×
Mar 31, 2021 = × × ×
Dec 31, 2020 = × × ×
Sep 30, 2020 = × × ×
Jun 30, 2020 = × × ×
Mar 31, 2020 = × × ×
Dec 31, 2019 = × × ×
Sep 30, 2019 = × × ×
Jun 30, 2019 = × × ×
Mar 31, 2019 = × × ×

Based on: 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).


Tax Burden
The tax burden ratio exhibited a declining trend from early 2019 to the end of 2019, decreasing from 1.27 to 0.86. It then stabilized around 0.85 to 0.92 throughout 2020. From 2021 to early 2023, the ratio fluctuated mildly close to 1, mostly ranging between 0.94 and 1.02, indicating relatively stable tax obligations during this period.
Interest Burden
The interest burden remained constant at 1 throughout 2019 and most of 2020, suggesting no interest-related deductions from earnings before tax. Starting in mid-2021, a slight decline to around 0.97-0.98 was observed, indicating a modest increase in interest expenses relative to earnings before interest and taxes, though the change is minor and suggests a stable cost of debt financing overall.
EBIT Margin
The EBIT margin showed a consistent upward trajectory from 14.64% in early 2019 to 20.88% by the end of 2020, demonstrating improved operational efficiency and profitability. The margin slightly declined during early to mid-2021, dropping to approximately 19.02%, but rebounded thereafter, ultimately reaching a peak of 22.12% by the first quarter of 2023. This reflects strong profitability growth with minor fluctuations.
Asset Turnover
Asset turnover initially held steady around 0.58 in 2019 before increasing to a peak of 0.71 in early 2020, indicating improved efficiency in utilizing assets to generate revenue. A decline followed through the latter part of 2020 and early 2021, bottoming around 0.52, but turned upward again from mid-2021, reaching 0.77 by late 2022. It then slightly decreased to 0.69 by the first quarter of 2023. The overall pattern reveals variable asset utilization with recent improvement.
Return on Assets (ROA)
ROA demonstrated a fluctuating but generally upward trend over the analyzed period. Starting near 10.9% in early 2019, it dipped to 8.4% at the end of that year before rising steadily through 2020, peaking just above 12.7% by late 2020. Another dip occurred in 2021, with returns near 9.3%, followed by a significant recovery and continuous growth, reaching 14.15% by early 2023. This shows enhanced overall profitability and asset efficiency in more recent periods.
Summary
Across the reviewed quarters, key profitability measures such as EBIT margin and ROA show a positive growth trend, reflecting improving operational efficiency and asset utilization. The tax burden has stabilized after initial fluctuations, and interest burden remains low and relatively constant, indicating effective management of tax and financing costs. Asset turnover experienced variable performance but displayed recovery and strengthening towards the end of the period. Overall, financial indicators point to strengthened profitability and operational effectiveness, alongside controlled finance-related expenses.

Disaggregation of Net Profit Margin

Fortinet Inc., decomposition of net profit margin ratio (quarterly data)

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Mar 31, 2023 = × ×
Dec 31, 2022 = × ×
Sep 30, 2022 = × ×
Jun 30, 2022 = × ×
Mar 31, 2022 = × ×
Dec 31, 2021 = × ×
Sep 30, 2021 = × ×
Jun 30, 2021 = × ×
Mar 31, 2021 = × ×
Dec 31, 2020 = × ×
Sep 30, 2020 = × ×
Jun 30, 2020 = × ×
Mar 31, 2020 = × ×
Dec 31, 2019 = × ×
Sep 30, 2019 = × ×
Jun 30, 2019 = × ×
Mar 31, 2019 = × ×

Based on: 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).


Tax Burden Ratio
The tax burden ratio shows a declining trend from early 2019 through the first quarter of 2023. Initially, the ratio was above 1.2 in the first half of 2019 but decreased significantly to around 0.85 by the end of 2019 and early 2020. This lower range between 0.85 and 1.02 persisted through 2022. From late 2022 to the first quarter of 2023, the ratio demonstrated minor fluctuations but remained under 1, reaching 0.94 at the end of the data period. The ratio’s downward trend suggests an improvement in tax efficiency or changes in tax strategy over the years.
Interest Burden Ratio
The interest burden ratio remained consistently at 1.0 through most of 2019 and 2020, indicating no interest expense impact on operating income during this period. Starting in mid-2021, the ratio slightly declined to values between 0.97 and 0.99, signaling a modest but stable increase in interest expenses relative to operating earnings. The small decrease suggests some level of financing costs incurred but overall a stable interest expense environment with limited volatility.
EBIT Margin
The EBIT margin exhibited a clear upward trajectory across the reported quarters. Starting at 14.64% in the first quarter of 2019, the margin increased steadily, surpassing 20% in several quarters from mid-2020 onwards. After a small dip towards the end of 2021 and mid-2022 when margins fell to approximately 17.84%-18.12%, the margin rebounded strongly to reach 22.12% by the first quarter of 2023. This indicates improved operating profitability and effective cost management over time, reflecting enhanced earnings from core business operations.
Net Profit Margin
The net profit margin fluctuated moderately within a narrow band throughout the period but generally followed a positive trend. It began at 18.64% in March 2019, rose to above 19% in mid-2019, then experienced a notable dip to approximately 15.14% by the end of 2019. Following this, net margins recovered and stabilized around 17% to 19%, with noticeable improvement occurring from late 2022 into early 2023 where the margin peaked at 20.46%. The pattern suggests effective bottom-line management despite periods of margin contraction, with recent results indicating solid profitability growth.