Stock Analysis on Net

Alphabet Inc. (NASDAQ:GOOG)

Analysis of Short-term (Operating) Activity Ratios
Quarterly Data

Microsoft Excel

Short-term Activity Ratios (Summary)

Alphabet Inc., short-term (operating) activity ratios (quarterly data)

Microsoft Excel
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 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Turnover Ratios
Receivables turnover 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 6.89 7.83 7.64 6.39
Payables turnover 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 18.14 18.73 18.26 12.93
Working capital turnover 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 1.48 1.58 1.56 1.51
Average No. Days
Average receivable collection period 53 52 51 57 50 49 46 52 45 47 47 56 52 53 52 62 53 47 48 57
Average payables payment period 18 16 17 21 16 15 12 15 19 13 11 20 16 18 20 24 20 19 20 28

Based on: 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), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-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 Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Alphabet Inc. payables turnover ratio increased from Q1 2024 to Q2 2024 but then decreased significantly from Q2 2024 to Q3 2024.
Working capital turnover An activity ratio calculated as revenue divided by working capital. Alphabet Inc. working capital turnover ratio improved from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 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 Q1 2024 to Q2 2024 and from Q2 2024 to Q3 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 decreased from Q1 2024 to Q2 2024 but then increased from Q2 2024 to Q3 2024 exceeding Q1 2024 level.

Receivables Turnover

Alphabet Inc., receivables turnover calculation (quarterly data)

Microsoft Excel
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 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Revenues 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 46,075 40,499 38,944 36,339
Accounts receivable, net 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 25,326 20,889 20,965 19,149
Short-term Activity Ratio
Receivables turnover1 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 6.89 7.83 7.64 6.39
Benchmarks
Receivables Turnover, Competitors2
Comcast Corp. 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 10.11 10.32 10.06 9.65
Meta Platforms Inc. 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 9.84 10.04 10.06 7.43
Walt Disney Co. 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 4.49

Based on: 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), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q3 2024 Calculation
Receivables turnover = (RevenuesQ3 2024 + RevenuesQ2 2024 + RevenuesQ1 2024 + RevenuesQ4 2023) ÷ Accounts receivable, net
= (88,268 + 84,742 + 80,539 + 86,310) ÷ 49,104 = 6.92

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 Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Payables Turnover

Alphabet Inc., payables turnover calculation (quarterly data)

Microsoft Excel
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 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Cost of revenues 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 21,020 17,568 17,296 16,012
Accounts payable 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 5,561 4,142 3,925 3,710
Short-term Activity Ratio
Payables turnover1 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 18.14 18.73 18.26 12.93
Benchmarks
Payables Turnover, Competitors2
Comcast Corp. 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 3.00 3.14 3.43 3.18
Meta Platforms Inc. 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 13.54 15.15 16.18 9.37
Netflix Inc. 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 26.93 30.91 24.14 18.45

Based on: 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), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q3 2024 Calculation
Payables turnover = (Cost of revenuesQ3 2024 + Cost of revenuesQ2 2024 + Cost of revenuesQ1 2024 + Cost of revenuesQ4 2023) ÷ Accounts payable
= (36,474 + 35,507 + 33,712 + 37,575) ÷ 7,049 = 20.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 increased from Q1 2024 to Q2 2024 but then decreased significantly from Q2 2024 to Q3 2024.

Working Capital Turnover

Alphabet Inc., working capital turnover calculation (quarterly data)

Microsoft Excel
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 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Current assets 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 152,578 148,358 147,437 138,207
Less: Current liabilities 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 45,221 39,224 37,000 34,910
Working capital 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 107,357 109,134 110,437 103,297
 
Revenues 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 46,075 40,499 38,944 36,339
Short-term Activity Ratio
Working capital turnover1 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 1.48 1.58 1.56 1.51
Benchmarks
Working Capital Turnover, Competitors2
Comcast Corp. 165.10
Meta Platforms Inc. 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 1.47 1.32 1.35 1.38
Netflix Inc. 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 12.62 24.13
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-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), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q3 2024 Calculation
Working capital turnover = (RevenuesQ3 2024 + RevenuesQ2 2024 + RevenuesQ1 2024 + RevenuesQ4 2023) ÷ Working capital
= (88,268 + 84,742 + 80,539 + 86,310) ÷ 76,738 = 4.43

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 Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Average Receivable Collection Period

Alphabet Inc., average receivable collection period calculation (quarterly data)

Microsoft Excel
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 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data
Receivables turnover 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 6.89 7.83 7.64 6.39
Short-term Activity Ratio (no. days)
Average receivable collection period1 53 52 51 57 50 49 46 52 45 47 47 56 52 53 52 62 53 47 48 57
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Comcast Corp. 42 40 39 41 39 39 37 38 36 36 37 38 38 37 38 40 36 35 36 38
Meta Platforms Inc. 34 35 34 44 37 38 34 42 35 35 35 43 39 41 40 48 37 36 36 49
Walt Disney Co. 53 49 58 51 55 54 61 56 62 65 74 72 77 78 84 71 66 68 83 81

Based on: 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), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q3 2024 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 6.92 = 53

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 Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Average Payables Payment Period

Alphabet Inc., average payables payment period calculation (quarterly data)

Microsoft Excel
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 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data
Payables turnover 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 18.14 18.73 18.26 12.93
Short-term Activity Ratio (no. days)
Average payables payment period1 18 16 17 21 16 15 12 15 19 13 11 20 16 18 20 24 20 19 20 28
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Comcast Corp. 115 120 118 123 123 122 121 120 117 113 116 118 115 118 121 125 121 116 106 115
Meta Platforms Inc. 96 42 52 68 60 43 53 72 61 63 50 66 37 18 17 29 27 24 23 39
Netflix Inc. 11 11 11 14 10 11 11 13 11 10 13 18 14 14 13 16 14 12 15 20

Based on: 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), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q3 2024 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 20.32 = 18

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 decreased from Q1 2024 to Q2 2024 but then increased from Q2 2024 to Q3 2024 exceeding Q1 2024 level.