120,600 19,900 51,800 lders' Equity $ 256,300 $ 278,500 ent of Cash Flows: ctivit Data Table et In erati Albuquerque Group, Inc Comparative Balance Sheet December 31, 2018 and 2017 2018 20 Assets Current Assets Cash Accounts Receivable Merchandise Inventory $ 2.700 15,600 42,00043,100 93,400 iviti 97.200 Long-term Assets: Land Plant Assets Accumulated Depreciation-Plant Assets 35,500 10,000 120,530 112.130 (19,430) (17.930) $278,500 $ 256,300 ivit Total Assets ct Liabilities Current Liabilities: $ 25,300 $ 26,800 23,100 22.000 Accounts Payable Accrued Liabilities ng Long-term Liabilities: 49,000 Notes Payable Total Liabilities 97,400 115,800 Stockholders' Equity 120,600 19,900 Common Stock, no par Retained Earnings Total Stockholders' Equity 129,300 51,800 181,100 140,500 22,000 67,000 115,800 23,100 49,000 97400 120,600 19,00 $ 256,300 129,300 51,800 $ 278,500 nd Stockholders Equity B-Statement of Cash Flows: Operating Activities Data Table Reconcile Net Income ided by Operating Ac Albuquerque Group, Inc Income Statement Year Ended December 31, 2018 Net Sales Revenue $ 437,000 205,200 231,800 Cost of Goods Sold by Operating Actvi Gross Prof Operating Expenses: nvesting Activities: Salaries Expense Depreciation Expense-Plant Assets Other Operating Expenses Total Operating Expenses $76,600 15,300 49,600 Investing Activities nancing Activities: 141,500 Operating Income Other Income and (Expenses): 90,300 Interest Revenue Interest Expense Total Other Income and (Expenses) (24,600) Financing Activities (12800) Net Income Before Income Taxes and Financing Acti 6,800 Income Tax Expense $ 60,700 Net Income sting and Financing Print Done t or enter any number in the input fields and then click Check Answer Check Answer Clear All The 2018 comparative balance sheet and income statement of Albuquerque Group Inc. follow. Albuquerque EB(Click the icon to view the comparative balance sheet.) disposed of o plant asset at Click the icon to view the income statement.) Prepare the spreadsheet for the 2018 statement of cash flows Format cash flows from operating S0. The cost and accumulated depreciation transactions Assune plant asset and land acquisitions were for cash. activities by the indirect method. A pla of the disposed asset was $13,800. There were no sales of land, no retirement of common a Use the transaction references in Panel B when selecting the transaction references in Panel A. 0 select a label or enter a zero. Do not check your answer until both Panel A and Panel 8 have been completed) Albuquerque Group, Ine Spreadsheet for Statement of Cash Flows Yenar Ended December 31,2018 Transaction Analysis Panel A-Balance Sheet: 12/31/2017 15,600 43,100 DEBIT CREDIT 12/31/2018 2,700 42,000 97,200 35,500 120,530 (19,430) 278,500 Cash Accounts Receivable Merchandise Inventory Plant Assets Accumulated Depreciation-Plant Assets Total Assets 10,000 112,130 (17,930) 256 300 Accounts Payable Accrued Liabilities Notes Payable Total Liabilities 26,800 25,300 23,100 49,000 97.400 67,000 115,800 129,300 Common Stock Retained Earmings Total Liabilities and Stockholders Equity 120,600 19,900 $ 256,300 51,800 278,500 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 Choose from any list or enter any number in the input fields and then click Check Answer All parts showing Clear All Notes Payable 67,000 49,000 Total Liabilities 115,800 97 400 20,600 Common Stock Retained Earnings Total Liabilities and Stockholders' Equity 129,300 51,800 278,500 19,900 256,300 Panel B-Statement of Cash Flows Cash Flows from Operating Activities Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities: b) 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 Total Non-cash Investing and Financing Activities Total Choose from any list or enter any number in the input fields and then click Check Answer showing Clear All