Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Qiagen N.V. logo

Qiagen N.V.

Sector: Healthcare   

Industry: Diagnostics & Research

45.69
 
USD
  
-0.30
  
(-0.65%)
Optionable: Yes  Market Cap: 10,358 M  90-day average vol: 995,523

Previous close: 45.99  Open: 45.81  Bid: 36.0  Ask: 59.5
52 week range    
35.81   
   49.18
Peers   
TMO / 
HOLX / 
BDX / 
GE / 
Last updated: Monday 20th May 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

QGEN Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
"""debtc"""131 M503 M285 M43 M848 M390 M610 M
Accounts payable46 M52 M51 M59 M69 M85 M118 M101 M99 M84 M
Accounts receivable265 M274 M278 M329 M352 M385 M381 M362 M324 M382 M
Accrued expenses299 M266 M308 M322 M362 M119 M118 M101 M99 M290 M
Accumulated depreciation & depletion-393 M-410 M-451 M-565 M-603 M-699 M-630 M-503 M-517 M
Additional paid in capital1,823 M1,766 M1,795 M1,630 M1,742 M1,777 M1,834 M1,819 M1,868 M1,915 M
Building & improvements383 M
Cash and equivalents393 M290 M439 M658 M1,159 M624 M598 M881 M731 M668 M
CashCashEquivalentsAndShortTermInvestments577 M421 M532 M1,017 M1,394 M753 M715 M1,065 M1,418 M1,058 M
CashEquivalents393 M290 M439 M658 M1,159 M624 M598 M881 M731 M581 M
Common par3 M3 M3 M3 M3 M3 M3 M3 M3 M3 M
Common stock equity2,650 M2,566 M2,607 M2,541 M2,635 M2,537 M2,798 M3,097 M3,467 M3,808 M
CommonStock3 M3 M3 M3 M3 M3 M3 M3 M3 M3 M
Construction in progress204 M
Cost in excess1,888 M1,876 M1,926 M2,013 M2,109 M2,141 M2,364 M2,351 M2,353 M2,476 M
CurrentAccruedExpenses224 M192 M230 M242 M263 M444 M188 M
CurrentCapitalLeaseObligation1 M922000.0999000.01 M20 M19 M23 M22 M22 M
CurrentDeferredAssets31 M
CurrentDeferredRevenue49 M50 M45 M49 M45 M49 M57 M69 M66 M
CurrentDeferredTaxesAssets133 M145 M190 M85 M79 M92 M143 M133 M
CurrentDeferredTaxesLiabilities33 M36 M138 M94 M64 M33 M56 M56 M
Deferred revenues33 M36 M66 M
DerivativeProductLiabilities253 M317 M197 M393 M192 M157 M99 M
FinancialAssets224 M295 M192 M379 M190 M131 M
Finished goods85 M88 M79 M99 M98 M99 M151 M175 M212 M
Float term debt1,041 M1,049 M1,067 M1,758 M1,671 M1,421 M1,880 M1,094 M1,472 M922 M
GoodwillAndOtherIntangibleAssets2,615 M2,512 M2,483 M2,512 M2,584 M2,773 M3,090 M2,978 M2,897 M3,003 M
Gross fixed assets (Plant Property & Equipment)821 M853 M888 M1,059 M1,115 M1,154 M1,190 M638 M1,165 M1,282 M
IncomeTaxPayable29 M22 M27 M21 M30 M34 M57 M14 M12 M
Intangibles727 M636 M557 M499 M475 M632 M726 M627 M545 M527 M
Inventories132 M137 M137 M156 M163 M171 M291 M328 M358 M398 M
Invested capital3,691 M3,615 M3,674 M4,299 M4,306 M4,464 M4,974 M4,232 M5,419 M4,730 M
Land & improvements26 M
LineOfCredit37 M37 M
LongTermCapitalLeaseObligation4 M2 M2 M57000.022000.062 M117 M101 M
LongTermDebtAndCapitalLeaseObligation1,041 M1,049 M1,067 M1,758 M1,671 M1,421 M1,880 M1,094 M1,472 M922 M
LongTermProvisions1 M2 M2 M3 M4 M9 M16 M4 M
Machinery furniture & equipment401 M
Minority interest8 M2 M
Net fixed assets (net PP&E)428 M443 M437 M494 M512 M455 M559 M638 M662 M765 M
NetOtherUnrealizedGainLoss-2 M-434 M
Non-current deferred income taxes117 M70 M41 M77 M63 M23 M39 M38 M4 M
NonCurrentDeferredAssets4 M2 M68 M39 M43 M57 M55 M73 M
NonCurrentDeferredLiabilities117 M70 M41 M77 M63 M23 M39 M38 M
NonCurrentDeferredTaxesAssets4 M2 M68 M39 M43 M57 M55 M73 M155 M
NonCurrentPensionAndOtherPostretirementBenefitPlans5 M7 M7 M8 M7 M8 M9 M7 M
NotesReceivable11 M8 M17 M29000.0
Number of employees6100.06100.06100.06100.06100.06100.06100.06100.06100.06100.0
Other current assets16 M17 M18 M44 M56 M58 M100 M79 M
Other equity adjustments-135 M-259 M-334 M-221 M-311 M-310 M-244 M-327 M-404 M-434 M
Other fixed assets268 M
Other non-current assets258 M261 M283 M120 M160 M188 M162 M158 M203 M200 M
Other non-current liabilities207 M224 M285 M84 M89 M106 M187 M209 M218 M207 M
Other receivable11 M10 M10 M1,418 M1,502 M1,526 M1,870 M2,142 M
OtherCurrentLiabilities4 M444 M411 M569 M486 M63 M
OtherDeferredCosts96 M101 M37 M51 M69 M
OtherEquityInterest882000.02 M1 M878000.0124000.0561000.0
OtherInventories3 M3 M2 M2 M
OtherPayable160 M67 M90 M34 M41 M157 M240 M64 M5 M
Payables75 M74 M78 M81 M99 M119 M118 M101 M99 M102 M
Prepaid expenses114 M70 M67 M99 M109 M105 M237 M355 M294 M310 M
Raw materials25 M27 M29 M24 M26 M26 M65 M98 M91 M
RecievablesAdjustmentsAllowances-9 M-9 M-12 M-27 M-23 M
Restricted cash6 M
Retained earnings1,126 M1,209 M1,263 M1,248 M1,380 M1,178 M1,323 M1,792 M2,160 M2,457 M
Short term debt131 M503 M285 M43 M848 M390 M588 M
TaxesReceivable29 M27 M24 M40 M35 M42 M59 M53 M
Total assets4,454 M4,179 M4,308 M5,039 M5,748 M5,236 M5,870 M6,147 M6,288 M6,115 M
Total current assets1,149 M961 M1,038 M1,648 M2,155 M1,570 M1,624 M2,110 M2,394 M2,148 M
Total current liabilities432 M268 M308 M325 M972 M951 M572 M1,517 M975 M1,079 M
Total equity2,650 M2,566 M2,607 M2,541 M2,635 M2,537 M2,798 M3,097 M3,467 M3,808 M
Total liabilities1,828 M1,644 M1,701 M2,498 M3,113 M2,699 M3,072 M3,050 M2,821 M2,307 M
Total non-current assets3,306 M3,218 M3,271 M3,391 M3,593 M3,665 M4,245 M4,037 M3,894 M3,968 M
Total non-current liabilities1,365 M1,343 M1,393 M2,173 M2,141 M1,748 M2,500 M1,533 M1,847 M1,228 M
TotalEquityGrossMinority2,658 M2,568 M2,607 M2,541 M2,635 M2,537 M2,798 M3,097 M3,467 M3,808 M
TotalEquityGrossMinorityInterest2,658 M2,568 M2,607 M2,541 M2,635 M2,537 M2,798 M3,097 M3,467 M3,808 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest4,454 M4,179 M4,308 M5,039 M5,748 M5,236 M5,870 M6,147 M6,288 M6,115 M
TotalNonCurrentLiabilitiesNetMinorityInteres1,365 M1,343 M1,393 M2,173 M2,141 M1,748 M2,500 M1,533 M1,847 M1,228 M
TotalTaxPayable29 M22 M27 M21 M30 M34 M57 M12 M
Treasury stock-167 M-152 M-120 M-119 M-179 M-112 M-118 M-190 M-160 M-133 M
UnearnedPremiums-113 M-82 M-50 M
UnrealizedGainLoss-434 M
Work in progress22 M21 M28 M33 M39 M46 M74 M85 M95 M
Working capital717 M693 M729 M1,323 M1,183 M619 M1,052 M592 M1,419 M1,068 M
ltinv23 M17 M38 M18 M15 M10 M11 M21 M18 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