Stock Analysis on Net

Twitter Inc. (NYSE:TWTR)

This company has been moved to the archive! The financial data has not been updated since July 26, 2022.

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

Microsoft Excel

Short-term Activity Ratios (Summary)

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

Microsoft Excel
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 Jun 30, 2017 Mar 31, 2017
Turnover Ratios
Receivables turnover 5.38 5.53 4.17 4.73 4.67 4.64 3.57 4.59 5.53 5.30 4.07 4.91 4.58 4.62 3.86 4.61 4.39 4.18 3.68
Payables turnover 13.38 10.15 8.85 8.25 4.89 6.65 7.03 5.17 7.20 6.29 7.06 7.24 5.11 5.84 6.65 7.84 5.46 6.26 5.04
Working capital turnover 0.84 0.83 0.77 0.73 0.60 0.50 0.56 0.52 0.43 0.45 0.51 0.57 0.57 0.56 0.54 0.54 0.45 0.52 0.52
Average No. Days
Average receivable collection period 68 66 88 77 78 79 102 79 66 69 90 74 80 79 95 79 83 87 99
Average payables payment period 27 36 41 44 75 55 52 71 51 58 52 50 71 62 55 47 67 58 72

Based on: 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), 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).

Short-term activity ratio Description The company
Receivables turnover An activity ratio equal to revenue divided by receivables. Twitter Inc. receivables turnover ratio improved from Q4 2021 to Q1 2022 but then slightly deteriorated from Q1 2022 to Q2 2022.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Twitter Inc. payables turnover ratio increased from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022.
Working capital turnover An activity ratio calculated as revenue divided by working capital. Twitter Inc. working capital turnover ratio improved from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022.

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. Twitter Inc. number of days of receivables outstanding improved from Q4 2021 to Q1 2022 but then slightly deteriorated from Q1 2022 to Q2 2022.
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. Twitter Inc. number of days of payables outstanding decreased from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022.

Receivables Turnover

Twitter Inc., receivables turnover calculation (quarterly data)

Microsoft Excel
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 Jun 30, 2017 Mar 31, 2017
Selected Financial Data (US$ in thousands)
Revenue 1,176,660 1,200,984 1,567,220 1,283,817 1,190,427 1,036,018 1,289,041 936,233 683,438 807,637 1,007,341 823,717 841,381 786,890 908,836 758,111 710,541 664,871 731,560 589,633 573,855 548,251
Accounts receivable, net of allowance for doubtful accounts 972,591 948,142 1,217,404 1,014,208 954,265 850,075 1,041,743 747,548 600,777 656,377 850,184 684,186 719,904 684,220 788,700 621,943 614,944 611,840 664,268 509,854 524,064 501,153
Short-term Activity Ratio
Receivables turnover1 5.38 5.53 4.17 4.73 4.67 4.64 3.57 4.59 5.53 5.30 4.07 4.91 4.58 4.62 3.86 4.61 4.39 4.18 3.68
Benchmarks
Receivables Turnover, Competitors2
Alphabet Inc. 7.79 7.79 6.55 7.03 6.89 7.02 5.90 6.89 7.83 7.64 6.39
Comcast Corp. 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.36 10.51 8.40 9.29 8.96 9.19 7.58 9.84 10.04 10.06 7.43
Walt Disney Co. 5.57 4.90 5.04 4.76 4.66 4.32 5.15 5.53 5.38 4.39 4.49 4.13 4.10 5.87 6.37

Based on: 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), 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).

1 Q2 2022 Calculation
Receivables turnover = (RevenueQ2 2022 + RevenueQ1 2022 + RevenueQ4 2021 + RevenueQ3 2021) ÷ Accounts receivable, net of allowance for doubtful accounts
= (1,176,660 + 1,200,984 + 1,567,220 + 1,283,817) ÷ 972,591 = 5.38

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. Twitter Inc. receivables turnover ratio improved from Q4 2021 to Q1 2022 but then slightly deteriorated from Q1 2022 to Q2 2022.

Payables Turnover

Twitter Inc., payables turnover calculation (quarterly data)

Microsoft Excel
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 Jun 30, 2017 Mar 31, 2017
Selected Financial Data (US$ in thousands)
Cost of revenue 540,676 507,450 515,091 484,479 416,932 381,008 432,924 361,388 288,039 284,037 314,008 281,057 277,965 264,011 268,345 243,644 230,185 222,823 217,979 210,016 212,908 220,339
Accounts payable 153,092 189,524 203,171 207,912 325,446 219,899 194,281 241,102 162,160 183,921 161,148 150,785 206,282 172,169 145,186 116,685 161,300 137,968 170,969 103,112 107,398 86,176
Short-term Activity Ratio
Payables turnover1 13.38 10.15 8.85 8.25 4.89 6.65 7.03 5.17 7.20 6.29 7.06 7.24 5.11 5.84 6.65 7.84 5.46 6.26 5.04
Benchmarks
Payables Turnover, Competitors2
Alphabet Inc. 27.29 33.89 18.38 22.54 20.72 18.72 15.16 18.14 18.73 18.26 12.93
Comcast Corp. 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. 5.82 7.25 5.55 9.80 20.49 20.92 12.54 13.54 15.15 16.18 9.37
Netflix Inc. 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: 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), 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).

1 Q2 2022 Calculation
Payables turnover = (Cost of revenueQ2 2022 + Cost of revenueQ1 2022 + Cost of revenueQ4 2021 + Cost of revenueQ3 2021) ÷ Accounts payable
= (540,676 + 507,450 + 515,091 + 484,479) ÷ 153,092 = 13.38

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. Twitter Inc. payables turnover ratio increased from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022.

Working Capital Turnover

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

Microsoft Excel
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 Jun 30, 2017 Mar 31, 2017
Selected Financial Data (US$ in thousands)
Current assets 7,273,581 7,476,068 7,918,370 8,649,234 9,728,141 9,863,742 8,637,108 8,589,579 8,495,287 8,467,579 7,620,075 6,624,451 7,512,783 7,255,785 7,111,036 6,719,760 6,540,504 5,409,235 5,321,884 5,002,422 4,840,102 4,695,332
Less: Current liabilities 1,017,263 1,136,707 1,343,867 2,114,981 2,257,919 2,036,693 1,952,826 1,935,103 841,107 710,020 832,476 762,627 1,733,738 1,621,679 1,516,311 1,457,646 594,419 528,654 583,278 481,202 494,578 488,992
Working capital 6,256,318 6,339,361 6,574,503 6,534,253 7,470,222 7,827,049 6,684,282 6,654,476 7,654,180 7,757,559 6,787,599 5,861,824 5,779,045 5,634,106 5,594,725 5,262,114 5,946,085 4,880,581 4,738,606 4,521,220 4,345,524 4,206,340
 
Revenue 1,176,660 1,200,984 1,567,220 1,283,817 1,190,427 1,036,018 1,289,041 936,233 683,438 807,637 1,007,341 823,717 841,381 786,890 908,836 758,111 710,541 664,871 731,560 589,633 573,855 548,251
Short-term Activity Ratio
Working capital turnover1 0.84 0.83 0.77 0.73 0.60 0.50 0.56 0.52 0.43 0.45 0.51 0.57 0.57 0.56 0.54 0.54 0.45 0.52 0.52
Benchmarks
Working Capital Turnover, Competitors2
Alphabet Inc. 2.51 2.33 2.08 1.96 1.84 1.69 1.55 1.48 1.58 1.56 1.51
Comcast Corp. 165.10
Meta Platforms Inc. 3.54 3.13 2.59 1.95 1.59 1.46 1.42 1.47 1.32 1.35 1.38
Netflix Inc. 91.06 84.84 20.95 15.57 12.30 12.78 12.62 24.13
Walt Disney Co. 41.96 25.38 26.13 9.70 9.36 7.30 7.58 6.70

Based on: 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), 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).

1 Q2 2022 Calculation
Working capital turnover = (RevenueQ2 2022 + RevenueQ1 2022 + RevenueQ4 2021 + RevenueQ3 2021) ÷ Working capital
= (1,176,660 + 1,200,984 + 1,567,220 + 1,283,817) ÷ 6,256,318 = 0.84

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. Twitter Inc. working capital turnover ratio improved from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022.

Average Receivable Collection Period

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

Microsoft Excel
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 Jun 30, 2017 Mar 31, 2017
Selected Financial Data
Receivables turnover 5.38 5.53 4.17 4.73 4.67 4.64 3.57 4.59 5.53 5.30 4.07 4.91 4.58 4.62 3.86 4.61 4.39 4.18 3.68
Short-term Activity Ratio (no. days)
Average receivable collection period1 68 66 88 77 78 79 102 79 66 69 90 74 80 79 95 79 83 87 99
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Alphabet Inc. 47 47 56 52 53 52 62 53 47 48 57
Comcast Corp. 36 37 38 38 37 38 40 36 35 36 38
Meta Platforms Inc. 35 35 43 39 41 40 48 37 36 36 49
Walt Disney Co. 65 74 72 77 78 84 71 66 68 83 81 88 89 62 57

Based on: 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), 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).

1 Q2 2022 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 5.38 = 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. Twitter Inc. number of days of receivables outstanding improved from Q4 2021 to Q1 2022 but then slightly deteriorated from Q1 2022 to Q2 2022.

Average Payables Payment Period

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

Microsoft Excel
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 Jun 30, 2017 Mar 31, 2017
Selected Financial Data
Payables turnover 13.38 10.15 8.85 8.25 4.89 6.65 7.03 5.17 7.20 6.29 7.06 7.24 5.11 5.84 6.65 7.84 5.46 6.26 5.04
Short-term Activity Ratio (no. days)
Average payables payment period1 27 36 41 44 75 55 52 71 51 58 52 50 71 62 55 47 67 58 72
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Alphabet Inc. 13 11 20 16 18 20 24 20 19 20 28
Comcast Corp. 113 116 118 115 118 121 125 121 116 106 115
Meta Platforms Inc. 63 50 66 37 18 17 29 27 24 23 39
Netflix Inc. 10 13 18 14 14 13 16 14 12 15 20

Based on: 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), 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).

1 Q2 2022 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 13.38 = 27

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. Twitter Inc. number of days of payables outstanding decreased from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022.