QBCRF Stock Annual Balance Sheet. Download in Excel

	Dec-14	Dec-15	Dec-16	Dec-17	Dec-18	Dec-19	Dec-20	Dec-21	Dec-22	Dec-23
Accounts payable	468 M	471 M	706 M	763 M	586 M	579 M	667 M	682 M	771 M	926 M
Accounts receivable	398 M	433 M	525 M	543 M	468 M	461 M	460 M	614 M	688 M	974 M
Accrued expenses	721 M	653 M	741 M	776 M	897 M	786 M	919 M	894 M	964 M	1,180 M
Accumulated depreciation & depletion	-3,418 M	-3,932 M	-4,342 M	-4,786 M	-5,280 M	-5,824 M	-6,268 M	-6,623 M	-6,986 M	-7,118 M
Additional paid in capital	2 M	2 M	2 M	4 M	5 M	17 M	17 M	17 M	17 M	17 M
Cash and equivalents	395 M	19 M	22 M	865 M	21 M	14 M	137 M	65 M	7 M	11 M
CashCashEquivalentsAndShortTermInvestments	395 M	19 M	22 M	865 M	21 M	14 M	137 M	65 M	7 M	11 M
CashEquivalents	239 M	2 M	800000.0	2 M	800000.0	9 M
Common par	327 M	326 M	323 M	314 M	1,066 M	1,056 M	1,018 M	965 M	916 M	915 M
Common stock equity	504 M	299 M	599 M	861 M	480 M	978 M	1,113 M	1,256 M	1,357 M	1,727 M
CommonStock	327 M	326 M	323 M	314 M	1,066 M	1,056 M	1,018 M	965 M	916 M	915 M
Construction in progress	38 M	75 M	93 M	46 M	91 M	97 M	95 M	107 M
Cost in excess	2,715 M	2,678 M	2,725 M	2,696 M	2,678 M	2,693 M	2,714 M	2,719 M	2,726 M	2,721 M
CurrentAccruedExpenses	167 M	173 M	186 M	198 M	191 M	203 M	183 M	164 M	46 M	53 M
CurrentCapitalLeaseObligation				40 M	36 M	31 M	34 M	36 M	37 M	99 M
CurrentDeferredRevenue	283 M	322 M	340 M	347 M	341 M	333 M	308 M	472 M	306 M	371 M
CurrentProvisions	57 M	67 M	69 M	25 M	32 M	16 M	23 M	15 M	18 M	31 M
Deferred revenues	283 M	322 M	340 M	347 M	341 M	333 M	308 M	472 M	345 M	371 M
DefinedPensionBenefit	3 M		9 M
DerivativeProductLiabilities	334 M	340 M	300000.0	34 M		2 M	28 M	23 M		54 M
EmployeeBenefits	151 M	178 M	167 M	165 M	165 M	222 M	324 M	166 M
FinancialAssets	401 M	1,072 M	809 M	592 M	887 M	680 M	626 M	406 M	200 M	36 M
Finished goods	116 M	78 M	76 M	88 M	89 M	94 M	84 M
Float term debt	5,548 M	6,312 M	6,117 M	5,516 M	6,520 M	6,050 M	5,895 M	6,618 M	5,468 M	6,152 M
GoodwillAndOtherIntangibleAssets	3,692 M	3,893 M	3,949 M	3,679 M	3,814 M	4,137 M	4,181 M	5,063 M	5,001 M	6,106 M
Gross fixed assets (Plant Property & Equipment)	6,848 M	7,357 M	7,947 M	8,530 M	8,860 M	9,351 M	9,601 M	9,834 M	10,039 M	10,877 M
IncomeTaxPayable	86 M	9 M	35 M	13 M	119 M	4 M	70 M	47 M	31 M	25 M
Intangibles	978 M	1,214 M	1,224 M	983 M	1,135 M	1,444 M	1,467 M	2,344 M	2,275 M	3,385 M
InterestPayable	42 M	46 M	49 M	54 M	51 M	57 M	56 M	45 M	46 M	53 M
Inventories	212 M	216 M	183 M	199 M	203 M	240 M	251 M	283 M	406 M	512 M
Invested capital	6,052 M	6,611 M	6,716 M	6,378 M	7,000 M	7,028 M	7,008 M	7,874 M	6,825 M	7,879 M
Land & improvements									664 M	677 M
LineOfCredit	5 M	34 M	19 M	800000.0	24 M	29 M	2 M
LongTermCapitalLeaseObligation				128 M	108 M	107 M	139 M	147 M	149 M	278 M
LongTermDebtAndCapitalLeaseObligation	5,548 M	6,312 M	6,117 M	5,644 M	6,629 M	6,157 M	6,034 M	6,765 M	5,617 M	6,430 M
Machinery furniture & equipment	1,398 M	1,522 M	1,664 M	1,751 M	1,872 M	1,985 M	2,027 M	1,855 M	1,776 M	1,729 M
Minority interest	559 M	353 M	426 M	536 M	89 M	95 M	102 M	123 M	126 M	111 M
Net fixed assets (net PP&E)	3,430 M	3,425 M	3,605 M	3,744 M	3,580 M	3,526 M	3,332 M	3,211 M	3,053 M	3,759 M
NetOtherUnrealizedGainLoss									2 M	6 M
Non-current deferred income taxes	529 M	614 M	625 M	745 M	776 M	859 M	848 M	830 M	780 M	810 M
NonCurrentAccountsReceivable					61 M	61 M	109 M	128 M
NonCurrentDeferredAssets	32 M	48 M	16 M	33 M	101 M	89 M	134 M	146 M	22 M	23 M
NonCurrentDeferredLiabilities	555 M	633 M	625 M	745 M	776 M	859 M	848 M	830 M	780 M	810 M
NonCurrentDeferredRevenue	26 M	19 M	21 M	17 M	15 M
NonCurrentDeferredTaxesAssets	8 M	30 M	16 M	33 M	52 M	31 M	46 M	39 M	22 M	23 M
NonCurrentPensionAndOtherPostretirementBenefitPlans	137 M	159 M	145 M	149 M	165 M	222 M	324 M	166 M
Other current assets			102 M	106 M	102 M	121 M	113 M	132 M	136 M	192 M
Other equity adjustments	-64 M	-111 M	-106 M	-51 M	-83 M	-64 M	-134 M	-19 M	2 M	6 M
Other fixed assets	4,881 M	5,194 M	5,549 M	6,051 M	6,284 M	6,632 M	6,813 M	7,208 M	7,599 M	8,471 M
Other non-current assets	20 M	35 M	177 M	185 M	92 M	130 M	155 M	128 M	540 M	623 M
Other non-current liabilities	18 M	30 M	516 M	212 M	104 M	150 M	99 M	127 M	210 M	290 M
Other receivable	52 M	61 M	107 M	133 M	230 M	247 M	279 M	260 M	153 M	201 M
OtherCurrentBorrowings	230 M	44 M	52 M	470 M	58 M	57 M	29 M	57 M		150 M
OtherCurrentLiabilities	99 M			442 M	7 M
OtherEquityAdjustments						-64 M	-134 M	-19 M
OtherInventories	73 M	2 M	2 M	78 M	94 M	119 M	138 M		406 M	512 M
OtherPayable									116 M	176 M
Payables	553 M	480 M	741 M	776 M	706 M	583 M	737 M	729 M	918 M	1,127 M
Prepaid expenses	38 M	46 M	53 M	64 M
Properties	532 M	567 M	642 M	681 M	613 M	636 M	666 M	665 M
Raw materials	21 M	23 M	24 M	20 M	20 M	28 M	29 M
Restricted cash								162 M	39 M
Retained earnings	239 M	82 M	379 M	595 M	-508 M	-32 M	211 M	292 M	422 M	789 M
Short term debt	235 M	78 M	71 M	471 M	82 M	87 M	30 M	57 M	1,171 M	1,640 M
TaxesReceivable	7 M	29 M	7 M	29 M	5 M	19 M	5 M	7 M	11 M	49 M
Total assets	9,079 M	9,276 M	9,504 M	10,109 M	9,658 M	9,726 M	9,862 M	10,763 M	10,625 M	12,741 M
Total current assets	1,500 M	803 M	947 M	1,876 M	1,124 M	1,103 M	1,244 M	1,524 M	1,810 M	2,194 M
Total current liabilities	1,410 M	1,131 M	1,221 M	2,076 M	1,416 M	1,264 M	1,314 M	1,473 M	2,535 M	3,320 M
Total equity	504 M	299 M	599 M	861 M	480 M	978 M	1,113 M	1,256 M	1,357 M	1,727 M
Total liabilities	8,015 M	8,624 M	8,479 M	8,712 M	9,089 M	8,654 M	8,648 M	9,384 M	9,142 M	10,904 M
Total non-current assets	7,579 M	8,473 M	8,557 M	8,233 M	8,534 M	8,623 M	8,618 M	9,240 M	8,815 M	10,547 M
Total non-current liabilities	6,606 M	7,493 M	7,258 M	6,636 M	7,674 M	7,389 M	7,333 M	7,911 M	6,607 M	7,584 M
TotalEquityGrossMinority	1,063 M	652 M	1,025 M	1,397 M	569 M	1,072 M	1,214 M	1,379 M	1,484 M	1,838 M
TotalEquityGrossMinorityInterest	1,063 M	652 M	1,025 M	1,397 M	569 M	1,072 M	1,214 M	1,379 M	1,484 M	1,838 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest	9,079 M	9,276 M	9,504 M	10,109 M	9,658 M	9,726 M	9,862 M	10,763 M	10,625 M	12,741 M
TotalNonCurrentLiabilitiesNetMinorityInteres	6,606 M	7,493 M	7,258 M	6,636 M	7,674 M	7,389 M	7,333 M	7,911 M	6,607 M	7,584 M
TotalTaxPayable	86 M	9 M	35 M	13 M	119 M	4 M	70 M	47 M	31 M	25 M
UnrealizedGainLoss									2 M	6 M
Work in progress	2 M	113 M	82 M	2 M
Working capital	90 M	-328 M	-274 M	-200 M	-292 M	-161 M	-70 M	50 M	-725 M	-1,126 M
debtc	235 M	78 M	71 M	511 M	118 M	118 M	65 M	93 M	1,208 M	1,739 M
ltinv							81 M	159 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