Spreadsheet and Statement The following 2019 information is available for Stewart Company: 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. Making whatever additional assumptions that are necessary, 1. Prepare a spreadsheet to support a 2019 statement of cash flows for Stewart. If an amount is zero, enter "0*. Credits Accumulated depreciation Accounts payable Bonds pay. (due 1/1/2021) Common stock, $10 par Retained earnings Totals Cash Flow From Operating Activities Net income Add: Decrease in accounts receivable Add: Loss on sale of equipment Add: Depreciation expense Add: Increase in accounts payable Less: Increase in inventory Less: Gain on sale of land Cash Flows From Investing Activities Proceeds from sale of land Payment for purchase of land Proceeds from sale of equipment Cash Flow From Operating Activities Net income Add: Decrease in accounts receivable Add: Loss on sale of equipment Add: Depreciation expense Add: Increase in accounts payable Less: Increase in inventory Less: Gain on sale of land Cash Flows From Investing Activities Proceeds from sale of land Payment for purchase of land Proceeds from sale of equipment Payment for purchase of equipment Cash Flows From Financing Activities Proceeds from issuance of common stock Payment of dividends Net increase in cash Totais 2. Prepare the statement of cash flows. Use the minus sign to indicate cash outflows, a decrease in cash or cash payments. 2. Prepare the statement of cash flows. Use the minus sign to indicate cash outflows, a decrease in cash or cash payments. Investing Activities: Financing Activities: Cash, January 1, 2019 Cash, December 31, 2019 Check My Work