4 Directions 5 A) Using the information below and the template on the west tab, prepare a statement of each flows (indirect method) 6 B) Also using the template on the best tab, compute free cash flow 7 8 Grading 9 10 In order to get full points for this project 11 Cells in one on the template should be . VALUE 12 Cells in green on the template should be a FORMULA 13 Cells in yellow on the template should be TEXT 14 15 The points wilable for each row requiring input ne noted in Column G on the template in the next tab. 16 17 We Really Love Cash, Co. We Really Love Cash, Co. 18 Comparative Balance Sheet Income Statement 19 December 31 For the Year ended December 31, 2020 20 21 2020 2019 $242,000 Sales revenue 22 Assets Cost of goods sold 175,000 23 Cash $39,000 $20,000 Gross profit 67,000 24 Accounts Recerrable 30,000 14.000 Operating expenses 24,000 25 Inventory 27,000 20.000 Income from operations 43.000 26 Equipment 60,000 78,000 3.000 Interest expense Accumulated depreciation equpmeet 29.000 (24,000) Income before income taxes 40.000 28 Total Assets $127.000 $100,000 Income tax expense 8.000 29 Net income $32000 30 Liabilities and Stockholders' Equity 31 Accounts payable $24,000 $15,000 32 Income taxes payable 7,000 8.000 Bonds payable 27,000 33 000 34 Common stock 18,000 14,000 75 Retsed eng 51 000 38,000 36 Total Liabilities and Stockholders' Equity $127,000 $10,000 38 10 -11 42 Additional data 1 Dividends declared and paid were $19,000 2. During the year equipment was sold for $6,500 enh. Thus equipment cost $18,000 otpally and had a book value of $6,500 at the time of sale 3. All depreciation expense, 516,500, is in the operating expenses 4. All sales and purchases se on account 45 46 47 49 50 51 55 56 57 58 59 50 51