Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
The Hain Celestial Group Inc. logo

The Hain Celestial Group Inc.

Sector: Consumer Defensive   

Industry: Packaged Foods

Optionable: Yes  Market Cap: 633 M  90-day average vol: 1,430,875

Previous close: 7.05  Open: 6.96  Bid: 6.86  Ask: 6.92
52 week range    
GIS / 
CPB / 
THS / 
Last updated: Thursday 30th May 2024
MarketXLS Rank

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



StockDividendMarket Cap (B)PEPrice ($)


0.03413 B14.143.54


0.029941 B18.968.14


0.020993 B2267.48


0.028915 B20.1137.1


2 B4336.14

HAIN Income Statement

AcquisitionExpense21 M
Amortization of intangibles16 M18 M19 M17 M18 M13 M12 M9 M10 M10 M
Basic EPS from continuing operations1.451.620.460.630.79-0.480.250.660.84-1.3
Basic EPS total1.431.620.460.650.09-1.76-0.770.770.84-1.3
Basic weighted shares outstanding98 M102 M103 M104 M104 M104 M104 M100 M93 M89 M
Cost of sales-1,586 M-2,047 M-2,271 M-1,824 M-1,798 M1,706 M1,588 M1,479 M1,464 M1,400 M
Depreciation-57 M-38 M-34 M-34 M29 M31 M34 M47 M51 M
Depreciation unreconciled16 M18 M19 M17 M18 M13 M12 M9 M10 M10 M
DepreciationAndAmortization16 M18 M19 M17 M18 M13 M12 M9 M10 M10 M
DevelopmentExpense27 M
Diluted EPS total1.41.60.460.650.09-1.76-0.770.760.83-1.3
Diluted normalized net income/share1.421.60.460.630.79-0.480.250.650.83-1.3
Diluted weighted shares outstanding100 M103 M104 M104 M104 M104 M104 M101 M93 M89 M
Earnings from equity interest4 M628000.0-47000.0129000.0339000.0-655000.0-2 M-2 M-3 M-1 M
EarningsFromEquityInterestNetOfTax4 M628000.0-47000.0129000.0339000.0-655000.0-2 M-2 M-3 M-1 M
ExciseTaxes25 M
GainOnSaleOfBusiness10 M
GainOnSaleOfPPE5 M9 M4 M
GainOnSaleOfSecurity2 M311000.0-21000.0
GeneralAndAdministrativeExpense-30 M-32 M-34 M30 M9 M318 M324 M302 M300 M289 M
Gross operating profit567 M563 M565 M519 M515 M398 M466 M492 M427 M396 M
ImpairmentOfCapitalAssets-6 M85 M8 M394000.02 M176 M
Income before tax208 M213 M87 M88 M81 M-56 M34 M109 M103 M-130 M
Income restructuring and M&A-4 M-462856.0-10 M-4 M-3 M-592000.0-196000.0-9 M
Income taxes70 M49 M71 M22 M-887000.0-3 M6 M41 M23 M-14 M
InterestExpenseNonOperating10 M44 M
InterestExpenseOperating-21 M-23 M-24 M-19 M-24 M-20 M-16 M-6 M-10 M-42 M
MiscOtherSpecialCharges6 M-5 M-17 M-430000.02 M-994000.0-4 M10 M11 M2 M
Net income from total operations141 M165 M47 M66 M82 M-183 M-80 M77 M78 M-117 M
NetIncomeCommonStockholders141 M165 M47 M66 M82 M110 M141 M106 M111 M-56 M
NetIncomeContinuousOperations141 M165 M47 M66 M82 M-183 M-80 M77 M78 M-117 M
NetIncomeDiscontinuousOperations2 M-73 M-130 M-106 M11 M
NetNonOperatingInterestIncomeExpense-10 M-44 M
NonRecurringOperationExpense-6 M
Normalized income116 M19 M
Operating income208 M208 M253 M129 M128 M-32 M56 M107 M105 M-86 M
Operating income before depreciation (EBITDA)235 M247 M128 M129 M118 M-26 M70 M152 M151 M-77 M
OperatingExpense360 M355 M336 M391 M388 M261 M287 M296 M301 M292 M
Other income net-4 M-6 M60 M41 M39 M35 M33 M49 M-8 M-688000.0
Other special charges-1 M15 M
OtherGainLossFromDispositionOfDiscontinuedOperations-130 M-106 M11 M
OtherGandA-30 M-32 M-34 M30 M9 M318 M324 M302 M300 M289 M
OtherImpairmentOfCapitalAssets43 M40 M14 M34 M27 M58 M1 M
OtherOperatingExpenses-6 M-4 M-217000.0-118000.0-248000.0-636000.0-343000.0-273000.0-2 M
OtherWriteDown27 M
PromotionAndAdvertising-16 M26 M-27 M-30 M-35 M23 M19 M21 M41 M39 M
RentAndLandingFees-21 M-27 M-34 M-35 M-36 M37 M
Research & development expense-10 M-10 M-11 M-10 M-10 M11 M12 M10 M9 M6 M
ResearchExpense11 M12 M10 M9 M6 M
RestructringAndMnAIncome-4 M-462856.0-10 M-4 M-3 M-592000.0-196000.0-9 M
Revenue per share16 M18 M19 M17 M18 M13 M12 M9 M10 M10 M
SalariesAndWages13 M8 M13 M10 M19 M-70 M-49 M-16 M-10 M-7 M
SecuritiesAmortization20 M21 M
Selling Gen & administrative expense311 M329 M304 M342 M351 M318 M324 M302 M300 M289 M
SellingAndMarketingExpense311 M329 M304 M313 M342 M23 M19 M21 M41 M39 M
SellingExpense311 M303 M304 M313 M342 M
Special income/charges4 M7 M-75 M-8 M4 M3 M592000.0-2 M-176 M
Total Income available for interest expense (EBIT)187 M190 M63 M69 M57 M-76 M18 M103 M104 M-127 M
Total common shares outstanding201 M205 M207 M207 M208 M208 M102 M97 M89 M89 M
Total net income141 M165 M47 M66 M82 M-183 M-80 M77 M78 M-117 M
Total ordinary shares90 M90 M90 M90 M90 M90 M90 M90 M90 M90 M
Total revenues2,154 M2,610 M2,885 M2,344 M2,458 M2,105 M2,054 M1,970 M1,892 M1,797 M
TotalExpenses-1,227 M-1,692 M-1,935 M-1,433 M-1,411 M1,967 M1,875 M1,774 M1,765 M1,692 M
TotalRevenue2,154 M2,610 M2,885 M2,344 M2,458 M2,105 M2,054 M1,970 M1,892 M1,797 M
WriteDown-5 M-23 M-3 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