Hi,

I'm requesting with your help.

Panel A- Balance Sheet.

Panel B- Statement of Cash Flows:

Income statement

Comparative Balance Sheet

Thank you,

Michelle

statement of cash flows. Format cash flows from operating activities by the indirect method. A plant asset was disposed of for 3 common stock and no treasury stock transactions. Assume plant asset and land acquisitions were for cash. empty do not s in Panel B when selecting the transaction references in Panel A. (If a box is not used in the spreadsheet, leave the box Use the transaction references Alden Group, Inc. Spreadsheet for Statement of Cash Flows Year Ended December 31, 2018 Transaction Analysis Balance Balance 12/31/2018 CREDIT DEBIT 12/31/2017 Panel A-Balance Sheet s 9.400 S 15,600 Cash 42,800 43.600 Accounts Receivable 90.800 93.200 Merchandise Inventory 38.100 3.000 Land 122.660 12.460 Plant Assets (21,760) 18,400 Acoumulated Depreciation-Plant Assets S 259,400 $ 207,800 Total Assets 2,300 25.100 Accounts Payable Accrued Liabilties 22,000 0,000 23.900 51.000 Notes Payable Total Liabilites 116,900 100,000 e balance sheet.) ement of cash flows. Format cash fHows from operating activities by the indirect method. A plant sactions. Assume plant asset and land acquisitions were for cash. Spreadsheet for Statement of Cash Flows Year Ended December 31, 2018 Transaction Analysis Balance Balance 12/31/2018 12/31/2017 DEBIT CREDIT et: s 15,600! 9.400 43,600 42,600 93.200 (a) 96,800 13,000 38,100 112.460 (d) (18.480) (e) 122,660 (21,760) ts S 259,400 (0 S 287,800 20.300|| (i) 0) 25,100 22.800 23.900 68.000 (k) 51,000 118.900 (m) 100,000 1 122.900 131,300 19.600 56.500 S 259,400 S 287,800 ash flows. Format cash flows from operating activities by the indirect method. A plant asset was disposed of for $0. T ssume plant asset and land acquisitions were for cash. sheet for Statement of Cash Flows ar Ended December 31, 2018 Transaction Analysis Balance Balance 12/31/2017 DEBIT CREDIT 12/31/2018 15.600|| 43.600 s S9.400 42,600 93,200 96,800 13.000 38.100 112.4801| (18,480) 22.660 (21,760) 287,800 S 259,400 th) 26,300 25.100 0) 22.600 23,900 ck) 88.000 51.000 116.900 100.000 122.900 131 300 19,600 56.500 259,400 S287,800 Prepare the spreadsheet for the 2018 statement of cash flows. Format cash flows from operating activities by the indi common stock, and no treasury stock transactions. Assume plant asset and land acquisitions were for cash. Panel B-Statement of Cash Flows: Cash Flows from Operating Activities: Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities: d) Net Cash Provided by Operating Activities Cash Flows from Investing Activities Net Cash Used for Investing Activites Cash Flows from Finanoing Activities 0) Net Cash Usad for Financing Activities (i Choose from any list or enter any number in the inout fieldis a Prepare the spreadsheet for the 2018 stalement of cash flows. Format cash flows from operating activities by the indirect met common stock, and no treasury stock transactions. Assume plant asset and land acquisitions were for cash. (0 Net Cash Provided by Operating Activities Cash Flows from Investing Activities Net Cash Used for Investing Activities Cash Flows from Financing Activities: Net Cash Used for Financing Activities Non-cash investing and Financing Activities: Total Non-cash Investing and Financing Activites Total Alden Group, Inc. Income Statement Year Ended December 31, 2018 Net Sales Revenue 5 442.000 205,100 Cost of Goods Sold 236.900 Gross Profit Operating Expenses S 76,500 Salanes Expense Depreciation Exoense-Plant Assets 15,600 49.600 Other Operating Expenses 141.700 Total Operating Expenses Operating income 95,200 Other Income and (Expenses: Interest Revenue 11.400 (24.500) Interest Expense 13.100 Total Other income and (Expenses) Net Income Before Income Taxes 82.100 16 400 Income T Expense 65.700 Net income Alden Group, Inc. Comparative Balance Sheet December 31, 2018 and 2017 2017 2018 Assets Current Assets: $9,400$ 15,600 Cash 42,600 43,600 Accounts Receivable 96,80093,200 Merchandise Inventory Long-term Assets: 38,100 13,000 Land 122660 112.460 Plant Assets (21,760) (18,460) Accumulated Depreciation Plant Assets S 287,800 S 259,400 Total Assets Liabilities Current Liabilities: S 25,100 $ 26,300 Accounts Payable 23,900 22,600 Accrued Liabilities Long-term Liabilities 51,000 68,000 Notes Payable 100,000116,900 Total Liabilities Stockholders' Equity 131.300122900 Common Stock, no par 56,500 19,600 Retained Earnings 187,800 142,500 Total Stockholders Equity S 287,800 S 259,400 Total Liabilities and Stockholders' Equity