Follow this procedure.. ACME lab. 4 years balance sheet (data)2017-2020.. Excel work

CHAPTER 3 Financial Statements and Patio Analysis TABLE 3.2 Bartlett Company Balance Sheels (5000) December 31 2015 Assets 2014 $ 288 $ 163 51 Cash Marketable securities Accounts receivable Inventories 68 SO3 165 289 $1,221 $2,072 1,866 300 $1,004 $1,903 158 316 275 Total current assets Land and buildings Machinery and equipment Furniture and fixtures Vehicles Other (includes financial leases) Total gross fixed assets (ar cost) Less: Accumulated depreciation Net fixed assets 96 98 $4,669 2,295 $2,374 $3,597 $4,322 2,056 $2,266 $3,270 Total assets $ 382 $ 270 79 159 $ 620 $ 483 1,023 $1,643 $ 200 967 $1,450 $ 200 Liabilities and Stockholders' Equity Accounts payable Notes payable Accruals Total current liabilities Long-term debt (includes financial leases) Total liabilities Preferred stock: cumulative 5%, $100 par, 2,000 shares authorized and issued Common stock: $2.50 par, 100,000 shares authorized, shares issued and outstanding in 2015: 76,262; in 2014: 76,244 Paid-in capital in excess of par on common stock Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 191 190 428 418 1,135 $1,954 $3,597 1,012 $1,820 $3,270 CHAPTER 3 Financial Statements and Patio Analysis TABLE 3.2 Bartlett Company Balance Sheels (5000) December 31 2015 Assets 2014 $ 288 $ 163 51 Cash Marketable securities Accounts receivable Inventories 68 SO3 165 289 $1,221 $2,072 1,866 300 $1,004 $1,903 158 316 275 Total current assets Land and buildings Machinery and equipment Furniture and fixtures Vehicles Other (includes financial leases) Total gross fixed assets (ar cost) Less: Accumulated depreciation Net fixed assets 96 98 $4,669 2,295 $2,374 $3,597 $4,322 2,056 $2,266 $3,270 Total assets $ 382 $ 270 79 159 $ 620 $ 483 1,023 $1,643 $ 200 967 $1,450 $ 200 Liabilities and Stockholders' Equity Accounts payable Notes payable Accruals Total current liabilities Long-term debt (includes financial leases) Total liabilities Preferred stock: cumulative 5%, $100 par, 2,000 shares authorized and issued Common stock: $2.50 par, 100,000 shares authorized, shares issued and outstanding in 2015: 76,262; in 2014: 76,244 Paid-in capital in excess of par on common stock Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 191 190 428 418 1,135 $1,954 $3,597 1,012 $1,820 $3,270