Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS



Optionable:   Market Cap:   90-day average vol:

Previous close:   Open:   Bid:   Ask:
52 week range    

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


ADV Income Statement

Invalid dateDec-19Dec-20Dec-21Dec-22Dec-23
Amortization of intangibles2,163 M2,206 M888 M855 M
Basic EPS from continuing operations-0.730.17-4.33-0.2
Basic EPS total-0.06-0.730.17-4.33-0.2
Basic weighted shares outstanding204 M223 M318 M319 M324 M
Cost of sales2,559 M2,964 M1,921 M3,622 M
Depreciation233 M239 M240 M233 M225 M
Depreciation unreconciled233 M239 M240 M233 M225 M
DepreciationAndAmortization233 M239 M240 M233 M225 M
Diluted EPS total-0.1-0.730.17-4.33-0.2
Diluted normalized net income/share0.17-4.33-0.2
Diluted weighted shares outstanding212 M321 M319 M324 M
Earnings from equity interest5 M
EarningsFromEquityInterestNetOfTax5 M
GainOnSaleOfBusiness59 M
GainOnSaleOfPPE-21 M-7 M-3 M-19 M
GeneralAndAdministrativeExpense306 M168 M188 M265 M
Gross operating profit3,785 M596 M638 M2,129 M603 M
ImpairmentOfCapitalAssets1,573 M44 M
Income before tax-18 M-180 M91 M-1,523 M-89 M
Income restructuring and M&A13 M-5 M-60 M1,377 M
Income taxes1 M170 M34 M-145 M-29 M
InterestExpenseNonOperating232 M234 M138 M104 M166 M
MinorityInterests-1 M-736000.0-3 M-3 M-3 M
MiscOtherSpecialCharges3,785 M-13 M-955000.021 M286000.0
Net income from total operations-21 M-176 M54 M-1,381 M-63 M
NetIncomeCommonStockholders-21 M-366 M54 M-1,381 M-63 M
NetIncomeContinuousOperations-21 M-176 M54 M-1,381 M-63 M
NetNonOperatingInterestIncomeExpense-232 M-234 M-138 M-104 M-166 M
Normalized income-115 M
Operating income214 M67 M230 M-1,439 M76 M
Operating income before depreciation (EBITDA)446 M292 M478 M-1,176 M309 M
OperatingExpense3,571 M545 M408 M421 M490 M
Other income net-7,655 M13 M955000.0-18 M-40 M
OtherGandA306 M168 M188 M265 M
OtherOperatingExpenses-53 M921 M29 M31 M28 M
OtherTaxes3,163 M
RestructringAndMnAIncome13 M-5 M-60 M1,377 M
Revenue per share-17 M2,163 M2,206 M888 M855 M
SalariesAndWages-5 M1 M-7 M-8 M
Selling Gen & administrative expense175 M306 M168 M188 M265 M
SellingAndMarketingExpense175 M
SellingExpense175 M
Special income/charges-13 M5 M60 M-1,573 M-43 M
Total Income available for interest expense (EBIT)214 M54 M229 M-1,418 M76 M
Total common shares outstanding56 M318 M318 M322 M320 M
Total net income-21 M-176 M54 M-1,381 M-63 M
Total ordinary shares322 M322 M322 M322 M322 M
Total revenues3,785 M3,156 M3,602 M4,050 M4,225 M
TotalExpenses3,571 M3,104 M3,372 M2,341 M4,112 M
TotalRevenue3,785 M3,156 M3,602 M4,050 M4,225 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


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