acc112_12835 monty kultz & 09/2/21 12:25 PM Save = Homework: Lesson 8 As... Question 5, EF168-31 (si... HW Score: 34.65%, 17.33 of 50 points Points: 0 of 10 The income statement and additional data of Minerals 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 of a box is not used in the spreadshot, loave the box empty, do not reloc a label or enter a zero. Do not check your answer until both Panel and Panel have been completed. Abbreviations uned Acquisition of Plant Assets by Inuing NP - Acquisition of Plant Assets by sung Note Payabio) Minerals Plus, Inc. Spreadsheet for Statement of Cash Flows Year Ended September 30, 2024 Balance Transaction Analysis Balance Panel A Balance Sheet: 9/30/2023 DEBIT CREDIT 9/30/2024 Cash 15.290 $ 35,000 Accounts Receivable 51.000 37.000 Merchandise Inventory 96.000 98.000 Plant Assets 75.000 195.000 $ Accumulated Depreciation-Part Assets Land (20,000) 79.000 5 296 290 (50,000) 54.000 $367,000 Total Assets do fur ca Accounts Payable 30.000 14.000 Help Me Solve This e Text Pages Get More Help Clear All Check Answer pos mer @ 12 The income statement and additional data of Minerals 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. Accounts Payable Accrued Liabilities Notes Payable Total Liabilities 14,000 25,000 14,000 30,000 15,000 15,000 53,000 60,000 9,000 234.290 Common Stock, no par Retained Earnings Total Liabilities and Stockholders' Equity 41,000 266,000 367,000 $ 296 290 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) (0) Clear All Chi Help Me Solve This e Text Pages Get More Help 12 The income statement and additional data of Minerals Plus, Inc. follow: (Click the icon to view the income statement) (Click the loon 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. to Net Cash Provided by Operating Activities: (b) (c) (d) (0) Net Cash Provided by Operating Activities Cash Flows from Investing Activities: (01) (h) Net Cash Used for Investing Activities Cash Flows from Financing Activities: 0 0 (k) Net Cash Used for Financing Activities e Non-cash Investing and Financing Activities: e Text Pages Help Me Solve This Get More Help Clear All C 2UTO 12 w Non-cash Investing and Financing Activities: (92) Total Non-cash Investing and Financing Activities (92) Total Minerals Plus, Inc. Income Statement Year Ended September 30, 2024 Net Sales Revenue $ 235,000 Cost of Goods Sold 96,000 Gross Profit 139,000 Operating Expenses: Salaries Expense $ 60,000 Depreciation Expense Plant Assets 30,000 90,000 Total Operating Expenses Net Income Before Income Taxes 49,000 10,290 Income Tax Expense Net Income $ 38,710 Search a. More Info 3 Acquisition of plant assets is $118,000. Of this amount, $103,000 is paid in cash and $15,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 $32,000. d. Payment of note payable is $14,000. e. Payment of dividends is $7,000. f. From the balance sheet: Cash Accounts Receivable Merchandise Inventory Land Plant Assets Accumulated Depreciation Accounts Payable September 30 2024 2023 $ 35,000 $ 15,290 37,000 51,000 98,000 96,000 54,000 79,000 193,000 75,000 (50,000) (20,000) 30,000 14,000 15,000 25,000 15,000 14,000 41,000 9,000 266,000 234.290 Accrued Liabilities Notes Payable (long-term) Common Stock, no par Retained Earnings Cance QUIVE 1113 LETOyus UUTIUIC FUIT o men 7 RA @ MacBook Air