The 2012 comparative balance sheet and income statement of Attleboro Group, Inc. follow. Attleboro had no noncash investing and financing transactions during 2012.

Requirement
1. Prepare the spreadsheet for the 2012 statement of cash flows. Format cash flows from operating activities by the indirectmethod.

Transcribed Image Text:

ATTLEBORO GROUP, INC. Comparative Balance Sheet December 31, 2012 and 2011 Increase 2012 2011 (Dccrease) Current assets: $ 11,800 $ 15,200 S (3,400) Cash and cash cquivalents Accounts receivable 42,200 43,900 (1,700) 96,800 93,500 Inventories 3,300 Plant asscts: Land 39,800 14,000 25,800 Equipment, net 101,100 93,800 7,300 $ 291,700 $ 260,400 $ 31,300 Total asscts Current liabilities: $ 25,100 $ 26,300 $ (1,200) Accounts payable Accrucd liabilitics 24,200 22,500 1,700 Long-term liabilities: Notes payable Stockholders' equity: 51,000 (13,000) 64,000 Common stock 136,600 128,300 8,300 Retained carnings 54,800 19,300 35,500 $ 291,700 $ 260,400 S 31,300 Total liabilities and stockholders' equity ATTLEBORO GROUP, INC. Income Statement Year Ended December 31, 2012 Revenues: $ 441,000 Sales revenue Interest revenue 11,300 $ 452,300 Total revenues Expenses: Cost of goods sold Salary expense Depreciation expensc Other operating cxpense S 205,300 76,500 15,100 49,600 Interest expense 24,700 Income tax expense 16,700 Total cxpenses 387,900 $ 64,400 Net income