The income statement and additional data of minerals plus, inc. follow:

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

Minerals Plus, Inc.
Spreadsheet for Statement of Cash Flows
Year Ended September 30, 2018
		Balance	Transaction Analysis				Balance
	Panel ABalance Sheet:	9/30/2017		DEBIT	CREDIT		9/30/2018
	Cash	$1,000					$31,000
	Accounts Receivable	59,000					50,000
	Merchandise Inventory	95,000					98,000
	Plant Assets	65,000					176,000
	Accumulated DepreciationPlant Assets	(25,000)					(47,000)
	Land	105,000					84,000
	Total Assets	$300,000					$392,000
	Accounts Payable	15,000					31,000
	Accrued Liabilities	23,000					10,000
	Notes Payable	9,000					10,000
	Total Liabilities	47,000					51,000
	Common Stock, no par	7,000					38,000
	Retained Earnings	246,000					303,000
	Total Liabilities and Stockholders' Equity	$300,000					$392,000

	Panel BStatement of Cash Flows:
	Cash Flows from Operating Activities:
			(a)
	Adjustments to Reconcile Net Income
	to Net Cash Provided by Operating Activities:
			(b)
			(c)
						(d)
			(e)
						(f)
	Net Cash Provided by Operating Activities
	Cash Flows from Investing Activities:
						(g1)
			(h)
	Net Cash Used for Investing Activities
	Cash Flows from Financing Activities:
						(j)
			(i)
						(k)
	Net Cash Used for Financing Activities
						(l)

	Non-cash Investing and Financing Activities:
						(g2)
	Total Non-cash Investing and Financing Activities		(g2)
	Total

Minerals Plus, Inc. Income Statement Year Ended September 30, 2018 Net Sales Revenue $ 234,000 Cost of Goods Sold 89,000 Gross Profit 145,000 Operating Expenses: Salaries Expense $ 53,000 22,000 Depreciation ExpensePlant Assets Total Operating Expenses 75,000 Net Income Before Income Taxes 70,000 Income Tax Expense 4,000 $ 66,000 Net Income a. Acquisition of plant assets is $111,000. Of this amount, $101,000 is paid in cash and $10,000 by signing a note payable. b. Cash receipt from sale of land totals $21,000. There was no gain or loss. c. Cash receipts from issuance of common stock total $31,000. d. Payment of note payable is $9,000 e. Payment of dividends is $9,000. f. From the balance sheet: Cash Accounts Receivable Merchandise Inventory Land Plant Assets Accumulated Depreciation Accounts Payable Accrued Liabilities Notes Payable (long-term) Common Stock, no par Retained Earnings September 30 2018 2017 $ 31,000 $ 1,000 50,000 59,000 98,000 95,000 84,000 105,000 176,000 65,000 (47,000) (25,000) 31,000 15,000 10,000 23,000 10,000 9,000 38,000 7,000 303,000 246,000