Evaluate average revenues per store

Assignment Help Corporate Finance
Reference no: EM1344262

Store driven forecast. The home depot is a leading specialty retailer of hardware and home improvement products and is the second largest retail store chain in 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 store. The following table provides summary data for the home depot.

Home Depot
(amounts in millions except number of stores

........................................2007................2008
Number of Store...... 2234------------- 2274
Sales revenue.................$77349.00----- $74288
Inventory.........................$11731---------- $10673
Capital expenditure net... $3558------------$1847

a. Use the preceding data for The Home Depot to evaluate 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 the Year + 1. Use the data form 2008 to project year + 1 sales revenue, 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 the in Year + 1, Home Depot's sales revenues will grow, but only because it will open new stores.

Reference no: EM1344262

Questions Cloud

Calculate future value of the investment : A grandmother want a plan to finance her new grandchild's college education. She has $62,000 to invest. Search the internet & locate a long-range investment CD, Savings Bond, plan, etc, for the grandmother.
Show what are the different categories of hedge funds : How does the risk of short-term funds differ from the risk of long-term funds and What are the different categories of hedge funds?
Compute the unemployment rate as the us bureau : The nation of Wrexington utilizes the same method to Compute the unemployment rate as the U.S. Bureau of Labor Statistics utilizes. From the data below, Compute Wrexington's unemployment rate.
Prepare journal entries for acquisition : Penny's Concrete acquired 25% of outstanding common stock of Cardinal Inc on January 1, 2005, by paying $1,200,000 for 50,000 shares.
Evaluate average revenues per store : The Home Depot to evaluate average revenues per store, capital spending per new store, and ending inventory per store in 2008
Writing java code by using netbeans : Write a java code using netbeans for the following program. Write a program that asks the user to enter five test scores.
Acquisition talks of acme with jel and dbc : Acme has been in acquisition talks with 2 different European firms. JEL Industries is headquartered in country that is part of European Union while DBC Industries is headquartered in European country that doesn't belong to the Union and doesn't us..
Explain approach of the sherman anti-trust act : The world becomes a single market, some new approach must be developed to control the reach of the corporate oligopolies.
Projecting gross profit - the effects of volume versus pric : Projecting gross profit -  the effects of volume versus price and Suppose you are analyzing a firm that is successfully executing strategy that differentiates its products from those of its competitors.

Reviews

Write a Review

Corporate Finance Questions & Answers

  Explain what indicators would you look at to assess

Explain what indicators would you look at to assess whether your firm's long-term assets were impaired

  Which kind of security would lil john need to sell

Which kind of security would Lil John need to sell to accomplish this, and how much would it have to sell

  Purpose the closing entries for the general journal

Closing entries for general journal - Purpose the closing entries for the general journal or close the revenue and expense columns.

  Prepare a spread sheet model

Prepare a spread sheet model for the client that determines NPV/IRR with and without tax.

  How would you hedge this exposure

How would you hedge this exposure? If you hedge, what is the variance of the pound value of the hedged position?

  Show how an increase in your companys accounts payable

Show how an increase in your company's accounts payable from one period to the next is a means to maintain high cash balances in your company's bank account.

  Determine the price of the stock using dividend

Determine the Price of the stock using dividend discount Model - What should the price of the company's stock be today?

  Describe how coca-cola able to retain most of the profits

Use the five forces framework and your knowledge of the soft drink industry to describe how Coca-Cola and Pepsi are able to retain most of the profits in this industry.

  Determine the expected return of portfolio

Determine the expected return of portfolio on the facts narrated - What is the expected return on a portfolio that is equally invested in the two assets?

  Evaluation of stock price and stock

Calculation of stock price and stock to be allotted with given data - c. How many shares of common stock must be issued at the value computed in part b to eliminate the deficit computed in part a?

  Stock market project

Select five companies for the purpose of tracking the stock market, preparing research on the companies, and preparing company reports.

  Preparation of product cost and analyzing wastage

Preparation of Product Cost and analyzing Wastage, Spoilage and Compute the cost of good units completed and transferred out, spoilage, and ending inventory using the eighted-average method.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd