Stock Analysis on Net

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

Microsoft Excel

Short-term Activity Ratios (Summary)

AT&T 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 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
Receivables turnover 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
Working capital turnover
Average No. Days
Average inventory processing period 16 18 17 20 22 25 19 16 16 14 12 15 17
Add: Average receivable collection period 31 27 28 31 35 32 30 41 38 34 33 36 43 41 40 41 46
Operating cycle 47 45 45 51 57 57 49 57 54 48 45 51 60

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. AT&T Inc. inventory turnover ratio deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 exceeding Q2 2023 level.
Receivables turnover An activity ratio equal to revenue divided by receivables. AT&T Inc. receivables turnover ratio improved from Q2 2023 to Q3 2023 but then deteriorated significantly 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. AT&T Inc. number of days of inventory outstanding deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 exceeding Q2 2023 level.
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover. AT&T Inc. number of days of receivables outstanding improved from Q2 2023 to Q3 2023 but then deteriorated significantly from Q3 2023 to Q4 2023.
Operating cycle Equal to average inventory processing period plus average receivables collection period.

Inventory Turnover

AT&T 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 revenues 13,911 12,054 11,827 12,331 13,571 12,201 12,341 12,735 19,795 17,826 21,099 21,087 22,910 19,839 17,983 19,188 22,736 20,154 20,512 20,739
Inventories 2,177 2,520 2,348 2,791 3,123 3,935 3,241 3,153 3,464 3,088 2,810 3,347 3,695
Short-term Activity Ratio
Inventory turnover1 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
Benchmarks
Inventory Turnover, Competitors2
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
Verizon Communications Inc. 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

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 revenuesQ4 2023 + Cost of revenuesQ3 2023 + Cost of revenuesQ2 2023 + Cost of revenuesQ1 2023) ÷ Inventories
= (13,911 + 12,054 + 11,827 + 12,331) ÷ 2,177 = 23.02

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. AT&T Inc. inventory turnover ratio deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 exceeding Q2 2023 level.

Receivables Turnover

AT&T 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 32,022 30,350 29,917 30,139 31,343 30,043 29,643 29,712 40,958 39,922 44,045 43,939 45,691 42,340 40,950 42,779 46,821 44,588 44,957 44,827
Accounts receivable, net of related allowances for credit loss 10,289 8,962 9,304 10,214 11,466 11,384 11,377 17,218 17,571 16,304 15,771 16,971 20,215 19,379 19,127 19,908 22,636 22,921 22,381 23,863
Short-term Activity Ratio
Receivables turnover1 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
Benchmarks
Receivables Turnover, Competitors2
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
Verizon Communications Inc. 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

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 of related allowances for credit loss
= (32,022 + 30,350 + 29,917 + 30,139) ÷ 10,289 = 11.90

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. AT&T Inc. receivables turnover ratio improved from Q2 2023 to Q3 2023 but then deteriorated significantly from Q3 2023 to Q4 2023.

Working Capital Turnover

AT&T 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,458 35,620 36,672 29,903 33,108 32,295 34,485 76,856 59,997 57,230 62,869 62,754 52,008 49,971 56,555 52,704 54,761 50,695 47,218 46,472
Less: Current liabilities 51,127 51,684 54,159 58,150 56,173 52,257 49,189 82,494 85,588 81,601 82,126 76,608 63,438 59,565 69,469 69,704 68,911 68,126 66,376 64,652
Working capital (14,669) (16,064) (17,487) (28,247) (23,065) (19,962) (14,704) (5,638) (25,591) (24,371) (19,257) (13,854) (11,430) (9,594) (12,914) (17,000) (14,150) (17,431) (19,158) (18,180)
 
Operating revenues 32,022 30,350 29,917 30,139 31,343 30,043 29,643 29,712 40,958 39,922 44,045 43,939 45,691 42,340 40,950 42,779 46,821 44,588 44,957 44,827
Short-term Activity Ratio
Working capital turnover1
Benchmarks
Working Capital Turnover, Competitors2
T-Mobile US Inc. 31.35 45.77
Verizon Communications Inc. 141.27 8.59 53.78

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
= (32,022 + 30,350 + 29,917 + 30,139) ÷ -14,669 =

2 Click competitor name to see calculations.


Average Inventory Processing Period

AT&T 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 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
Short-term Activity Ratio (no. days)
Average inventory processing period1 16 18 17 20 22 25 19 16 16 14 12 15 17
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
T-Mobile US Inc. 20 20 16 19 19 22 22 26 26 18 18 25 33 30 27 25 19
Verizon Communications Inc. 14 15 12 15 15 20 23 23 20 15 9 9 13 10 9 11 9

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 ÷ 23.02 = 16

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. AT&T Inc. number of days of inventory outstanding deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 exceeding Q2 2023 level.

Average Receivable Collection Period

AT&T 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 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
Short-term Activity Ratio (no. days)
Average receivable collection period1 31 27 28 31 35 32 30 41 38 34 33 36 43 41 40 41 46
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
T-Mobile US Inc. 22 21 21 20 20 20 20 18 19 19 21 17 23 26 24 15 15
Verizon Communications Inc. 68 64 63 61 65 64 65 64 65 60 58 63 68 64 64 66 70

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 ÷ 11.90 = 31

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. AT&T Inc. number of days of receivables outstanding improved from Q2 2023 to Q3 2023 but then deteriorated significantly from Q3 2023 to Q4 2023.

Operating Cycle

AT&T 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 16 18 17 20 22 25 19 16 16 14 12 15 17
Average receivable collection period 31 27 28 31 35 32 30 41 38 34 33 36 43 41 40 41 46
Short-term Activity Ratio
Operating cycle1 47 45 45 51 57 57 49 57 54 48 45 51 60
Benchmarks
Operating Cycle, Competitors2
T-Mobile US Inc. 42 41 37 39 39 42 42 44 45 37 39 42 56 56 51 40 34
Verizon Communications Inc. 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).

1 Q4 2023 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 16 + 31 = 47

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.