AKA Stock Annual Balance Sheet. Download in Excel

	Invalid date	Dec-21	Dec-22
Accounts payable	25 M	21 M	28 M
Accounts receivable	3 M	3 M	5 M
Accrued expenses	78 M	61 M	54 M
Accumulated depreciation & depletion	-3 M	-174 M	-69 M
Additional paid in capital	454 M	461 M	466 M
Cash and equivalents	39 M	48 M	22 M
CashCashEquivalentsAndShortTermInvestments	39 M	48 M	22 M
CashEquivalents		48 M
Common par	129000.0	129000.0	128000.0
Common stock equity	451 M	247 M	149 M
CommonStock	129000.0	129000.0	128000.0
Cost in excess	363 M	168 M	95 M
CurrentAccruedExpenses	53 M	40 M	25 M
CurrentCapitalLeaseObligation	6 M	7 M	8 M
CurrentDeferredRevenue	11 M	11 M	12 M
CurrentDeferredTaxesAssets	16 M	20 M	23 M
CurrentDeferredTaxesLiabilities	19 M	8 M	21 M
Deferred revenues	18 M	15 M	21 M
DeferredFinancingCosts	-2 M		-1 M
Deposits		3 M
Float term debt	125 M	138 M	125 M
GeneralPartnershipCapital	451 M	247 M
GoodwillAndOtherIntangibleAssets	462 M	244 M	159 M
Gross fixed assets (Plant Property & Equipment)	44 M	240 M	133 M
IncomeTaxPayable			257000.0
Intangibles	98 M	76 M	64 M
InterestPayable	9 M	7 M	11 M
Inventories	116 M	127 M	91 M
Invested capital	679 M	385 M	364 M
LongTermCapitalLeaseObligation	21 M	34 M	35 M
LongTermDebtAndCapitalLeaseObligation	125 M	172 M	125 M
Net fixed assets (net PP&E)	41 M	66 M	65 M
Non-current deferred income taxes	3 M	284000.0	-2 M
NonCurrentDeferredAssets		1 M	2 M
NonCurrentDeferredLiabilities	3 M	284000.0
NonCurrentDeferredTaxesAssets	16 M	1 M	2 M
Other current assets	6 M	7 M	10 M
Other equity adjustments		-45 M
Other fixed assets	41 M		65 M
Other non-current assets	850000.0	853000.0	618000.0
Other non-current liabilities	1 M	1 M	2 M
Other receivable	562 M	612 M	546 M
OtherEquityInterest	-746000.0
OtherInventories	116 M		91 M
OtherPayable	249 M	5 M
Payables	25 M	21 M	29 M
Preferred securities of subsidiary trust		50 M
PreferredStock		50 M
Prepaid expenses	25 M	19 M	16 M
RecievablesAdjustmentsAllowances			-200000.0
Restricted cash	2 M		2 M
Retained earnings	-3 M	-169 M	-318 M
Short term debt	6 M	6 M	3 M
Total assets	688 M	510 M	362 M
Total current assets	184 M	198 M	136 M
Total current liabilities	108 M	88 M	86 M
Total equity	451 M	247 M	149 M
Total liabilities	237 M	263 M	213 M
Total non-current assets	504 M	312 M	226 M
Total non-current liabilities	129 M	174 M	127 M
TotalEquityGrossMinority	451 M	247 M	149 M
TotalEquityGrossMinorityInterest	451 M	247 M	149 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest	688 M	510 M	362 M
TotalNonCurrentLiabilitiesNetMinorityInteres	129 M	174 M	127 M
TotalTaxPayable			257000.0
Working capital	76 M	109 M	50 M
debtc	11 M	12 M	11 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