CPA Stock Annual Balance Sheet. Download in Excel

	Invalid date	Dec-17	Dec-18	Dec-19	Dec-20	Dec-21	Dec-22
Accounts payable	131 M	140 M	134 M	67 M	121 M	169 M	184 M
Accounts receivable	116 M	116 M	130 M	65 M	92 M	138 M	159 M
Accrued expenses	195 M	232 M	199 M	102 M	158 M	220 M	321 M
AccruedInterestReceivable	10 M	13 M	13 M	6 M	5 M	11 M
Accumulated depreciation & depletion							-1,345 M
Additional paid in capital	73 M	80 M	86 M	91 M	98 M	103 M	209 M
AllowanceForLoansAndLeaseLosses	4 M	1 M	957000.0	1 M	1 M	3 M
Cash and equivalents	705 M	566 M	692 M	771 M	806 M	812 M	206 M
CashCashEquivalentsAndShortTermInvestments	705 M	566 M	692 M	771 M	806 M	812 M	915 M
CashEquivalents	30 M	34 M	40 M	20 M			206 M
Common par							31 M
Common stock equity	1,867 M	1,768 M	1,906 M	1,255 M	1,271 M	1,463 M	2,122 M
CommonStock							31 M
Construction in progress							12 M
Cost in excess							20 M
CurrentAccruedExpenses	60 M	92 M	55 M	34 M	33 M	45 M	65 M
CurrentCapitalLeaseObligation		102 M	98 M	84 M	74 M	80 M	68 M
CurrentDeferredRevenue	17 M	30 M	35 M	16 M	35 M	55 M
CurrentDeferredTaxesLiabilities	52 M	49 M	43 M	22 M	19 M	17 M
Deferred revenues	70 M	79 M	79 M	38 M	54 M	72 M	55 M
DefinedPensionBenefit	3 M	5 M	249000.0	26 M	27 M	504000.0
EmployeeBenefits				14 M	8 M
Float term debt	876 M	975 M	938 M	1,036 M	1,229 M	1,302 M	1,240 M
GoodwillAndOtherIntangibleAssets	81 M	101 M	108 M	96 M	82 M	79 M	88 M
Gross fixed assets (Plant Property & Equipment)	2,617 M	3,060 M	2,823 M	2,362 M	2,679 M	3,118 M	4,865 M
IncomeTaxPayable	4 M		10 M	1 M	4 M	6 M	27 M
Intangibles							68 M
InterestPayable		45 M	52 M
Inventories	82 M	87 M	69 M	74 M	75 M	93 M	117 M
Invested capital	2,743 M	2,743 M	2,844 M	2,291 M	2,795 M	3,120 M	3,362 M
Land & improvements							6 M
Leases							76 M
LongTermCapitalLeaseObligation		273 M	207 M	147 M	105 M	158 M	215 M
LongTermDebtAndCapitalLeaseObligation	876 M	1,249 M	1,145 M	1,183 M	1,334 M	1,460 M	1,456 M
Machinery furniture & equipment							4,490 M
Marketable securities							709 M
Net fixed assets (net PP&E)	2,617 M	3,060 M	2,823 M	2,362 M	2,679 M	3,118 M	3,520 M
NetOtherUnrealizedGainLoss							-9 M
NonCurrentAccountsReceivable	2 M	1 M	2 M	1 M
NonCurrentDeferredAssets	19 M	16 M	19 M	36 M	28 M	31 M	30 M
NonCurrentDeferredLiabilities	33 M	37 M	45 M	75 M	60 M	56 M	36 M
NonCurrentDeferredRevenue	33 M	37 M	45 M	75 M	60 M	56 M
NonCurrentDeferredTaxesAssets	19 M	16 M	19 M	36 M	28 M	31 M
NonCurrentPensionAndOtherPostretirementBenefitPlans				14 M	8 M
NonCurrentPrepaidAssets	26 M	26 M	18 M	6 M	7 M	8 M
Other current assets	12 M	54 M	14 M	143 M	23 M	18 M	32 M
Other equity adjustments							-9 M
Other fixed assets							281 M
Other non-current assets	31 M	44 M	139 M	31 M	14 M	17 M	32 M
Other non-current liabilities	138 M	633 M	199 M	238 M	764 M	894 M	304 M
Other receivable	7 M	15 M	14 M	13 M	11 M	14 M
OtherCurrentBorrowings	2 M	1 M	1 M				222 M
OtherCurrentLiabilities	547 M	21 M	544 M	484 M	54 M	44 M	612 M
OtherPayable	13 M	15 M	14 M	3 M	8 M	1 M	1 M
Payables	134 M	140 M	143 M	68 M	125 M	175 M	256 M
Prepaid expenses	45 M	70 M	49 M	30 M	31 M	52 M	45 M
RecievablesAdjustmentsAllowances							-102000.0
Retained earnings	1,930 M	1,824 M	1,957 M	1,300 M	1,349 M	1,704 M	2,096 M
Short term debt	298 M	312 M	123 M	128 M	197 M	142 M	222 M
TaxesReceivable							66000.0
Total assets	4,045 M	4,286 M	4,199 M	3,980 M	4,306 M	4,690 M	5,197 M
Total current assets	1,198 M	893 M	955 M	1,329 M	1,296 M	1,236 M	1,268 M
Total current liabilities	1,058 M	747 M	1,041 M	836 M	536 M	1,194 M	1,278 M
Total equity	1,867 M	1,768 M	1,906 M	1,255 M	1,271 M	1,463 M	2,122 M
Total liabilities	2,150 M	2,666 M	2,430 M	2,345 M	2,702 M	3,198 M	3,075 M
Total non-current assets	2,846 M	3,392 M	3,244 M	2,651 M	3,009 M	3,455 M	3,929 M
Total non-current liabilities	1,092 M	1,919 M	1,389 M	1,510 M	2,166 M	2,005 M	1,796 M
TotalEquityGrossMinority	1,895 M	1,768 M	1,906 M	1,255 M	1,271 M	1,492 M	2,122 M
TotalEquityGrossMinorityInterest	1,895 M	1,768 M	1,906 M	1,255 M	1,271 M	1,492 M	2,122 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest	4,045 M	4,434 M	4,336 M	3,600 M	3,972 M	4,690 M	5,197 M
TotalNonCurrentLiabilitiesNetMinorityInteres	1,092 M	1,919 M	1,389 M	1,510 M	2,166 M	2,005 M	1,796 M
TotalTaxPayable	4 M		10 M	1 M	4 M	6 M	71 M
Treasury stock	-136 M	-136 M	-136 M	-136 M	-177 M	-345 M	-204 M
UnrealizedGainLoss							-9 M
Working capital	141 M	146 M	-87 M	494 M	760 M	42 M	-11 M
debtc	298 M	414 M	220 M	212 M	271 M	223 M	291 M
ltinv	66 M	139 M	134 M	120 M	200 M	202 M	259 M

<< PREVIOUS STOCK

NEXT STOCK>>

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