Prepare a statement of cash flows for Abrahams Manufacturing Company for the year ended January 31. 2018. Interpret your results. Additional Information 1. The only entry in the accumulated depreciation account is for 2018 depreciation. 2. The firm paid $22.000 in common stock dividends during 2018. Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy paste a formula across a row 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 finction. 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. DATA Abrahams Manufacturing Company Balance Sheet: 2017 2018 Cash $89,000 $100,000 Accounts receivable 64.000 70,000 Inventory 112.000 100,000 Prepaid expenses 10,000 Total current assets 275,000 280,000 Gross plant and equipment 238.000 311,000 Accumulated depreciation (40,000) (66.000) Total assets $473.000 $525,000 10.000 Accounts payable Accrued liabilities Total current debt Mortgage payable Preferred stock Common stock Retained earnings Total debt and equity $85.000 68,000 153,000 70,000 0 205,000 45,000 $473.000 $90,000 63,000 153,000 0 120.000 205,000 47,000 $525.000 Abrahams Manufacturing Company Income Statement: Sales Cost of goods sold Gross profit Selling, general, and administrative expenses Depreciation expense Operating income Interest expens Earnings before taxes Taxes Preferred stock dividends Earnings available to common shareholders 2018 $184,000 60,000 S124,000 44,000 26.000 $54,000 4.000 $50,000 16.000 10,000 S24.000 Common stock dividends paid during 2018 $22,000 SOLUTION Abrahams Manufacturing Company Statement of Cash Flows: Cash Flow from Operating Activities Net Income Adjustments Depreciation Increase in accounts receivable Decrease in inventory Increase in account payable Decrease in accrued liabilities Net cash provided by operating activities Cash Flow from Investing Activities Increase in gross fixed assets Cash Flow from Financing Activities Decrease in mortgage payable Increase in preferred stock Preferred stock dividends Common stock dividends Net cash provided by financing activities Net increase in cash Beginning cash Ending cash 1. Start Excel. Download and open the workbook named: Keown_Martin_Petty_Problem_3-13_Start. Important note: All calculations must be shown using cell references. Do NOT enter numerical values in the cells 2. In cell C46, calculate the net income amount. 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. (1 point) 3. In cell B48. input the depreciation expense. 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. (1 point) 4. In cell B49, calculate the increase in accounts receivable. 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. (1 point) 5. In cell B50, calculate the decrease in inventory. 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. (1 point) 6. In cell B51, calculate the increase in account 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. (1 point) 7. In cell B52. calculate the decrease in accrued liabilities. 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. (1 point) 8. In cell C53, input the function SUM to calculate the net cash provided by operating 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. (1 point) 9. 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. (1 point) 10. In cell B57, calculate the decrease in mortgage payable. 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. (1 point) 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. (1 point) 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. (1 point) 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. (1 point) 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. (1 point) 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. (1 point) 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. (1 point) 18. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed