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

Two-Component Disaggregation of ROE

Microsoft Corp., decomposition of ROE (quarterly data)

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

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


The Return on Equity (ROE) exhibited an initial upward trajectory, peaking in late 2021 before entering a prolonged period of contraction. From a high of 44.67% in September 2021, the ROE declined to 30.22% by March 2026, reflecting a shift in both operational efficiency and capital structure.

Return on Assets (ROA)
Asset efficiency showed an initial strengthening phase, rising from 15.78% in September 2020 to a peak of 21.03% in March 2022. Following this peak, a gradual deceleration occurred, with the ratio stabilizing between 16.45% and 18.04% throughout 2024 and 2025. This suggests a period of significant growth in asset productivity that eventually normalized.
Financial Leverage
A consistent deleveraging trend is observed across the entire analyzed period. The financial leverage ratio decreased steadily from 2.44 in September 2020 to 1.68 by March 2026. This sustained reduction indicates a strategic shift toward a more equity-heavy capital structure and a reduced reliance on debt to finance assets.
Integrated DuPont Impact
The overall decline in ROE is the result of dual compression. Between 2020 and 2021, the increase in ROA was sufficient to offset the declining leverage, resulting in an overall rise in ROE. However, from 2022 onward, both ROA and financial leverage trended downward simultaneously, compounding the negative pressure on the ROE and leading to its transition from the mid-40% range to approximately 30%.

Three-Component Disaggregation of ROE

Microsoft Corp., decomposition of ROE (quarterly data)

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

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


The Return on Equity (ROE) exhibits a distinct bell-shaped trajectory over the analyzed period, peaking at 44.67% in September 2021 before entering a sustained decline to 30.22% by March 2026. This overall movement is the result of diverging trends among the three DuPont components: expanding profit margins, fluctuating asset efficiency, and a consistent reduction in financial leverage.

Net Profit Margin
Profitability demonstrates significant resilience and a general upward trend. The margin increased from 32.29% in September 2020 to a peak of 38.51% in late 2021. Despite a temporary contraction to 33.05% by December 2022, a recovery phase followed, with the margin reaching its highest point of 39.34% by March 2026. This suggests that operational efficiency and pricing power improved over the long term, acting as a primary support for ROE.
Asset Turnover
Asset utilization improved during the initial phase, rising from 0.49 in September 2020 to a peak of 0.56 in 2022. However, a gradual decline is observed starting in 2023, with the ratio stabilizing at 0.46 from June 2024 through March 2026. This indicates a decrease in the efficiency of assets in generating revenue, which contributed to the softening of the ROE in the latter half of the period.
Financial Leverage
A consistent and systemic reduction in financial leverage is observed throughout the period. The leverage ratio declined steadily from 2.44 in September 2020 to 1.68 by March 2026. This deleveraging process represents a shift toward a more conservative capital structure with less reliance on debt, which served as the primary downward driver for ROE, offsetting the gains achieved through higher profit margins.
ROE Synthesis
The initial surge in ROE through 2021 was driven by a combination of expanding margins and increasing asset turnover. The subsequent decline in ROE was not caused by a failure in profitability—which actually trended upward—but was rather a direct consequence of the aggressive reduction in financial leverage and the slight deterioration in asset turnover. By the end of the period, the company achieved higher net margins but realized a lower ROE due to a significantly lower equity multiplier.

Two-Component Disaggregation of ROA

Microsoft Corp., decomposition of ROA (quarterly data)

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

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


The Return on Assets (ROA) exhibits a cyclical trajectory, characterized by an initial expansion phase peaking in early 2022, followed by a period of contraction and subsequent stabilization. ROA rose from 15.78% in September 2020 to a peak of 21.03% by March 2022. Following this peak, a downward trend occurred, with the ratio settling into a range between 16.45% and 18.04% through the remainder of the period, ending at 18.04% in March 2026.

Net Profit Margin
The profit margin demonstrates significant volatility with an overall upward bias. An initial growth phase saw margins climb from 32.29% to a peak of 38.51% in September 2021. A subsequent correction led to a low of 33.05% in December 2022. From 2023 through 2024, margins remained relatively stable in the 34% to 36% range, before exhibiting a strong upward trend toward the end of the analyzed period, reaching 39.34% by March 2026.
Asset Turnover
Asset utilization efficiency showed an early improvement trend, rising from 0.49 in September 2020 to a plateau of 0.56 between March and September 2022. However, a persistent decline in asset turnover is observed from March 2023 (0.55) onward, eventually stabilizing at 0.46 from June 2025 through March 2026. This indicates a decrease in the revenue generated per unit of asset employed over the latter half of the period.
ROA Disaggregation Analysis
The fluctuations in ROA are the result of opposing forces between profitability and asset efficiency. The peak ROA in March 2022 was driven by the convergence of high net profit margins (37.63%) and peak asset turnover (0.56). The subsequent decline in ROA was primarily precipitated by the steady erosion of asset turnover. In the final stages of the period, the recovery of ROA to 18.04% is attributed exclusively to expanding net profit margins, which offset the continued stagnation in asset turnover at 0.46.