Question: The following information is taken from publicly traded retailers. The data comes from the balance sheet, income statement, and Item 2 on the companies'

The following information is taken from publicly traded retailers. The data comes

The following information is taken from publicly traded retailers. The data comes from the balance sheet, income statement, and Item 2 on the companies' Form 10-K filings. Use the information to answer the requirements. Retail SQ footage Company Revenue (Millions) COGS Average Inventory (000s) Number of Stores 4,902 $ 121,715 $ Autozone (AZO) 11,221 $ 3,913 $ 41,066 $ 6,202 Costco (COST) 151,576 $ 10,437 $ 110,700 $ 762 Home Depot (HD) 108,203 $ 71,043 $ 13,337 $ 237,700 $ 2,287 209,000 $ Lowe's (LOW) O'Reilly (ORLY) 71,309 $ 48,396 $ 11,977 $ 2,015 9,536 $ 4,237 $ 3,102 $ 38,455 $ 5,219 Walmart (WMT) 511,729 $ 374,623 $ 44,026 $ 1,129,000 $ 11,361 a. Compute the days inventory outstanding (DIO) for each company b. Compute the gross profit margin for each company c. Compare the DIO and gross profit margin for each of the three combinations of competitors. What do we observe? How are the two ratios related? d. Compute the following two nontraditional efficiency metrics: Revenue per square foot and Revenue per store. What do we observe? Company COGS Average Inventory Inventory Turnover DIO

Step by Step Solution

★★★★★

3.61 Rating (158 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Revenue Company Millions Autozone AZO 11221 Costco COST 151576 Home Depot HD 108203 Lowes LOW 713091 ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Sales per square foot for the dress department of a chain store average $260 annually. If the annual sales for this department in a new store unit are planned at $260,000 what amount of space should...

Sales per square foot for the dress department of a chain store average $260 annually. If the annual sales for this department in a new store unit are planned at $260,000, what amount of space should...

Use the following spreadsheet to answer question 4 6: A B C D E F G H I This Year Last Year Percent Change Occupancy ADR Rev APR Occupancy ADR Rev APR Occupancy ADR Rev APR 1 Jan 75.65% 84.76 64.12...

The information below was taken from the balance sheet of Cohort Enterprises as of December 31, 2012: (a) Compute the effective interest rate when the bonds were issued.(b) What effective rate would...

The following financial information represents Hadley Company's first year of operations, 2011: After reading Hadley's financial statements, you conclude that the company had a very successful first...

From the following data, taken from the balance sheet of Petey's Widget Factory, determine the working capital, current ratio, and acid-test ratio.

Lundy Manufacturing produces and sells football equipment. The company was involved in the following transactions or events during 2012: 1. The company purchased $250,000 worth of materials to be...

Using Financial Reports: Evaluating Financial Information as a Bank Loan Officer Stoscheck Moving Corporation has been in operation since January 1, 2012. It is now December 31, 2012, the end of the...

As a recently hired accountant for a small business, Bearing, Inc., you are provided with last year's balance sheet, income statement, and post-closing trial balance to familiarize yourself with the...

Effect of deferrals on financial statements: three separate single-cycle examples Required a. On February 1, 2010, Moore, Inc., was formed when it received $70,000 cash from the issue of common...

Megah Corporation is evaluating cash dividend versus share repurchase. Companies have RM 9,000 extra cash, current earning price (EPS) is RM46 per share and the stock currently sells form RM1.30 per...

Equity Investments Co Ltds constitution provides that Equity Investments Co Ltd will own and operate an equity securities investment business. It also provides Equity Investments Co Ltd will not own...

2 Zara wants to give a questionnaire to 100 people who travel on a bus route. a Describe an advantage of this method. Describe b Describe two disadvantages of this method. Describe C Describe a...

As soon as the debtor files for Chapter 11, the debtor (CAN/CANOT) delay interest and principal payments until the reorganization plan is approved and use the cash generated from operations to...

Cellar Ltd is in the business of bottling wine, particularly for small wineries that cannot afford sophisticated technical equipment and prefer to concentrate on the growing of the grapes. The white...

A load of 10 kN is to be rest with the help of steel wire. Find the minimum diameter of steel wire if stresses is not to exceed 100 MPa.

Translate the following propositions into standard form. After you have done so, indicate whether the form is A, E, I, or O. 1. Every penguin is carnivorous. 2. Many people drive cars

CASE 14 CONSOLIDATED WEEDCUTTERS Part Number Made from Part Number Quantity per 100 301 2. 302 2 150 302 1 Consolidated Weedcutters Inc. makes two models of cutters, the standard (part number 100),...

i need help with an cash flow statment and a statement of owners equity please! i have the balance sheet and an income statment. what else can i give to help? here is all the info that i put into a...

Pillows Ltd. makes decorative throw pillows for home use. The following information was taken from the The following information was taken from the Pillows Lid. direct materials budget: Pillows Lid....

KWVN - TV complebed ths folowng transefions: (Gick on the ioon to view the iraneactions) Read the trgainments. Requirement 1. Record the transactions in the general journal. (Recond debts fint then...

If a company uses a periodic inventory system , which of the following entry or entries is/are required to record the sale of merchandise on account? I Debit Accounts Receivable; Credit Sales Revenue...

The following information was taken from the books of ACDC Traders for April and May 2020. List of balances in the debtor's ledger of ACDC Traders as of 30 April 2020 The following information...