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 Balance Sheet

Annual
Mar-14Mar-15Mar-16Mar-17Mar-18Mar-19Mar-20Mar-21Mar-22Mar-23
"""debtc"""47 M14 M51 M52 M15 M9 M14 M19 M
Accounts payable94 M95 M77 M108 M112 M142 M151 M174 M198 M
Accounts receivable135 M130 M169 M194 M196 M243 M264 M291 M398 M355 M
Accrued expenses339 M225 M207 M245 M266 M361 M378 M736 M591 M517 M
Accumulated depreciation & depletion-615 M-653 M-675 M-767 M-838 M-893 M-949 M-1,093 M-156 M-1,355 M
Additional paid in capital140 M153 M164 M174 M186 M198 M207 M225 M230 M238 M
Building & improvements213 M240 M266 M345 M347 M433 M433 M513 M
Cash and equivalents168 M67 M107 M79 M282 M79 M144 M209 M125 M113 M
CashCashEquivalentsAndShortTermInvestments171 M72 M107 M79 M320 M104 M166 M235 M245 M113 M
CashEquivalents97 M7 M13 M4 M3 M79 M144 M209 M125 M
Common par231 M231 M231 M229 M230 M230 M231 M231 M232 M230 M
Common stock equity-199 M-203 M-225 M-212 M-221 M974 M1,035 M1,061 M1,333 M1,611 M
CommonStock231 M231 M231 M229 M230 M230 M231 M231 M232 M230 M
Construction in progress115 M249 M144 M57 M179 M257 M268 M92 M
Cost in excess5 M201 M197 M209 M200 M195 M
CurrentAccruedExpenses64 M75 M82 M75 M82 M101 M168 M203 M123 M114 M
CurrentCapitalLeaseObligation21 M18 M16 M16 M18 M15 M9 M14 M19 M
CurrentDeferredAssets38 M33 M
CurrentDeferredTaxesAssets38 M33 M456 M431 M443 M1,533 M1,392 M1,389 M1,195 M
CurrentDeferredTaxesLiabilities412 M347 M329 M289 M346 M1,362 M1,227 M1,188 M961 M
CurrentProvisions48 M46 M47 M40 M29 M26 M21 M20 M19 M16 M
DeferredFinancingCosts7 M
DefinedPensionBenefit21 M20 M
DividendsPayable125 M267 M259 M177 M159 M304 M178 M134 M
EmployeeBenefits47 M40 M29 M26 M21 M20 M
Finished goods133 M151 M144 M147 M190 M235 M224 M150 M238 M
Float term debt398 M502 M565 M884 M1,380 M1,355 M859 M877 M1,059 M
GoodwillAndOtherIntangibleAssets17 M376 M364 M383 M362 M350 M
Gross fixed assets (Plant Property & Equipment)1,318 M1,534 M1,542 M1,646 M1,830 M2,281 M2,331 M2,514 M1,670 M1,415 M
IncomeTaxPayable5 M2 M5 M2 M3 M13 M9 M7 M10 M15 M
Intangibles12 M174 M167 M174 M163 M155 M
InterestPayable500000.06 M6 M5 M13 M9 M9 M5 M5 M
Inventories187 M218 M193 M203 M256 M317 M305 M218 M280 M344 M
InventoriesAdjustmentsAllowances-7 M-7 M-8 M-8 M-8 M-14 M-14 M-10 M-10 M
Invested capital-199 M837 M277 M352 M1,063 M2,355 M2,390 M2,319 M2,210 M2,670 M
Land & improvements29 M70 M70 M70 M68 M84 M79 M85 M
LineOfCredit47 M14 M51 M52 M10 M5 M
LongTermCapitalLeaseObligation43 M55 M65 M63 M
LongTermDebtAndCapitalLeaseObligation398 M502 M565 M884 M1,380 M1,398 M914 M942 M1,122 M
LongTermProvisions1,572 M1,290 M1,176 M1,043 M1,101 M979 M883 M1,014 M1,011 M858 M
Machinery furniture & equipment961 M975 M1,062 M1,176 M1,236 M1,508 M1,511 M1,776 M
Net fixed assets (net PP&E)703 M880 M867 M879 M992 M1,388 M1,382 M1,419 M1,515 M59 M
Non-current deferred income taxes93 M89 M82 M95 M66 M80 M82 M86 M87 M94 M
NonCurrentAccountsReceivable246 M207 M149 M58 M53 M44 M39 M43 M
NonCurrentAccruedExpenses24 M26 M33 M37 M46 M40 M35 M34 M33 M33 M
NonCurrentDeferredAssets467 M402 M411 M384 M413 M1,442 M1,309 M1,274 M819 M756 M
NonCurrentDeferredLiabilities93 M89 M82 M95 M66 M80 M82 M86 M87 M94 M
NonCurrentDeferredTaxesAssets467 M402 M411 M384 M413 M1,442 M1,309 M1,274 M819 M756 M
Number of employees5196.05196.05196.05196.05196.05196.05196.05196.05196.05196.0
Other current assets4 M21 M4 M3 M2 M2 M2 M2 M11 M900000.0
Other equity adjustments33 M-400000.0800000.0-2 M-1 M-30 M-62 M-7 M-22 M-53 M
Other fixed assets61 M42 M49 M59 M
Other non-current assets30 M31 M68 M60 M34 M29 M25 M3 M6 M20 M
Other non-current liabilities1,597 M1,311 M1,191 M1,059 M1,127 M1,024 M926 M1,068 M182 M49 M
Other receivable37 M24 M22 M12 M12 M20 M20 M24 M3,777 M
OtherCurrentLiabilities155 M139 M138 M128 M127 M120 M116 M155 M33 M40 M
OtherInventories18 M218 M32 M30 M30 M33 M38 M
OtherPayable52 M53 M44 M60 M69 M104 M49 M49 M458 M388 M
Payables276 M150 M126 M171 M184 M260 M210 M533 M468 M403 M
Prepaid expenses32 M24 M18 M28 M25 M31 M26 M39 M81 M77 M
Raw materials55 M68 M51 M58 M65 M89 M70 M60 M94 M
RecievablesAdjustmentsAllowances-1000000.0-800000.0-1 M-900000.0-1 M-3 M-4 M-6 M-3 M
Restricted cash63 M27 M22 M114 M70 M63 M63 M137 M147 M
Retained earnings-602 M-587 M-622 M-613 M-635 M577 M660 M611 M892 M1,197 M
Short term debt47 M14 M51 M52 M
TaxesReceivable85 M25 M30 M
Total assets2,104 M2,045 M2,029 M2,013 M2,351 M4,033 M4,028 M4,089 M4,243 M4,479 M
Total current assets659 M524 M534 M632 M843 M754 M908 M944 M1,124 M1,075 M
Total current liabilities541 M378 M400 M429 M395 M483 M510 M901 M770 M697 M
Total equity-199 M-203 M-225 M-212 M-221 M974 M1,035 M1,061 M1,333 M1,611 M
Total liabilities2,303 M2,247 M2,255 M2,225 M2,573 M3,058 M2,993 M3,028 M2,910 M2,868 M
Total non-current assets1,445 M1,521 M1,495 M1,381 M1,508 M3,279 M3,120 M3,145 M3,081 M1,528 M
Total non-current liabilities1,762 M1,869 M1,863 M1,796 M2,178 M2,575 M2,483 M2,127 M2,255 M2,154 M
TotalEquityGrossMinority-199 M-203 M-225 M-212 M-221 M974 M1,035 M1,061 M1,333 M1,611 M
TotalEquityGrossMinorityInterest-199 M-203 M-225 M-212 M-221 M974 M1,035 M1,061 M1,333 M1,611 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest2,104 M2,045 M2,029 M2,013 M2,351 M4,033 M4,028 M4,089 M4,243 M4,479 M
TotalNonCurrentLiabilitiesNetMinorityInteres1,762 M1,869 M1,863 M1,796 M2,178 M2,575 M2,483 M2,127 M2,255 M2,154 M
TotalTaxPayable5 M2 M5 M2 M3 M13 M9 M7 M10 M15 M
Treasury stock22 M9 M22 M100 M78 M
UnearnedIncome653 M551 M534 M415 M436 M375 M340 M388 M379 M343 M
Work in progress6 M7 M6 M7 M8 M7 M25 M18 M23 M
Working capital118 M146 M135 M203 M448 M271 M398 M43 M354 M378 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