Stock Analysis on Net
Stock Analysis on Net
Microsoft Excel LibreOffice Calc

T-Mobile US Inc. (NASDAQ:TMUS)

Analysis of Long-term (Investment) Activity Ratios

Beginner level

Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.


Long-term Activity Ratios (Summary)

T-Mobile US 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.82 1.85 1.83 1.78 1.60
Net fixed asset turnover (including operating lease, right-of-use asset) 1.26 1.85 1.83 1.78 1.60
Total asset turnover 0.52 0.60 0.58 0.57 0.51
Equity turnover 1.56 1.75 1.80 2.04 1.94

Based on: 10-K (filing date: 2020-02-06), 10-K (filing date: 2019-02-07), 10-K (filing date: 2018-02-08), 10-K (filing date: 2017-02-14), 10-K (filing date: 2016-02-17).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. T-Mobile US Inc.’s net fixed asset turnover ratio improved from 2017 to 2018 but then deteriorated significantly 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). T-Mobile US 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. T-Mobile US Inc.’s total asset turnover ratio improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. T-Mobile US Inc.’s equity turnover ratio deteriorated from 2017 to 2018 and from 2018 to 2019.

Net Fixed Asset Turnover

T-Mobile US 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)
Revenues 44,998  43,310  40,604  37,242  32,053 
Property and equipment, net, including financing lease right-of-use assets 24,699  23,359  22,196  20,943  20,000 
Long-term Activity Ratio
Net fixed asset turnover1 1.82 1.85 1.83 1.78 1.60
Benchmarks
Net Fixed Asset Turnover, Industry
Telecommunications 1.45 1.41 1.39 1.42 1.36

Based on: 10-K (filing date: 2020-02-06), 10-K (filing date: 2019-02-07), 10-K (filing date: 2018-02-08), 10-K (filing date: 2017-02-14), 10-K (filing date: 2016-02-17).

1 2019 Calculation
Net fixed asset turnover = Revenues ÷ Property and equipment, net, including financing lease right-of-use assets
= 44,998 ÷ 24,699 = 1.82

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. T-Mobile US Inc.’s net fixed asset turnover ratio improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019.

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

T-Mobile US 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)
Revenues 44,998  43,310  40,604  37,242  32,053 
 
Property and equipment, net, including financing lease right-of-use assets 24,699  23,359  22,196  20,943  20,000 
Operating lease right-of-use assets 10,933  —  —  —  — 
Property and equipment, net, including financing lease right-of-use assets (including operating lease, right-of-use asset) 35,632  23,359  22,196  20,943  20,000 
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 1.26 1.85 1.83 1.78 1.60
Benchmarks
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-06), 10-K (filing date: 2019-02-07), 10-K (filing date: 2018-02-08), 10-K (filing date: 2017-02-14), 10-K (filing date: 2016-02-17).

1 2019 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = Revenues ÷ Property and equipment, net, including financing lease right-of-use assets (including operating lease, right-of-use asset)
= 44,998 ÷ 35,632 = 1.26

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). T-Mobile US 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

T-Mobile US 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)
Revenues 44,998  43,310  40,604  37,242  32,053 
Total assets 86,921  72,468  70,563  65,891  62,436 
Long-term Activity Ratio
Total asset turnover1 0.52 0.60 0.58 0.57 0.51
Benchmarks
Total Asset Turnover, Industry
Telecommunications 0.38 0.40 0.42 0.46 0.44

Based on: 10-K (filing date: 2020-02-06), 10-K (filing date: 2019-02-07), 10-K (filing date: 2018-02-08), 10-K (filing date: 2017-02-14), 10-K (filing date: 2016-02-17).

1 2019 Calculation
Total asset turnover = Revenues ÷ Total assets
= 44,998 ÷ 86,921 = 0.52

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. T-Mobile US Inc.’s total asset turnover ratio improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019.

Equity Turnover

T-Mobile US 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)
Revenues 44,998  43,310  40,604  37,242  32,053 
Stockholders’ equity 28,789  24,718  22,559  18,236  16,557 
Long-term Activity Ratio
Equity turnover1 1.56 1.75 1.80 2.04 1.94
Benchmarks
Equity Turnover, Industry
Telecommunications 1.30 1.32 1.58 2.00 1.99

Based on: 10-K (filing date: 2020-02-06), 10-K (filing date: 2019-02-07), 10-K (filing date: 2018-02-08), 10-K (filing date: 2017-02-14), 10-K (filing date: 2016-02-17).

1 2019 Calculation
Equity turnover = Revenues ÷ Stockholders’ equity
= 44,998 ÷ 28,789 = 1.56

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. T-Mobile US Inc.’s equity turnover ratio deteriorated from 2017 to 2018 and from 2018 to 2019.