i Data Table Alden Group, Inc. Comparative Balance Sheet December 31, 2016 and 2015 2016 2015 Assets Current Assets: Cash $ 12,000 $ 15,700 Accounts Receivable 42,100 43,800 93,800 96,900 Merchandise Inventory Long-term Assets: Plant Assets 123,310 Accumulated DepreciationPlant Assets (22,610) 38,900 112,610 (18,510) 13,000 Land $ 290,600 $ 260,400 Total Assets Liabilities Current Liabilities: Accounts Payable $ 25,300 $ 26,500 Drint Dana i Data Table - X Alden Group, Inc. Income Statement Year Ended December 31, 2016 Sales Revenue $ 438,000 205,400 Cost of Goods Sold Gross Profit 232,600 Operating Expenses: Salaries Expense $ 76,700 Depreciation ExpensePlant Assets 15,700 49,600 Other Operating Expenses 142,000 Total Operating Expenses Operating Income Other Revenues and (Expenses): 90,600 Interest Revenue 11,200 Interest Expense (24,400) Total Other Revenues and (Expenses) (13,200) Net Income Before Income Taxes 77,400 Print Done The 2016 comparative balance sheet and income statement of Alden Group, Inc. follow. (Click the icon to view the comparative balance sheet.) Click the icon to view the income statement.) Alden disposed of a plant asset at book value during 2016. A plant asset was disposed of for $0. The cost and accumulated depreciation of the disposed asset was $11,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. Prepare the spreadsheet for the 2016 statement of cash flows. Format cash flows from operating activities by the indirect method. 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.) Alden Group, Inc. Spreadsheet for Statement of Cash Flows Year Ended December 31, 2016 Balance 12/31/2015 Transaction Analysis DEBIT CREDIT Balance 12/31/2016 Panel ABalance Sheet: : Cash $ $ $ 12,000 15,700 43,800 Accounts Receivable 42,100 Merchandise Inventory 93,800 112,610 Plant Assets Accumulated DepreciationPlant Assets Land (18,510) 13,000 96,900 123,310 (22,610) 38,900 290,600 S $ 260,400 Total Assets Choose from any list or enter any number in the input fields and then continue to the next question. Accounts Payable 25,300 Accrued Liabilities 26,500 22,200 60,000 24,100 Notes Payable 48,000 Total Liabilities 108,700 97,400 Common Stock 132,400 19,300 140,600 52,600 Retained Earnings $ 260,400 $ 290,600 Total Liabilities and Stockholders' Equity Panel B-Statement of Cash Flows: Cash Flows from Operating Activities: (a) Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities: (b) becne from anvliet ar antarany number in the innut field and then continue to the nevt etian (b) (c) (d) (e) (f) Net Cash Provided by Operating Activities Cash Flows from Investing Activities: (h) (i) Net Cash Used for Investing Activities Cash Flows from Financing Activities: (i) (k) Net Cash Used for Financing Activities (m) Net Cash Used for Investing Activities Cash Flows from Financing Activities: (i) (k) (1) Net Cash Used for Financing Activities (m) Non-cash Investing and Financing Activities: Total Non-cash Investing and Financing Activities g) Total