Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Telephone and Data Systems Inc. logo

Telephone and Data Systems Inc.

Sector: Communication Services   

Industry: Telecom Services

15.54
 
USD
  
-0.53
  
(-3.30%)
Optionable: Yes  Market Cap: 1,775 M  90-day average vol: 986,084

Previous close: 16.07  Open: 15.92  Bid: 14.25  Ask: 16.1
52 week range    
6.44   
   21.75
Peers   
SHEN / 
USM / 
SPOK / 
TMUS / 
VZ / 
T / 
AMZN / 
Last updated: Friday 26th April 2024
56
MarketXLS Rank
80
Value
38
Technical
50
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

TDS Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
"""debtc"""808000.014 M12 M20 M21 M126 M134 M147 M165 M173 M
Accounts payable387 M349 M365 M368 M365 M374 M508 M481 M506 M360 M
Accounts receivable549 M705 M753 M861 M992 M1,005 M1,004 M1,058 M1,069 M992 M
Accrued expenses556 M515 M547 M569 M547 M426 M593 M536 M564 M415 M
Accumulated depreciation & depletion-7,348 M-7,756 M-8,124 M-8,318 M-8,728 M-9,337 M-9,687 M-9,904 M-10,211 M-10,550 M
Additional paid in capital2,337 M2,365 M2,386 M2,413 M2,432 M2,468 M2,482 M2,496 M2,551 M2,558 M
Building & improvements480 M506 M511 M519 M523 M527 M533 M541 M532 M542 M
Cash and equivalents472 M985 M900 M619 M921 M465 M1,429 M367 M360 M236 M
CashCashEquivalentsAndShortTermInvestments472 M985 M900 M719 M938 M465 M1,432 M367 M360 M236 M
CashEquivalents472 M985 M900 M619 M921 M
Common par2 M2 M2 M1000000.01000000.01000000.01000000.01,075 M1,075 M1,075 M
Common stock equity3,926 M4,126 M4,144 M4,269 M4,560 M4,653 M4,804 M5,927 M5,849 M5,202 M
CommonStock1 M1000000.01000000.01000000.01000000.01000000.01000000.01000000.01000000.01000000.0
Construction in progress590 M528 M576 M709 M653 M
Cost in excess771 M766 M766 M509 M509 M547 M547 M547 M547 M
CurrentAccruedExpenses115 M113 M127 M126 M127 M11 M16 M10 M12 M12 M
CurrentCapitalLeaseObligation0.00.00.00.0170 M116 M129 M141 M146 M147 M
CurrentDeferredRevenue324 M288 M229 M223 M197 M189 M193 M236 M285 M277 M
CurrentDeferredTaxesAssets256 M237 M216 M162 M242 M447 M472 M646 M720 M743 M
CurrentDeferredTaxesLiabilities108 M899 M921 M550 M640 M1,122 M1,335 M1,565 M1,685 M1,718 M
Deferred revenues432 M288 M229 M223 M197 M189 M193 M236 M285 M277 M
DeferredFinancingCosts0.0
DefinedPensionBenefit51 M50 M52 M59 M55 M63 M69 M77 M66 M71 M
DividendsPayable8 M12 M11 M11 M11 M-75 M-78 M-80 M-82 M-83 M
Float term debt1,941 M2,440 M2,433 M2,437 M2,418 M3,247 M4,364 M3,888 M4,639 M4,970 M
GoodwillAndOtherIntangibleAssets2,534 M2,901 M2,938 M3,020 M2,957 M3,331 M3,398 M4,841 M5,450 M4,885 M
Gross fixed assets (Plant Property & Equipment)11,194 M11,520 M11,679 M11,742 M12,074 M13,836 M14,657 M15,305 M15,966 M16,599 M
IncomeTaxPayable47 M41 M44 M64 M44 M41 M69 M45 M46 M43 M
Intangibles1,762 M2,135 M2,172 M2,511 M2,448 M2,784 M2,851 M4,294 M4,903 M4,885 M
InterestPayable111 M142 M170 M170 M172 M11 M16 M10 M12 M12 M
Inventories274 M158 M151 M145 M150 M169 M154 M178 M268 M208 M
Invested capital5,867 M6,566 M6,594 M0.06,999 M10,216 M12,592 M12,743 M14,219 M14,252 M
Land & improvements1,130 M1,137 M1,188 M1,214 M1,245 M57 M56 M62 M63 M67 M
Leases1,314 M1,404 M1,476 M1,538 M1,598 M
LongTermCapitalLeaseObligation1,942 M2,454 M2,445 M2,457 M2,439 M931 M940 M960 M908 M890 M
LongTermDebtAndCapitalLeaseObligation1,941 M2,440 M2,433 M2,437 M2,418 M3,247 M4,364 M3,888 M4,639 M4,970 M
LongTermProvisions95 M0.0
Machinery furniture & equipment3,285 M3,383 M3,383 M3,411 M3,460 M3,708 M4,017 M4,150 M4,248 M4,381 M
Minority interest529 M578 M606 M624 M744 M762 M799 M818 M766 M806 M
Net fixed assets (net PP&E)3,846 M3,764 M3,555 M3,424 M3,346 M4,499 M4,970 M5,401 M5,755 M6,049 M
Non-current deferred income taxes668 M900 M922 M552 M640 M676 M863 M921 M969 M975 M
NonCurrentDeferredAssets942 M900 M
NonCurrentDeferredLiabilities900 M922 M552 M640 M676 M863 M921 M969 M975 M
NonCurrentDeferredTaxesAssets942 M350 M338 M309 M377 M599 M630 M795 M897 M959 M
NotesReceivable381 M628 M873 M974 M1,008 M1,007 M1,085 M1,211 M1,151 M
Number of employees9300.09300.09300.09300.09300.09300.09300.09300.09300.09300.0
Other current assets133 M30 M40 M37 M82 M29 M38 M61 M58 M52 M
Other equity adjustments6 M355000.01000000.0-1000000.0-10 M
Other fixed assets205 M205 M187 M194 M193 M13,836 M14,657 M15,305 M15,966 M16,599 M
Other non-current assets282 M197 M434 M422 M616 M607 M652 M728 M822 M822 M
Other non-current liabilities431 M433 M453 M495 M541 M481 M541 M759 M813 M784 M
Other receivable135 M98 M98 M100 M107 M119 M108 M93 M112 M82 M
OtherCurrentLiabilities203 M127 M99 M106 M114 M221 M233 M261 M500 M319 M
OtherInventories169 M154 M178 M268 M208 M
OtherPayable2,408 M
Payables442 M402 M420 M443 M420 M415 M577 M526 M552 M403 M
Preferred securities of subsidiary trust824000.01000000.01000000.01,074 M1,074 M1,074 M
PreferredStock824000.01000000.01000000.01,074 M1,074 M1,074 M
Prepaid expenses87 M112 M115 M112 M103 M98 M105 M103 M102 M86 M
RecievablesAdjustmentsAllowances-55 M0.0-71 M-76 M-78 M-72 M-96 M-90 M
Restricted cash474 M1,452 M414 M399 M270 M
Retained earnings2,330 M2,487 M2,454 M2,525 M2,656 M2,663 M2,798 M2,817 M2,704 M2,034 M
Short term debt808000.014 M12 M20 M21 M10 M5 M6 M19 M26 M
TaxesReceivable114 M70 M10 M2 M12 M36 M187 M184 M59 M4 M
Total assets8,907 M9,422 M9,446 M9,295 M9,783 M10,781 M12,525 M13,493 M14,550 M13,921 M
Total current assets1,767 M2,158 M2,059 M1,966 M2,330 M1,921 M3,026 M2,044 M2,028 M1,660 M
Total current liabilities1,063 M944 M887 M918 M879 M962 M1,153 M1,180 M1,514 M1,184 M
Total equity3,926 M4,126 M4,144 M4,269 M4,560 M4,653 M4,804 M5,927 M5,849 M5,202 M
Total liabilities3,564 M4,717 M4,695 M4,402 M4,479 M5,366 M6,922 M6,748 M7,935 M7,913 M
Total non-current assets7,926 M7,264 M7,379 M7,319 M7,399 M8,925 M9,497 M11,449 M12,522 M12,261 M
Total non-current liabilities2,372 M3,773 M3,808 M3,484 M3,600 M4,404 M5,769 M5,568 M6,421 M6,729 M
TotalEquityGrossMinority4,455 M4,704 M4,750 M4,892 M5,293 M5,404 M5,593 M6,734 M6,603 M5,996 M
TotalEquityGrossMinorityInterest4,455 M4,704 M4,750 M4,892 M5,293 M5,404 M5,593 M6,734 M6,603 M5,996 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest8,907 M9,422 M9,446 M9,295 M9,783 M10,781 M12,525 M13,493 M14,550 M13,921 M
TotalNonCurrentLiabilitiesNetMinorityInteres2,372 M3,773 M3,808 M3,484 M3,600 M4,404 M5,769 M5,568 M6,421 M6,729 M
TotalTaxPayable47 M41 M44 M64 M44 M41 M69 M45 M46 M43 M
Treasury stock-748 M-727 M-698 M-669 M-519 M-479 M-477 M-461 M-481 M-465 M
UnearnedPremiums76 M75 M75 M73 M72 M109 M67 M72 M73 M
Working capital704 M1,214 M1,172 M1,048 M1,451 M959 M1,873 M864 M514 M476 M
ltinv322 M402 M452 M453 M480 M488 M477 M479 M495 M505 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