Copy the Mike Owjai Manufacturing financial statements from Problem 1 in Chapter 2 into a new workbook.

Question:

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 131, 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 11%.
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?
Financial Statements
Financial statements are the standardized formats to present the financial information related to a business or an organization for its users. Financial statements contain the historical information as well as current period’s financial...
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Financial Analysis with Microsoft Excel

ISBN: 978-1285432274

7th edition

Authors: Timothy R. Mayes, Todd M. Shank

Question Posted: