SQM Stock Annual Balance Sheet. Download in Excel

	Invalid date	Dec-17	Dec-18	Dec-19	Dec-20	Dec-21
Accounts payable	196 M	164 M	206 M	204 M	280 M	375 M
Accounts receivable	471 M	474 M	368 M	313 M	590 M	1,002 M
Accrued expenses	420 M	359 M	326 M	267 M	390 M	665 M
Accumulated depreciation & depletion	-2,796 M	-2,997 M	-3,181 M	-3,349 M	-3,558 M	-3,792 M
Additional paid in capital	-4000.0	-253000.0	-832000.0	3 M
AllowanceForLoansAndLeaseLosses	21 M	20 M	21 M	20 M		9 M
Building & improvements	610 M	649 M	666 M	705 M	767 M	803 M
Cash and equivalents	630 M	556 M	112 M	247 M	1,515 M	2,655 M
CashCashEquivalentsAndShortTermInvestments	153 M	112 M	109 M	86 M	40 M	54 M
CashEquivalents	579 M	454 M	476 M	262 M	853 M	2,126 M
Common par	477 M	477 M	477 M	477 M	1,578 M	1,578 M
Common stock equity	2,188 M	2,085 M	2,086 M	2,123 M	3,182 M	4,897 M
CommonStock	477 M	477 M	477 M	477 M	1,578 M	1,578 M
Construction in progress	165 M	208 M	375 M	486 M	732 M	1,329 M
Cost in excess	38 M	35 M	35 M	42 M	35 M	967000.0
CurrentAccruedExpenses	19 M	20 M	22 M	24 M
CurrentCapitalLeaseObligation			8 M	6 M	8 M	12 M
CurrentDeferredAssets	64 M	89 M	124 M	223 M	248 M	352 M
CurrentDeferredRevenue	5 M	19 M	3 M	6 M
CurrentDeferredTaxesAssets	64 M	89 M	124 M	223 M	248 M	352 M
CurrentDeferredTaxesLiabilities	12 M	21 M	17 M	8 M		290 M
CurrentProvisions	63 M	106 M	132 M	128 M	318 M	1,303 M
Deferred revenues	17 M	40 M	20 M	15 M
DefinedPensionBenefit	9 M	9 M	10 M	10 M		279000.0
DerivativeProductLiabilities	9 M	12 M	16 M	14 M	73 M	20 M
DividendsPayable	111 M	110 M	69 M	8 M	34 M	7 M
EmployeeBenefits	34 M	37 M	36 M	32 M
FinancialAssets	9 M	13 M	4 M	37 M	245000.0	23 M
Finished goods	414 M	456 M	492 M	563 M	603 M	1,098 M
Float term debt	1,032 M	1,318 M	1,472 M	1,886 M	2,515 M	2,375 M
GoodwillAndOtherIntangibleAssets	45 M	41 M	84 M	88 M	91 M	70 M
Gross fixed assets (Plant Property & Equipment)	4,332 M	4,635 M	4,946 M	5,266 M	5,772 M	6,721 M
IncomeTaxPayable	7 M	5 M	3 M	1 M		47 M
Intangibles	7 M	6 M	49 M	46 M	57 M	69 M
InterestPayable	50 M	58 M	77 M			87 M
Inventories	902 M	914 M	983 M	1,093 M	1,184 M	1,784 M
Invested capital	4,086 M	3,703 M	4,302 M	4,931 M	3,182 M	9,219 M
Land & improvements	25 M	25 M	24 M	24 M	24 M	23 M
LongTermCapitalLeaseObligation			30 M	26 M	47 M	50 M
LongTermDebtAndCapitalLeaseObligation	1,032 M	1,318 M	1,502 M	1,912 M	2,561 M	2,424 M
LongTermProvisions	30 M	32 M	35 M	63 M	61 M	58 M
Machinery furniture & equipment	2,961 M	3,092 M	3,220 M	3,358 M	3,550 M	3,782 M
Minority interest	60 M	52 M	48 M	39 M	34 M	35 M
Net fixed assets (net PP&E)	1,536 M	1,638 M	1,765 M	1,917 M	2,214 M	2,929 M
NetUnrealizedGainLossForeignCurrency	614.0	694.0	748.0
Non-current deferred income taxes	205 M	175 M	183 M	156 M	110 M	290 M
NonCurrentAccountsReceivable	34 M	34 M	34 M	102 M	6 M	2 M
NonCurrentAccruedExpenses				4 M	4 M
NonCurrentDeferredAssets	32 M					604 M
NonCurrentDeferredLiabilities	205 M	175 M	183 M	156 M
NonCurrentDeferredRevenue				4 M	4 M
NonCurrentDeferredTaxesAssets	32 M	140 M	138 M	161 M		604 M
NonCurrentPensionAndOtherPostretirementBenefitPlans			36 M	32 M	27 M	44 M
NonCurrentPrepaidAssets	771000.0	712000.0	551000.0	731000.0
Other current assets	215000.0	341000.0	604000.0	414000.0	754000.0	1 M
Other equity adjustments	-14 M	-15 M	-14 M	7 M
Other fixed assets	299 M	308 M	341 M	338 M	340 M	390 M
Other non-current assets	18 M	27 M	524000.0	3 M	6 M	8 M
Other non-current liabilities	1,032 M	1,793 M	1,475 M	281 M	4,121 M	-70000.0
Other receivable	18 M	20 M	72 M	95 M	101 M	128 M
OtherCurrentBorrowings	177 M	15 M	281 M	37 M		346 M
OtherCurrentLiabilities	48 M	15 M	22 M	15 M	2 M	293 M
OtherEquityAdjustments	-14 M	-15 M	-14 M	7 M
OtherPayable	7 M	6 M	5 M	15 M	29 M	9 M
Payables	401 M	339 M	304 M	251 M	557 M	836 M
Prepaid expenses	21 M	21 M	30 M	32 M	72 M	75 M
Properties	272 M	354 M	320 M	355 M	359 M	394 M
Raw materials	32 M	34 M	33 M	42 M	54 M	95 M
Restricted cash						30 M
Retained earnings	1,725 M	1,623 M	1,623 M	1,638 M	1,648 M	3,350 M
Short term debt	177 M	15 M	281 M	37 M	41 M	474 M
TaxesReceivable	54 M	100 M	132 M	177 M	204 M	384 M
Total assets	4,296 M	4,268 M	4,684 M	4,818 M	7,044 M	10,819 M
Total current assets	2,466 M	2,398 M	2,682 M	2,569 M	4,586 M	6,992 M
Total current liabilities	748 M	556 M	777 M	476 M	992 M	3,052 M
Total equity	2,188 M	2,085 M	2,086 M	2,123 M	3,182 M	4,897 M
Total liabilities	2,049 M	2,130 M	2,550 M	2,656 M	3,828 M	5,887 M
Total non-current assets	1,830 M	1,870 M	2,002 M	2,249 M	2,458 M	3,828 M
Total non-current liabilities	1,301 M	1,575 M	1,773 M	2,180 M	2,837 M	2,836 M
TotalEquityGrossMinority	1,784 M	1,675 M	1,671 M	1,678 M	3,216 M	3,385 M
TotalEquityGrossMinorityInterest	1,784 M	1,675 M	1,671 M	1,678 M	3,216 M	3,385 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest	4,296 M	4,268 M	4,684 M	4,818 M	7,044 M	10,819 M
TotalNonCurrentLiabilitiesNetMinorityInteres	1,301 M	1,575 M	1,773 M	2,180 M	2,837 M	2,836 M
TotalTaxPayable	86 M	60 M	25 M	25 M	215 M	447 M
Work in progress	456 M	424 M	458 M	488 M	527 M	591 M
Working capital	1,066 M	1,272 M	813 M	1,148 M	3,594 M	3,940 M
debtc	177 M	15 M	288 M	42 M	48 M	487 M
ltinv	187 M	115 M	114 M	101 M

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