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







Analyst Estimates

Financial Health





StockDividendMarket Cap (B)PEPrice ($)

TS Income Statement

Invalid dateDec-17Dec-18Dec-19Dec-20Dec-21Dec-22
AcquiredInProcessRnD-743 M
AcquiredInProcessRnDIncome743 M
Amortization of intangibles-64 M-59 M
Basic EPS from continuing operations0.841.481.26-0.54
Basic EPS total0.841.481.26-0.540.932.16
Basic weighted shares outstanding1,181 M1,181 M1,181 M1 M1 M1,181 M
Cost of sales-3,685 M5,279 M5,107 M4,087 M4,612 M7,088 M
Depreciation-44 M-38 M-38 M
Depreciation unreconciled-664 M-540 M-679 M-102 M-97 M
DepreciationAndAmortization-664 M-540 M-679 M-102 M-97 M
Diluted EPS total0.461.481.26-0.540.932.16
Diluted weighted shares outstanding2,391 M1,181 M1,181 M1 M1 M1,181 M
Earnings from equity interest116 M194 M82 M-526 M513 M209 M
EarningsFromEquityInterestNetOfTax116 M194 M82 M-526 M513 M209 M
GainOnSaleOfSecurity876 M9 M55 M
GainsLossOnDisposalOfDiscontinuedOperations92 M
GeneralAndAdministrativeExpense-1,144 M-1,251 M-1,274 M-1,036 M-589 M-754 M
Gross operating profit1,603 M2,379 M2,187 M1,059 M1,910 M4,675 M
ImpairmentOfCapitalAssets622 M
Income before tax428 M2,016 M1,720 M-1,227 M1,243 M3,166 M
Income taxes-17 M229 M202 M23 M189 M617 M
Interest income592 M40 M48 M18 M38 M86 M
InterestExpenseNonOperating-24 M-46 M
InterestExpenseOperating-18 M-32 M-31 M-29 M
InterestIncomeOperating50 M41 M31 M
MinorityInterests-8 M-2 M-11 M-8 M-47 M-5 M
MiscOtherSpecialCharges11 M15 M23 M33 M68 M104 M
Net income from total operations1,100 M1,785 M1,506 M-1,258 M2,130 M5,143 M
NetIncomeCommonStockholders1,100 M1,785 M1,506 M-1,258 M1,100 M2,553 M
NetIncomeContinuousOperations1,100 M1,785 M1,506 M-1,258 M2,130 M5,143 M
NetIncomeDiscontinuousOperations92 M
NetNonOperatingInterestIncomeExpense549 M74 M63 M-38 M13 M10 M
NetOperatingInterestIncomeExpense68 M72 M31 M29 M
Operating income324 M857 M809 M-74 M766 M2,977 M
Operating income before depreciation (EBITDA)1,018 M1,320 M2,229 M-577 M2,940 M6,340 M
OperatingExpense1,279 M1,523 M1,377 M1,133 M-1,144 M-1,697 M
Other income net-127 M-1,085 M-848 M492 M-463 M-179 M
Other special charges-7 M-14 M
OtherGandA-1,144 M-1,251 M-1,274 M-1,036 M-589 M-754 M
OtherOperatingExpenses9 M13 M11 M14 M2 M-83 M
OtherTaxes-43 M-121 M
RealizedCapitalGain876 M
Research & development expense-64 M-63 M-61 M-42 M
Revenue per share-64 M-59 M
SalariesAndWages-1,221 M-1,326 M-1,352 M-1,202 M-426 M-518 M
Selling Gen & administrative expense1,270 M1,510 M1,366 M1,119 M-1,005 M-1,396 M
SellingAndMarketingExpense1,270 M1,510 M1,366 M1,119 M-416 M-642 M
Special income/charges-743 M622 M64 M90 M
Total Income available for interest expense (EBIT)410 M1,985 M1,689 M-1,255 M2,345 M5,732 M
Total common shares outstanding1,181 M1,181 M1,181 M1,181 M1,181 M1,181 M
Total net income1,100 M1,785 M1,506 M-1,258 M2,130 M5,143 M
Total ordinary shares590 M590 M590 M590 M590 M590 M
Total revenues5,289 M7,659 M7,294 M5,147 M6,521 M11,763 M
TotalExpenses-2,406 M6,802 M6,485 M5,221 M5,825 M8,827 M
TotalRevenue5,289 M7,659 M7,294 M5,147 M6,521 M11,763 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