The 2018 comparative balance sheet and income statement of Amber Group, Inc. follow. Amber 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 $14,100. 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 Panal B have been completed) Data Table X Amber Group, Inc. Spreadsheet for Statement of Cash Flows Year Ended December 31, 2018 Amber Group, Inc. Balance Transaction Analysis Balance Comparative Balance Sheet Panel A-Balance Sheet 12/31/2017 her DEBIT CREDIT 12/31/2018 December 31, 2018 and 2017 Cash S 15.500 5 9.600 2018 2017 Accounts Receivable 43,500 MI 42,100 Assets Merchandise Inventory 93,700 97,300 Current Assets I and 14.000 1 39,700 Cash S 9,600 3 15,500 Plant Assets 111 730 || 120 230 Accounts Recavabla 42,100 43,500 Accumulated Depreciation Plant Assets (17930) (19.530) Merchandise Inventory 97300 93 700 S Total Assets 260,500 s 289.400 Long term Assets Land 39,700 14.000 Accounts Payable 26,400 25,100 Plant Assets 120.230 111,730 Accrued Liabilities 22,800 | 24.400 Accumulated Depreciation-Plant Assets (19.530) (17.930) Notes Payable 61,000 43,000 $ 289.400 260.500 Total Assets Liabilities Total Liabilities 110,200 92 500 Current Liabilities: Accounts Payable S 25,100 $ 26.400 Common Stock 130,300 139,200 Accrund Liabilities 24400 22 800 Retained Earnings 20,000 N 57.700 Long term Liabilities Total Liabilities and Stockholders' Equity 5 260,500 S 289,400 Notes Payable 43.000 61.000 Total Liabilities 92,500 110,200 Panel B-Statement of Cash Flows: Stockholders' Equity Common Stock, no par 139.200 130,300 Cash Flows from Operating Activities: Retained Earnings 57,700 20,000 (a) 196.900 Total Stockholders' Equity 150,300 Adjustments to Reconcile Net Income Total Llabilities and Stockholders' Equity to Net Cash Provided by Operating Activities 5 289,400 5 260.500 (b) (c) (d) (e) Net Cash Provided by Operating Activities Cash Flows from Investing Activities: Net Cash Used for Investing Activities Cash Flows from Financing Activities 5 442 000 205 400 (k) 236.600 0 Net Cash Used for Financing Activities S m 76,300 15.700 49.400 Non-cash Investing and Financing Activities. 141.400 Net Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses Salaries Expanse Depreciation Expanse 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 (9) 95 200 Total Non-cash investing and Financing Activities (9) Total 11.900 (24.500) (12,600) 82 600 16.700 3 65,900 Net Income