Stock Analysis on Net

Ford Motor Co. (NYSE:F)

$24.99

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

Microsoft Excel

Paying user area


We accept:

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

Two-Component Disaggregation of ROE

Ford Motor Co., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
Mar 31, 2025 = ×
Dec 31, 2024 = ×
Sep 30, 2024 = ×
Jun 30, 2024 = ×
Mar 31, 2024 = ×
Dec 31, 2023 = ×
Sep 30, 2023 = ×
Jun 30, 2023 = ×
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 = ×

Based on: 10-Q (reporting date: 2025-03-31), 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 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).

The analyzed data reveals several key financial performance trends over the observed periods.

Return on Assets (ROA)
The ROA experienced initial negative values in late 2020, indicating inefficiencies or losses during that period. Starting from March 2021, there was a notable improvement with ROA turning positive and peaking in December 2021 at 6.98%, suggesting enhanced asset utilization. However, following this peak, a declining trend surfaced through 2022, even turning negative briefly in early 2023. Subsequently, ROA recovered modestly and remained in a range slightly above 1% to just over 2% toward the end of the dataset. This pattern implies fluctuating efficiency in asset utilization with periods of recovery but some persistent challenges in sustaining high returns.
Financial Leverage
Financial leverage showed a downward trend from early 2020 through the end of 2021, falling from 8.91 to around 5.3, indicative of a reduction in reliance on debt or liabilities relative to equity. From 2022 onward, leverage stabilized within the mid-6 range, showing minor fluctuations but overall maintaining a relatively steady capital structure. The initial reduction followed by stabilization suggests an effort to manage financial risk but with some re-leveraging in recent years.
Return on Equity (ROE)
ROE mirrored the pattern of ROA with significant volatility. It was negative in late 2020, reaching -4.17%, followed by a sharp improvement that peaked dramatically at 36.97% in December 2021, reflecting strong profitability relative to equity during that quarter. After this peak, ROE declined through 2022, again falling into negative territory in early 2023. From mid-2023 forward, there was a recovery trend, but ROE fluctuated between roughly 7% and 14%, indicating moderate profitability with variability. The large swings in ROE highlight changes in both profitability and financial structure over the periods.

Overall, the financial indicators show substantial volatility in profitability with notable peaks in late 2021, followed by periods of decline and recovery. Financial leverage decreased significantly early in the period analyzed and then remained relatively stable, suggesting active management of capital structure. The fluctuations in ROA and ROE suggest the company faced varying operational and financial challenges impacting returns while attempting to balance its financing strategy.


Three-Component Disaggregation of ROE

Ford Motor Co., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Mar 31, 2025 = × ×
Dec 31, 2024 = × ×
Sep 30, 2024 = × ×
Jun 30, 2024 = × ×
Mar 31, 2024 = × ×
Dec 31, 2023 = × ×
Sep 30, 2023 = × ×
Jun 30, 2023 = × ×
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 = × ×

Based on: 10-Q (reporting date: 2025-03-31), 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 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).

The analyzed financial data reveals notable fluctuations and trends across the various key performance indicators over multiple quarters.

Net Profit Margin (%)
The net profit margin exhibits significant variability throughout the periods. Starting with a negative margin in the quarter ending December 31, 2020 (-1.1%), the margin improves steadily to peak at 14.21% by December 31, 2021. Following this peak, there is a downward correction with margins reducing to negative again in the quarter ending December 31, 2022 (-1.33%). Subsequently, the margin recovers progressively, stabilizing within a range of approximately 2.0% to 3.7% from the first quarter of 2023 onward, indicating moderate but consistent profitability.
Asset Turnover (ratio)
Asset turnover data commences from the quarter ending March 31, 2021, showing an initial ratio of 0.43. This ratio gradually increases over time, reaching around 0.61 by late 2023 and maintaining a stable level between 0.60 and 0.61 through to March 31, 2025. This trend suggests an improvement in the efficiency with which assets are used to generate sales, stabilizing at a higher operational performance level in recent periods.
Financial Leverage (ratio)
Financial leverage demonstrates a declining trend from early 2020, decreasing from a high of 8.91 to approximately 5.3 by December 31, 2021. This reduction indicates a deleveraging phase, possibly from debt reduction or increased equity. However, from early 2022 onward, the ratio slightly rebounds and stabilizes around 6.3 to 6.4, implying a maintained moderate leverage position in recent years with limited volatility.
Return on Equity (ROE) (%)
The return on equity reflects marked volatility. It begins with negative ROE in December 2020 (-4.17%), surges to an exceptional level of 36.97% by December 31, 2021, indicative of strong profitability and efficient equity use during that period. However, this high ROE is followed by a substantial decline to negative territory in December 2022 (-4.58%). Subsequent quarters demonstrate a gradual recovery and relative stabilization, with ROE fluctuating mostly between approximately 7.9% and 13.9%, suggesting a reestablishment of profitability but at lower levels than the 2021 peak.

In summary, while experiencing periods of volatility, particularly around late 2020 to 2022, the company shows a general tendency toward operational stabilization. Profitability measures such as net profit margin and ROE underscore recovery cycles with pronounced peaks and corrections. Asset utilization progressively improves and maintains stability, and financial leverage moves toward moderate, consistent levels after an initial deleveraging phase. Overall, these patterns point to a dynamic financial performance environment with signs of measured growth and risk management in recent periods.


Five-Component Disaggregation of ROE

Ford Motor Co., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Mar 31, 2025 = × × × ×
Dec 31, 2024 = × × × ×
Sep 30, 2024 = × × × ×
Jun 30, 2024 = × × × ×
Mar 31, 2024 = × × × ×
Dec 31, 2023 = × × × ×
Sep 30, 2023 = × × × ×
Jun 30, 2023 = × × × ×
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 = × × × ×

Based on: 10-Q (reporting date: 2025-03-31), 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 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).

The financial analysis over the quarterly periods reveals several notable trends and shifts in key performance indicators.

Tax Burden
The tax burden ratio displays some variability, generally fluctuating around the value of 1. It reached values slightly above 1.2 in late 2022 and early 2024, indicating a higher tax impact relative to pre-tax income during these periods. Some quarters show a decline toward values near 0.8, suggesting lower effective taxation or tax benefits in certain quarters, especially noted toward the end of the timeline.
Interest Burden
The interest burden ratio exhibits pronounced volatility at the beginning of the recorded periods, with a notably negative figure in the fourth quarter of 2020. Following this, the ratio stabilizes around the range of 0.6 to 0.9, suggesting consistent interest expense management relative to earnings before interest and taxes. The values remain relatively stable in recent quarters, indicating no significant changes in interest expense coverage.
EBIT Margin
The EBIT margin shows a substantial increase from negative or near-zero values during 2020 to a peak of over 15% in the fourth quarter of 2020. After this peak, there is a gradual decline, stabilizing mostly between 2% and 6% in subsequent quarters. This pattern indicates a recovery and strengthening in operating profitability post-2020 with some moderation in recent periods. The negative EBIT margin observed in early 2022 stands out as an anomaly but is quickly reversed.
Asset Turnover
Asset turnover ratios reflect a gradual improvement over the period, rising from approximately 0.43 to a range consistently around 0.60 to 0.61 by the end of the analyzed timeframe. This trend suggests enhanced efficiency in the use of assets to generate sales, with a stable performance in the last several quarters.
Financial Leverage
Financial leverage ratios indicate a declining trend from very high levels above 8.5 in early 2020 to a range around 6.0 in 2023 and onward. This reduction may imply a decrease in reliance on debt financing or improved asset base growth relative to equity. The relative stability after this decline suggests a balanced approach to capital structure in recent periods.
Return on Equity (ROE)
ROE shows considerable variability with very low or negative returns during some early quarters in 2020, followed by a strong rebound reaching peak values near 37% towards the end of 2020. Subsequently, ROE moderated to more sustainable levels, ranging roughly between 7% and 13% in recent quarters. This reflects an initial recovery phase and then a steady state of profitability for shareholders, with some fluctuations aligned with changes in EBIT margin and leverage.

Overall, the data reflects a recovery and strengthening phase after early 2020 disruptions, marked by improved profitability, asset utilization, and capital structure management. Some volatility in interest and tax burdens requires ongoing monitoring, but the general direction points towards operational and financial stabilization and incremental performance improvements over the observed timeframe.


Two-Component Disaggregation of ROA

Ford Motor Co., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Mar 31, 2025 = ×
Dec 31, 2024 = ×
Sep 30, 2024 = ×
Jun 30, 2024 = ×
Mar 31, 2024 = ×
Dec 31, 2023 = ×
Sep 30, 2023 = ×
Jun 30, 2023 = ×
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 = ×

Based on: 10-Q (reporting date: 2025-03-31), 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 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).

Net Profit Margin
The net profit margin exhibits considerable volatility throughout the observed periods. Starting from a negative position of -1.1% in December 2020, it increased to a peak of 14.21% by December 2021, indicating a significant improvement in profitability. However, following this peak, the margin declined steadily to negative territory again at -1.33% in December 2022. Subsequently, the margin showed a recovery trend, fluctuating between approximately 1.85% and 3.75% through 2023 and early 2024. By March 2025, the margin stabilized around 2.95%. Overall, the margin has shown cyclical behavior with pronounced peaks and troughs, reflecting periods of both strong profitability and losses.
Asset Turnover
Asset turnover demonstrates a generally positive and stable trend over the periods. Beginning at 0.43 in December 2020, it gradually increased to around 0.61 by late 2023 and remained relatively constant at this level through early 2025. This stability suggests efficient and consistent utilization of assets in generating revenue. There is no indication of significant declines, with only minor fluctuations between 0.49 and 0.61. The consistent asset turnover ratio indicates effective asset management during the periods analyzed.
Return on Assets (ROA)
Return on assets mirrors the general pattern observed in net profit margin but with less dramatic fluctuations. Starting from a negative -0.48% in December 2020, ROA rose to a high of 6.98% in December 2021, highlighting improved asset efficiency and profitability. This was followed by a decline, including a return to negative -0.77% in December 2022, before recovering modestly over the subsequent quarters. Between early 2023 and March 2025, ROA values fluctuated between roughly 1.12% and 2.3%, indicating moderate and fairly stable returns on asset investments. The trend suggests sensitivity to profit margin changes while benefiting from steady asset turnover.

Four-Component Disaggregation of ROA

Ford Motor Co., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Mar 31, 2025 = × × ×
Dec 31, 2024 = × × ×
Sep 30, 2024 = × × ×
Jun 30, 2024 = × × ×
Mar 31, 2024 = × × ×
Dec 31, 2023 = × × ×
Sep 30, 2023 = × × ×
Jun 30, 2023 = × × ×
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 = × × ×

Based on: 10-Q (reporting date: 2025-03-31), 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 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).

Tax Burden
The tax burden ratio shows fluctuations over the observed periods, starting from 1 in early 2021 and displaying values mostly above 0.8. Peaks occur around 1.25 in late 2022, followed by a dip below 0.9 in mid-2023, and then stabilizing near 1 toward early 2025. This pattern suggests variations in effective tax rates impacting net profit margins unevenly over time.
Interest Burden
Interest burden ratios are volatile, with an extreme negative value observed in late 2020 (-2.11), followed by consistent positive ratios generally below 1 in subsequent periods. From 2021 onward, values remain relatively stable between 0.6 and 0.9, reflecting ongoing interest expenses that moderately constrain pre-tax profitability but without extreme fluctuations after 2020.
EBIT Margin
The EBIT margin exhibits substantial variability. Initial readings in 2020 are low or slightly negative, but a notable increase occurs in late 2020 through early 2021 with a peak margin above 15%. After this peak, margins decline, reaching negative territory briefly at the start of 2023, before recovering to a range of approximately 2.5% to 5% toward the end of the dataset. This indicates episodic improvements in operating profitability followed by cyclical contractions and recoveries.
Asset Turnover
Asset turnover shows a gradual increasing trend, starting below 0.5 in early 2020, rising steadily to around 0.6 by mid-2023, and maintaining this level through early 2025. This suggests improving efficiency in generating revenue from asset utilization over the observed timeframe.
Return on Assets (ROA)
The ROA follows a pattern similar to EBIT margin, with values hovering near zero or slightly negative in early 2020, then rising to a peak close to 7% at the end of 2020. A general decline follows, with lows below zero or near zero in early 2023, and a partial recovery to around 1.5% to 2% toward early 2025. This reflects fluctuating profitability relative to asset base influenced by varying operational and financial performance across periods.

Disaggregation of Net Profit Margin

Ford Motor Co., decomposition of net profit margin ratio (quarterly data)

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Mar 31, 2025 = × ×
Dec 31, 2024 = × ×
Sep 30, 2024 = × ×
Jun 30, 2024 = × ×
Mar 31, 2024 = × ×
Dec 31, 2023 = × ×
Sep 30, 2023 = × ×
Jun 30, 2023 = × ×
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 = × ×

Based on: 10-Q (reporting date: 2025-03-31), 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 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).

Tax Burden
The tax burden ratio exhibits variability over the observed periods, initially ranging around 1.00 in early 2021, increasing to a peak above 1.25 in late 2022, indicating higher tax expense relative to pre-tax income during that time. After this peak, the ratio declined to values near 0.81 by early 2025, suggesting a lower effective tax rate or reduced tax impact on earnings in recent quarters.
Interest Burden
The interest burden ratio showed a marked negative value (-2.11) in the fourth quarter of 2020, indicating significant interest expenses or losses relative to operating income. Following this, the ratio improved considerably, stabilizing in the range of approximately 0.60 to 0.91 through 2021 and 2022, and then showing slight fluctuations within 0.72 to 0.87 in subsequent periods. This stabilization suggests a reduction in the relative interest expense burden from mid-2021 onwards.
EBIT Margin
The EBIT margin started at a low 0.46% in the fourth quarter of 2020, then experienced substantial growth with peaks reaching over 15% in late 2021. Thereafter, it declined steadily but remained positive, fluctuating between approximately 2% and 6% through 2022 to early 2025. Notably, there was a negative EBIT margin of -1.06% in early 2022, indicating a quarter of operational losses, before a recovery trend took hold. The margin's overall trajectory reflects periods of operational challenges followed by recovery and moderate profitability.
Net Profit Margin
Net profit margins mirrored the trends observed in EBIT margins, starting with a negative margin of -1.1% in late 2020. This was followed by an increasing trend peaking at over 14% in late 2021, indicating strong net profitability during that quarter. Subsequently, the margin decreased and showed volatility, including a negative margin of -1.33% in early 2022. From mid-2022 onward, net profit margins remained positive but moderate, fluctuating around 2% to 3.75%. The variance in net margins reflects sensitivity to operational performance and tax/interest impacts across the periods.