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

Financials

IQV Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Accounts payable109 M145 M250 M322 M2,295 M2,512 M581 M621 M3,316 M3,564 M
Accounts receivable445 M554 M998 M1,229 M1,279 M1,312 M1,181 M1,275 M2,917 M3,381 M
Accrued expenses495 M540 M1,209 M1,402 M2,395 M2,620 M2,063 M2,172 M3,477 M3,680 M
Accumulated depreciation & depletion-306 M-322 M-363 M-483 M-567 M-597 M-673 M-765 M-1,130 M-1,125 M
Cash and equivalents867 M977 M1,198 M959 M891 M837 M1,814 M1,366 M1,216 M1,376 M
CashCashEquivalentsAndShortTermInvestments867 M977 M1,238 M1,005 M938 M899 M1,902 M1,477 M1,309 M1,496 M
Common par144 M9 M10,602 M10,782 M10,901 M11,049 M11,095 M10,777 M10,898 M11,028 M
Common stock equity-704 M-564 M8,633 M7,995 M6,714 M6,003 M6,001 M6,042 M5,765 M6,112 M
CommonStock144 M9 M10,602 M10,782 M10,901 M11,049 M11,095 M10,777 M10,898 M11,028 M
Cost in excess464 M720 M10,727 M11,850 M11,800 M12,159 M12,654 M13,301 M13,921 M14,567 M
CurrentAccruedExpenses330 M360 M883 M1,008 M1,198 M1,380 M1,414 M
CurrentCapitalLeaseObligation357 M350 M
CurrentDeferredAssets119 M101 M
CurrentDeferredRevenue543 M585 M774 M985 M1,007 M1,014 M1,252 M1,825 M1,797 M1,799 M
CurrentDeferredTaxesAssets119 M101 M630 M730 M
CurrentDeferredTaxesLiabilities-976 M-766 M
Deferred revenues543 M585 M774 M985 M1,007 M1,014 M1,252 M1,825 M1,797 M1,799 M
Float term debt2,283 M2,419 M7,108 M10,122 M10,907 M11,545 M12,384 M12,034 M12,859 M13,178 M
GoodwillAndOtherIntangibleAssets745 M1,088 M17,117 M18,441 M17,751 M17,673 M17,859 M18,244 M18,741 M19,406 M
Gross fixed assets (Plant Property & Equipment)496 M510 M769 M923 M1,001 M1,551 M1,626 M1,668 M1,993 M1,944 M
IncomeTaxPayable56 M35 M76 M72 M100 M108 M102 M137 M161 M116 M
Intangibles280 M368 M6,390 M6,591 M5,951 M5,514 M5,205 M4,943 M4,820 M4,839 M
InterestPayable274000.05 M42 M45 M45 M55 M56 M43 M66 M
Invested capital3,861 M4,274 M22,849 M28,239 M28,528 M29,489 M31,140 M30,110 M31,219 M32,245 M
LongTermCapitalLeaseObligation396 M371 M313 M264 M223 M
LongTermDebtAndCapitalLeaseObligation2,283 M2,419 M7,108 M10,122 M10,907 M11,941 M12,755 M12,347 M12,859 M13,178 M
Machinery furniture & equipment310 M323 M98 M153 M154 M154 M147 M141 M
Minority interest49000.0228 M227 M249 M240 M260 M279 M
Net fixed assets (net PP&E)190 M188 M406 M440 M434 M954 M953 M903 M863 M819 M
Non-current deferred income taxes62 M66 M2,133 M895 M736 M646 M338 M410 M464 M202 M
NonCurrentDeferredAssets36 M43 M89 M109 M109 M119 M114 M124 M118 M166 M
NonCurrentDeferredLiabilities62 M66 M2,133 M895 M736 M646 M338 M410 M464 M202 M
NonCurrentDeferredTaxesAssets36 M43 M89 M109 M109 M119 M114 M124 M118 M166 M
NonCurrentPrepaidAssets113 M110 M177 M235 M239 M227 M386 M491 M
Number of employees83000.083000.083000.083000.083000.083000.083000.083000.083000.083000.0
Other current assets92 M83 M235 M259 M322 M451 M563 M521 M122 M140 M
Other equity adjustments-59 M-111 M-570 M49 M-224 M-311 M-205 M-406 M
Other fixed assets338 M446 M521 M1,066 M1,128 M1,151 M863 M819 M
Other non-current liabilities184 M183 M402 M440 M418 M456 M633 M649 M671 M698 M
Other receivable532 M614 M723 M883 M1,130 M1,286 M1,263 M1,309 M561 M546 M
OtherCurrentLiabilities30 M19 M20 M10 M32 M211 M242 M207 M152 M294 M
Payables164 M180 M326 M394 M2,395 M2,620 M683 M758 M3,477 M3,680 M
Prepaid expenses45 M51 M123 M146 M151 M138 M159 M156 M623 M596 M
Properties186 M187 M333 M324 M326 M331 M351 M376 M
RecievablesAdjustmentsAllowances-2 M-2 M-14 M-15 M-15 M-16 M-34 M-33 M-36 M-34 M
Restricted cash3 M2 M
Retained earnings-789 M-462 M-399 M538 M807 M998 M1,277 M2,243 M2,607 M3,825 M
SecuritySoldNotYetRepurchased-1,168 M-992 M
Short term debt826000.049 M92 M103 M100 M100 M149 M91 M152 M718 M
TaxesReceivable45 M34 M34 M47 M69 M56 M56 M58 M43 M32 M
Total assets3,296 M3,926 M21,208 M22,857 M22,549 M23,251 M24,564 M24,689 M25,337 M26,681 M
Total current assets2,146 M2,412 M3,337 M3,554 M3,874 M4,126 M5,090 M4,763 M4,981 M5,596 M
Total current liabilities1,472 M1,594 M2,705 M3,156 M3,534 M3,945 M4,558 M5,241 M5,578 M6,491 M
Total equity-704 M-564 M8,633 M7,995 M6,714 M6,003 M6,001 M6,042 M5,765 M6,112 M
Total liabilities4,000 M4,262 M12,348 M14,613 M15,595 M16,988 M18,284 M18,647 M19,572 M20,569 M
Total non-current assets1,150 M1,514 M17,871 M19,303 M18,675 M19,125 M19,474 M19,926 M19,884 M20,630 M
Total non-current liabilities2,528 M2,668 M9,643 M11,457 M12,061 M13,043 M13,726 M13,406 M13,994 M14,078 M
TotalEquityGrossMinority5,765 M6,112 M
TotalEquityGrossMinorityInterest5,765 M6,112 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest3,296 M3,926 M21,208 M22,857 M22,549 M23,251 M24,564 M24,689 M25,337 M26,681 M
TotalNonCurrentLiabilitiesNetMinorityInteres2,528 M2,668 M9,643 M11,457 M12,061 M13,043 M13,726 M13,406 M13,994 M14,078 M
TotalTaxPayable56 M35 M76 M72 M100 M108 M102 M137 M161 M116 M
Treasury stock-1,000 M-3,374 M-4,770 M-5,733 M-6,166 M-6,572 M-7,740 M-8,741 M
UnearnedIncome68 M105 M
UnearnedPremiums-50 M-79 M
Working capital787 M928 M809 M633 M579 M408 M918 M-478 M-597 M-895 M
debtc826000.049 M92 M103 M100 M100 M149 M91 M152 M718 M
ltinv66 M85 M82 M78 M142 M152 M162 M164 M94 M134 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