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
Dec 31, 2024 Sep 30, 2024 Jun 30, 2024 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
Turnover Ratios
Inventory turnover 18.45 16.36 22.27 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
Receivables turnover 19.04 18.67 17.33 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
Working capital turnover 50.77 31.35
Average No. Days
Average inventory processing period 20 22 16 19 20 20 16 19 19 22 22 26 26 18 18 25 33
Add: Average receivable collection period 19 20 21 20 22 21 21 20 20 20 20 18 19 19 21 17 23
Operating cycle 39 42 37 39 42 41 37 39 39 42 42 44 45 37 39 42 56

Based on: 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 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).

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 Q2 2024 to Q3 2024 but then slightly improved from Q3 2024 to Q4 2024.
Receivables turnover An activity ratio equal to revenue divided by receivables. T-Mobile US Inc. receivables turnover ratio improved from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024.

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. T-Mobile US Inc. number of days of inventory outstanding deteriorated from Q2 2024 to Q3 2024 but then slightly improved from Q3 2024 to Q4 2024.
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 improved from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024.
Operating cycle Equal to average inventory processing period plus average receivables collection period. T-Mobile US Inc. operating cycle deteriorated from Q2 2024 to Q3 2024 but then improved from Q3 2024 to Q4 2024 not reaching Q2 2024 level.

Inventory Turnover

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

Microsoft Excel
Dec 31, 2024 Sep 30, 2024 Jun 30, 2024 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
Selected Financial Data (US$ in millions)
Cost of revenues 8,785 7,029 6,752 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
Inventory 1,607 1,789 1,319 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
Short-term Activity Ratio
Inventory turnover1 18.45 16.36 22.27 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
Benchmarks
Inventory Turnover, Competitors2
AT&T Inc. 21.68 19.35 27.18 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. 24.08 21.31 29.31 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

Based on: 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 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).

1 Q4 2024 Calculation
Inventory turnover = (Cost of revenuesQ4 2024 + Cost of revenuesQ3 2024 + Cost of revenuesQ2 2024 + Cost of revenuesQ1 2024) ÷ Inventory
= (8,785 + 7,029 + 6,752 + 7,087) ÷ 1,607 = 18.45

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 Q2 2024 to Q3 2024 but then slightly improved from Q3 2024 to Q4 2024.

Receivables Turnover

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

Microsoft Excel
Dec 31, 2024 Sep 30, 2024 Jun 30, 2024 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
Selected Financial Data (US$ in millions)
Revenues 21,872 20,162 19,772 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
Accounts receivable, net of allowance for credit losses 4,276 4,286 4,563 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
Short-term Activity Ratio
Receivables turnover1 19.04 18.67 17.33 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
Benchmarks
Receivables Turnover, Competitors2
AT&T Inc. 12.69 13.46 12.62 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
Verizon Communications Inc. 5.16 5.17 5.24 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

Based on: 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 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).

1 Q4 2024 Calculation
Receivables turnover = (RevenuesQ4 2024 + RevenuesQ3 2024 + RevenuesQ2 2024 + RevenuesQ1 2024) ÷ Accounts receivable, net of allowance for credit losses
= (21,872 + 20,162 + 19,772 + 19,594) ÷ 4,276 = 19.04

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 improved from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024.

Working Capital Turnover

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

Microsoft Excel
Dec 31, 2024 Sep 30, 2024 Jun 30, 2024 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
Selected Financial Data (US$ in millions)
Current assets 18,404 22,531 19,297 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
Less: Current liabilities 20,174 20,955 23,038 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
Working capital (1,770) 1,576 (3,741) (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)
 
Revenues 21,872 20,162 19,772 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
Short-term Activity Ratio
Working capital turnover1 50.77 31.35
Benchmarks
Working Capital Turnover, Competitors2
AT&T Inc.
Verizon Communications Inc. 141.27 8.59

Based on: 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 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).

1 Q4 2024 Calculation
Working capital turnover = (RevenuesQ4 2024 + RevenuesQ3 2024 + RevenuesQ2 2024 + RevenuesQ1 2024) ÷ Working capital
= (21,872 + 20,162 + 19,772 + 19,594) ÷ -1,770 =

2 Click competitor name to see calculations.


Average Inventory Processing Period

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

Microsoft Excel
Dec 31, 2024 Sep 30, 2024 Jun 30, 2024 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
Selected Financial Data
Inventory turnover 18.45 16.36 22.27 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
Short-term Activity Ratio (no. days)
Average inventory processing period1 20 22 16 19 20 20 16 19 19 22 22 26 26 18 18 25 33
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
AT&T Inc. 17 19 13 16 16 18 17 20 22 25 19 16 16 14 12 15 17
Verizon Communications Inc. 15 17 12 14 14 15 12 15 15 20 23 23 20 15 9 9 13

Based on: 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 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).

1 Q4 2024 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 18.45 = 20

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. T-Mobile US Inc. number of days of inventory outstanding deteriorated from Q2 2024 to Q3 2024 but then slightly improved from Q3 2024 to Q4 2024.

Average Receivable Collection Period

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

Microsoft Excel
Dec 31, 2024 Sep 30, 2024 Jun 30, 2024 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
Selected Financial Data
Receivables turnover 19.04 18.67 17.33 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
Short-term Activity Ratio (no. days)
Average receivable collection period1 19 20 21 20 22 21 21 20 20 20 20 18 19 19 21 17 23
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
AT&T Inc. 29 27 29 29 31 27 28 31 35 32 30 41 38 34 33 36 43
Verizon Communications Inc. 71 71 70 69 68 64 63 61 65 64 65 64 65 60 58 63 68

Based on: 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 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).

1 Q4 2024 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 19.04 = 19

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 improved from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024.

Operating Cycle

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

No. days

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

Based on: 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 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).

1 Q4 2024 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 20 + 19 = 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 Q2 2024 to Q3 2024 but then improved from Q3 2024 to Q4 2024 not reaching Q2 2024 level.