. - Data Table 238,000 91,000 147,000 Healthy Living Plus, Inc. Income Statement Year Ended September 30, 2024 Net Sales Revenue $ Cost of Goods Sold Gross Profit Operating Expenses Salaries Expense $ 58,000 Depreciation ExpensePlant Assets 24,000 Total Operating Expenses Net Income Before Income Taxes Income Tax Expense $ Net Income 82,000 65,000 13,650 51,350 Print Done a. c. Acquisition of plant assets is $124,000. Of this amount, $107,000 is paid in cash and $17,000 by signing a note payable. b. Cash receipt from sale of land totals $23,000. There was no gain or loss. Cash receipts from issuance of common stock total $35,000 d. Payment of note payable is $16,000. Payment of dividends is $10,000 f. From the balance sheet: e. Cash Accounts Receivable Merchandise Inventory Land Plant Assets Accumulated Depreciation Accounts Pavable September 30 2024 2023 $ 30,000 $ 8,650 37,000 53,000 90,000 86,000 84,000 107,000 154,000 30,000 (49,000) (25,000) 33.000 15.000 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 2024 2023 $ 30,000 $ 8,650 37,000 53,000 90,000 86,000 84,000 107,000 154,000 30,000 (49,000) (25,000) 33,000 15,000 20,000 29,000 17,000 16,000 46,000 11,000 230,000 188,650 The income statement and additional data of Healthy Living Plus, Inc. follow: E: (Click the icon to view the income statement.) (Click the icon to view the additional data.) Prepare the spreadsheet for the 2024 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, 2024 Balance Transaction Analysis Panel A-Balance Sheet: 9/30/2023 DEBIT CREDIT Balance 9/30/2024 Cash $ $ Accounts Receivable 8,650 53,000 86,000 30,000 37,000 90,000 154,000 Merchandise Inventory Plant Assets 30,000 Accumulated DepreciationPlant Assets (25,000) (49,000) Land 107.000 84,000 $ 259,650 $ 346,000 Total Assets 15,000 Accounts Payable Accrued Liabilities 29,000 16,000 33,000 20,000 17,000 Notes Payable Total Liabilities 60,000 70,000 Common Stock, no par 11,000 188,650 46,000 230,000 Retained Earnings 259,650 $ 346,000 Total Liabilities and Stockholders' Equity Panel B-Statement of Cash Flows: 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) (1) Net Cash Provided by Operating Activities Cash Flows from Investing Activities: (91) 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) (1) Net Cash Provided by Operating Activities Cash Flows from Investing Activities: (91) 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) Total Non-cash Investing and Financing Activities (92) Total
