TOP The income statement and additional data of Healthy Living Plus, Inc. follow Click the loon 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 Und the transaction relances in Panel when selecting the action references in Panel Alla box is not used in the spreadsheet love the box emply do not selecta label or entera 200. De ret check you answer unt both Panel and Panel have been completed. Abbreviations et Auf Part Ants by NP Aulon of Plant Anse by laung Note Patie) Healthy Living Plus, Inc. Spreadsheet for Statement of Cash Flows Year Ended September 30, 2018 Balance Transaction Analysis Balance Panel A Balance sheet 91302017 DET CREDIT 9/30/2018 Cash 20.000 5 33.00 Account Rabia 2.000 0.000 Merchandisinventary 95.000 99.000 PA 10.000 05.000 Acum Deo-Plants Land Total 1900) 23.000 $310.000 . 72.000 37.000 Healthy Living Plus, Inc. Income Statement Year Ended September 30, 2018 Net Sales Revenue $ 230,000 Cost of Goods Sold 92,000 138,000 Gross Profit Operating Expenses: Salaries Expense $ 53,000 30,000 Depreciation Expense-Plant Assets Total Operating Expenses 83,000 Net Income Before Income Taxes 55,000 Income Tax Expense 8,000 Net Income $ 47,000 c. a. Acquisition of plant assets is $125,000. Of this amount, $110,000 is paid in cash and $15,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 $14,000 e. Payment of dividends is $10,000. t. From the balance sheet: Cash September 30 2018 2017 33.000 $ 20,000 38,000 52,000 99,000 95,000 72,000 93,000 Accounts Receivable Merchandise Inventory Land Plant Assets 70,000 195,000 (40,000) (10,000) 31,000 40.000 14.000 19,000 Accumulated Depreciation Accounts Payablo Accrued Liabilities Notes Payable (long-term) Common Stock, no par Retained Earnings 15,000 14,000 41.000 6,000 250,000 287.000 a. Acquisition of plant assets is $125,000. Of this amount, $110,000 is paid in cash and $15,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 $35,000. d. Payment of note payable is $14,000. e. Payment of dividends is $10,000. f. From the balance sheet: September 30 2018 2017 $ 33,000 $ 20,000 38,000 52.000 99.000 95,000 72,000 93,000 195,000 70,000 Cash Accounts Receivable Merchandise Inventory Land Plant Assets Accumulated Depreciation Accounts Payablo Accrued Liabilities Notes Payable (long-term) Common Stock, no par Retained Earnings (10,000) (40,000) 40.000 31.000 14,000 19.000 15.000 14.000 41.000 6.000 250,000 287,000 Ques The income statement and additional data of Health ing Plus, Inc. follow (Click the icon to view the income statement) Oick the loon 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 Pune B when selecting the transaction references in Panel Alfa boris not used in the spreadsheet leave the box emply do not select a label or enter a zero. Done ante ut both Panel and Panel have been completed. Abbreviations and Acquisition of Plant Assets by sung NP = Acquisition of Plant Assets by sung Note Payable) Healthy Living Plus, Inc. Spreadsheet for Statement of Cash Flows Year Ended September 30, 2018 Balance Transaction Analysis Balance Panel A-Balance Sheet 30/2017 DEBIT CREDIT 9/2010 30,000 3.1.000 Acours Reci $2.000 33.000 Werder 95.000 000 Pants 70.000 105.000 1.000 0.000 390.000 0.0001 307.000