Stock Analysis on Net

AT&T Inc. (NYSE:T)

Analysis of Short-term (Operating) Activity Ratios

Microsoft Excel

Short-term Activity Ratios (Summary)

AT&T Inc., short-term (operating) activity ratios

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Turnover Ratios
Inventory turnover 21.68 23.02 16.28 23.04 21.63
Receivables turnover 12.69 11.90 10.53 9.61 8.50
Payables turnover 1.79 1.84 1.63 2.59 2.51
Working capital turnover
Average No. Days
Average inventory processing period 17 16 22 16 17
Add: Average receivable collection period 29 31 35 38 43
Operating cycle 46 47 57 54 60
Less: Average payables payment period 203 199 223 141 145
Cash conversion cycle -157 -152 -166 -87 -85

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-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 2022 to 2023 but then slightly deteriorated from 2023 to 2024.
Receivables turnover An activity ratio equal to revenue divided by receivables. AT&T Inc. receivables turnover ratio improved from 2022 to 2023 and from 2023 to 2024.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. AT&T Inc. payables turnover ratio increased from 2022 to 2023 but then slightly decreased from 2023 to 2024.

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 2022 to 2023 but then slightly deteriorated from 2023 to 2024.
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 2022 to 2023 and from 2023 to 2024.
Operating cycle Equal to average inventory processing period plus average receivables collection period. AT&T Inc. operating cycle improved from 2022 to 2023 and from 2023 to 2024.
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. AT&T Inc. number of days of payables outstanding decreased from 2022 to 2023 but then slightly increased from 2023 to 2024.
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. AT&T Inc. cash conversion cycle deteriorated from 2022 to 2023 but then slightly improved from 2023 to 2024.

Inventory Turnover

AT&T Inc., inventory turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in millions)
Cost of revenues 49,221 50,123 50,848 79,807 79,920
Inventories 2,270 2,177 3,123 3,464 3,695
Short-term Activity Ratio
Inventory turnover1 21.68 23.02 16.28 23.04 21.63
Benchmarks
Inventory Turnover, Competitors2
T-Mobile US Inc. 18.45 17.99 19.22 14.26 11.19
Verizon Communications Inc. 24.08 26.68 24.76 18.43 28.51
Inventory Turnover, Sector
Telecommunication Services 22.87 19.77 19.01 19.88
Inventory Turnover, Industry
Communication Services 52.08 44.81 39.09 36.78

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 2024 Calculation
Inventory turnover = Cost of revenues ÷ Inventories
= 49,221 ÷ 2,270 = 21.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. AT&T Inc. inventory turnover ratio improved from 2022 to 2023 but then slightly deteriorated from 2023 to 2024.

Receivables Turnover

AT&T Inc., receivables turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in millions)
Operating revenues 122,336 122,428 120,741 168,864 171,760
Accounts receivable, net of related allowance for credit loss 9,638 10,289 11,466 17,571 20,215
Short-term Activity Ratio
Receivables turnover1 12.69 11.90 10.53 9.61 8.50
Benchmarks
Receivables Turnover, Competitors2
T-Mobile US Inc. 19.04 16.74 17.90 19.10 16.00
Verizon Communications Inc. 5.16 5.34 5.58 5.60 5.36
Receivables Turnover, Sector
Telecommunication Services 8.36 8.34 8.39 7.61
Receivables Turnover, Industry
Communication Services 7.76 8.07 7.77 7.20

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 2024 Calculation
Receivables turnover = Operating revenues ÷ Accounts receivable, net of related allowance for credit loss
= 122,336 ÷ 9,638 = 12.69

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 2022 to 2023 and from 2023 to 2024.

Payables Turnover

AT&T Inc., payables turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in millions)
Cost of revenues 49,221 50,123 50,848 79,807 79,920
Accounts payable 27,433 27,309 31,101 30,756 31,836
Short-term Activity Ratio
Payables turnover1 1.79 1.84 1.63 2.59 2.51
Benchmarks
Payables Turnover, Competitors2
T-Mobile US Inc. 6.99 5.42 5.02 5.63 5.08
Verizon Communications Inc. 5.19 5.48 6.76 7.00 7.68
Payables Turnover, Sector
Telecommunication Services 3.15 3.11 3.81 3.62
Payables Turnover, Industry
Communication Services 4.91 4.73 4.79 4.63

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 2024 Calculation
Payables turnover = Cost of revenues ÷ Accounts payable
= 49,221 ÷ 27,433 = 1.79

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. AT&T Inc. payables turnover ratio increased from 2022 to 2023 but then slightly decreased from 2023 to 2024.

Working Capital Turnover

AT&T Inc., working capital turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in millions)
Current assets 31,168 36,458 33,108 59,997 52,008
Less: Current liabilities 46,872 51,127 56,173 85,588 63,438
Working capital (15,704) (14,669) (23,065) (25,591) (11,430)
 
Operating revenues 122,336 122,428 120,741 168,864 171,760
Short-term Activity Ratio
Working capital turnover1
Benchmarks
Working Capital Turnover, Competitors2
T-Mobile US Inc. 31.35
Verizon Communications Inc. 8.59
Working Capital Turnover, Sector
Telecommunication Services 64.80
Working Capital Turnover, Industry
Communication Services 10.57 11.82 7.57 4.32

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 2024 Calculation
Working capital turnover = Operating revenues ÷ Working capital
= 122,336 ÷ -15,704 =

2 Click competitor name to see calculations.


Average Inventory Processing Period

AT&T Inc., average inventory processing period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data
Inventory turnover 21.68 23.02 16.28 23.04 21.63
Short-term Activity Ratio (no. days)
Average inventory processing period1 17 16 22 16 17
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
T-Mobile US Inc. 20 20 19 26 33
Verizon Communications Inc. 15 14 15 20 13
Average Inventory Processing Period, Sector
Telecommunication Services 16 18 19 18
Average Inventory Processing Period, Industry
Communication Services 7 8 9 10

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 2024 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 21.68 = 17

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 2022 to 2023 but then slightly deteriorated from 2023 to 2024.

Average Receivable Collection Period

AT&T Inc., average receivable collection period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data
Receivables turnover 12.69 11.90 10.53 9.61 8.50
Short-term Activity Ratio (no. days)
Average receivable collection period1 29 31 35 38 43
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
T-Mobile US Inc. 19 22 20 19 23
Verizon Communications Inc. 71 68 65 65 68
Average Receivable Collection Period, Sector
Telecommunication Services 44 44 44 48
Average Receivable Collection Period, Industry
Communication Services 47 45 47 51

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 2024 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 12.69 = 29

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 2022 to 2023 and from 2023 to 2024.

Operating Cycle

AT&T Inc., operating cycle calculation, comparison to benchmarks

No. days

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data
Average inventory processing period 17 16 22 16 17
Average receivable collection period 29 31 35 38 43
Short-term Activity Ratio
Operating cycle1 46 47 57 54 60
Benchmarks
Operating Cycle, Competitors2
T-Mobile US Inc. 39 42 39 45 56
Verizon Communications Inc. 86 82 80 85 81
Operating Cycle, Sector
Telecommunication Services 60 62 63 66
Operating Cycle, Industry
Communication Services 54 53 56 61

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 2024 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 17 + 29 = 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 2022 to 2023 and from 2023 to 2024.

Average Payables Payment Period

AT&T Inc., average payables payment period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data
Payables turnover 1.79 1.84 1.63 2.59 2.51
Short-term Activity Ratio (no. days)
Average payables payment period1 203 199 223 141 145
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
T-Mobile US Inc. 52 67 73 65 72
Verizon Communications Inc. 70 67 54 52 48
Average Payables Payment Period, Sector
Telecommunication Services 116 118 96 101
Average Payables Payment Period, Industry
Communication Services 74 77 76 79

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 2024 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 1.79 = 203

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. AT&T Inc. number of days of payables outstanding decreased from 2022 to 2023 but then slightly increased from 2023 to 2024.

Cash Conversion Cycle

AT&T Inc., cash conversion cycle calculation, comparison to benchmarks

No. days

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data
Average inventory processing period 17 16 22 16 17
Average receivable collection period 29 31 35 38 43
Average payables payment period 203 199 223 141 145
Short-term Activity Ratio
Cash conversion cycle1 -157 -152 -166 -87 -85
Benchmarks
Cash Conversion Cycle, Competitors2
T-Mobile US Inc. -13 -25 -34 -20 -16
Verizon Communications Inc. 16 15 26 33 33
Cash Conversion Cycle, Sector
Telecommunication Services -56 -56 -33 -35
Cash Conversion Cycle, Industry
Communication Services -20 -24 -20 -18

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 2024 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 17 + 29203 = -157

2 Click competitor name to see calculations.

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. AT&T Inc. cash conversion cycle deteriorated from 2022 to 2023 but then slightly improved from 2023 to 2024.