Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Sector:    

Industry: 

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

Financials

JHX Cash Flow

Annual
Mar-14Mar-15Mar-16Mar-17Mar-18Mar-19Mar-20Mar-21Mar-22Mar-23
(Increase) Decrease in inventories-22 M-38 M16 M-10 M-52 M-29 M3 M99 M-64 M-71 M
(Increase) Decrease in other current assets6 M200000.0100 M900000.095 M
(Increase) Decrease in other current liabilities-134 M-137 M-115 M-92 M-104 M
(Increase) Decrease in other working capital100 M108 M100 M900000.095 M16 M-16 M-19 M18 M23 M
(Increase) Decrease in payables36 M-97 M-76 M37 M48 M12 M34 M10 M137 M-58 M
(Increase) Decrease in receivables31 M24 M-23 M65 M5 M-13 M-111 M52 M-71 M32 M
Acquisitions-4 M-559 M
Amortization of intangibles18 M4 M
AssetImpairmentCharge16 M77 M
CapitalExpenditureReported115 M276 M73 M102 M204 M318 M194 M111 M258 M591 M
Cash at beginning of period154 M168 M67 M129 M193 M313 M124 M186 M318 M272 M
Cash at end of period168 M67 M107 M193 M313 M124 M186 M318 M272 M186 M
Cash flow323 M180 M260 M383 M309 M304 M451 M787 M755 M599 M
CashFlowFromContinuingInvestingActivities-119 M-278 M-67 M-109 M-245 M-864 M-204 M-120 M-346 M-652 M
ChangeInAccountPayable36 M16 M-17 M40 M21 M4 M45 M25 M137 M-63 M
ChangeInAccruedExpense13 M12 M18 M18 M48 M16 M31 M73 M41 M18 M
ChangeInIncomeTaxPayable4 M-3 M27 M9 M-11 M-15 M200000.06 M
ChangeInPayablesAndAccruedExpense49 M-86 M-58 M55 M95 M28 M65 M83 M178 M-40 M
ChangeInPrepaidAssets4 M9 M-4 M-2 M-3 M-2 M-3 M-14 M-6 M-12 M
ChangeInTaxPayable4 M-3 M27 M9 M-11 M-15 M200000.06 M
ChangeInWorkingCapital34 M-120 M-83 M108 M46 M-16 M-61 M201 M55 M-68 M
ChangesInAccountReceivables5 M-5 M-40 M-28 M-2 M-18 M-119 M46 M-71 M32 M
CommonStockDividendPaid-199 M-390 M-246 M-177 M-177 M-172 M-159 M-484 M-130 M
CommonStockPayments-22 M-9 M-22 M-100 M-78 M
Current deferred income taxes-71 M-37 M-100000.026 M-77 M13 M64 M86 M50 M48 M
Deferred income taxes-71 M-37 M-100000.026 M-77 M13 M64 M86 M50 M48 M
Depreciation61 M71 M80 M83 M92 M119 M132 M135 M156 M173 M
Depreciation unreconciled61 M71 M80 M83 M92 M119 M150 M152 M185 M196 M
DepreciationAndAmortization61 M71 M80 M83 M92 M119 M150 M152 M156 M173 M
Effect of exchange rate changes-4 M3 M700000.0200000.0-3 M7 M-6 M6 M-6 M-8 M
ExcessTaxBenefitFromStockBasedCompensation-6 M-1 M-400000.0-3 M-800000.0-400000.0-3 M
FinancingCashFlow-186 M-5 M-154 M-210 M61 M364 M-179 M-540 M-450 M-25 M
Free cash flow202 M-99 M194 M188 M101 M-13 M265 M678 M499 M22 M
GainLossOnSaleOfPPE15 M15 M-13 M
IncomeTaxPaidSupplementalData12 M36 M58 M52 M49 M26 M53 M
InterestPaidSupplementalData5 M21 M26 M26 M57 M62 M56 M37 M41 M
Issuance of capital stock29 M4 M2 M300000.0200000.0100000.0300000.0200000.0
Issuance of debt322 M115 M-15 M-75 M84 M-20 M-130 M
IssuanceOfCapitalStock29 M4 M2 M300000.0200000.0100000.0300000.0200000.0
IssuanceOfDebt397 M115 M62 M325 M542 M-20 M-531 M39 M189 M
Net cash from financing activities-186 M-5 M-154 M-210 M61 M364 M-179 M-540 M-450 M-25 M
Net cash from investing activities-119 M-278 M-67 M-109 M-245 M-864 M-204 M-120 M-348 M-652 M
Net cash from operating activities323 M180 M260 M383 M309 M304 M451 M787 M757 M599 M
Net change in cash & cash equivalents14 M-100 M40 M64 M120 M-190 M62 M126 M-52 M-86 M
Net income from continuing operations100 M291 M244 M277 M146 M229 M242 M263 M459 M512 M
NetBusinessPurchaseAndSale-4 M-559 M
NetCommonStockIssuance7 M-5 M-20 M-99 M200000.0100000.0300000.0-78 M
NetInvestmentPropertiesPurchaseAndSale2 M200000.0-600000.0-5 M-38 M17 M-8 M-2 M-88 M-74 M
NetInvestmentPurchaseAndSale2 M200000.0-600000.0-5 M-38 M17 M-8 M-2 M-88 M-74 M
NetIssuancePaymentsOfDebt397 M115 M62 M325 M542 M-20 M-531 M39 M189 M
NetLongTermDebtIssuance397 M115 M80 M348 M459 M-400000.0-401 M39 M189 M
NetPPEPurchaseAndSale-115 M-276 M-63 M-102 M-202 M-317 M-186 M-109 M-258 M-577 M
Operating (gains) losses15 M15 M26 M1000000.013 M-13 M
Other financing charges net6 M1 M400000.03 M-52 M-3 M-6 M
Other investing changes net-4 M200000.0-600000.0-5 M-38 M17 M-8 M-2 M26 M106 M
Other non-cash items196 M-33 M9 M-117 M65 M-55 M65 M75 M9 M-68 M
Payment of cash dividends199 M390 M247 M177 M178 M172 M159 M484 M130 M
Purchase of Float term investments-78 M-89 M-75 M-25 M-115 M
Purchase of property plant & equipment-115 M-278 M-76 M-104 M-215 M-323 M-203 M-120 M-258 M591 M
Purchase of short term investments1,039 M528 M154 M800 M459 M330 M390 M450 M
PurchaseOfInvestment-78 M-89 M-75 M-25 M-115 M-180 M
PurchaseOfLongTermInvestments-180 M
PurchaseOfPPE-115 M-276 M-73 M-102 M-210 M-317 M-194 M-111 M-258 M-591 M
Repayment of debt-642 M-413 M-74 M-452 M-180 M-400000.0-401 M-351 M-261 M
RepaymentOfDebt-642 M-413 M-410 M-855 M-639 M-350 M-531 M-351 M-261 M
Repurchase of capital stock-22 M-9 M-22 M-100 M-78 M
Revenue per share18 M17 M23 M5 M
SaleOfInvestment40 M106 M67 M23 M
SaleOfPPE700000.010 M8 M8 M2 M14 M
ShortTermDebtIssuance322 M528 M395 M380 M722 M330 M
ShortTermDebtPayments-413 M-410 M-455 M-639 M-350 M-130 M
StockBasedCompensation9 M9 M10 M9 M11 M13 M10 M18 M7 M16 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