Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Parker-Hannifin Corporation logo

Parker-Hannifin Corporation

Sector: Industrials   

Industry: Diversified Industrials

534.65
 
USD
  
-3.44
  
(-0.64%)
Optionable: Yes  Market Cap: 69,873 M  90-day average vol: 606,709

Previous close: 538.09  Open: 540.77  Bid: 499.59  Ask: 558.19
52 week range    
309.89   
   570.15
Peers   
CR / 
CIR / 
DOV / 
ITT / 
IEX / 
ROK / 
GE / 
DHR / 
IR / 
Last updated: Monday 22nd April 2024
57
MarketXLS Rank
75
Value
46
Technical
52
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

PH Balance Sheet

Annual
Jun-14Jun-15Jun-16Jun-17Jun-18Jun-19Jun-20Jun-21Jun-22Jun-23
"""debtc"""817 M223 M362 M1,008 M638 M587 M810 M3 M1,724 M3,763 M
Accounts payable1,252 M1,092 M1,035 M1,300 M1,430 M1,413 M1,112 M1,668 M1,732 M2,051 M
Accounts receivable1,858 M1,620 M1,594 M1,931 M2,146 M2,131 M1,854 M2,184 M2,342 M2,827 M
Accrued expenses1,983 M1,716 M1,621 M1,951 M2,132 M2,138 M1,915 M2,587 M3,665 M3,321 M
Accumulated depreciation & depletion-3,328 M-3,199 M-3,169 M-3,249 M-3,359 M-3,418 M-3,518 M-3,774 M-3,775 M-4,001 M
Additional paid in capital595 M623 M628 M544 M497 M462 M417 M330 M327 M306 M
Cash and equivalents1,614 M1,181 M1,222 M885 M822 M3,220 M686 M733 M536 M475 M
CashCashEquivalentsAndShortTermInvestments2,187 M1,914 M2,104 M924 M855 M3,371 M756 M772 M564 M484 M
CashEquivalents1,614 M1,181 M1,222 M885 M822 M3,220 M686 M
CommercialPaper816 M304 M534 M534 M586 M724 M1,400 M1,800 M
Common par91 M91 M91 M91 M91 M91 M91 M91 M91 M91 M
Common stock equity6,659 M5,104 M4,575 M5,262 M5,860 M5,962 M6,227 M8,398 M8,848 M10,327 M
CommonStock91 M91 M91 M91 M91 M91 M91 M91 M91 M91 M
Construction in progress81 M93 M75 M122 M128 M115 M176 M196 M204 M342 M
Cost in excess3,171 M2,943 M2,903 M5,587 M5,504 M5,454 M7,870 M8,060 M7,740 M10,629 M
CurrentAccruedExpenses507 M485 M459 M498 M502 M558 M608 M682 M1,683 M895 M
CurrentCapitalLeaseObligation91 M69 M81 M79 M46 M43 M40 M36 M173 M
CurrentDeferredAssets136 M142 M
CurrentDeferredRevenue-65 M-51 M-51 M-60 M-245 M
CurrentDeferredTaxesAssets136 M343 M64 M61 M17 M22 M7 M6 M9 M38 M
CurrentDeferredTaxesLiabilities2,800 M3,000 M551 M-186 M-177 M-43 M-292 M-450 M-196 M-1,568 M
DeferredFinancingCosts-23 M-47 M-41 M-75 M-71 M-61 M-87 M-75 M
DefinedPensionBenefit3,499 M3,238 M3,307 M3,896 M3,916 M4,245 M4,594 M5,306 M4,362 M5,455 M
DividendsPayable1.02.03.0
EmployeeBenefits1,346 M1,699 M2,076 M1,406 M1,178 M1,304 M1,887 M1,056 M640 M552 M
Finished goods533 M527 M459 M643 M673 M663 M704 M734 M812 M794 M
Float term debt1,508 M2,724 M2,652 M4,862 M4,319 M6,521 M7,652 M6,582 M9,756 M8,796 M
GoodwillAndOtherIntangibleAssets4,360 M3,956 M3,826 M7,894 M7,520 M7,237 M11,669 M11,579 M10,876 M19,079 M
Gross fixed assets (Plant Property & Equipment)5,153 M4,863 M4,737 M5,187 M5,215 M5,187 M5,811 M6,040 M5,898 M6,866 M
IncomeTaxPayable224 M139 M128 M153 M199 M167 M195 M236 M250 M375 M
Intangibles1,188 M1,013 M923 M2,307 M2,016 M1,783 M3,799 M3,520 M3,136 M8,451 M
InterestPayable83 M118 M137 M162 M214 M190 M308 M250 M255 M574 M
Inventories1,372 M1,300 M1,173 M1,549 M1,621 M1,678 M1,964 M2,091 M2,215 M2,908 M
Invested capital9,676 M10,552 M9,880 M14,985 M14,497 M19,004 M21,532 M21,562 M28,360 M27,919 M
Land & improvements326 M295 M291 M321 M290 M281 M346 M343 M322 M385 M
Leases10 M105 M
LineOfCredit1,696 M1,466 M1,466 M1,414 M
LongTermCapitalLeaseObligation1,509 M2,947 M2,733 M5,336 M140 M134 M136 M278 M
LongTermDebtAndCapitalLeaseObligation1,508 M2,724 M2,652 M4,862 M4,319 M6,521 M7,652 M6,582 M9,756 M8,796 M
Machinery furniture & equipment3,210 M3,017 M2,934 M3,168 M3,219 M3,224 M3,516 M3,654 M3,588 M4,086 M
Minority interest3 M3 M3 M6 M6 M6 M15 M15 M12 M11 M
Net fixed assets (net PP&E)1,824 M1,664 M1,568 M1,937 M1,856 M1,768 M2,293 M2,266 M2,123 M2,865 M
Non-current deferred income taxes95 M63 M54 M222 M235 M193 M419 M554 M307 M1,650 M
NonCurrentDeferredAssets406 M605 M36 M58 M150 M127 M104 M111 M81 M
NonCurrentDeferredLiabilities95 M63 M54 M222 M235 M193 M419 M554 M307 M1,650 M
NonCurrentDeferredRevenue-421000.0-3 M-3 M-2 M-78 M
NonCurrentDeferredTaxesAssets-349 M406 M605 M36 M58 M150 M127 M104 M111 M81 M
NonCurrentPensionAndOtherPostretirementBenefitPlans1,346 M1,699 M2,076 M1,406 M1,178 M1,304 M1,887 M1,056 M640 M552 M
NotesReceivable388 M365 M232 M255 M328 M311 M245 M326 M544 M309 M
Number of employees55090.055090.055090.055090.055090.055090.055090.055090.055090.055090.0
Other current assets165 M146 M140 M148 M153 M141 M86 M101 M91 M114 M
Other equity adjustments-823 M-1,739 M-2,228 M-1,924 M-1,763 M-2,059 M-2,559 M
Other fixed assets5,153 M4,863 M4,737 M5,187 M5,215 M5,187 M5,811 M6,040 M5,898 M6,866 M
Other non-current assets57000.030 M84 M5,170 M1 M1 M
Other non-current liabilities410 M336 M307 M337 M526 M438 M539 M639 M522 M893 M
Other receivable216 M161 M130 M137 M14,302 M14,320 M13,696 M14,348 M15,862 M19,065 M
OtherCurrentBorrowings496000.0223 M58 M474 M100 M228000.086 M3 M302 M1,974 M
OtherCurrentLiabilities453 M410 M383 M436 M428 M426 M424 M507 M470 M651 M
OtherInventories1,372 M1,300 M1,173 M1,549 M1,621 M1,678 M1,964 M2,091 M2,215 M2,908 M
Payables1,476 M1,231 M1,162 M1,454 M1,629 M1,580 M1,307 M1,904 M1,982 M2,426 M
Preferred securities of subsidiary trust3 M
PreferredStock3 M
Prepaid expenses130 M242 M104 M120 M135 M182 M215 M244 M6,383 M306 M
Raw materials106 M85 M75 M184 M182 M164 M272 M267 M274 M625 M
RecievablesAdjustmentsAllowances-16 M-9 M-8 M-14 M-10 M-9 M-12 M-12 M-10 M-32 M
Retained earnings8,351 M8,103 M8,075 M9,006 M9,863 M10,718 M11,085 M13,349 M14,119 M15,749 M
Short term debt817 M223 M362 M1,008 M638 M587 M810 M3 M1,724 M3,763 M
Total assets13,274 M12,279 M12,034 M15,490 M15,320 M17,577 M19,888 M20,341 M25,944 M29,964 M
Total current assets6,072 M5,441 M5,208 M4,780 M5,085 M7,673 M5,035 M5,617 M12,047 M6,834 M
Total current liabilities3,253 M2,349 M2,366 M3,396 M3,197 M3,152 M3,148 M3,097 M5,859 M7,735 M
Total equity6,659 M5,104 M4,575 M5,262 M5,860 M5,962 M6,227 M8,398 M8,848 M10,327 M
Total liabilities6,612 M7,172 M7,455 M10,223 M9,455 M11,609 M13,646 M11,928 M17,084 M19,626 M
Total non-current assets7,203 M6,838 M6,826 M10,710 M10,235 M9,904 M14,853 M14,724 M13,897 M23,130 M
Total non-current liabilities3,359 M4,823 M5,090 M6,827 M6,257 M8,457 M10,498 M8,831 M11,225 M11,891 M
TotalEquityGrossMinority6,663 M5,108 M4,579 M5,267 M5,865 M5,968 M6,242 M8,414 M8,860 M10,338 M
TotalEquityGrossMinorityInterest6,663 M5,108 M4,579 M5,267 M5,865 M5,968 M6,242 M8,414 M8,860 M10,338 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest13,274 M12,279 M12,034 M15,490 M15,320 M17,577 M19,888 M20,341 M25,944 M29,964 M
TotalNonCurrentLiabilitiesNetMinorityInteres3,359 M4,823 M5,090 M6,827 M6,257 M8,457 M10,498 M8,831 M11,225 M11,891 M
TotalTaxPayable224 M139 M128 M153 M199 M167 M195 M236 M250 M375 M
Treasury stock-2,377 M-3,712 M-4,219 M-4,379 M-4,590 M-5,309 M-5,365 M-5,371 M-5,688 M-5,818 M
Work in progress732 M689 M640 M723 M766 M851 M989 M1,090 M1,129 M1,489 M
Working capital2,819 M3,092 M2,842 M1,384 M1,888 M4,521 M1,886 M2,520 M6,187 M-901 M
ltinv1,019 M812 M827 M842 M801 M748 M765 M774 M788 M1,105 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