PLEASE PROVIDE EXCEL FORMULAS FOR THE BLANKS, the assignment can not be completed unless the answers are put into formula format. I provided the first protion of the assignment so that formulas can be provided. if theres anything missing thats needed to provide formulas please let me know and ill amend my question thank you.

1 Prepare a schedule of net cash provided by operating activities. - Prepare the Operating Activities Section of a Statement of Cash Flows using the Indirect... ? INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW FILE HOME Sign in 3 points X Calibri 11 Paste BIU. - A A Alignment Number Conditional Format as Cell Cells Formatting Table Styles Styles fu The following information is for FloorCo, Inc. for the year just ended: Clipboard Font eBook A1 V X B C D E F G H Print 1 The following information is for FloorCo, Inc. for the year just ended: 2 3 References 4 Beginning of year End of year S 5 Current assets: 6 Cash 7 Accounts receivable Inventory 9 Prepaid expenses 75,000 $ 158,000 285,000 11,000 90,000 140,000 246,000 16,000 8 284,000 9,500 27,000 302,000 11,200 24,000 11 Current liabilities 12 Accounts payable 13 Accrued liabilities 14 Income taxes payable 15 16 Net income 17 Accumulated depreciation 19 total credits 20 $ 94,500 $ 45,000 $ 94,500 21 floor Company did not record any gains or losses during the year. 22 23 Prepare a schedule of net cash provided by operating activities. 24 25 FloorCo, Inc. 25 Operating Activities Section of the Statement of Cash Flows 27 28 Vet income 29 Adjustments to reconcile net income to net cash provided by operations: 30 Depreciation 45,000 31 Increase in accounts receivable (18,000) 32 Increase in inventory (39,000) 33 Decrease in prepaid expenses 5,000 34 Decrease in accounts payable (18,000) 35 Decrease in accrued liabilities (1,700) 36 Increase in income taxes payable 3,000 37 Net cash provided by operating activities 38 39 40 (23,700 70.800 S Sheet1 + X All answers must be entered as a formula. Click OK to begin. OK 2 Use the income statement and balance sheet to prepare a statement of cash flows using the indirect method Prepare a statement of cash flows using the indirect method - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW FILE HOME INSERT Sign In 3 points Calibri 11 -A Skipped Paste BIU- % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Clipboard Font A1 X Required: eBook E Print References B c D 1 tequired: 2 Complete the statement of cash flows (indirect method) shown below by using formulas that reference 3 lata from the income statement and balance sheet (found by clicking the tabs at the bottom of this 4 vorksheet. Note: Blank cells may be included in calculations 5 6 INNOVATION ELECTRONICS, INC. 7 Statement of Cash Flows 8 For the Year Ended December 31, 20X2 Cash Flows from Operating Activities: 10 let income 11 djustments to reconcile net income to net cash 12 irovided by operating activities: 13 Depreciation expense 14 jain (on sale of land) 15 hanges in current assets and current liabilities: 16 Accounts receivable 17 nventory 18 'repaid insurance 19 Accounts payable 20 nterest payable 21 ncome tax payable 22 let cash provided by (used in operating activities let cash provided by (used in operating activities 23 24 Lash Flows from Investing Activities: 25 'urchase investments 26 ale of land 27 let cash provided by (used in) investing activities 28 29 ash Flows from Financing Activities: 30 ssue common stock 31 ssue long term note 32 let cash provided by (used in financing activities 33 let increase (decrease) in cash 34 Lash at beginning of the period 35 Lash at end of the period