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

Optionable: Yes  Market Cap: 6,112 M  90-day average vol: 2,440,451

Previous close: 6.83  Open: 6.81  Bid: 6.56  Ask: 6.9
52 week range    
BCO / 
Last updated: Wednesday 21st February 2024
MarketXLS Rank

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



StockDividendMarket Cap (B)PEPrice ($)


0.01153 B43.969.62


0 B11.17.99


51 B-98.2510.98


0.003820 B42.3100.31

ADT Income Statement

Invalid dateDec-18Dec-19Dec-20Dec-21Dec-22
AccruedPreferredStockDividends424 M634 M
AllowancesForConstruction4 M
Amortization of intangibles-1,207 M-162 M5,907 M5,943 M-935 M
Basic EPS from continuing operations-0.57-1.54-0.82
Basic EPS total-0.81-0.57-1.54-0.820.38
Basic weighted shares outstanding748 M747 M776 M825 M903 M
Cost of sales-120 M-38 M
Depreciation2,972 M1,989 M1,914 M1,915 M1,694 M
Depreciation unreconciled2,972 M1,989 M1,914 M1,915 M1,694 M
DepreciationAndAmortization2,972 M1,989 M1,914 M1,915 M1,694 M
Diluted EPS total-0.81-0.57-1.56-0.820.38
Diluted normalized net income/share-0.57-1.56-0.82
Diluted weighted shares outstanding748 M747 M781 M825 M970 M
Dividends paid per share0.140.84
Earnings from equity interest107 M68 M-5 M
EarningsFromEquityInterestNetOfTax107 M68 M-5 M
GainOnSaleOfBusiness-2 M-12 M
GainOnSaleOfPPE562 M
GainOnSaleOfSecurity-9 M-60 M158 M302 M
GainsLossOnDisposalOfDiscontinuedOperations-62 M-738000.0
GeneralAndAdministrativeExpense-5 M1,407 M1,723 M1,789 M-185 M
Gross operating profit13 M5,126 M5,435 M5,307 M6,395 M
ImpairmentOfCapitalAssets88 M45 M149 M
Income before tax-633 M-522 M-779 M-471 M237 M
Income restructuring and M&A-3 M36 M120 M
Income taxes23 M98 M-147 M-130 M60 M
Interest income-663 M-534 M-708 M-458 M-265 M
InterestExpenseNonOperating-620 M623 M710 M458 M-279 M
MiscOtherSpecialCharges4,334 M-665 M-111 M-29 M-58 M
Net income from total operations-656 M-424 M-632 M-341 M173 M
NetIncomeCommonStockholders-656 M770 M2,641 M2,835 M173 M
NetIncomeContinuousOperations-656 M-424 M-632 M-341 M173 M
NetIncomeDiscontinuousOperations-62 M-738000.0
NetNonOperatingInterestIncomeExpense-663 M-534 M-708 M-458 M-265 M
Operating income-4,219 M196 M41 M15 M710 M
Operating income before depreciation (EBITDA)1,720 M2,090 M1,845 M1,902 M1,652 M
OperatingExpense4,219 M3,396 M2,120 M2,116 M5,686 M
Other income net-4,334 M447 M111 M29 M62 M
OtherGandA-5 M1,407 M1,723 M1,789 M-185 M
OtherOperatingExpenses-228000.0-1000000.0153 M-100 M
OtherWriteOff-49 M-150 M56 M66 M-88 M
OtherunderPreferredStockDividend424 M634 M
PreferredStockDividends424 M634 M
PromotionAndAdvertising-143 M160 M264 M239 M-219 M
RentAndLandingFees-5 M
Research & development expense9000.0
RestructringAndMnAIncome-3 M36 M120 M
Revenue per share-1,207 M-139 M6,004 M6,069 M-1,098 M
SalariesAndWages-135 M-1,517 M-1,588 M2,062 M
Selling Gen & administrative expense1,247 M1,407 M1,723 M1,789 M1,930 M
SellingAndMarketingExpense1,247 M160 M264 M239 M1,930 M
SellingExpense1,247 M1,930 M
Special income/charges-85 M-81 M-120 M-149 M
Total Income available for interest expense (EBIT)-1,253 M101 M-69 M-13 M-42 M
Total common shares outstanding757 M760 M817 M1,803 M917 M
Total net income-656 M-424 M-632 M-341 M173 M
Total ordinary shares867 M867 M867 M867 M867 M
Total revenues13 M5,126 M5,315 M5,307 M6,395 M
TotalExpenses4,219 M3,396 M2,000 M2,116 M5,686 M
TotalRevenue4,582 M5,126 M5,315 M5,307 M6,395 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


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.


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