Analysis of Short-term (Operating) 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.
Short-term Activity Ratios (Summary)
Microsoft Corp., short-term (operating) 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).
| Short-term activity ratio | Description | The company |
|---|---|---|
| Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | Microsoft Corp. inventory turnover ratio improved from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024. |
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | Microsoft Corp. receivables turnover ratio deteriorated from Q1 2024 to Q2 2024 but then slightly improved from Q2 2024 to Q3 2024. |
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Microsoft Corp. payables turnover ratio increased from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024. |
| Working capital turnover | An activity ratio calculated as revenue divided by working capital. | Microsoft Corp. working capital turnover ratio improved from Q1 2024 to Q2 2024 but then slightly deteriorated from Q2 2024 to Q3 2024. |
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average inventory processing period | An activity ratio equal to the number of days in the period divided by inventory turnover over the period. | Microsoft Corp. number of days of inventory outstanding improved from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024. |
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | Microsoft Corp. number of days of receivables outstanding deteriorated from Q1 2024 to Q2 2024 but then slightly improved from Q2 2024 to Q3 2024. |
| Operating cycle | Equal to average inventory processing period plus average receivables collection period. | |
| Average payables payment period | An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. | Microsoft Corp. number of days of payables outstanding decreased from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024. |
| Cash conversion cycle | A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. | Microsoft Corp. cash conversion cycle deteriorated from Q1 2024 to Q2 2024 but then slightly improved from Q2 2024 to Q3 2024. |
Inventory Turnover
Microsoft Corp., inventory 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) | |||||||||||||||||||||||||||||||||||
| Cost of revenue | 18,505) | 19,623) | 16,302) | 16,795) | 16,128) | 17,488) | 15,452) | 16,429) | 15,615) | 16,960) | 13,646) | 13,991) | 13,045) | 14,194) | 11,002) | 12,339) | 10,975) | 12,358) | 10,406) | 10,412) | 10,170) | 12,423) | 9,905) | 9,742) | 9,269) | 11,064) | 8,278) | ||||||||
| Inventories | 1,304) | 1,615) | 3,000) | 2,500) | 2,877) | 2,980) | 4,268) | 3,742) | 3,296) | 3,019) | 3,411) | 2,636) | 2,245) | 1,924) | 2,705) | 1,895) | 1,644) | 1,823) | 2,622) | 2,063) | 1,951) | 1,961) | 3,614) | 2,662) | 2,084) | 2,003) | 3,211) | ||||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||||||||
| Inventory turnover1 | 54.62 | 42.63 | 22.24 | 26.35 | 22.77 | 21.81 | 15.10 | 16.74 | 18.27 | 19.09 | 16.09 | 19.81 | 22.53 | 25.21 | 17.25 | 24.32 | 26.86 | 23.78 | 16.56 | 20.80 | 21.65 | 21.08 | 11.06 | 14.41 | — | — | — | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Inventory Turnover, Competitors2 | |||||||||||||||||||||||||||||||||||
| International Business Machines Corp. | — | — | — | 23.74 | 19.66 | 18.29 | 17.30 | 17.94 | 15.59 | 16.30 | 14.96 | 15.68 | 15.08 | 17.43 | 18.90 | 20.69 | 19.95 | 21.10 | 22.49 | 25.11 | — | — | — | — | — | — | — | ||||||||
| Synopsys Inc. | — | — | 3.31 | 3.75 | 4.15 | 4.43 | 4.94 | 5.02 | 4.62 | 4.45 | 4.28 | 3.76 | 3.53 | 3.65 | 3.51 | 4.13 | 4.71 | 4.49 | 5.09 | 5.32 | 4.90 | 4.57 | 5.44 | 6.01 | — | — | — | ||||||||
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
Inventory turnover
= (Cost of revenueQ3 2024
+ Cost of revenueQ2 2024
+ Cost of revenueQ1 2024
+ Cost of revenueQ4 2023)
÷ Inventories
= (18,505 + 19,623 + 16,302 + 16,795)
÷ 1,304 = 54.62
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | Microsoft Corp. inventory turnover ratio improved from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024. |
Receivables Turnover
Microsoft Corp., receivables 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 | 61,858) | 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) | ||||||||
| Accounts receivable, net of allowance for doubtful accounts | 44,029) | 42,831) | 36,953) | 48,688) | 37,420) | 35,833) | 31,279) | 44,261) | 32,613) | 33,520) | 27,349) | 38,043) | 26,322) | 27,312) | 22,851) | 32,011) | 22,699) | 23,525) | 19,087) | 29,524) | 19,269) | 19,680) | 17,390) | 26,481) | 17,208) | 18,428) | 14,561) | ||||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||||||||
| Receivables turnover1 | 5.37 | 5.31 | 5.91 | 4.35 | 5.55 | 5.70 | 6.49 | 4.48 | 5.90 | 5.52 | 6.44 | 4.42 | 6.08 | 5.61 | 6.44 | 4.47 | 6.11 | 5.71 | 6.80 | 4.26 | 6.34 | 6.02 | 6.61 | 4.17 | — | — | — | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Receivables Turnover, Competitors2 | |||||||||||||||||||||||||||||||||||
| Adobe Inc. | — | — | 9.69 | 8.73 | 10.20 | 10.94 | 9.99 | 8.53 | 9.98 | 10.51 | 9.58 | 8.41 | 9.77 | 9.74 | 9.00 | 9.20 | 9.44 | 8.82 | 8.40 | 7.28 | 7.76 | 7.94 | 7.12 | 6.86 | — | — | — | ||||||||
| International Business Machines Corp. | — | — | — | 8.57 | 11.48 | 10.67 | 10.52 | 9.25 | 10.95 | 10.17 | 9.79 | 8.49 | 9.23 | 9.57 | 10.72 | 10.32 | 12.30 | 11.54 | 11.05 | 9.80 | — | — | — | — | — | — | — | ||||||||
| Intuit Inc. | — | 16.27 | 39.65 | 35.48 | 19.62 | 15.15 | 34.68 | 28.53 | 17.44 | 12.84 | 25.10 | 24.64 | 16.04 | 16.60 | 79.16 | 51.54 | 31.31 | 11.82 | 66.66 | 77.98 | 25.87 | 11.61 | 79.14 | 60.86 | — | — | — | ||||||||
| Oracle Corp. | 7.20 | 7.59 | 7.82 | 7.22 | 7.72 | 7.43 | 7.44 | 7.13 | 9.12 | 9.28 | 9.11 | 7.48 | 8.56 | 8.91 | 8.57 | 7.04 | 9.55 | 9.77 | 10.35 | 7.69 | 9.92 | 10.01 | 10.68 | 7.55 | — | — | — | ||||||||
| Palo Alto Networks Inc. | — | 3.97 | 5.10 | 2.80 | 4.50 | 4.82 | 4.70 | 2.57 | 4.17 | 5.10 | 5.61 | 3.43 | 5.20 | 5.65 | 5.30 | 3.29 | 4.88 | 5.78 | 6.04 | 4.98 | 6.75 | 6.25 | 6.34 | 4.86 | — | — | — | ||||||||
| Salesforce Inc. | 7.00 | 6.12 | 6.95 | 2.92 | 7.09 | 6.18 | 7.07 | 2.72 | 6.22 | 5.78 | 7.04 | 2.73 | 6.12 | 5.63 | 5.93 | 2.77 | 6.16 | 6.32 | 6.51 | 2.70 | — | — | — | — | — | — | — | ||||||||
| ServiceNow Inc. | — | — | — | 4.41 | 7.26 | 7.33 | 6.87 | 4.20 | 7.71 | 7.74 | 7.59 | 4.24 | 7.13 | 6.62 | 7.49 | 4.48 | 6.69 | 6.26 | 6.04 | 4.14 | — | — | — | — | — | — | — | ||||||||
| Synopsys Inc. | — | — | 5.76 | 6.17 | 8.29 | 6.78 | 5.00 | 6.38 | 7.25 | 6.58 | 4.34 | 7.40 | 7.06 | 6.51 | 4.84 | 4.72 | 5.50 | 5.36 | 4.22 | 6.07 | 7.23 | 6.14 | 4.16 | 5.63 | — | — | — | ||||||||
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
Receivables turnover
= (RevenueQ3 2024
+ RevenueQ2 2024
+ RevenueQ1 2024
+ RevenueQ4 2023)
÷ Accounts receivable, net of allowance for doubtful accounts
= (61,858 + 62,020 + 56,517 + 56,189)
÷ 44,029 = 5.37
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | Microsoft Corp. receivables turnover ratio deteriorated from Q1 2024 to Q2 2024 but then slightly improved from Q2 2024 to Q3 2024. |
Payables Turnover
Microsoft Corp., payables 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) | |||||||||||||||||||||||||||||||||||
| Cost of revenue | 18,505) | 19,623) | 16,302) | 16,795) | 16,128) | 17,488) | 15,452) | 16,429) | 15,615) | 16,960) | 13,646) | 13,991) | 13,045) | 14,194) | 11,002) | 12,339) | 10,975) | 12,358) | 10,406) | 10,412) | 10,170) | 12,423) | 9,905) | 9,742) | 9,269) | 11,064) | 8,278) | ||||||||
| Accounts payable | 18,087) | 17,695) | 19,307) | 18,095) | 15,305) | 15,354) | 16,609) | 19,000) | 16,085) | 15,314) | 14,832) | 15,163) | 13,412) | 12,770) | 12,509) | 12,530) | 9,246) | 8,811) | 8,574) | 9,382) | 7,544) | 7,563) | 8,511) | 8,617) | 7,623) | 7,850) | 6,866) | ||||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||||||||
| Payables turnover1 | 3.94 | 3.89 | 3.46 | 3.64 | 4.28 | 4.23 | 3.88 | 3.30 | 3.74 | 3.76 | 3.70 | 3.44 | 3.77 | 3.80 | 3.73 | 3.68 | 4.78 | 4.92 | 5.06 | 4.57 | 5.60 | 5.47 | 4.70 | 4.45 | — | — | — | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Payables Turnover, Competitors2 | |||||||||||||||||||||||||||||||||||
| Accenture PLC | — | 19.54 | 16.93 | 17.41 | 18.03 | 17.35 | 17.54 | 16.37 | 16.93 | 17.22 | 16.45 | 15.03 | 16.92 | 17.94 | 20.16 | 22.48 | 21.75 | 20.11 | 19.17 | 18.16 | 19.00 | 20.14 | 21.74 | 21.62 | — | — | — | ||||||||
| Adobe Inc. | — | — | 7.92 | 7.50 | 7.29 | 6.51 | 7.21 | 5.71 | 6.66 | 5.53 | 6.54 | 5.98 | 5.40 | 5.60 | 6.76 | 5.63 | 7.62 | 6.00 | 6.52 | 7.98 | 8.45 | 8.63 | 9.18 | 6.42 | — | — | — | ||||||||
| International Business Machines Corp. | — | — | — | 6.67 | 8.23 | 7.36 | 7.44 | 6.87 | 7.35 | 7.40 | 7.69 | 6.54 | 6.71 | 7.47 | 8.35 | 7.75 | 9.76 | 8.36 | 9.63 | 8.30 | — | — | — | — | — | — | — | ||||||||
| Intuit Inc. | — | 4.19 | 5.12 | 4.93 | 3.29 | 3.54 | 3.98 | 3.26 | 2.52 | 2.31 | 3.47 | 2.70 | 2.56 | 2.82 | 5.25 | 4.52 | 3.48 | 2.78 | 4.45 | 4.26 | 2.92 | 2.67 | 4.92 | 5.49 | — | — | — | ||||||||
| Oracle Corp. | 9.02 | 13.12 | 13.67 | 11.27 | 7.60 | 6.68 | 6.72 | 6.74 | 7.65 | 8.03 | 10.79 | 10.54 | 9.49 | 10.71 | 14.72 | 12.46 | 15.07 | 15.07 | 16.46 | 13.78 | 13.45 | 13.86 | 15.37 | 15.28 | — | — | — | ||||||||
| Palo Alto Networks Inc. | — | 10.93 | 14.57 | 14.43 | 20.69 | 14.50 | 14.30 | 13.43 | 14.68 | 12.25 | 14.46 | 22.41 | 16.80 | 25.37 | 21.85 | 15.72 | 17.72 | 15.76 | 11.28 | 11.03 | 11.31 | 26.19 | 15.99 | 13.06 | — | — | — | ||||||||
| ServiceNow Inc. | — | — | — | 15.25 | 26.38 | 10.08 | 7.20 | 5.74 | 7.86 | 5.60 | 8.57 | 15.20 | 19.64 | 11.82 | 9.75 | 28.83 | 17.87 | 10.13 | 11.28 | 15.04 | — | — | — | — | — | — | — | ||||||||
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
Payables turnover
= (Cost of revenueQ3 2024
+ Cost of revenueQ2 2024
+ Cost of revenueQ1 2024
+ Cost of revenueQ4 2023)
÷ Accounts payable
= (18,505 + 19,623 + 16,302 + 16,795)
÷ 18,087 = 3.94
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Microsoft Corp. payables turnover ratio increased from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024. |
Working Capital Turnover
Microsoft Corp., working capital 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) | |||||||||||||||||||||||||||||||||||
| Current assets | 147,180) | 147,393) | 207,586) | 184,257) | 163,889) | 157,823) | 160,812) | 169,684) | 153,922) | 174,188) | 174,326) | 184,406) | 165,614) | 173,973) | 177,077) | 181,915) | 170,505) | 167,074) | 165,896) | 175,552) | 159,887) | 156,874) | 164,195) | 169,662) | 156,659) | 167,633) | 161,031) | ||||||||
| Less: Current liabilities | 118,525) | 121,016) | 124,792) | 104,149) | 85,691) | 81,718) | 87,389) | 95,082) | 77,439) | 77,510) | 80,528) | 88,657) | 72,193) | 67,486) | 70,056) | 72,310) | 58,707) | 59,640) | 58,118) | 69,420) | 53,861) | 50,318) | 56,277) | 58,488) | 46,133) | 58,099) | 51,615) | ||||||||
| Working capital | 28,655) | 26,377) | 82,794) | 80,108) | 78,198) | 76,105) | 73,423) | 74,602) | 76,483) | 96,678) | 93,798) | 95,749) | 93,421) | 106,487) | 107,021) | 109,605) | 111,798) | 107,434) | 107,778) | 106,132) | 106,026) | 106,556) | 107,918) | 111,174) | 110,526) | 109,534) | 109,416) | ||||||||
| Revenue | 61,858) | 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) | ||||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||||||||
| Working capital turnover1 | 8.26 | 8.63 | 2.64 | 2.65 | 2.65 | 2.68 | 2.77 | 2.66 | 2.52 | 1.91 | 1.88 | 1.76 | 1.71 | 1.44 | 1.37 | 1.30 | 1.24 | 1.25 | 1.20 | 1.19 | 1.15 | 1.11 | 1.06 | 0.99 | — | — | — | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Working Capital Turnover, Competitors2 | |||||||||||||||||||||||||||||||||||
| Accenture PLC | — | 15.40 | 11.18 | 11.93 | 10.11 | 13.40 | 14.81 | 15.07 | 13.41 | 15.55 | 15.85 | 12.77 | 7.71 | 8.35 | 7.70 | 8.71 | 10.32 | 10.56 | 9.98 | 9.85 | 11.92 | 11.77 | 12.53 | 12.12 | — | — | — | ||||||||
| Adobe Inc. | — | — | 42.33 | 6.85 | 9.10 | 14.68 | 19.89 | 20.28 | 16.36 | 31.92 | 57.86 | 9.09 | 6.22 | 7.44 | 8.67 | 4.89 | 5.51 | 8.11 | 9.50 | — | — | — | — | 16.24 | — | — | — | ||||||||
| International Business Machines Corp. | — | — | — | — | — | 31.12 | 12.14 | — | — | — | — | — | — | — | — | — | 40.51 | 49.97 | — | 107.30 | — | — | — | — | — | — | — | ||||||||
| Intuit Inc. | — | 13.92 | 11.94 | 8.13 | 6.30 | 15.31 | 10.83 | 8.98 | 5.68 | 21.87 | 4.39 | 3.85 | 3.40 | 5.45 | 1.74 | 1.73 | 3.19 | 4.80 | 4.93 | 4.17 | 3.46 | 10.00 | 9.43 | 20.71 | — | — | — | ||||||||
| Oracle Corp. | — | — | — | — | — | — | — | 3.50 | 3.86 | 3.39 | 1.70 | 1.29 | 1.69 | 1.58 | 1.26 | 1.12 | 2.25 | 1.98 | 1.68 | 1.42 | 1.34 | 1.09 | 0.84 | 0.70 | — | — | — | ||||||||
| Palo Alto Networks Inc. | — | — | — | — | — | — | — | — | — | — | — | — | 3.52 | — | 2.15 | 1.40 | 4.81 | 1.80 | 1.89 | 1.80 | 1.60 | 1.60 | 1.21 | 1.14 | — | — | — | ||||||||
| Salesforce Inc. | 42.02 | 99.31 | 90.67 | 62.21 | 30.85 | 25.15 | 54.57 | 24.95 | 27.10 | — | 4.36 | 5.11 | 7.48 | 10.29 | 9.75 | 15.29 | 28.71 | — | — | — | — | — | — | — | — | — | — | ||||||||
| ServiceNow Inc. | — | — | — | 21.77 | 19.04 | 9.59 | 7.83 | 11.16 | 6.63 | 11.21 | 10.61 | 21.76 | 11.15 | 16.31 | 5.62 | 5.76 | 3.73 | 8.10 | 43.84 | 46.69 | — | — | — | — | — | — | — | ||||||||
| Synopsys Inc. | — | — | 8.03 | 13.12 | 10.27 | 12.83 | 17.05 | 21.34 | 14.02 | 7.78 | 9.47 | 10.65 | 9.50 | 9.18 | 16.88 | 9.00 | 27.06 | — | — | — | — | — | — | — | — | — | — | ||||||||
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
Working capital turnover
= (RevenueQ3 2024
+ RevenueQ2 2024
+ RevenueQ1 2024
+ RevenueQ4 2023)
÷ Working capital
= (61,858 + 62,020 + 56,517 + 56,189)
÷ 28,655 = 8.26
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Working capital turnover | An activity ratio calculated as revenue divided by working capital. | Microsoft Corp. working capital turnover ratio improved from Q1 2024 to Q2 2024 but then slightly deteriorated from Q2 2024 to Q3 2024. |
Average Inventory Processing Period
Microsoft Corp., average inventory processing period 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 | |||||||||||||||||||||||||||||||||||
| Inventory turnover | 54.62 | 42.63 | 22.24 | 26.35 | 22.77 | 21.81 | 15.10 | 16.74 | 18.27 | 19.09 | 16.09 | 19.81 | 22.53 | 25.21 | 17.25 | 24.32 | 26.86 | 23.78 | 16.56 | 20.80 | 21.65 | 21.08 | 11.06 | 14.41 | — | — | — | ||||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||||||||
| Average inventory processing period1 | 7 | 9 | 16 | 14 | 16 | 17 | 24 | 22 | 20 | 19 | 23 | 18 | 16 | 14 | 21 | 15 | 14 | 15 | 22 | 18 | 17 | 17 | 33 | 25 | — | — | — | ||||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||||||||||||
| Average Inventory Processing Period, Competitors2 | |||||||||||||||||||||||||||||||||||
| International Business Machines Corp. | — | — | — | 15 | 19 | 20 | 21 | 20 | 23 | 22 | 24 | 23 | 24 | 21 | 19 | 18 | 18 | 17 | 16 | 15 | — | — | — | — | — | — | — | ||||||||
| Synopsys Inc. | — | — | 110 | 97 | 88 | 82 | 74 | 73 | 79 | 82 | 85 | 97 | 103 | 100 | 104 | 88 | 77 | 81 | 72 | 69 | 74 | 80 | 67 | 61 | — | — | — | ||||||||
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
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 54.62 = 7
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average inventory processing period | An activity ratio equal to the number of days in the period divided by inventory turnover over the period. | Microsoft Corp. number of days of inventory outstanding improved from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024. |
Average Receivable Collection Period
Microsoft Corp., average receivable collection period 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 | |||||||||||||||||||||||||||||||||||
| Receivables turnover | 5.37 | 5.31 | 5.91 | 4.35 | 5.55 | 5.70 | 6.49 | 4.48 | 5.90 | 5.52 | 6.44 | 4.42 | 6.08 | 5.61 | 6.44 | 4.47 | 6.11 | 5.71 | 6.80 | 4.26 | 6.34 | 6.02 | 6.61 | 4.17 | — | — | — | ||||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||||||||
| Average receivable collection period1 | 68 | 69 | 62 | 84 | 66 | 64 | 56 | 81 | 62 | 66 | 57 | 83 | 60 | 65 | 57 | 82 | 60 | 64 | 54 | 86 | 58 | 61 | 55 | 88 | — | — | — | ||||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||||||||||||
| Average Receivable Collection Period, Competitors2 | |||||||||||||||||||||||||||||||||||
| Adobe Inc. | — | — | 38 | 42 | 36 | 33 | 37 | 43 | 37 | 35 | 38 | 43 | 37 | 37 | 41 | 40 | 39 | 41 | 43 | 50 | 47 | 46 | 51 | 53 | — | — | — | ||||||||
| International Business Machines Corp. | — | — | — | 43 | 32 | 34 | 35 | 39 | 33 | 36 | 37 | 43 | 40 | 38 | 34 | 35 | 30 | 32 | 33 | 37 | — | — | — | — | — | — | — | ||||||||
| Intuit Inc. | — | 22 | 9 | 10 | 19 | 24 | 11 | 13 | 21 | 28 | 15 | 15 | 23 | 22 | 5 | 7 | 12 | 31 | 5 | 5 | 14 | 31 | 5 | 6 | — | — | — | ||||||||
| Oracle Corp. | 51 | 48 | 47 | 51 | 47 | 49 | 49 | 51 | 40 | 39 | 40 | 49 | 43 | 41 | 43 | 52 | 38 | 37 | 35 | 47 | 37 | 36 | 34 | 48 | — | — | — | ||||||||
| Palo Alto Networks Inc. | — | 92 | 72 | 130 | 81 | 76 | 78 | 142 | 88 | 72 | 65 | 106 | 70 | 65 | 69 | 111 | 75 | 63 | 60 | 73 | 54 | 58 | 58 | 75 | — | — | — | ||||||||
| Salesforce Inc. | 52 | 60 | 53 | 125 | 52 | 59 | 52 | 134 | 59 | 63 | 52 | 134 | 60 | 65 | 62 | 132 | 59 | 58 | 56 | 135 | — | — | — | — | — | — | — | ||||||||
| ServiceNow Inc. | — | — | — | 83 | 50 | 50 | 53 | 87 | 47 | 47 | 48 | 86 | 51 | 55 | 49 | 82 | 55 | 58 | 60 | 88 | — | — | — | — | — | — | — | ||||||||
| Synopsys Inc. | — | — | 63 | 59 | 44 | 54 | 73 | 57 | 50 | 55 | 84 | 49 | 52 | 56 | 75 | 77 | 66 | 68 | 86 | 60 | 51 | 59 | 88 | 65 | — | — | — | ||||||||
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
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 5.37 = 68
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | Microsoft Corp. number of days of receivables outstanding deteriorated from Q1 2024 to Q2 2024 but then slightly improved from Q2 2024 to Q3 2024. |
Operating Cycle
Microsoft Corp., operating cycle calculation (quarterly data)
No. days
| 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 | |||||||||||||||||||||||||||||||||||
| Average inventory processing period | 7 | 9 | 16 | 14 | 16 | 17 | 24 | 22 | 20 | 19 | 23 | 18 | 16 | 14 | 21 | 15 | 14 | 15 | 22 | 18 | 17 | 17 | 33 | 25 | — | — | — | ||||||||
| Average receivable collection period | 68 | 69 | 62 | 84 | 66 | 64 | 56 | 81 | 62 | 66 | 57 | 83 | 60 | 65 | 57 | 82 | 60 | 64 | 54 | 86 | 58 | 61 | 55 | 88 | — | — | — | ||||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||||||||
| Operating cycle1 | 75 | 78 | 78 | 98 | 82 | 81 | 80 | 103 | 82 | 85 | 80 | 101 | 76 | 79 | 78 | 97 | 74 | 79 | 76 | 104 | 75 | 78 | 88 | 113 | — | — | — | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Operating Cycle, Competitors2 | |||||||||||||||||||||||||||||||||||
| International Business Machines Corp. | — | — | — | 58 | 51 | 54 | 56 | 59 | 56 | 58 | 61 | 66 | 64 | 59 | 53 | 53 | 48 | 49 | 49 | 52 | — | — | — | — | — | — | — | ||||||||
| Synopsys Inc. | — | — | 173 | 156 | 132 | 136 | 147 | 130 | 129 | 137 | 169 | 146 | 155 | 156 | 179 | 165 | 143 | 149 | 158 | 129 | 125 | 139 | 155 | 126 | — | — | — | ||||||||
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
Operating cycle = Average inventory processing period + Average receivable collection period
= 7 + 68 = 75
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Operating cycle | Equal to average inventory processing period plus average receivables collection period. |
Average Payables Payment Period
Microsoft Corp., average payables payment period 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 | |||||||||||||||||||||||||||||||||||
| Payables turnover | 3.94 | 3.89 | 3.46 | 3.64 | 4.28 | 4.23 | 3.88 | 3.30 | 3.74 | 3.76 | 3.70 | 3.44 | 3.77 | 3.80 | 3.73 | 3.68 | 4.78 | 4.92 | 5.06 | 4.57 | 5.60 | 5.47 | 4.70 | 4.45 | — | — | — | ||||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||||||||
| Average payables payment period1 | 93 | 94 | 106 | 100 | 85 | 86 | 94 | 111 | 98 | 97 | 99 | 106 | 97 | 96 | 98 | 99 | 76 | 74 | 72 | 80 | 65 | 67 | 78 | 82 | — | — | — | ||||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||||||||||||
| Average Payables Payment Period, Competitors2 | |||||||||||||||||||||||||||||||||||
| Accenture PLC | — | 19 | 22 | 21 | 20 | 21 | 21 | 22 | 22 | 21 | 22 | 24 | 22 | 20 | 18 | 16 | 17 | 18 | 19 | 20 | 19 | 18 | 17 | 17 | — | — | — | ||||||||
| Adobe Inc. | — | — | 46 | 49 | 50 | 56 | 51 | 64 | 55 | 66 | 56 | 61 | 68 | 65 | 54 | 65 | 48 | 61 | 56 | 46 | 43 | 42 | 40 | 57 | — | — | — | ||||||||
| International Business Machines Corp. | — | — | — | 55 | 44 | 50 | 49 | 53 | 50 | 49 | 47 | 56 | 54 | 49 | 44 | 47 | 37 | 44 | 38 | 44 | — | — | — | — | — | — | — | ||||||||
| Intuit Inc. | — | 87 | 71 | 74 | 111 | 103 | 92 | 112 | 145 | 158 | 105 | 135 | 142 | 129 | 70 | 81 | 105 | 131 | 82 | 86 | 125 | 137 | 74 | 66 | — | — | — | ||||||||
| Oracle Corp. | 40 | 28 | 27 | 32 | 48 | 55 | 54 | 54 | 48 | 45 | 34 | 35 | 38 | 34 | 25 | 29 | 24 | 24 | 22 | 26 | 27 | 26 | 24 | 24 | — | — | — | ||||||||
| Palo Alto Networks Inc. | — | 33 | 25 | 25 | 18 | 25 | 26 | 27 | 25 | 30 | 25 | 16 | 22 | 14 | 17 | 23 | 21 | 23 | 32 | 33 | 32 | 14 | 23 | 28 | — | — | — | ||||||||
| ServiceNow Inc. | — | — | — | 24 | 14 | 36 | 51 | 64 | 46 | 65 | 43 | 24 | 19 | 31 | 37 | 13 | 20 | 36 | 32 | 24 | — | — | — | — | — | — | — | ||||||||
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
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 3.94 = 93
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average payables payment period | An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. | Microsoft Corp. number of days of payables outstanding decreased from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024. |
Cash Conversion Cycle
Microsoft Corp., cash conversion cycle calculation (quarterly data)
No. days
| 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 | |||||||||||||||||||||||||||||||||||
| Average inventory processing period | 7 | 9 | 16 | 14 | 16 | 17 | 24 | 22 | 20 | 19 | 23 | 18 | 16 | 14 | 21 | 15 | 14 | 15 | 22 | 18 | 17 | 17 | 33 | 25 | — | — | — | ||||||||
| Average receivable collection period | 68 | 69 | 62 | 84 | 66 | 64 | 56 | 81 | 62 | 66 | 57 | 83 | 60 | 65 | 57 | 82 | 60 | 64 | 54 | 86 | 58 | 61 | 55 | 88 | — | — | — | ||||||||
| Average payables payment period | 93 | 94 | 106 | 100 | 85 | 86 | 94 | 111 | 98 | 97 | 99 | 106 | 97 | 96 | 98 | 99 | 76 | 74 | 72 | 80 | 65 | 67 | 78 | 82 | — | — | — | ||||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||||||||
| Cash conversion cycle1 | -18 | -16 | -28 | -2 | -3 | -5 | -14 | -8 | -16 | -12 | -19 | -5 | -21 | -17 | -20 | -2 | -2 | 5 | 4 | 24 | 10 | 11 | 10 | 31 | — | — | — | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Cash Conversion Cycle, Competitors2 | |||||||||||||||||||||||||||||||||||
| International Business Machines Corp. | — | — | — | 3 | 7 | 4 | 7 | 6 | 6 | 9 | 14 | 10 | 10 | 10 | 9 | 6 | 11 | 5 | 11 | 8 | — | — | — | — | — | — | — | ||||||||
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
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 7 + 68 – 93 = -18
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Cash conversion cycle | A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. | Microsoft Corp. cash conversion cycle deteriorated from Q1 2024 to Q2 2024 but then slightly improved from Q2 2024 to Q3 2024. |