Homework: Homework CH14 Score: 0 of 25 pts com PCA-38A (similar to) The 2018 comes we shot and come word of Alen Group, refowlended a new book 2010 HW Score: 18.93% 18.93 of 100 pts Outono 0 Pre nero 2018 meter hoomas the rest of the candidato 13 Panel compted) he tools and when we had to welcome to our Drew wwwwww DEBIT CREDIT 12010 het for en af Cash Younded December 2018 Balance BONT 5 15.100 43.100 3.300 10.000 TO 117.00 000 00 100 1 254.100 293.700 Choose from any or enterrumber in the route and then click Check Al part showing CA Check G Search or type URL The 2018 comparative balance sheet and income statement of Allen Group, Inc. follow. Alle 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 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. Allen Group, Inc. Spreadsheet for Statement of Cash Flows Year Ended December 31, 2018 Balance Transaction Analysis Balance Panel A-Balance Sheet: 12/31/2017 DEBIT CREDIT 12/31/2018 Cash $ 15.100 5 9,500 Accounts Receivable 43.100 42,000 Merchandise Inventory 93.200 96,500 Land 19,000 44,500 Plant Assets 111,630 121,830 (17,930) (20,630) Accumulated Depreciation--Plant Assets $ 264,100 293.700 Total Assets $ Accounts Payable Accrued Liabilities 26,000 22,400 66,000 24,400 23,600 48,000 Notes Payable Choose from any list or enter any number in the input fields and then click Check Answer. All parts showing Clear All The 2018 comparative balance sheet and income statement of Allen Group, Inc. follow. Allen 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.TH 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. Total Liabilities 114,400 95.000 Common Stock 130.600 19.100 139,300 58.400 Retained Earnings Total Liabilities and Stockholders' Equity $ 264,100 $ 293,700 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) (c) (d) (e) In Choose from any list or enter any number in the input fields and then click Check Answer. Clear All All parts showing Homework: Homework CH14 Score: 0 of 25 pts B of 8 (3 complete PCA-38A (similar to) The 2018 comparative balance sheet and income statement of Allen Group, Inc. follow. Alle 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 50. The There were no sales of land, no retirement of common stock, and no treasury stock transactions. Assume plant asset and land squinitions were for cash Net Cash Provided by Operating Activities Cash Flows from Investing Activities: ch) 0) Net Cash Used for Investing Activities Cash Flows from Financing Activities: 0 (k M Net Cash Used for Financing Activities (m) Non-cash investing and Financing Activities: (9) Total Non-cash investing and Financing Activities (9) Total Choose from any list or enter any number in the input fields and then click Check Answer Clear All All parts showing Data Table en Groy mat ca! no treas nd accu Allen Group, Inc. Comparative Balance Sheet December 31, 2018 and 2017 saction or enter 2018 2017 coup, Ind Assets tement Current Assets cember Cash 9,500 $ 15,100 43,100 93,200 42,000 96,500 alance 31/2017 Accounts Receivable Merchandise Inventory Long-term Assets: Land Plant Assets 44.500 15,100 43,100 93,200 19.000 111,630 (17,930 121,830 (20,630) 19,000 111,630 (17,930) Accumulated Depreciation-Plant Assets 293,700 $ 264,100 Total Assets Liabilities 264.100 Current Liabilities: Accounts Pavable 24.400 $ 26.000 A Print Done s and then Data Table - X roy (c Land ! eas 44,500 19,000 Plant Assets Accumulated DepreciationPlant Assets 121,830 (20,630) 111,630 (17,930) on Total Assets $ 293,700 $ 264,100 Ind Liabilities nt Current Liabilities: ber Accounts Payable $ $ 24,400 $ 26,000 e 23,600 22,400 Accrued Liabilities Long-term Liabilities: 17 100 Notes Payable 48,000 66,000 Total Liabilities 96,000 114,400 Stockholders' Equity 100 200 ood -630 230) Common Stock, no par 139,300 130,600 19,100 58,400 Retained Earnings 197,700 Total Stockholders' Equity 149.700 -100 $ 293,700 $ 264,100 Total Liabilities and Stockholders' Equity nnd Print Done chen career class ev01 misspap A econ 8 of 8 (3 complete) Toup. In * Data Table (Click to cash nld Basury The cost and accumulated Income Statement Year Ended December 31, 2018 Net Sales Revenue on reford $ 445,000 205,700 lect a label or enter a zero Inc. 239,300 nt of Ca ser 31, 2 $ 76,700 15,000 49,900 17 100 141,600 Cost of Goods Sold Gross Profit Operating Expenses Salaries Expense Depreciation ExpensePlant 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 100 97.700 200 000 11,700 (24.800) 630 230) (13,100) 100 84,800 16,700 then click Print Done con 8 of 8 (3 complete) =p. In 0 Data Table lick to sh fid sury The cost and accur $ 445,000 205,700 refer blect a label or enter 239,300 nc. 76,700 of Ca r 31,2 15,000 49,900 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 141,600 7 97,700 00 00 00 11,700 (24,800) 100 (13,100) 530 30) 84,600 16,700 100 $ 67.900 Net Income All hen click Print Done CAN