Stock Analysis on Net

T-Mobile US Inc. (NASDAQ:TMUS)

Analysis of Short-term (Operating) Activity Ratios
Quarterly Data

Microsoft Excel

Short-term Activity Ratios (Summary)

T-Mobile US Inc., short-term (operating) activity ratios (quarterly data)

Microsoft Excel
Mar 31, 2024 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
Turnover Ratios
Inventory turnover 19.48 17.99 18.08 23.32 19.63 19.22 16.91 16.93 13.90 14.26 20.32 20.39 14.77 11.19 12.34 13.29 14.80 19.21
Receivables turnover 18.46 16.74 17.41 17.11 18.11 17.90 18.52 17.96 20.04 19.10 19.29 17.45 21.33 16.00 13.84 15.31 24.18 23.58
Working capital turnover 31.35 45.77
Average No. Days
Average inventory processing period 19 20 20 16 19 19 22 22 26 26 18 18 25 33 30 27 25 19
Add: Average receivable collection period 20 22 21 21 20 20 20 20 18 19 19 21 17 23 26 24 15 15
Operating cycle 39 42 41 37 39 39 42 42 44 45 37 39 42 56 56 51 40 34

Based on: 10-Q (reporting date: 2024-03-31), 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).

Short-term activity ratio Description The company
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. T-Mobile US Inc. inventory turnover ratio deteriorated from Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 exceeding Q3 2023 level.
Receivables turnover An activity ratio equal to revenue divided by receivables. T-Mobile US Inc. receivables turnover ratio deteriorated from Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 exceeding Q3 2023 level.

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.
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover. T-Mobile US Inc. number of days of receivables outstanding deteriorated from Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 exceeding Q3 2023 level.
Operating cycle Equal to average inventory processing period plus average receivables collection period. T-Mobile US Inc. operating cycle deteriorated from Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 exceeding Q3 2023 level.

Inventory Turnover

T-Mobile US Inc., inventory turnover calculation (quarterly data)

Microsoft Excel
Mar 31, 2024 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)
Cost of revenues 7,087 8,400 7,135 7,004 7,649 8,671 8,694 9,168 9,673 10,452 8,683 8,944 8,526 9,652 7,681 6,765 4,168 5,212 4,437 4,310 4,562
Inventory 1,521 1,678 1,685 1,373 1,741 1,884 2,247 2,243 2,715 2,567 1,762 1,707 2,209 2,527 1,931 1,549 1,225 964 801 998 1,261
Short-term Activity Ratio
Inventory turnover1 19.48 17.99 18.08 23.32 19.63 19.22 16.91 16.93 13.90 14.26 20.32 20.39 14.77 11.19 12.34 13.29 14.80 19.21
Benchmarks
Inventory Turnover, Competitors2
AT&T Inc. 23.39 23.02 19.76 21.26 18.07 16.28 14.50 19.34 22.66 23.04 26.85 30.23 24.45 21.63
Verizon Communications Inc. 26.13 26.68 24.76 29.87 24.48 24.76 18.63 15.71 15.61 18.43 24.37 38.66 40.24 28.51 35.70 41.16 33.09 38.49

Based on: 10-Q (reporting date: 2024-03-31), 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 Q1 2024 Calculation
Inventory turnover = (Cost of revenuesQ1 2024 + Cost of revenuesQ4 2023 + Cost of revenuesQ3 2023 + Cost of revenuesQ2 2023) ÷ Inventory
= (7,087 + 8,400 + 7,135 + 7,004) ÷ 1,521 = 19.48

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. T-Mobile US Inc. inventory turnover ratio deteriorated from Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 exceeding Q3 2023 level.

Receivables Turnover

T-Mobile US Inc., receivables turnover calculation (quarterly data)

Microsoft Excel
Mar 31, 2024 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 19,594 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
Accounts receivable, net of allowance for credit losses 4,253 4,692 4,500 4,592 4,366 4,445 4,324 4,466 4,016 4,194 4,130 4,546 3,612 4,276 4,332 3,379 1,862 1,908 1,842 1,835 1,765
Short-term Activity Ratio
Receivables turnover1 18.46 16.74 17.41 17.11 18.11 17.90 18.52 17.96 20.04 19.10 19.29 17.45 21.33 16.00 13.84 15.31 24.18 23.58
Benchmarks
Receivables Turnover, Competitors2
AT&T Inc. 12.77 11.90 13.59 13.05 11.86 10.53 11.45 12.33 8.98 9.61 10.65 11.16 10.19 8.50 8.92 9.16 9.00 8.00
Verizon Communications Inc. 5.29 5.34 5.68 5.82 5.96 5.58 5.73 5.62 5.69 5.60 6.05 6.25 5.76 5.36 5.68 5.72 5.52 5.19

Based on: 10-Q (reporting date: 2024-03-31), 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 Q1 2024 Calculation
Receivables turnover = (RevenuesQ1 2024 + RevenuesQ4 2023 + RevenuesQ3 2023 + RevenuesQ2 2023) ÷ Accounts receivable, net of allowance for credit losses
= (19,594 + 20,478 + 19,252 + 19,196) ÷ 4,253 = 18.46

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. T-Mobile US Inc. receivables turnover ratio deteriorated from Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 exceeding Q3 2023 level.

Working Capital Turnover

T-Mobile US Inc., working capital turnover calculation (quarterly data)

Microsoft Excel
Mar 31, 2024 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)
Current assets 19,295 19,015 18,669 20,237 18,876 19,067 21,427 17,476 17,455 20,891 16,772 20,570 18,779 23,885 19,465 24,321 9,487 9,305 8,458 8,114 8,745
Less: Current liabilities 20,563 20,928 21,711 24,569 23,846 24,742 26,362 20,622 21,423 23,499 19,247 21,837 19,495 21,703 19,840 23,191 14,756 12,506 12,869 13,173 13,327
Working capital (1,268) (1,913) (3,042) (4,332) (4,970) (5,675) (4,935) (3,146) (3,968) (2,608) (2,475) (1,267) (716) 2,182 (375) 1,130 (5,269) (3,201) (4,411) (5,059) (4,582)
 
Revenues 19,594 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
Short-term Activity Ratio
Working capital turnover1 31.35 45.77
Benchmarks
Working Capital Turnover, Competitors2
AT&T Inc.
Verizon Communications Inc. 141.27 8.59 53.78

Based on: 10-Q (reporting date: 2024-03-31), 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 Q1 2024 Calculation
Working capital turnover = (RevenuesQ1 2024 + RevenuesQ4 2023 + RevenuesQ3 2023 + RevenuesQ2 2023) ÷ Working capital
= (19,594 + 20,478 + 19,252 + 19,196) ÷ -1,268 =

2 Click competitor name to see calculations.


Average Inventory Processing Period

T-Mobile US Inc., average inventory processing period calculation (quarterly data)

Microsoft Excel
Mar 31, 2024 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
Inventory turnover 19.48 17.99 18.08 23.32 19.63 19.22 16.91 16.93 13.90 14.26 20.32 20.39 14.77 11.19 12.34 13.29 14.80 19.21
Short-term Activity Ratio (no. days)
Average inventory processing period1 19 20 20 16 19 19 22 22 26 26 18 18 25 33 30 27 25 19
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
AT&T Inc. 16 16 18 17 20 22 25 19 16 16 14 12 15 17
Verizon Communications Inc. 14 14 15 12 15 15 20 23 23 20 15 9 9 13 10 9 11 9

Based on: 10-Q (reporting date: 2024-03-31), 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 Q1 2024 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 19.48 = 19

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.

Average Receivable Collection Period

T-Mobile US Inc., average receivable collection period calculation (quarterly data)

Microsoft Excel
Mar 31, 2024 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
Receivables turnover 18.46 16.74 17.41 17.11 18.11 17.90 18.52 17.96 20.04 19.10 19.29 17.45 21.33 16.00 13.84 15.31 24.18 23.58
Short-term Activity Ratio (no. days)
Average receivable collection period1 20 22 21 21 20 20 20 20 18 19 19 21 17 23 26 24 15 15
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
AT&T Inc. 29 31 27 28 31 35 32 30 41 38 34 33 36 43 41 40 41 46
Verizon Communications Inc. 69 68 64 63 61 65 64 65 64 65 60 58 63 68 64 64 66 70

Based on: 10-Q (reporting date: 2024-03-31), 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 Q1 2024 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 18.46 = 20

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. T-Mobile US Inc. number of days of receivables outstanding deteriorated from Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 exceeding Q3 2023 level.

Operating Cycle

T-Mobile US Inc., operating cycle calculation (quarterly data)

No. days

Microsoft Excel
Mar 31, 2024 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
Average inventory processing period 19 20 20 16 19 19 22 22 26 26 18 18 25 33 30 27 25 19
Average receivable collection period 20 22 21 21 20 20 20 20 18 19 19 21 17 23 26 24 15 15
Short-term Activity Ratio
Operating cycle1 39 42 41 37 39 39 42 42 44 45 37 39 42 56 56 51 40 34
Benchmarks
Operating Cycle, Competitors2
AT&T Inc. 45 47 45 45 51 57 57 49 57 54 48 45 51 60
Verizon Communications Inc. 83 82 79 75 76 80 84 88 87 85 75 67 72 81 74 73 77 79

Based on: 10-Q (reporting date: 2024-03-31), 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 Q1 2024 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 19 + 20 = 39

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. T-Mobile US Inc. operating cycle deteriorated from Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 exceeding Q3 2023 level.