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

TKR Income Statement

AcquiredInProcessRnD-60 M
Amortization of intangibles-21 M-36 M-36 M-40 M-47 M57 M56 M55 M44 M66 M
Basic EPS from continuing operations3.51-1.681.792.623.934.783.784.865.545.52
Basic EPS total3.78-1.681.792.623.934.783.784.865.545.52
Basic weighted shares outstanding90 M85 M79 M78 M77 M76 M75 M76 M74 M71 M
Cost of sales-2,178 M2,078 M1,975 M2,193 M2,541 M2,648 M2,503 M3,030 M3,165 M3,260 M
Depreciation-137 M-131 M-132 M-138 M-146 M161 M167 M168 M164 M201 M
Depreciation unreconciled-158 M-167 M-168 M-178 M-193 M219 M225 M225 M44 M66 M
Diluted EPS total3.74-1.681.782.583.864.713.724.795.485.47
Diluted normalized net income/share3.74-1.681.782.583.864.713.724.795.485.47
Diluted weighted shares outstanding91 M85 M79 M79 M78 M77 M76 M77 M74 M72 M
Dividends paid per share1.
Earnings from equity interest-2 M
EarningsFromEquityInterestNetOfTax-2 M
Fees3 M
GainOnSaleOfBusiness29 M-800000.0500000.0-3 M3 M
GainOnSaleOfPPE23 M0.0
GainOnSaleOfSecurity19 M462 M-100000.010 M-10 M
GainsLossOnDisposalOfDiscontinuedOperations24 M0.0
GeneralAndAdministrativeExpense-33 M-33 M-30 M-35 M-36 M
Gross operating profit898 M2,407 M2,668 M3,004 M3,581 M1,142 M1,010 M1,103 M1,332 M1,509 M
ImpairmentOfCapitalAssets-99 M-3 M-4 M-100000.0-1 M3 M33 M
Income before tax204 M1,889 M2,203 M2,452 M2,949 M472 M396 M477 M551 M531 M
Income restructuring and M&A113 M15 M22 M4 M5 M7 M10 M8 M44 M46 M
Income taxes55 M-122 M61 M58 M103 M98 M104 M95 M134 M123 M
Interest income4 M3 M2 M3 M2 M5 M4 M2 M4 M9 M
InterestExpenseNonOperating29 M33 M34 M37 M52 M72 M68 M59 M75 M111 M
InterestExpenseOperating-2 M-1 M-700000.0-400000.0-1 M-1 M-3 M-1000000.0-200000.0
MinorityInterests147 M-71 M-300000.01 M-3 M-13 M-8 M-12 M-10 M-14 M
MiscOtherSpecialCharges-3 M-7 M-900000.0-5 M3 M23 M-6 M19 M15 M-25 M
Net income from total operations296 M1,940 M2,142 M2,395 M2,844 M362 M285 M369 M407 M394 M
NetIncomeCommonStockholders296 M1,940 M2,142 M2,395 M2,844 M3,010 M2,788 M369 M407 M394 M
NetIncomeContinuousOperations296 M1,940 M2,142 M2,395 M2,844 M362 M285 M369 M407 M394 M
NetIncomeDiscontinuousOperations24 M
NetNonOperatingInterestIncomeExpense-24 M-31 M-32 M-34 M-50 M-67 M-64 M-56 M-71 M-101 M
NetOperatingInterestIncomeExpense2 M1 M700000.0400000.01 M2 M3 M1000000.0200000.0
Normalized income495 M
Operating income322 M1,913 M2,198 M2,496 M3,000 M516 M455 M513 M607 M657 M
Operating income before depreciation (EBITDA)368 M2,053 M2,367 M2,626 M3,146 M704 M630 M701 M789 M842 M
OperatingExpense543 M494 M471 M508 M581 M619 M534 M581 M681 M807 M
Other income net-20 M-21 M900000.05 M-3 M-23 M6 M-19 M-15 M25 M
OtherGandA-33 M-33 M-30 M-35 M-36 M
OtherImpairmentOfCapitalAssets98 M-3 M-4 M
OtherOperatingExpenses400000.012 M5 M12 M6 M37 M36 M34 M30 M34 M
OtherTaxes11 M1000000.08 M5 M5 M
RentAndLandingFees-33 M-33 M-30 M-35 M-36 M
Research & development expense-39 M-33 M-32 M-35 M-37 M41 M
ResearchExpense-33 M-32 M-35 M-37 M41 M
RestructringAndMnAIncome113 M15 M22 M4 M5 M7 M10 M8 M44 M46 M
SalariesAndWages-110 M-1,100 M-84 M0.0-7 M-600000.027 M
Selling Gen & administrative expense543 M494 M471 M508 M581 M619 M534 M581 M637 M741 M
SellingAndMarketingExpense543 M494 M471 M508 M581 M619 M534 M581 M637 M741 M
Special income/charges113 M15 M22 M4 M5 M7 M10 M8 M44 M46 M
Total Income available for interest expense (EBIT)231 M1,922 M2,235 M2,488 M3,000 M543 M462 M533 M625 M641 M
Total common shares outstanding88 M80 M78 M78 M76 M151 M76 M75 M72 M70 M
Total net income296 M1,940 M2,142 M2,395 M2,844 M362 M285 M369 M407 M394 M
Total ordinary shares70 M70 M70 M70 M70 M70 M70 M70 M70 M70 M
Total revenues3,043 M2,407 M2,668 M3,004 M3,581 M3,790 M3,513 M4,133 M4,497 M4,769 M
TotalExpenses-1,636 M494 M471 M508 M581 M3,267 M3,037 M3,611 M3,846 M4,066 M
TotalRevenue3,076 M2,407 M2,668 M3,004 M3,581 M3,790 M3,513 M4,133 M4,497 M4,769 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