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

IR Income Statement

Invalid dateDec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
AllowancesForConstruction1,677 M3,994 M
Amortization of intangibles119 M126 M124 M335 M333 M348 M368 M
Basic EPS from continuing operations1.340.78-
Basic EPS total0.11.340.78-0.091.361.491.92
Basic weighted shares outstanding182 M202 M204 M383 M415 M405 M405 M
Cost of sales1,478 M1,677 M1,540 M2,568 M3,164 M3,591 M3,994 M
Depletion3,591 M
Depreciation-174 M180 M178 M2,568 M422 M433 M459 M
Depreciation unreconciled119 M126 M124 M2,903 M333 M348 M368 M
DepreciationAndAmortization119 M126 M124 M2,903 M333 M348 M368 M
Diluted EPS total0.11.290.76-0.091.341.481.9
Diluted normalized net income/share1.290.76-
Diluted weighted shares outstanding188 M209 M209 M383 M421 M410 M409 M
Earnings from equity interest-11 M700000.0-6 M
EarningsFromEquityInterestNetOfTax-11 M700000.0-6 M
GainOnSaleOfPPE-800000.01 M-800000.0
GainOnSaleOfSecurity-9 M
GeneralAndAdministrativeExpense435 M436 M789 M4,192 M4,687 M1,273 M
Gross operating profit898 M1,013 M912 M1,405 M1,989 M2,326 M2,882 M
ImpairmentOfCapitalAssets-2 M3,297 M
Income before tax-113 M350 M191 M-45 M513 M742 M1,031 M
Income restructuring and M&A-57 M-52 M-43 M-42 M-64 M-95 M-105 M
Income taxes-131 M80 M32 M11 M-22 M150 M240 M
InterestExpenseNonOperating141 M100 M89 M111 M88 M103 M157 M
InterestExpenseOperating3,164 M
MinorityInterests-100000.01,676 M1,870 M-900000.0-2 M-4 M-6 M
MiscOtherSpecialCharges-81 M6 M5 M6 M35 M28 M24 M
Net income from total operations19 M269 M159 M-33 M563 M605 M779 M
NetIncomeCommonStockholders18 M269 M159 M-33 M563 M605 M779 M
NetIncomeContinuousOperations19 M269 M159 M-33 M563 M605 M779 M
NetIncomeDiscontinuousOperations24 M42 M15 M
NetNonOperatingInterestIncomeExpense-141 M-100 M-89 M-111 M-88 M-103 M-157 M
Normalized income1,806 M1,514 M-23 M724 M
Operating income111 M443 M275 M60 M566 M817 M1,164 M
Operating income before depreciation (EBITDA)202 M630 M458 M478 M1,023 M1,278 M1,647 M
OperatingExpense787 M570 M636 M3,894 M4,587 M5,099 M1,718 M
Other income net83 M-6 M-4 M14 M-24 M-29 M3,976 M
Other special charges200000.040 M33 M36 M12 M
OtherGainLossFromDispositionOfDiscontinuedOperations24 M42 M15 M
OtherGandA435 M436 M789 M4,192 M4,687 M1,273 M
OtherImpairmentOfCapitalAssets2 M20 M
OtherOperatingExpenses222 M9 M76 M201 M62 M65 M78 M
OtherWriteOff-5 M2 M2 M4 M4 M3 M3 M
Research & development expense-26 M24 M25 M58 M74 M91 M108 M
ResearchExpense24 M25 M58 M74 M91 M108 M
RestructringAndMnAIncome-57 M-52 M-43 M-42 M-64 M-95 M-105 M
Revenue per share119 M126 M124 M335 M333 M348 M368 M
SalariesAndWages-175 M3 M19 M48 M87 M79 M52 M
Selling Gen & administrative expense446 M435 M436 M789 M4,192 M4,687 M1,273 M
SellingAndMarketingExpense446 M
SellingExpense446 M
Special income/charges57 M-1,677 M43 M2 M31 M59 M93 M
Total Income available for interest expense (EBIT)28 M449 M280 M66 M601 M845 M1,188 M
Total common shares outstanding196 M199 M205 M419 M408 M405 M403 M
Total net income19 M269 M159 M-33 M563 M605 M779 M
Total ordinary shares403 M403 M403 M403 M403 M403 M403 M
Total revenues2,375 M2,690 M2,452 M3,973 M5,152 M5,916 M6,876 M
TotalExpenses2,265 M2,247 M2,177 M6,462 M7,751 M8,690 M5,712 M
TotalRevenue2,375 M2,690 M2,452 M3,973 M5,152 M5,916 M6,876 M
WriteOff1,677 M1,540 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