Microsoft Excel LibreOffice Calc

AT&T Inc. (NYSE:T)


Analysis of Long-term (Investment) Activity Ratios

Beginner level


Long-term Activity Ratios (Summary)

AT&T Inc., long-term (investment) activity ratios

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
Net fixed asset turnover 1.39 1.30 1.28 1.31 1.18
Net fixed asset turnover (including operating lease, right-of-use asset) 1.18 1.30 1.28 1.31 1.18
Total asset turnover 0.33 0.32 0.36 0.41 0.36
Equity turnover 0.98 0.93 1.14 1.33 1.20

Based on: 10-K (filing date: 2020-02-20), 10-K (filing date: 2019-02-20), 10-K (filing date: 2018-02-20), 10-K (filing date: 2017-02-17), 10-K (filing date: 2016-02-18).

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.’s net fixed asset turnover ratio improved from 2017 to 2018 and from 2018 to 2019.
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.’s net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. AT&T Inc.’s total asset turnover ratio deteriorated from 2017 to 2018 but then slightly improved from 2018 to 2019.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. AT&T Inc.’s equity turnover ratio deteriorated from 2017 to 2018 but then slightly improved from 2018 to 2019.

Net Fixed Asset Turnover

AT&T Inc., net fixed asset turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
Selected Financial Data (US$ in millions)
Operating revenues 181,193  170,756  160,546  163,786  146,801 
Property, plant and equipment, net 130,128  131,473  125,222  124,899  124,450 
Long-term Activity Ratio
Net fixed asset turnover1 1.39 1.30 1.28 1.31 1.18
Benchmarks
Net Fixed Asset Turnover, Competitors2
Verizon Communications Inc. 1.43 1.47 1.42 1.49 1.58
Net Fixed Asset Turnover, Sector
Fixed Line Telecommunications 1.41 1.37 1.34 1.38 1.34
Net Fixed Asset Turnover, Industry
Telecommunications 1.45 1.41 1.39 1.42 1.36

Based on: 10-K (filing date: 2020-02-20), 10-K (filing date: 2019-02-20), 10-K (filing date: 2018-02-20), 10-K (filing date: 2017-02-17), 10-K (filing date: 2016-02-18).

1 2019 Calculation
Net fixed asset turnover = Operating revenues ÷ Property, plant and equipment, net
= 181,193 ÷ 130,128 = 1.39

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.’s net fixed asset turnover ratio improved from 2017 to 2018 and from 2018 to 2019.

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, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
Selected Financial Data (US$ in millions)
Operating revenues 181,193  170,756  160,546  163,786  146,801 
 
Property, plant and equipment, net 130,128  131,473  125,222  124,899  124,450 
Operating lease right-of-use assets 24,039  —  —  —  — 
Property, plant and equipment, net (including operating lease, right-of-use asset) 154,167  131,473  125,222  124,899  124,450 
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 1.18 1.30 1.28 1.31 1.18
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
Verizon Communications Inc. 1.15 1.47 1.42 1.49 1.58
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Sector
Fixed Line Telecommunications 1.16 1.37 1.34 1.38 1.34
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Industry
Telecommunications 1.18 1.41 1.39 1.42 1.36

Based on: 10-K (filing date: 2020-02-20), 10-K (filing date: 2019-02-20), 10-K (filing date: 2018-02-20), 10-K (filing date: 2017-02-17), 10-K (filing date: 2016-02-18).

1 2019 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = Operating revenues ÷ Property, plant and equipment, net (including operating lease, right-of-use asset)
= 181,193 ÷ 154,167 = 1.18

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.’s net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019.

Total Asset Turnover

AT&T Inc., total asset turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
Selected Financial Data (US$ in millions)
Operating revenues 181,193  170,756  160,546  163,786  146,801 
Total assets 551,669  531,864  444,097  403,821  402,672 
Long-term Activity Ratio
Total asset turnover1 0.33 0.32 0.36 0.41 0.36
Benchmarks
Total Asset Turnover, Competitors2
Verizon Communications Inc. 0.45 0.49 0.49 0.52 0.54
Total Asset Turnover, Sector
Fixed Line Telecommunications 0.37 0.38 0.41 0.45 0.43
Total Asset Turnover, Industry
Telecommunications 0.38 0.40 0.42 0.46 0.44

Based on: 10-K (filing date: 2020-02-20), 10-K (filing date: 2019-02-20), 10-K (filing date: 2018-02-20), 10-K (filing date: 2017-02-17), 10-K (filing date: 2016-02-18).

1 2019 Calculation
Total asset turnover = Operating revenues ÷ Total assets
= 181,193 ÷ 551,669 = 0.33

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.’s total asset turnover ratio deteriorated from 2017 to 2018 but then slightly improved from 2018 to 2019.

Equity Turnover

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

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
Selected Financial Data (US$ in millions)
Operating revenues 181,193  170,756  160,546  163,786  146,801 
Stockholders’ equity attributable to AT&T 184,221  184,089  140,861  123,135  122,671 
Long-term Activity Ratio
Equity turnover1 0.98 0.93 1.14 1.33 1.20
Benchmarks
Equity Turnover, Competitors2
Verizon Communications Inc. 2.15 2.46 2.92 5.59 8.01
Equity Turnover, Sector
Fixed Line Telecommunications 1.27 1.27 1.56 1.99 2.00
Equity Turnover, Industry
Telecommunications 1.30 1.32 1.58 2.00 1.99

Based on: 10-K (filing date: 2020-02-20), 10-K (filing date: 2019-02-20), 10-K (filing date: 2018-02-20), 10-K (filing date: 2017-02-17), 10-K (filing date: 2016-02-18).

1 2019 Calculation
Equity turnover = Operating revenues ÷ Stockholders’ equity attributable to AT&T
= 181,193 ÷ 184,221 = 0.98

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.’s equity turnover ratio deteriorated from 2017 to 2018 but then slightly improved from 2018 to 2019.