Keown_Martin_Petty. Problem 3-13 [Excel]. v1 Project Description: In this problem. you will prepare a statement of cash ows. Steps to Perform: Step Instructions Eomplete the steps below using cell references to given data or previous calculations. In some cases. a simple cell reference is all you need. To copytpaste a formula across a rowr or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used. the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead. make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases. unless otherwise directed. use the earliest appearance of the data in your formulas. usually the Given Data section. Start Excel. Download and open the workbook named: Keown_hlartin_Petty_Problem_3 13_tart. Important note: All calculations must be shown using cell references. Do MDT enter numeiical values in the cells. In cell C45. calculate the net income amount. Note: The output ofthe expression or function you typed in this cell is expected as a positive number in case of cash inow and as a negative number in case of cash outow. In cell 348. input the depreciation expense. Note: The output ofthe expression or function you typed in this cell is expected as a positive number in case of cash inow and as a negative number in case of cash outow. In cell 349. calculate the increase in accounts receivable. Note: The output ofthe expression or function you typed in this cell is expected as a positive number in case of cash inow and as a negative number in case of cash outow. In cell 3512]. calculate the decrease in inventory. Note: The output ofthe expression or function you typed in this cell is expected as a positive number in case of cash inow and as a negative number in case of cash outow. In cell 351. calculate the increase in account payable. Note: The output ofthe expression or function you typed in this cell is expected as a positive number in case of cash inow and as a negative number in case of cash outow. In cell 352. calculate the decrease in accrued liabilities. Note: The output ofthe expression or function you typed in this cell is expected as a positive number in case of cash inow and as a negative number in case of cash outow. In cell C53. input the function SLIM to calculate the net cash provided by operating activities. Note: The output ofthe expression or function you typed in this cell is expected as a positive number in case of cash inow and as a negative number in case of cash outow. Points Possible Step Instructions Points Possible g In cell C55, calculate the increase in gross fixed assets. Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow. 10 In cell B57, calculate the decrease in mortgage payable. Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow. 11 In cell B58, calculate the increase in preferred stock. Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow. 12 In cell B59, input the preferred stock dividends. Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow. 13 In cell B60, input the common stock dividends. Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow. 14 In cell C61, input the function SUM to calculate the net cash provided by financing activities. Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow. 15 In cell C62, calculate the net increase in cash. Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow. 16 In cell C63, input the beginning cash. Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow. 17 In cell C64, calculate the ending cash. Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow. 18 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as 0 directed. Total Points 16