Please help with this question. also put down drop box to show my options, thank you in advance

The income statement and additional data of Vitamins Plus, Inc. follow (Click the icon to view the income statement.) i (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) Vitamins 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 22.000 38,000 Accounts Receivable 52,000 39,000 Merchandise Inventory 94,000 99.000 Plant Assets 75,000 186,000 Accumulated Depreciation Plant Assets (25,000) 87,000 (55,000) 62,000 Land Choose from any list or enter any number in the input fields and then continue to the next question Save for Later The income statement and additional data of Vitamins Plus, Inc. follow: in (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. (25,000) Accumulated Depreciation-Plant Assets (55,000) L 62,000 Land $ 305,000 379,000 Total Assets 87.000 Accounts Payable Accrued Liabilities 24,000 NNE 20,000 DO 13,000 N L 37,000 13,000 14,000 14,000 - Notes Payable 64,000 57,000 or. Total Liabilities 1 Common Stock, no par 5,000 243,000 305,000 34,000 281,000 379,000 Retained Earnings Total Liabilities and Stockholders' Equity Panel B Statement of Cash Flows: Cash Flows from Operating Activities: Choose from any list or enter any number in the input fields and then continue to the next question Save for Later The income statement and additional data of Vitamins 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. Retained Earnings 305,000 379,000 Total Liabilities and Stockholders' Equity Panel B-Statement of Cash Flows: Cash Flows from Operating Activities: Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities: Net Cash Provided by Operating Activities Cash Flows from Investing Activities: (91) Choose from any list or enter any number in the input fields and then continue to the next question. Save for Later The income statement and additional data of Vitamins 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. Net Cash Provided by Operating Activities Cash Flows from Investing Activities: (91) Net Cash Used for Investing Activities Cash Flows from Financing Activities: Net Cash Used for Financing Activities Non-cash Investing and Financing Activities: (92) Total Non-cash Investing and Financing Activities Choose from any list or enter any number in the input fields and then continue to the next question. Save for Later The income statement and additional data of Vitamins 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. Cash Flows from Investing Activities: (91) Net Cash Used for Investing Activities Cash Flows from Financing Activities: Net Cash Used for Financing Activities Non-cash Investing and Financing Activities: (92) Total Non-cash Investing and Financing Activities Total Choose from any list or enter any number in the input fields and then continue to the next question. Save for Later 0 More Info a. pet, Equi: Acquisition of plant assets is $121,000. Of this amount, $107,000 is paid in cash and $14,000 by signing a note payable. b. Cash receipt from sale of land totals $25,000. There was no gain or loss. c. Cash receipts from issuance of common stock total $29,000. d. Payment of note payable is $13,000. e. Payment of dividends is $11,000. f. From the balance sheet: Salar Cash Accounts Receivable Merchandise Inventory Land Plant Assets Accumulated Depreciation Accounts Payable Accrued Liabilities September 30 2018 2017 $ 38,000 $ 22,000 39,000 52,000 99,000 94,000 62,000 87,000 196,000 75,000 (55,000) (25,000) 37,000 24,000 13,000 20,000 Plant er any Print Done More Info Payment of note payable is $13,000. Payment of dividends is $11,000. 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 $ 38,000 $ 22,000 39,000 52,000 99,000 94,000 62,000 87,000 196,000 75,000 (55,000) (25,000) 37,000 24,000 13,000 20,000 14,000 13,000 34,000 5,000 281,000 243,000 Print Done Vitamins Plus, Inc. readsheet for Statement of Cash Flows Year Ended September 30, 2018 Transaction Analysis CREDIT Balance 9/30/2017 22,000 O 52,000 94,000 75,000 DEBIT C (25,000) 87,000 305,000 $ 24.000 (1) ber in the input fields and then cont e next question. The income statement and additional data of Vitamins Plus, Inc. follov (Click the icon to view the income statement.) i (Click the icon Prepare the spreadsheet for the 2018 statement of cash flows. Format womTom WC, no par Retained Earnings Total Liabilities and Stockholders' Equity Panel B-Statement of Cash Flows: Cash Flows from Operating Activities: Net Income Net Loss Net Cash Provided by Operating Activities Cash Flows from Investing Activities: Choose from any list or enter any number in the input fields and then col The income statement and additional data of Vitamins Plus, Inc E: (Click the icon to view the income statement.) (Click th Prepare the spreadsheet for the 2018 statement of cash flows. Cash Flows from Operating Activities: Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities: Depreciation ExpensePlant Assets Loss on Sale of Assets Net Cash Provided by Operating Activities Cash Flows from Investing Activities: Net Cash Used for Investing Activities Cash Flows from Financing Activities: The income statement and additional data of Vitamins Plus, Inc. follow: E: (Click the icon to view the income statement.) (Click the icon to view the additional Prepare the spreadsheet for the 2018 statement of cash flows. Format cash flows from ope Cash Flows from Operating Activities: (a) Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities: Decrease in Accounts Payable Increase in Accounts Payable Net Cash Used for Investing Activities Cash Flows from Financing Activities: Choose from any list or enter any number in the input fields and then continue to th repare the spreadsheet for the 2018 statement of cash flows. Cash Flows from Operating Activities: Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities: Decrease in Accrued Liabilities Increase in Accrued Liabilities Net Cash Used for Investing Activities Cash Flows from Financing Activities