SQ Stock Annual Balance Sheet. Download in Excel

	Invalid date	Dec-16	Dec-17	Dec-18	Dec-19	Dec-20	Dec-21	Dec-22
Accounts payable	444 M	734 M	36 M	42 M	47 M	82 M	96 M	143 M
Accounts receivable	6 M	9 M	22 M	34 M	42 M	90 M	141 M	135 M
Accrued expenses	504 M	813 M	298 M	298 M	361 M	703 M	1,074 M	1,326 M
Accumulated depreciation & depletion	-73 M	-101 M	-125 M	-179 M	-228 M	-259 M	-368 M	-323 M
Additional paid in capital	1,357 M	1,630 M	2,012 M	2,224 M	2,955 M	3,317 M	18,315 M	19,602 M
Cash and equivalents	452 M	696 M	583 M	1,047 M	3,158 M	4,444 M	4,544 M	4,996 M
CashCashEquivalentsAndShortTermInvestments	512 M	866 M	1,124 M	1,540 M	3,853 M	5,313 M	5,626 M	5,848 M
CashEquivalents	474 M	725 M	617 M	1,047 M	3,158 M
Common stock equity	576 M	786 M	1,121 M	1,715 M	2,682 M	3,273 M	17,223 M	18,695 M
CommonStock	576 M	786 M	1,121 M	-1,715 M	2,682 M	409 M	-13,828 M	-7 M
Cost in excess	57 M	58 M	262 M	266 M	317 M	519 M	11,967 M	11,920 M
CurrentAccruedExpenses	40 M	52 M	298 M	298 M	361 M	703 M	1,074 M	1,326 M
CurrentCapitalLeaseObligation	17 M	19 M	28 M	27 M	53 M	64 M	67 M	54 M
CurrentDeferredRevenue	5 M	6 M	31 M	38 M	45 M	48 M
CurrentDeferredTaxesAssets	306000.0	519000.0	8 M	8 M	207 M	418 M	571 M	680 M
CurrentDeferredTaxesLiabilities	-476000.0	-644000.0	-8 M	-7 M	-199 M	-418 M	-689 M	-706 M
DeferredFinancingCosts	1 M	3 M
FinancialAssets							573 M	251 M
Float term debt		359 M	900 M	1,048 M	2,977 M	4,954 M	5,344 M	5,265 M
GoodwillAndOtherIntangibleAssets	76 M	73 M	339 M	335 M	454 M	776 M	13,981 M	13,681 M
Gross fixed assets (Plant Property & Equipment)	162 M	193 M	267 M	441 M	919 M	991 M	1,070 M	864 M
IncomeTaxPayable	4 M	6 M	10 M
Intangibles	19 M	14 M	77 M	69 M	138 M	257 M	2,014 M	1,762 M
InterestPayable				45 M	75 M	33 M	36 M	-47 M
Inventories	14 M	17 M	29 M	48 M	61 M
Invested capital	576 M	1,503 M	2,920 M	3,702 M	8,245 M	12,786 M	27,554 M	28,935 M
LoansReceivable	42 M	73 M	90 M	165 M	463 M	518 M	474 M	775 M
LongTermCapitalLeaseObligation	1 M	4 M	2 M	109 M	390 M	395 M	357 M	290 M
LongTermDebtAndCapitalLeaseObligation		359 M	900 M	1,048 M	2,977 M	4,954 M	5,344 M	5,265 M
LongTermProvisions			149 M
Minority interest						41 M	28 M	-2 M
Net fixed assets (net PP&E)	88 M	91 M	142 M	262 M	690 M	732 M	702 M	541 M
Non-current deferred income taxes	476000.0	644000.0	4 M		-73 M	15 M	132 M	36 M
NonCurrentDeferredAssets	44 M	103 M	334 M	676 M	2,038 M	2,831 M	3,180 M	3,170 M
NonCurrentDeferredLiabilities						15 M	132 M	36 M
NonCurrentDeferredRevenue	23 M	20 M	23 M	6 M	7 M
NonCurrentDeferredTaxesAssets	255 M	410 M	727 M	868 M	1,445 M	2,306 M	2,671 M	2,681 M
NonCurrentPrepaidAssets	2 M
NotesReceivable						91 M
Other current assets	382 M	707 M	564 M	839 M	1,408 M	1,859 M	4,044 M	5,580 M
Other equity adjustments	-2 M	-1 M	-6 M	2 M	23 M
Other fixed assets	88 M	91 M	142 M	262 M	690 M	732 M	702 M	541 M
Other non-current assets	18 M	41 M	74 M	196 M	499 M	371 M	484 M	739 M
Other non-current liabilities	58 M	70 M	93 M	94 M	85 M	208 M	202 M	155 M
Other receivable	42 M	73 M	90 M	165 M	463 M
OtherCurrentLiabilities	74 M	160 M	54 M	96 M	239 M	255 M	463 M	8 M
OtherInventories	14 M	17 M	29 M	48 M	61 M	77 M	98 M	110 M
OtherPayable	20 M	27 M	112 M	20 M	79 M
Payables	464 M	761 M	749 M
Preferred securities of subsidiary trust	100 M	100 M	100 M	100 M	100 M
PreferredStock	100 M	100 M	100 M	100 M	100 M
Prepaid expenses	7 M	14 M	22 M	23 M	34 M	63 M	141 M	398 M
Restricted cash	22 M	29 M	34 M	39 M	4,793 M	19 M	640 M	770 M
Retained earnings	-781 M	-844 M	-892 M	-509 M	-274 M	-44 M	-1,092 M	-907 M
Short term debt					464 M	498 M	922 M	753 M
Total assets	1,211 M	2,187 M	3,281 M	4,551 M	9,870 M	15,026 M	31,364 M	34,070 M
Total current assets	958 M	1,675 M	1,778 M	2,544 M	5,724 M	11,622 M	15,623 M	18,857 M
Total current liabilities	577 M	973 M	352 M	421 M	1,117 M	6,536 M	8,435 M	9,922 M
Total equity	576 M	786 M	1,121 M	1,715 M	2,682 M	3,273 M	17,223 M	18,695 M
Total liabilities	635 M	1,401 M	1,494 M	1,563 M	4,179 M	11,713 M	14,113 M	15,377 M
Total non-current assets	254 M	512 M	1,503 M	2,008 M	4,146 M	6,236 M	18,921 M	18,383 M
Total non-current liabilities	58 M	428 M	1,142 M	1,142 M	3,062 M	5,177 M	5,678 M	5,455 M
TotalEquityGrossMinority	576 M	786 M	1,121 M	1,715 M	2,682 M	3,314 M	17,251 M	18,693 M
TotalEquityGrossMinorityInterest	576 M	786 M	1,121 M	1,715 M	2,682 M	3,314 M	17,251 M	18,693 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest	1,211 M	2,187 M	2,614 M	4,551 M	9,870 M	15,026 M	31,364 M	34,070 M
TotalNonCurrentLiabilitiesNetMinorityInteres	58 M	428 M	1,142 M	1,142 M	3,062 M	5,177 M	5,678 M	5,455 M
UnearnedIncome			149 M
Working capital	380 M	702 M	1,426 M	2,123 M	4,607 M	5,086 M	7,189 M	8,936 M
debtc				27 M	517 M	498 M	922 M	753 M
ltinv	27 M	204 M	465 M	537 M	464 M	1,526 M	573 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