Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
IHS Inc. logo

IHS Inc.

Sector: Information   

Industry: Telecommunications Resellers

3.62
 
USD
  
0.03
  
(0.84%)
Optionable: No  Market Cap: 1,192 M  90-day average vol: 566,056

Previous close: 3.59  Open: 3.6  Bid: 3.51  Ask: 3.65
52 week range    
2.18   
   10.13
Peers   
TRI / 
MSCI / 
MCO / 
FDS / 
MORN / 
DHX / 
TTGT / 
TRI-CA / 
Last updated: Thursday 2nd 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

IHS Balance Sheet

Annual
Invalid dateDec-21Dec-22Dec-23
"""debtc"""51 M525 M545 M
Accounts payable499 M669 M368 M
Accounts receivable469 M663 M234 M
Accrued expenses568 M739 M567 M
Accumulated depreciation & depletion-1,428 M
Additional paid in capital5,125 M5,212 M
Cash and equivalents916 M514 M294 M
CashCashEquivalentsAndShortTermInvestments916 M514 M294 M
Common par5,395 M
Common stock equity1,583 M1,131 M110 M
CommonStock5,395 M
Construction in progress213 M
Cost in excess869 M760 M619 M
CurrentCapitalLeaseObligation51 M87 M91 M
CurrentDeferredRevenue20 M86 M41 M
CurrentDeferredTaxesLiabilities186 M
CurrentProvisions343000.0483000.0277000.0
Deferred revenues186 M41 M
FinancialAssets165 M6 M2 M
Float term debt2,401 M2,906 M3,057 M
GoodwillAndOtherIntangibleAssets1,571 M1,814 M1,552 M
Gross fixed assets (Plant Property & Equipment)2,229 M3,039 M4,055 M
IncomeTaxPayable76 M
Intangibles701 M1,053 M933 M
InterestPayable179 M
Inventories42 M74 M41 M
Invested capital3,984 M4,038 M3,167 M
Land & improvements39 M
Leases21 M
LongTermCapitalLeaseObligation326 M517 M511 M
LongTermDebtAndCapitalLeaseObligation2,727 M3,424 M3,568 M
LongTermProvisions72 M85 M86 M
Machinery furniture & equipment2,238 M
Minority interest143 M227 M238 M
Net fixed assets (net PP&E)2,229 M3,039 M2,627 M
NetOtherUnrealizedGainLoss-5,293 M
NetUnrealizedGainLossForeignCurrency435.0461.0
Non-current deferred income taxes137 M
NonCurrentAccruedExpenses312000.01 M
NonCurrentDeferredAssets78 M64 M
NonCurrentDeferredLiabilities137 M
NonCurrentDeferredTaxesAssets5 M78 M64 M
NonCurrentPrepaidAssets62 M
Other current assets26 M
Other equity adjustments-5,285 M
Other fixed assets1,566 M
Other non-current assets11 M10000.078 M
Other non-current liabilities-662 M-861 M5 M
Other receivable199 M387 M319 M
OtherCurrentBorrowings39 M438 M454 M
OtherCurrentLiabilities5,431 M45 M
OtherEquityInterest5,312 M
OtherPayable343 M443 M119 M
Payables568 M739 M567 M
Prepaid expenses25 M27 M64 M
PurchasedComponents41 M
RecievablesAdjustmentsAllowances-21 M
Retained earnings-2,860 M-3,319 M
Short term debt438 M454 M
TaxesReceivable128000.01 M16 M
Total assets5,474 M6,321 M5,365 M
Total current assets1,428 M1,253 M973 M
Total current liabilities831 M1,266 M1,222 M
Total equity1,583 M1,131 M110 M
Total liabilities3,748 M4,962 M5,017 M
Total non-current assets4,046 M5,068 M4,392 M
Total non-current liabilities2,917 M3,696 M3,795 M
TotalEquityGrossMinority1,726 M1,359 M347 M
TotalEquityGrossMinorityInterest1,726 M1,359 M347 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest5,474 M6,321 M5,365 M
TotalNonCurrentLiabilitiesNetMinorityInteres2,917 M3,696 M3,795 M
TotalTaxPayable69 M70 M79 M
UnrealizedGainLoss-5,285 M
Working capital597 M-13 M-249 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