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)
Alphabet Inc., short-term (operating) activity ratios (quarterly data)
Based on: 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31).
| Short-term activity ratio | Description | The company |
|---|---|---|
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | Alphabet Inc. receivables turnover ratio deteriorated from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024. |
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Alphabet Inc. payables turnover ratio decreased from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024. |
| Working capital turnover | An activity ratio calculated as revenue divided by working capital. | Alphabet Inc. working capital turnover ratio improved from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024. |
| 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. | Alphabet Inc. number of days of receivables outstanding deteriorated from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024. |
| 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. | Alphabet Inc. number of days of payables outstanding increased from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024. |
Receivables Turnover
Alphabet Inc., receivables turnover calculation (quarterly data)
| Dec 31, 2024 | Sep 30, 2024 | Jun 30, 2024 | 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 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||
| Revenues | 96,469) | 88,268) | 84,742) | 80,539) | 86,310) | 76,693) | 74,604) | 69,787) | 76,048) | 69,092) | 69,685) | 68,011) | 75,325) | 65,118) | 61,880) | 55,314) | 56,898) | 46,173) | 38,297) | 41,159) | ||||||
| Accounts receivable, net | 52,340) | 49,104) | 47,087) | 44,552) | 47,964) | 41,020) | 38,804) | 36,036) | 40,258) | 34,697) | 35,707) | 34,703) | 39,304) | 34,047) | 31,967) | 28,006) | 30,930) | 24,925) | 21,201) | 21,825) | ||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||
| Receivables turnover1 | 6.69 | 6.92 | 6.97 | 7.14 | 6.41 | 7.24 | 7.46 | 7.90 | 7.03 | 8.13 | 7.79 | 7.79 | 6.55 | 7.03 | 6.89 | 7.02 | 5.90 | — | — | — | ||||||
| Benchmarks | ||||||||||||||||||||||||||
| Receivables Turnover, Competitors2 | ||||||||||||||||||||||||||
| Comcast Corp. | 9.06 | 8.77 | 9.20 | 9.28 | 8.80 | 9.42 | 9.29 | 9.78 | 9.58 | 10.17 | 10.18 | 9.77 | 9.69 | 9.50 | 9.81 | 9.48 | 9.03 | — | — | — | ||||||
| Meta Platforms Inc. | 9.68 | 10.63 | 10.33 | 10.63 | 8.34 | 9.81 | 9.63 | 10.63 | 8.66 | 10.52 | 10.36 | 10.51 | 8.40 | 9.29 | 8.96 | 9.19 | 7.58 | — | — | — | ||||||
| Walt Disney Co. | 7.18 | 6.94 | 7.42 | 6.30 | 7.21 | 6.70 | 6.81 | 6.03 | 6.54 | 5.93 | 5.57 | 4.90 | 5.04 | 4.76 | 4.66 | 4.32 | 5.15 | 5.53 | 5.38 | 4.39 | ||||||
Based on: 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31).
1 Q4 2024 Calculation
Receivables turnover
= (RevenuesQ4 2024
+ RevenuesQ3 2024
+ RevenuesQ2 2024
+ RevenuesQ1 2024)
÷ Accounts receivable, net
= (96,469 + 88,268 + 84,742 + 80,539)
÷ 52,340 = 6.69
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. | Alphabet Inc. receivables turnover ratio deteriorated from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024. |
Payables Turnover
Alphabet Inc., payables turnover calculation (quarterly data)
| Dec 31, 2024 | Sep 30, 2024 | Jun 30, 2024 | 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 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||
| Cost of revenues | 40,613) | 36,474) | 35,507) | 33,712) | 37,575) | 33,229) | 31,916) | 30,612) | 35,342) | 31,158) | 30,104) | 29,599) | 32,988) | 27,621) | 26,227) | 24,103) | 26,080) | 21,117) | 18,553) | 18,982) | ||||||
| Accounts payable | 7,987) | 7,049) | 6,092) | 6,198) | 7,493) | 5,803) | 5,313) | 4,184) | 5,128) | 6,303) | 4,409) | 3,436) | 6,037) | 4,616) | 4,708) | 4,801) | 5,589) | 4,391) | 4,064) | 4,099) | ||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||
| Payables turnover1 | 18.32 | 20.32 | 22.98 | 22.01 | 17.79 | 22.59 | 24.29 | 30.41 | 24.61 | 19.65 | 27.29 | 33.89 | 18.38 | 22.54 | 20.72 | 18.72 | 15.16 | — | — | — | ||||||
| Benchmarks | ||||||||||||||||||||||||||
| Payables Turnover, Competitors2 | ||||||||||||||||||||||||||
| Comcast Corp. | 3.27 | 3.16 | 3.04 | 3.10 | 2.96 | 2.97 | 3.00 | 3.01 | 3.05 | 3.13 | 3.23 | 3.16 | 3.09 | 3.16 | 3.10 | 3.03 | 2.91 | — | — | — | ||||||
| Meta Platforms Inc. | 3.92 | 3.79 | 8.78 | 7.00 | 5.35 | 6.08 | 8.44 | 6.90 | 5.06 | 6.01 | 5.82 | 7.25 | 5.55 | 9.80 | 20.49 | 20.92 | 12.54 | — | — | — | ||||||
| Netflix Inc. | 23.38 | 32.06 | 34.06 | 32.75 | 26.38 | 37.07 | 31.96 | 33.26 | 28.54 | 33.93 | 36.53 | 28.76 | 20.70 | 25.28 | 25.56 | 29.17 | 23.28 | — | — | — | ||||||
Based on: 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31).
1 Q4 2024 Calculation
Payables turnover
= (Cost of revenuesQ4 2024
+ Cost of revenuesQ3 2024
+ Cost of revenuesQ2 2024
+ Cost of revenuesQ1 2024)
÷ Accounts payable
= (40,613 + 36,474 + 35,507 + 33,712)
÷ 7,987 = 18.32
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. | Alphabet Inc. payables turnover ratio decreased from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024. |
Working Capital Turnover
Alphabet Inc., working capital turnover calculation (quarterly data)
| Dec 31, 2024 | Sep 30, 2024 | Jun 30, 2024 | 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 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||
| Current assets | 163,711) | 157,541) | 161,995) | 165,471) | 171,530) | 176,310) | 168,788) | 161,985) | 164,795) | 166,109) | 172,371) | 177,853) | 188,143) | 184,110) | 175,697) | 172,137) | 174,296) | 164,369) | 149,069) | 147,018) | ||||||
| Less: Current liabilities | 89,122) | 80,803) | 77,913) | 76,997) | 81,814) | 86,295) | 77,709) | 68,854) | 69,300) | 65,979) | 61,354) | 61,948) | 64,254) | 61,782) | 55,741) | 55,453) | 56,834) | 48,200) | 43,658) | 40,189) | ||||||
| Working capital | 74,589) | 76,738) | 84,082) | 88,474) | 89,716) | 90,015) | 91,079) | 93,131) | 95,495) | 100,130) | 111,017) | 115,905) | 123,889) | 122,328) | 119,956) | 116,684) | 117,462) | 116,169) | 105,411) | 106,829) | ||||||
| Revenues | 96,469) | 88,268) | 84,742) | 80,539) | 86,310) | 76,693) | 74,604) | 69,787) | 76,048) | 69,092) | 69,685) | 68,011) | 75,325) | 65,118) | 61,880) | 55,314) | 56,898) | 46,173) | 38,297) | 41,159) | ||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||
| Working capital turnover1 | 4.69 | 4.43 | 3.90 | 3.60 | 3.43 | 3.30 | 3.18 | 3.06 | 2.96 | 2.82 | 2.51 | 2.33 | 2.08 | 1.96 | 1.84 | 1.69 | 1.55 | — | — | — | ||||||
| Benchmarks | ||||||||||||||||||||||||||
| Working Capital Turnover, Competitors2 | ||||||||||||||||||||||||||
| Comcast Corp. | — | — | — | — | — | — | — | — | — | — | — | — | — | 165.10 | — | — | — | — | — | — | ||||||
| Meta Platforms Inc. | 2.48 | 2.71 | 3.03 | 3.02 | 2.53 | 2.65 | 3.04 | 4.33 | 3.59 | 3.32 | 3.54 | 3.13 | 2.59 | 1.95 | 1.59 | 1.46 | 1.42 | — | — | — | ||||||
| Netflix Inc. | 16.63 | 26.43 | — | 55.26 | 31.89 | 13.41 | 11.35 | 14.73 | 23.67 | 29.95 | 91.06 | 84.84 | — | 20.95 | 15.57 | 12.30 | 12.78 | — | — | — | ||||||
| Walt Disney Co. | — | — | — | — | 54.74 | 45.26 | 420.20 | — | 3,308.88 | 112.96 | 41.96 | 25.38 | 26.13 | 9.70 | 9.36 | 7.30 | 7.58 | 6.70 | — | — | ||||||
Based on: 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31).
1 Q4 2024 Calculation
Working capital turnover
= (RevenuesQ4 2024
+ RevenuesQ3 2024
+ RevenuesQ2 2024
+ RevenuesQ1 2024)
÷ Working capital
= (96,469 + 88,268 + 84,742 + 80,539)
÷ 74,589 = 4.69
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. | Alphabet Inc. working capital turnover ratio improved from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024. |
Average Receivable Collection Period
Alphabet Inc., average receivable collection period calculation (quarterly data)
| Dec 31, 2024 | Sep 30, 2024 | Jun 30, 2024 | 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 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||||||||||||||||||||||
| Receivables turnover | 6.69 | 6.92 | 6.97 | 7.14 | 6.41 | 7.24 | 7.46 | 7.90 | 7.03 | 8.13 | 7.79 | 7.79 | 6.55 | 7.03 | 6.89 | 7.02 | 5.90 | — | — | — | ||||||
| Short-term Activity Ratio (no. days) | ||||||||||||||||||||||||||
| Average receivable collection period1 | 55 | 53 | 52 | 51 | 57 | 50 | 49 | 46 | 52 | 45 | 47 | 47 | 56 | 52 | 53 | 52 | 62 | — | — | — | ||||||
| Benchmarks (no. days) | ||||||||||||||||||||||||||
| Average Receivable Collection Period, Competitors2 | ||||||||||||||||||||||||||
| Comcast Corp. | 40 | 42 | 40 | 39 | 41 | 39 | 39 | 37 | 38 | 36 | 36 | 37 | 38 | 38 | 37 | 38 | 40 | — | — | — | ||||||
| Meta Platforms Inc. | 38 | 34 | 35 | 34 | 44 | 37 | 38 | 34 | 42 | 35 | 35 | 35 | 43 | 39 | 41 | 40 | 48 | — | — | — | ||||||
| Walt Disney Co. | 51 | 53 | 49 | 58 | 51 | 55 | 54 | 61 | 56 | 62 | 65 | 74 | 72 | 77 | 78 | 84 | 71 | 66 | 68 | 83 | ||||||
Based on: 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31).
1 Q4 2024 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 6.69 = 55
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. | Alphabet Inc. number of days of receivables outstanding deteriorated from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024. |
Average Payables Payment Period
Alphabet Inc., average payables payment period calculation (quarterly data)
| Dec 31, 2024 | Sep 30, 2024 | Jun 30, 2024 | 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 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||||||||||||||||||||||
| Payables turnover | 18.32 | 20.32 | 22.98 | 22.01 | 17.79 | 22.59 | 24.29 | 30.41 | 24.61 | 19.65 | 27.29 | 33.89 | 18.38 | 22.54 | 20.72 | 18.72 | 15.16 | — | — | — | ||||||
| Short-term Activity Ratio (no. days) | ||||||||||||||||||||||||||
| Average payables payment period1 | 20 | 18 | 16 | 17 | 21 | 16 | 15 | 12 | 15 | 19 | 13 | 11 | 20 | 16 | 18 | 20 | 24 | — | — | — | ||||||
| Benchmarks (no. days) | ||||||||||||||||||||||||||
| Average Payables Payment Period, Competitors2 | ||||||||||||||||||||||||||
| Comcast Corp. | 112 | 115 | 120 | 118 | 123 | 123 | 122 | 121 | 120 | 117 | 113 | 116 | 118 | 115 | 118 | 121 | 125 | — | — | — | ||||||
| Meta Platforms Inc. | 93 | 96 | 42 | 52 | 68 | 60 | 43 | 53 | 72 | 61 | 63 | 50 | 66 | 37 | 18 | 17 | 29 | — | — | — | ||||||
| Netflix Inc. | 16 | 11 | 11 | 11 | 14 | 10 | 11 | 11 | 13 | 11 | 10 | 13 | 18 | 14 | 14 | 13 | 16 | — | — | — | ||||||
Based on: 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31).
1 Q4 2024 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 18.32 = 20
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. | Alphabet Inc. number of days of payables outstanding increased from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024. |