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

SP Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Amortization of intangibles-15 M-15 M-15 M-7 M-6 M-15 M-13 M527 M543 M545 M
Basic EPS from continuing operations1.52.171.58
Basic EPS total1.050.781.041.862.382.21-8.211.52.171.58
Basic weighted shares outstanding22 M22 M22 M22 M22 M22 M21 M21 M21 M20 M
Cost of sales-1,343 M-1,402 M-1,392 M-1,405 M-1,284 M-1,436 M-1,056 M997 M1,332 M1,528 M
Depreciation30 M34 M34 M21 M18 M29 M29 M25 M30 M36 M
Depreciation unreconciled30 M34 M34 M21 M18 M29 M29 M25 M30 M36 M
DepreciationAndAmortization30 M34 M34 M21 M18 M29 M29 M25 M30 M36 M
Diluted EPS total1.030.771.031.832.352.2-8.211.482.151.57
Diluted normalized net income/share1.482.151.57
Diluted weighted shares outstanding22 M23 M23 M23 M23 M22 M21 M21 M21 M20 M
Earnings from equity interest2 M2 M2 M11 M3 M3 M1 M1 M5 M3 M
EarningsFromEquityInterestNetOfTax2 M2 M2 M11 M3 M3 M1 M1 M5 M3 M
GainOnSaleOfBusiness500000.0100000.0300000.0
GeneralAndAdministrativeExpense102 M97 M90 M83 M91 M109 M85 M88 M109 M140 M
Gross operating profit171 M170 M176 M185 M184 M228 M1,087 M180 M222 M254 M
ImpairmentOfCapitalAssets135 M
Income before tax26 M25 M42 M72 M76 M71 M-240 M46 M66 M49 M
Income restructuring and M&A-41 M-55 M
Income taxes-200000.05 M16 M28 M20 M19 M989 M11 M18 M14 M
Interest income4 M-2 M-900000.0-700000.010 M300000.0500000.0400000.0400000.0300000.0
InterestExpenseNonOperating18 M13 M11 M9 M10 M19 M22 M21 M18 M29 M
InterestIncomeOperating41 M
LossAndLossAdjustmentExpectedIncurred-6 M
MinorityInterests-3 M-3 M-3 M-3 M-3 M-3 M100000.0-4 M-3 M-4 M
MiscOtherSpecialCharges497 M571 M546 M600000.0400000.019 M200000.0100000.0
Net income from total operations194 M188 M200 M41 M53 M49 M-173 M32 M45 M31 M
NetIncomeCommonStockholders194 M188 M200 M41 M53 M49 M-173 M32 M45 M31 M
NetIncomeContinuousOperations194 M188 M200 M41 M53 M49 M-173 M32 M45 M31 M
NetNonOperatingInterestIncomeExpense-14 M-14 M-11 M-10 M500000.0-19 M-21 M-21 M-17 M-29 M
Normalized income42 M
Operating income-286 M-362 M-316 M81 M75 M90 M972 M67 M83 M78 M
Operating income before depreciation (EBITDA)76 M73 M86 M102 M105 M119 M-190 M92 M113 M114 M
OperatingExpense132 M131 M124 M104 M109 M138 M115 M113 M139 M177 M
Other income net-497 M-572 M-545 M-700000.0-400000.0-22 M-200000.0-100000.0-900000.0500000.0
OtherGandA102 M97 M90 M83 M91 M109 M85 M88 M109 M140 M
OtherImpairmentOfCapitalAssets-97 M4 M4 M
OtherOperatingExpenses-151 M-81 M120 M164 M173 M
OtherWriteOff-200000.0-3 M2 M3 M
PromotionAndAdvertising-1 M-2 M-1 M-1 M-1 M
RentAndLandingFees102 M97 M90 M83 M91 M109 M85 M
RestructringAndMnAIncome-41 M-55 M
Revenue per share-18 M-18 M-18 M-10 M-9 M-17 M-17 M532 M549 M551 M
SalariesAndWages-200000.0-200000.0200000.0200000.0200000.0
Selling Gen & administrative expense102 M97 M90 M83 M91 M109 M85 M88 M109 M140 M
SellingAndMarketingExpense-1 M-2 M-1 M-1 M-1 M
Special income/charges6 M900000.041 M55 M-135 M
Total Income available for interest expense (EBIT)44 M38 M52 M81 M86 M90 M-219 M67 M83 M78 M
Total common shares outstanding22 M22 M22 M23 M23 M23 M23 M23 M19 M20 M
Total net income194 M188 M200 M41 M53 M49 M-173 M32 M45 M31 M
Total ordinary shares20 M20 M20 M20 M20 M20 M20 M20 M20 M20 M
Total revenues1,059 M1,083 M1,063 M1,591 M1,468 M1,664 M1,087 M1,177 M1,554 M1,782 M
TotalExpenses-1,212 M-1,270 M-1,268 M-1,301 M-1,175 M-1,297 M115 M1,111 M1,471 M1,705 M
TotalRevenue1,515 M1,572 M1,568 M1,591 M1,468 M1,664 M1,087 M1,177 M1,554 M1,782 M
WriteDown-6 M-900000.0
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