Did I do this right?

ATTLEBORO GROUP, INC. Comparative Balance Sheet December 31, 2012 and 2011
	2012		2011		Increase (Decrease)
Current assets:
Cash and cash equivalents	$ 11,800		$ 15,200		$ (3,400)
Accounts receivable	42,200		43,900		(1,700)
Inventories	96,800		93,500		3,300
Plant assets:
Land	39,800		14,000		25,800
Equipment, net	101,100		93,800		7,300
Total assets		$ 291,700		$ 260,400		$ 31,300
Current liabilities:
Accounts payable	$ 25,100		$ 26,300		$ (1,200)
Accrued liabilities	24,200		22,500		1,700
Long-term liabilities:
Notes payable	51,000		64,000		(13,000)
Stockholders equity:
Common stock	136,600		128,300		8,300
Retained earnings	54,800		19,300		35,500
Total liabilities and stockholders equity		$ 291,700		$ 260,400		$ 31,300

ATTLEBORO GROUP, INC. Income Statement Year Ended December 31, 2012
	Revenues:
	Sales revenue			$ 441,000
	Interest revenue			11,300
	Total revenues Expenses:				$ 452,300
	Cost of goods sold	$ 205,300
	Salary expense	76,500
	Depreciation expense	15,100
	Other operating expense	49,600
	Interest expense	24,700
	Income tax expense Total expenses		16,700	387,900
	Net income				$ 64,400

Requirement

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

Attleboro Group, Inc. Spreadsheet for Statement of Cash Flows (Indirect Method)
Year Ended December 31, 2012
PANEL A BALANCE SHEET	BALANCE	TRANSACTION ANALYSIS		BALANCE
	12/31/2011	DEBIT	CREDIT	12/31/2012
Cash	$15,200.00		-$3,400.00	$11,800.00
Accounts receivable	$43,900.00		-$1,700.00	$42,200.00
Inventories	$93,500.00		$3,300.00	$96,800.00
Plant assets:
Land	$14,000.00		$25,800.00	$39,800.00
Equipment	$93,800.00		$7,300.00	$101,100.00
Total assets	$260,400.00		$31,300.00	$291,700.00
Current liabilities:
Accounts payable	$26,300.00	-$1,200.00		$25,100.00
Accruded liabilities	$22,500.00		$1,700.00	$24,200.00
Long-term liabilities
Notes payable	$64,000.00		-$13,000.00	$51,000.00
Stockholders' equity:
Common stock	$128,300.00		$8,300.00	$136,600.00
Retained earnings	$19,300.00		$35,500.00	$54,800.00
Total liabilities and stockholders' equity	$260,400.00		$31,300.00	$291,700.00
Attleboro Group, Inc.
Spreadsheet for Statement of Cash Flows (Indirect Method)
Year Ended December 31, 2012
PANEL B STATEMENT OF CASH FLOWS	BALANCE	TRANSACTION ANALYSIS		BALANCE
	12/31/2011	DEBIT	CREDIT	12/31/2012
Cash flows from operation activities:
Net income		$64,400.00
Adjustments to reconcile net income to net
cash provied by operation activities:
Depreciation		$15,100.00
Decrease in accounts receivable			$1,700.00
Increase in inventories			-$3,300.00
Decrease in accounts payable			-$1,200.00
Increase in accrued liabilities			$1,700.00
Net cash flow from operating activity				$78,400.00
Cash flows for investing activities
Purchase of land			-$25,800.00
Purchase of equipment			-$22,400.00
Net cash flow from investing activity				-$48,200.00
Cash flow from financing activity
Repayment of note payable			$13,000.00
Issue of common stock		$8,300.00
Dividend paid			$28,900.00
Net cash flow from financing activity				-$33,600.00
Net decrease				-$3,400.00