The income statement and additional data of Minerals Plus, Inc. follow. (Click the icon to view the income statement.) (Click the icon to view the additional data.) Prepare the spreadsheet for the 2018 statement of cash flows. Format cash flows from operating activities by the indirect method. Use the transaction references in Panel B when selecting the transaction references in Panel A. (If a box is not used in the spreadsheet, leave the box empty, do not select a label or enter a zero. Do not check your answer until both Panel A and Panel Data Table Minerals Plus, Inc. Spreadsheet for Statement of Cash Flows Year Ended September 30, 2018 Balance Transaction Analysis Panel ABalance Sheet: 9/30/2017 DEBIT CREDIT Cash $ 26,000 Accounts Receivable 54,000 Merchandise Inventory 94,000 Plant Assets 80,000 Balance 9/30/2018 $ 38,000 44,000 96,000 197,000 Minerals Plus, Inc. Income Statement Year Ended September 30, 2018 Net Sales Revenue $ 236,000 99,000 Cost of Goods Sold Accumulated Depreciation Plant Assets Land Total Assets (22,000) 79.000 137,000 (46,000) 58,000 387,000 311,000 $ $ 58,000 24,000 Accounts Payable Accrued Liabilities Notes Payable Total Liabilities 18,000 23,000 10.000 Gross Profit Operating Expenses Salaries Expense Depreciation Expense-Plant Assets Total Operating Expenses Net Income Before Income Taxes Income Tax Expense 33,000 19,000 11,000 82,000 51.000 63,000 55,000 7,000 $ Net Income 48,000 Common Stock, no par Retained Earnings Total Liabilities and Stockholders' Equity 6,000 254,000 34,000 290,000 Print Done $ 311,000 387,000 Panel B-Statement of Cash Flows: Cash Flows from Operating Activities: (a) More Info Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities: (b) (d) a. Acquisition of plant assets is $117.000. Of this amount, $106,000 is paid in cash and $11,000 by signing a note payable. b. Cash receipt from sale of land totals $21,000. There was no gain or loss. Cash receipts from issuance of common stock total $28,000. d. Payment of note payable is $10,000. e. Payment of dividends is $12,000. 1. f. From the balance sheet: (e) () Net Cash Provided by Operating Activities Cash Flows from Investing Activities: September 30 2018 2017 (91) (h) Cash 26.000 54.000 Net Cash Used for Investing Activities Cash Flows from Financing Activities: (1) (1) Accounts Receivable Merchandise Inventory Land Plant Assets Accumulated Depreciation Accounts Payable Accrued Liabilities Notes Payable (long-term) Common Stock, no par Retained Earnings (k) $ 38,000 $ 44,000 96,000 58,000 197.000 (46,000) 33,000 19,000 11,000 34.000 290.000 94,000 79.000 80,000 (22,000) 18.000 Net Cash Used for Financing Activities 23.000 10,000 6.000 254.000 Non-cash Investing and Financing Activities: (92) (92) Total Non-cash Investing and Financing Activities Total Print Done