needs to follow this sheet:

M14' CASH FLOW FROM OPERATING ACTIVITIES Shanna Company reported a net income of $105,000 for the current year. Depreciation recorded for the year totaled $38,000. Current asset and liability accounts had the following balances at the beginning and end of the year Cash Accounts receivable Inventory Prepaid rent Accounts payable Salaries payable Ending $39,500 55,000 69,800 5,400 43,700 6,000 Beginning $41,300 48,800 75,000 6,000 54,100 8,400 The president of Shanna Company has asked you to develop a worksheet that will compute cash flow 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. Ending $33,000 91,300 82,000 4,750 40,500 6,400 Beginning $39,500 Cash Accounts receivable Inventory Prepaid rent Accounts payable Notes-payable Salaries 69,800 5,400 43,700 6,000 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