How can I do a spreadsheet to make a comparative balance sheet of Cromme for December 31, 2016. The problem is 26e PR 16-1A. Please help me. Below is the part of the problem I have to fill it it is a spreadsheet.

CROMME INC.

Statement of Cash Flows

For the Year Ended December 31, 2016

Cash flows from operating activities:

Net income

Adjustments to reconcile net income to net cash

flow from operating activities:

Depreciation

Loss on inventory write down and fixed assets

Changes in current operating assets and liabilities:

Net cash flow from operating activities

Cash flows from investing activities:

Net cash flow used for investing activities

Cash flows from financing activities:

Net cash flow from financing activities

Increase in cash

Cash at the beginning of the year

Cash at the end of the year

Spreadsheet (Work Sheet) for Statement of Cash Flows

For the Year Ended December 31, 2016

Balance,

Transactions

Balance,

Dec. 31, 2015

Debit

Credit

Dec. 31, 2016

Cash

179,800

146,600

Accounts receivable (net)

242,000

224,600

Merchandise inventory

299,200

321,600

Prepaid expenses

9,600

13,400

Equipment

537,000

655,000

Accum. depr. - equipment

(132,200)

(170,800)

Accounts payable

(237,600)

(250,200)

Mortgage note payable

(336,000)

-

Common stock, $25 par

(24,000)

(74,000)

Paid-in capital in excess of par

(320,000)

(470,000)

Retained earnings

(217,800)

(396,200)

Totals

-

-

Operating activities:

Net income

a

Depreciation

Decrease in accounts receivable

Increase in merchandise inventory

Increase in prepaid expenses

Increase in accounts payable

Investing activities:

Purchase of equipment

Financing activities:

Payment of cash dividends

Sale of common stock

Payment of mortgage note payable

Net decrease in cash

Totals

Spreadsheet (Work Sheet) for Statement of Cash Flows
For the Year Ended December 31, 2016
						Balance,		Transactions						Balance,
						Dec. 31, 2015			Debit			Credit		Dec. 31, 2016
	Cash					179,800								146,600
	Accounts receivable (net)					242,000								224,600
	Merchandise inventory					299,200								321,600
	Prepaid expenses					9,600								13,400
	Equipment					537,000								655,000
	Accum. depr. - equipment					(132,200)								(170,800)
	Accounts payable					(237,600)								(250,200)
	Mortgage note payable					(336,000)								-
	Common stock, $25 par					(24,000)								(74,000)
	Paid-in capital in excess of par					(320,000)								(470,000)
	Retained earnings					(217,800)								(396,200)
	Totals					-								-
	Operating activities:
		Net income
		Depreciation
		Decrease in accounts receivable
		Increase in merchandise inventory
		Increase in prepaid expenses
		Increase in accounts payable
	Investing activities:
		Purchase of equipment
	Financing activities:
		Payment of cash dividends
		Sale of common stock
		Payment of mortgage note payable
	Net decrease in cash
	Totals