The 2018 comparative balance sheet and income statement of Attleboro Group, Inc. follow. Attleboro disposed of a plant asset at book value during 2018.

The 2018 comparative balance sheet and income statement of Attleboro Group, Inc. follow. Attleboro disposed of a plant asset at book value during 2018 EEE (Click the icon to view the comparative balance sheet.) EEB (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 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 treasur 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 Balance Transaction Analysis Balance Panel A-Balance Sheet: 12/31/2017 DEBIT CREDIT 12131/2018 $ 15,700 43,700 93,100 10,000 112,430 (17,930) $ 257,000 $ 10,200 42,200 96,900 35,800 122,830 (20,930) $ 287,000 Cash Accounts Receivable Merchandise Inventory Plant Assets Accumulated Depreciation-Plant Assets Total Assets Accounts Payable Accrued Liabilities Notes Payable otal Liabilities 26,600 22,300 68,000 116,900 25,500 23,800 50,000 99,300 Common Stock 120,700 19,400 129,600 58,100 Retained Earnings 19,400 58,10 Retained Earnings $ 257,000 $ 287,000 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 Net Cash Used for Financing Activities Net Cash Provided by Operating Activities Cash Flows from Investing Activities: Net Cash Used for Investing Activities Cash Flows from Financing Activities: 0) Net Cash Used for Financing Activities Non-cash Investing and Financing Activities: Total Non-cash Investing and Financing Actvities Total 2018 2017 Assets Current Assets Cash Accounts Receivable Merchandise Inventory $ 10,200 $15,700 43,700 93,100 42,200 96,900 Long-term Assets 35,800 Land Plant Assets Accumulated Depreciation-Plant Assets 10,000 112.430 (20,930) (17,930) $ 287,000 $ 257,000 122,830 Total Assets Liabilities Current Liabilities Accounts Payable $ 25,500 $ 26,600 22,300 Accrued Liabilities 23,800 Long-term Liabilities 50,000 68,000 Notes Payable Total Liabilities 99,300 116,900 Stockholders' Equity Common Stock, no par Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity 120,700 19,400 140,100 $ 287,000 $ 257,000 129,600 58,100 187,700 Attleboro Group, Inc. Income Statement Year Ended December 31, 2018 Net Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses S 442,000 205,200 236,800 Salaries Expense Depreciation Expense-Plant Assets Other Operating Expenses Total Operating Expenses s 76,300 15,300 49,100 140,700 Operating Income Other Income and (Expenses) 96,100 Interest Revenue Interest Expense Total Other Income and (Expenses) 11,400 (24,100) Net Income Before Income Taxes Income Tax Expense Net Income (12,700) 83,400 16,000 S 67,400