P16B-45B Using a spreadsheet to prepare the statement of cash flows- indirect method The 2018 comparative balance sheet and income statement of Attleboro Group, follow. Attleboro disposed of a plant asset at book value in 2018. ATTLEBORO GROUP, INC. Income Statement Year Ended December 31, 2018 $441,000 205,400 235,600 $ 76,300 15,300 49,600 Net Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses: Salaries Expense Depreciation Expense Other Operating Expenses Total Operating Expenses Operating Income Other Income and (Expenses): Interest Revenue Interest Expense Total Other Income and (Expenses) Net Income Before Income Taxes Income Tax Expense Net Income 141,200 94,400 11,500 (24,400) (12,900) 81,500 16,200 $ 65,300 ATTLEBORO GROUP, INC. Comparative Balance Sheet December 31, 2018 and 2017 2018 2017 $ 14,000 42,000 96,800 $15,500 43,700 93,300 Assets Current Assets: Cash Accounts Receivable Merchandise Inventory Long-term Assets Land Plant Assets Accumulated Depreciation-Plant Assets Total Assets 36,400 121,250 (20,350) $ 290,100 11,000 112,850 (18,650) $ 257,700 Liabilities $ 24,500 23,900 $ 26,000 22,600 Current Liabilities: Accounts Payable Accrued Liabilities Long-term Liabilities: Notes Payable Total Liabilities 56,000 104,400 69,000 117,600 Stockholders' Equity Common Stock, no par Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity 129,500 56,200 185.700 121,000 19,100 140.100 $ 290,100 $257,700 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 $13,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