I'm stuck. Please hello me solve this problem but outline the steps/ reasoning so I can learn.

AutoSave Off table - File Home Insert Draw Page Layout Formulas Data Review View Help Calibri ab Wrap Text X Cut Le Copy Format Painter - 11 A A === CA- Paste BIU Merge & Center Clipboard Font Alignment i POSSIBLE DATA LOSS Some features might be lost if you save this workbook in the comma-delimited (.csv) format A1 X Atkinson Group, Inc. A B D E F G 2018 2017 $14,100 $15,300 42,400 43,700 96,300 93,200 1 Atkinson Group, Inc. 2 Comparative Balance Sheet 3 December 31, 2018 and 2017 4 5 Assets 6 Current Assets: 7 Cash 8 Accounts Receivable 9 Merchandise Inventory 10 Long-term Assets: 11 Land 12 Plant Assets 13 Accumulated Depreciation"Plant Assets 14 Total Assets 15 Liabilities 16 Current Liabilities: 17 Accounts Payable 18 Accrued Liabilities 19 Long-term Liabilities: 20 Notes Payable 21 Total Liabilities 22 Stockholders' Equity 23 Common Stock, no par 24 Retained Earnings 25 Total Stockholders' Equity 26 Total Liabilities and Stockholders' Equity 27 39,900 14,000 121,450 112,650 -20,950 -18,650 $293,200 $260,200 $24,500 24,600 $26,000 22,900 51,000 100,100 61,000 109,900 139,500 131,100 53,600 19,200 193,100 150,300 $293,200 $260,200 28 29 30 31 32 33 34 35 36 Court Calibri 11 A A = = = A EEEEEEE LE Copy 33 Format Painter Paste B I U Clipboard Font Alignme POSSIBLE DATA LOSS Some features might be lost if you save this workbook in the comma- A1 12 f Atkinson Group, Inc. B C D E $440,000 205,300 234,700 A 1 Atkinson Group, Inc. 2 Income Statement 3 Year Ended December 31, 2018 4 Net Sales Revenue 5 Cost of Goods Sold 6 Gross Profit 7 Operating Expenses: 8 Salaries Expense 9 Depreciation Expense" Plant Assets 10 Other Operating Expenses 11 Total Operating Expenses 12 Operating Income 13 Other Income and (Expenses): 14 Interest Revenue 15 Interest Expense 16 Total Other Income and (Expenses) 17 Net Income Before Income Taxes 18 Income Tax Expense 19 Net Income $76,400 15,900 49,600 141,900 92,800 11,500 -24,700 -13,200 79,600 16,500 $63, 100 20 21 22 23 24 25 26 27 28 29 30 31 Calibri (Body) - 11 B I J x x H A. A Aar AA Font ... E ! AL Paragraph Styles Editing Dictate Sensitivity Editor Styles Voice Sensitivity Editor 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.) Atkinson Group, Inc. Spreadsheet for Statement of Cash Flows Year Ended December 31, 2018 Balance Balance Transaction Analysis DEBIT CREDIT Panel A Balance Sheet: 12/31/2017 12/31/2018 Cash $1,200 (m) $14.100 $15.300 43.700 Accounts Receivable 1,300 C Merchandise Inventory 93,200 (d) $3,100 42,400 96,300 39.900 121,450 Land 25,900 14,000 112,650 (h) 13,600 (g) Plant Assets Accumulated Depreciation - Plant Assets Total Assets (6) (18.650) (g) $260,200 (20.950) $293,200 1,500 24,500 Accounts Payable Accrued Liabilities Notes Payable Total Liabilities 26,000 (e) 22,900 61.000 0 1,700 (f) 24,600 51,000 10.000 109,900 100,100 131,100 19,200 (1) Common Stock Retained Earnings Total Liabilities and Stockholders' Equity 8,400 (k) (a) 139,500 53,600 $260,200 $293,200 Panel B Statement of Cash Flows: Cash Flows from Operating Activities: Net Income Adjustments to Reconcile Net Income EX 63.100 1 of 2 305 words Focus Start a search AutoSave OF Document1 - Word O Christina Elam CE Mailings Review View Help Share Comments File Home Insert Draw Design Layout References X Calibri (Body) - 11 EE BIUab , X A Paste 3 A--AA AA - 21 1 Clipboard Font Paragraph Styles Editing Dictate Sensitivity Editor Styles Voice Sensitivity Editor (6) 15,900 1,300 3,100 (d) 10000 (e) (f) 24600 to Net Cash Provided by Operating Activities Depreciation Expense Plant Assets Decrease in Accounts Receivable Increase in Merchandise Inventory Decrease in Accounts Payable Increase in Accrued Liabilities Net Cash Provided by Operating Activities Cash Flows from Investing Activities: Cash Payment for Acquisition of Plant Assets Cash Payment for Acquisition of Land Net Cash Used for Investing Activities Cash Flows from Financing Activities: Cash Payment of Notes Payable Cash Receipt from Issuance of Common Stock Cash Payment of Dividends Net Cash Used for Financing Activities (h) 0 I (k) (1) (m Net Decrease in Cash Non cash Investing and Financing Activities Disposal of Plant Asset at Book Value Total Non cash Investing and Financing Activities (8) Total (Ctrl) - Page 2 of 2 305 words Focus 2 Ee + 100 Start a search O Score: 0 of 25 pts 8 of 8 (8 complete) X PCA-38A (similar to) HW Score: 72 21% 7 Ques The 2018 comparative balance sheet and income statement of Atkinson Group, Inc. follow. Atkinson disposed of a plant asset at book value during 2018 E!! (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 S0. The cost and depreciation of the disposed asset was $13,600. There were no sales of land, no retirement of common stock, and no treasury stock transactions. Assume plant asset and land acqu 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 Do not check your answer until both Panel A and Panel B have been completed.) Atkinson Group, Inc. Spreadsheet for Statement of Cash Flows Year Ended December 31, 2018 Balance Transaction Analysis Balance DEBIT 12/31/2017 CREDIT 12/31/2018 Panel A--Balance Sheet: 5 1.200 (m) 5 14100 15,300 al Check Answe Cash UM-.-. Clear All Choose from any list or enter any number in the input fields and then click Check Answer All parts showing Reflect in e Portfolio Activity Details