Spreadsheet and Statement

The following 2019 information is available for Stewart Company:

Condensed Income Statement for 2019
Sales		$9,000
Cost of goods sold		(6,000)
Other expenses		(2,000)
Loss on sale of equipment		(260)
Gain on sale of land		400
Net income		$1,140

		Comparative Balance Sheets
		December 31, 2018		December 31, 2019
Cash		$700		$1,130
Accounts receivable		450		310
Inventory		350		400
Land		300		500
Equipment		1,600		1,800
Less: Accumulated depreciation		(200)		(150)
Total Assets		$3,200		$3,990
Accounts payable		$600		$750
Bonds payable (due 1/1/2018)		1,000		1,000
Common stock, $10 par		900		1,400
Retained earnings		700		840
Total Liabilities and Shareholders' Equity		$3,200		$3,990

Partial additional information:

The equipment that was sold for cash had cost $400 and had a book value of $300.

Land that was sold brought a cash price of $530.

Fifty shares of stock were issued at par.

Required:

Making whatever additional assumptions that are necessary,

Question Content Area

1. Prepare a spreadsheet to support a 2019 statement of cash flows for Stewart. If an amount is zero, enter "0".

STEWART COMPANY Cash Flows Worksheet For Year Ended December 31, 2019

	Balances 12/31/2018	Balances 12/31/2019	Balances Change	Worksheet Entries Debit	Worksheet Entries Credit
Debits
Cash	fill in the blank e025baf47fbb008_1	fill in the blank e025baf47fbb008_2	fill in the blank e025baf47fbb008_3	fill in the blank e025baf47fbb008_4
Noncash Accounts:
Accounts receivable	fill in the blank e025baf47fbb008_5	fill in the blank e025baf47fbb008_6	fill in the blank e025baf47fbb008_7		fill in the blank e025baf47fbb008_8
Inventory	fill in the blank e025baf47fbb008_9	fill in the blank e025baf47fbb008_10	fill in the blank e025baf47fbb008_11	fill in the blank e025baf47fbb008_12
Land	fill in the blank e025baf47fbb008_13	fill in the blank e025baf47fbb008_14	fill in the blank e025baf47fbb008_15	fill in the blank e025baf47fbb008_16	fill in the blank e025baf47fbb008_17
Equipment	fill in the blank e025baf47fbb008_18	fill in the blank e025baf47fbb008_19	fill in the blank e025baf47fbb008_20	fill in the blank e025baf47fbb008_21	fill in the blank e025baf47fbb008_22
Totals	fill in the blank e025baf47fbb008_23	fill in the blank e025baf47fbb008_24	fill in the blank e025baf47fbb008_25
Credits
Accumulated depreciation	fill in the blank e025baf47fbb008_26	fill in the blank e025baf47fbb008_27	fill in the blank e025baf47fbb008_28	fill in the blank e025baf47fbb008_29	fill in the blank e025baf47fbb008_30
Accounts payable	fill in the blank e025baf47fbb008_31	fill in the blank e025baf47fbb008_32	fill in the blank e025baf47fbb008_33		fill in the blank e025baf47fbb008_34
Bonds pay. (due 1/1/2021)	fill in the blank e025baf47fbb008_35	fill in the blank e025baf47fbb008_36	fill in the blank e025baf47fbb008_37
Common stock, $10 par	fill in the blank e025baf47fbb008_38	fill in the blank e025baf47fbb008_39	fill in the blank e025baf47fbb008_40		fill in the blank e025baf47fbb008_41
Retained earnings	fill in the blank e025baf47fbb008_42	fill in the blank e025baf47fbb008_43	fill in the blank e025baf47fbb008_44	fill in the blank e025baf47fbb008_45	fill in the blank e025baf47fbb008_46
Totals	fill in the blank e025baf47fbb008_47	fill in the blank e025baf47fbb008_48	fill in the blank e025baf47fbb008_49	fill in the blank e025baf47fbb008_50	fill in the blank e025baf47fbb008_51
Cash Flow From Operating Activities
Net income				fill in the blank
Add: Decrease in accounts receivable				fill in the blank
Add: Loss on sale of equipment				fill in the blank
Add: Depreciation expense				fill in the blank
Add: Increase in accounts payable				fill in the blank
Less: Increase in inventory					fill in the blank
Less: Gain on sale of land					fill in the blank
Cash Flows From Investing Activities
Proceeds from sale of land				fill in the blank
Payment for purchase of land					fill in the blank
Proceeds from sale of equipment				fill in the blank
Payment for purchase of equipment					fill in the blank
Cash Flows From Financing Activities
Proceeds from issuance of common stock				fill in the blank
Payment of dividends					fill in the blank
Net increase in cash					fill in the blank
Totals				$fill in the blank	fill in the blank