Home Depot is a leading specialty retailer of hardware and home improvement products and is the second-largest retail store chain in the United States. It operates large, warehouse style
stores. The following table provides summary data for Home Depot in Years 4 and 5.

Required
a. Use the preceding data for Home Depot to compute average revenues per store, capital spending per new store, and ending inventory per store in Year 5.
b. Assume that Home Depot will add 200 new stores by the end of Year +1 and assume that each new store will be open for business for an average of one-half year in Year +1. For simplicity, assume that in Year +1 Home Depot's only growth will come from opening new stores. Project Year +1 sales revenues, capital spending, and ending inventory.

Transcribed Image Text:

Home Depot (amounts in millions except number of stores) Year 4 Year 5 Number of Stores Sales Revenues Inventory Capital Expenditures, net 1,707 ....$64,816 1,890 $73,094