G Search the web... f a D: AutoSave Off Problem 7 Excel Template Search Russell, Javier M (Hopkinsville Student) RJ X File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments X Insert Arial ab Wrap Text General 11 A A A AY o o 8 LG 2X Delete Paste BIU Ideas EESE E Merge & Center y Sensitivity $ -% 00 0 Format Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Editing Clipboard Font Alignment Number Cells Ideas Sensitivity F29 for Cash, December 31, 2021 E G G H 1 J K L M P + R S T U Davidson Company Statement of Cash Floys For the Year Ended December 31, 2021 Cash Flows from Operating Activities Net Cash Provided (Used) By Operating Activities B 1 Problem 7 Chapter 14 2 INSTRUCTIONS: The items listed below belong on the Statement of Cash Flows. The correct format for the Statement is also provided. Using formulas 3 and cell links, complete the Statement of Cash Flows. 4 5 Items for the Statement of Cash Flows: 6 01/01/21 12/31/21 Increase (Decrease) 7 Cash 42,000 60,000 8 Accounts Receivable 254,000 314,200 9 Inventory 78,500 117,100 10 Accounts Payable 164,200 204,800 11 Short-term Notes Payable 65,000 27,200 12 13 14 Net Income for 2021 230,200 15 Purchase of Equipment 84.000 16 Depreciation Expense 26,600 17 Payment of Cash Dividends 91,600 18 Sale of Land 32,800 19 20 21 22 23 24 25 26 27 28 29 30 Sheet1 + Cash Floys from Investing Activities Net Cash Provided (Used) By Investing Activities Cash Flows from Financing Activities Net Cash Provided (Used) By Financing Activities Net Increase (Decrease) in Cash Cash, January 1, 2021 Cash, December 31, 2021 + 66% Type here to search j E a X ? la 8:30 PM 10/11/2020