Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Sector:    

Industry: 

 
USD
  
  
()
Optionable:   Market Cap:   90-day average vol:

Previous close:   Open:   Bid:   Ask:
52 week range    
   
   

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

Valuation

Returns

Risk

Ranks

Dividends

Analyst Estimates

Financial Health

Technicals

Growth

Profitability

Peers

StockDividendMarket Cap (B)PEPrice ($)
Financials

HZNP Income Statement

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
AcquisitionExpense177 M4 M1 M49 M98 M
Amortization of intangibles-2 M-9 M254 M446 M426 M414 M414 M1,783 M3,840 M3,475 M
Basic EPS from continuing operations-2.34-3.150.27-1.04-2.46-0.233.131.912.372.28
Basic EPS total-2.34-3.150.27-1.04-2.46-0.233.131.912.372.28
Basic weighted shares outstanding64 M84 M149 M161 M163 M166 M183 M204 M226 M229 M
Cost of sales15 M79 M220 M393 M537 M391 M362 M533 M795 M920 M
Depreciation1 M2 M5 M5 M7 M6 M7 M24 M18 M24 M
DepreciationAndAmortization1 M2 M5 M5 M7 M6 M7 M24 M18 M24 M
Diluted EPS total-2.34-3.150.25-1.04-2.46-0.232.91.812.272.22
Diluted normalized net income/share-3.150.25-1.04-2.46-0.232.91.812.272.22
Diluted weighted shares outstanding64 M84 M156 M161 M163 M166 M205 M215 M236 M235 M
Earnings from equity interest600000.0
EarningsFromEquityInterestNetOfTax600000.0
GainOnSaleOfBusiness6 M
GainOnSaleOfPPE6 M43 M-11 M5 M2 M
GainOnSaleOfSecurity-29 M1 M
GainsLossOnDisposalOfDiscontinuedOperations6 M
GeneralAndAdministrativeExpense24 M89 M220 M608 M655 M692 M697 M973 M1,446 M1,541 M
Gross operating profit59 M218 M538 M588 M519 M816 M938 M1,668 M2,432 M2,709 M
ImpairmentOfCapitalAssets22 M46 M2 M12 M56 M
Income before tax-150 M-270 M-133 M-228 M-504 M-83 M-20 M402 M463 M527 M
Income restructuring and M&A334 M88 M369 M5 M-1 M1 M-141000.0-13 M-2 M
Income taxes-1 M-6 M-172 M-61 M-103 M-45 M-593 M12 M-72 M5 M
Interest income-24 M-70 M-87 M-127 M-122 M-87 M-60 M-81 M-84 M
InterestExpenseNonOperating13 M24 M127 M122 M87 M60 M81 M
MiscOtherSpecialCharges-26 M-41 M-88 M7 M-390000.0841000.0-60 M-28 M2 M-6 M
Net income from total operations-149 M-264 M40 M-167 M-402 M-38 M573 M390 M534 M521 M
NetIncomeCommonStockholders-149 M-264 M40 M-35 M-402 M-38 M573 M388 M708 M634 M
NetIncomeContinuousOperations-149 M-264 M40 M-167 M-402 M-38 M573 M390 M534 M521 M
NetIncomeDiscontinuousOperations6 M
NetNonOperatingInterestIncomeExpense-13 M-24 M-70 M-87 M-127 M-122 M-87 M-60 M-81 M-84 M
NonRecurringOperationExpense-65 M6 M1000000.05 M
Operating income-43 M-8 M55 M-147 M-383 M38 M127 M490 M543 M617 M
Operating income before depreciation (EBITDA)-124 M-226 M24 M12 M-73 M311 M327 M753 M903 M925 M
OperatingExpense102 M227 M482 M735 M902 M778 M811 M1,178 M1,889 M2,091 M
Other income net96 M233 M117 M-7 M390000.0-44 M71 M24 M-4 M6 M
OtherGandA24 M89 M220 M608 M655 M692 M697 M973 M1,446 M1,541 M
OtherOperatingExpenses-51000.0-3 M-66 M-2 M-2 M-3 M-4 M-87 M-56 M
PromotionAndAdvertising14 M19 M22 M36 M114 M289 M271 M
RentAndLandingFees500000.0600000.03 M5 M6 M6 M
Research & development expense10 M17 M42 M61 M225 M83 M103 M209 M345 M438 M
ResearchExpense10 M17 M42 M61 M225 M83 M103 M209 M345 M438 M
RestructringAndMnAIncome334 M88 M369 M5 M-1 M1 M-141000.0-13 M-2 M
Revenue per share-2 M-9 M254 M446 M426 M414 M414 M1,783 M3,840 M3,475 M
SalariesAndWages800000.02 M3 M5 M5 M6 M12 M18 M18 M
Selling Gen & administrative expense92 M209 M440 M608 M655 M692 M697 M973 M1,446 M1,541 M
SellingAndMarketingExpense69 M120 M220 M14 M19 M22 M36 M114 M289 M271 M
Special income/charges-334 M-88 M-304 M-22 M-46 M-2 M-2 M-12 M-56 M
Total Income available for interest expense (EBIT)-137 M-270 M-133 M-228 M-378 M39 M67 M461 M544 M527 M
Total common shares outstanding68 M124 M160 M162 M165 M170 M190 M224 M229 M228 M
Total net income-149 M-264 M40 M-167 M-402 M-38 M573 M390 M534 M521 M
Total ordinary shares229 M229 M229 M229 M229 M229 M229 M229 M229 M229 M
Total revenues74 M297 M757 M981 M1,056 M1,208 M1,300 M2,200 M3,226 M3,629 M
TotalExpenses117 M305 M702 M1,128 M1,440 M1,170 M1,173 M1,710 M2,683 M3,012 M
TotalRevenue74 M297 M757 M981 M1,056 M1,208 M1,300 M2,200 M3,226 M3,629 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