IHS Stock Annual Balance Sheet. Download in Excel

	Invalid date	Dec-21	Dec-22
Accounts payable	499 M	669 M	368 M
Accounts receivable	469 M	663 M	234 M
Accrued expenses	568 M	739 M	567 M
Accumulated depreciation & depletion			-1,428 M
Additional paid in capital	5,125 M	5,212 M
Cash and equivalents	916 M	514 M	294 M
CashCashEquivalentsAndShortTermInvestments	916 M	514 M	294 M
Common par			5,395 M
Common stock equity	1,583 M	1,131 M	110 M
CommonStock			5,395 M
Construction in progress			213 M
Cost in excess	869 M	760 M	619 M
CurrentCapitalLeaseObligation	51 M	87 M	91 M
CurrentDeferredRevenue	20 M	86 M	41 M
CurrentDeferredTaxesLiabilities		186 M
CurrentProvisions	343000.0	483000.0	277000.0
Deferred revenues		186 M	41 M
FinancialAssets	165 M	6 M	2 M
Float term debt	2,401 M	2,906 M	3,057 M
GoodwillAndOtherIntangibleAssets	1,571 M	1,814 M	1,552 M
Gross fixed assets (Plant Property & Equipment)	2,229 M	3,039 M	4,055 M
IncomeTaxPayable			76 M
Intangibles	701 M	1,053 M	933 M
InterestPayable	179 M
Inventories	42 M	74 M	41 M
Invested capital	3,984 M	4,038 M	3,167 M
Land & improvements			39 M
Leases	21 M
LongTermCapitalLeaseObligation	326 M	517 M	511 M
LongTermDebtAndCapitalLeaseObligation	2,727 M	3,424 M	3,568 M
LongTermProvisions	72 M	85 M	86 M
Machinery furniture & equipment			2,238 M
Minority interest	143 M	227 M	238 M
Net fixed assets (net PP&E)	2,229 M	3,039 M	2,627 M
NetOtherUnrealizedGainLoss			-5,293 M
NetUnrealizedGainLossForeignCurrency	435.0	461.0
Non-current deferred income taxes			137 M
NonCurrentAccruedExpenses	312000.0	1 M
NonCurrentDeferredAssets		78 M	64 M
NonCurrentDeferredLiabilities			137 M
NonCurrentDeferredTaxesAssets	5 M	78 M	64 M
NonCurrentPrepaidAssets			62 M
Other current assets			26 M
Other equity adjustments			-5,285 M
Other fixed assets			1,566 M
Other non-current assets	11 M	10000.0	78 M
Other non-current liabilities	-662 M	-861 M	5 M
Other receivable	199 M	387 M	319 M
OtherCurrentBorrowings	39 M	438 M	454 M
OtherCurrentLiabilities	5,431 M	45 M
OtherEquityInterest		5,312 M
OtherPayable	343 M	443 M	119 M
Payables	568 M	739 M	567 M
Prepaid expenses	25 M	27 M	64 M
PurchasedComponents			41 M
RecievablesAdjustmentsAllowances			-21 M
Retained earnings	-2,860 M	-3,319 M
Short term debt		438 M	454 M
TaxesReceivable	128000.0	1 M	16 M
Total assets	5,474 M	6,321 M	5,365 M
Total current assets	1,428 M	1,253 M	973 M
Total current liabilities	831 M	1,266 M	1,222 M
Total equity	1,583 M	1,131 M	110 M
Total liabilities	3,748 M	4,962 M	5,017 M
Total non-current assets	4,046 M	5,068 M	4,392 M
Total non-current liabilities	2,917 M	3,696 M	3,795 M
TotalEquityGrossMinority	1,726 M	1,359 M	347 M
TotalEquityGrossMinorityInterest	1,726 M	1,359 M	347 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest	5,474 M	6,321 M	5,365 M
TotalNonCurrentLiabilitiesNetMinorityInteres	2,917 M	3,696 M	3,795 M
TotalTaxPayable	69 M	70 M	79 M
UnrealizedGainLoss			-5,285 M
Working capital	597 M	-13 M	-249 M
debtc	51 M	525 M	545 M

<< PREVIOUS STOCK

NEXT STOCK>>

Call: 1-877-778-8358

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