Analysis of Long-term (Investment) Activity Ratios
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 (reporting date: 2024-06-30), 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30).
| 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. net fixed asset turnover ratio deteriorated from 2022 to 2023 and from 2023 to 2024. |
| 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. net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from 2022 to 2023 and from 2023 to 2024. |
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Microsoft Corp. total asset turnover ratio deteriorated from 2022 to 2023 and from 2023 to 2024. |
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | Microsoft Corp. equity turnover ratio deteriorated from 2022 to 2023 and from 2023 to 2024. |
Net Fixed Asset Turnover
Microsoft Corp., net fixed asset turnover calculation, comparison to benchmarks
| Jun 30, 2024 | Jun 30, 2023 | Jun 30, 2022 | Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||
| Revenue | 245,122) | 211,915) | 198,270) | 168,088) | 143,015) | 125,843) | |
| Property and equipment, net of accumulated depreciation | 135,591) | 95,641) | 74,398) | 59,715) | 44,151) | 36,477) | |
| Long-term Activity Ratio | |||||||
| Net fixed asset turnover1 | 1.81 | 2.22 | 2.66 | 2.81 | 3.24 | 3.45 | |
| Benchmarks | |||||||
| Net Fixed Asset Turnover, Competitors2 | |||||||
| Accenture PLC | 42.66 | 41.90 | 37.12 | 30.83 | 28.68 | 31.06 | |
| Adobe Inc. | 11.11 | 9.56 | 9.23 | 9.44 | 8.48 | 8.64 | |
| Cadence Design Systems Inc. | — | 10.14 | 9.59 | 9.77 | 8.62 | 8.47 | |
| CrowdStrike Holdings Inc. | 4.93 | 4.55 | 5.57 | 5.24 | 3.54 | — | |
| International Business Machines Corp. | — | 11.25 | 11.35 | 10.07 | 7.33 | 7.71 | |
| Intuit Inc. | 16.14 | 14.83 | 14.33 | 12.35 | 10.46 | 8.70 | |
| Oracle Corp. | 2.46 | 2.93 | 4.37 | 5.74 | 6.26 | 6.32 | |
| Palantir Technologies Inc. | — | 46.59 | 27.55 | 49.26 | 36.99 | — | |
| Palo Alto Networks Inc. | 22.23 | 19.44 | 15.38 | 13.37 | 9.79 | 9.80 | |
| Salesforce Inc. | 9.45 | 8.47 | 9.41 | 8.64 | 7.20 | 6.48 | |
| ServiceNow Inc. | — | 6.61 | 6.88 | 7.70 | 6.85 | 7.39 | |
| Synopsys Inc. | 10.88 | 10.48 | 10.51 | 8.90 | 7.62 | 7.82 | |
| Net Fixed Asset Turnover, Sector | |||||||
| Software & Services | — | 3.73 | 4.47 | 4.72 | 5.16 | 5.51 | |
| Net Fixed Asset Turnover, Industry | |||||||
| Information Technology | — | 3.78 | 4.44 | 4.74 | 4.57 | 4.64 | |
Based on: 10-K (reporting date: 2024-06-30), 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30).
1 2024 Calculation
Net fixed asset turnover = Revenue ÷ Property and equipment, net of accumulated depreciation
= 245,122 ÷ 135,591 = 1.81
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. net fixed asset turnover ratio deteriorated from 2022 to 2023 and from 2023 to 2024. |
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
| Jun 30, 2024 | Jun 30, 2023 | Jun 30, 2022 | Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||
| Revenue | 245,122) | 211,915) | 198,270) | 168,088) | 143,015) | 125,843) | |
| Property and equipment, net of accumulated depreciation | 135,591) | 95,641) | 74,398) | 59,715) | 44,151) | 36,477) | |
| Operating lease right-of-use assets | 18,961) | 14,346) | 13,148) | 11,088) | 8,753) | 7,379) | |
| Property and equipment, net of accumulated depreciation (including operating lease, right-of-use asset) | 154,552) | 109,987) | 87,546) | 70,803) | 52,904) | 43,856) | |
| Long-term Activity Ratio | |||||||
| Net fixed asset turnover (including operating lease, right-of-use asset)1 | 1.59 | 1.93 | 2.26 | 2.37 | 2.70 | 2.87 | |
| Benchmarks | |||||||
| Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2 | |||||||
| Accenture PLC | 15.17 | 15.38 | 13.17 | 10.48 | 9.37 | 31.06 | |
| Adobe Inc. | 9.70 | 8.13 | 7.61 | 7.46 | 6.42 | 8.64 | |
| Cadence Design Systems Inc. | — | 7.38 | 6.57 | 6.85 | 6.04 | 6.21 | |
| CrowdStrike Holdings Inc. | 4.57 | 4.21 | 4.97 | 4.30 | 3.54 | — | |
| International Business Machines Corp. | — | 7.09 | 7.37 | 6.43 | 5.00 | 5.14 | |
| Intuit Inc. | 11.47 | 9.99 | 8.86 | 8.30 | 8.00 | 8.70 | |
| Oracle Corp. | 1.84 | 2.31 | 3.21 | 4.20 | 4.74 | 6.32 | |
| Palantir Technologies Inc. | — | 9.65 | 7.07 | 6.21 | 4.43 | — | |
| Palo Alto Networks Inc. | 10.75 | 11.16 | 9.17 | 7.32 | 5.62 | 9.80 | |
| Salesforce Inc. | 5.76 | 4.76 | 4.65 | 3.75 | 3.16 | 6.48 | |
| ServiceNow Inc. | — | 4.33 | 4.18 | 4.34 | 4.06 | 3.98 | |
| Synopsys Inc. | 5.43 | 5.19 | 4.87 | 4.35 | 3.88 | 7.82 | |
| Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Sector | |||||||
| Software & Services | — | 3.02 | 3.48 | 3.58 | 3.82 | 4.53 | |
| Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Industry | |||||||
| Information Technology | — | 3.31 | 3.84 | 4.03 | 3.87 | 4.34 | |
Based on: 10-K (reporting date: 2024-06-30), 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30).
1 2024 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)
= 245,122 ÷ 154,552 = 1.59
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. net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from 2022 to 2023 and from 2023 to 2024. |
Total Asset Turnover
Microsoft Corp., total asset turnover calculation, comparison to benchmarks
| Jun 30, 2024 | Jun 30, 2023 | Jun 30, 2022 | Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||
| Revenue | 245,122) | 211,915) | 198,270) | 168,088) | 143,015) | 125,843) | |
| Total assets | 512,163) | 411,976) | 364,840) | 333,779) | 301,311) | 286,556) | |
| Long-term Activity Ratio | |||||||
| Total asset turnover1 | 0.48 | 0.51 | 0.54 | 0.50 | 0.47 | 0.44 | |
| Benchmarks | |||||||
| Total Asset Turnover, Competitors2 | |||||||
| Accenture PLC | 1.16 | 1.25 | 1.30 | 1.17 | 1.20 | 1.45 | |
| Adobe Inc. | 0.71 | 0.65 | 0.65 | 0.58 | 0.53 | 0.54 | |
| Cadence Design Systems Inc. | — | 0.72 | 0.69 | 0.68 | 0.68 | 0.70 | |
| CrowdStrike Holdings Inc. | 0.46 | 0.45 | 0.40 | 0.32 | 0.34 | — | |
| International Business Machines Corp. | — | 0.46 | 0.48 | 0.43 | 0.47 | 0.51 | |
| Intuit Inc. | 0.51 | 0.52 | 0.46 | 0.62 | 0.70 | 1.08 | |
| Oracle Corp. | 0.38 | 0.37 | 0.39 | 0.31 | 0.34 | 0.36 | |
| Palantir Technologies Inc. | — | 0.49 | 0.55 | 0.47 | 0.41 | — | |
| Palo Alto Networks Inc. | 0.40 | 0.48 | 0.45 | 0.42 | 0.38 | 0.44 | |
| Salesforce Inc. | 0.35 | 0.32 | 0.28 | 0.32 | 0.31 | 0.43 | |
| ServiceNow Inc. | — | 0.52 | 0.54 | 0.55 | 0.52 | 0.57 | |
| Synopsys Inc. | 0.47 | 0.57 | 0.54 | 0.48 | 0.46 | 0.52 | |
| Total Asset Turnover, Sector | |||||||
| Software & Services | — | 0.51 | 0.53 | 0.49 | 0.48 | 0.50 | |
| Total Asset Turnover, Industry | |||||||
| Information Technology | — | 0.61 | 0.65 | 0.62 | 0.58 | 0.59 | |
Based on: 10-K (reporting date: 2024-06-30), 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30).
1 2024 Calculation
Total asset turnover = Revenue ÷ Total assets
= 245,122 ÷ 512,163 = 0.48
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. total asset turnover ratio deteriorated from 2022 to 2023 and from 2023 to 2024. |
Equity Turnover
Microsoft Corp., equity turnover calculation, comparison to benchmarks
| Jun 30, 2024 | Jun 30, 2023 | Jun 30, 2022 | Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | ||
|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||
| Revenue | 245,122) | 211,915) | 198,270) | 168,088) | 143,015) | 125,843) | |
| Stockholders’ equity | 268,477) | 206,223) | 166,542) | 141,988) | 118,304) | 102,330) | |
| Long-term Activity Ratio | |||||||
| Equity turnover1 | 0.91 | 1.03 | 1.19 | 1.18 | 1.21 | 1.23 | |
| Benchmarks | |||||||
| Equity Turnover, Competitors2 | |||||||
| Accenture PLC | 2.29 | 2.50 | 2.79 | 2.59 | 2.61 | 3.00 | |
| Adobe Inc. | 1.52 | 1.18 | 1.25 | 1.07 | 0.97 | 1.06 | |
| Cadence Design Systems Inc. | — | 1.20 | 1.30 | 1.09 | 1.08 | 1.11 | |
| CrowdStrike Holdings Inc. | 1.33 | 1.53 | 1.42 | 1.00 | 0.65 | — | |
| International Business Machines Corp. | — | 2.75 | 2.76 | 3.03 | 3.57 | 3.70 | |
| Intuit Inc. | 0.88 | 0.83 | 0.77 | 0.98 | 1.50 | 1.81 | |
| Oracle Corp. | 6.08 | 46.56 | — | 7.73 | 3.24 | 1.81 | |
| Palantir Technologies Inc. | — | 0.64 | 0.74 | 0.67 | 0.72 | — | |
| Palo Alto Networks Inc. | 1.55 | 3.94 | 26.20 | 6.71 | 3.09 | 1.83 | |
| Salesforce Inc. | 0.58 | 0.54 | 0.46 | 0.51 | 0.50 | 0.85 | |
| ServiceNow Inc. | — | 1.18 | 1.44 | 1.60 | 1.59 | 1.63 | |
| Synopsys Inc. | 0.68 | 0.95 | 0.92 | 0.79 | 0.75 | 0.82 | |
| Equity Turnover, Sector | |||||||
| Software & Services | — | 1.30 | 1.43 | 1.43 | 1.51 | 1.65 | |
| Equity Turnover, Industry | |||||||
| Information Technology | — | 1.57 | 1.74 | 1.80 | 1.82 | 1.85 | |
Based on: 10-K (reporting date: 2024-06-30), 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30).
1 2024 Calculation
Equity turnover = Revenue ÷ Stockholders’ equity
= 245,122 ÷ 268,477 = 0.91
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. equity turnover ratio deteriorated from 2022 to 2023 and from 2023 to 2024. |