More info a. Acquisition of plant assets is $127,000. Of this amount, $109,000 is paid in cash and $18,000 by signing a note payable. b. Cash receipt from sale of land totals $22,000. There was no gain or loss. c. Cash receipts from issuance of common stock total $33,000. d. Payment of note payable is $17,000. e. f. Payment of dividends is $6,000. From the balance sheet: September 30 2024 2023 Cash Accounts Receivable Merchandise Inventory Land Plant Assets $ 35,000 $ 24,020 37,000 54,000 98,000 96,000 84,000 106,000 167,000 40,000 Accumulated Depreciation (49,000) (25,000) Accounts Payable 37,000 25,000 Accrued Liabilities 18,000 30,000 Notes Payable (long-term) 18,000 17,000 Common Stock, no par 45,000 12,000 Retained Earnings 254,000 211,020 Print Done Cash Panel A-Balance Sheet: Accounts Receivable Merchandise Inventory Plant Assets Accumulated Depreciation-Plant Assets Land Total Assets Accounts Payable Accrued Liabilities Notes Payable Total Liabilities Common Stock, no par Retained Earnings Total Liabilities and Stockholders' Equity Energy Plus, Inc. Spreadsheet for statement of Cash Flow Year Ended September 30, 2024 Panel B-Statement of Cash Flows: Cash Flows from Operating Activities: Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities: Not Cash Provided by Operating Activities Cash Flows from Investing Activities: Balance Transaction Analysis Balance 9/30/2023 DEBIT CREDIT 8/30/2024 24,020 $ 35,000 54,000 37,000 96,000 98,000 40,000 (25,000) 167,000 (40,000) 106,000 84,000 $ 295,020 $72,000 25,000 37,000 30,000 18,000 17,000 18,000 72,000 73,000 12,000 45,000 211,020 254,000 $ 295,020 (a) (d) (1) (91) (h) Not Cash Used for Investing Activities Cash Flows from Financing Activities: Net Cash Used for Financing Activities Non-cash Investing and Financing Activities: (0) (K) (1) (92) Total Non-cash Investing and Financing Activities Total (92) 372,000 The income statement and additional data of Energy Plus, Inc. follow: (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.) Data table Energy Plus, Inc. Income Statement Year Ended September 30, 2024 Net Sales Revenue $ 234,000 97,000 Cost of Goods Sold Gross Profit 137,000 Operating Expenses: Salaries Expense $ 51,000 Depreciation Expense-Plant Assets 24,000 75,000 Total Operating Expenses Net Income Before Income Taxes 62,000 13,020 Income Tax Expense Net Income $ 48,980 Print Done