SAB Technology Corporation increased its sales from $400,000 in 2012 to $500,000 in year 2013 as is shown in the firm’s income statements presented below. Jenny Sands, chief executive officer (CEO) and founder of the firm expressed concern that the cash account and the firm’s marketable securities declined substantially between 2012 and 2013. SAB's complete balance sheets are also shown below. Ms. Sands is seeking your assistance in the preparation of a statement of cash flows for SAB Financial Statements 1 Income statement (in $ Thousands) 2013 2012 2 3 Net sales 500.00 400.00 4 Less: cogs 300.00 240.00 5 Gross profit 200.00 160.00 6 Less: operating exp 46.00 46.00 7 Less: Depr 30.00 25.00 8 EBIT 124.00 89.00 9 Less: Interest 38.50 33.50 10 Income before tax 85.50 55.50 11 Less: Income taxes 30.00 20.00 12 Net income 55.50 35.50 13 14 Cash dividend 20.00 17.00 15 Addition to retained earnings 35.50 18.50 16 17 18 Balance sheet (in $ Thousands) 2013 2012 19 20 Cash 16.00 39.00 21 Account receivable 80.00 50.00 22 Inventories 204.00 151.00 23 Current asset 300.00 240.00 24 Gross fixed asset 290.00 200.00 25 less: accumuled depr 125.00 95.00 26 Net fixed asset 165.00 105.00 27 Total assets 465.00 345.00 28 29 Account payable 45.00 30.00 30 Accrued liabilities 23.00 10.00 31 Short-term notes 27.00 20.00 32 Total current liabilities 95.00 60.00 33 Long-term debt 20.00 15.00 34 Total liabilities 115.00 75.00 35 Common stock 129.50 85.00 36 Retained earnings 220.50 185.00 37 Owners' equity 350.00 270.00 38 Total liabilities and equity 465.00 345.00

1) Study the excel template _efu_homework2_excel. xlsxPreview the document
2) Cash flow analysis for year 2013 cash flows from operating activities = ?? cash flow from investment activities = ?? cash flow from financing activities = ?? net cash flow = ?? cash at the end of period = ??
3) Cash flow identity for year 2013 Operating cash flow = EBIT + D&A - Tax = ?? Change in Net Operating Working Capital = Change in NOWC = ?? Net Capital Spending = ?? Cash flow from assets = ?? Cash flow to creditors = ?? Cash flow to Shareholders = ??