Stock Analysis on Net

Verizon Communications Inc. (NYSE:VZ)

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

Microsoft Excel

Short-term Activity Ratios (Summary)

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

Microsoft Excel
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
Inventory turnover 26.68 24.76 29.87 24.48 24.76 18.63 15.71 15.61 18.43 24.37 38.66 40.24 28.51 35.70 41.16 33.09 38.49
Receivables turnover 5.34 5.68 5.82 5.96 5.58 5.73 5.62 5.69 5.60 6.05 6.25 5.76 5.36 5.68 5.72 5.52 5.19
Working capital turnover 141.27 8.59 53.78
Average No. Days
Average inventory processing period 14 15 12 15 15 20 23 23 20 15 9 9 13 10 9 11 9
Add: Average receivable collection period 68 64 63 61 65 64 65 64 65 60 58 63 68 64 64 66 70
Operating cycle 82 79 75 76 80 84 88 87 85 75 67 72 81 74 73 77 79

Based on: 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
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. Verizon Communications Inc. inventory turnover ratio deteriorated from Q2 2023 to Q3 2023 but then slightly improved from Q3 2023 to Q4 2023.
Receivables turnover An activity ratio equal to revenue divided by receivables. Verizon Communications Inc. receivables turnover ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

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. Verizon Communications Inc. number of days of inventory outstanding deteriorated from Q2 2023 to Q3 2023 but then slightly improved from Q3 2023 to Q4 2023.
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover. Verizon Communications Inc. number of days of receivables outstanding deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.
Operating cycle Equal to average inventory processing period plus average receivables collection period. Verizon Communications Inc. operating cycle deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Inventory Turnover

Verizon Communications Inc., inventory turnover calculation (quarterly data)

Microsoft Excel
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 services and wireless equipment 15,182 13,437 12,764 13,504 15,762 14,601 14,420 14,350 14,996 13,528 14,255 13,522 14,822 12,334 11,749 12,296 15,631 13,384 12,721 12,990
Inventories 2,057 2,240 1,896 2,381 2,388 3,133 3,646 3,659 3,055 2,303 1,421 1,303 1,796 1,457 1,289 1,633 1,422 1,538 1,167 1,417
Short-term Activity Ratio
Inventory turnover1 26.68 24.76 29.87 24.48 24.76 18.63 15.71 15.61 18.43 24.37 38.66 40.24 28.51 35.70 41.16 33.09 38.49
Benchmarks
Inventory Turnover, Competitors2
AT&T Inc. 23.02 19.76 21.26 18.07 16.28 14.50 19.34 22.66 23.04 26.85 30.23 24.45 21.63
T-Mobile US Inc. 17.99 18.08 23.32 19.63 19.22 16.91 16.93 13.90 14.26 20.32 20.39 14.77 11.19 12.34 13.29 14.80 19.21

Based on: 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 Q4 2023 Calculation
Inventory turnover = (Cost of services and wireless equipmentQ4 2023 + Cost of services and wireless equipmentQ3 2023 + Cost of services and wireless equipmentQ2 2023 + Cost of services and wireless equipmentQ1 2023) ÷ Inventories
= (15,182 + 13,437 + 12,764 + 13,504) ÷ 2,057 = 26.68

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. Verizon Communications Inc. inventory turnover ratio deteriorated from Q2 2023 to Q3 2023 but then slightly improved from Q3 2023 to Q4 2023.

Receivables Turnover

Verizon Communications Inc., receivables turnover calculation (quarterly data)

Microsoft Excel
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)
Operating revenues 35,130 33,336 32,596 32,912 35,251 34,241 33,789 33,554 34,067 32,915 33,764 32,867 34,692 31,543 30,447 31,610 34,775 32,894 32,071 32,128
Accounts receivable, net 25,085 23,602 23,186 22,856 24,506 23,670 23,909 23,615 23,846 22,195 21,257 22,507 23,917 22,617 22,672 23,797 25,429 24,713 24,926 24,469
Short-term Activity Ratio
Receivables turnover1 5.34 5.68 5.82 5.96 5.58 5.73 5.62 5.69 5.60 6.05 6.25 5.76 5.36 5.68 5.72 5.52 5.19
Benchmarks
Receivables Turnover, Competitors2
AT&T Inc. 11.90 13.59 13.05 11.86 10.53 11.45 12.33 8.98 9.61 10.65 11.16 10.19 8.50 8.92 9.16 9.00 8.00
T-Mobile US Inc. 16.74 17.41 17.11 18.11 17.90 18.52 17.96 20.04 19.10 19.29 17.45 21.33 16.00 13.84 15.31 24.18 23.58

Based on: 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 Q4 2023 Calculation
Receivables turnover = (Operating revenuesQ4 2023 + Operating revenuesQ3 2023 + Operating revenuesQ2 2023 + Operating revenuesQ1 2023) ÷ Accounts receivable, net
= (35,130 + 33,336 + 32,596 + 32,912) ÷ 25,085 = 5.34

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. Verizon Communications Inc. receivables turnover ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Working Capital Turnover

Verizon Communications Inc., working capital turnover calculation (quarterly data)

Microsoft Excel
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 36,814 38,119 37,388 35,722 37,857 39,746 37,499 35,580 36,728 40,277 35,626 39,647 54,594 38,572 37,333 40,705 37,473 34,895 33,308 33,397
Less: Current liabilities 53,223 55,677 51,404 47,768 50,171 53,141 49,224 46,585 47,160 41,358 40,078 38,730 39,660 36,185 38,886 41,057 44,868 39,209 38,214 38,607
Working capital (16,409) (17,558) (14,016) (12,046) (12,314) (13,395) (11,725) (11,005) (10,432) (1,081) (4,452) 917 14,934 2,387 (1,553) (352) (7,395) (4,314) (4,906) (5,210)
 
Operating revenues 35,130 33,336 32,596 32,912 35,251 34,241 33,789 33,554 34,067 32,915 33,764 32,867 34,692 31,543 30,447 31,610 34,775 32,894 32,071 32,128
Short-term Activity Ratio
Working capital turnover1 141.27 8.59 53.78
Benchmarks
Working Capital Turnover, Competitors2
AT&T Inc.
T-Mobile US Inc. 31.35 45.77

Based on: 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 Q4 2023 Calculation
Working capital turnover = (Operating revenuesQ4 2023 + Operating revenuesQ3 2023 + Operating revenuesQ2 2023 + Operating revenuesQ1 2023) ÷ Working capital
= (35,130 + 33,336 + 32,596 + 32,912) ÷ -16,409 =

2 Click competitor name to see calculations.


Average Inventory Processing Period

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

Microsoft Excel
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
Inventory turnover 26.68 24.76 29.87 24.48 24.76 18.63 15.71 15.61 18.43 24.37 38.66 40.24 28.51 35.70 41.16 33.09 38.49
Short-term Activity Ratio (no. days)
Average inventory processing period1 14 15 12 15 15 20 23 23 20 15 9 9 13 10 9 11 9
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
AT&T Inc. 16 18 17 20 22 25 19 16 16 14 12 15 17
T-Mobile US Inc. 20 20 16 19 19 22 22 26 26 18 18 25 33 30 27 25 19

Based on: 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 Q4 2023 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 26.68 = 14

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. Verizon Communications Inc. number of days of inventory outstanding deteriorated from Q2 2023 to Q3 2023 but then slightly improved from Q3 2023 to Q4 2023.

Average Receivable Collection Period

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

Microsoft Excel
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 5.34 5.68 5.82 5.96 5.58 5.73 5.62 5.69 5.60 6.05 6.25 5.76 5.36 5.68 5.72 5.52 5.19
Short-term Activity Ratio (no. days)
Average receivable collection period1 68 64 63 61 65 64 65 64 65 60 58 63 68 64 64 66 70
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
AT&T Inc. 31 27 28 31 35 32 30 41 38 34 33 36 43 41 40 41 46
T-Mobile US Inc. 22 21 21 20 20 20 20 18 19 19 21 17 23 26 24 15 15

Based on: 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 Q4 2023 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 5.34 = 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. Verizon Communications Inc. number of days of receivables outstanding deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Operating Cycle

Verizon Communications Inc., operating cycle calculation (quarterly data)

No. days

Microsoft Excel
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
Average inventory processing period 14 15 12 15 15 20 23 23 20 15 9 9 13 10 9 11 9
Average receivable collection period 68 64 63 61 65 64 65 64 65 60 58 63 68 64 64 66 70
Short-term Activity Ratio
Operating cycle1 82 79 75 76 80 84 88 87 85 75 67 72 81 74 73 77 79
Benchmarks
Operating Cycle, Competitors2
AT&T Inc. 47 45 45 51 57 57 49 57 54 48 45 51 60
T-Mobile US Inc. 42 41 37 39 39 42 42 44 45 37 39 42 56 56 51 40 34

Based on: 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 Q4 2023 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 14 + 68 = 82

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. Verizon Communications Inc. operating cycle deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.