You have to prepare the cash flow statement. You can do it your way, or you can follow the steps below: 1. Compute the cash balance in the Y1 column. 2. Compute the ending balances for Y2 given the data in two panels at the bottom of the balance sheet. 3. Compute the change in balance sheet. 4. ICF1: Identify changes in non-cash accounts due to purchase of PP&E. Enter the formula for the change in cash in the first row. 5. ICF2: Identify changes in non-cash accounts due to sale of PP&E. Enter the formula for the change in cash in the first row. 6. Subtract changes due to investing from the total change to arrive at changes due to operating activities. 7. Use this information to prepare the cash flow statement. 8. If your computations have errors, then the check cells will not be blank. Y1 Y2 Change ICF1| ICF2 OCF 995.00 732.00 970.00 |-707.00 Balance sheet [Compute missing numbers] Cash Ending gross PP&E Ending accumulated depreciation Retained earnings Check Changes in accounts due to purchase and sale during the year ICF1: Gross PP&E bought during the year ICF2: Gross PP&E sold during the year ICF2: Accumulated depreciation of PP&E sold during the year ICF2: Gain on sale of PP&E Income statement data Sales revenue Depreciation expense = Income before gain Gain on sale of PP&E = Net income Change 458.00 400.00 354.00 74.00 800.00 220.00 580.00 74.00 654.00 Year 2 Computations Ending gross PP&E Ending accumulated depreciation Net income Operating cash flow Capital expenditures (Put a negative sign in front of the number.] Proceeds from sale of PP&E Investing cash flows