The income statement and additional data of Healthy Living 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.) Healthy Living Plus, Inc. Spreadsheet for Statement of Cash Flows Year Ended September 30, 2018 Cash Accounts Receivable Merchandise Inventory Plant Assets Balance Transaction Analysis Panel A-Balance Sheet: 9/30/2017 DEBIT CREDIT Balance 9/30/2018 $ 12,000 $ 33,000 57,000 43,000 95,000 98,000 70,000 191,000 Accumulated Depreciation-Plant Assets (24,000) (52,000) 85,000 Land 62,000 Hele me nafs this data of Healthy Living 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. Land Total Assets Accounts Payable Accrued Liabilities Notes Payable Total Liabilities Common Stock, no par Retained Earnings Total Liabilities and Stockholders' Equity Panel B-Statement of Cash Flows: Cash Flows from Operating Activities: 85,000 $ 295,000 22.000 27,000 14,000 63,000 62,000 $ 375,000 40,000 14,000 15,000 69,000 10,000 222,000 44,000 262,000 $ 295,000 $ 375,000 The income statement and additional data of Healthy Living Plus, Inc. follow. (Click the icon to view the income statement.) ( 0 (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. 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) Net Cash Provided by Operating Activities Cash Flows from Investing Activities: Net Cash Used for Investing Activities Cock Ele from Einancing Activitie (h) (91) The income statement and additional data of Healthy Living 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: Net Cash Used for Investing Activities Cash Flows from Financing Activities: Net Cash Used for Financing Activities Non-cash Investing and Financing Activities: Total Non-cash Investing and Financing Activities Total (92) 69 (h) (92) (91) Data table Healthy Living Plus, Inc. Income Statement Year Ended September 30, 2018 Net Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses: Salaries Expense Depreciation Expense-Plant Assets Total Operating Expenses Net Income Before Income Taxes Income Tax Expense Net Income $ 233,000 90,000 143,000 $ 52,000 28,000 80,000 63,000 11,000 $ 52,000 Print Done - More info a. b. C. Acquisition of plant assets is $121,000. Of this amount, $106,000 is paid in cash and $15,000 by signing a note payable. Cash receipt from sale of land totals $23,000. There was no gain or loss. Cash receipts from issuance of common stock total $34,000. d. Payment of note payable is $14,000. e. 49 Payment of dividends is $12,000. f. From the balance sheet: Cash Accounts Receivable Merchandise Inventory Land Plant Assets September 30 2018 2017 $ 33,000 $ 12,000 43,000 57,000 98,000 95,000 62,000 85,000 191,000 70,000 Accumulated Depreciation (52,000) (24,000) Accounts Payable 40,000 22,000 Accrued Liabilities 14,000 27,000 - More info C. Cash receipts from issuance or common stock total $34,000. d. Payment of note payable is $14,000. e. f. Payment of dividends is $12,000. From the balance sheet: September 30 2018 2017 $ 33,000 $ 12,000 Cash Accounts Receivable 43,000 57,000 Merchandise Inventory 98,000 95,000 Land 62,000 85,000 Plant Assets 191,000 70,000 Accumulated Depreciation (52,000) (24,000) Accounts Payable 40,000 22,000 Accrued Liabilities 14,000 27,000 Notes Payable (long-term) 15,000 14,000 Common Stock, no par 44,000 10,000 Retained Earnings 262,000 222,000 Print Done