Stock Analysis on Net

Alphabet Inc. (NASDAQ:GOOG)

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

Microsoft Excel LibreOffice Calc

Short-term Activity Ratios (Summary)

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

Microsoft Excel LibreOffice Calc
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 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016
Turnover Ratios
Inventory turnover 81.40 107.53 101.19 116.39 95.42 93.40 84.21 71.97 49.10 67.95 58.97 53.79 46.12 75.59 77.44 60.86 54.87 99.32 133.16 131.11
Receivables turnover 7.03 6.89 7.02 5.90 6.89 7.83 7.64 6.39 7.42 7.07 7.42 6.57 7.26 7.27 6.99 6.05 6.84 7.09 7.34 6.39
Payables turnover 22.54 20.72 18.72 15.16 18.14 18.73 18.26 12.93 16.61 16.69 16.74 13.60 14.75 15.66 13.97 14.53 15.70 15.89 16.17 17.22
Working capital turnover 1.96 1.84 1.69 1.55 1.48 1.58 1.56 1.51 1.42 1.34 1.37 1.35 1.32 1.31 1.19 1.11 1.06 1.06 1.01 1.02
Average No. Days
Average inventory processing period 4 3 4 3 4 4 4 5 7 5 6 7 8 5 5 6 7 4 3 3
Add: Average receivable collection period 52 53 52 62 53 47 48 57 49 52 49 56 50 50 52 60 53 51 50 57
Operating cycle 56 56 56 65 57 51 52 62 56 57 55 63 58 55 57 66 60 55 53 60
Less: Average payables payment period 16 18 20 24 20 19 20 28 22 22 22 27 25 23 26 25 23 23 23 21
Cash conversion cycle 40 38 36 41 37 32 32 34 34 35 33 36 33 32 31 41 37 32 30 39

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

Short-term activity ratio Description The company
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. Alphabet Inc. inventory turnover ratio improved from Q1 2021 to Q2 2021 but then deteriorated significantly from Q2 2021 to Q3 2021.
Receivables turnover An activity ratio equal to revenue divided by receivables. Alphabet Inc. receivables turnover ratio deteriorated from Q1 2021 to Q2 2021 but then improved from Q2 2021 to Q3 2021 exceeding Q1 2021 level.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Alphabet Inc. payables turnover ratio increased from Q1 2021 to Q2 2021 and from Q2 2021 to Q3 2021.
Working capital turnover An activity ratio calculated as revenue divided by working capital. Alphabet Inc. working capital turnover ratio improved from Q1 2021 to Q2 2021 and from Q2 2021 to Q3 2021.

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.
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover.
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. Alphabet Inc. number of days of payables outstanding decreased from Q1 2021 to Q2 2021 and from Q2 2021 to Q3 2021.
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. Alphabet Inc. cash conversion cycle deteriorated from Q1 2021 to Q2 2021 and from Q2 2021 to Q3 2021.

Inventory Turnover

Alphabet Inc., inventory turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016
Selected Financial Data (US$ in millions)
Cost of revenues 27,621  26,227  24,103  26,080  21,117  18,553  18,982  21,020  17,568  17,296  16,012  17,918  14,281  13,883  13,467  14,267  11,148  10,373  9,795  10,661  8,699  8,130  7,648 
Inventory 1,278  907  888  728  835  815  889  999  1,401  964  1,053  1,107  1,212  698  636  749  765  398  280  268  559  —  — 
Short-term Activity Ratio
Inventory turnover1 81.40 107.53 101.19 116.39 95.42 93.40 84.21 71.97 49.10 67.95 58.97 53.79 46.12 75.59 77.44 60.86 54.87 99.32 133.16 131.11
Benchmarks
Inventory Turnover, Competitors2
Walt Disney Co. 32.59 28.78 28.80 27.72 28.67 32.40 29.31 25.48 25.27 23.41 24.31 23.51 24.08 23.98 23.44 22.07 23.38 22.91 22.92 21.58

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

1 Q3 2021 Calculation
Inventory turnover = (Cost of revenuesQ3 2021 + Cost of revenuesQ2 2021 + Cost of revenuesQ1 2021 + Cost of revenuesQ4 2020) ÷ Inventory
= (27,621 + 26,227 + 24,103 + 26,080) ÷ 1,278 = 81.40

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. Alphabet Inc. inventory turnover ratio improved from Q1 2021 to Q2 2021 but then deteriorated significantly from Q2 2021 to Q3 2021.

Receivables Turnover

Alphabet Inc., receivables turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016
Selected Financial Data (US$ in millions)
Revenues 65,118  61,880  55,314  56,898  46,173  38,297  41,159  46,075  40,499  38,944  36,339  39,276  33,740  32,657  31,146  32,323  27,772  26,010  24,750  26,064  22,451  21,500  20,257 
Accounts receivable, net 34,047  31,967  28,006  30,930  24,925  21,201  21,825  25,326  20,889  20,965  19,149  20,838  17,897  17,043  16,777  18,336  15,295  14,003  12,913  14,137  11,979  11,686  10,818 
Short-term Activity Ratio
Receivables turnover1 7.03 6.89 7.02 5.90 6.89 7.83 7.64 6.39 7.42 7.07 7.42 6.57 7.26 7.27 6.99 6.05 6.84 7.09 7.34 6.39
Benchmarks
Receivables Turnover, Competitors2
Charter Communications Inc. 19.32 19.35 20.41 21.85 22.84 23.39 22.14 20.55 19.80 21.58 28.00 25.18 24.77 26.29 29.86 25.43 24.97 27.42 27.95 20.25
Comcast Corp. 9.50 9.81 9.48 9.03 10.11 10.32 10.06 9.65 10.15 9.57 9.18 8.51 9.86 9.88 9.92 9.89 10.57 10.70 10.91 10.11
Facebook Inc. 9.29 8.96 9.19 7.58 9.84 10.04 10.06 7.43 8.67 8.33 9.10 7.36 8.57 8.68 8.72 6.97 8.25 8.51 8.87 6.92
Walt Disney Co. 4.76 4.66 4.32 5.15 5.53 5.38 4.39 4.49 4.13 4.10 5.87 6.37 5.75 5.88 5.63 6.39 5.76 5.98 5.59 6.14

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

1 Q3 2021 Calculation
Receivables turnover = (RevenuesQ3 2021 + RevenuesQ2 2021 + RevenuesQ1 2021 + RevenuesQ4 2020) ÷ Accounts receivable, net
= (65,118 + 61,880 + 55,314 + 56,898) ÷ 34,047 = 7.03

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 2021 to Q2 2021 but then improved from Q2 2021 to Q3 2021 exceeding Q1 2021 level.

Payables Turnover

Alphabet Inc., payables turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016
Selected Financial Data (US$ in millions)
Cost of revenues 27,621  26,227  24,103  26,080  21,117  18,553  18,982  21,020  17,568  17,296  16,012  17,918  14,281  13,883  13,467  14,267  11,148  10,373  9,795  10,661  8,699  8,130  7,648 
Accounts payable 4,616  4,708  4,801  5,589  4,391  4,064  4,099  5,561  4,142  3,925  3,710  4,378  3,789  3,369  3,526  3,137  2,674  2,488  2,306  2,041  2,175  1,716  1,667 
Short-term Activity Ratio
Payables turnover1 22.54 20.72 18.72 15.16 18.14 18.73 18.26 12.93 16.61 16.69 16.74 13.60 14.75 15.66 13.97 14.53 15.70 15.89 16.17 17.22
Benchmarks
Payables Turnover, Competitors2
Comcast Corp. 3.16 3.10 3.03 2.91 3.00 3.14 3.43 3.18 3.37 3.27 3.01 3.50 3.88 3.85 3.64 3.67 3.59 3.86 3.77 3.54
Facebook Inc. 9.80 20.49 20.92 12.54 13.54 15.15 16.18 9.37 14.04 17.31 16.96 11.41 13.85 17.18 10.49 14.35 12.77 13.72 24.18 12.55
Netflix Inc. 25.28 25.56 29.17 23.28 26.93 30.91 24.14 18.45 26.36 25.19 23.98 17.70 21.16 19.64 19.04 21.30 23.91 24.68 21.43 19.27

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

1 Q3 2021 Calculation
Payables turnover = (Cost of revenuesQ3 2021 + Cost of revenuesQ2 2021 + Cost of revenuesQ1 2021 + Cost of revenuesQ4 2020) ÷ Accounts payable
= (27,621 + 26,227 + 24,103 + 26,080) ÷ 4,616 = 22.54

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

Working Capital Turnover

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

Microsoft Excel LibreOffice Calc
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 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016
Selected Financial Data (US$ in millions)
Current assets 184,110  175,697  172,137  174,296  164,369  149,069  147,018  152,578  148,358  147,437  138,207  135,676  129,702  124,157  123,761  124,308  119,345  112,386  108,794  105,408  98,546  94,238  90,955 
Less: Current liabilities 61,782  55,741  55,453  56,834  48,200  43,658  40,189  45,221  39,224  37,000  34,910  34,620  31,301  29,903  25,394  24,183  20,693  18,685  15,256  16,756  14,323  17,341  17,684 
Working capital 122,328  119,956  116,684  117,462  116,169  105,411  106,829  107,357  109,134  110,437  103,297  101,056  98,401  94,254  98,367  100,125  98,652  93,701  93,538  88,652  84,223  76,897  73,271 
 
Revenues 65,118  61,880  55,314  56,898  46,173  38,297  41,159  46,075  40,499  38,944  36,339  39,276  33,740  32,657  31,146  32,323  27,772  26,010  24,750  26,064  22,451  21,500  20,257 
Short-term Activity Ratio
Working capital turnover1 1.96 1.84 1.69 1.55 1.48 1.58 1.56 1.51 1.42 1.34 1.37 1.35 1.32 1.31 1.19 1.11 1.06 1.06 1.01 1.02
Benchmarks
Working Capital Turnover, Competitors2
Charter Communications Inc.
Comcast Corp. 165.10 24.75
Facebook Inc. 1.95 1.59 1.46 1.42 1.47 1.32 1.35 1.38 1.36 1.39 1.36 1.28 1.19 1.07 0.98 0.91 0.89 0.88 0.89 0.88
Netflix Inc. 20.95 15.57 12.30 12.78 12.62 24.13 4.93 6.12 4.25 7.04 5.31 10.13 6.46 12.69 7.79
Walt Disney Co. 9.70 9.36 7.30 7.58 6.70 973.68 448.65

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

1 Q3 2021 Calculation
Working capital turnover = (RevenuesQ3 2021 + RevenuesQ2 2021 + RevenuesQ1 2021 + RevenuesQ4 2020) ÷ Working capital
= (65,118 + 61,880 + 55,314 + 56,898) ÷ 122,328 = 1.96

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

Average Inventory Processing Period

Alphabet Inc., average inventory processing period calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016
Selected Financial Data
Inventory turnover 81.40 107.53 101.19 116.39 95.42 93.40 84.21 71.97 49.10 67.95 58.97 53.79 46.12 75.59 77.44 60.86 54.87 99.32 133.16 131.11
Short-term Activity Ratio (no. days)
Average inventory processing period1 4 3 4 3 4 4 4 5 7 5 6 7 8 5 5 6 7 4 3 3
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
Walt Disney Co. 11 13 13 13 13 11 12 14 14 16 15 16 15 15 16 17 16 16 16 17

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

1 Q3 2021 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 81.40 = 4

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.

Average Receivable Collection Period

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

Microsoft Excel LibreOffice Calc
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 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016
Selected Financial Data
Receivables turnover 7.03 6.89 7.02 5.90 6.89 7.83 7.64 6.39 7.42 7.07 7.42 6.57 7.26 7.27 6.99 6.05 6.84 7.09 7.34 6.39
Short-term Activity Ratio (no. days)
Average receivable collection period1 52 53 52 62 53 47 48 57 49 52 49 56 50 50 52 60 53 51 50 57
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Charter Communications Inc. 19 19 18 17 16 16 16 18 18 17 13 14 15 14 12 14 15 13 13 18
Comcast Corp. 38 37 38 40 36 35 36 38 36 38 40 43 37 37 37 37 35 34 33 36
Facebook Inc. 39 41 40 48 37 36 36 49 42 44 40 50 43 42 42 52 44 43 41 53
Walt Disney Co. 77 78 84 71 66 68 83 81 88 89 62 57 63 62 65 57 63 61 65 59

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

1 Q3 2021 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 7.03 = 52

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.

Operating Cycle

Alphabet Inc., operating cycle calculation (quarterly data)

No. days

Microsoft Excel LibreOffice Calc
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 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016
Selected Financial Data
Average inventory processing period 4 3 4 3 4 4 4 5 7 5 6 7 8 5 5 6 7 4 3 3
Average receivable collection period 52 53 52 62 53 47 48 57 49 52 49 56 50 50 52 60 53 51 50 57
Short-term Activity Ratio
Operating cycle1 56 56 56 65 57 51 52 62 56 57 55 63 58 55 57 66 60 55 53 60
Benchmarks
Operating Cycle, Competitors2
Walt Disney Co. 88 91 97 84 79 79 95 95 102 105 77 73 78 77 81 74 79 77 81 76

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

1 Q3 2021 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 4 + 52 = 56

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

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

Microsoft Excel LibreOffice Calc
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 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016
Selected Financial Data
Payables turnover 22.54 20.72 18.72 15.16 18.14 18.73 18.26 12.93 16.61 16.69 16.74 13.60 14.75 15.66 13.97 14.53 15.70 15.89 16.17 17.22
Short-term Activity Ratio (no. days)
Average payables payment period1 16 18 20 24 20 19 20 28 22 22 22 27 25 23 26 25 23 23 23 21
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Comcast Corp. 115 118 121 125 121 116 106 115 108 111 121 104 94 95 100 100 102 95 97 103
Facebook Inc. 37 18 17 29 27 24 23 39 26 21 22 32 26 21 35 25 29 27 15 29
Netflix Inc. 14 14 13 16 14 12 15 20 14 14 15 21 17 19 19 17 15 15 17 19

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

1 Q3 2021 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 22.54 = 16

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

Cash Conversion Cycle

Alphabet Inc., cash conversion cycle calculation (quarterly data)

No. days

Microsoft Excel LibreOffice Calc
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 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016
Selected Financial Data
Average inventory processing period 4 3 4 3 4 4 4 5 7 5 6 7 8 5 5 6 7 4 3 3
Average receivable collection period 52 53 52 62 53 47 48 57 49 52 49 56 50 50 52 60 53 51 50 57
Average payables payment period 16 18 20 24 20 19 20 28 22 22 22 27 25 23 26 25 23 23 23 21
Short-term Activity Ratio
Cash conversion cycle1 40 38 36 41 37 32 32 34 34 35 33 36 33 32 31 41 37 32 30 39

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

1 Q3 2021 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 4 + 5216 = 40

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. Alphabet Inc. cash conversion cycle deteriorated from Q1 2021 to Q2 2021 and from Q2 2021 to Q3 2021.