Stock Analysis on Net

Alphabet Inc. (NASDAQ:GOOG)

$24.99

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

Microsoft Excel

Two-Component Disaggregation of ROE

Alphabet Inc., 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 financial data reveals evolving trends in key profitability and capital structure measures over a series of quarters from 2020 through 2025.

Return on Assets (ROA)

The Return on Assets demonstrates a consistent upward trajectory starting at 12.6% in March 2020 and increasing steadily to 23.35% by March 2025. This progression indicates improving efficiency in asset utilization to generate earnings. The ROA peaked around the end of 2021 at 21.16% then showed a moderate decline during 2022 before recovering and sustaining growth through 2024 and early 2025.

Financial Leverage

Financial leverage ratios remained relatively stable within a narrow band around 1.34 to 1.45 over the timeframe. Slight fluctuations in the leverage ratio suggest the company maintained a consistent financing strategy with limited variations in debt relative to equity. No significant increases or drops were observed, indicating a conservative approach to leverage without considerable shifts in capital structure.

Return on Equity (ROE)

The Return on Equity trends parallel the ROA but at higher levels, reflecting the impact of financial leverage on shareholder returns. Starting from 18.09% in early 2020, ROE shows sustained growth reaching above 32% by March 2025. The trend features a peak near 30.22% at the end of 2021, a slight pullback in 2022, and subsequent recovery and improvement thereafter. This pattern underscores increasing profitability for equity holders supported by stable leverage.

In summary, the data reveals steady improvement in profitability metrics with ROA and ROE rising significantly over the five-year period. The minimal variation in financial leverage suggests that these profitability gains are predominantly driven by operational efficiencies rather than changes in capital structure or risk exposure. The observed trends point to a robust enhancement in asset utilization and equity returns, aligned with prudent financial management practices.


Three-Component Disaggregation of ROE

Alphabet Inc., 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 data reflects the quarterly financial performance indicators including Net Profit Margin, Asset Turnover, Financial Leverage, and Return on Equity (ROE) over several years.

Net Profit Margin
The Net Profit Margin exhibits a general upward trend from the first available data in March 31, 2020 at 22.06% to 30.86% by March 31, 2025. After peaking near 29.52% at the end of 2020, the margin shows a gradual decline through 2022, reaching a low of 20.58% in mid-2023. However, from that point onward, it steadily recovers and surpasses previous highs, indicating improving profitability towards the end of the period.
Asset Turnover
Asset Turnover steadily increases from 0.57 in Q1 2020 to a peak of 0.79 between Q3 2022 and Q3 2024, indicating improved efficiency in using assets to generate sales. There is a slight decrease towards the final quarters, ending at 0.76 by March 31, 2025, which still remains higher than the initial periods. This suggests consistent operational improvement with slight fluctuations towards the end.
Financial Leverage
Financial Leverage shows relatively minor variations, generally fluctuating between 1.34 and 1.45 over the entire period. The leverage ratio peaks around 1.45 in Q4 2023 but trends slightly downwards thereafter to 1.38 by Q1 2025, suggesting a stable but cautiously managed use of debt relative to equity throughout the years.
Return on Equity (ROE)
ROE, mirroring the trends in profitability, rises from 18.09% in early 2020 to over 32% by Q1 2025. After an initial improvement through 2021 and a peak near 30.22% in Q1 2022, ROE dips moderately to 22.46% in mid-2023 but then accelerates upward to reach the highest recorded figure in the data. This demonstrates strengthened overall equity returns, likely supported by improvements in profit margins and asset turnover.

Overall, the financial ratios indicate that the company has experienced enhanced profitability and efficiency in asset utilization over time, with stable financial leverage. The temporary mid-term dip in profitability and returns observed around 2022-2023 was followed by a significant recovery, leading to strong financial performance by early 2025.


Two-Component Disaggregation of ROA

Alphabet Inc., 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 a clear upward trend over the analyzed periods. Starting from 22.06% in March 2020, it rose steadily, reaching a peak of 29.52% by December 2020. Following this, the margin experienced a gradual decline through 2022, bottoming at 20.58% in June 2023. From that point onward, the margin has recovered consistently, ascending to 30.86% by March 2025. Overall, the data reflects sustained profitability improvement, with temporary fluctuations likely influenced by external or operational factors.
Asset Turnover
The asset turnover ratio shows a gradual increase beginning at 0.57 in March 2020 and peaking at 0.79 between September 2022 and September 2024. Thereafter, a slight decline is noted, ending at 0.76 in March 2025. This pattern indicates a general enhancement in the efficiency of asset use to generate revenue over time, though the minor decrease toward the end may suggest a stabilization or modest slowdown in asset utilization efficiency.
Return on Assets (ROA)
Return on assets displays a consistent upward trajectory from 12.6% in March 2020 to 20.33% in December 2020. This is followed by a moderate decline through late 2022, reaching 15.86% in June 2023. Subsequently, ROA steadily improves, culminating at 23.35% by March 2025. The trend implies an overall enhancement in the company’s ability to generate profits from its assets, with a period of slower growth or pressure in the middle of the timeline.