i need the formulas

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. Additional Information for 20X : 1. 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 signe No repayments on 43 notes were made. 44 5. Additional common stock was issued. Complete the statement of cash flows (indirect method) shown below by using formulas that reference 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