The 2024 comparative balance sheet and income statement of Attleborn Group, Inc. follow. Attleboro disposed of a plant asset at book value during 2024 (Click the icon to view the comparative balance sheet) (Click the icon to view the income statement) Prepare the spreadsheet for the 2024 statement of cash flows. Format cash flows from operating activities by the indirect method A plant asset was disposed of for $0 The cost and accumulated depreciation of the disposed asset was $14,100 There were no sales of land, no retirement of common stock, and no treasury stock transactions Assume plant asset and land acquisitions were forcash Use the transaction references in Panel B when selecting the transaction references in Panel A of a box is not used in the spreadsheet, leave the box empty, do not select a label or atera z Do not check your and both Panel A and Panel B have been completed) Attleboro Group, Inc. Spreadsheet for Statement of Cash Flows Year Ended December 31, 2024 Balance Cash Panel A-Balance Sheet Accounts Receivable Marchandise inventory 12/31/2023 DEBIT Transaction Analysis CREDIT Balance 12012024 15.400 12.700 43.700 42.700 97.200 93.400 Time Remaining 1303 Next Cashi Accounts Receivable $ 15,400 $ 12,700 43,700 42,700 Merchandise Inventory 93,400 97,200 Land 18,000 43.600 Plant Assets 111,760 119,660 Accumulated Depreciation-Plant Assets (17.560) (19.260) Total Assets $ 264,700 $ 296,600 Accounts Payable Accrued Liabilities Notes Payable 26.200 22.400 60,000 24.500 23,900 48,000 Accrued Liabilities 22,400 23,900 Notes Payable 60,000 48,000 Total Liabilities 108,600 96,400 Common Stock Retained Earnings Total Liabilities and Stockholders' Equity Panel B-Statement of Cash Flows: Cash Flows from Operating Activities: 136,900 19,200 $ 264,700 145,600 54.600 $ 296,600 Panel B-Statement of Cash Flows: Cash Flows from Operating Activities: Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities (a) (b) (c) (d) (e) (f) Net Cash Provided by Operating Activities Cash Flows from Investing Activities: Net Cash Used for Investing Activities Cash Flows from Financing Activities: Net Cash Used for Financing Activities (h) (0) (k) (0) (m) Net Cash Used for Financing Activities (k) (i) Non-cash Investing and Financing Activities: Total Non-cash Investing and Financing Activities Total (m) (g) (g) Attleboro Group, Inc. Comparative Balance Sheet December 31, 2024 and 2023 Assets 2024 2023 Current Assets: Cash Accounts Receivable Merchandise Inventory $ 12.700 S 15,400 42.700 43,700 97.200 93.400 Long-term Assets: Land 43,600 18,000 Plant Assets 119.660 111,760 (19.260) (17.560) Accumulated Depreciation-Plant Assets The cost and accumulated depreciation nt of ws f com Total Assets Current Liabilities: Accounts Payable Accrued Liabilities Long-term Liabilities. $ 296,600 $ 264,700 4 Liabilities $ 24,500 $ 26,200 23,900 22,400 48,000 60,000 Notes Payable Total Liabilities 96,400 108,600 Stockholders' Equity Common Stock, no par 145,600 136,900 Retained Earnings 54,600 19,200 200,200 156.100 Total Stockholders' Equity 206 600 S 264700 The cost and accumulated depreciati Current Liabilities: Accounts Payable Accrued Liabilities Long-term Liabilities: Liabilities The cost and accumulated dep 24,500 $ 26,200 23,900 22.400 Notes Payable 48,000 60,000 Total Liabilities 96.400 108,600 Stockholders' Equity Common Stock, no par 145,600 136,900 54.600 19,200 Retained Earnings 200,200 156,100 Total Stockholders' Equity S 296.600 $ 264.700 Total Liabilities and Stockholders' Equity eet) sh flows For ent of commo Attleboro Group, Inc. Income Statement Year Ended December 31, 2024 Net Sales Revenue $ 441,000 Cost of Goods Sold Gross Profit 205,100 235,900 Operating Expenses Salaries Expense S 76,600 Depreciation Expense Plant Assets 15,800 49.400 Other Operating Expenses 141,800 Total Operating Expenses Operating Income Other Incoma.and (Finanses 94,100 or $0. The cost and accumulated depr cash. Attle Salaries Expense $ 76,600 Form mor Total Operating Expenses Depreciation Expense-Plant Assets 15,800 Other Operating Expenses 49.400 Operating Income Other Income and (Expenses) Interest Revenue Interest Expense Total Other Income and (Expenses) Net Income Before Income Taxes Income Tax Expense Net Income 141,800 94,100 11,100 (24 700) (13.600) 80,500 16.700 63,800 or $0. The cost and accumulated depreciation of cash