please complete and correct the work.
The 2024 comparative balance sheet and income statement of Albuquerque Group, Inc. follow. Albuquerque disposed of a plant asset at book value during 2024.
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 $ 12,600. 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. (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.)
Balance Sheet
Income Statement:
The 2024 comparative balance sheet and income statement of Albuquerque Group, Inc. follow. Albuquerque disposed of a plant asset at book value during 2024.
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 $ 12,600. 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.
Requirment: 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.)
Data table Data table Spreadsheet for Statem ent of Cash Flows Panel B-Statement of Cash Flows: Cash Flows from Operating Activities Adjustments to Reconcile Net income to Net Cash Frovided by Operating Activities: \begin{tabular}{|l|} \hline Depreciation Expense-Plant Assets \\ \hline Decrease in Accounts Recenable \\ \hline Decrease in Merchandise lriventory \\ \hline Decrease in Accounts Payable \\ \hline Increase in Accrued Labilities \\ \hline \end{tabular} (d) (e) Net Cash Provided by Operating Activities Cash Flows from Investing Activties \begin{tabular}{l} \hline Cash Payment for Acquisition of Plant Assets \\ Net Cash Used for Investing Activities \\ Cash Flows from Financing Activties: \\ \hline Cash Rayment of Notes Payable \\ \hline Cash Receipt from Issuance of Common Stock \\ \hline Cash Payment of Dividends \\ Net Cash Used for Financing Activties \end{tabular} (h) (i) 00 (i) \begin{tabular}{l} \hline Decrease in Accounts Recemable \\ \hline Decrease in Merchandise Iment ory \\ \hline Decrease in Accounts Payable \\ \hline Increase in Accrued Liabilities \\ \hline \end{tabular} Net Cash Provided by Operating Actwities Cash Flows from investing Activities: \begin{tabular}{|c|} \hline Cash Payment for Acquisition of Plant Assets \\ \hline \end{tabular} Net Cash Used for Imesting Actinties Cash Flows from Financing Actities \begin{tabular}{l} \hline Cash Payment of Notes Payable \\ \hline Cash Receipt from Issuance of Common Stock \\ Net Cash Used for Financing Activities Payment of Dimidends \\ Net Increase in Cash \\ Non-cash Investing and Financing Activies: \\ Cash Receipt from Disposal of Plant Asset \\ Total Non-cash Imesting and Financing Activities \\ Total \end{tabular} The 2024 comparative balance sheet and income statement of Abuquerque Group, inc, follow Abrquerque dispesed of a plant asset at book value dunng Ro24. Coick the icon to vinw the cornparatae balance shet! (Cick the icon to wev the income statement) retaemert of cormmon stock, and no treasury atock trantactions Assume flant asset and land acquastions were for cash We the transaction ieferences in Panel B when selecting the transaction teferences in Panel A (f a box is not used in the spreadstheot, feave the box ampty, do net select a labJl ar onter a Abuquergue Group. Inc. Spreadsheet for Statement of Cash Flows Year Ended December 31, 2074 Yom tealed berenked 31, rwi Data table Data table Albuquerque Group, Inc. Albuquerque Group, Inc. Spreadsheet for Statement of Cash Flows Panel B-Statement of Cash Flows: \begin{tabular}{l|} \hline Cash Flowe trom Operating Activities: \\ Adjustments to Reconoile Net Income \\ to Net Cash Provided by Operating Activities: \\ \hline \\ \hline \end{tabular} (a) (d) (e) (i) Net C ash Provided by Operating Activities Cash Flous fromrinvesting Activities: (h) (i) Net Cash Used for Investing Activities Cash Flowe from Financing Activities. Net Cash Used for Financing Activities Net Cash used for financing Activities Non-cash Investing and Financing Activities: Total Nonicash livesting and Financing Activities Total Data lable