Stock Analysis on Net
Stock Analysis on Net

Microsoft Corp. (NASDAQ:MSFT)

$24.99

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 Maestro Discover JCB PayPal Google Pay
Visa Secure Mastercard Identity Check

Two-Component Disaggregation of ROE

Microsoft Corp., decomposition of ROE (quarterly data)

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

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


The overall Return on Equity (ROE) exhibits a sustained downward trajectory over the analyzed period, declining from a peak of 44.67% in September 2021 to 30.23% by June 2026. This contraction indicates a reduction in the returns generated for shareholders, driven by simultaneous declines in both operational asset efficiency and the degree of financial leverage employed.

Return on Assets (ROA)
Asset efficiency experienced a gradual decline, starting at 20.24% and reaching a peak of 21.03% in March 2022 before entering a downward trend. Following this peak, ROA generally decreased, settling into a range between 16.45% and 18.04% from 2023 through 2026. This trend suggests a slight erosion in the capacity to generate earnings from the total asset base.
Financial Leverage
A consistent reduction in financial leverage is observed, moving from 2.21 in September 2021 to 1.71 by June 2026. The ratio remained above 2.0 until September 2022, after which it trended lower, reaching a minimum of 1.68 in March 2026. This downward movement reflects a decrease in the proportion of debt used to finance assets, which reduces the magnification effect on equity returns.
ROE Disaggregation and Synthesis
The compression of ROE is the result of the combined impact of declining ROA and reduced financial leverage. While the decrease in ROA lowered the fundamental earnings power of assets, the decline in leverage reduced the multiplier effect that amplifies ROA into ROE. The most significant period of ROE erosion occurred between June 2022 and September 2023, coinciding with the most rapid declines in both components. Data from 2025 to 2026 indicates a period of relative stabilization, with ROE fluctuating narrowly around the 30% mark.

Three-Component Disaggregation of ROE

Microsoft Corp., decomposition of ROE (quarterly data)

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

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


The Return on Equity (ROE) exhibits a sustained downward trajectory over the analyzed period, declining from a peak of 44.67% in September 2021 to 30.23% by June 2026. Although a slight stabilization is observed in the final quarters, the overall trend reflects a significant reduction in the efficiency with which equity is utilized to generate profit.

Net Profit Margin
Profitability shows a cyclical pattern, initially declining from 38.51% in September 2021 to a low of 33.05% by December 2022. However, a consistent recovery phase followed, with margins expanding to reach a period high of 40.31% by June 2026. This indicates that the company successfully improved its operational efficiency and pricing power over the long term.
Asset Turnover
A gradual decline in asset efficiency is observed. After peaking at 0.56 in late 2022, the asset turnover ratio trended downward to 0.44 by June 2026. This contraction suggests that the company is generating less revenue for every unit of assets held, potentially indicating significant capital expenditures that have not yet reached full revenue-generating capacity.
Financial Leverage
The financial leverage ratio demonstrates a steady and persistent decrease, moving from 2.21 in September 2021 to 1.71 by June 2026. This downward trend reflects a strategic reduction in the use of debt to finance assets, resulting in a more conservative capital structure and a reduced reliance on financial gearing to amplify returns.

The DuPont disaggregation reveals a divergence between profitability and overall equity returns. While the net profit margin improved substantially toward the end of the period, this gain was offset by the simultaneous decline in both asset turnover and financial leverage. Consequently, the reduction in ROE is primarily driven by a deleveraging of the balance sheet and a decrease in asset productivity rather than a failure in operational profitability.


Two-Component Disaggregation of ROA

Microsoft Corp., decomposition of ROA (quarterly data)

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

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


The Return on Assets (ROA) exhibits a general downward trajectory over the analyzed period, declining from a peak of 21.03% in March 2022 to 17.64% by June 2026. This contraction is characterized by an initial period of stability followed by a sustained decline that bottomed out in mid-2025, before experiencing a modest recovery in the final quarters.

Net Profit Margin
Profitability margins underwent a cyclical fluctuation. An initial decline was observed from September 2021 (38.51%) to a trough of 33.05% in December 2022. Following this period, margins recovered steadily throughout 2023 and 2024. A significant expansion occurred in the final stages of the period, with margins climbing to a peak of 40.31% by June 2026, indicating improved cost management or higher-margin revenue streams in the later years.
Asset Turnover
Asset utilization efficiency shows a consistent long-term decline. After maintaining a range between 0.53 and 0.56 from September 2021 through December 2022, the ratio began a gradual descent. The turnover rate dropped below 0.50 in September 2023 and continued to erode, reaching a period low of 0.44 by June 2026. This suggests that asset growth has outpaced the growth in generated revenue.
ROA Drivers and Interaction
The disaggregation of ROA reveals a divergence between profitability and efficiency. While the Net Profit Margin eventually recovered and surpassed its initial levels, the overall ROA remained suppressed due to the continuous decline in Asset Turnover. The positive momentum in profit margins during 2025 and 2026 partially offset the diminishing asset efficiency, preventing a further collapse in ROA and facilitating a slight upward correction toward the end of the series.