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 Apple Pay 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
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 = ×
Dec 31, 2019 = ×
Sep 30, 2019 = ×
Jun 30, 2019 = ×
Mar 31, 2019 = ×
Dec 31, 2018 = ×
Sep 30, 2018 = ×

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

The primary reason for the decrease in return on equity ratio (ROE) over Q4 2024 is the decrease in profitability measured by return on assets ratio (ROA).


Three-Component Disaggregation of ROE

Microsoft Corp., decomposition of ROE (quarterly data)

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

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

The primary reason for the decrease in return on equity ratio (ROE) over Q4 2024 is the decrease in efficiency measured by asset turnover ratio.


Two-Component Disaggregation of ROA

Microsoft Corp., decomposition of ROA (quarterly data)

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

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

The primary reason for the decrease in return on assets ratio (ROA) over Q4 2024 is the decrease in asset turnover ratio.