Data table Supplements Plus, Inc. Income Statement Year Ended September 30, 2018 Net Sales Revenue 235,000 97,000 Cost of Goods Sold Gross Profit 138,000 Operating Expenses: Salaries Expense 58,000 22,000 Depreciation ExpensePlant Assets 80,000 Total Operating Expenses Net Income Before Income Taxes 58,000 Income Tax Expense 7,000 $ 51,000 Net Income Print Done More info - a. Acquisition of plant assets is $113,000. Of this amount, $102,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 $35,000. d. Payment of note payable is $10,000. Payment of dividends is $13,000. f. From the balance sheet: C. e. September 30 2018 2017 Cash $ 38,000 $ 23,000 Accounts Receivable 41,000 51,000 Merchandise Inventory 97,000 93,000 Land 75,000 96,000 Plant Assets 60,000 Accumulated Depreciation 173,000 (37,000) 31,000 (15,000) 21,000 Accounts Payable Accrued Liabilities 11,000 16,000 Notes Payable (long-term) 11,000 10,000 Common Stock, no par 45,000 10,000 Retained Earnings 289,000 251,000 Print Done The income statement and additional data of Supplements 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 B have been completed. Abbreviations used: Acquistion of Plant Assets by Issuing NP = Acquisition of Plant Assets by Issuing Note Payable.) Supplements Plus, Inc. Spreadsheet for Statement of Cash Flows Year Ended September 30, 2018 Balance Transaction Analysis Balance Panel A-Balance Sheet: 9/30/2017 DEBIT CREDIT 9/30/2018 Cash $ 23,000 $ 38.000 Accounts Receivable 41,000 Merchandise Inventory Plant Assets 51,000 93,000 60,000 97,000 173,000 Accumulated Depreciation-Plant Assets - Land (15,000) 96,000 (37,000) () 75,000 $ 308,000 $ 387,000 Total Assets 21,000 31.000 Accounts Payable Accrued Liabilities 16,000 10,000 11,000 11,000 Notes Payable The income statement and additional data of Supplements 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. 10,000 11,000 Notes Payable Total Liabilities 47,000 53,000 Common Stock, no par 10,000 251,000 45.000 289,000 Retained Earnings S 308.000 387,000 Total Liabilities and Stockholders' Equity Panel B-Statement 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: The income statement and additional data of Supplements 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. (d) () Net Cash Provided by Operating Activities Cash Flows from Investing Activities: (91) (h) Net Cash Used for Investing Activities Cash Flows from Financing Activities: 0) (0) (k) Net Cash Used for Financing Activities (0) Non-cash Investing and Financing Activities: (92) (92) Total Non-cash Investing and Financing Activities Total