Stock Analysis on Net
Stock Analysis on Net

Microsoft Corp. (NASDAQ:MSFT)

$19.99

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.

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Microsoft Excel LibreOffice Calc

Long-term Activity Ratios (Summary)

Microsoft Corp., long-term (investment) activity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
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 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
Net fixed asset turnover
Net fixed asset turnover (including operating lease, right-of-use asset)
Total asset turnover
Equity turnover

Based on: 10-Q (filing date: 2021-10-26), 10-K (filing date: 2021-07-29), 10-Q (filing date: 2021-04-27), 10-Q (filing date: 2021-01-26), 10-Q (filing date: 2020-10-27), 10-K (filing date: 2020-07-31), 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).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Microsoft Corp.’s net fixed asset turnover ratio deteriorated from Q3 2021 to Q4 2021 and from Q4 2021 to Q1 2022.
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Microsoft Corp.’s net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q3 2021 to Q4 2021 and from Q4 2021 to Q1 2022.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Microsoft Corp.’s total asset turnover ratio deteriorated from Q3 2021 to Q4 2021 but then improved from Q4 2021 to Q1 2022 exceeding Q3 2021 level.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Microsoft Corp.’s equity turnover ratio deteriorated from Q3 2021 to Q4 2021 and from Q4 2021 to Q1 2022.

Net Fixed Asset Turnover

Microsoft Corp., net fixed asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 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
Selected Financial Data (US$ in millions)
Revenue
Property and equipment, net of accumulated depreciation
Long-term Activity Ratio
Net fixed asset turnover1
Benchmarks
Net Fixed Asset Turnover, Competitors2
Accenture PLC
Adobe Inc.
Autodesk Inc.
Automatic Data Processing Inc.
Fidelity National Information Services Inc.
Fiserv Inc.
International Business Machines Corp.
Intuit Inc.
Mastercard Inc.
Oracle Corp.
PayPal Holdings Inc.
salesforce.com inc.
ServiceNow Inc.
Visa Inc.

Based on: 10-Q (filing date: 2021-10-26), 10-K (filing date: 2021-07-29), 10-Q (filing date: 2021-04-27), 10-Q (filing date: 2021-01-26), 10-Q (filing date: 2020-10-27), 10-K (filing date: 2020-07-31), 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).

1 Q1 2022 Calculation
Net fixed asset turnover = (RevenueQ1 2022 + RevenueQ4 2021 + RevenueQ3 2021 + RevenueQ2 2021) ÷ Property and equipment, net of accumulated depreciation
= ( + + + ) ÷ =

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Microsoft Corp.’s net fixed asset turnover ratio deteriorated from Q3 2021 to Q4 2021 and from Q4 2021 to Q1 2022.

Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)

Microsoft Corp., net fixed asset turnover (including operating lease, right-of-use asset) calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 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
Selected Financial Data (US$ in millions)
Revenue
 
Property and equipment, net of accumulated depreciation
Operating lease right-of-use assets
Property and equipment, net of accumulated depreciation (including operating lease, right-of-use asset)
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
Accenture PLC
Adobe Inc.
Autodesk Inc.
Automatic Data Processing Inc.
International Business Machines Corp.
Intuit Inc.
salesforce.com inc.
ServiceNow Inc.

Based on: 10-Q (filing date: 2021-10-26), 10-K (filing date: 2021-07-29), 10-Q (filing date: 2021-04-27), 10-Q (filing date: 2021-01-26), 10-Q (filing date: 2020-10-27), 10-K (filing date: 2020-07-31), 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).

1 Q1 2022 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = (RevenueQ1 2022 + RevenueQ4 2021 + RevenueQ3 2021 + RevenueQ2 2021) ÷ Property and equipment, net of accumulated depreciation (including operating lease, right-of-use asset)
= ( + + + ) ÷ =

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Microsoft Corp.’s net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q3 2021 to Q4 2021 and from Q4 2021 to Q1 2022.

Total Asset Turnover

Microsoft Corp., total asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 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
Selected Financial Data (US$ in millions)
Revenue
Total assets
Long-term Activity Ratio
Total asset turnover1
Benchmarks
Total Asset Turnover, Competitors2
Accenture PLC
Adobe Inc.
Autodesk Inc.
Automatic Data Processing Inc.
Fidelity National Information Services Inc.
Fiserv Inc.
International Business Machines Corp.
Intuit Inc.
Mastercard Inc.
Oracle Corp.
PayPal Holdings Inc.
salesforce.com inc.
ServiceNow Inc.
Visa Inc.

Based on: 10-Q (filing date: 2021-10-26), 10-K (filing date: 2021-07-29), 10-Q (filing date: 2021-04-27), 10-Q (filing date: 2021-01-26), 10-Q (filing date: 2020-10-27), 10-K (filing date: 2020-07-31), 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).

1 Q1 2022 Calculation
Total asset turnover = (RevenueQ1 2022 + RevenueQ4 2021 + RevenueQ3 2021 + RevenueQ2 2021) ÷ Total assets
= ( + + + ) ÷ =

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Microsoft Corp.’s total asset turnover ratio deteriorated from Q3 2021 to Q4 2021 but then improved from Q4 2021 to Q1 2022 exceeding Q3 2021 level.

Equity Turnover

Microsoft Corp., equity turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 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
Selected Financial Data (US$ in millions)
Revenue
Stockholders’ equity
Long-term Activity Ratio
Equity turnover1
Benchmarks
Equity Turnover, Competitors2
Accenture PLC
Adobe Inc.
Autodesk Inc.
Automatic Data Processing Inc.
Fidelity National Information Services Inc.
Fiserv Inc.
International Business Machines Corp.
Intuit Inc.
Mastercard Inc.
Oracle Corp.
PayPal Holdings Inc.
salesforce.com inc.
ServiceNow Inc.
Visa Inc.

Based on: 10-Q (filing date: 2021-10-26), 10-K (filing date: 2021-07-29), 10-Q (filing date: 2021-04-27), 10-Q (filing date: 2021-01-26), 10-Q (filing date: 2020-10-27), 10-K (filing date: 2020-07-31), 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).

1 Q1 2022 Calculation
Equity turnover = (RevenueQ1 2022 + RevenueQ4 2021 + RevenueQ3 2021 + RevenueQ2 2021) ÷ Stockholders’ equity
= ( + + + ) ÷ =

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Microsoft Corp.’s equity turnover ratio deteriorated from Q3 2021 to Q4 2021 and from Q4 2021 to Q1 2022.