Please complete and submit steps 7–8 of the Financial Analysis Report
Richierich49
CopyofStep8WorksheetUnit3.2RatioAnalysisTargetWalMart.xlsxSheet1
| Name: | Unit 3 Assignment 2 | ||||
| Financial Analysis Wal-Mart vs. Target: The Basis for your Ongoing Analysis (Step 8 to support Step 9) | |||||
| Financial diagnostic categories | Ratio | WalMart | Target | Commentary, which company is 'better' and why | Be sure to use the worksheet with the formulas |
| 1.) Liquidity Management | -Current ratio | Notes here: | ca/cl | ||
| -Cash ratio | cash/CL | ||||
| -Quick ratio | (ca -inv)/cl | ||||
| 2.) Debt Management | Debt/Assets | Notes here: | d/a | ||
| Debt/Equity | d/e | ||||
| EBIT/Interest | ebit/interest | ||||
| 3.) Profitability | Profit Margin | Notes here: | ni/s | ||
| Return on Assets | ni/a | ||||
| Return on Equity | ni/e | ||||
| 4.) Asset Management | Total asset turnover | Notes here: | s/ta | ||
| Inventory turnover | cogs/inv | ||||
| A/Receivable turnover | s/ar | ||||
| 5.) Market Value | Price/Earnings ratio | Notes here: | yahoo finance | ||
| Earnings per Share | |||||
