close
How does this work?
A valuation is an assessment of the value of one share in a company, it is not necessarily the same as the price listed in the sharemarket. You can use a variety of methods to value a company, Valuecruncher uses Discounted Cash Flow (DCF) analysis to help people create the valuations you see below.
Valuecruncher Valuation
41.66%
from latest share price
Your Last Valuation
| Valuation | Compared to price | Member |
 Created
|
Views |
|---|---|---|---|---|
| $34.55 |
41.66%
|
Valuecruncher | 09 Jan 2009 | 0 |
| $24.00 |
8.35%
|
TheCrunchBlog | 07 Nov 2008 | 125 |
| $31.64 |
19.17%
|
contrarian | 19 Jun 2008 | 40 |
Price History
Recent Comments
Company Details
| Updated: | 3 hours ago |
| Ticker: | HD |
| Market: | NYSE |
This valuation is part of this blog post:
http://blog.valuecruncher.com/2008/11/running-the-numbers-intrinsic-valuation-of-home-depot-hd/
Assumptions
Revenue: Reuters aggregates 17 analysts covering $HD and these analysts have mean estimates of 2009 and 2010 revenues of US$72.4 billion and US$73.0 billion respectively. For our analysis we have used US$72.5 billion in 2009, US$73.0 billion in 2010 and US$75.0 billion in 2011.
Profitability: We have used an EBITDA margin of 9.5% in 2009 rising to 10.5% in 2011. Reuters has $HD‘s EBITD margin at 10.1% last year and averaging 12.8% over the last five-years.
Capital Expenditure: We have assumed capital expenditures of US$2.25 billion in 2009 and 2010 then US$2.50 billion per annum moving forward.
Discount Rate: 9.0%.
Terminal Growth Rate: 2.5%.