Question
Evaluating Turnover and Nontraditional Efficiency Ratios Across Industries The following information is taken from publicly traded retailers. The data come from the balance sheet, income
Evaluating Turnover and Nontraditional Efficiency Ratios Across Industries The following information is taken from publicly traded retailers. The data come from the balance sheet, income statement, and Item 2 on the companies Form 10K filings. Use the information to answer the requirements.
Average | Retail SQ | # of | |||
---|---|---|---|---|---|
$ millions | Revenue | COGS | Inventory | Footage (000s) | Stores |
Autozone | $11,782 | $4,902 | $4,109 | 41,066 | 6,202 |
Costco | 148,655 | 121,715 | 10,959 | 110,700 | 762 |
Home Depot | 113,613 | 71,043 | 14,004 | 237,700 | 2,287 |
Lowes | 74,874 | 48,396 | 12,576 | 209,000 | 2,015 |
OReilly | 10,013 | 4,237 | 3,257 | 38,455 | 5,219 |
Walmart | 537,315 | 374,623 | 46,227 | 1,129,000 | 11,361 |
Required a. Compute the days inventory outstanding (DIO) for each company. Note: Do not round until your final answer; round your final answer to the nearest whole day.
DIO | ||
---|---|---|
AUTOZONE | Answer
| days |
COSTCO | Answer
| days |
HOME DEPOT | Answer
| days |
LOWE'S | Answer
| days |
O'REILLY | Answer
| days |
WALMART | Answer
| days |
b. Compute the gross profit margin for each company. Note: Round percentage to one decimal place (for example, enter 6.7% for 6.6555%).
DIO | |
---|---|
AUTOZONE | Answer
|
COSTCO | Answer
|
HOME DEPOT | Answer
|
LOWE'S | Answer
|
O'REILLY | Answer
|
WALMART | Answer
|
c. Compute the following two nontraditional efficiency metrics: Revenue per square foot and Revenue per store. Note: Round your answers to two decimal places (for example, enter 6.78 for 6.77555).
Revenue per SF | Revenue per store | |
---|---|---|
AUTOZONE | Answer
| Answer
|
COSTCO | Answer
| Answer
|
HOME DEPOT | Answer
| Answer
|
LOWE'S | Answer
| Answer
|
O'REILLY | Answer
| Answer
|
WALMART | Answer
| Answer
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started