Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Pentair plc. logo

Pentair plc.

Sector: Industrials   

Industry: Diversified Industrials

79.18
 
USD
  
-0.87
  
(-1.09%)
Optionable: Yes  Market Cap: 13,235 M  90-day average vol: 1,645,445

Previous close: 80.05  Open: 80.61  Bid: 75.46  Ask: 82.45
52 week range    
51.38   
   85.81
Peers   
XYL / 
IEX / 
CR / 
Last updated: Thursday 18th April 2024
57
MarketXLS Rank
75
Value
38
Technical
60
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

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

CR

0.01856 B14.1101.72

DOV

0.012324 B22162.15

IEX

0.010916 B38.3197.98

XYL

0.012519 B41.289.46
Financials

PNR Income Statement

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
Amortization of intangibles-134 M-114 M-121 M-52 M
Basic EPS from continuing operations2.543.192.22.490.631.832.142.143.362.93
Basic EPS total2.671.13-2.522.883.671.982.12.153.342.92
Basic weighted shares outstanding201 M191 M180 M181 M182 M176 M169 M167 M166 M165 M
BasicDiscontinuousOperations0.13-2.06-2.620.393.040.15-0.040.01-0.02-0.01
CommissionExpenses11 M
Cost of sales4,630 M4,576 M3,018 M3,096 M1,858 M1,917 M1,906 M1,960 M2,446 M2,757 M
Depreciation-141 M-139 M-81 M-85 M-51 M-50 M-48 M-47 M-51 M-54 M
DepreciationAndAmortization-141 M-139 M-81 M-85 M-51 M-50 M-48 M-47 M-51 M-54 M
Diluted EPS total2.621.11-2.522.853.631.962.092.143.32.9
Diluted normalized net income/share2.53.142.172.470.621.812.122.133.322.92
Diluted weighted shares outstanding205 M194 M183 M183 M184 M177 M170 M167 M168 M166 M
DilutedDiscontinuousOperations0.12-2.03-2.590.383.010.15-0.030.01-0.02-0.02
Dividends paid per share0.760.80.84
Earnings from equity interest2 M1 M2 M4 M1 M39 M
EarningsFromEquityInterestNetOfTax2 M1 M2 M4 M1 M39 M
ExciseTaxes500 M
GainOnSaleOfBusiness21 M-200000.0-3 M-4 M-4 M-7 M2 M-100000.01 M200000.0
GainOnSaleOfPPE24 M
GainOnSaleOfSecurity5 M24 M
GainsLossOnDisposalOfDiscontinuedOperations25 M-392 M-7 M600000.0552 M26 M-6 M
GeneralAndAdministrativeExpense-76 M-69 M-26 M-37 M-30 M2,932 M-31 M-31 M-36 M-46 M
Gross operating profit2,370 M2,463 M1,599 M1,794 M988 M1,048 M1,052 M1,058 M1,319 M1,365 M
ImpairmentOfCapitalAssets11 M555 M-13 M-16 M-12 M-21 M-26 M
Income before tax695 M784 M513 M561 M173 M380 M408 M432 M627 M551 M
Income restructuring and M&A-103 M-88 M-41 M-24 M-28 M-41 M-14 M-14 M-7 M-56 M
Income taxes177 M177 M115 M109 M59 M58 M46 M75 M71 M67 M
Interest income4 M4 M5 M8 M10 M
InterestExpenseNonOperating75 M72 M107 M148 M-87 M-33 M-30 M24 M13 M62 M
InterestExpenseOperating-69 M-67 M-77 M-143 M253 M
InterestIncomeOperating4 M4 M6 M21 M
MinorityInterests-6 M135 M
MiscOtherSpecialCharges64 M75 M57 M60 M-101 M-17 M3 M-5 M1000000.017 M
Net income from total operations543 M607 M397 M522 M667 M347 M362 M716 M1,109 M483 M
NetIncomeCommonStockholders1,079 M430 M314 M974 M1,157 M-2,703 M717 M716 M1,109 M964 M
NetIncomeContinuousOperations543 M607 M397 M522 M667 M347 M362 M716 M1,109 M483 M
NetIncomeDiscontinuousOperations25 M-392 M-7 M600000.0552 M26 M-6 M3 M
NetIncomeExtraordinary543 M215 M-76 M522 M667 M347 M356 M359 M553 M481 M
NetNonOperatingInterestIncomeExpense-71 M-69 M-102 M-140 M87 M21 M30 M-24 M-12 M-62 M
NetOperatingInterestIncomeExpense-87 M-33 M-30 M62 M
Operating income754 M852 M616 M701 M405 M-3,006 M433 M461 M637 M595 M
Operating income before depreciation (EBITDA)976 M1,042 M702 M747 M426 M432 M457 M531 M717 M728 M
OperatingExpense1,617 M1,611 M983 M1,093 M622 M3,554 M619 M596 M682 M769 M
Other income net-23 M-1000000.02 M-400000.060 M-900000.0-5 M5 M-2 M-17 M
OtherGandA-76 M-69 M-26 M-37 M-30 M2,932 M-31 M-31 M-36 M-46 M
OtherImpairmentOfCapitalAssets-17 M-21 M-5 M-13 M-9 M11 M-9 M
OtherOperatingExpenses-3 M-2 M-1 M-2 M13 M-12 M-32 M-32 M-37 M-47 M
OtherWriteOff-900000.0-4 M-2 M-900000.0-1 M
RealizedCapitalGain46 M
RentAndLandingFees-76 M-69 M-26 M-37 M-30 M2,777 M
Research & development expense123 M117 M99 M114 M73 M77 M79 M76 M86 M92 M
ResearchExpense123 M117 M99 M114 M73 M77 M79 M76 M86 M92 M
RestructringAndMnAIncome-103 M-88 M-41 M-24 M-28 M-41 M-14 M-14 M-7 M-56 M
Revenue per share-268 M-114 M-68 M-96 M-36 M-35 M-32 M-28 M-26 M-52 M
SalariesAndWages-31 M-34 M-33 M-34 M-40 M-21 M-21 M-20 M-30 M-25 M
Selling Gen & administrative expense1,494 M1,494 M884 M979 M536 M3,477 M540 M521 M596 M677 M
SellingAndMarketingExpense1,494 M1,494 M884 M979 M536 M545 M540 M521 M596 M677 M
SellingExpense1,494 M1,494 M884 M979 M536 M534 M540 M521 M596 M677 M
Special income/charges-11 M88 M41 M38 M44 M53 M35 M14 M7 M82 M
Total Income available for interest expense (EBIT)700 M789 M542 M566 M338 M347 M377 M456 M639 M612 M
Total common shares outstanding197 M182 M180 M182 M182 M171 M168 M166 M165 M165 M
Total net income543 M607 M397 M522 M667 M347 M362 M716 M1,109 M483 M
Total ordinary shares165 M165 M165 M165 M165 M165 M165 M165 M165 M165 M
Total revenues7,000 M7,039 M4,616 M4,890 M2,885 M2,965 M2,957 M3,018 M3,765 M4,122 M
TotalExpenses6,246 M6,187 M4,000 M4,189 M2,480 M5,471 M2,525 M2,556 M3,128 M3,527 M
TotalRevenue7,000 M7,039 M4,616 M4,890 M2,846 M2,965 M2,957 M3,018 M3,765 M4,122 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