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
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
Inventory turnover 19.35 27.18 23.39 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 13.46 12.62 12.77 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 19 13 16 16 18 17 20 22 25 19 16 16 14 12 15 17
Add: Average receivable collection period 27 29 29 31 27 28 31 35 32 30 41 38 34 33 36 43 41 40 41 46
Operating cycle 46 42 45 47 45 45 51 57 57 49 57 54 48 45 51 60

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
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. AT&T Inc. inventory turnover ratio improved from Q1 2024 to Q2 2024 but then deteriorated significantly from Q2 2024 to Q3 2024.
Receivables turnover An activity ratio equal to revenue divided by receivables. AT&T Inc. receivables turnover ratio deteriorated from Q1 2024 to Q2 2024 but then improved from Q2 2024 to Q3 2024 exceeding Q1 2024 level.

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 improved from Q1 2024 to Q2 2024 but then deteriorated significantly from Q2 2024 to Q3 2024.
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. AT&T Inc. operating cycle improved from Q1 2024 to Q2 2024 but then deteriorated significantly from Q2 2024 to Q3 2024.

Inventory Turnover

AT&T Inc., inventory 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 11,630 11,442 11,954 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,529 1,816 2,127 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 19.35 27.18 23.39 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. 16.36 22.27 19.48 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. 21.31 29.31 26.13 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-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
Inventory turnover = (Cost of revenuesQ3 2024 + Cost of revenuesQ2 2024 + Cost of revenuesQ1 2024 + Cost of revenuesQ4 2023) ÷ Inventories
= (11,630 + 11,442 + 11,954 + 13,911) ÷ 2,529 = 19.35

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 improved from Q1 2024 to Q2 2024 but then deteriorated significantly from Q2 2024 to Q3 2024.

Receivables Turnover

AT&T 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)
Operating revenues 30,213 29,797 30,028 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 9,068 9,686 9,577 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 13.46 12.62 12.77 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. 18.67 17.33 18.46 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.17 5.24 5.29 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-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 = (Operating revenuesQ3 2024 + Operating revenuesQ2 2024 + Operating revenuesQ1 2024 + Operating revenuesQ4 2023) ÷ Accounts receivable, net of related allowances for credit loss
= (30,213 + 29,797 + 30,028 + 32,022) ÷ 9,068 = 13.46

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

Working Capital Turnover

AT&T 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 29,799 29,868 30,445 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 40,658 42,429 44,834 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 (10,859) (12,561) (14,389) (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 30,213 29,797 30,028 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. 50.77 31.35 45.77
Verizon Communications Inc. 141.27 8.59 53.78

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 = (Operating revenuesQ3 2024 + Operating revenuesQ2 2024 + Operating revenuesQ1 2024 + Operating revenuesQ4 2023) ÷ Working capital
= (30,213 + 29,797 + 30,028 + 32,022) ÷ -10,859 =

2 Click competitor name to see calculations.


Average Inventory Processing Period

AT&T Inc., average inventory processing 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
Inventory turnover 19.35 27.18 23.39 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 19 13 16 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. 22 16 19 20 20 16 19 19 22 22 26 26 18 18 25 33 30 27 25 19
Verizon Communications Inc. 17 12 14 14 15 12 15 15 20 23 23 20 15 9 9 13 10 9 11 9

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 inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 19.35 = 19

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 improved from Q1 2024 to Q2 2024 but then deteriorated significantly from Q2 2024 to Q3 2024.

Average Receivable Collection Period

AT&T 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 13.46 12.62 12.77 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 27 29 29 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. 20 21 20 22 21 21 20 20 20 20 18 19 19 21 17 23 26 24 15 15
Verizon Communications Inc. 71 70 69 68 64 63 61 65 64 65 64 65 60 58 63 68 64 64 66 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
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 13.46 = 27

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

AT&T Inc., operating cycle calculation (quarterly data)

No. days

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
Average inventory processing period 19 13 16 16 18 17 20 22 25 19 16 16 14 12 15 17
Average receivable collection period 27 29 29 31 27 28 31 35 32 30 41 38 34 33 36 43 41 40 41 46
Short-term Activity Ratio
Operating cycle1 46 42 45 47 45 45 51 57 57 49 57 54 48 45 51 60
Benchmarks
Operating Cycle, Competitors2
T-Mobile US Inc. 42 37 39 42 41 37 39 39 42 42 44 45 37 39 42 56 56 51 40 34
Verizon Communications Inc. 88 82 83 82 79 75 76 80 84 88 87 85 75 67 72 81 74 73 77 79

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
Operating cycle = Average inventory processing period + Average receivable collection period
= 19 + 27 = 46

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. AT&T Inc. operating cycle improved from Q1 2024 to Q2 2024 but then deteriorated significantly from Q2 2024 to Q3 2024.