See the Excel spreadsheet and the tab labeled Income Statement. Using this information along with the Balance Sheet/Managerial Balance Sheet you prepared, complete the Cash Flow Statement in the tab labeled Cash Flow Statement.

Use your constructed Cash Flow Statement to answer the following questions:

1:When the Working Capital increases from year-end 2009 to year-end 2010 , the cash flow term in the Operating Activities section of the Cash Flow Statement is:

a)Negative because cash is consumed and to pay for the working capital increase

b)Positive because cash is released due to the increase in working capital

c)An imaginary number

d)Who really knows ??

2:The Net Operating Cash Flow (NOCF) from Operating Activities is:

a)$939,000

b)($939,000)

c)$739,000

d)($739,000)

3:Did the business use cash to purchase capital (equipment etc) in 2010 ?

a)Yes because the net assets increased from 2009 to 2010 and there was also depreciation

b)No because the net assets increased from 2009 to 2010 and there was also depreciation

c)It is not possible to determine this

4:When a business sells a capital asset (for example, they sell one of the chemical plants they own), it makes the capital expenditure term in the Cash Flow from Investing Activities be:

a)A positive term to indicate cash flowed back into the businesss from the sale

b)A negative term to indicate cash flowed back into the business from the sale

c)It all depends on the marginal tax rate

d)None of the above

5:What was the change in short term borrowings ?

a)An increase of $1,530,000

b)An increase of $2,530,00

c)An increase of $550,000

d)An increase of $750,000

e)None of the above

6:The reason why this term is positive in the Cash Flow statement is that:

a)The business borrowed the cash bringing cash into it

b)The business bought back stock

c)The business paid a dividend

d)The business went bankrupt

7:What was the closing cash position of the business at the end of 2010 ?

a)It decreased to $330,000

b)It increased to $530,000

c)It decreased to $200,000

d)It increased to $330,000

8:It appears the business increased its working capital and also closed the year with a small decrease in its cash position. Which statement might best summarize your concern about the business based on looking at the Managerial Balance Sheet and the Cash Flow Statement ?

a)You are not concerned at all

b)You are pleased that the cash flow from the operating activity of the business is positive beforeaccounting for the change in working capital but wondering why the working capital increased so much

c)You are pleased that the cash flow from the operating activity of the business is positive before the change in working capital but wondering why the working capital increased so much along with whether there are plans to reduce it in the future. And you also want to know how convinced the business they will make money on the additional capital they spent during 2010.

alanceSheet thousands) 31-Dec-09 31-Dec-10 385 3, 310 3, 500 $330 4, 720 4, 800 as Accounts Receiveable Inventories Prepaid Expenses Net fixed assets Total Assets 595 $11,445 $8, 625 Short-term debt Accounts payable Accrued expenses Long term debt Owner s equity Total Liabilities and ovner' s eqity $8, 625 $570 1, 760 286 1, 180 $2, 100 2255 385 1370 $11,445 Note: The company did not sell any fixed assets in 2010