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.

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