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:
This is a one-time payment. There is no automatic renewal.
Microsoft Corp. (MSFT)
Analysis of Long-term (Investment) Activity Ratios
Low level of difficulty
Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Long-term Activity Ratios (Summary)
Microsoft Corp., long-term (investment) activity ratios
Based on: 10-K (filing date: 2019-08-01), 10-K (filing date: 2018-08-03), 10-K (filing date: 2017-08-02), 10-K (filing date: 2016-07-28), 10-K (filing date: 2015-07-31), 10-K (filing date: 2014-07-31).
| 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 2017 to 2018 and from 2018 to 2019. |
| 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 2017 to 2018 and from 2018 to 2019. |
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Microsoft Corp.’s total asset turnover ratio improved from 2017 to 2018 and from 2018 to 2019. |
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | Microsoft Corp.’s equity turnover ratio improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019. |
Net Fixed Asset Turnover
Microsoft Corp., net fixed asset turnover calculation, comparison to benchmarks
| Jun 30, 2019 | Jun 30, 2018 | Jun 30, 2017 | Jun 30, 2016 | Jun 30, 2015 | Jun 30, 2014 | ||
|---|---|---|---|---|---|---|---|
| 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 | |||||||
| Adobe Inc. | |
|
|
|
|
|
|
| Alphabet Inc. | |
|
|
|
|
|
|
| Facebook Inc. | |
|
|
|
|
|
|
| International Business Machines Corp. | |
|
|
|
|
|
|
| Intuit Inc. | |
|
|
|
|
|
|
| Oracle Corp. | |
|
|
|
|
|
|
| salesforce.com inc. | |
|
|
|
|
|
|
| Net Fixed Asset Turnover, Sector | |||||||
| Software & Computer Services | |
|
|
|
|
|
|
| Net Fixed Asset Turnover, Industry | |||||||
| Technology | |
|
|
|
|
|
|
Based on: 10-K (filing date: 2019-08-01), 10-K (filing date: 2018-08-03), 10-K (filing date: 2017-08-02), 10-K (filing date: 2016-07-28), 10-K (filing date: 2015-07-31), 10-K (filing date: 2014-07-31).
1 2019 Calculation
Net fixed asset turnover = Revenue ÷ 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 2017 to 2018 and from 2018 to 2019. |
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, comparison to benchmarks
Based on: 10-K (filing date: 2019-08-01), 10-K (filing date: 2018-08-03), 10-K (filing date: 2017-08-02), 10-K (filing date: 2016-07-28), 10-K (filing date: 2015-07-31), 10-K (filing date: 2014-07-31).
1 2019 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = Revenue ÷ Property and equipment, net of accumulated depreciation (including operating lease, right-of-use asset)
= ÷ =
| 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 2017 to 2018 and from 2018 to 2019. |
Total Asset Turnover
Microsoft Corp., total asset turnover calculation, comparison to benchmarks
| Jun 30, 2019 | Jun 30, 2018 | Jun 30, 2017 | Jun 30, 2016 | Jun 30, 2015 | Jun 30, 2014 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||
| Revenue | |
|
|
|
|
|
|
| Total assets | |
|
|
|
|
|
|
| Long-term Activity Ratio | |||||||
| Total asset turnover1 | |
|
|
|
|
|
|
| Benchmarks | |||||||
| Total Asset Turnover, Competitors2 | |||||||
| Adobe Inc. | |
|
|
|
|
|
|
| Alphabet Inc. | |
|
|
|
|
|
|
| Facebook Inc. | |
|
|
|
|
|
|
| International Business Machines Corp. | |
|
|
|
|
|
|
| Intuit Inc. | |
|
|
|
|
|
|
| Oracle Corp. | |
|
|
|
|
|
|
| salesforce.com inc. | |
|
|
|
|
|
|
| Total Asset Turnover, Sector | |||||||
| Software & Computer Services | |
|
|
|
|
|
|
| Total Asset Turnover, Industry | |||||||
| Technology | |
|
|
|
|
|
|
Based on: 10-K (filing date: 2019-08-01), 10-K (filing date: 2018-08-03), 10-K (filing date: 2017-08-02), 10-K (filing date: 2016-07-28), 10-K (filing date: 2015-07-31), 10-K (filing date: 2014-07-31).
1 2019 Calculation
Total asset turnover = Revenue ÷ 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 improved from 2017 to 2018 and from 2018 to 2019. |
Equity Turnover
Microsoft Corp., equity turnover calculation, comparison to benchmarks
| Jun 30, 2019 | Jun 30, 2018 | Jun 30, 2017 | Jun 30, 2016 | Jun 30, 2015 | Jun 30, 2014 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||
| Revenue | |
|
|
|
|
|
|
| Stockholders’ equity | |
|
|
|
|
|
|
| Long-term Activity Ratio | |||||||
| Equity turnover1 | |
|
|
|
|
|
|
| Benchmarks | |||||||
| Equity Turnover, Competitors2 | |||||||
| Adobe Inc. | |
|
|
|
|
|
|
| Alphabet Inc. | |
|
|
|
|
|
|
| Facebook Inc. | |
|
|
|
|
|
|
| International Business Machines Corp. | |
|
|
|
|
|
|
| Intuit Inc. | |
|
|
|
|
|
|
| Oracle Corp. | |
|
|
|
|
|
|
| salesforce.com inc. | |
|
|
|
|
|
|
| Equity Turnover, Sector | |||||||
| Software & Computer Services | |
|
|
|
|
|
|
| Equity Turnover, Industry | |||||||
| Technology | |
|
|
|
|
|
|
Based on: 10-K (filing date: 2019-08-01), 10-K (filing date: 2018-08-03), 10-K (filing date: 2017-08-02), 10-K (filing date: 2016-07-28), 10-K (filing date: 2015-07-31), 10-K (filing date: 2014-07-31).
1 2019 Calculation
Equity turnover = Revenue ÷ 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 improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019. |