Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Perrigo Company plc logo

Perrigo Company plc

Sector: Healthcare   

Industry: Drug Manufacturers - Specialty & Generic

26.85
 
USD
  
-0.54
  
(-1.97%)
Optionable: Yes  Market Cap: 3,848 M  90-day average vol: 1,489,364

Previous close: 27.39  Open: 27.24  Bid: 26.83  Ask: 27.16
52 week range    
25.77   
   40.28
Last updated: Monday 17th June 2024

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

PRGO Balance Sheet

Annual
Jun-14Jun-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Mar-22Dec-22
Accounts payable364 M709 M472 M450 M475 M520 M452 M411 M480 M537 M
Accounts receivable935 M1,209 M1,176 M1,131 M1,073 M1,243 M594 M653 M679 M697 M
Accrued expenses673 M1,157 M883 M946 M905 M938 M797 M826 M844 M938 M
Accumulated depreciation & depletion-688 M-739 M-2,631 M-805 M-851 M-922 M-861 M-912 M-990 M
Building & improvements430 M528 M520 M514 M552 M579 M516 M538 M
Cash and equivalents800 M786 M622 M679 M551 M354 M632 M1,865 M1,966 M601 M
CashCashEquivalentsAndShortTermInvestments805 M786 M622 M679 M551 M354 M632 M1,865 M1,966 M601 M
CashEquivalents786 M622 M679 M551 M354 M632 M1,865 M1,966 M601 M
Common par6,812 M8,768 M8,278 M8,034 M7,558 M7,496 M7,251 M7,177 M7,154 M7,071 M
Common stock equity8,693 M10,663 M5,958 M6,171 M5,668 M5,804 M5,655 M5,152 M5,105 M4,977 M
CommonStock6,812 M8,768 M8,278 M8,034 M7,558 M7,496 M7,251 M7,177 M7,154 M7,071 M
Cost in excess3,544 M6,984 M4,164 M4,266 M4,029 M4,186 M3,103 M3,005 M2,976 M3,549 M
CurrentAccruedExpenses292 M391 M379 M380 M333 M386 M336 M398 M359 M387 M
CurrentCapitalLeaseObligation32 M46 M40 M38 M39 M25 M28 M26 M28 M28 M
CurrentDeferredAssets63 M148 M
CurrentDeferredTaxesAssets63 M148 M
CurrentDeferredTaxesLiabilities1 M80 M318 M312 M281 M275 M235 M233 M361 M
Deferred revenues1 M80 M
DefinedPensionBenefit100 M140 M159 M168 M163 M181 M208 M195 M135 M
DividendsPayable105 M112 M142 M
Finished goods307 M564 M431 M454 M445 M530 M574 M549 M541 M620 M
Float term debt3,063 M5,247 M5,225 M3,271 M3,052 M3,366 M3,528 M2,917 M3,511 M4,070 M
GoodwillAndOtherIntangibleAssets10,331 M9,727 M7,561 M7,556 M6,888 M7,107 M5,584 M5,151 M5,030 M6,779 M
Gross fixed assets (Plant Property & Equipment)1,468 M1,671 M3,501 M1,638 M1,681 M1,955 M1,880 M1,943 M846 M2,133 M
IncomeTaxPayable17 M56 M32 M116 M97 M32 M9 M17 M5 M14 M
Intangibles6,787 M2,743 M3,397 M3,291 M2,859 M2,921 M2,482 M2,146 M2,054 M3,230 M
InterestPayable-146 M-217 M-168 M-128 M-122 M-128 M-125 M-36 M-156 M
Inventories632 M936 M795 M807 M878 M967 M1,059 M1,020 M1,022 M1,150 M
Invested capital11,764 M17,733 M11,742 M12,052 M8,723 M9,194 M9,240 M8,094 M8,639 M9,068 M
Land & improvements36 M49 M45 M46 M49 M50 M52 M51 M
LineOfCredit7 M
LongTermCapitalLeaseObligation134 M161 M173 M228 M250 M
LongTermDebtAndCapitalLeaseObligation3,063 M5,247 M5,225 M3,271 M3,052 M3,366 M3,528 M2,917 M3,511 M4,070 M
LongTermProvisions2 M4 M300000.03 M
Machinery furniture & equipment1,001 M1,094 M1,095 M1,079 M1,079 M1,196 M1,157 M1,187 M
Minority interest800000.0200000.0-500000.0100000.0100000.0300000.0
Net fixed assets (net PP&E)780 M932 M870 M833 M829 M1,033 M1,019 M864 M846 M1,143 M
NetOtherUnrealizedGainLoss9 M
NetUnrealizedGainLossInvestments-3 M
Non-current deferred income taxes728 M1,514 M390 M322 M282 M281 M276 M239 M239 M368 M
NonCurrentDeferredAssets24 M50 M72 M10 M1 M5 M41 M7 M7 M7 M
NonCurrentDeferredLiabilities728 M1,514 M390 M322 M282 M281 M276 M239 M239 M368 M
NonCurrentDeferredTaxesAssets24 M50 M72 M10 M1 M5 M41 M7 M7 M7 M
Number of employees8900.08900.08900.08900.08900.08900.08900.08900.08900.08900.0
Other current assets160 M5,420 M2,350 M420 M377 M351 M667 M183 M332 M
Other equity adjustments140 M104 M-82 M253 M85 M139 M395 M36 M15 M-27 M
Other non-current assets168 M233 M212 M410 M363 M426 M1,711 M378 M571 M368 M
Other non-current liabilities550 M741 M842 M430 M886 M515 M539 M656 M554 M623 M
Other receivable4,732 M4,837 M4,088 M4,139 M1,075 M4,452 M
OtherCurrentBorrowings2 M300 M70 M351 M3 M37 M604 M5 M1,588 M
OtherCurrentLiabilities27 M430 M792 M420 M442 M394 M548 M33 M132 M139 M
OtherEquityInterest12 M8 M10 M-1 M-4 M-6 M-12 M-10 M7 M
OtherPayable1,606 M2,178 M427 M36 M748 M169 M2,011 M
Payables382 M766 M504 M566 M571 M552 M461 M428 M485 M552 M
Preferred securities of subsidiary trust10 M10 M10 M10 M10 M
PreferredStock10 M10 M10 M10 M10 M
Prepaid expenses116 M150 M212 M203 M400 M166 M182 M306 M268 M272 M
Raw materials178 M213 M198 M200 M236 M250 M265 M219 M218 M268 M
RecievablesAdjustmentsAllowances-3 M-6 M-6 M-7 M-6 M-7 M-7 M-7 M
Retained earnings1,875 M1,974 M-2,095 M-1,975 M-1,838 M-1,695 M-1,858 M-1,927 M-1,929 M-2,068 M
SecuritySoldNotYetRepurchased8 M
Short term debt144 M153 M573 M70 M190 M3 M37 M604 M5 M36 M
Total assets13,880 M19,721 M13,870 M11,629 M10,983 M11,301 M11,488 M10,426 M10,390 M11,017 M
Total current assets2,551 M3,183 M2,805 M2,820 M2,902 M2,731 M3,134 M3,860 M3,936 M2,720 M
Total current liabilities1,075 M1,694 M1,836 M1,436 M1,537 M1,336 M1,382 M1,588 M981 M1,114 M
Total equity8,693 M10,663 M5,958 M6,171 M5,668 M5,804 M5,655 M5,152 M5,105 M4,977 M
Total liabilities5,187 M9,058 M7,913 M5,458 M5,315 M5,497 M5,833 M5,274 M5,285 M6,175 M
Total non-current assets11,329 M16,538 M11,065 M8,809 M8,081 M8,571 M8,355 M6,566 M6,454 M8,297 M
Total non-current liabilities4,112 M7,364 M6,076 M4,022 M3,778 M4,162 M4,451 M3,686 M4,304 M5,062 M
TotalEquityGrossMinority8,694 M10,663 M5,958 M6,171 M5,668 M5,804 M5,655 M5,152 M5,239 M4,842 M
TotalEquityGrossMinorityInterest8,694 M10,663 M5,958 M6,171 M5,668 M5,804 M5,655 M5,152 M5,239 M4,842 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest13,880 M19,721 M13,870 M11,629 M10,983 M11,301 M11,488 M10,426 M10,390 M11,017 M
TotalNonCurrentLiabilitiesNetMinorityInteres4,112 M7,364 M6,076 M4,022 M3,778 M4,162 M4,451 M3,686 M4,304 M5,062 M
TotalTaxPayable17 M56 M32 M116 M97 M32 M9 M17 M5 M14 M
UnearnedPremiums6 M-88 M-33 M-21 M-12 M-7 M300000.05 M5 M16 M
Work in progress147 M159 M166 M153 M198 M187 M220 M252 M263 M262 M
Working capital1,476 M1,489 M969 M1,384 M1,365 M1,395 M1,752 M2,272 M2,954 M1,606 M
debtc144 M153 M573 M70 M190 M3 M37 M604 M5 M36 M
ltinv21 M13 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