Assignment dealing with the Dupont Ratio Analysis of a company. I need the following information answered based on the company financial information attached in the excel document:
- Calculate the DuPont ratio for the most recent year - calculate profit margin, total asset turnover and equity multiplier and return on equity. Show all of your work
- What are the sources of ROE for this company
- Is ROE high or low because profit margins are high or low? Or, because asset turnover or financial leverage are high or low?
- Calculate the P/E and market/book value ratios for your company. For market/book, you should use the price, earnings and number of shares as of your company's most recent annual report (10K).
- What does your company's PE and market/book ratio (also called price/book ratio) say about your company
How does your company's P/E and market to book ratio compare to the industry? What implications does this have for your company's growth potential?
Attachment:- OXY.xlsx.xlsx