Problem:
Using the following ratios, calculate and/or state Dillards and Nordstroms solvency, liquidity, and profitability:
Current ratio
Return on sales
Earnings per share (EPS)
Debt ratio
Price earnings ratio
Could you put this info in MS Excel? Below is what I had come up with on my research. Please help. Thanks.
Nordstroms
(EPS) YTD as of 8/12/03 Basic 0.69 Diluted 0.68
Debt/Captial ratio 0.4955
Dillards
(EPS) YTD as of 8/2/03 Basic 0.60 Diluted 0.60
Current ratio as of 8/2/03 0.63