Problem 2

See the Excel spreadsheet Problem Set 7 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:
   1. Negative because cash is consumed and to pay for the working capital increase
   2. Positive because cash is released due to the increase in working capital
   3. An imaginary number
   4. Who really knows ??

1. The Net Operating Cash Flow (NOCF) from Operating Activities is:
   1. $939,000
   2. ($939,000)
   3. $739,000
   4. ($739,000)

1. Did the business use cash to purchase capital (equipment etc) in 2010 ?
   1. Yes because the net assets increased from 2009 to 2010 and there was also depreciation
   2. No because the net assets increased from 2009 to 2010 and there was also depreciation
   3. It is not possible to determine this

1. 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:
   1. A positive term to indicate cash flowed back into the businesss from the sale
   2. A negative term to indicate cash flowed back into the business from the sale
   3. It all depends on the marginal tax rate
   4. None of the above

1. What was the change in short term borrowings ?
   1. An increase of $1,530,000
   2. An increase of $2,530,00
   3. An increase of $550,000
   4. An increase of $750,000
   5. None of the above

1. The reason why this term is positive in the Cash Flow statement is that:
   1. The business borrowed the cash bringing cash into it
   2. The business bought back stock
   3. The business paid a dividend
   4. The business went bankrupt

1. What was the closing cash position of the business at the end of 2010 ?
   1. It decreased to $330,000
   2. It increased to $530,000
   3. It decreased to $200,000
   4. It increased to $330,000

1. 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 ?
   1. You are not concerned at all
   2. You are pleased that the cash flow from the operating activity of the business is positive before accounting 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.

Problem 2 See the Excel spreadsheet Problem Set 7 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: 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: Negative because cash is consumed and to pay for the working capital increase Positive because cash is released due to the increase in working capital An imaginary number Who really knows ?? The Net Operating Cash Flow (NOCF) from Operating Activities is: $939,000 ($939,000) $739,000 ($739,000) Did the business use cash to purchase capital (equipment etc) in 2010 ? Yes because the net assets increased from 2009 to 2010 and there was also depreciation No because the net assets increased from 2009 to 2010 and there was also depreciation It is not possible to determine this 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 positive term to indicate cash flowed back into the businesss from the sale A negative term to indicate cash flowed back into the business from the sale It all depends on the marginal tax rate None of the above What was the change in short term borrowings ? An increase of $1,530,000 An increase of $2,530,00 An increase of $550,000 An increase of $750,000 None of the above The reason why this term is positive in the Cash Flow statement is that: The business borrowed the cash bringing cash into it The business bought back stock The business paid a dividend The business went bankrupt What was the closing cash position of the business at the end of 2010 ? It decreased to $330,000 It increased to $530,000 It decreased to $200,000 It increased to $330,000 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 ? You are not concerned at all You are pleased that the cash flow from the operating activity of the business is positive before accounting 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