Paying users zone. Data is covered by 
.
Get to Microsoft Corp. for $19.99, or
get to entire website for at least 3 months from $49.99.
Long-term (Investment) Activity Analysis
Difficulty: Beginner
Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Ratios (Summary)
Microsoft Corp., long-term (investment) activity ratios
| Jun 30, 2018 | Jun 30, 2017 | Jun 30, 2016 | Jun 30, 2015 | Jun 30, 2014 | Jun 30, 2013 | ||
|---|---|---|---|---|---|---|---|
| Net fixed asset turnover | |
|
|
|
|
|
|
| Total asset turnover | |
|
|
|
|
|
|
| Equity turnover | |
|
|
|
|
|
Based on: 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), 10-K (filing date: 2013-07-30).
| 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 deteriorated from 2016 to 2017 and from 2017 to 2018. |
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Microsoft Corp.’s total asset turnover deteriorated from 2016 to 2017 but then improved from 2017 to 2018 not reaching 2016 level. |
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | Microsoft Corp.’s equity turnover improved from 2016 to 2017 and from 2017 to 2018. |
Net Fixed Asset Turnover
Microsoft Corp., net fixed asset turnover calculation, comparison to benchmarks
Based on: 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), 10-K (filing date: 2013-07-30).
2018 Calculations
1 Net fixed asset turnover = Revenue ÷ Property and equipment, net of accumulated depreciation
= ÷ =
| 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 deteriorated from 2016 to 2017 and from 2017 to 2018. |
Total Asset Turnover
Microsoft Corp., total asset turnover calculation, comparison to benchmarks
Based on: 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), 10-K (filing date: 2013-07-30).
2018 Calculations
1 Total asset turnover = Revenue ÷ Total assets
= ÷ =
| Ratio | Description | The company |
|---|---|---|
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Microsoft Corp.’s total asset turnover deteriorated from 2016 to 2017 but then improved from 2017 to 2018 not reaching 2016 level. |
Equity Turnover
Microsoft Corp., equity turnover calculation, comparison to benchmarks
Based on: 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), 10-K (filing date: 2013-07-30).
2018 Calculations
1 Equity turnover = Revenue ÷ Stockholders’ equity
= ÷ =
| Ratio | Description | The company |
|---|---|---|
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | Microsoft Corp.’s equity turnover improved from 2016 to 2017 and from 2017 to 2018. |
