Attachment # 00000319 - act_fin_stmt_forecasting_10-9.docx
act_fin_stmt_forecasting_10-9.docx (234.82 KB)
Raw Preview of Attachment:
(refer to the detailed question and attachment below)
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. Despite declining sales and difficult economic conditions in 2007 and 2008, The Home Depot continued to invest in new stores. The following table provides summary data for The Home Depot.Requireda. 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 2008.b. Assume that The Home Depot will add 100 new stores by the end of Year +1. Use the data from 2008 to project Year +1 sales revenues, capital spending, and ending inventory. 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 Statement Forecasting: The Home Depot

Question # 00001735 Posted By: alegbra Updated on: 09/28/2013 04:50 PM Due on: 09/30/2013
Subject Finance Topic Finance Tutorials:
Question
Dot Image
Financial Statement Forecasting: 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. Despite declining sales and difficult economic conditions in 2007 and 2008, The Home Depot continued to invest in new stores. The following table provides summary data for The Home Depot (see attached).

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 2008.

b. Assume that The Home Depot will add 100 new stores by the end of Year +1.
Use the data from 2008 to project Year +1 sales revenues, capital spending, and ending inventory. 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.
Dot Image
Tutorials for this Question
  1. Tutorial # 00001571 Posted By: neil2103 Posted on: 09/28/2013 04:52 PM
    Puchased By: 2
    Tutorial Preview
    The solution of Financial Statement Forecasting: The Home Depot...
    Attachments
    financial_statement_forecasting-_the_home_depot.xlsx (10.03 KB)
Whatsapp Lisa