I need the formulas!! Thank you

Use the income statement and balance sheet to prepare a statement of cash flows using the indirect method X 5. HOME 3 INSERT ? X Prepare a statement of cash flows using the indirect method - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW - 5 Sign In FILE Calibri B I U E- Paste Clipboard Editing - 11 AA . .A - Alignment Number Conditional Format as Cell - Formatting Table Styles - Font Styles X Required: Cells - 1 Required: 2 Complete the statement of cash flows (indirect method) shown below by using formulas that reference 3 data from the income statement and balance sheet (found by clicking the tabs at the bottom of this 4 worksheet. Note: Blank cells may be included in calculations. INNOVATION ELECTRONICS, INC. Statement of Cash Flows For the Year Ended December 31, 20X2 9 Cash Flows from Operating Activities: 10 Net income 11 Adjustments to reconcile net income to net cash 12 provided by operating activities: 13 Depreciation expense 14 Gain (on sale of land) 15 Changes in current assets and current liabilities: 16 Accounts receivable 17 Inventory 18 Prepaid insurance 19 Accounts payable 20 Interest payable 21 Income tax payable 22 Net cash provided by (used in operating activities 23 24 Cash Flows from Investing Activities: ... Income Statement Balance Sheet Cash Flow - READY Attempt(s) E E - T + 100% Hint Use the income statement and balance sheet to prepare a statement of cash flows using the indirect method ? X Prepare a statement of cash flows using the indirect method - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW - 5 Sign In FILE HOME INSERT Calibri B I U Cells - Editing - 11 AA . .A - Alignment Number Conditional Format as Cell - Formatting Table Styles - Font Styles Required: E- Paste Clipboard A1 21 ncome tax payable 22 Jet cash provided by (used in operating activities 23 24 Cash Flows from Investing Activities: 25 Purchase investments 26 ale of land 27 let cash provided by (used in) investing activities 29 Cash Flows from Financing Activities: 30 ssue common stock 31 ssue long term note 32 Jet cash provided by (used in financing activities 33 Vet increase (decrease) in cash 34 Cash at beginning of the period 35 Cash at end of the period - Income Statement Balance Sheet Cash Flow - READY E B - 1 + 100% Attempt(s) Hint D E C 1 Note: To complete the assignment, go to the worksheet tab labeled Cash Flow 2 and complete the statement of cash flows. 3 Note: Additional information is included at the bottom of the statement. INNOVATION ELECTRONICS, INC. Balance Sheet At December 31 120X220X1 Assets Current assets: 10 Cash $ 184,420 $ 25.740 11 Accounts receivable 68,700 83,000 12 Inventory 134,500 128.000 Prepaid insurance 2,980 4,560 Long-term assets: Investments 211.000 120,000 16 Land 208,500 255.000 17 Equipment 203,000 203,000 18 Accumulated depreciation (117,500) 20 Total assets S 895,600 $ 717,800 24 25 Liabilities and Stockholders' Equity Current liabilities: Accounts payable $ Income Statement Balance Sheet 26,500 $ Cash Flow - 81,000 I 23 24 $ $ 26,500 3,400 30,200 R1000 2300 32,500 26 27 28 20 30 31 32 Liabilities and Stockholders' Equity Current liabilities: Accounts payable Interest payable Income tax payable Long-term liabilities: Notes pavable Stockholders' equity: Common stock Retained earnings 255.000 242,000 273.000 307,500 230,000 130,000 Total liabilities and stockholders' equity S 895,600S 717,800 36 Additional Information for 20X2: 37 L. Assume that all increases and decreases in long term assets, long term liabilities, 38 and common stock are a result of cash transactions. 39 2. Land costing $46,500 was sold, resulting in a gain of $6,500. No other 40 long-term assets were sold. 41 3. Additional long-term investments were purchased 42 4. An additional long-term note payable was signed. No repayments on 43 notes were made. 44 5. Additional common stock was issued. - Income Statement Balance Sheet Cash Flow - I 1 Note: To complete the assignment, go to the worksheet tab labeled Cash Flow 2 and complete the statement of cash flows. complete the ansignment, go to the worksheet al labeled Cash Flow INNOVATION ELECTRONICS, INC. Income Statement For the Year Ended December 31, 20X2 Net sales $ Gain on sale of land 2.430,000 6.500 Total revenues 2.436.500 $ Expenses: Cost of goods sold Operating expenses Depreciation expense Interest expense Income tax expense 1,565,000 598,000 16,000 17.000 63,000 Total expenses 2.259.000 21 Net income 177.500 Income Statement Balance Sheet Cash Flow