FORTY Stock Annual Balance Sheet. Download in Excel

	Dec-12	Dec-13	Dec-14	Dec-15	Dec-17	Dec-18	Dec-19	Dec-20	Dec-21	Dec-22
Accounts payable	83 M	75 M	76 M	75 M
Accounts receivable	241 M	230 M	227 M	209 M	386 M	441 M	486 M	520 M	696 M	703 M
Accrued expenses	145 M	134 M	147 M	126 M	207 M	239 M	274 M	344 M	413 M	424 M
Accumulated depreciation & depletion	-29 M	-24 M	-25 M	-17 M
Additional paid in capital	133 M	132 M	137 M	131 M	98 M	98 M	121 M	149 M
Cash and equivalents	111 M	82 M	107 M	133 M	26 M	26 M	26 M	530 M	514 M	565 M
CashCashEquivalentsAndShortTermInvestments	126 M	101 M	130 M	144 M	40 M	53 M	63 M	561 M	541 M	590 M
CashEquivalents	111 M	82 M	107 M	133 M	735000.0	17 M
Common par	4 M	4 M	4 M	4 M
Common stock equity	245 M	319 M	390 M	452 M	359 M	368 M	422 M	503 M	541 M	552 M
CommonStock	4 M	4 M	4 M	4 M					1,180 M	1,177 M
Cost in excess	327 M	227 M	373 M	162 M	617 M	641 M	724 M	872 M	933 M	926 M
CurrentAccruedExpenses	62 M	54 M	63 M	51 M	112 M	115 M	142 M	190 M	208 M	201 M
CurrentCapitalLeaseObligation	22 M	22 M	22 M				36 M	32 M	42 M	45 M
CurrentDeferredAssets					16 M	14 M
CurrentDeferredRevenue	34 M	28 M	35 M	25 M	59 M	60 M	94 M
CurrentDeferredTaxesAssets	8 M	7 M	5 M		16 M	14 M	39 M	39750.0	46 M	42 M
CurrentDeferredTaxesLiabilities	9 M	9 M	15 M	54 M	37 M	35 M	54 M	68 M	78 M	59 M
Deferred revenues	34 M	28 M	35 M	25 M	96 M	94 M	54 M	68 M	78 M	59 M
DefinedPensionBenefit					87 M	82 M	96 M	114 M	123 M	92 M
Deposits			484000.0
DividendsPayable		5 M	8 M	4000.0		5 M	7 M
Float term debt	65 M	62 M	108 M	161 M		171 M	207 M	245 M	253 M	374 M
GoodwillAndOtherIntangibleAssets	402 M	267 M	450 M	167 M	781 M	791 M	889 M	1,095 M	1,175 M	1,149 M
Gross fixed assets (Plant Property & Equipment)	51 M	44 M	45 M	31 M	30 M	29 M	147 M	174 M	173 M	172 M
Intangibles	75 M	40 M	77 M	5 M	164 M	150 M	165 M	222 M	242 M	223 M
InterestPayable	7 M	6 M	5 M	8 M	-408000.0
Inventories	2 M	2 M	2 M	5 M	3 M	4 M	9 M	24 M	21 M	35 M
Invested capital	310 M	382 M	498 M	613 M		538 M	628 M	748 M	794 M	926 M
LongTermCapitalLeaseObligation	2 M	1 M	903000.0	494000.0			81 M
LongTermDebtAndCapitalLeaseObligation	66 M	64 M	109 M	162 M
LongTermProvisions	1 M	2 M	1 M	388000.0	9 M	9 M	12 M	15 M	13 M	9 M
Minority interest	246 M	180 M	277 M	101 M	414 M	438 M	475 M	605 M	639 M	625 M
Net fixed assets (net PP&E)	21 M	19 M	20 M	14 M	30 M	29 M	147 M	174 M	173 M	172 M
NetUnrealizedGainLossForeignCurrency	253000.0
Non-current deferred income taxes	8 M	8 M	33 M	67 M				-28617.0	-32 M	-17 M
NonCurrentAccruedExpenses	1 M		788000.0
NonCurrentDeferredAssets	14 M	13 M	18 M	13 M		14 M	39 M	40 M	46 M	42 M
NonCurrentDeferredLiabilities	9 M	42 M	37 M	71 M	9 M	5 M	6 M
NonCurrentDeferredRevenue		28 M	5 M	4 M	9 M	5 M	6 M
NonCurrentDeferredTaxesAssets	14 M	13 M	18 M	13 M		14 M	39 M	40 M	46 M	42 M
NonCurrentPensionAndOtherPostretirementBenefitPlans					9 M	9 M	12 M	15 M	13 M	9 M
NonCurrentPrepaidAssets	5 M	9 M	10 M	9 M
Notes payable					139 M	171 M	207 M	245 M	253 M	374 M
Other current assets	67 M	1 M	65 M	461000.0	45 M	40 M	66 M	84 M	72 M	65 M
Other equity adjustments	-7 M	-1 M	-1 M	-2 M
Other non-current assets	31000.0	68 M	2 M	55 M	17 M	23 M	22 M	23 M	24 M
Other non-current liabilities	12 M	81 M	6 M	4 M	222 M	224 M	344 M	414 M	410 M	316 M
Other receivable	1 M	483000.0	1 M	330000.0	45 M	40 M	66 M	84 M	72 M	65 M
OtherCurrentBorrowings	80 M	86 M	134 M	139 M
OtherCurrentLiabilities	97 M	15 M	81 M	71 M	43 M	51 M	146 M	178 M	341 M	381 M
OtherEquityInterest	173000.0
OtherInventories									21 M	35 M
OtherPayable	8 M				95 M	119 M	125 M	153 M	206 M	222 M
Payables	83 M	80 M	84 M	75 M	95 M	124 M	132 M	153 M	206 M	222 M
Prepaid expenses	11 M	14 M	16 M	15 M					17 M	15 M
RecievablesAdjustmentsAllowances			-2316.0	-1739.0
Retained earnings	116 M	184 M	250 M	319 M	258 M	266 M	297 M	350 M	384 M	402 M
Short term debt	39 M	36 M	43 M	59 M	139 M	171 M	207 M	245 M	253 M	374 M
Total assets	882 M	872 M	1,125 M	1,067 M	1,564 M	1,665 M	2,089 M	2,520 M	2,749 M	2,794 M
Total current assets	369 M	333 M	358 M	357 M	695 M	781 M	966 M	1,161 M	1,302 M	1,371 M
Total current liabilities	224 M	211 M	227 M	212 M	433 M	526 M	671 M	780 M	948 M	1,001 M
Total equity	245 M	319 M	390 M	452 M	359 M	368 M	422 M	503 M	541 M	552 M
Total liabilities	391 M	372 M	458 M	515 M	724 M	792 M	1,072 M	1,295 M	1,550 M	1,609 M
Total non-current assets	19 M	22 M	62 M	22 M	32 M	37 M	1,098 M	1,331 M	1,446 M	1,422 M
Total non-current liabilities	167 M	161 M	232 M	303 M	358 M	334 M	522 M	632 M	621 M	616 M
TotalEquityGrossMinority	469 M	476 M	692 M	542 M	773 M	805 M	896 M	1,109 M	1,180 M	1,177 M
TotalEquityGrossMinorityInterest	469 M	476 M	692 M	542 M	773 M	805 M	896 M	1,109 M	1,180 M	1,177 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest	882 M	872 M	1,125 M	1,067 M	1,564 M	1,665 M	2,089 M	2,520 M	2,749 M	2,794 M
TotalNonCurrentLiabilitiesNetMinorityInteres	167 M	161 M	232 M	303 M	358 M	334 M	522 M	632 M	621 M	616 M
Treasury stock	-259000.0	-259000.0	-259000.0	-259000.0	-259000.0	259000.0	-259000.0	-259000.0	-259000.0	-259000.0
UnearnedIncome	67 M
Working capital	145 M	122 M	132 M	146 M	262 M	256 M	294 M	381 M	355 M	371 M
debtc	39 M	36 M	43 M	59 M	139 M	171 M	242 M	277 M	295 M	419 M
ltinv	3 M	162 M	203 M	451 M		-60 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