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

180.27
 
USD
  
2.36
  
(1.33%)
Optionable: Yes  Market Cap: 208,485 M  90-day average vol: 4,493,014

Previous close: 177.91  Open: 179.02  Bid: 180.0  Ask: 180.2
52 week range    
126.05   
   181.17
Peers   
VZ / 
T / 
TDS / 
AMX / 
USM / 
SPOK / 
Last updated: Thursday 6th June 2024
69
MarketXLS Rank
80
Value
92
Technical
36
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 Balance Sheet

Annual
Dec-16Dec-17Dec-18Dec-19Mar-20Jun-20Dec-20Dec-21Dec-22Dec-23
Accounts payable7,277 M182 M200 M187 M228 M126 M157 M11,405 M12,275 M10,373 M
Accounts receivable1,896 M1,915 M1,769 M1,888 M1,836 M3,355 M4,254 M4,194 M4,445 M4,692 M
Accrued expenses7,277 M8,710 M7,941 M6,933 M6,231 M9,474 M10,353 M11,508 M12,275 M10,373 M
Accumulated depreciation & depletion-24,779 M-27,301 M-31,297 M-33,118 M-37,089 M-42,395 M-49,818 M-53,102 M-58,481 M
Additional paid in capital38,846 M38,629 M38,010 M38,498 M38,597 M72,505 M72,772 M73,292 M73,941 M67,705 M
Cash and equivalents5,500 M1,219 M1,203 M1,528 M1,112 M11,076 M10,385 M6,631 M4,507 M5,135 M
CashCashEquivalentsAndShortTermInvestments5,500 M1,219 M1,203 M1,528 M1,112 M11,076 M10,385 M6,631 M4,507 M5,135 M
CashEquivalents1,219 M1,203 M1,528 M1,112 M11,076 M
Common stock equity18,236 M22,559 M24,718 M28,789 M28,977 M62,954 M65,344 M69,102 M69,656 M64,715 M
CommonStock18,236 M859 M1,000 M2,000 M1,000 M2,000 M2,000 M69,102 M69,656 M64,715 M
Cost in excess1,683 M1,683 M1,901 M1,930 M1,930 M10,910 M11,117 M12,188 M12,234 M12,234 M
CurrentCapitalLeaseObligation1,425 M1,824 M2,700 M3,244 M3,105 M5,204 M4,931 M4,545 M4,673 M4,815 M
CurrentDeferredAssets2,621 M2,590 M2,557 M2,236 M2,230 M
CurrentDeferredRevenue986 M779 M698 M631 M619 M1,185 M1,030 M856 M780 M825 M
CurrentDeferredTaxesAssets3,877 M3,430 M3,728 M5,990 M16,207 M16,268 M21,351 M19,912 M
CurrentDeferredTaxesLiabilities8,815 M3,537 M4,472 M5,607 M9,966 M26,484 M32,235 M33,370 M
Deferred revenues986 M779 M698 M631 M619 M1,185 M1,030 M856 M780 M825 M
DeferredFinancingCosts5 M6 M567 M
DefinedPensionBenefit2,100 M2,300 M2,200 M1,600 M1,600 M
DividendsPayable-747 M
Float term debt8 M12,121 M12,124 M10,958 M10,959 M62,783 M61,830 M68,570 M98,021 M100,875 M
GoodwillAndOtherIntangibleAssets29,073 M37,266 M37,658 M38,510 M38,492 M99,818 M99,243 M109,527 M111,540 M111,559 M
Gross fixed assets (Plant Property & Equipment)45,722 M49,497 M63,907 M66,035 M33,105 M93,136 M111,591 M70,084 M127,160 M129,318 M
Intangibles27,390 M35,583 M35,757 M36,580 M36,562 M88,908 M88,126 M97,339 M99,306 M99,325 M
InterestPayable1,418 M1,111 M227 M227 M780 M771 M710 M731 M818 M
Inventories1,111 M1,566 M1,084 M964 M1,225 M1,549 M2,527 M2,567 M1,884 M1,678 M
Invested capital40,076 M44,910 M40,191 M40,347 M39,896 M136,266 M127,174 M210,503 M234,473 M236,989 M
Leases2,624 M2,400 M1,159 M3,100 M3,322 M3,257 M3,270 M
LineOfCredit74 M79 M86 M113 M631 M244 M441 M352 M-263 M
LongTermCapitalLeaseObligation27,786 M28,319 M27,547 M11,885 M11,740 M16,903 M28,163 M27,273 M31,225 M29,476 M
LongTermDebtAndCapitalLeaseObligation21,832 M12,121 M12,124 M22,843 M22,699 M79,686 M89,993 M95,843 M98,021 M100,875 M
LongTermProvisions0.0
Net fixed assets (net PP&E)20,943 M22,196 M32,610 M32,917 M33,105 M56,047 M69,196 M70,084 M74,058 M70,837 M
Non-current deferred income taxes4,938 M3,537 M4,472 M5,607 M5,618 M9,996 M9,966 M10,216 M10,884 M13,458 M
NonCurrentAccountsReceivable2,829 M
NonCurrentDeferredLiabilities7,554 M6,257 M7,253 M5,607 M5,618 M9,996 M9,966 M10,216 M10,884 M13,458 M
NonCurrentDeferredTaxesAssets4,450 M3,703 M3,938 M6,119 M17,085 M16,703 M21,726 M20,218 M
NonCurrentNoteReceivables984 M1,274 M1,547 M1,583 M1,367 M1,399 M2,031 M2,829 M2,546 M2,042 M
NotesReceivable1,930 M2,290 M2,538 M2,600 M2,406 M3,194 M3,577 M4,748 M5,123 M4,456 M
Number of employees71000.071000.071000.071000.071000.071000.071000.071000.071000.071000.0
Other current assets1,537 M1,903 M1,676 M1,972 M2,882 M4,496 M2,496 M2,005 M2,435 M2,352 M
Other equity adjustments8 M-332 M-868 M-1,700 M-1,700 M-1,581 M-1,365 M
Other fixed assets20,943 M69,196 M70,084 M70,801 M67,567 M
Other non-current assets674 M912 M3,894 M4,606 M4,775 M5,614 M5,807 M3,232 M4,127 M4,229 M
Other non-current liabilities6,626 M15,521 M15,549 M17,176 M12,946 M11,330 M13,156 M7,903 M4,101 M7,706 M
Other receivable40 M22 M11 M20 M11,113 M24 M22 M4,748 M79,571 M78,558 M
OtherCurrentBorrowings354 M1,612 M841 M25 M3,818 M4,579 M5,623 M5,164 M3,619 M
OtherCurrentLiabilities405 M414 M787 M1,673 M4,801 M3,510 M810 M967 M5,784 M1,296 M
OtherInventories1,111 M2,567 M1,884 M1,678 M
OtherPayable4,702 M8,528 M7,741 M6,746 M6,003 M9,348 M10,196 M2,245 M3,331 M1,010 M
Payables7,277 M8,710 M7,941 M6,933 M6,231 M9,474 M10,353 M11,508 M12,275 M10,373 M
Preferred securities of subsidiary trust0.0
PreferredStock0.0
Prepaid expenses2,203 M333 M627 M624 M746 M673 M702 M
RecievablesAdjustmentsAllowances-121 M-67 M-61 M-194 M-252 M-328 M-268 M
Restricted cash73 M101 M
Retained earnings-20,609 M-16,074 M-12,954 M-8,833 M1.0-7,839 M-5,836 M-2,812 M-1,269 M6,383 M
SecuritySoldNotYetRepurchased0.0427 M1,071 M
Short term debt354 M1,612 M841 M25 M3,818 M4,579 M5,623 M5,164 M3,619 M
Total assets68,512 M70,563 M72,468 M86,921 M89,456 M187,199 M200,162 M206,563 M211,338 M207,682 M
Total current assets16,838 M8,915 M8,281 M9,305 M11,717 M24,321 M23,885 M20,891 M19,067 M19,015 M
Total current liabilities9,022 M11,515 M10,267 M12,506 M14,756 M23,191 M21,703 M23,499 M24,742 M20,928 M
Total equity18,236 M22,559 M24,718 M28,789 M28,977 M62,954 M65,344 M69,102 M69,656 M64,715 M
Total liabilities45,034 M45,414 M45,193 M58,132 M56,019 M124,203 M134,818 M137,461 M141,682 M142,967 M
Total non-current assets51,674 M61,648 M75,709 M77,616 M77,739 M162,878 M176,277 M185,672 M192,271 M188,667 M
Total non-current liabilities36,012 M36,489 M37,483 M45,626 M41,263 M101,012 M113,115 M113,962 M116,940 M122,039 M
TotalEquityGrossMinority18,236 M22,559 M24,718 M28,789 M28,937 M62,954 M65,344 M69,102 M69,656 M64,715 M
TotalEquityGrossMinorityInterest18,236 M22,559 M24,718 M28,789 M28,937 M62,954 M65,344 M69,102 M69,656 M64,715 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest63,270 M70,563 M72,468 M86,921 M84,956 M187,157 M200,162 M206,563 M211,338 M207,682 M
TotalNonCurrentLiabilitiesNetMinorityInteres36,012 M36,489 M37,483 M45,626 M41,263 M101,012 M113,115 M113,962 M116,940 M122,039 M
Treasury stock-1000000.0-4 M-6 M-8 M-11 M-12 M-11 M-13 M-3,016 M-9,373 M
UnearnedPremiums212 M78 M2,197 M1,740 M1,335 M
Working capital7,816 M-2,600 M-1,986 M-3,201 M-3,039 M1,130 M2,182 M-2,608 M-5,675 M-1,913 M
debtc354 M1,612 M841 M3,269 M3,105 M9,022 M9,510 M10,168 M9,837 M8,434 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