The 2018 comparative balance sheet and income statement of Alden Group, Inc. follow. Alden disposed of a plant asset at book value during (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 ass stock transactions. Assume plant asset and land acquisitions were for cash Year Ended December 31, 2018 Balance Transaction Analysis Balance Panel A-Balance Sheet: 12/31/2017 DEBIT CREDIT 12/31/2018 Cash $ 15,600 9,400 Accounts Receivable 43,000 41,800 Merchandise Inventory 93,700 97,600 Land 14,000 39,800 Plant Assets 110,720 119,820 Accumulated Depreciation-Plant Assets (16,520) (18,220) $ 260,500 100 S 290,200 Total Assets Accounts Payable Accrued Liabilities Notes Payable Total Liabilities Common Stock Retained Earnings Total Liabilities and Stockholders' Equity Panel B-Statement of Cash Flows: Cash Flows from Operating Activities: Adjustments to Reconcile Net Income 26,500 22,400 64,000 112,900 127.600 20,000 $ 260,500 (a) 25,100 23,500 51,000 99,600 135,600 55,000 $ 290,200 Panel B-Statement of Cash Flows: Cash Flows from Operating Activities Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities @ (c) (d) (e) (f) Net Cash Provided by Operating Activities Cash Flows from Investing Activities Net Cash Used for Investing Activities Cash Flows from Financing Activities: G (k) (1) Net Cash Used for Financing Activities Non-cash Investing and Financing Activities: Total Non-cash Investing and Financing Activities Total (g) (m) Data table Alden Group, Inc. Comparative Balance Sheet December 31, 2018 and 2017 Current Assets Cash Accounts Receivable Merchandise Inventory Long-term Assets: Assets 2018 2017 $ 9,400 S 15,600 41,800 43,000 97,600 93,700 Land 39,800 14,000 Plant Assets 119,820 110,720 Accumulated Depreciation-Plant Assets (18,220) (16,520) 290,200 $ 260,500 Total Assets Current Liabilities: Accounts Payable Accrued Liabilities Long-term Liabilities: Liabilities $ 25,100 $ 26,500 23,500 22,400 Notes Payable Total Liabilities: 51,000 64,000 99,600 112,900 Stockholders' Equity Common Stock, no par 135,600 127,600 55.000 20.000 Print Done - X Data table Current Assets: Cash Accounts Receivable Merchandise Inventory Long-term Assets Land Plant Assets 2018 2017 Assets Accumulated Depreciation-Plant Assets Total Assets Current Liabilities: Liabilities $ 9,400 $ 15,600 41,800 43,000 97,600 93,700 39,800 14,000 119,820 110,720 (18,220) (16,520) $ 290,200 $ 260,500 Accounts Payable Accrued Liabilities Long-term Liabilities: 25,100 $ 26,500 23,500 22,400 $1.000 64,000 Notes Payable Total Liabilities 99,600 112,900 Stockholders' Equity Common Stock, no par 135,600 127,600 55,000 20,000 Retained Earnings 190,600 147,600 Total Stockholders' Equity $ 290,200 $ 260,500 Total Liabilities and Stockholders' Equity Print Done Data table Alden Group, Inc. Income Statement Year Ended December 31, 2018 Net Sales Revenue 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 Interest Expense Total Other Income and (Expenses) Net Income Before Income Taxes Income Tax Expense Net Income S $ 440,000 205,500 234,500 76,400 15,500 49.400 141,300 93,200 11,300 (24,100) (12,800) 80,400 16,700 63,700 Print Done Calculator 12 Data table ULIM Data table