M14. CASH FLOW FROM OPERATING ACTIVITIES Shanna Company reported balances at the beginning and end of the year a net income of $105,000 for the current year. Depreciation for the year totaled $38,000. Current asset and liability accounts had the following Beginning $41,300 48,800 Ending $39,500 55,000 69,800 5,400 43,700 6,000 Cash nts receivable Inventory Prepaid rent Accounts payable Salaries payable 6,000 54,100 8.400 The president of Shanna Company has asked you to develop a worksheet that will compute cash fiow from operating activities (file name CASHFL). Use the information provided as input for the Data Section of your worksheet. Review the Model-Building Problem Checklist on page 154 to ensure that your worksheet is complete and ready to be graded. Print the worksheet when done. Check figure: Cash flow from operating activities, $129,800 To test your model, use the following information for the next year, when net income was $60,000 and depreciation totaled $30,000. Beginning $39,500 55,000 Ending Cash Accounts receivable Inventory Prepaid rent Accounts payable 91,300 82,000 4,750 40,500 6,400 5,400 43,700 6,000 Nspayable Salaries Print the worksheet when done. Check figure: Cash flow from operating activities, $39,350. CHART (optional) Using the test model data, design a column chart that will show the components of cash flow from operating activities (net income, change in accounts receivable, etc.). Print the chart when done. 169