PUBGY Stock Annual Balance Sheet. Download in Excel

	Dec-11	Dec-12	Dec-13	Dec-14	Dec-16	Dec-17	Dec-18	Dec-19	Dec-20	Dec-21
Accounts payable	7,745 M	8,249 M	8,636 M	9,640 M	11,992 M	11,541 M	12,176 M	13,411 M	12,887 M	14,479 M
Accounts receivable	6,436 M	6,832 M	6,994 M	7,676 M	10,010 M	8,907 M	9,115 M	10,233 M	9,508 M	11,315 M
Accumulated depreciation & depletion	-727 M	-807 M	-828 M	-927 M	-1,174 M	-1,048 M	-1,377 M	-1,193 M	-1,948 M	-2,283 M
Additional paid in capital	3,823 M	4,531 M
Building & improvements							1,816 M	2,489 M	2,329 M	2,421 M
Capital lease obligations	84 M	81 M	78 M	88 M	101 M	0.0	2,041 M	2,532 M	2,142 M	2,089 M
Cash and equivalents	2,174 M	1,314 M	1,442 M	3,158 M	2,228 M	2,407 M	3,206 M	3,413 M	3,700 M	3,659 M
CashCashEquivalentsAndShortTermInvestments	2,174 M	1,314 M	1,442 M	3,158 M	2,228 M	2,407 M	3,206 M	3,413 M	3,700 M	3,659 M
CashEquivalents	1,883 M	965 M	1,001 M	2,666 M	112 M	1,390 M	2,273 M	2,268 M	1,884 M	2,136 M
Common par	77 M	84 M	86 M	88 M	90 M	92 M	94 M	96 M	99 M	101 M
Common stock equity	3,900 M	4,615 M	5,095 M	6,086 M	6,055 M	5,956 M	6,853 M	7,401 M	7,182 M	8,588 M
CommonStock	77 M	84 M	86 M	88 M	90 M	92 M	94 M	96 M	99 M	101 M
Cost in excess	5,207 M	5,667 M	6,123 M	7,006 M	9,150 M	8,450 M	8,751 M	11,629 M	10,858 M	11,760 M
CurrentCapitalLeaseObligation	0.0	0.0	0.0	0.0	0.0	0.0	393 M	336 M	292 M	288 M
CurrentProvisions	137 M	166 M	139 M	125 M	130 M	98 M	125 M	170 M	234 M	274 M
Finished goods			307 M	320 M	406 M	385 M	367 M
Float term debt	1,376 M	649 M	460 M	1,539 M	3,028 M	2,780 M	2,425 M	4,286 M	3,653 M	3,446 M
GoodwillAndOtherIntangibleAssets	6,192 M	6,649 M	7,062 M	7,961 M	10,495 M	9,574 M	9,876 M	13,608 M	12,367 M	13,139 M
Gross fixed assets (Plant Property & Equipment)	496 M	506 M	1,341 M	1,479 M	1,814 M	1,638 M	3,720 M	4,034 M	4,219 M	4,387 M
Intangibles	985 M	982 M	939 M	955 M	1,345 M	1,124 M	1,125 M	1,979 M	1,509 M	1,379 M
Inventories	343 M	342 M	307 M	320 M	406 M	385 M	367 M	411 M	230 M	277 M
InventoriesAdjustmentsAllowances	-2 M	-2 M	-4 M	-3 M	-29 M	-32 M	-1000000.0		-13 M
Invested capital	5,276 M	5,264 M	5,555 M	7,625 M	9,083 M	8,736 M	9,278 M	11,687 M	10,835 M	12,034 M
Land & improvements	271 M		265 M	270 M	282 M	268 M	168 M	166 M	167 M	167 M
LongTermCapitalLeaseObligation	84 M	81 M	78 M	88 M	101 M	0.0	1,648 M	2,196 M	1,850 M	1,801 M
LongTermDebtAndCapitalLeaseObligation	1,460 M	730 M	538 M	1,627 M	3,028 M	2,780 M	4,073 M	6,482 M	5,503 M	5,247 M
LongTermProvisions	483 M	464 M	368 M	442 M	556 M	415 M	384 M	426 M	468 M	543 M
Machinery furniture & equipment				794 M	978 M	884 M	1,097 M	1,267 M	1,093 M	1,129 M
Minority interest	33 M	44 M	38 M	29 M	10 M	2 M	0.0	-9 M	-22 M	-33 M
Net fixed assets (net PP&E)	496 M	506 M	513 M	552 M	640 M	590 M	2,343 M	2,841 M	2,271 M	2,104 M
Non-current deferred income taxes	241 M	238 M	295 M	360 M	649 M	419 M	446 M	413 M	247 M	274 M
NonCurrentDeferredAssets	0.0
NonCurrentDeferredTaxesAssets	82 M	96 M	126 M	133 M	150 M	130 M	150 M	143 M	137 M	175 M
NonCurrentPrepaidAssets	28 M	24 M	23 M	22 M	41 M	31 M	32 M	33 M	33 M	32 M
Other fixed assets	496 M	506 M	1,076 M	415 M	554 M	486 M	639 M	2,601 M	630 M	670 M
Other non-current assets								1000000.0
Other receivable	119 M	92 M	70 M	65 M	70 M	922 M	1,022 M	1,078 M	1,069 M	1,130 M
OtherCurrentLiabilities	212 M	235 M	651 M	590 M	561 M	528 M	486 M	432 M	530 M	672 M
OtherInventories			311 M	323 M	435 M	417 M	368 M		243 M
OtherPayable	452 M	445 M	433 M	471 M	588 M	586 M	614 M	665 M	883 M	1,031 M
Payables	8,475 M	8,956 M	9,294 M	10,401 M	12,856 M	12,754 M	13,405 M	14,775 M	14,363 M	16,211 M
Prepaid expenses	227 M	241 M	228 M	225 M	316 M	285 M	247 M	277 M	265 M	385 M
Properties	952 M	269 M	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
Retained earnings	3,821 M
Short term debt	838 M	379 M	322 M	533 M	283 M	350 M	449 M	1,602 M	856 M	184 M
TaxesReceivable	206 M	248 M	185 M	238 M	188 M	252 M	264 M	366 M	240 M	340 M
Total assets	16,450 M	16,604 M	17,110 M	20,626 M	24,896 M	23,780 M	27,080 M	32,659 M	30,161 M	32,846 M
Total current assets	9,524 M	9,088 M	9,260 M	11,749 M	13,342 M	13,253 M	14,434 M	15,816 M	15,130 M	17,127 M
Total current liabilities	10,333 M	10,513 M	10,776 M	12,082 M	14,598 M	14,208 M	15,324 M	17,946 M	16,783 M	18,227 M
Total equity	3,900 M	4,615 M	5,095 M	6,086 M	6,055 M	5,956 M	6,853 M	7,401 M	7,182 M	8,588 M
Total non-current assets	6,926 M	7,516 M	7,850 M	8,877 M	11,554 M	10,527 M	12,646 M	16,843 M	15,031 M	15,719 M
Total non-current liabilities	2,184 M	1,432 M	1,201 M	2,429 M	4,233 M	3,614 M	4,903 M	7,321 M	6,218 M	6,064 M
TotalEquityGrossMinority	3,933 M	4,659 M	5,133 M	6,115 M	6,065 M	5,958 M	6,853 M	7,392 M	7,160 M	8,555 M
TotalTaxPayable	278 M	262 M	225 M	290 M	276 M	627 M	615 M	699 M	593 M	701 M
Work in progress	345 M	344 M	311 M	323 M	435 M	417 M	368 M
Working capital	-809 M	-1,425 M	-1,516 M	-333 M	-1,256 M	-955 M	-890 M	-2,130 M	-1,653 M	-1,100 M
debtc	838 M	379 M	322 M	533 M	283 M	350 M	842 M	1,938 M	1,148 M	472 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