Analysis of Long-term (Investment) Activity Ratios
Quarterly Data
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 (quarterly data)
Based on: 10-Q (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-K (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-K (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-K (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-K (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-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 Q4 2023 to Q1 2024 and from Q1 2024 to Q2 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 Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024. |
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Microsoft Corp. total asset turnover ratio deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024. |
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | Microsoft Corp. equity turnover ratio deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024. |
Net Fixed Asset Turnover
Microsoft Corp., net fixed asset turnover calculation (quarterly data)
| Dec 31, 2023 | Sep 30, 2023 | Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | Sep 30, 2022 | Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | 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 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||||||||||
| Revenue | 62,020) | 56,517) | 56,189) | 52,857) | 52,747) | 50,122) | 51,865) | 49,360) | 51,728) | 45,317) | 46,152) | 41,706) | 43,076) | 37,154) | 38,033) | 35,021) | 36,906) | 33,055) | 33,717) | 30,571) | 32,471) | 29,084) | 30,085) | 26,819) | 28,918) | 24,538) | ||||||||
| Property and equipment, net of accumulated depreciation | 112,308) | 102,502) | 95,641) | 88,132) | 82,755) | 77,037) | 74,398) | 70,298) | 67,214) | 63,772) | 59,715) | 54,945) | 51,737) | 47,927) | 44,151) | 41,221) | 40,522) | 38,409) | 36,477) | 33,648) | 32,717) | 31,430) | 29,460) | 27,929) | 26,304) | 24,809) | ||||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||||||||||
| Net fixed asset turnover1 | 2.03 | 2.13 | 2.22 | 2.36 | 2.47 | 2.64 | 2.66 | 2.74 | 2.75 | 2.76 | 2.81 | 2.91 | 2.96 | 3.07 | 3.24 | 3.36 | 3.31 | 3.38 | 3.45 | 3.63 | 3.62 | 3.66 | 3.75 | — | — | — | ||||||||
| Benchmarks | ||||||||||||||||||||||||||||||||||
| Net Fixed Asset Turnover, Competitors2 | ||||||||||||||||||||||||||||||||||
| Accenture PLC | 44.26 | 44.00 | 41.90 | 41.40 | 40.46 | 38.17 | 37.12 | 35.78 | 34.22 | 32.49 | 30.83 | 31.16 | 30.44 | 29.69 | 28.68 | 30.82 | 31.33 | 31.71 | 31.06 | 31.90 | 33.16 | 33.91 | 32.91 | — | — | — | ||||||||
| Adobe Inc. | — | 10.03 | 9.56 | 9.28 | 9.07 | 9.15 | 9.23 | 9.25 | 9.33 | 9.48 | 9.44 | 9.27 | 9.15 | 8.94 | 8.48 | 8.48 | 8.68 | 8.70 | 8.64 | 8.56 | 8.38 | 8.65 | 8.40 | — | — | — | ||||||||
| International Business Machines Corp. | — | — | 11.25 | 11.39 | 11.12 | 11.34 | 11.35 | 11.75 | 11.31 | 10.50 | 10.07 | 6.68 | 6.93 | 7.33 | 7.33 | 7.53 | 7.78 | 7.95 | 7.71 | — | — | — | — | — | — | — | ||||||||
| Intuit Inc. | 14.39 | 14.56 | 14.83 | 15.00 | 14.70 | 14.38 | 14.33 | 15.00 | 13.74 | 13.08 | 12.35 | 11.24 | 9.74 | 10.55 | 10.46 | 9.20 | 9.40 | 8.97 | 8.70 | 8.48 | 7.94 | 7.57 | 7.34 | — | — | — | ||||||||
| Oracle Corp. | 2.87 | 2.89 | 2.93 | 2.93 | 3.21 | 3.60 | 4.37 | 4.86 | 5.16 | 5.37 | 5.74 | 5.82 | 5.95 | 6.13 | 6.26 | 6.36 | 6.31 | 6.31 | 6.32 | 6.39 | 6.63 | 6.73 | 6.75 | — | — | — | ||||||||
| Palo Alto Networks Inc. | 21.37 | 20.44 | 19.44 | 18.99 | 17.86 | 16.45 | 15.38 | 14.54 | 13.39 | 14.05 | 13.37 | 12.36 | 11.44 | 10.60 | 9.79 | 9.14 | 10.02 | 9.53 | 9.80 | 10.01 | 9.49 | 8.77 | 8.32 | — | — | — | ||||||||
| Salesforce Inc. | 8.53 | 8.71 | 8.47 | 8.62 | 8.69 | 9.74 | 9.41 | 9.03 | 8.68 | 8.98 | 8.64 | 7.91 | 7.67 | 7.24 | 7.20 | 6.70 | 6.45 | 6.25 | 6.48 | — | — | — | — | — | — | — | ||||||||
| ServiceNow Inc. | — | — | 6.61 | 7.07 | 6.98 | 6.82 | 6.88 | 7.57 | 7.54 | 7.84 | 7.70 | 7.47 | 7.06 | 6.97 | 6.85 | 7.48 | 7.23 | 7.89 | 7.39 | — | — | — | — | — | — | — | ||||||||
| Synopsys Inc. | — | 10.81 | 10.48 | 10.31 | 9.68 | 10.01 | 10.51 | 10.17 | 9.68 | 9.43 | 8.90 | 8.67 | 8.32 | 7.85 | 7.62 | 7.25 | 7.23 | 7.38 | 7.82 | 8.87 | 9.39 | 9.98 | 10.09 | — | — | — | ||||||||
Based on: 10-Q (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-K (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-K (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-K (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-K (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30).
1 Q2 2024 Calculation
Net fixed asset turnover
= (RevenueQ2 2024
+ RevenueQ1 2024
+ RevenueQ4 2023
+ RevenueQ3 2023)
÷ Property and equipment, net of accumulated depreciation
= (62,020 + 56,517 + 56,189 + 52,857)
÷ 112,308 = 2.03
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 Q4 2023 to Q1 2024 and from Q1 2024 to Q2 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 (quarterly data)
| Dec 31, 2023 | Sep 30, 2023 | Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | Sep 30, 2022 | Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | 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 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||||||||||
| Revenue | 62,020) | 56,517) | 56,189) | 52,857) | 52,747) | 50,122) | 51,865) | 49,360) | 51,728) | 45,317) | 46,152) | 41,706) | 43,076) | 37,154) | 38,033) | 35,021) | 36,906) | 33,055) | 33,717) | 30,571) | 32,471) | 29,084) | 30,085) | 26,819) | 28,918) | 24,538) | ||||||||
| Property and equipment, net of accumulated depreciation | 112,308) | 102,502) | 95,641) | 88,132) | 82,755) | 77,037) | 74,398) | 70,298) | 67,214) | 63,772) | 59,715) | 54,945) | 51,737) | 47,927) | 44,151) | 41,221) | 40,522) | 38,409) | 36,477) | 33,648) | 32,717) | 31,430) | 29,460) | 27,929) | 26,304) | 24,809) | ||||||||
| Operating lease right-of-use assets | 16,398) | 15,435) | 14,346) | 13,879) | 13,624) | 13,347) | 13,148) | 12,916) | 12,354) | 11,575) | 11,088) | 10,673) | 10,298) | 9,047) | 8,753) | 8,448) | 8,439) | 7,890) | 7,379) | 7,121) | 6,806) | 6,734) | 6,686) | 6,859) | 6,749) | 6,844) | ||||||||
| Property and equipment, net of accumulated depreciation (including operating lease, right-of-use asset) | 128,706) | 117,937) | 109,987) | 102,011) | 96,379) | 90,384) | 87,546) | 83,214) | 79,568) | 75,347) | 70,803) | 65,618) | 62,035) | 56,974) | 52,904) | 49,669) | 48,961) | 46,299) | 43,856) | 40,769) | 39,523) | 38,164) | 36,146) | 34,788) | 33,053) | 31,653) | ||||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||||||||||
| Net fixed asset turnover (including operating lease, right-of-use asset)1 | 1.77 | 1.85 | 1.93 | 2.03 | 2.12 | 2.25 | 2.26 | 2.31 | 2.32 | 2.34 | 2.37 | 2.44 | 2.47 | 2.58 | 2.70 | 2.79 | 2.74 | 2.80 | 2.87 | 3.00 | 3.00 | 3.01 | 3.05 | — | — | — | ||||||||
| Benchmarks | ||||||||||||||||||||||||||||||||||
| Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2 | ||||||||||||||||||||||||||||||||||
| Accenture PLC | 15.77 | 15.97 | 15.38 | 14.85 | 14.14 | 13.47 | 13.17 | 12.30 | 11.56 | 11.17 | 10.48 | 10.27 | 9.83 | 9.71 | 9.37 | 9.54 | 9.69 | 9.68 | 31.06 | 31.90 | 33.16 | 33.91 | 32.91 | — | — | — | ||||||||
| Adobe Inc. | — | 8.47 | 8.13 | 7.84 | 7.61 | 7.60 | 7.61 | 7.57 | 7.52 | 7.55 | 7.46 | 7.26 | 7.08 | 6.82 | 6.42 | 6.30 | 6.42 | 6.32 | 8.64 | 8.56 | 8.38 | 8.65 | 8.40 | — | — | — | ||||||||
| International Business Machines Corp. | — | — | 7.09 | 7.21 | 7.48 | 7.45 | 7.37 | 7.67 | 7.35 | 6.73 | 6.43 | 4.56 | 4.73 | 4.97 | 5.00 | 5.11 | 5.21 | 5.28 | 5.14 | — | — | — | — | — | — | — | ||||||||
| Intuit Inc. | 10.11 | 10.03 | 9.99 | 9.89 | 9.51 | 9.11 | 8.86 | 10.03 | 8.99 | 8.64 | 8.30 | 7.66 | 6.52 | 8.04 | 8.00 | 7.11 | 6.76 | 6.42 | 8.70 | 8.48 | 7.94 | 7.57 | 7.34 | — | — | — | ||||||||
| Palo Alto Networks Inc. | 10.63 | 11.50 | 11.16 | 11.00 | 10.33 | 9.47 | 9.17 | 8.68 | 8.08 | 7.91 | 7.32 | 6.86 | 6.49 | 6.08 | 5.62 | 5.26 | 5.37 | 5.03 | 9.80 | 10.01 | 9.49 | 8.77 | 8.32 | — | — | — | ||||||||
| Salesforce Inc. | 5.13 | 5.08 | 4.76 | 4.72 | 4.80 | 4.83 | 4.65 | 4.40 | 4.03 | 4.02 | 3.75 | 3.67 | 3.52 | 3.31 | 3.16 | 2.87 | 2.84 | 2.75 | 6.48 | — | — | — | — | — | — | — | ||||||||
| ServiceNow Inc. | — | — | 4.33 | 4.46 | 4.44 | 4.24 | 4.18 | 4.63 | 4.46 | 4.53 | 4.34 | 4.11 | 4.32 | 4.21 | 4.06 | 4.13 | 3.91 | 3.97 | 3.98 | — | — | — | — | — | — | — | ||||||||
| Synopsys Inc. | — | 5.48 | 5.19 | 4.98 | 4.71 | 4.69 | 4.87 | 4.66 | 4.42 | 4.70 | 4.35 | 4.23 | 4.05 | 4.03 | 3.88 | 3.67 | 3.64 | 3.68 | 7.82 | 8.87 | 9.39 | 9.98 | 10.09 | — | — | — | ||||||||
Based on: 10-Q (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-K (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-K (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-K (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-K (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30).
1 Q2 2024 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset)
= (RevenueQ2 2024
+ RevenueQ1 2024
+ RevenueQ4 2023
+ RevenueQ3 2023)
÷ Property and equipment, net of accumulated depreciation (including operating lease, right-of-use asset)
= (62,020 + 56,517 + 56,189 + 52,857)
÷ 128,706 = 1.77
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 Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024. |
Total Asset Turnover
Microsoft Corp., total asset turnover calculation (quarterly data)
| Dec 31, 2023 | Sep 30, 2023 | Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | Sep 30, 2022 | Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | 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 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||||||||||
| Revenue | 62,020) | 56,517) | 56,189) | 52,857) | 52,747) | 50,122) | 51,865) | 49,360) | 51,728) | 45,317) | 46,152) | 41,706) | 43,076) | 37,154) | 38,033) | 35,021) | 36,906) | 33,055) | 33,717) | 30,571) | 32,471) | 29,084) | 30,085) | 26,819) | 28,918) | 24,538) | ||||||||
| Total assets | 470,558) | 445,785) | 411,976) | 380,088) | 364,552) | 359,784) | 364,840) | 344,607) | 340,389) | 335,418) | 333,779) | 308,879) | 304,137) | 301,001) | 301,311) | 285,449) | 282,794) | 278,955) | 286,556) | 263,281) | 258,859) | 257,619) | 258,848) | 245,497) | 256,003) | 249,097) | ||||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||||||||||
| Total asset turnover1 | 0.48 | 0.49 | 0.51 | 0.55 | 0.56 | 0.56 | 0.54 | 0.56 | 0.54 | 0.53 | 0.50 | 0.52 | 0.50 | 0.49 | 0.47 | 0.49 | 0.47 | 0.47 | 0.44 | 0.46 | 0.46 | 0.45 | 0.43 | — | — | — | ||||||||
| Benchmarks | ||||||||||||||||||||||||||||||||||
| Total Asset Turnover, Competitors2 | ||||||||||||||||||||||||||||||||||
| Accenture PLC | 1.26 | 1.25 | 1.25 | 1.27 | 1.32 | 1.32 | 1.30 | 1.29 | 1.28 | 1.23 | 1.17 | 1.14 | 1.14 | 1.17 | 1.20 | 1.27 | 1.33 | 1.33 | 1.45 | 1.52 | 1.55 | 1.58 | 1.70 | — | — | — | ||||||||
| Adobe Inc. | — | 0.69 | 0.65 | 0.65 | 0.66 | 0.67 | 0.65 | 0.64 | 0.63 | 0.62 | 0.58 | 0.58 | 0.56 | 0.55 | 0.53 | 0.55 | 0.56 | 0.55 | 0.54 | 0.53 | 0.51 | 0.49 | 0.48 | — | — | — | ||||||||
| International Business Machines Corp. | — | — | 0.46 | 0.47 | 0.46 | 0.45 | 0.48 | 0.48 | 0.47 | 0.44 | 0.43 | 0.42 | 0.44 | 0.47 | 0.47 | 0.49 | 0.49 | 0.50 | 0.51 | — | — | — | — | — | — | — | ||||||||
| Intuit Inc. | 0.51 | 0.52 | 0.52 | 0.49 | 0.50 | 0.49 | 0.46 | 0.45 | 0.43 | 0.69 | 0.62 | 0.56 | 0.53 | 0.81 | 0.70 | 0.88 | 1.06 | 1.12 | 1.08 | 0.98 | 1.21 | 1.24 | 1.15 | — | — | — | ||||||||
| Oracle Corp. | 0.38 | 0.37 | 0.37 | 0.36 | 0.36 | 0.34 | 0.39 | 0.39 | 0.39 | 0.33 | 0.31 | 0.34 | 0.36 | 0.35 | 0.34 | 0.41 | 0.40 | 0.37 | 0.36 | 0.36 | 0.34 | 0.31 | 0.29 | — | — | — | ||||||||
| Palo Alto Networks Inc. | 0.41 | 0.49 | 0.48 | 0.46 | 0.47 | 0.46 | 0.45 | 0.47 | 0.47 | 0.44 | 0.42 | 0.42 | 0.40 | 0.41 | 0.38 | 0.50 | 0.43 | 0.44 | 0.44 | 0.44 | 0.45 | 0.42 | 0.39 | — | — | — | ||||||||
| Salesforce Inc. | 0.36 | 0.34 | 0.32 | 0.33 | 0.31 | 0.30 | 0.28 | 0.29 | 0.27 | 0.34 | 0.32 | 0.34 | 0.34 | 0.34 | 0.31 | 0.32 | 0.44 | 0.42 | 0.43 | — | — | — | — | — | — | — | ||||||||
| ServiceNow Inc. | — | — | 0.52 | 0.56 | 0.54 | 0.56 | 0.54 | 0.62 | 0.59 | 0.57 | 0.55 | 0.58 | 0.56 | 0.55 | 0.52 | 0.55 | 0.61 | 0.60 | 0.57 | — | — | — | — | — | — | — | ||||||||
| Synopsys Inc. | — | 0.58 | 0.57 | 0.56 | 0.54 | 0.54 | 0.54 | 0.53 | 0.52 | 0.51 | 0.48 | 0.48 | 0.48 | 0.48 | 0.46 | 0.46 | 0.46 | 0.47 | 0.52 | 0.54 | 0.52 | 0.50 | 0.51 | — | — | — | ||||||||
Based on: 10-Q (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-K (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-K (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-K (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-K (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30).
1 Q2 2024 Calculation
Total asset turnover
= (RevenueQ2 2024
+ RevenueQ1 2024
+ RevenueQ4 2023
+ RevenueQ3 2023)
÷ Total assets
= (62,020 + 56,517 + 56,189 + 52,857)
÷ 470,558 = 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 Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024. |
Equity Turnover
Microsoft Corp., equity turnover calculation (quarterly data)
| Dec 31, 2023 | Sep 30, 2023 | Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | Sep 30, 2022 | Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | 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 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||||||||||
| Revenue | 62,020) | 56,517) | 56,189) | 52,857) | 52,747) | 50,122) | 51,865) | 49,360) | 51,728) | 45,317) | 46,152) | 41,706) | 43,076) | 37,154) | 38,033) | 35,021) | 36,906) | 33,055) | 33,717) | 30,571) | 32,471) | 29,084) | 30,085) | 26,819) | 28,918) | 24,538) | ||||||||
| Stockholders’ equity | 238,268) | 220,714) | 206,223) | 194,683) | 183,136) | 173,566) | 166,542) | 162,924) | 160,010) | 151,978) | 141,988) | 134,505) | 130,236) | 123,392) | 118,304) | 114,501) | 110,109) | 106,061) | 102,330) | 94,864) | 92,128) | 85,967) | 82,718) | 79,239) | 78,360) | 89,647) | ||||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||||||||||
| Equity turnover1 | 0.96 | 0.99 | 1.03 | 1.07 | 1.11 | 1.17 | 1.19 | 1.18 | 1.16 | 1.16 | 1.18 | 1.19 | 1.18 | 1.19 | 1.21 | 1.21 | 1.22 | 1.22 | 1.23 | 1.29 | 1.29 | 1.34 | 1.33 | — | — | — | ||||||||
| Benchmarks | ||||||||||||||||||||||||||||||||||
| Equity Turnover, Competitors2 | ||||||||||||||||||||||||||||||||||
| Accenture PLC | 2.38 | 2.42 | 2.50 | 2.51 | 2.66 | 2.72 | 2.79 | 2.79 | 2.76 | 2.64 | 2.59 | 2.48 | 2.49 | 2.50 | 2.61 | 2.78 | 2.89 | 2.90 | 3.00 | 3.12 | 3.19 | 3.32 | 4.01 | — | — | — | ||||||||
| Adobe Inc. | — | 1.29 | 1.18 | 1.20 | 1.24 | 1.27 | 1.25 | 1.20 | 1.19 | 1.17 | 1.07 | 1.05 | 1.04 | 1.01 | 0.97 | 1.06 | 1.11 | 1.11 | 1.06 | 1.04 | 1.02 | 0.97 | 0.96 | — | — | — | ||||||||
| International Business Machines Corp. | — | — | 2.75 | 2.65 | 2.73 | 2.80 | 2.76 | 3.02 | 3.07 | 3.06 | 3.03 | 2.75 | 2.98 | 3.24 | 3.57 | 3.54 | 3.67 | 3.83 | 3.70 | — | — | — | — | — | — | — | ||||||||
| Intuit Inc. | 0.89 | 0.87 | 0.83 | 0.80 | 0.86 | 0.83 | 0.77 | 0.76 | 0.73 | 1.06 | 0.98 | 0.89 | 0.87 | 1.49 | 1.50 | 1.45 | 1.91 | 1.91 | 1.81 | 1.67 | 2.30 | 2.19 | 2.53 | — | — | — | ||||||||
| Oracle Corp. | 13.35 | 21.50 | 46.56 | — | — | — | — | — | — | — | 7.73 | 4.46 | 4.98 | 4.13 | 3.24 | 2.79 | 2.54 | 2.14 | 1.81 | 1.67 | 1.30 | 1.05 | 0.87 | — | — | — | ||||||||
| Palo Alto Networks Inc. | 1.73 | 3.32 | 3.94 | 5.27 | 8.44 | 11.45 | 26.20 | 15.31 | 41.24 | 8.78 | 6.71 | 4.00 | 3.65 | 4.80 | 3.09 | 4.38 | 1.94 | 1.99 | 1.83 | 1.89 | 2.42 | 1.93 | 2.35 | — | — | — | ||||||||
| Salesforce Inc. | 0.57 | 0.56 | 0.54 | 0.51 | 0.49 | 0.47 | 0.46 | 0.44 | 0.42 | 0.53 | 0.51 | 0.50 | 0.50 | 0.53 | 0.50 | 0.48 | 0.86 | 0.85 | 0.85 | — | — | — | — | — | — | — | ||||||||
| ServiceNow Inc. | — | — | 1.18 | 1.18 | 1.16 | 1.36 | 1.44 | 1.53 | 1.57 | 1.57 | 1.60 | 1.57 | 1.58 | 1.59 | 1.59 | 1.58 | 1.60 | 1.64 | 1.63 | — | — | — | — | — | — | — | ||||||||
| Synopsys Inc. | — | 0.92 | 0.95 | 0.93 | 0.91 | 0.92 | 0.92 | 0.88 | 0.86 | 0.84 | 0.79 | 0.79 | 0.78 | 0.78 | 0.75 | 0.76 | 0.80 | 0.81 | 0.82 | 0.84 | 0.83 | 0.84 | 0.90 | — | — | — | ||||||||
Based on: 10-Q (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-K (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-K (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-K (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-K (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30).
1 Q2 2024 Calculation
Equity turnover
= (RevenueQ2 2024
+ RevenueQ1 2024
+ RevenueQ4 2023
+ RevenueQ3 2023)
÷ Stockholders’ equity
= (62,020 + 56,517 + 56,189 + 52,857)
÷ 238,268 = 0.96
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 Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024. |