You've help someone with this question before on about 6 months ago.
I need to submit a 3-5 page word document comparing and contrasting the company ratios to one another and the industry. Make a determination of which company is in a better financial situation as part of your conclusion. Also discuss how each company compares to the industry averages.
Here is the question
Refer to the financial statements of American Eagle (Appendix B) and Urban Outfitters (Appendix C) and the Industry Ratio Report (Appendix D) at the end of this book. Compute the following ratios for the most recent reporting year for which you have available information: return on equity, earnings per share, profit margin, current ratio, inventory turnover, debt/equity ratio, price/earnings ratio, and dividend yield. Assume the stock price is $28 for Urban Outfitters and $15 for American Eagle. Compare the ratios for each company to the industry average ratios.
I would an excel sheet that is not read only because I would like to view the formulas.
return on equity
earnings per share