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

6.09
 
USD
  
-0.08
  
(-1.30%)
Optionable: Yes  Market Cap: 555 M  90-day average vol: 1,345,351

Previous close: 6.17  Open: 6.13  Bid: 5.5  Ask: 6.3
52 week range    
5.69   
   18.25
Peers   
GIS / 
MDLZ / 
CPB / 
THS / 
Last updated: Friday 26th April 2024
38
MarketXLS Rank
60
Value
23
Technical
31
Quality

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

Financials

HAIN Balance Sheet

Annual
Jun-14Jun-15Jun-16Jun-17Jun-18Jun-19Jun-20Jun-21Jun-22Jun-23
"""debtc"""100 M31 M27 M10 M27 M17 M2 M530000.08 M8 M
Accounts payable239 M274 M252 M186 M230 M220 M171 M172 M175 M135 M
Accounts receivable288 M263 M279 M226 M253 M210 M171 M174 M171 M161 M
Accrued expenses324 M360 M331 M293 M346 M334 M295 M290 M262 M223 M
Accumulated depreciation & depletion-166 M-185 M-212 M-227 M-246 M-218 M-225 M-231 M-233 M-242 M
Additional paid in capital969 M1,072 M1,123 M1,138 M1,148 M1,158 M1,172 M1,188 M1,203 M1,218 M
Building & improvements76 M89 M
Cash and equivalents124 M167 M128 M137 M107 M31 M38 M76 M66 M53 M
CashCashEquivalentsAndShortTermInvestments124 M167 M128 M137 M107 M31 M38 M76 M66 M53 M
CashEquivalents32 M45 M21 M137 M107 M31 M7000.0
Common par1 M1 M1 M1 M1 M1 M1 M1 M1 M1 M
Common stock equity1,620 M1,772 M1,665 M1,713 M1,737 M1,519 M1,444 M1,523 M1,083 M1,018 M
CommonStock1 M1 M1 M1 M1 M1 M1 M1 M1 M1 M
Construction in progress5 M11 M
Cost in excess1,134 M1,136 M1,060 M1,019 M1,024 M876 M862 M871 M934 M939 M
CurrentAccruedExpenses85 M86 M79 M107 M116 M114 M124 M118 M87 M89 M
CurrentCapitalLeaseObligation3 M4 M16 M19 M16 M19 M12 M11 M13 M10 M
CurrentDeferredAssets24 M39 M
CurrentDeferredTaxesAssets24 M39 M
CurrentDeferredTaxesLiabilities-143 M154 M146 M125 M97 M79 M-77 M-70 M-119 M-74 M
DerivativeProductLiabilities6 M12 M3 M3 M
Finished goods191 M261 M238 M215 M232 M200 M158 M188 M203 M192 M
Float term debt768 M813 M836 M740 M688 M614 M364 M316 M988 M911 M
GoodwillAndOtherIntangibleAssets1,786 M1,782 M1,665 M1,540 M1,535 M1,256 M1,208 M1,186 M1,411 M1,237 M
Gross fixed assets (Plant Property & Equipment)477 M538 M602 M519 M556 M506 M603 M635 M646 M634 M
Intangibles651 M646 M605 M521 M510 M380 M346 M315 M478 M298 M
InterestPayable-10 M-44 M
Inventories320 M397 M409 M342 M392 M299 M248 M285 M308 M310 M
InventoriesAdjustmentsAllowances-5 M-12 M-4 M-421000.0-351000.0
Invested capital2,388 M2,584 M2,501 M2,461 M2,432 M2,138 M2,089 M2,070 M2,953 M2,750 M
Land & improvements34 M36 M
Leases691000.0547000.0413000.0289000.0
LongTermCapitalLeaseObligation118 M83 M86 M107 M90 M
LongTermDebtAndCapitalLeaseObligation768 M813 M836 M740 M688 M614 M364 M316 M988 M911 M
Machinery furniture & equipment330 M359 M
Net fixed assets (net PP&E)311 M354 M390 M292 M310 M288 M377 M405 M412 M392 M
NetOtherUnrealizedGainLoss9 M4 M
Non-current deferred income taxes148 M151 M132 M98 M87 M35 M52 M43 M95 M72 M
NonCurrentDeferredLiabilities148 M151 M132 M98 M87 M35 M52 M43 M95 M72 M
NonCurrentDeferredTaxesAssets27000.011 M15 M15 M21 M35 M-42 M-37 M-37 M-53 M
Number of employees3078.03078.03078.03078.03078.03078.03078.03078.03078.03078.0
Other current assets2 M11 M16 M124 M241 M110 M8 M2 M2 M1 M
Other equity adjustments60 M-42 M-172 M-195 M-184 M-225 M
Other fixed assets377 M405 M412 M392 M
Other non-current assets29 M33 M33 M205 M30 M318 M24 M21 M20 M26 M
Other non-current liabilities5 M17 M19 M16 M13 M14 M29 M34 M22 M27 M
Other receivable2,458 M2,105 M2,054 M1,970 M1,892 M1,797 M
OtherCurrentLiabilities9 M2 M4 M38 M50 M32 M4 M
OtherInventories248 M285 M308 M310 M
OtherPayable177 M105 M157 M20 M12 M260 M
Payables239 M274 M252 M186 M230 M220 M171 M172 M175 M135 M
Preferred securities of subsidiary trust5 M5 M5 M5 M5 M5 M
PreferredStock5 M5 M5 M5 M5 M5 M
Prepaid expenses48 M63 M85 M46 M60 M51 M96 M40 M54 M65 M
RecievablesAdjustmentsAllowances-896000.0-936000.0-2 M-588000.0-638000.0-1 M-2 M-3 M
Retained earnings630 M754 M801 M869 M879 M695 M443 M618 M605 M526 M
Short term debt100 M31 M27 M10 M27 M17 M2 M530000.08 M8 M
Total assets2,965 M3,097 M3,008 M2,931 M2,947 M2,583 M2,188 M2,206 M2,458 M2,259 M
Total current assets804 M933 M900 M875 M1,052 M702 M561 M577 M600 M591 M
Total current liabilities424 M362 M357 M340 M422 M383 M300 M290 M269 M231 M
Total equity1,620 M1,772 M1,665 M1,713 M1,737 M1,519 M1,444 M1,523 M1,083 M1,018 M
Total liabilities1,345 M1,326 M1,344 M1,218 M1,210 M1,063 M745 M683 M1,375 M1,241 M
Total non-current assets2,162 M2,171 M2,108 M2,056 M1,895 M1,881 M1,628 M1,629 M1,858 M1,668 M
Total non-current liabilities921 M980 M987 M878 M787 M680 M445 M393 M1,106 M1,010 M
TotalEquityGrossMinority1,620 M1,728 M1,665 M1,713 M1,737 M1,519 M1,444 M1,523 M1,083 M1,018 M
TotalEquityGrossMinorityInterest1,620 M1,728 M1,665 M1,713 M1,737 M1,519 M1,444 M1,523 M1,083 M1,018 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest2,965 M3,097 M3,008 M2,931 M2,947 M2,583 M2,188 M2,206 M2,458 M2,259 M
TotalNonCurrentLiabilitiesNetMinorityInteres921 M980 M987 M878 M787 M680 M445 M393 M1,106 M1,010 M
Treasury stock-40 M-58 M-89 M-99 M-107 M-110 M-172 M-284 M-726 M-727 M
UnearnedPremiums692000.01 M-1 M-1 M
Work in progress129 M136 M170 M127 M160 M100 M90 M98 M105 M118 M
Working capital379 M571 M543 M534 M629 M319 M261 M287 M331 M360 M
ltinv37 M2 M20 M19 M21 M19 M17 M17 M14 M13 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

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