(Appendix 11B) Using a Spreadsheet to Prepare a Statement of Cash Flows

Comparative balance sheets for Cincinnati Health Club are presented below.

Cincinnati Health Club Balance Sheets
		Jan. 1				Dec. 31
ASSETS
Current assets:
Cash					$9,300				$5,200
Accounts receivable					8,800				10,300
Inventory					18,600				19,800
	Total current assets				$36,700				$35,300
Property, plant, and equipment:
Building			$500,000				$500,000
Equipment			260,000				270,000
			$760,000				$770,000
Accumulated depreciation			(130,000)				(159,000)
Net property, plant, and equipment					630,000				611,000
Total assets					$666,700				$646,300
LIABILITIES AND EQUITY
Current liabilities:
Accounts payable			$36,000				$55,300
Salaries payable			11,800				9,600
Income taxes payable			10,000				1,100
	Total current liabilities				$57,800				$66,000
Long-term liabilities:
Bonds payable					400,000				370,000
	Total liabilities				$457,800				$436,000
Equity:
Common stock			$150,000				$190,000
Retained earnings			58,900				20,300
	Total equity				208,900				210,300
Total liabilities and equity					$666,700				$646,300

Additional Information:

Cincinnati Health Club reported net income of $2,700 for the year.

No buildings or equipment were sold during the year. Equipment was purchased for $10,000 cash.

Depreciation expense was $29,000.

Bonds payable of $60,000 were issued for cash during the year.

Common stock of $40,000 was issued during the year.

Cash dividends of $41,300 were declared and paid during the year

Cincinnati Health Club Statement of Cash Flows For the year ending December 31

Cash flows from operating activities:
Select		$- Select -
Adjustments to reconcile net income to net cash flow from operating activities:
Select	$- Select -
Select	- Select -
Select	- Select -
Select	- Select -
Select	- Select -
Select	- Select -	blank
Select		$- Select -
Select
Select	$- Select -
Select		- Select -
Select
Select	$- Select -
Select	- Select -
Select	- Select -
Select	- Select -
Select		- Select -
Select		$- Select -
Cash, Jan. 1		fill in the blank 33
Cash, Dec. 31		$fill in the blank 34