Perrigo Company plc (PRGO)

Import this data to Google Sheets with:

=jivedata("PRGO","financials")

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

Perrigo Company plc

PRGO • CIK 0001585364

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Revenue from Contract with Customer, Excluding Assessed Tax	$4,655,600	$4,373,400	$4,253,100	$4,144,900
Cost of Goods and Services Sold	$2,975,200	$2,830,700	$2,758,600	$2,766,200
Gross Profit	$1,680,400	$1,542,700	$1,494,500	$1,378,700
Operating Income (Loss)	$151,900	$112,900	$-1,122,200	$-1,563,400
Interest Income (Expense), Nonoperating, Net	—	$-187,800	$-162,500	$-163,200
Other Nonoperating Income (Expense)	$10,400	$900	$-13,200	$115,500
Gain (Loss) on Extinguishment of Debt	$3,200	$-6,700	$0	$-1,400
Income (Loss) from Continuing Operations before Income Taxes, Noncontrolling Interest	$-8,300	$-80,700	$-1,297,900	$-1,612,500
Income Tax Expense (Benefit)	$-3,900	$80,000	$104,400	$90,700
Income (Loss) from Continuing Operations, Net of Tax, Attributable to Parent	$-4,400	$-160,700	$-1,402,300	$-1,703,200
Income (Loss) from Discontinued Operations, Net of Tax, Attributable to Parent	$-8,300	$-11,100	$-23,100	$-31,500
Net Income (Loss) Attributable to Parent	$-12,700	$-171,800	$-1,425,400	$-1,734,700
Production and Distribution Costs	$110,500	$98,000	$93,400	$91,300
Research and Development Expense	$122,500	$112,200	$95,400	$95,100
Selling and Marketing Expense	$641,800	$546,600	$526,500	$503,000
General and Administrative Expense	$522,300	$468,000	$435,900	$425,700
Asset Impairment Charges	$90,000	$88,900	$1,363,100	$1,690,300
Restructuring Charges	$42,200	$110,100	$71,900	$123,300
Operating Expenses	$1,528,500	$1,429,800	$2,616,700	$2,942,100
Weighted Average Number of Shares Outstanding, Basic	135,300,000	137,400,000	138,500,000	139,400,000
Incremental Common Shares Attributable to Dilutive Effect of Share-based Payment Arrangements	0	0	0	0
Payments of Dividends	$149,700	$152,500	$159,300	$159,900
StockRepurchaseProgramAuthorizedAmount1	—	$1,000,000	$1,000,000	$1,000,000
Stock Repurchase Program, Remaining Authorized Repurchase Amount	$835,800	$835,800	$835,800	$835,800

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$751,300	$558,800	$531,600	$399,700
Accounts Receivable, after Allowance for Credit Loss, Current	$739,600	$642,300	$612,800	$709,900
Property, Plant and Equipment, Net	$916,400	$917,800	$898,700	$849,000
Inventory, Net	$1,140,900	$1,081,800	$1,149,000	$1,064,500
Prepaid Expense and Other Assets, Current	$201,100	$199,000	$231,400	$277,700
Disposal Group, Including Discontinued Operation, Assets, Current	—	—	$272,600	$0
Finite-Lived Intangible Assets, Net	$2,980,800	$2,423,700	$2,351,500	$2,190,200
Assets, Current	$2,832,900	$2,481,900	$2,797,400	$2,451,700
Deferred Income Tax Assets, Net	$25,800	$5,100	$3,300	$6,300
Other Assets, Noncurrent	$335,200	$318,600	$261,800	$258,600
Assets, Noncurrent	$7,976,200	$7,165,800	$5,737,800	$5,157,700
Assets	$10,809,100	$9,647,700	$8,535,200	$7,609,500
Preferred Stock, Shares Issued	0	0	0	0
Common Stock, Shares, Issued	135,500,000	136,500,000	137,600,000	138,700,000
Accounts Payable, Current	$477,700	$495,200	$474,500	$400,400
Employee-related Liabilities, Current	$127,000	$123,200	$112,200	$153,200
Other Accrued Liabilities, Current	—	$238,700	$230,600	$265,400
Accrued Income Taxes, Current	$42,100	$17,400	$20,800	$28,800
Long-term Debt, Current Maturities	$440,600	$36,400	$36,600	$11,400
Disposal Group, Including Discontinued Operation, Liabilities, Current	—	—	$26,800	$0
Liabilities, Current	$1,586,300	$1,044,200	$1,012,900	$1,054,800
Long-term Debt, Excluding Current Maturities	$3,632,800	$3,581,700	$3,603,600	$3,283,400
Deferred Income Tax Liabilities, Net	$262,300	$203,200	$168,900	$146,700
Other Liabilities, Noncurrent	$559,800	$499,200	$814,300	$608,800
Liabilities, Noncurrent	$4,454,900	$4,284,100	$4,586,800	$4,038,900
Liabilities	$6,041,200	$5,328,300	$5,599,700	$5,093,700
Preferred Stock, Value, Issued	$0	$0	$0	$0
Common Stock, Value, Issued	$6,837,500	$6,733,900	$6,608,200	$6,540,500
Accumulated Other Comprehensive Income (Loss), Net of Tax	$10,700	$-162,400	$4,800	$-22,800
Retained Earnings (Accumulated Deficit)	$-2,080,300	$-2,252,100	$-3,677,500	$-4,001,900
Stockholders' Equity Attributable to Parent	$4,767,900	$4,319,400	$2,935,500	$2,515,800
Accounts Receivable, Allowance for Credit Loss	$7,800	$7,400	$6,500	$3,900
Preferred Stock, Shares Authorized	10,000,000	10,000,000	10,000,000	10,000,000
Common Stock, Shares Authorized	10,000,000,000	10,000,000,000	10,000,000,000	10,000,000,000
Equity Securities, FV-NI	—	—	$900	$900
Equity Method Investments	—	—	$23,400	$23,200
Operating Lease, Right-of-Use Asset	$183,600	$175,200	$167,800	$156,000
Finance Lease, Right-of-Use Asset, after Accumulated Amortization	$13,700	$11,700	$11,500	$10,100
Operating Lease, Liability, Current	$27,500	$27,800	$25,700	$25,400
Finance Lease, Liability, Current	$1,900	$1,500	$1,800	$1,500
Operating Lease, Liability, Noncurrent	$159,600	$153,800	$151,500	$138,500
Finance Lease, Liability, Noncurrent	$13,200	$12,000	$11,500	$10,500
Operating Lease, Liability	$187,100	$181,600	$177,200	$163,900
Finance Lease, Liability	$15,100	$13,500	$13,300	$12,100
Deferred Tax Liabilities, Net	$236,500	$198,100	$165,600	$165,600

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Net Income (Loss) Attributable to Parent	$-12,700	$-171,800	$-1,425,400	$-1,734,700
Net Cash Provided by (Used in) Operating Activities	$405,500	$362,900	$238,500	$196,100
Effect of Exchange Rate on Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Including Disposal Group and Discontinued Operations	—	—	$32,500	$-2,900
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Period Increase (Decrease), Including Exchange Rate Effect	$150,600	$-192,500	$-24,900	$-54,500
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$751,300	$558,800	$531,600	$478,900
Disposal Group, Including Discontinued Operation, Cash and Cash Equivalents	$0	$0	$2,300	$-2,600
Depreciation, Depletion and Amortization	$359,500	$325,900	$337,500	$350,400
Asset Impairment Charges	$90,000	$88,900	$1,363,100	$1,690,300
Share-based Payment Arrangement, Noncash Expense	$68,800	$64,400	$54,600	$47,400
Payments for (Proceeds from) Derivative Instrument, Investing Activities	—	$48,200	$0	$0
Proceeds from Sale of Other Assets, Investing Activities	—	$37,900	$0	$0
Payments to Acquire Property, Plant, and Equipment	$101,700	$118,300	$93,400	$76,800
Amortization of Debt Discount (Premium)	$2,300	$8,900	$9,000	$8,700
Proceeds from Divestiture of Businesses	$0	$215,500	$14,400	$362,900
Gain (Loss) on Disposition of Business	$0	$6,400	$-1,600	$129,500
Payments for (Proceeds from) Other Investing Activities	$0	—	$500	$-2,100
Gain (Loss) on Disposition of Other Assets	—	$28,100	$0	$0
Net Cash Provided by (Used in) Investing Activities	$-77,500	$78,800	$-75,400	$291,100
Interest Rate Cash Flow Hedge Gain (Loss) Reclassified to Earnings, Net	—	$-14,400	$0	$0
Amortization of Deferred Hedge Gains	—	—	$-23,800	$-21,500
Deferred Income Tax Expense (Benefit)	$-106,600	$9,800	$-50,800	$-79,700
Other Operating Activities, Cash Flow Statement	$25,700	$-9,500	$6,800	$7,100
Adjustments, Noncash Items, to Reconcile Net Income (Loss) to Cash Provided by (Used in) Operating Activities	—	$437,600	$339,600	$242,900
Proceeds from Issuance of Long-term Debt	$295,100	$1,091,200	$0	$427,600
Repayments of Long-term Debt	$325,300	$1,529,000	$34,800	$776,500
Payments of Dividends	$149,700	$152,500	$159,300	$159,900
Payment, Tax Withholding, Share-based Payment Arrangement	—	—	$19,100	$8,400
Proceeds from (Payments for) Other Financing Activities	$-7,300	$-16,000	$-7,300	$1,500
Net Cash Provided by (Used in) Financing Activities	$-187,200	$-611,000	$-220,500	$-538,900
Increase (Decrease) in Accounts Receivable	$57,100	$11,100	$-30,700	$65,700
Increase (Decrease) in Inventories	$-19,400	$-13,700	$61,100	$-110,500
Increase (Decrease) in Prepaid Expense and Other Assets	$-47,500	$-20,100	$-8,400	$62,800
Increase (Decrease) in Accounts Payable	$-65,900	$54,200	$-28,700	$-75,600
Increase (Decrease) in Employee Related Liabilities	$-52,800	$-94,400	$-63,400	$-84,800
Increase (Decrease) in Contract with Customer, Liability	—	$-25,600	$-26,200	$-25,100
Increase (Decrease) in Other Accrued Liabilities	—	$-1,300	$-16,500	$57,200
Increase (Decrease) in Income Taxes Payable	$-12,900	$-31,800	$55,900	$97,000
Increase (Decrease) in Other Noncurrent Liabilities	—	—	$-200	$0
Increase (Decrease) in Other Operating Assets and Liabilities, Net	$-33,500	$-1,500	$0	$0
Increase (Decrease) in Operating Capital	$58,500	$74,700	$101,100	$46,800
Interest Paid, Excluding Capitalized Interest, Operating Activities	$276,900	$251,400	$202,000	$202,000
Proceeds from Interest Received	$100,800	$75,000	$60,400	$60,400
Income Taxes Paid	$107,500	$155,700	$98,900	$98,900
Proceeds from Income Tax Refunds	$10,700	$2,600	$20,200	$20,200

Loading financial statements…

Import this data to Google Sheets with:

=jivedata("PRGO","financials")

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