Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
T-Mobile US Inc. logo

T-Mobile US Inc.

Sector: Communication Services   

Industry: Telecom Services

164.05
 
USD
  
-0.13
  
(-0.08%)
Optionable: Yes  Market Cap: 193,756 M  90-day average vol: 4,369,647

Previous close: 164.18  Open: 164.77  Bid: 165.21  Ask: 166.0
52 week range    
124.92   
   168.64
Peers   
VZ / 
T / 
TDS / 
AMX / 
USM / 
SPOK / 
Last updated: Friday 26th April 2024
67
MarketXLS Rank
80
Value
84
Technical
39
Quality

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Financials

TMUS Cash Flow

Annual
Dec-16Dec-17Dec-18Dec-19Mar-20Jun-20Dec-20Dec-21Dec-22Dec-23
(Increase) Decrease in inventories-802 M-844 M-201 M-617 M-511 M-553 M-2,222 M201 M744 M197 M
(Increase) Decrease in other current assets-133 M-575 M-181 M-144 M6 M-104 M-402 M
(Increase) Decrease in other current liabilities279 M-157 M-43 M144 M79 M-2,190 M-2,178 M-531 M459 M-839 M
(Increase) Decrease in other working capital-573 M-754 M-358 M
(Increase) Decrease in payables-1,201 M1,079 M-867 M17 M-405 M-1,261 M-2,123 M549 M558 M-1,126 M
(Increase) Decrease in receivables-506 M-5,743 M-6,215 M-4,724 M-679 M-371 M-4,726 M-6,366 M-6,342 M-4,868 M
Acquisitions-338 M-31 M-5,000 M-5,000 M-1,916 M-52 M
AssetImpairmentCharge477 M307 M418 M1,020 M452 M1,503 M898 M
CapitalExpenditureReported8,670 M11,065 M5,668 M7,358 M1,852 M3,002 M12,367 M21,692 M17,301 M10,811 M
Cash at beginning of period4,582 M5,500 M1,219 M1,203 M1,528 M1,112 M1,528 M10,463 M6,703 M4,674 M
Cash at end of period5,500 M1,219 M1,203 M1,528 M1,899 M11,161 M10,463 M6,703 M4,674 M5,307 M
Cash flow6,135 M3,831 M3,899 M6,824 M951 M777 M8,640 M13,917 M16,781 M18,559 M
CashFlowFromContinuingInvestingActivities-5,680 M-6,745 M-579 M-4,125 M-580 M-6,356 M-12,715 M-19,386 M-12,359 M-5,829 M
ChangeInAccountPayable-1,201 M1,079 M-867 M17 M-405 M-1,261 M-2,123 M549 M558 M-1,126 M
ChangeInPayablesAndAccruedExpense-1,201 M1,079 M-867 M17 M-405 M-1,261 M-2,123 M549 M558 M-1,126 M
ChangeInWorkingCapital-2,363 M-6,240 M-7,507 M-5,324 M-1,510 M-4,479 M-11,651 M-6,720 M-5,335 M-6,994 M
ChangesInAccountReceivables-603 M-3,931 M-4,617 M-3,709 M-748 M-498 M-3,273 M-3,225 M-5,158 M-5,038 M
CommonStockDividendPaid-55 M-55 M-747 M
CommonStockPayments-427 M-1,071 M-16,990 M-19,536 M-3,000 M-13,074 M
Current deferred income taxes914 M-1,404 M980 M1,091 M310 M98 M822 M197 M492 M2,600 M
Deferred income taxes914 M-1,404 M980 M1,091 M310 M98 M822 M197 M492 M2,600 M
Depreciation6,243 M5,984 M6,486 M6,616 M1,718 M4,064 M14,151 M16,383 M13,651 M12,818 M
Depreciation unreconciled6,243 M5,984 M6,486 M6,616 M1,718 M4,064 M14,151 M16,383 M13,651 M12,818 M
DepreciationAndAmortization6,243 M5,984 M6,486 M6,616 M1,718 M4,064 M14,151 M16,383 M13,651 M12,818 M
FinancingCashFlow463 M-1,367 M-3,336 M-2,374 M-453 M15,628 M13,010 M1,709 M-6,451 M-12,097 M
Free cash flow-2,535 M-7,234 M-1,769 M-534 M951 M-2,225 M-3,727 M-7,775 M-520 M7,748 M
GainLossOnInvestmentSecurities-25 M-52 M
GainLossOnSaleOfPPE-835 M-235 M
IncomeTaxPaidSupplementalData25 M31 M51 M88 M24 M31 M
InterestPaidSupplementalData1,681 M2,028 M1,525 M1,128 M341 M608 M
Issuance of capital stock17,290 M19,840 M
Issuance of debt-150 M-300 M-300 M-775 M-25 M-186 M-186 M
IssuanceOfCapitalStock17,290 M19,840 M
IssuanceOfDebt622 M-536 M-1,855 M-1,398 M-307 M15,743 M13,714 M2,516 M-3,081 M2,168 M
Net cash from financing activities463 M-1,367 M-3,336 M-2,374 M-453 M15,628 M13,010 M1,709 M-6,451 M-12,097 M
Net cash from investing activities-5,680 M-6,745 M-579 M-4,125 M-580 M-6,356 M-12,715 M-19,386 M-12,359 M-5,829 M
Net cash from operating activities6,135 M3,831 M3,899 M6,824 M951 M777 M8,640 M13,917 M16,781 M18,559 M
Net change in cash & cash equivalents918 M-4,281 M-16 M325 M371 M10,049 M8,935 M-3,760 M-2,029 M633 M
Net income from continuing operations1,460 M4,536 M2,888 M3,468 M951 M110 M3,064 M3,024 M2,590 M8,317 M
NetBusinessPurchaseAndSale-338 M-31 M-5,000 M-3,776 M-1,916 M-52 M
NetCommonStockIssuance-427 M-1,071 M300 M304 M-3,000 M-13,074 M
NetIntangiblesPurchaseAndSale-3,968 M-5,828 M-127 M-967 M-99 M-745 M-1,333 M-9,366 M-3,331 M-1,010 M
NetInvestmentPropertiesPurchaseAndSale2,990 M4,320 M5,427 M3,264 M-580 M1,646 M3,428 M4,222 M4,994 M4,982 M
NetInvestmentPurchaseAndSale2,990 M4,320 M5,427 M3,264 M-580 M1,646 M3,428 M4,222 M4,994 M4,982 M
NetIssuancePaymentsOfDebt622 M-536 M-1,855 M-1,398 M-307 M15,743 M13,714 M2,516 M-3,081 M2,168 M
NetLongTermDebtIssuance772 M-236 M-1,555 M-1,398 M-282 M15,929 M13,900 M2,516 M-3,081 M2,168 M
NetPPEPurchaseAndSale-4,702 M-5,237 M-5,541 M-6,391 M-1,753 M-2,257 M-11,034 M-12,326 M-13,970 M-9,801 M
Operating (gains) losses-860 M-149 M122 M19 M163 M371 M184 M
Other financing charges net-133 M-161 M-198 M-948 M-146 M-282 M-817 M-691 M-370 M-444 M
Other investing changes net-8 M4,320 M5,427 M3,264 M-580 M1,646 M3,428 M4,222 M4,994 M4,982 M
Other non-cash items741 M1,104 M930 M954 M148 M821 M1,883 M849 M5,383 M1,818 M
Payment of cash dividends55 M55 M747 M
ProceedsFromStockOptionExercised29 M21 M
Purchase of property plant & equipment-8,670 M-11,065 M-5,668 M-7,358 M-1,852 M-3,002 M-12,367 M-21,692 M-17,301 M-10,811 M
Purchase of short term investments997 M10,480 M2,494 M26,694 M35,337 M14,727 M3,714 M8,446 M
PurchaseOfIntangibles-3,968 M-5,828 M-127 M-967 M-99 M-745 M-1,333 M-9,366 M-3,331 M-1,010 M
PurchaseOfPPE-4,702 M-5,237 M-5,541 M-6,391 M-1,753 M-2,257 M-11,034 M-12,326 M-13,970 M-9,801 M
Repayment of debt-225 M-10,716 M-4,049 M-1,398 M-282 M-10,765 M-21,437 M-12,211 M-6,795 M-6,278 M
RepaymentOfDebt-375 M-13,926 M-10,614 M-3,738 M-307 M-29,694 M-40,366 M-12,211 M-6,795 M-6,278 M
Repurchase of capital stock-427 M-1,071 M-16,990 M-19,536 M-3,000 M-13,074 M
Sale of short term investments2,998 M
SaleOfBusiness1,224 M
SaleOfInvestment2,998 M
ShortTermDebtIssuance2,910 M6,265 M2,340 M18,743 M18,743 M
ShortTermDebtPayments-150 M-3,210 M-6,565 M-2,340 M-25 M-18,929 M-18,929 M
StockBasedCompensation235 M306 M424 M495 M138 M259 M694 M540 M595 M667 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University