CHAPTER 4: Financial Statement Analysis Tools Problems 1. Copy the Mike Owjai Manufacturing financial statements from Problem 1 in Chapter 2 into a new workbook a. Set up a ratio worksheet similar to the one in Exhibit 4-6, page 13 and calculate all of the ratios for Mike Owjai Manufacturing. b. Identify at least two areas of potential concern using the ratios Identify at least two areas that have shown improvement. c. In 2014 Mike Owjai Manufacturing's ROE increased. Explain, in words, why this increase occurred using the DuPont method from equation (4-29). Now use the extended DuPont method from (4-33) d. Mike Owjai Manufacturing has shown an accounting profit in each of the past two years. Calculate the economic profit for these years and compare it to net income. The WACC is 1 196. e. Using Altman's model for privately held firms, calculate the Z-score for Mike Owjai Manufacturing. Does it appear that the firm is in imminent danger of bankruptcy? L. Using the data presented belo a Recreate the inome ment and balance shoet sing formulas b. On another woekhoct, crcae a statcment of cash flows for 2014 Do d. Suppose that sales were $2.850,000 what is 14 father than $2.625,000. 2014 t-core and retained eamings? ch.ges bun part d, and change the tax rate to 40%, what e. Undo CHAPTER 4: Financial Statement Analysis Tools Problems 1. Copy the Mike Owjai Manufacturing financial statements from Problem 1 in Chapter 2 into a new workbook a. Set up a ratio worksheet similar to the one in Exhibit 4-6, page 13 and calculate all of the ratios for Mike Owjai Manufacturing. b. Identify at least two areas of potential concern using the ratios Identify at least two areas that have shown improvement. c. In 2014 Mike Owjai Manufacturing's ROE increased. Explain, in words, why this increase occurred using the DuPont method from equation (4-29). Now use the extended DuPont method from (4-33) d. Mike Owjai Manufacturing has shown an accounting profit in each of the past two years. Calculate the economic profit for these years and compare it to net income. The WACC is 1 196. e. Using Altman's model for privately held firms, calculate the Z-score for Mike Owjai Manufacturing. Does it appear that the firm is in imminent danger of bankruptcy? L. Using the data presented belo a Recreate the inome ment and balance shoet sing formulas b. On another woekhoct, crcae a statcment of cash flows for 2014 Do d. Suppose that sales were $2.850,000 what is 14 father than $2.625,000. 2014 t-core and retained eamings? ch.ges bun part d, and change the tax rate to 40%, what e. Undo