Stock Analysis on Net

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Microsoft Excel

Long-term Activity Ratios (Summary)

AT&T Inc., long-term (investment) 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
Net fixed asset turnover 0.95 0.95 0.94 0.94 0.95 1.03 1.12 1.22 1.34 1.40 1.42 1.39 1.35 1.34 1.36 1.39 1.39
Net fixed asset turnover (including operating lease, right-of-use asset) 0.82 0.81 0.81 0.81 0.81 0.88 0.95 1.02 1.13 1.17 1.19 1.16 1.13 1.13 1.14 1.17 1.18
Total asset turnover 0.30 0.30 0.30 0.30 0.30 0.31 0.33 0.27 0.31 0.32 0.32 0.32 0.33 0.32 0.32 0.33 0.33
Equity turnover 1.19 1.17 1.19 1.22 1.24 1.06 1.19 0.91 1.02 1.06 1.08 1.04 1.06 0.98 1.00 1.01 0.98

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).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. AT&T Inc. net fixed asset turnover ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). AT&T Inc. net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. AT&T Inc. total asset turnover ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. AT&T Inc. equity turnover ratio deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 not reaching Q2 2023 level.

Net Fixed Asset Turnover

AT&T Inc., net fixed asset 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
Property, plant and equipment, net 128,489 128,496 128,783 128,458 127,445 127,045 125,135 127,159 125,904 124,419 123,591 124,607 127,315 128,722 128,945 128,921 130,128 131,316 132,074 132,051
Long-term Activity Ratio
Net fixed asset turnover1 0.95 0.95 0.94 0.94 0.95 1.03 1.12 1.22 1.34 1.40 1.42 1.39 1.35 1.34 1.36 1.39 1.39
Benchmarks
Net Fixed Asset Turnover, Competitors2
T-Mobile US Inc. 1.80 1.76 1.74 1.74 1.75 1.79 1.83 1.86 1.86 1.86 1.85 1.77 1.55 1.44 1.23 1.81 1.82
Verizon Communications Inc. 1.24 1.25 1.26 1.27 1.27 1.32 1.33 1.35 1.34 1.40 1.41 1.37 1.35 1.38 1.40 1.42 1.43

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
Net fixed asset turnover = (Operating revenuesQ4 2023 + Operating revenuesQ3 2023 + Operating revenuesQ2 2023 + Operating revenuesQ1 2023) ÷ Property, plant and equipment, net
= (32,022 + 30,350 + 29,917 + 30,139) ÷ 128,489 = 0.95

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. AT&T Inc. net fixed asset turnover ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)

AT&T Inc., net fixed asset turnover (including operating lease, right-of-use asset) 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
 
Property, plant and equipment, net 128,489 128,496 128,783 128,458 127,445 127,045 125,135 127,159 125,904 124,419 123,591 124,607 127,315 128,722 128,945 128,921 130,128 131,316 132,074 132,051
Operating lease right-of-use assets 20,905 21,001 21,581 21,619 21,814 21,782 21,808 23,941 24,180 24,341 24,390 24,415 24,714 24,546 24,692 24,008 24,039 24,477 22,650 20,235
Property, plant and equipment, net (including operating lease, right-of-use asset) 149,394 149,497 150,364 150,077 149,259 148,827 146,943 151,100 150,084 148,760 147,981 149,022 152,029 153,268 153,637 152,929 154,167 155,793 154,724 152,286
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 0.82 0.81 0.81 0.81 0.81 0.88 0.95 1.02 1.13 1.17 1.19 1.16 1.13 1.13 1.14 1.17 1.18
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
T-Mobile US Inc. 1.11 1.09 1.08 1.08 1.07 1.08 1.09 1.08 1.14 1.14 1.13 1.08 0.95 0.86 0.87 1.26 1.26
Verizon Communications Inc. 1.01 1.01 1.02 1.02 1.02 1.05 1.05 1.05 1.05 1.08 1.09 1.11 1.09 1.11 1.13 1.15 1.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
Net fixed asset turnover (including operating lease, right-of-use asset) = (Operating revenuesQ4 2023 + Operating revenuesQ3 2023 + Operating revenuesQ2 2023 + Operating revenuesQ1 2023) ÷ Property, plant and equipment, net (including operating lease, right-of-use asset)
= (32,022 + 30,350 + 29,917 + 30,139) ÷ 149,394 = 0.82

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). AT&T Inc. net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Total Asset Turnover

AT&T Inc., total asset 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
Total assets 407,060 406,698 408,453 400,873 402,853 426,463 426,433 577,195 551,622 547,107 544,710 546,985 525,761 538,553 547,898 545,354 551,669 548,796 546,914 548,384
Long-term Activity Ratio
Total asset turnover1 0.30 0.30 0.30 0.30 0.30 0.31 0.33 0.27 0.31 0.32 0.32 0.32 0.33 0.32 0.32 0.33 0.33
Benchmarks
Total Asset Turnover, Competitors2
T-Mobile US Inc. 0.38 0.38 0.37 0.38 0.38 0.38 0.38 0.38 0.39 0.39 0.39 0.38 0.34 0.31 0.28 0.52 0.52
Verizon Communications Inc. 0.35 0.35 0.36 0.36 0.36 0.36 0.36 0.37 0.36 0.38 0.38 0.37 0.41 0.43 0.44 0.45 0.45

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
Total asset turnover = (Operating revenuesQ4 2023 + Operating revenuesQ3 2023 + Operating revenuesQ2 2023 + Operating revenuesQ1 2023) ÷ Total assets
= (32,022 + 30,350 + 29,917 + 30,139) ÷ 407,060 = 0.30

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. AT&T Inc. total asset turnover ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Equity Turnover

AT&T Inc., equity 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
Stockholders’ equity attributable to AT&T 103,297 103,703 101,903 99,396 97,500 122,406 117,746 169,036 166,332 163,771 162,296 165,488 161,673 175,553 175,896 177,779 184,221 183,049 184,257 185,112
Long-term Activity Ratio
Equity turnover1 1.19 1.17 1.19 1.22 1.24 1.06 1.19 0.91 1.02 1.06 1.08 1.04 1.06 0.98 1.00 1.01 0.98
Benchmarks
Equity Turnover, Competitors2
T-Mobile US Inc. 1.21 1.21 1.20 1.18 1.14 1.14 1.15 1.15 1.16 1.16 1.18 1.16 1.05 0.93 0.82 1.55 1.56
Verizon Communications Inc. 1.45 1.37 1.42 1.47 1.50 1.55 1.56 1.60 1.63 1.74 1.80 1.82 1.89 1.97 2.07 2.18 2.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
Equity turnover = (Operating revenuesQ4 2023 + Operating revenuesQ3 2023 + Operating revenuesQ2 2023 + Operating revenuesQ1 2023) ÷ Stockholders’ equity attributable to AT&T
= (32,022 + 30,350 + 29,917 + 30,139) ÷ 103,297 = 1.19

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. AT&T Inc. equity turnover ratio deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 not reaching Q2 2023 level.