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.
Paying users area
Try for free
Microsoft Corp. pages available for free this week:
- Income Statement
- Balance Sheet: Liabilities and Stockholders’ Equity
- Common-Size Income Statement
- Analysis of Liquidity Ratios
- DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin
- Enterprise Value (EV)
- Enterprise Value to EBITDA (EV/EBITDA)
- Debt to Equity since 2005
- Price to Earnings (P/E) since 2005
- Price to Book Value (P/BV) since 2005
The data is hidden behind: . Unhide it.
Get 1-month access to Microsoft Corp. for $24.99, or
get full access to the entire website for at least 3 months from $62.19.
This is a one-time payment. There is no automatic renewal.
We accept:
Long-term Activity Ratios (Summary)
Microsoft Corp., long-term (investment) activity ratios (quarterly data)
Based on: 10-Q (reporting date: 2024-03-31), 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 Q1 2024 to Q2 2024 and from Q2 2024 to Q3 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 Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024. |
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Microsoft Corp. total asset turnover ratio deteriorated from Q1 2024 to Q2 2024 but then improved from Q2 2024 to Q3 2024 not reaching Q1 2024 level. |
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | Microsoft Corp. equity turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024. |
Net Fixed Asset Turnover
Microsoft Corp., net fixed asset turnover calculation (quarterly data)
| Mar 31, 2024 | 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 | |||||||||||||||||||||||||||||||||||
| 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. | |||||||||||||||||||||||||||||||||||
| International Business Machines Corp. | |||||||||||||||||||||||||||||||||||
| Intuit Inc. | |||||||||||||||||||||||||||||||||||
| Oracle Corp. | |||||||||||||||||||||||||||||||||||
| Palo Alto Networks Inc. | |||||||||||||||||||||||||||||||||||
| Salesforce Inc. | |||||||||||||||||||||||||||||||||||
| ServiceNow Inc. | |||||||||||||||||||||||||||||||||||
| Synopsys Inc. | |||||||||||||||||||||||||||||||||||
Based on: 10-Q (reporting date: 2024-03-31), 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 Q3 2024 Calculation
Net fixed asset turnover
= (RevenueQ3 2024
+ RevenueQ2 2024
+ RevenueQ1 2024
+ RevenueQ4 2023)
÷ 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. net fixed asset turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 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)
| Mar 31, 2024 | 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 | |||||||||||||||||||||||||||||||||||
| 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. | |||||||||||||||||||||||||||||||||||
| International Business Machines Corp. | |||||||||||||||||||||||||||||||||||
| Intuit Inc. | |||||||||||||||||||||||||||||||||||
| Palo Alto Networks Inc. | |||||||||||||||||||||||||||||||||||
| Salesforce Inc. | |||||||||||||||||||||||||||||||||||
| ServiceNow Inc. | |||||||||||||||||||||||||||||||||||
| Synopsys Inc. | |||||||||||||||||||||||||||||||||||
Based on: 10-Q (reporting date: 2024-03-31), 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 Q3 2024 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset)
= (RevenueQ3 2024
+ RevenueQ2 2024
+ RevenueQ1 2024
+ RevenueQ4 2023)
÷ 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. net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024. |
Total Asset Turnover
Microsoft Corp., total asset turnover calculation (quarterly data)
| Mar 31, 2024 | 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 | |||||||||||||||||||||||||||||||||||
| Total assets | |||||||||||||||||||||||||||||||||||
| Long-term Activity Ratio | |||||||||||||||||||||||||||||||||||
| Total asset turnover1 | |||||||||||||||||||||||||||||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Total Asset Turnover, Competitors2 | |||||||||||||||||||||||||||||||||||
| Accenture PLC | |||||||||||||||||||||||||||||||||||
| Adobe Inc. | |||||||||||||||||||||||||||||||||||
| International Business Machines Corp. | |||||||||||||||||||||||||||||||||||
| Intuit Inc. | |||||||||||||||||||||||||||||||||||
| Oracle Corp. | |||||||||||||||||||||||||||||||||||
| Palo Alto Networks Inc. | |||||||||||||||||||||||||||||||||||
| Salesforce Inc. | |||||||||||||||||||||||||||||||||||
| ServiceNow Inc. | |||||||||||||||||||||||||||||||||||
| Synopsys Inc. | |||||||||||||||||||||||||||||||||||
Based on: 10-Q (reporting date: 2024-03-31), 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 Q3 2024 Calculation
Total asset turnover
= (RevenueQ3 2024
+ RevenueQ2 2024
+ RevenueQ1 2024
+ RevenueQ4 2023)
÷ 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. total asset turnover ratio deteriorated from Q1 2024 to Q2 2024 but then improved from Q2 2024 to Q3 2024 not reaching Q1 2024 level. |
Equity Turnover
Microsoft Corp., equity turnover calculation (quarterly data)
| Mar 31, 2024 | 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 | |||||||||||||||||||||||||||||||||||
| Stockholders’ equity | |||||||||||||||||||||||||||||||||||
| Long-term Activity Ratio | |||||||||||||||||||||||||||||||||||
| Equity turnover1 | |||||||||||||||||||||||||||||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Equity Turnover, Competitors2 | |||||||||||||||||||||||||||||||||||
| Accenture PLC | |||||||||||||||||||||||||||||||||||
| Adobe Inc. | |||||||||||||||||||||||||||||||||||
| International Business Machines Corp. | |||||||||||||||||||||||||||||||||||
| Intuit Inc. | |||||||||||||||||||||||||||||||||||
| Oracle Corp. | |||||||||||||||||||||||||||||||||||
| Palo Alto Networks Inc. | |||||||||||||||||||||||||||||||||||
| Salesforce Inc. | |||||||||||||||||||||||||||||||||||
| ServiceNow Inc. | |||||||||||||||||||||||||||||||||||
| Synopsys Inc. | |||||||||||||||||||||||||||||||||||
Based on: 10-Q (reporting date: 2024-03-31), 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 Q3 2024 Calculation
Equity turnover
= (RevenueQ3 2024
+ RevenueQ2 2024
+ RevenueQ1 2024
+ RevenueQ4 2023)
÷ 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. equity turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024. |