Pentair plc (PNR) | Jive Data

Import this data to Google Sheets with:

=jivedata("PNR","financials")

Full statements spill as a table. For one cell: =jivedata("PNR","Revenue") or =jivedata("PNR","Revenue","TTM"). Install the Jive Data add-on, then paste into a cell.

Pentair plc

PNR • CIK 0000077360

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Net Income (Loss) Attributable to Parent	$622,700	$625,400	$653,800	$671,300
Income (Loss) from Continuing Operations, Net of Tax, Attributable to Parent	$622,900	$625,600	$649,500	$655,400
Antidilutive Securities Excluded from Computation of Earnings Per Share, Amount	300,000	100,000	100,000	100,000
Weighted Average Number of Shares Outstanding, Basic	165,100,000	165,600,000	164,100,000	161,700,000
Incremental Common Shares Attributable to Dilutive Effect of Share-based Payment Arrangements	1,200,000	1,500,000	1,400,000	1,200,000
Weighted Average Number of Shares Outstanding, Diluted	166,300,000	167,100,000	165,500,000	162,900,000
Restructuring Charges	$6,000	$43,500	$36,700	$40,700

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$170,300	$118,700	$101,600	$67,700
Accounts and Financing Receivable, after Allowance for Credit Loss	$561,700	$565,200	$673,200	$913,700
Property, Plant and Equipment, Net	$362,000	$358,800	$376,800	$377,100
Inventory, Net	$677,700	$610,900	$632,600	$642,000
Other Assets, Current	$159,300	$141,300	$134,400	$139,600
Assets, Current	$1,569,000	$1,436,100	$1,541,800	$1,763,000
Liabilities and Equity	$6,563,300	$6,446,500	$6,868,800	$7,072,000
Goodwill	$3,274,600	$3,286,600	$3,538,100	$3,524,700
Intangible Assets, Net (Excluding Goodwill)	$1,042,400	$1,033,800	$1,073,300	$1,056,100
Other Assets, Miscellaneous, Noncurrent	$315,300	$331,200	$338,800	$351,100
Assets, Noncurrent, Other than Noncurrent Investments and Property, Plant and Equipment	$4,632,300	$4,651,600	$4,950,200	$4,950,200
Other Short-term Borrowings	—	$9,300	$0	$0
Accounts Payable, Current	$278,900	$272,800	$301,500	$332,500
Employee-related Liabilities, Current	$125,400	$116,200	$120,100	$94,500
Other Liabilities, Current	$545,300	$496,800	$537,700	$512,500
Liabilities, Current	$949,600	$895,100	$959,300	$939,500
Long-term Debt, Excluding Current Maturities	$1,988,300	$1,638,700	$1,638,600	$1,944,300
Liability, Defined Benefit Plan, Noncurrent	$73,600	$61,600	$58,800	$58,200
Deferred Income Tax Liabilities, Net	$40,000	$44,400	$47,500	$45,700
Other Liabilities, Noncurrent	$294,700	$243,800	$295,400	$274,200
Liabilities	$3,346,200	$2,883,600	$2,999,600	$3,261,900
Common Stock, Value, Outstanding	$1,700	$1,700	$1,700	$1,700
Additional Paid in Capital	$1,593,600	$1,501,700	$1,313,100	$1,118,600
Retained Earnings (Accumulated Deficit)	$1,866,200	$2,336,100	$2,822,600	$2,951,400
Accumulated Other Comprehensive Income (Loss), Net of Tax	$-244,400	$-276,600	$-268,200	$-261,600
Stockholders' Equity, Including Portion Attributable to Noncontrolling Interest	$3,217,100	$3,562,900	$3,869,200	$3,810,100
Accounts Receivable, Allowance for Credit Loss, Current	$11,200	$9,100	$6,800	$6,000
Common Stock, Shares Authorized	426,000,000	426,000,000	426,000,000	426,000,000
Common Stock, Shares, Issued	165,300,000	164,800,000	163,200,000	161,600,000
Restructuring Reserve	$13,400	$18,700	$14,000	$20,600
Restructuring and Related Cost, Incurred Cost	$15,100	$35,200	$27,400	$13,200
Payments for Restructuring	$24,900	$29,900	$32,100	$6,600
Inventory, Raw Materials and Supplies, Gross	$369,100	$315,800	$311,700	$328,300
Inventory, Work in Process, Gross	$97,100	$88,400	$88,800	$95,100
Inventory, Finished Goods, Gross	$211,500	$206,700	$232,100	$218,600
Contract with Customer, Asset, after Allowance for Credit Loss, Current	$70,800	$46,700	$53,900	$52,500
Other Prepaid Expense, Current	$55,200	$51,000	$66,200	$78,000
Land and Land Improvements	$32,300	$31,300	$33,200	$33,200
Buildings and Improvements, Gross	$225,500	$217,900	$241,200	$241,500
Machinery and Equipment, Gross	$669,900	$675,800	$702,700	$704,000
Capitalized Computer Software, Gross	$70,500	$92,200	$98,200	$100,200
Construction in Progress, Gross	$55,800	$51,100	$45,100	$51,200
Property, Plant and Equipment, Gross	$1,054,000	$1,068,300	$1,120,400	$1,130,100
Accumulated Depreciation, Depletion and Amortization, Property, Plant, and Equipment	$692,000	$709,500	$743,600	$753,000
Operating Lease, Right-of-Use Asset	$102,000	$116,100	$115,300	$125,500
Deferred Compensation Plan Assets	$26,100	$29,400	$32,300	$31,800
Dividends Payable, Current	$38,000	$41,200	$44,100	$43,600
Product Warranty Accrual, Current	$65,000	$67,200	$69,800	$71,300
Accrued Exchange Fee Rebate	$181,800	$176,700	$180,300	$148,000
Contract with Customer, Liability, Current	$46,900	$33,800	$37,400	$35,500
Operating Lease, Liability, Current	$26,200	$26,300	$28,500	$29,000
Taxes Payable	$20,700	$28,800	$26,800	$30,800
Interest Payable	$29,700	$5,500	$22,500	$12,700
Other Accrued Liabilities, Current	$103,200	$80,200	$99,400	$103,800
Operating Lease, Liability, Noncurrent	$79,100	$92,800	$98,800	$108,300
Accrued Income Taxes, Noncurrent	$35,600	$8,100	$8,500	$6,500
Self Insurance Reserve, Noncurrent	$51,900	$55,600	$52,800	$52,800
Foreign Currency Contracts, Liability, Fair Value Disclosure	$70,000	$16,300	$69,000	$51,000

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Net Income (Loss), Including Portion Attributable to Noncontrolling Interest	$622,700	$625,400	$653,800	$671,300
Income (Loss) from Discontinued Operations, Net of Tax, Attributable to Parent	$-200	$-200	$4,300	$15,900
Net Cash Provided by (Used in) Operating Activities, Continuing Operations	$620,800	$766,900	$814,800	$786,300
Effect of Exchange Rate on Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$-4,300	$6,000	$-24,900	$-24,900
Cash Provided by (Used in) Operating Activities, Discontinued Operations	$-1,600	$-200	$0	$0
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Period Increase (Decrease), Including Exchange Rate Effect	$61,400	$-51,600	$-17,100	$-72,900
Net Cash Provided by (Used in) Operating Activities	$619,200	$766,700	$814,800	$786,300
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$170,300	$118,700	$101,600	$28,700
Payments to Acquire Property, Plant, and Equipment	$76,000	$74,400	$68,800	$70,500
Payments to Acquire Investments	—	—	$18,000	$18,000
Proceeds from Sale of Property, Plant, and Equipment	$5,600	$600	$2,400	$2,600
Payments for (Proceeds from) Hedge, Investing Activities	$18,500	$5,800	$28,900	$28,900
Payments to Acquire Businesses, Net of Cash Acquired	$600	$108,000	$292,100	$292,100
Payments for (Proceeds from) Other Investing Activities	$-4,100	$0	$-900	$-900
Net Cash Provided by (Used in) Investing Activities	$-85,400	$-187,600	$-404,500	$-406,000
Income (Loss) from Equity Method Investments	$2,800	$1,900	$1,000	$1,100
Proceeds from Short-term Debt	—	$9,300	$-9,300	$-9,300
Depreciation	$59,500	$60,300	$59,600	$59,400
Proceeds from (Repayments of) Lines of Credit	$-320,000	$9,500	$268,200	$268,200
Amortization of Intangible Assets	$55,300	$54,300	$58,100	$59,600
Repayments of Long-term Debt	$12,500	$362,500	$269,300	$269,300
Deferred Income Taxes and Tax Credits	$-92,500	$-11,400	$-4,300	$-14,000
Payments of Debt Issuance Costs	$0	$0	$2,200	$2,200
Gain (Loss) on Disposition of Business	$0	—	$-26,300	$-26,300
Share-based Payment Arrangement, Noncash Expense	$29,100	$39,700	$37,000	$40,100
Payments for Repurchase of Common Stock	$0	$150,000	$225,000	$225,000
Asset Impairment Charges	$7,900	$17,600	$49,100	$43,900
Payments of Ordinary Dividends, Common Stock	$145,200	$152,300	$164,300	$167,200
Pension and Other Postretirement Benefits Cost (Reversal of Cost)	$12,100	$100	$6,900	$6,900
Payments for (Proceeds from) Hedge, Financing Activities	$0	$9,100	$0	$0
Payment for Pension and Other Postretirement Benefits	$8,700	$12,000	$10,600	$10,600
Net Cash Provided by (Used in) Financing Activities	$-468,100	$-636,700	$-402,500	$-439,000
Gain (Loss) on Disposition of Other Assets	$3,400	$0	$0	$0
Interest Paid, Excluding Capitalized Interest, Operating Activities	$146,400	$145,600	$79,800	$79,800
Income Taxes Paid	$120,000	$121,000	$86,900	$86,900
Increase (Decrease) in Accounts Receivable	$24,400	$11,200	$93,100	$74,500
Increase (Decrease) in Inventories	$-109,600	$-53,600	$36,900	$44,900
Increase (Decrease) in Other Current Assets	$29,100	$-14,100	$700	$-5,200
Increase (Decrease) in Accounts Payable	$-75,100	$-3,700	$20,500	$30,200
Increase (Decrease) in Other Employee-Related Liabilities	$17,200	$-5,000	$-3,700	$-3,900
Increase (Decrease) in Other Current Liabilities	$-59,500	$-48,700	$26,100	$-20,200
Increase (Decrease) in Other Noncurrent Assets and Liabilities, Net	$-2,700	$4,500	$-32,000	$-28,500

Loading financial statements…

Import this data to Google Sheets with:

=jivedata("PNR","financials")

Full statements spill as a table. For one cell: =jivedata("PNR","Revenue") or =jivedata("PNR","Revenue","TTM"). Install the Jive Data add-on, then paste into a cell.

Pentair plc

PNR • CIK 0000077360

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Net Income (Loss) Attributable to Parent	$622,700	$625,400	$653,800	$671,300
Income (Loss) from Continuing Operations, Net of Tax, Attributable to Parent	$622,900	$625,600	$649,500	$655,400
Antidilutive Securities Excluded from Computation of Earnings Per Share, Amount	300,000	100,000	100,000	100,000
Weighted Average Number of Shares Outstanding, Basic	165,100,000	165,600,000	164,100,000	161,700,000
Incremental Common Shares Attributable to Dilutive Effect of Share-based Payment Arrangements	1,200,000	1,500,000	1,400,000	1,200,000
Weighted Average Number of Shares Outstanding, Diluted	166,300,000	167,100,000	165,500,000	162,900,000
Restructuring Charges	$6,000	$43,500	$36,700	$40,700

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$170,300	$118,700	$101,600	$67,700
Accounts and Financing Receivable, after Allowance for Credit Loss	$561,700	$565,200	$673,200	$913,700
Property, Plant and Equipment, Net	$362,000	$358,800	$376,800	$377,100
Inventory, Net	$677,700	$610,900	$632,600	$642,000
Other Assets, Current	$159,300	$141,300	$134,400	$139,600
Assets, Current	$1,569,000	$1,436,100	$1,541,800	$1,763,000
Liabilities and Equity	$6,563,300	$6,446,500	$6,868,800	$7,072,000
Goodwill	$3,274,600	$3,286,600	$3,538,100	$3,524,700
Intangible Assets, Net (Excluding Goodwill)	$1,042,400	$1,033,800	$1,073,300	$1,056,100
Other Assets, Miscellaneous, Noncurrent	$315,300	$331,200	$338,800	$351,100
Assets, Noncurrent, Other than Noncurrent Investments and Property, Plant and Equipment	$4,632,300	$4,651,600	$4,950,200	$4,950,200
Other Short-term Borrowings	—	$9,300	$0	$0
Accounts Payable, Current	$278,900	$272,800	$301,500	$332,500
Employee-related Liabilities, Current	$125,400	$116,200	$120,100	$94,500
Other Liabilities, Current	$545,300	$496,800	$537,700	$512,500
Liabilities, Current	$949,600	$895,100	$959,300	$939,500
Long-term Debt, Excluding Current Maturities	$1,988,300	$1,638,700	$1,638,600	$1,944,300
Liability, Defined Benefit Plan, Noncurrent	$73,600	$61,600	$58,800	$58,200
Deferred Income Tax Liabilities, Net	$40,000	$44,400	$47,500	$45,700
Other Liabilities, Noncurrent	$294,700	$243,800	$295,400	$274,200
Liabilities	$3,346,200	$2,883,600	$2,999,600	$3,261,900
Common Stock, Value, Outstanding	$1,700	$1,700	$1,700	$1,700
Additional Paid in Capital	$1,593,600	$1,501,700	$1,313,100	$1,118,600
Retained Earnings (Accumulated Deficit)	$1,866,200	$2,336,100	$2,822,600	$2,951,400
Accumulated Other Comprehensive Income (Loss), Net of Tax	$-244,400	$-276,600	$-268,200	$-261,600
Stockholders' Equity, Including Portion Attributable to Noncontrolling Interest	$3,217,100	$3,562,900	$3,869,200	$3,810,100
Accounts Receivable, Allowance for Credit Loss, Current	$11,200	$9,100	$6,800	$6,000
Common Stock, Shares Authorized	426,000,000	426,000,000	426,000,000	426,000,000
Common Stock, Shares, Issued	165,300,000	164,800,000	163,200,000	161,600,000
Restructuring Reserve	$13,400	$18,700	$14,000	$20,600
Restructuring and Related Cost, Incurred Cost	$15,100	$35,200	$27,400	$13,200
Payments for Restructuring	$24,900	$29,900	$32,100	$6,600
Inventory, Raw Materials and Supplies, Gross	$369,100	$315,800	$311,700	$328,300
Inventory, Work in Process, Gross	$97,100	$88,400	$88,800	$95,100
Inventory, Finished Goods, Gross	$211,500	$206,700	$232,100	$218,600
Contract with Customer, Asset, after Allowance for Credit Loss, Current	$70,800	$46,700	$53,900	$52,500
Other Prepaid Expense, Current	$55,200	$51,000	$66,200	$78,000
Land and Land Improvements	$32,300	$31,300	$33,200	$33,200
Buildings and Improvements, Gross	$225,500	$217,900	$241,200	$241,500
Machinery and Equipment, Gross	$669,900	$675,800	$702,700	$704,000
Capitalized Computer Software, Gross	$70,500	$92,200	$98,200	$100,200
Construction in Progress, Gross	$55,800	$51,100	$45,100	$51,200
Property, Plant and Equipment, Gross	$1,054,000	$1,068,300	$1,120,400	$1,130,100
Accumulated Depreciation, Depletion and Amortization, Property, Plant, and Equipment	$692,000	$709,500	$743,600	$753,000
Operating Lease, Right-of-Use Asset	$102,000	$116,100	$115,300	$125,500
Deferred Compensation Plan Assets	$26,100	$29,400	$32,300	$31,800
Dividends Payable, Current	$38,000	$41,200	$44,100	$43,600
Product Warranty Accrual, Current	$65,000	$67,200	$69,800	$71,300
Accrued Exchange Fee Rebate	$181,800	$176,700	$180,300	$148,000
Contract with Customer, Liability, Current	$46,900	$33,800	$37,400	$35,500
Operating Lease, Liability, Current	$26,200	$26,300	$28,500	$29,000
Taxes Payable	$20,700	$28,800	$26,800	$30,800
Interest Payable	$29,700	$5,500	$22,500	$12,700
Other Accrued Liabilities, Current	$103,200	$80,200	$99,400	$103,800
Operating Lease, Liability, Noncurrent	$79,100	$92,800	$98,800	$108,300
Accrued Income Taxes, Noncurrent	$35,600	$8,100	$8,500	$6,500
Self Insurance Reserve, Noncurrent	$51,900	$55,600	$52,800	$52,800
Foreign Currency Contracts, Liability, Fair Value Disclosure	$70,000	$16,300	$69,000	$51,000

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Net Income (Loss), Including Portion Attributable to Noncontrolling Interest	$622,700	$625,400	$653,800	$671,300
Income (Loss) from Discontinued Operations, Net of Tax, Attributable to Parent	$-200	$-200	$4,300	$15,900
Net Cash Provided by (Used in) Operating Activities, Continuing Operations	$620,800	$766,900	$814,800	$786,300
Effect of Exchange Rate on Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$-4,300	$6,000	$-24,900	$-24,900
Cash Provided by (Used in) Operating Activities, Discontinued Operations	$-1,600	$-200	$0	$0
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Period Increase (Decrease), Including Exchange Rate Effect	$61,400	$-51,600	$-17,100	$-72,900
Net Cash Provided by (Used in) Operating Activities	$619,200	$766,700	$814,800	$786,300
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$170,300	$118,700	$101,600	$28,700
Payments to Acquire Property, Plant, and Equipment	$76,000	$74,400	$68,800	$70,500
Payments to Acquire Investments	—	—	$18,000	$18,000
Proceeds from Sale of Property, Plant, and Equipment	$5,600	$600	$2,400	$2,600
Payments for (Proceeds from) Hedge, Investing Activities	$18,500	$5,800	$28,900	$28,900
Payments to Acquire Businesses, Net of Cash Acquired	$600	$108,000	$292,100	$292,100
Payments for (Proceeds from) Other Investing Activities	$-4,100	$0	$-900	$-900
Net Cash Provided by (Used in) Investing Activities	$-85,400	$-187,600	$-404,500	$-406,000
Income (Loss) from Equity Method Investments	$2,800	$1,900	$1,000	$1,100
Proceeds from Short-term Debt	—	$9,300	$-9,300	$-9,300
Depreciation	$59,500	$60,300	$59,600	$59,400
Proceeds from (Repayments of) Lines of Credit	$-320,000	$9,500	$268,200	$268,200
Amortization of Intangible Assets	$55,300	$54,300	$58,100	$59,600
Repayments of Long-term Debt	$12,500	$362,500	$269,300	$269,300
Deferred Income Taxes and Tax Credits	$-92,500	$-11,400	$-4,300	$-14,000
Payments of Debt Issuance Costs	$0	$0	$2,200	$2,200
Gain (Loss) on Disposition of Business	$0	—	$-26,300	$-26,300
Share-based Payment Arrangement, Noncash Expense	$29,100	$39,700	$37,000	$40,100
Payments for Repurchase of Common Stock	$0	$150,000	$225,000	$225,000
Asset Impairment Charges	$7,900	$17,600	$49,100	$43,900
Payments of Ordinary Dividends, Common Stock	$145,200	$152,300	$164,300	$167,200
Pension and Other Postretirement Benefits Cost (Reversal of Cost)	$12,100	$100	$6,900	$6,900
Payments for (Proceeds from) Hedge, Financing Activities	$0	$9,100	$0	$0
Payment for Pension and Other Postretirement Benefits	$8,700	$12,000	$10,600	$10,600
Net Cash Provided by (Used in) Financing Activities	$-468,100	$-636,700	$-402,500	$-439,000
Gain (Loss) on Disposition of Other Assets	$3,400	$0	$0	$0
Interest Paid, Excluding Capitalized Interest, Operating Activities	$146,400	$145,600	$79,800	$79,800
Income Taxes Paid	$120,000	$121,000	$86,900	$86,900
Increase (Decrease) in Accounts Receivable	$24,400	$11,200	$93,100	$74,500
Increase (Decrease) in Inventories	$-109,600	$-53,600	$36,900	$44,900
Increase (Decrease) in Other Current Assets	$29,100	$-14,100	$700	$-5,200
Increase (Decrease) in Accounts Payable	$-75,100	$-3,700	$20,500	$30,200
Increase (Decrease) in Other Employee-Related Liabilities	$17,200	$-5,000	$-3,700	$-3,900
Increase (Decrease) in Other Current Liabilities	$-59,500	$-48,700	$26,100	$-20,200
Increase (Decrease) in Other Noncurrent Assets and Liabilities, Net	$-2,700	$4,500	$-32,000	$-28,500

Pentair plc

Earnings Per Share

Consolidated Balance Sheets

Consolidated Statementsof Cash Flows

Pentair plc

Earnings Per Share

Consolidated Balance Sheets

Consolidated Statementsof Cash Flows