REQUIRED a. Use the preceding data for The Home Depot to compute average revenues per store, capital spending per new store, and ending inventory per store in 2015. b. Assume that The Home Depot will add 10 new stores by the end of Year +1. Use the data from 2015 to project Year +1 sales revenues, capital spending, and ending inven- tory. 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 sales revenues will grow, but only because it will open new stores.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Topic Video
Question
Please answer question 10.9 from Accounting textbook “Financial Reporting, Financial Statement Analysis and Valuation”. The instructions can be found in the (2) pictures I attached.
Problems and Cases
10.9 Store-Driven Forecasts. The 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. In 2014 and 2015, The Home Depot invested in five
new stores. The following table provides summary hypothetical data for The Home Depot.
The Home Depot (amounts in
millions except number of stores)
2014
2015
Number of stores
2,269
2,274
Sales revenues
$83,176
$88,519
Inventory
$11,079
$11,809
Capital Expenditures, net
$ 1,442
$ 1,503
Transcribed Image Text:Problems and Cases 10.9 Store-Driven Forecasts. The 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. In 2014 and 2015, The Home Depot invested in five new stores. The following table provides summary hypothetical data for The Home Depot. The Home Depot (amounts in millions except number of stores) 2014 2015 Number of stores 2,269 2,274 Sales revenues $83,176 $88,519 Inventory $11,079 $11,809 Capital Expenditures, net $ 1,442 $ 1,503
Questions, Exercises, Problems, and Cases
REQUIRED
a. Use the preceding data for The Home Depot to compute average revenues per store,
capital spending per new store, and ending inventory per store in 2015.
b. Assume that The Home Depot will add 10 new stores by the end of Year +1. Use the
data from 2015 to project Year +1 sales revenues, capital spending, and ending inven-
tory. 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 sales revenues will
grow, but only because it will open new stores.
Transcribed Image Text:Questions, Exercises, Problems, and Cases REQUIRED a. Use the preceding data for The Home Depot to compute average revenues per store, capital spending per new store, and ending inventory per store in 2015. b. Assume that The Home Depot will add 10 new stores by the end of Year +1. Use the data from 2015 to project Year +1 sales revenues, capital spending, and ending inven- tory. 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 sales revenues will grow, but only because it will open new stores.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Accounting Equation
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education