Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The 2024 comparative balance sheet and income statement of Attleboro Group, Inc. follow. Attleboro disposed of a plant asset at book value during 2024. (Click
The 2024 comparative balance sheet and income statement of Attleboro 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 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.) Attleboro Group, Inc. Spreadsheet for Statement of Cash Flows Year Ended December 31, 2024 Balance Transaction Analysis Balance Panel A-Balance Sheet: 12/31/2023 DEBIT CREDIT 12/31/2024 Cash 15,300 13,700 Accounts Receivable 43,300 42, 100 Merchandise Inventory 93,800 97,600 Land 18,000 43,700 Plant Assets 110,960 119,260 Accumulated Depreciation-Plant Assets 16,960 17,860) Total Assets $ 264,400 $ 298,500 Accounts Payable 26,300 24,900 Accrued Liabilities 22, 100 23,600 Notes Payable 68,000 58,000 Total Liabilities 116,400 106,500 Common Stock 128,900 136,900 Retained Earnings 19, 100 55, 100 Total Liabilities and Stockholders' Equity $ 264,400 $ 298,500Panel 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) (e) (f) Net Cash Provided by Operating Activities Cash Flows from Investing Activities: (h) Net Cash Used for Investing Activities Cash Flows from Financing Activities: (j) (k) (1) Net Cash Used for Financing Activities (m) Non-cash Investing and Financing Activities: (g) Total Non-cash Investing and Financing Activities (g) TotalAttleboro Group, Inc. Income Statement Year Ended December 31, 2024 Net Sales Revenue $ 440,000 Cost of Goods Sold 205, 100 Gross Profit 234,900 Operating Expenses: Salaries Expense 76,500 Depreciation Expense-Plant Assets 15,000 Other Operating Expenses 49,600 Total Operating Expenses 141, 100 Operating Income 93,800 Other Income and (Expenses): Interest Revenue 11,900 Interest Expense (24,300) Total Other Income and (Expenses) (12,400) Net Income Before Income Taxes 81,400 Income Tax Expense 16,800 Net Income 64,6002024 2023 Assets Current Assets: Cash 13,700 S 15,300 Accounts Receivable 42, 100 43,300 Merchandise Inventory 97,600 93,800 Long-term Assets: Land 43,700 18,000 Plant Assets 119,260 110,960 Accumulated Depreciation-Plant Assets (17,860) (16,960) Total Assets 298,500 5 264,400 Liabilities Current Liabilities: Accounts Payable 24,900 S 26,300 Accrued Liabilities 23,600 22,100 Long-term Liabilities: Notes Payable 58,000 68,000 Total Liabilities 106,500 116,400 Stockholders' Equity Common Stock, no par 136,900 128,900 Retained Earnings 55,100 19,100 Total Stockholders' Equity 192,000 148,000 Total Liabilities and Stockholders' Equity 298,500 5 264,400
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started