Review the data from P14-31B.

Requirement
1. Prepare the spreadsheet for All Wired€™s 2012 statement of cash flows. Format cash flows from operating activities by the indirectmethod.

Transcribed Image Text:

ALL WIRED, INC. Comparative Balance Sheet December 31, 2012 and 2011 Increase 2012 2011 (Decrease) Current assets: $ 26,700 $ 15,600 $ 11,100 Cash and cash cquivalents Accounts receivable 26,500 25,300 1,200 Inventories 79,900 91,900 (12,000) Plant assets: Land 11,000 24,500 35,500 Equipment, net 102,900 90,700 12,200 $ 271,500 $ 234,500 $ 37,000 Total assets Current liabilitics: $ 35,600 $ 30,500 $ Accounts payable Accrued liabilities 5,100 (1,700) 28,900 30,600 Long-term liabilities: Notes payable Stockholders' equity: 77,000 103,000 (26,000) Common stock 88,200 64,300 23,900 41,800 Retained carnings 6,100 35,700 Total liabilities and stockholders' cquity $ 271,500 $ 234,500 $ 37,000