Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
AT&T Inc. logo

AT&T Inc.

Sector: Communication Services   

Industry: Telecom Services

17.60
 
USD
  
0.05
  
(0.28%)
Optionable: Yes  Market Cap: 122,885 M  90-day average vol: 38,506,973

Previous close: 17.55  Open: 17.55  Bid: 17.61  Ask: 17.62
52 week range    
13.43   
   19.99
Peers   
VZ / 
TMUS / 
SHEN / 
DTEGY / 
TDS / 
USM / 
AMX / 
CMCSA / 
Last updated: Friday 29th March 2024
60
MarketXLS Rank
80
Value
61
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

T Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
"""debtc"""6,056 M7,636 M9,832 M38,374 M10,255 M11,838 M3,470 M24,620 M7,467 M9,477 M
Accounts payable23,592 M30,372 M31,138 M34,470 M43,184 M45,956 M50,051 M39,095 M42,644 M35,852 M
Accounts receivable14,527 M16,532 M16,794 M16,522 M26,472 M22,636 M20,215 M12,313 M11,466 M10,289 M
Accrued expenses27,121 M35,498 M36,225 M38,802 M48,217 M50,949 M53,792 M44,089 M44,658 M37,872 M
Accumulated depreciation & depletion-169,397 M-181,777 M-194,749 M-188,277 M-199,217 M-28,217 M-200,436 M-202,964 M-202,185 M-211,402 M
Additional paid in capital91,108 M89,763 M89,604 M89,563 M125,525 M126,279 M130,175 M130,112 M123,610 M114,519 M
Cash and equivalents8,603 M5,121 M5,788 M50,498 M5,204 M12,130 M9,740 M19,223 M3,701 M6,722 M
CashCashEquivalentsAndShortTermInvestments8,603 M5,121 M5,788 M50,498 M5,204 M12,130 M9,740 M19,223 M3,701 M6,722 M
CashEquivalents7,346 M3,004 M61 M69 M9 M
CommercialPaper3,048 M6,586 M866 M2,091 M
Common par6,495 M6,495 M6,495 M6,495 M7,621 M7,621 M7,621 M7,621 M7,621 M7,621 M
Common stock equity89,716 M122,671 M123,135 M140,861 M184,089 M184,221 M161,673 M166,332 M97,500 M103,297 M
CommonStock6,495 M6,495 M6,495 M6,495 M7,621 M7,621 M7,621 M7,621 M7,621 M7,621 M
Cost in excess69,692 M104,568 M105,207 M105,449 M146,370 M146,241 M135,259 M92,740 M67,895 M67,854 M
CurrentCapitalLeaseObligation430 M884 M869 M1,818 M1,911 M3,451 M3,537 M3,393 M3,547 M3,524 M
CurrentDeferredRevenue4,105 M4,682 M4,519 M4,213 M5,948 M5,939 M6,071 M3,918 M3,778 M
CurrentDeferredTaxesAssets2,079 M
CurrentDeferredTaxesLiabilities1,142 M59,334 M60,274 M53,758 M56,946 M58,583 M
Deferred revenues4,105 M4,682 M4,519 M4,213 M5,948 M6,124 M3,918 M3,778 M
DeferredFinancingCosts-452 M-532 M-508 M-427 M-436 M
DividendsPayable2,438 M2,950 M3,008 M3,070 M3,854 M3,781 M3,741 M3,749 M2,014 M2,020 M
EmployeeBenefits37,079 M34,262 M33,578 M31,775 M19,218 M18,788 M18,276 M12,560 M7,260 M8,734 M
Float term debt16,013 M118,515 M113,681 M125,972 M166,250 M173,113 M175,977 M169,967 M147,082 M145,422 M
GoodwillAndOtherIntangibleAssets135,843 M207,070 M207,824 M212,704 M371,201 M264,946 M244,485 M211,961 M197,341 M200,356 M
Gross fixed assets (Plant Property & Equipment)282,295 M306,227 M319,648 M313,499 M330,690 M52,256 M352,465 M346,437 M351,444 M360,796 M
IncomeTaxPayable1,091 M2,176 M2,079 M1,262 M1,179 M1,212 M1,019 M1,148 M798 M1,022 M
Intangibles66,151 M102,502 M102,617 M107,255 M224,831 M118,705 M109,226 M119,221 M129,446 M132,502 M
InterestPayable3,613 M4,120 M4,910 M6,300 M7,957 M8,422 M7,925 M6,716 M6,108 M6,704 M
Invested capital178,394 M359,701 M350,497 M392,805 M516,589 M508,643 M491,425 M487,310 M373,005 M376,573 M
Leases2,238 M
LongTermCapitalLeaseObligation21,804 M22,202 M18,956 M18,659 M17,568 M
LongTermDebtAndCapitalLeaseObligation75,778 M118,515 M113,681 M125,972 M166,250 M173,113 M175,977 M169,967 M147,082 M145,422 M
Minority interest554 M969 M975 M1,146 M9,795 M17,713 M17,567 M17,523 M8,957 M16,118 M
Net fixed assets (net PP&E)112,898 M124,450 M124,899 M125,222 M131,473 M24,039 M152,029 M143,473 M149,259 M149,394 M
Non-current deferred income taxes38,436 M56,181 M60,128 M43,207 M57,859 M59,502 M60,472 M53,767 M57,032 M58,666 M
NonCurrentDeferredAssets37,544 M
NonCurrentDeferredLiabilities38,436 M56,181 M60,128 M43,207 M57,859 M59,502 M60,472 M53,767 M57,032 M58,666 M
NonCurrentDeferredTaxesAssets2,126 M-4,029 M-4,304 M-6,067 M-6,470 M-7,301 M-7,355 M-6,109 M-5,817 M-6,484 M
NonCurrentPensionAndOtherPostretirementBenefitPlans37,079 M34,262 M33,578 M31,775 M19,218 M18,788 M18,276 M12,560 M7,260 M8,734 M
Notes payable81,399 M124,847 M122,381 M162,526 M171,529 M161,109 M1,800 M
Number of employees160700.0160700.0160700.0160700.0160700.0160700.0160700.0160700.0160700.0160700.0
Other current assets9,645 M13,267 M14,232 M10,757 M17,704 M18,364 M18,358 M135,907 M14,818 M17,270 M
Other fixed assets112,898 M124,450 M124,899 M125,222 M131,473 M24,039 M152,029 M143,473 M149,259 M149,394 M
Other non-current assets13,425 M15,346 M16,812 M18,444 M24,809 M22,754 M23,617 M19,252 M19,612 M19,601 M
Other non-current liabilities17,989 M22,258 M21,748 M19,747 M30,233 M29,421 M28,358 M25,243 M28,849 M23,696 M
OtherCurrentBorrowings6,056 M7,636 M9,832 M38,374 M10,255 M11,838 M3,470 M24,620 M7,467 M9,477 M
OtherCurrentLiabilities1,766 M1,644 M1,585 M1,464 M6,124 M6,176 M37,521 M130 M631 M
OtherInventories1,933 M4,033 M2,039 M2,225 M2,771 M-2,864 M-3,592 M
OtherPayable3,141 M30,759 M2,959 M-1,123 M43,309 M1,809 M1,851 M1,245 M10,200 M2,942 M
Payables27,121 M35,498 M36,225 M38,802 M48,217 M50,949 M53,792 M44,089 M44,658 M37,872 M
Prepaid expenses831 M1,072 M1,555 M8,390 M2,047 M131,759 M3,695 M3,325 M3,123 M2,177 M
RecievablesAdjustmentsAllowances-454 M-704 M-661 M-663 M-907 M-1,235 M-1,221 M-658 M-588 M-499 M
Restricted cash50,932 M5,400 M12,295 M9,870 M21,316 M3,793 M6,833 M
Retained earnings39,142 M39,005 M39,695 M57,517 M63,002 M63,406 M41,787 M45,879 M-16,649 M-2,715 M
SecuritySoldNotYetRepurchased2,417 M5,498 M202 M
Short term debt6,056 M7,636 M9,832 M38,374 M10,255 M11,838 M3,470 M24,620 M7,467 M9,477 M
Total assets296,834 M402,672 M403,821 M444,097 M592,868 M512,757 M488,671 M551,622 M402,853 M407,060 M
Total current assets33,606 M35,992 M38,369 M86,167 M51,427 M184,889 M52,008 M170,768 M33,108 M36,458 M
Total current liabilities37,282 M47,816 M50,576 M81,389 M64,420 M68,911 M63,438 M106,230 M56,173 M51,127 M
Total equity89,716 M122,671 M123,135 M140,861 M184,089 M184,221 M161,673 M166,332 M97,500 M103,297 M
Total liabilities206,564 M279,032 M279,711 M302,090 M337,980 M349,735 M346,521 M367,767 M296,396 M287,645 M
Total non-current assets263,228 M366,680 M365,452 M357,930 M541,441 M327,868 M436,663 M380,854 M369,745 M370,602 M
Total non-current liabilities169,282 M231,216 M229,135 M220,701 M273,560 M280,824 M283,083 M261,537 M240,223 M236,518 M
TotalEquityGrossMinority90,270 M123,640 M124,110 M142,007 M193,884 M201,934 M179,240 M183,855 M106,457 M117,442 M
TotalEquityGrossMinorityInterest90,270 M123,640 M124,110 M142,007 M193,884 M201,934 M179,240 M183,855 M106,457 M117,442 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest296,834 M402,672 M403,821 M444,097 M531,864 M551,669 M488,671 M551,622 M402,853 M407,060 M
TotalNonCurrentLiabilitiesNetMinorityInteres169,282 M231,216 M229,135 M220,701 M273,560 M280,824 M283,083 M261,537 M240,223 M236,518 M
TotalTaxPayable1,091 M2,176 M2,079 M1,262 M1,179 M1,212 M1,019 M
Treasury stock-47,029 M-12,592 M-12,659 M-12,714 M-12,059 M-13,085 M-17,910 M-17,280 M-17,082 M-16,128 M
UnearnedIncome812 M18,208 M14,243 M10,676 M7,713 M12,434 M14,752 M18,983 M
UnearnedPremiums-2,968 M-2,526 M-2,996 M-9,710 M-9,758 M-9,650 M-9,509 M
Working capital-3,676 M-11,824 M-12,207 M4,778 M-12,993 M115,978 M-11,430 M64,538 M-23,065 M-14,669 M
ltinv250 M1,606 M1,674 M1,560 M6,245 M3,695 M1,780 M6,168 M3,533 M1,251 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.

We respect your privacy and will never share your email.
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