Microsoft Excel LibreOffice Calc

Microsoft Corp. (NASDAQ:MSFT)

Paying users zone. Data is hidden behind: .

  • Get 1-month access to Microsoft Corp. for $19.99, or

  • get full access to the entire website for at least 3 months from $49.99.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Apple Pay Google Pay
Verified by Visa MasterCard SecureCode American Express SafeKey

This is a one-time payment. There is no automatic renewal.


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

Beginner level


Two-Component Disaggregation of ROE

Microsoft Corp., decomposition of ROE (quarterly data)

Microsoft Excel LibreOffice Calc
ROE = ROA × Financial Leverage
Mar 31, 2020 = ×
Dec 31, 2019 = ×
Sep 30, 2019 = ×
Jun 30, 2019 = ×
Mar 31, 2019 = ×
Dec 31, 2018 = ×
Sep 30, 2018 = ×
Jun 30, 2018 = ×
Mar 31, 2018 = ×
Dec 31, 2017 = ×
Sep 30, 2017 = ×
Jun 30, 2017 = ×
Mar 31, 2017 = ×
Dec 31, 2016 = ×
Sep 30, 2016 = ×
Jun 30, 2016 = ×
Mar 31, 2016 = ×
Dec 31, 2015 = ×
Sep 30, 2015 = ×
Jun 30, 2015 = ×
Mar 31, 2015 = ×
Dec 31, 2014 = ×
Sep 30, 2014 = ×
Jun 30, 2014 = ×
Mar 31, 2014 = ×
Dec 31, 2013 = ×
Sep 30, 2013 = ×

Based on: 10-Q (filing date: 2020-04-29), 10-Q (filing date: 2020-01-29), 10-Q (filing date: 2019-10-23), 10-K (filing date: 2019-08-01), 10-Q (filing date: 2019-04-24), 10-Q (filing date: 2019-01-30), 10-Q (filing date: 2018-10-24), 10-K (filing date: 2018-08-03), 10-Q (filing date: 2018-04-26), 10-Q (filing date: 2018-01-31), 10-Q (filing date: 2017-10-26), 10-K (filing date: 2017-08-02), 10-Q (filing date: 2017-04-27), 10-Q (filing date: 2017-01-26), 10-Q (filing date: 2016-10-20), 10-K (filing date: 2016-07-28), 10-Q (filing date: 2016-04-21), 10-Q (filing date: 2016-01-28), 10-Q (filing date: 2015-10-22), 10-K (filing date: 2015-07-31), 10-Q (filing date: 2015-04-23), 10-Q (filing date: 2015-01-26), 10-Q (filing date: 2014-10-23), 10-K (filing date: 2014-07-31), 10-Q (filing date: 2014-04-24), 10-Q (filing date: 2014-01-23), 10-Q (filing date: 2013-10-24).

The primary reason for the increase in return on equity ratio (ROE) over Q3 2020 is the increase in profitability measured by return on assets ratio (ROA).


Three-Component Disaggregation of ROE

Microsoft Corp., decomposition of ROE (quarterly data)

Microsoft Excel LibreOffice Calc
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Mar 31, 2020 = × ×
Dec 31, 2019 = × ×
Sep 30, 2019 = × ×
Jun 30, 2019 = × ×
Mar 31, 2019 = × ×
Dec 31, 2018 = × ×
Sep 30, 2018 = × ×
Jun 30, 2018 = × ×
Mar 31, 2018 = × ×
Dec 31, 2017 = × ×
Sep 30, 2017 = × ×
Jun 30, 2017 = × ×
Mar 31, 2017 = × ×
Dec 31, 2016 = × ×
Sep 30, 2016 = × ×
Jun 30, 2016 = × ×
Mar 31, 2016 = × ×
Dec 31, 2015 = × ×
Sep 30, 2015 = × ×
Jun 30, 2015 = × ×
Mar 31, 2015 = × ×
Dec 31, 2014 = × ×
Sep 30, 2014 = × ×
Jun 30, 2014 = × ×
Mar 31, 2014 = × ×
Dec 31, 2013 = × ×
Sep 30, 2013 = × ×

Based on: 10-Q (filing date: 2020-04-29), 10-Q (filing date: 2020-01-29), 10-Q (filing date: 2019-10-23), 10-K (filing date: 2019-08-01), 10-Q (filing date: 2019-04-24), 10-Q (filing date: 2019-01-30), 10-Q (filing date: 2018-10-24), 10-K (filing date: 2018-08-03), 10-Q (filing date: 2018-04-26), 10-Q (filing date: 2018-01-31), 10-Q (filing date: 2017-10-26), 10-K (filing date: 2017-08-02), 10-Q (filing date: 2017-04-27), 10-Q (filing date: 2017-01-26), 10-Q (filing date: 2016-10-20), 10-K (filing date: 2016-07-28), 10-Q (filing date: 2016-04-21), 10-Q (filing date: 2016-01-28), 10-Q (filing date: 2015-10-22), 10-K (filing date: 2015-07-31), 10-Q (filing date: 2015-04-23), 10-Q (filing date: 2015-01-26), 10-Q (filing date: 2014-10-23), 10-K (filing date: 2014-07-31), 10-Q (filing date: 2014-04-24), 10-Q (filing date: 2014-01-23), 10-Q (filing date: 2013-10-24).

The primary reason for the increase in return on equity ratio (ROE) over Q3 2020 is the increase in efficiency measured by asset turnover ratio.


Two-Component Disaggregation of ROA

Microsoft Corp., decomposition of ROA (quarterly data)

Microsoft Excel LibreOffice Calc
ROA = Net Profit Margin × Asset Turnover
Mar 31, 2020 = ×
Dec 31, 2019 = ×
Sep 30, 2019 = ×
Jun 30, 2019 = ×
Mar 31, 2019 = ×
Dec 31, 2018 = ×
Sep 30, 2018 = ×
Jun 30, 2018 = ×
Mar 31, 2018 = ×
Dec 31, 2017 = ×
Sep 30, 2017 = ×
Jun 30, 2017 = ×
Mar 31, 2017 = ×
Dec 31, 2016 = ×
Sep 30, 2016 = ×
Jun 30, 2016 = ×
Mar 31, 2016 = ×
Dec 31, 2015 = ×
Sep 30, 2015 = ×
Jun 30, 2015 = ×
Mar 31, 2015 = ×
Dec 31, 2014 = ×
Sep 30, 2014 = ×
Jun 30, 2014 = ×
Mar 31, 2014 = ×
Dec 31, 2013 = ×
Sep 30, 2013 = ×

Based on: 10-Q (filing date: 2020-04-29), 10-Q (filing date: 2020-01-29), 10-Q (filing date: 2019-10-23), 10-K (filing date: 2019-08-01), 10-Q (filing date: 2019-04-24), 10-Q (filing date: 2019-01-30), 10-Q (filing date: 2018-10-24), 10-K (filing date: 2018-08-03), 10-Q (filing date: 2018-04-26), 10-Q (filing date: 2018-01-31), 10-Q (filing date: 2017-10-26), 10-K (filing date: 2017-08-02), 10-Q (filing date: 2017-04-27), 10-Q (filing date: 2017-01-26), 10-Q (filing date: 2016-10-20), 10-K (filing date: 2016-07-28), 10-Q (filing date: 2016-04-21), 10-Q (filing date: 2016-01-28), 10-Q (filing date: 2015-10-22), 10-K (filing date: 2015-07-31), 10-Q (filing date: 2015-04-23), 10-Q (filing date: 2015-01-26), 10-Q (filing date: 2014-10-23), 10-K (filing date: 2014-07-31), 10-Q (filing date: 2014-04-24), 10-Q (filing date: 2014-01-23), 10-Q (filing date: 2013-10-24).

The primary reason for the increase in return on assets ratio (ROA) over Q3 2020 is the increase in asset turnover ratio.