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

TS Stock Forecast, Price Targets, Chart, Dividends & Analysis

Sector:    

Industry: 

 
USD
  
  
()
Previous close:   Open:   Bid:   Ask:
52 week range    
   
   
Mkt Cap:   Avg Vol (90 Days):
Ad slot not ready
Search for a stock

Metrics

Valuation

Returns

Risk

Ranks

Dividends

Analyst Estimates

Financial Health

Technicals

Growth

Profitability

Peers

StockDividendMarket Cap (B)PEPrice ($)
Financials

TS Income Statement

Annual
Invalid dateDec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
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 M8,669 M
Depreciation-44 M-38 M-38 M41 M
Depreciation unreconciled-664 M-540 M-679 M-102 M-97 M82 M
DepreciationAndAmortization-664 M-540 M-679 M-102 M-97 M82 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 M95 M
EarningsFromEquityInterestNetOfTax116 M194 M82 M-526 M513 M209 M95 M
GainOnSaleOfBusiness3 M
GainOnSaleOfPPE118000.0
GainOnSaleOfSecurity876 M9 M55 M
GainsLossOnDisposalOfDiscontinuedOperations92 M
GeneralAndAdministrativeExpense-1,144 M-1,251 M-1,274 M-1,036 M-589 M-754 M929 M
Gross operating profit1,603 M2,379 M2,187 M1,059 M1,910 M4,675 M6,200 M
ImpairmentOfCapitalAssets622 M
Income before tax428 M2,016 M1,720 M-1,227 M1,243 M3,166 M4,803 M
Income taxes-17 M229 M202 M23 M189 M617 M845 M
Interest income592 M40 M48 M18 M38 M86 M213 M
InterestExpenseNonOperating27 M-24 M-46 M107 M
InterestExpenseOperating-18 M-32 M-31 M-29 M
InterestIncomeOperating50 M41 M31 M
MinorityInterests-8 M-2 M-11 M8 M47 M5 M-40 M
MiscOtherSpecialCharges11 M15 M23 M33 M68 M104 M149 M
Net income from total operations1,100 M1,785 M1,506 M-634 M1,100 M2,553 M3,918 M
NetIncomeCommonStockholders1,100 M1,785 M1,506 M-634 M1,100 M2,553 M3,918 M
NetIncomeContinuousOperations1,100 M1,785 M1,506 M-1,258 M2,130 M5,143 M3,958 M
NetIncomeDiscontinuousOperations92 M
NetNonOperatingInterestIncomeExpense549 M74 M63 M-38 M13 M10 M107 M
NetOperatingInterestIncomeExpense68 M72 M31 M29 M
Normalized income3,527 M
Operating income324 M857 M809 M-74 M766 M2,977 M4,449 M
Operating income before depreciation (EBITDA)1,018 M1,320 M2,229 M87 M1,861 M3,820 M5,459 M
OperatingExpense1,279 M1,523 M1,377 M1,133 M-1,144 M-1,697 M1,750 M
Other income net-127 M-1,085 M-848 M492 M-463 M-179 M-247 M
Other special charges-7 M-14 M
OtherCostofRevenue8,669 M
OtherGandA-1,144 M-1,251 M-1,274 M-1,036 M-589 M-754 M929 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 M41 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 M1,668 M
SellingAndMarketingExpense1,270 M1,510 M1,366 M1,119 M-416 M-642 M739 M
Special income/charges-743 M622 M64 M90 M
Total Income available for interest expense (EBIT)410 M1,985 M1,689 M-592 M1,266 M3,212 M4,910 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-634 M1,100 M2,553 M3,918 M
Total ordinary shares584 M584 M584 M584 M584 M584 M584 M
Total revenues5,289 M7,659 M7,294 M5,147 M6,521 M11,763 M14,869 M
TotalExpenses-2,406 M6,802 M6,485 M5,221 M5,825 M8,827 M10,419 M
TotalRevenue5,289 M7,659 M7,294 M5,147 M6,521 M11,763 M14,869 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