The 2024 comparative balance sheet and income statement of Albuquerque Group, Ine follow Albuquerque 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 50. The cost and accumulated depreciation of the disposed asset was 512 300. There were no sales of land, no retirement of common stock, and no treasury stock transactions Assume plant asset and land acquisitions were for cash Use the transaction references in Panel B when selecting the transaction references in Panel A (la 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) Albuquerque Group, Inc. Spreadsheet for Statement of Cash Flows Year Ended December 31, 2024 Balance Transaction Analysis Balance Panel ABalance Sheet 12/31/2023 DEBIT CREDIT 12/31/2024 Cash $ 15.100 7.800 Accounts Receivable 43.800 42300 Merchandise Inventory 93 100 96600 Land 13 000 38 700 Plant Assets 110.520 120 220 Accumulated Depreciation-Plant Assets (16.520) (19.220) 259,000 $ Total Assets 286.400 $ S 26.400 Accounts Payable Accued Liabilities 22.500 61.000 24.700 23.900 43,000 91,600 Notes Payable Total Liabilities 109 900 129600 19 500 Common Stock Retained Eamings Total Liabilities and Stockholders Equity 138.500 56,300 286,400 5 259.000 5 Panel Statement of Cash Flows: Cash Flows from Operating Activities a) Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities (b) (d (e) 10 Net Cash Provided by Operating Activities The 2024 comparative balance sheet and income statement of Albuquerque Group, Inc. folow Albuquerque disposed of a plant asset at book value during 2024 Click the icon to view the comparative balance sheet) m Click the icon to view the income statement Prepare the spreadsheet for the 2024 statement of cash flows. Format cash fows from operating activities by the indirect method A plant asset was disposed of for 50. The cost and accumulated depreciation of the disposed asset was 512300 There were no sales of land, na retirement of common stock and no treasury stock transactions. Assume plant asset and land acquisitions were for cash Accounts Payable Accrued Liabilities Notes Payable Total Liabilities 26400 22.500 63.000 24.700 23 900 43.000 91.600 109,900 Common Stock 129 500 19.500 259,000 136 500 56 300 Retained Earnings Total Liabilities and Stockholders' Equity 5 $ 285.400 Panel B Statement of Cash Flows: Cash Flows from Operating Activities 0 Adjustments to Reconcile Not Income to Net Cash Provided by Operating Activities O (d () 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 Non cash investing and Financing Activities Total Non-cash Investing and Financing Activities Total EX Data table Albuquerque Group, Inc. Comparative Balance Sheet December 31, 2024 and 2023 2024 2023 Assets Current Assets Cash $ 7.800 S 15.100 43,800 42 300 96,600 93,100 el 38.700 A 120.220 (19.220) 13,000 110.520 (16,520) NI 286,400 5 259,000 Dd Accounts Receivable Merchandise Inventory Long-term Assets Land Plant Assets Accumulated Depreciation--Plant Assets $ Total Assets Liabilities Current Liabilities Accounts Payable Accrued Liabilities Long-term Liabilities Notes Payable Total Liabilities Stockholders' Equity Common Stock, no par Retained Earnings Total Stockholders' Equity $ Total Liabilities and Stockholders' Equity 24,700 5 26.400 22.500 23.900 43,000 61,000 rall 91,600 109,900 Ad 138,500 56 300 129,600 19.500 ng 194.800 JA 149.100 286.400 S 259.000 ing Print Done - -X DO Data table DO Do Albuquerque Group, Inc. Income Statement Year Ended December 31, 2024 Net Sales Revenue DO DO $ 442,000 205.200 DO 236,800 Cost of Goods Sold Gross Profit Operating Expenses Salaries Expense Depreciation Expense --Plant Assets $ 76,900 15,000 49,800 141,700 Other Operating Expenses Total Operating Expenses Operating Income Other Income and (Expenses) Interest Revenue 95 100 11,200 (24 800) (13.600) Interest Expense Total Other Income and (Expenses) Net Income Before Income Taxes Income Tax Expense 81,500 16.700 S 64,800 Net Income Print Done