DQuestion 4 5 pts J-test Given the financial statement, calculate the Cash flow identity. You can use the excel template included excel template to calculate. fmu test1 excel.xisx Report the results for year 2013 as follows: Operating Cash Flow= ?? Net Capital Spending = ?? Change in NOWC ?? Cash Flow from Asset (CFFA) = ?? Cash Flow to Creditors (CFCR) ?? Cash Flow to Shareholders (CFSH) ?? Hints: 1) You need to include the answer to each item to get full credit. 2) At the end of the calculation, you should achieve Cash flow identity, CFFA CFCR CFSH. Income statement (in $ Thousands) 1 2012 2013 2 1 Income statement (in $ Thousands) 2012 2013 2 3 500.00 600.00 Net sales Less: cogs 300.00 360.00 4 Gross profit 200.00 240.00 5 Less: operating exp 75.00 80.00 6 25.00 30.00 7 Less: Depr EBIT 100.00 130.00 Less: Interest 33.50 38.50 10 Income before tax 66.50 91.50 Less: Income taxes 20.00 30.00 11 12 Net income 61.50 46.50 13 Cash dividend 14 17.00 20.00 15 Addition to retained earnings 29.50 41.50 16 17 18 Balance sheet (in $ Thousands) 2012 2013 19 Cash 20 39.00 16.00 21 Account receivable 50.00 80.00 22 Inventories 151.00 204.00 23 Current asset 240.00 300.00 24 Gross fixed asset 200.00 290.00 95.00 125.00 25 less: accumuled depr 26 Net fixed asset 105.00 165.00 27 345.00 465.00 Total assets 28 45.00 29 Account payable 30.00 10.00 30 Accrued liabilities 23.00 31 Short-term notes 20.00 27.00 32 Total current liabilities 60.00 95.00 Long-term debt 33 15.00 20.00 20 Cash 39.00 16.00 21 Account receivable 50.00 80.00 Inventories 22 151.00 204.00 23 Current asset 240.00 300.00 Gross fixed asset 290.00 24 200.00 less: accumuled depr 25 95.00 125.00 Net fixed asset 26 105.00 165.00 Total assets 27 345.00 465.00 28 29 Account payable 30.00 45.00 30 Accrued liabilities 10.00 23.00 Short-term notes 27.00 31 20.00 32 Total current liabilities 60.00 95.00 33 Long-term debt 15.00 20.00 34 Total liabilities 75.00 115.00 Common stock 35 85.00 123.50 Retained earnings 36 185.00 226.50 37 Owners' equity 350.00 270.00 Total liabilities and equity 38 345.00 465.00