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

OLN Income Statement

AcquiredInProcessRnDIncome34 M
Amortization of intangibles1,421 M1,421 M
Basic EPS from continuing operations2.241.33-0.01-
Basic EPS total2.241.34-0.39-0.023.311.97-0.07-
Basic weighted shares outstanding80 M79 M103 M165 M166 M167 M162 M158 M159 M145 M
Cost of sales-2,034 M-1,853 M-2,487 M-4,944 M-5,555 M-5,822 M-5,439 M-5,375 M6,616 M7,194 M
Depreciation-135 M-139 M-229 M-533 M-559 M-601 M-597 M-568 M583 M599 M
DepreciationAndAmortization-135 M-139 M-229 M-533 M-559 M-601 M-597 M-568 M583 M599 M
Diluted EPS total2.211.33-0.390.13.261.95-0.07-6.147.968.94
Diluted normalized net income/share2.211.32-0.01-0.027.968.94
Diluted weighted shares outstanding81 M80 M103 M165 M169 M168 M162 M158 M163 M149 M
Dividends paid per share0.
Earnings from equity interest3 M2 M2 M2 M2 M-20 M11 M
EarningsFromEquityInterestNetOfTax3 M2 M2 M2 M2 M-20 M11 M
GainOnSaleOfBusiness1 M4 M22 M3 M2 M
GainOnSaleOfPPE-1 M200000.0-600000.0-700000.03 M2 M-800000.0-1 M-13 M
GainOnSaleOfSecurity-200000.0-47 M
GeneralAndAdministrativeExpense-64 M-67 M-75 M-95 M-118 M-122 M-123 M-122 M417 M394 M
Gross operating profit482 M390 M413 M638 M717 M1,130 M671 M384 M2,294 M2,182 M
ImpairmentOfCapitalAssets700 M
Income before tax250 M163 M7 M-34 M117 M437 M-37 M-1,020 M1,539 M1,676 M
Income restructuring and M&A6 M16 M3 M113 M38 M22 M77 M9 M28 M25 M
Income taxes71 M58 M8 M-30 M-432 M109 M-26 M-50 M242 M349 M
Interest income600000.01 M1 M3 M2 M2 M1000000.0500000.0200000.02 M
InterestExpenseNonOperating39 M44 M97 M192 M217 M243 M243 M293 M348 M144 M
MiscOtherSpecialCharges-1 M100000.016 M9 M10 M7 M28 M19 M36 M39 M
Net income from total operations179 M106 M-1 M-4 M550 M328 M-11 M-970 M1,297 M1,327 M
NetIncomeCommonStockholders179 M106 M-1 M-4 M550 M328 M-11 M-970 M1,297 M1,327 M
NetIncomeContinuousOperations179 M106 M-1 M-4 M550 M328 M-11 M-970 M1,297 M1,327 M
NetIncomeDiscontinuousOperations700000.05 M5 M2 M2 M1 M700000.0
NetNonOperatingInterestIncomeExpense-38 M-42 M-96 M-188 M-216 M-242 M-242 M-292 M-348 M-142 M
NonRecurringOperationExpense-57 M-11 M
Normalized income1,243 M1,346 M
Operating income292 M223 M227 M314 M347 M700 M254 M-38 M1,851 M1,779 M
Operating income before depreciation (EBITDA)424 M346 M333 M691 M894 M1,282 M804 M-159 M2,469 M2,419 M
OperatingExpense190 M166 M186 M323 M370 M431 M417 M422 M417 M394 M
Other income net-1 M2 M122 M47 M-23 M-1000000.0-27 M-19 M-36 M-39 M
Other special charges-1 M-16 M
OtherGandA-64 M-67 M-75 M-95 M-118 M-122 M-123 M-122 M417 M394 M
OtherOperatingExpenses-2 M-256 M-46 M-11 M-4 M-162 M-94 M-96 M-205 M-670 M
ProvisionForGainLossOnDisposal200000.05 M5 M2 M2 M1 M700000.0
RealizedCapitalGain16 M
RentAndLandingFees-64 M-67 M-75 M-95 M-118 M-122 M
RestructringAndMnAIncome6 M16 M3 M113 M38 M22 M77 M9 M28 M25 M
Revenue per share-15 M-15 M-26 M-74 M-63 M-63 M-63 M-63 M1,484 M1,476 M
SalariesAndWages-15 M-16 M-19 M-11 M-19 M-19 M-9 M-17 M-27 M-33 M
Selling Gen & administrative expense190 M166 M186 M323 M370 M431 M417 M422 M417 M394 M
SellingAndMarketingExpense190 M166 M186 M323 M370 M431 M417 M422 M
SellingExpense190 M166 M186 M323 M370 M431 M417 M422 M
Special income/charges-5 M-16 M-3 M-113 M-38 M-22 M-76 M-709 M-26 M-9 M
Total Income available for interest expense (EBIT)289 M207 M104 M158 M335 M681 M206 M-727 M1,887 M1,820 M
Total common shares outstanding79 M77 M165 M165 M167 M165 M158 M158 M156 M132 M
Total net income179 M106 M-1 M-4 M550 M328 M-11 M-970 M1,297 M1,327 M
Total ordinary shares119 M119 M119 M119 M119 M119 M119 M119 M119 M119 M
Total revenues2,516 M2,243 M2,900 M5,561 M6,272 M6,953 M6,110 M5,759 M8,911 M9,376 M
TotalExpenses-1,844 M-1,687 M-2,300 M-4,621 M-5,185 M-5,391 M-5,022 M-4,953 M7,033 M7,588 M
TotalRevenue2,515 M2,241 M2,854 M5,551 M6,268 M6,946 M6,110 M5,758 M8,911 M9,376 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