70.2K

Verified Solution

Link Copied!

The 2018 comparative balance sheet and income statement of Attleboro Group, Inc. follow. Attleboro disposed of a plant asset at book value during 2018. : (Click the icon to view the comparative balance sheet.) : (Click the icon to view the income statement.) Prepare the spreadsheet for the 2018 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,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. (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, 2018 Transaction Analysis Balance 12/31/2017 Balance 12/31/2018 Panel A-Balance Sheet: DEBIT CREDIT Cash 9,100 Accounts Receivable 42,300 15,500 43,400 93,400 14,000 Merchandise Inventory Land 97,400 39,300 121,760 (20,260) Plant Assets 111,460 (17,560) Accumulated DepreciationPlant Assets $ 260,200 $ 289,600 Total Assets Accounts Payable Accrued Liabilities 26,500 22,300 62,000 24,700 24,200 50,000 Notes Payable Total Liabilities 110,800 98,900 Common Stock 129,500 19,900 260,200 137,600 53,100 Retained Earnings $ 289,600 Total Liabilities and Stockholders' Equity Panel B-Statement of Cash Flows: Cash Flows from Operating Activities: Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities: Net Cash Provided by Operating Activities Cash Flows from Investing Activities: = Net Cash Used for Investing Activities Cash Flows from Financing Activities: 5 Net Cash Used for Financing Activities Non-cash Investing and Financing Activities: Total Non-cash Investing and Financing Activities Total Data Table i Data Table Attleboro Group, Inc. Comparative Balance Sheet December 31, 2018 and 2017 2018 Attleboro Group, Inc. Income Statement Year Ended December 31, 2018 2017 Net Sales Revenue Assets $ 437,000 205,400 Current Assets: 231,600 Cash Accounts Receivable Merchandise Inventory Long-term Assets: 9,100 $ 42,300 97,400 15,500 43,400 93,400 $ 76,200 Cost of Goods Sold Gross Profit Operating Expenses: Salaries Expense Depreciation Expense-Plant Assets Other Operating Expenses Total Operating Expenses Operating Income Other Income and (Expenses): Interest Revenue 15,000 49,800 Land Plant Assets 39,300 121,760 (20,260) 14,000 111,460 (17,560) 141,000 Accumulated DepreciationPlant Assets 90,600 $ 289,600 $ 260,200 Total Assets Liabilities 11,700 (24,200) Current Liabilities: Interest Expense $ (12,500) Accounts Payable Accrued Liabilities Long-term Liabilities: 24,700 $ 24,200 26,500 22,300 Total Other Income and (Expenses) Net Income Before Income Taxes Income Tax Expense 78,100 16,000 50,000 62,000 $ 62,100 Net Income Notes Payable Total Liabilities 98,900 110,800 Stockholders' Equity Print Done Common Stock, no par Retained Earnings 137,600 53,100 190,700 289,600 $ 129,500 19,900 149,400 260,200 Total Stockholders' Equity $ Total Liabilities and Stockholders' Equity

Answer & Explanation Solved by verified expert

See Answer