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

5.89
 
USD
  
0.13
  
(2.26%)
Optionable: Yes  Market Cap: 529 M  90-day average vol: 1,306,114

Previous close: 5.76  Open: 5.8  Bid: 5.8  Ask: 5.9
52 week range    
5.69   
   18.25
Peers   
GIS / 
MDLZ / 
CPB / 
THS / 
Last updated: Friday 19th April 2024
43
MarketXLS Rank
60
Value
38
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 Cash Flow

Annual
Jun-14Jun-15Jun-16Jun-17Jun-18Jun-19Jun-20Jun-21Jun-22Jun-23
(Increase) Decrease in inventories-23 M-30 M-16 M209000.0-45 M31 M33 M-39 M-25 M189000.0
(Increase) Decrease in other current assets-6 M-4 M3 M-5 M-2 M
(Increase) Decrease in other working capital4 M6 M-220000.0-3 M3 M
(Increase) Decrease in payables24 M35 M-41 M3 M49 M-34 M-32 M-10 M-20 M-41 M
(Increase) Decrease in receivables967000.0-20 M-13 M33 M-25 M27 M34 M-3 M-5 M13 M
Acquisitions-177 M-105 M-157 M-20 M-12 M-813000.0-260 M
AssetImpairmentCharge6 M128 M40 M22 M34 M28 M58 M2 M176 M
CapitalExpenditureReported42 M51 M77 M47 M71 M76 M61 M72 M40 M28 M
Cash at beginning of period41 M124 M167 M115 M147 M113 M40 M38 M76 M66 M
Cash at end of period121 M167 M128 M69 M113 M31 M31 M76 M76 M53 M
Cash flow193 M186 M205 M167 M39 M-91 M157 M197 M158 M-50 M
Cash from disc. financing activities26 M21 M-58 M-300 M
Cash from disc. investing activities-16 M-11 M37 M298 M
CashFlowFromContinuingInvestingActivities-218 M-152 M-233 M-60 M-83 M-69 M-45 M-2 M-288 M-20 M
CashFlowFromDiscontinuedOperation306 M
CashFromDiscontinuedOperatingActivities2 M-13 M-14 M-128 M-112 M11 M
ChangeInAccountPayable24 M35 M-41 M3 M49 M-34 M-32 M-10 M-20 M-41 M
ChangeInIncomeTaxPayable5 M
ChangeInPayablesAndAccruedExpense24 M35 M-41 M3 M49 M-34 M-32 M-10 M-20 M-41 M
ChangeInPrepaidAssets-8 M-15 M-23 M33 M-9 M-7 M-45 M55 M-10 M-3 M
ChangeInTaxPayable5 M
ChangeInWorkingCapital-11 M-34 M-89 M65 M-32 M20 M-4 M3 M-64 M-28 M
ChangesInAccountReceivables967000.0-20 M-13 M33 M-25 M27 M34 M-3 M-5 M13 M
CommonStockPayments-60 M-106 M-410 M
Current deferred income taxes-3 M-3 M33 M-10 M-22 M-24 M36 M10 M9 M-26 M
Deferred income taxes-3 M-3 M33 M-10 M-22 M-24 M36 M10 M9 M-26 M
Depreciation48 M57 M66 M60 M61 M51 M52 M50 M47 M51 M
Depreciation unreconciled48 M57 M66 M60 M61 M51 M52 M50 M47 M51 M
DepreciationAndAmortization48 M57 M66 M60 M61 M51 M52 M50 M47 M51 M
EarningsLossesFromEquityInvestments4 M-10 M47000.0-129000.0-339000.0655000.02 M2 M3 M1 M
Effect of exchange rate changes3 M-8 M-11 M-3 M197000.0-2 M-1 M6 M-15 M4 M
FinancingCashFlow101 M17 M69000.0-121 M-69 M-23 M-104 M-162 M213 M-63 M
Free cash flow152 M136 M128 M113 M51 M-29 M96 M136 M53 M47 M
GainLossOnSaleOfBusiness2 M4 M-3 M
GainLossOnSaleOfPPE-5 M-9 M-4 M
Issuance of debt49 M29 M-110 M-996000.0-2 M-2 M-2 M-3 M-2 M
IssuanceOfDebt101 M-6 M16 M-110 M-41 M-76 M-348 M-52 M656 M-62 M
Net cash from financing activities101 M17 M69000.0-147 M-69 M-23 M-410 M-162 M213 M-63 M
Net cash from investing activities-218 M-152 M-233 M-76 M-83 M-69 M-45 M-2 M-288 M-20 M
Net cash from operating activities193 M186 M205 M154 M121 M39 M157 M197 M80 M67 M
Net change in cash & cash equivalents80 M43 M-39 M-46 M-34 M-76 M-3 M38 M-10 M-12 M
Net income from continuing operations140 M165 M47 M67 M-183 M26 M66 M156 M-233 M
NetBusinessPurchaseAndSale-177 M-105 M-157 M-20 M-12 M16 M59 M-260 M
NetCommonStockIssuance-60 M-106 M-410 M
NetInvestmentPropertiesPurchaseAndSale1 M3 M2 M-2 M-694000.0433000.0
NetInvestmentPurchaseAndSale1 M3 M2 M-2 M-694000.0433000.0
NetIssuancePaymentsOfDebt101 M-6 M16 M-110 M-41 M-76 M-348 M-52 M656 M-62 M
NetLongTermDebtIssuance101 M-55 M-13 M-20 M-40 M-74 M-346 M-50 M659 M-59 M
NetPPEPurchaseAndSale-42 M-50 M-77 M-41 M-70 M-69 M-61 M-61 M-28 M-20 M
Operating (gains) losses6 M-10 M47000.0-129000.0-339000.0655000.06 M-6 M-6 M-2 M
Other financing charges net-8 M4 M-16 M-37 M-29 M53 M-2 M-4 M-33 M-1 M
Other investing changes net-3 M-253000.02 M-2 M-694000.0433000.0
Other non-cash items14 M11 M147 M53 M32 M45 M41 M74 M16 M189 M
ProceedsFromStockOptionExercised7 M19 M
Purchase of property plant & equipment-42 M-50 M-77 M-41 M-70 M-69 M-61 M-61 M-28 M-20 M
Purchase of short term investments364 M285 M262 M241 M1,059 M328 M
PurchaseOfPPE-42 M-51 M-77 M-47 M-71 M-76 M-61 M-72 M-40 M-28 M
Repayment of debt101 M-55 M-13 M-20 M-404 M-359 M-608 M-291 M-400 M-387 M
RepaymentOfDebt101 M-98 M-308 M-200 M-405 M-361 M-610 M-293 M-403 M-390 M
Repurchase of capital stock-60 M-106 M-410 M
Sale of short term investments4 M3 M
SaleOfBusiness16 M60 M
SaleOfInvestment4 M3 M
SaleOfPPE2 M6 M738000.07 M16 M10 M12 M8 M
ShortTermDebtIssuance92 M324 M90 M65 M
ShortTermDebtPayments-43 M-295 M-200 M-996000.0-2 M-2 M-2 M-3 M-2 M
StockBasedCompensation12 M12 M13 M10 M11 M10 M13 M16 M16 M14 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