HOME DEPOT (HD) |
Consensus Forecast of HOME DEPOT Revenue in Millions  |
Jan-08 |
Jan-09 |
Jan-10 |
Jan-11 |
Jan-12 |
12/08 |
| $77,349.00 |
$71,288.00 |
$66,176.00 |
$68,699.73 |
$71,305.34 |
-2.0% |
|
| Consensus Forecast of HOME DEPOT EPS |
Jan-06 |
Jan-07 |
Jan-08 |
Jan-09 |
Jan-10 |
Jan-11 |
Jan-12 |
Jan-13 |
| $2.72 |
$2.83 |
$2.27 |
$1.78 |
$1.66 |
$1.94 |
$2.26 |
$2.71 |
|
EPS FORECASTS
|
This section is designed to find errors as the consensus forecast of EPS. The consensus forecasts for the lines in the HOME DEPOT Income Statement are shown and below each consensus forecast is a wiki section to discuss why the consensus forecast of that item may be high or low
|
|
| Consensus Forecasts of Total Revenue |
| |
Jan-05 |
Jan-06 |
Jan-07 |
Jan-08 |
Jan-09 |
Jan-10 |
Jan-11 |
Jan-12 |
12/05 |
| 1. Total Revenue |
$77,022.0 |
$79,023.2 |
$77,349.1 |
$71,288.0 |
$66,021.3 |
$68,766.1 |
$71,428.2 |
$76,013.7 |
-0.2% |
|
| Discussion by Wiki Users | | The Company expects sales growth of 2.6 % for FY10 with comps expected to increase by 2.0% driven by transactions.
| Last edited Wed Nov 24, 2010 01:08 AM
by BipashaChowdhury (Zacks Investment Research) |  |
| Consensus Forecasts of Fully Diluted Shares Outstanding |
| |
Jan-05 |
Jan-06 |
Jan-07 |
Jan-08 |
Jan-09 |
Jan-10 |
Jan-11 |
Jan-12 |
| Fully Diluted Shares Outstanding |
2147.0 |
2061.9 |
1856.7 |
1685.3 |
1690.6 |
1673.5 |
1617.8 |
1549.0 |
|
| Discussion by Wiki Users |
| | |
| Consensus Forecasts of GAAP EPS |
| |
Jan-05 |
Jan-06 |
Jan-07 |
Jan-08 |
Jan-09 |
Jan-10 |
Jan-11 |
Jan-12 |
| GAAP EPS |
$2.7 |
$2.7 |
$2.3 |
$1.3 |
$1.6 |
$1.9 |
$2.3 |
|
|
| Discussion by Wiki Users | | The Company expects EPS of $1.90 for 2010, which does not include the benefit of the Company’s year-to-date share repurchases, but excludes the impact of future share repurchases.
| Last edited Wed Nov 24, 2010 01:08 AM
by BipashaChowdhury (Zacks Investment Research) | |
| Consensus Forecasts of Cost of Goods Sold |
| |
Jan-05 |
Jan-06 |
Jan-07 |
Jan-08 |
Jan-09 |
Jan-10 |
Jan-11 |
Jan-12 |
| 2. Cost of Goods Sold |
$54,191.0 |
$52,476.3 |
$51,352.1 |
$47,271.7 |
$43,638.7 |
$45,246.4 |
$46,877.9 |
$49,735.0 |
| Percent of Revenue |
70% |
66% |
66% |
66% |
66% |
66% |
66% |
65% |
| 3. Gross Profit (1-2) |
$22,831.00 |
$26,546.90 |
$25,997.00 |
$24,016.30 |
$22,382.60 |
$23,519.70 |
$24,550.30 |
$26,278.70 |
| Percent of Revenue |
30% |
34% |
34% |
34% |
34% |
34% |
34% |
35% |
|
| Consensus Forecasts of Selling, General and Administrative Expense |
| |
Jan-05 |
Jan-06 |
Jan-07 |
Jan-08 |
Jan-09 |
Jan-10 |
Jan-11 |
Jan-12 |
| 4. Selling, General and Administrative Expense |
$16,485.0 |
$16,067.3 |
$17,041.0 |
$16,919.8 |
$15,729.6 |
$16,136.9 |
$16,502.7 |
$17,112.5 |
| Percent of Revenue |
21% |
20% |
22% |
24% |
24% |
23% |
23% |
23% |
|
| Discussion by Wiki Users |
| | |
| Consensus Forecasts of Pre - Tax Income |
| |
Jan-05 |
Jan-06 |
Jan-07 |
Jan-08 |
Jan-09 |
Jan-10 |
Jan-11 |
Jan-12 |
| 7. Pre - Tax Income |
$9,282.0 |
$8,473.9 |
$6,614.0 |
$4,700.5 |
$4,277.2 |
$5,071.0 |
$5,600.1 |
$5,969.5 |
| 8. Tax provisions |
$3,444.0 |
$3,247.2 |
$2,412.2 |
$1,572.3 |
$1,469.0 |
$1,841.3 |
$2,089.9 |
$2,362.3 |
| Percent of Revenue |
37% |
38% |
36% |
33% |
34% |
36% |
37% |
40% |
| 9. Net Income (7-8) |
$5,838.00 |
$5,226.70 |
$4,201.80 |
$3,128.20 |
$2,808.20 |
$3,229.70 |
$3,510.20 |
$3,607.20 |
|
| HD (HOME DEPOT) |
$66,864.00 |
$2,872.00 |
15.4% |
12% |
17.48 |
0.8 |
12.4 |
Industry Mean |
|
|
9% |
14% |
20.15 |
1.0 |
12.0 |
| S&P 500 |
|
|
23% |
11% |
13.71
| 1.9 |
|
|
|
|
|
|
|
|
|
BECN (BEACON ROOFING) |
$1,604.00 |
$37.59 |
8.9% |
14% |
20.15 |
0.6 |
10.9 |
FAST (FASTENAL) |
$1,962.00 |
$191.70 |
16.1% |
20% |
29.76 |
3.7 |
32.8 |
LOW (LOWES COS) |
$47,775.00 |
$1,797.00 |
9.6% |
11% |
16.90 |
0.7 |
10.0 |
CF is operating cash flow plus after-tax interest expense. |
|
| Discussion of Relative Valuation | | No comments yet. Be the first | | |
|
|
| | |
Created by: WikiMigrationBot.
Last Modification: Thursday 03 of June, 2010 07:16:51 CDT by WikiMigrationBot.
|
