Financial Analysis using Excel EFE Matrix Template

Visit one of the following online resources:
Yahoo Finance
D&B Hoovers
Global Edge (By Industry) or (visit the company’s website)
Calculate the following ratios for Dick’s Sporting Goods
Liquidity Ratios:
Current Ratio
Quick Ratio
Leverage Ratios
Debt-to-Total-Assets Ratio
Debt-to-Equity Ratio
Long-Term Debt-to-Equity Ratio
Times-Interest-Earned Ratio
Activity Ratios
Inventory Turnover
Fixed Assets Turnover
Accounts Receivable Turnover
Average Collection Period
Profitability Ratios
Gross Profit Margin
Operating Profit Margin
Return on Total Assets
Return on Stockholders’ Equity
Earnings Per Share
Price-Earnings Ratio
What do ratios calculated communicate about the financial strengths and weaknesses of Dick’s Sporting Goods?
Based on your calculations, would you invest in Dick’s Sporting Goods, why or why not?