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

Sector:    

Industry: 

 
USD
  
  
()
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

Metrics

Valuation

Returns

Risk

Ranks

Dividends

Analyst Estimates

Financial Health

Technicals

Growth

Profitability

Peers

StockDividendMarket Cap (B)PEPrice ($)
Financials

TV Income Statement

Annual
Invalid dateDec-17Dec-18Dec-19Dec-20Dec-21Dec-22
AcquiredInProcessRnD-816 M
AcquiredInProcessRnDIncome-1,317 M
AllowancesForConstruction11,275 M
Basic EPS total1.542.071.6-0.030.1215.8
Basic weighted shares outstanding10,092 M7,358 M7,634 M20,188 M122,580 M5,732 M
Cost of sales-53,535 M57,839 M59,067 M56,990 M46,654 M48,808 M
Depreciation-17,731 M-17,580 M
Depreciation unreconciled-19,041 M-20,279 M-21,540 M-21,642 M-21,748 M-21,593 M
DepreciationAndAmortization-19,041 M-20,279 M-21,540 M-21,642 M-21,748 M-21,593 M
Diluted EPS total1.542.071.6-0.020.020.14
Diluted normalized net income/share-0.03
Diluted weighted shares outstanding10,092 M7,358 M7,634 M30,282 M735,479 M646,912 M
DilutedDiscontinuousOperations0.020.17
Earnings from equity interest1,913 M533 M581 M-5,740 M3,671 M-7,378 M
EarningsFromEquityInterestNetOfTax1,913 M533 M581 M-5,740 M3,671 M-7,378 M
ExciseTaxes9,246 M
GainOnSaleOfBusiness234 M
GainOnSaleOfPPE119 M269 M-159 M58 M6,056 M77 M
GainOnSaleOfSecurity-295 M3,553 M627000.0932 M4,547 M
GainsLossOnDisposalOfDiscontinuedOperations6,586 M56,222 M
GeneralAndAdministrativeExpense13,556 M13,729 M13,269 M12,714 M12,190 M12,062 M
Gross operating profit36,019 M43,443 M42,690 M40,372 M27,262 M71,431 M
ImpairmentOfCapitalAssets-1,245 M-1,480 M-1,550 M-5,455 M-4,162 M-1,190 M
Income before tax10,852 M12,006 M8,775 M5,531 M8,498 M32,546 M
Income taxes4,274 M-3,225 M-3,438 M4,925 M1,673 M-1,227 M
Interest income3,941 M1,787 M2,464 M4,227 M560 M2,151 M
InterestExpenseNonOperating-9,246 M-9,707 M-10,402 M-10,482 M12,478 M-9,456 M
InterestExpenseOperating10,567 M
MinorityInterests2,053 M1,606 M1,299 M572 M
MiscOtherSpecialCharges5,973 M307 M-1,317 M492 M242 M42,705 M
Net income from total operations15,541 M15,231 M12,214 M606 M14,710 M90,568 M
NetIncomeCommonStockholders15,541 M15,231 M12,214 M606 M14,710 M90,568 M
NetIncomeContinuousOperations15,541 M15,231 M12,214 M606 M14,710 M90,568 M
NetIncomeDiscontinuousOperations6,586 M56,222 M
NetNonOperatingInterestIncomeExpense3,941 M1,787 M2,464 M4,227 M-11,918 M2,151 M
Operating income11,908 M18,690 M18,322 M6,810 M6,973 M49,946 M
Operating income before depreciation (EBITDA)20,142 M32,700 M19,382 M16,309 M1,498 M
OperatingExpense24,110 M24,753 M24,368 M33,562 M20,289 M21,485 M
Other income net-1,913 M-2,095 M12,011 M5,506 M-13,443 M7,378 M
Other special charges12,369 M
OtherGandA13,556 M13,729 M13,269 M12,714 M12,190 M12,062 M
OtherOperatingExpenses2,386 M10,482 M
RealizedCapitalGain234 M
SalariesAndWages-17,773 M-18,448 M-19,421 M-984 M-22,096 M-17,566 M
Selling Gen & administrative expense24,110 M24,753 M24,368 M23,080 M20,289 M21,485 M
SellingAndMarketingExpense10,554 M11,023 M11,099 M10,367 M8,100 M9,423 M
SellingExpense10,554 M11,023 M11,099 M10,367 M8,100 M9,423 M
Special income/charges1,245 M1,480 M1,550 M5,455 M4,162 M-12,173 M
Total Income available for interest expense (EBIT)1,606 M12,865 M-1,627 M-4,951 M20,976 M23,091 M
Total common shares outstanding342,337 M338,329 M337,244 M325,992 M329,296 M330,740 M
Total net income15,541 M15,231 M12,214 M606 M14,710 M90,568 M
Total ordinary shares565 M565 M565 M565 M565 M565 M
Total revenues98,799 M101,282 M101,757 M97,362 M73,915 M120,239 M
TotalExpenses-29,424 M82,592 M83,436 M90,552 M66,943 M70,292 M
TotalRevenue94,274 M101,282 M101,757 M97,362 M73,915 M120,239 M
WriteOff11,357 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