Stock Analysis on Net

T-Mobile US Inc. (NASDAQ:TMUS)

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

Microsoft Excel

Long-term Activity Ratios (Summary)

T-Mobile US 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 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
Net fixed asset turnover (including operating lease, right-of-use asset) 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
Total asset turnover 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
Equity turnover 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

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. T-Mobile US 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). T-Mobile US 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. T-Mobile US 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. T-Mobile US Inc. equity turnover ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Net Fixed Asset Turnover

T-Mobile US 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)
Revenues 20,478 19,252 19,196 19,632 20,273 19,477 19,701 20,120 20,785 19,624 19,950 19,759 20,341 19,272 17,671 11,113 11,878 11,061 10,979 11,080
Property and equipment, net, including financing lease right-of-use assets 43,702 44,470 45,169 45,335 45,343 44,653 43,833 43,293 43,125 42,751 42,824 43,448 44,203 41,605 42,089 24,898 24,699 24,953 24,436 23,803
Long-term Activity Ratio
Net fixed asset turnover1 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
Benchmarks
Net Fixed Asset Turnover, Competitors2
AT&T Inc. 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
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 = (RevenuesQ4 2023 + RevenuesQ3 2023 + RevenuesQ2 2023 + RevenuesQ1 2023) ÷ Property and equipment, net, including financing lease right-of-use assets
= (20,478 + 19,252 + 19,196 + 19,632) ÷ 43,702 = 1.80

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

T-Mobile US 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)
Revenues 20,478 19,252 19,196 19,632 20,273 19,477 19,701 20,120 20,785 19,624 19,950 19,759 20,341 19,272 17,671 11,113 11,878 11,061 10,979 11,080
 
Property and equipment, net, including financing lease right-of-use assets 43,702 44,470 45,169 45,335 45,343 44,653 43,833 43,293 43,125 42,751 42,824 43,448 44,203 41,605 42,089 24,898 24,699 24,953 24,436 23,803
Operating lease right-of-use assets 27,135 27,568 27,891 28,146 28,715 29,264 30,110 31,449 26,959 27,446 27,511 27,793 28,021 27,999 17,246 10,956 10,933 10,914 10,439 9,509
Property and equipment, net, including financing lease right-of-use assets (including operating lease, right-of-use asset) 70,837 72,038 73,060 73,481 74,058 73,917 73,943 74,742 70,084 70,197 70,335 71,241 72,224 69,604 59,335 35,854 35,632 35,867 34,875 33,312
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 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
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
AT&T Inc. 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
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) = (RevenuesQ4 2023 + RevenuesQ3 2023 + RevenuesQ2 2023 + RevenuesQ1 2023) ÷ Property and equipment, net, including financing lease right-of-use assets (including operating lease, right-of-use asset)
= (20,478 + 19,252 + 19,196 + 19,632) ÷ 70,837 = 1.11

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

T-Mobile US 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)
Revenues 20,478 19,252 19,196 19,632 20,273 19,477 19,701 20,120 20,785 19,624 19,950 19,759 20,341 19,272 17,671 11,113 11,878 11,061 10,979 11,080
Total assets 207,682 208,579 210,602 210,173 211,338 213,499 209,463 210,653 206,563 202,125 204,124 203,332 200,162 192,443 187,199 87,226 86,921 86,109 84,788 83,073
Long-term Activity Ratio
Total asset turnover1 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
Benchmarks
Total Asset Turnover, Competitors2
AT&T Inc. 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
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 = (RevenuesQ4 2023 + RevenuesQ3 2023 + RevenuesQ2 2023 + RevenuesQ1 2023) ÷ Total assets
= (20,478 + 19,252 + 19,196 + 19,632) ÷ 207,682 = 0.38

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. T-Mobile US Inc. total asset turnover ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Equity Turnover

T-Mobile US 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)
Revenues 20,478 19,252 19,196 19,632 20,273 19,477 19,701 20,120 20,785 19,624 19,950 19,759 20,341 19,272 17,671 11,113 11,878 11,061 10,979 11,080
Stockholders’ equity 64,715 64,698 65,750 66,925 69,656 70,150 70,034 69,976 69,102 68,427 67,470 66,377 65,344 64,487 62,996 28,977 28,789 27,771 26,967 26,181
Long-term Activity Ratio
Equity turnover1 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
Benchmarks
Equity Turnover, Competitors2
AT&T Inc. 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
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 = (RevenuesQ4 2023 + RevenuesQ3 2023 + RevenuesQ2 2023 + RevenuesQ1 2023) ÷ Stockholders’ equity
= (20,478 + 19,252 + 19,196 + 19,632) ÷ 64,715 = 1.21

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. T-Mobile US Inc. equity turnover ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.