Preview

Home Depot Case Analysis Essay

Good Essays
Open Document
Open Document
680 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Home Depot Case Analysis Essay
A. Analyze the implications of interest rate changes the calculations with the attached spreadsheet. Be sure to substantiate your claims.
The future value of Home Depot is simply the principle time value of money that is calculated to estimate the demand for future payments demand over the risk free rate of interest. The rate of discount is nothing but the summation of time value of money as proposed by the appropriate rate of interest. This aims towards increasing the nominal value of future returns.
At 8% rate of risk, the company expressed an ideal future value of negative 425.78 million while the company would ideally prefer a value that is positive and above. This is because the company prefers to get a value that is higher than the expected future value of the company in the time span of 5 years.
…show more content…

When the risk free rate is reduced to 5%, the company comes up to a future value of -460.69 million. This is lower than what is guaranteed at the present value of 8%. Again, at the risk free rate of 15%, the company has a future value of -359.18 million. In such a scenario, the company would ideally prefer a rate of interest that is causing the present value of the company to increase. The higher the risk, the higher is the rate of interest the company will have to serve and this causes a rise in the present value of the company when it lies in the negative field.
B. How might an issue (negative or positive) within the overall stock market impact Home Depot’s stock valuation numbers, other financial variables, or its overall portfolio management? Be sure your response is supported by


You May Also Find These Documents Helpful

  • Better Essays

    The focus of EEC’s investment of the purchasing of the supplier is to cut down on the cost expenditures of the company. The primary board members and investors anticipate in the timeframe the fifth of to save financially in revenue $600,000 per annum this will accumulate $9 million in net in the timeframe of that 15 years. 14% of that investment and consumption cost will be attributed out of $9 million net, which adds up to sum of $3 million. The president of the company asked me to give an analysis in the possibilities foreseen in the investment what would be the Net Present Value, along with the Internal Rate of Return, and the payback of the investment.…

    • 1228 Words
    • 4 Pages
    Better Essays
  • Satisfactory Essays

    Home Depot and its subsidiaries provides excellent customer service for home improvements, lawn products, and building material. The company stocks about $30,000 to $40,000 different types of home improvement supplies and other merchandise. The Consolidated Financial Statement reports the assets, liabilities, expense, and the amount of revenues for the company. In fiscal year 2013, The Home Depot recent quantitative assessment were completed. In tax year 2014, Home Depot completed its’ annual assessment in order to recover the reporting units from the different countries.…

    • 153 Words
    • 1 Page
    Satisfactory Essays
  • Good Essays

    Overall Net Present

    • 621 Words
    • 3 Pages

    The expected Net Present Value of the investment is $89,000. This number, a positive Net Present Value, represents that the future cash inflows at the company’s cost of capital (8%) will cover the cost of the investment. This also increases the value of the company. Should the Net Present Value have been a negative amount, it would represent that the future cash inflows would not cover the cost of the investment. Calculations are listed below:…

    • 621 Words
    • 3 Pages
    Good Essays
  • Better Essays

    Fin221 Preflight

    • 9377 Words
    • 38 Pages

    Which of the following is the actual rate of interest paid or earned over a year's time?…

    • 9377 Words
    • 38 Pages
    Better Essays
  • Satisfactory Essays

    Using Home Depot, Inc. 2008 Annual Report located in Appendix A of the text, Fundamentals of Financial Accounting , prepare a 1,050-1,750-word paper in which you address the following items:…

    • 427 Words
    • 2 Pages
    Satisfactory Essays
  • Best Essays

    The home improvement industry is greatly influenced by the housing market and by various economic factors. In 2008 housing turnover was down 16%, S&P/Case-Shiller US National Home Price Index was down 18.2%, Unemployment up from 4.9% in January 2008 to February 2009, and we witnessed some of the lowest consumer confidence levels on record (Lowe’s, 1008 Annual Report P.2).…

    • 4325 Words
    • 18 Pages
    Best Essays
  • Good Essays

    Home Depot Research Paper

    • 874 Words
    • 4 Pages

    As you can see the stock that we charted for this project was the Home Depot's stock. The Home Depot was founded by two men Bernie Marcus and Arthur Blank. Their original partnership was called MB associates and they officially incorporated on June 29, 1978. They did change their company name obviously to The Home Depot. They opened their first store on June 22, 1979 in Atlanta Georgia. They have been growing ever since then. By the year 1990 they had 145 stores and $3.8 billion in sales. As of today they have 2,045 stores, 355,000 associates, and $81.5 billion in sales. The Home Depot has come a long way in twenty eight years. They have never merged with any company's…

    • 874 Words
    • 4 Pages
    Good Essays
  • Good Essays

    The Home Depot (Ticker: HD) is the world’s largest home-improvement retailer along with being an American Fortune 50 company. The company operates 2,259 retail building supply/home improvement “warehouse” type stores all across the United States, Canada and Mexico. The Home Depot has over 340,000 team members and is based in Atlanta, Georgia. The average store size is just over 100,000 square feet along with an additional 24,000 square feet set aside for seasonal gardening.…

    • 797 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Home Depot Research Paper

    • 1668 Words
    • 7 Pages

    Bernie Marcus and Arthur Blank founded the Home Depot in 1978. Along with investment banker Ken Langone and merchandising expert Pat Farrah, the founder’s vision of one-stop shopping for the do-it-yourselfer became a reality when they opened the first two Home Depot stores on June 22, 1979, in Atlanta, Georgia. The first stores, at around 60,000 square feet each, were enormous warehouses that dwarfed the competition and stocked 25,000 SKUs, much more than the average hardware store at that time. Empty boxes piled high on the shelves gave the illusion of even more product and in only one year they opened a 4th store in Atlanta and the company had annual sales…

    • 1668 Words
    • 7 Pages
    Powerful Essays
  • Good Essays

    Home Depot Research Paper

    • 2133 Words
    • 9 Pages

    Decks, patios, bathrooms you name it, there is no job too difficult when Home Depot is there. Home Depot has helped many troubled individuals accomplish impossible tasks that seem like they can never be done. Home Depot has been around since the late 70's and has only gained more popularity as the years have passed. As one of the leading retailers in the United States, Home Depot is highly respected by the business world, customers, and also by thousands of Home Depot employees working around the world. With all of these employees comes enormous responsibility to maintain quality, sales, and productivity as well as employees motivation throughout…

    • 2133 Words
    • 9 Pages
    Good Essays
  • Powerful Essays

    Selected Questions

    • 2143 Words
    • 9 Pages

    47. A bank has $150 million in 1 year loans earning a fixed rate equal to 4.75%. The assets are funded by $150 million in liabilities that have a cost of 4.25% and a maturity of 3 years. If all interest rates are projected to fall 100 basis points by next year, by how much will the bank’s profits and loan NIM change in year 2? Does this bank face refinancing risk or reinvestment risk? Explain.…

    • 2143 Words
    • 9 Pages
    Powerful Essays
  • Good Essays

    5. (6 points): What are two suggestions that you would give a retailer that caters mostly to men (e.g., The Home Depot, Best Buy) to be better at attracting female shoppers? (Please make sure to expand on what the author proposes, simply repeating what he says will earn you zero points for this question).…

    • 1086 Words
    • 5 Pages
    Good Essays
  • Powerful Essays

    to kill a mocking bird

    • 2000 Words
    • 8 Pages

    Instructions: Multiple Choice Questions: Each of the multiple choice questions or incomplete statements below is followed by suggested answers or completions. Select the one that is best in each case.

Free Response Questions: Respond to the questions in the text boxes provided. In answering questions, you should emphasize the line of reasoning that generated your results; it is not enough to list the results of your analysis. Include correctly labeled diagrams, if useful or required, in explaining your answers. A correctly labeled diagram must have all axes and curves clearly labeled and must show directional changes. Clearly label each part of the answer. Only text that is included in the text boxes will be scored. Diagrams, if required, should be sent to your instructor via e-mail or fax.…

    • 2000 Words
    • 8 Pages
    Powerful Essays
  • Powerful Essays

    References: K. Palepu, 'The Home Depot, Inc. ', the case, Harvard Business School, 1996Palepu, Healy and Bernard. 'Business analysis and valuation ', Third edition, 2004Table 1: Stores Productivity198319841985Sales/Store ($million)Transaction/Store (000)Sales/TransactionSquare Foot/Store (000)Sales/Square Foot13.5446307418313.9460307718014.04673080175Table 2: Financial ratios of Home DepotFinancial RatioFiscal Year198319841985Return on SalesAsset TurnoverReturn on AssetsFinancial LeverageReturn on Equity (%)Gross Margin (%)SGA Expense/Sales (%)Net Interest Expense/Sales (%)Tax Expense/Sales (%)4.03.714.81.724.527.320.8-3.43.32.48.02.419.426.420.6(0.3)2.81.22.22.63.79.725.923.21.20.5Table 3: Comparison of Home Depot to HechingerHome DepotHechingerFiscal Year198319841985198319841985ROE (%)24.519.49.719.118.915.8ROA (%)14.88.02.610.78.97.1ROS (%)4.03.31.25.35.24.8AT3.72.42.22.01.71.5FL1.72.43.71.82.12.2AT: Asset Turnover, FL: Financial Leverage…

    • 2170 Words
    • 7 Pages
    Powerful Essays
  • Good Essays

    Chap7

    • 4514 Words
    • 48 Pages

    Which of the following will not cause times interest earned to drop? Assume no other changes than those listed.…

    • 4514 Words
    • 48 Pages
    Good Essays