TS Stock Annual Balance Sheet. Download in Excel

	Invalid date	Dec-17	Dec-18	Dec-19	Dec-20	Dec-21	Dec-22
Accounts payable	751 M	694 M	556 M	462 M	845 M	1,179 M	1,108 M
Accounts receivable	1,214 M	1,737 M	1,348 M	968 M	1,299 M	2,494 M	2,481 M
Accrued expenses	995 M	1,092 M	837 M	728 M	1,164 M	1,780 M	1,860 M
Accumulated depreciation & depletion	-7,018 M	-7,358 M	-7,789 M	-8,397 M	-8,787 M	-8,916 M	-9,235 M
Additional paid in capital	610 M	610 M	610 M	610 M	610 M	610 M
BankIndebtedness	931 M	508 M	781 M	303 M	219 M	682 M
Building & improvements	11,955 M	12,122 M	12,469 M	13,080 M	13,065 M	12,857 M
Cash and equivalents	330 M	428 M	1,554 M	585 M	318 M	1,092 M	1,638 M
CashCashEquivalentsAndShortTermInvestments	1,833 M	1,293 M	1,090 M	1,830 M	1,782 M	1,979 M	3,607 M
CashEquivalents	179 M	347 M	1,436 M	467 M	151 M	942 M
Common par	1,181 M	1,181 M	1,181 M	1,181 M	1,181 M	1,181 M
Common stock equity	11,482 M	11,783 M	11,989 M	11,263 M	11,961 M	13,906 M	16,843 M
CommonStock	1,181 M	1,181 M	1,181 M	1,181 M	1,181 M	1,181 M
Construction in progress	167 M	127 M	108 M	102 M	147 M	252 M
Cost in excess	1,292 M	1,288 M	1,320 M	1,086 M	1,085 M	1,085 M	1,104 M
CurrentCapitalLeaseObligation	138000.0	44000.0	38 M	43 M	35 M	29 M	38 M
CurrentDeferredRevenue	57 M	63 M	83 M	49 M	92 M	243 M
CurrentDeferredTaxesLiabilities	458 M	379 M	337 M	255 M	275 M	269 M
CurrentProvisions	32 M	24 M	17 M	12 M	9 M	11 M	36 M
Deferred revenues	57 M	63 M	83 M	49 M	92 M	243 M
DerivativeProductLiabilities							255000.0
EmployeeBenefits	193 M	194 M	230 M	202 M	183 M	180 M	118 M
FinancialAssets		52000.0			7 M		406 M
Finished goods	923 M	1,026 M	968 M	851 M	1,113 M	2,123 M	1,402 M
Float term debt	35 M	29 M	41 M	316 M	111 M	46 M	48 M
GoodwillAndOtherIntangibleAssets	1,661 M	1,466 M	1,562 M	1,429 M	1,372 M	1,333 M	1,377 M
Gross fixed assets (Plant Property & Equipment)	13,247 M	13,422 M	14,112 M	14,832 M	14,721 M	14,584 M	15,445 M
IncomeTaxPayable	35 M	183 M	65 M	28 M	73 M	280 M	488 M
Intangibles	368 M	178 M	241 M	343 M	288 M	247 M	273 M
InterestPayable	18 M	11 M	13 M	16 M	3 M	27 M
Inventories	2,368 M	2,524 M	2,266 M	1,637 M	2,673 M	3,987 M	3,921 M
InventoriesAdjustmentsAllowances	-216 M	-210 M	-218 M	-264 M	-246 M	-223 M	-209 M
Invested capital	11,517 M	11,812 M	12,030 M	11,579 M	12,072 M	13,952 M	16,891 M
Land & improvements	712 M	733 M	799 M	840 M	830 M	816 M	890 M
Leases			262 M	315 M	178 M	169 M
LineOfCredit	131000.0	2 M	24000.0	98000.0	60000.0	94000.0
LongTermCapitalLeaseObligation	59000.0		192 M	214 M	83 M	84 M	97 M
LongTermDebtAndCapitalLeaseObligation	35 M	29 M	233 M	530 M	194 M	130 M	145 M
LongTermProvisions	36 M	36 M	55 M	73 M	84 M	98 M	101 M
Machinery furniture & equipment	371 M	377 M	414 M	433 M	441 M	433 M	14,027 M
Minority interest	99 M	93 M	197 M	184 M	145 M	129 M	187 M
Net fixed assets (net PP&E)	6,229 M	6,064 M	6,323 M	6,435 M	5,934 M	5,668 M	6,210 M
Non-current deferred income taxes	458 M	379 M	337 M	255 M	275 M	269 M	632 M
NonCurrentAccountsReceivable	151 M	128 M	135 M	136 M	179 M	162 M
NonCurrentDeferredAssets	154 M	182 M	226 M	206 M	246 M	209 M
NonCurrentDeferredLiabilities	458 M	379 M	337 M	255 M	275 M	269 M	632 M
NonCurrentDeferredTaxesAssets	154 M	182 M	226 M	206 M	246 M	209 M
NonCurrentPensionAndOtherPostretirementBenefitPlans	125 M	115 M	145 M	137 M	112 M	109 M
NonCurrentPrepaidAssets	32 M	24 M	22 M	18 M	27 M	50 M
Other current assets		1000.0					66 M
Other equity adjustments	-1,027 M	-1,124 M	-1,176 M	-1,186 M	-1,269 M	-1,346 M
Other fixed assets	42 M	63 M	61 M	62 M	60 M	57 M	528 M
Other non-current assets							871 M
Other non-current liabilities	24 M	20 M	21 M	44 M	48 M	50 M	154 M
Other receivable	22 M	33 M	33 M	17 M	24 M	60 M	50 M
OtherCurrentBorrowings	-12000.0	-11000.0	-10000.0	303 M	220 M	682 M	535 M
OtherCurrentLiabilities	56 M	30 M	25 M	31 M	40 M	43 M	423 M
OtherEquityAdjustments	-203 M	-204 M	-219 M	-227 M	-218 M	-208 M
OtherInventories	274 M	238 M	194 M	159 M	253 M		2,159 M
OtherPayable	142 M	148 M	153 M	175 M	175 M	225 M	264 M
Payables	995 M	1,092 M	837 M	728 M	1,164 M	1,780 M	1,860 M
Prepaid expenses	74 M	62 M	56 M	46 M	62 M	100 M	104 M
Raw materials	767 M	761 M	708 M	632 M	844 M	1,150 M	570 M
Retained earnings	10,719 M	11,116 M	11,375 M	10,658 M	11,440 M	13,462 M
Short term debt	131000.0	2 M	24000.0	98000.0	60000.0	94000.0	535 M
TaxesReceivable	150 M	126 M	167 M	139 M	201 M	252 M	265 M
Total assets	14,398 M	14,251 M	14,843 M	13,716 M	14,449 M	17,550 M	21,082 M
Total current assets	5,381 M	5,464 M	5,671 M	4,288 M	4,981 M	8,469 M	10,504 M
Total current liabilities	2,071 M	1,718 M	1,780 M	1,166 M	1,560 M	2,788 M	2,902 M
Total equity	11,482 M	11,783 M	11,989 M	11,263 M	11,961 M	13,906 M	16,843 M
Total liabilities	2,817 M	2,376 M	2,657 M	2,270 M	2,344 M	3,516 M	4,051 M
Total non-current assets	9,017 M	8,787 M	9,172 M	9,429 M	9,468 M	9,082 M	10,577 M
Total non-current liabilities	746 M	657 M	876 M	1,103 M	784 M	727 M	1,149 M
TotalEquityGrossMinority	11,589 M	11,875 M	12,186 M	11,446 M	12,106 M	14,034 M	17,030 M
TotalEquityGrossMinorityInterest	11,589 M	11,875 M	12,186 M	11,446 M	12,106 M	14,034 M	17,030 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest	14,398 M	14,251 M	14,843 M	13,716 M	14,449 M	17,550 M	21,082 M
TotalNonCurrentLiabilitiesNetMinorityInteres	746 M	657 M	876 M	1,103 M	784 M	727 M	1,149 M
TotalTaxPayable	102 M	250 M	128 M	91 M	143 M	376 M	488 M
Work in progress	620 M	709 M	613 M	417 M	708 M	937 M
Working capital	3,310 M	3,744 M	2,879 M	3,239 M	4,212 M	5,680 M	7,602 M
debtc	931 M	510 M	819 M	347 M	254 M	711 M	573 M
ltinv	790 M	924 M	905 M	1,204 M	1,704 M	1,661 M	1,616 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