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

ADT Inc.

Sector: Industrials   

Industry: Security & Protection Services

7.29
 
USD
  
-0.05
  
(-0.68%)
Optionable: Yes  Market Cap: 6,682 M  90-day average vol: 6,505,147

Previous close: 7.34  Open: 7.32  Bid: 7.18  Ask: 7.39
52 week range    
5.53   
   7.60
Peers   
BCO / 
PANW / 
ICTSF / 
Last updated: Thursday 23rd May 2024
71
MarketXLS Rank
80
Value
69
Technical
65
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

ADT Balance Sheet

Annual
Invalid dateDec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Accounts payable221 M242 M322 M475 M418 M294 M
Accounts receivable246 M287 M336 M442 M335 M390 M
Accrued expenses619 M719 M906 M1,212 M1,195 M895 M
Accumulated depreciation & depletion-392 M-546 M-1,914 M-1,915 M-1,616 M-1,351 M
Additional paid in capital5,969 M5,977 M6,641 M7,261 M7,381 M7,413 M
Cash and equivalents367 M49 M205 M24 M257 M15 M
CashCashEquivalentsAndShortTermInvestments367 M49 M205 M24 M257 M15 M
CashEquivalents367 M49 M208 M143 M145 M55 M
Common par5,541 M3,192 M8 M8 M9 M9 M
Common stock equity4,225 M6,369 M3,039 M3,249 M3,393 M3,789 M
CommonStock5,540 M3,192 M8 M8 M9 M9 M
Cost in excess5,082 M4,960 M5,236 M5,943 M5,430 M4,904 M
CurrentAccruedExpenses398 M477 M584 M737 M777 M601 M
CurrentCapitalLeaseObligation40 M30 M31 M93 M71 M97 M
CurrentDeferredRevenue335 M342 M346 M374 M310 M264 M
CurrentDeferredTaxesAssets1,016 M1,055 M985 M1,031 M996 M699 M
CurrentDeferredTaxesLiabilities1,653 M-2,219 M-1,974 M-1,897 M-1,888 M-1,726 M
Deferred revenues335 M342 M346 M374 M310 M264 M
DeferredAcquisitionCosts513 M654 M850 M991 M1,176 M
DeferredCosts430 M513 M654 M850 M991 M1,176 M
DeferredFinancingCosts-58 M-65 M-64 M-51 M-40 M
DefinedPensionBenefit85 M-91 M-99 M-75 M-56 M-59 M
DividendsPayable107 M565 M112 M-128 M-129 M
Finished goods89 M104 M175 M277 M225 M224 M
Float term debt9,944 M9,634 M9,448 M9,575 M8,947 M7,523 M
GoodwillAndOtherIntangibleAssets12,570 M11,629 M11,143 M11,357 M10,357 M9,781 M
Gross fixed assets (Plant Property & Equipment)718 M875 M2,239 M2,279 M1,922 M1,634 M
Intangibles7,488 M6,670 M5,907 M5,413 M4,927 M4,877 M
InterestPayable85 M115 M124 M125 M156 M111 M
Inventories115 M138 M216 M348 M237 M230 M
Invested capital14,169 M25,637 M21,934 M22,399 M21,287 M18,835 M
Leases66 M54 M89 M67 M83 M
LongTermCapitalLeaseObligation60 M100 M116 M100 M85 M124 M
LongTermDebtAndCapitalLeaseObligation9,944 M9,634 M9,448 M9,575 M8,947 M7,523 M
LongTermProvisions-55 M-56 M82 M52 M91 M138 M
Net fixed assets (net PP&E)327 M329 M326 M364 M306 M283 M
Non-current deferred income taxes1,342 M1,166 M991 M867 M893 M1,027 M
NonCurrentDeferredAssets430 M513 M654 M850 M991 M1,176 M
NonCurrentDeferredLiabilities1,887 M1,840 M1,823 M2,066 M2,474 M2,942 M
NonCurrentDeferredRevenue544 M674 M832 M1,199 M1,581 M1,915 M
NonCurrentDeferredTaxesAssets1,025 M1,111 M1,053 M1,091 M1,054 M712 M
Number of employees22000.022000.02200022000.022000.022000.0
Other current assets2,908 M2,739 M66 M66 M470 M85 M
Other equity adjustments-72 M-58 M-119 M
Other fixed assets329 M326 M364 M306 M283 M
Other non-current assets120 M248 M364 M463 M1,526 M713 M
Other non-current liabilities141 M305 M511 M301 M240 M230 M
Other receivable4,582 M5,126 M5,315 M5,307 M5,168 M4,983 M
OtherCurrentLiabilities83 M92 M100 M196 M299 M482 M
OtherDeferredCosts430 M513 M654 M
OtherPayable694 M-670 M381 M675 M622 M589 M
Payables221 M242 M322 M475 M418 M294 M
Preferred securities of subsidiary trust250000.0250000.01000000
PreferredStock250000.0250000.01000000
Prepaid expenses130 M151 M210 M169 M307 M254 M
RecievablesAdjustmentsAllowances-40 M-44 M-68 M-54 M-35 M-53 M
Restricted cash49 M208 M9 M116 M115 M
Retained earnings-1,680 M-2,801 M-3,610 M-4,022 M-3,997 M-3,634 M
SecuritySoldNotYetRepurchased-150 M-4000-1,200 M
Short term debt58 M58 M45 M118 M858 M321 M
Total assets17,209 M16,039 M16,117 M16,894 M17,821 M15,964 M
Total current assets854 M3,320 M967 M993 M1,722 M1,005 M
Total current liabilities1,012 M1,120 M1,296 M1,703 M2,661 M1,480 M
Total equity4,225 M6,369 M3,039 M3,249 M3,393 M3,789 M
Total liabilities12,984 M12,899 M13,078 M13,646 M14,428 M12,175 M
Total non-current assets13,447 M12,719 M15,150 M15,902 M16,099 M14,959 M
Total non-current liabilities11,971 M11,780 M11,782 M11,942 M11,767 M10,695 M
TotalEquityGrossMinority9,758 M6,369 M3,039 M3,248 M3,393 M3,788 M
TotalEquityGrossMinorityInterest9,758 M6,369 M3,039 M3,248 M3,393 M3,788 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest17,209 M19,268 M16,116 M16,894 M17,821 M15,964 M
TotalNonCurrentLiabilitiesNetMinorityInteres11,971 M11,780 M11,782 M11,942 M11,767 M10,695 M
UnearnedIncome2,908 M2,663 M2,868 M2,919 M3,006 M
UnearnedPremiums-20 M-27 M-20 M-17 M-13 M-15 M
Work in progress26 M34 M41 M71 M12 M6 M
Working capital-158 M2,201 M-329 M-711 M-939 M-476 M
debtc58 M58 M45 M118 M858 M321 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