Home Depot
Team Project #1
Home Depot, Inc. in the New Millennium
(HBS 9-101-117)
Question 1. Assess Home Depot’s financial performance from 1986 to 1999. What explains the decline in performance in 2000? (See Question #1 Exhibit)
The slowing economy in 2000 combined with Home Depot’s aggressive expansion efforts was the reason for Home Depot’s poor financial performance. Between June 1999 and May 2000, the FED had raised interest rates six times – or a total of 1.75 percentage points – in an effort to slow the economy and economists had been noticing some softening of overall consumer demand.
From Exhibit 4 we see an average increase in sq. footage of 26% per year for period 1986 – 2000 while average sales growth fall from an average over the same time period of 31% to 19% in 2000. In addition Exhibit 4 shows there was a drop in sales per square footage from $423 in 1999 to $415 in 2000 and a drop in weekly sales per store from $876,000 in 1999 to $826,000 in 2000.
An additional calculation derived from Exhibit 4 is the average number of customer transactions per store per year which had been on the steady increase from 1986 to 1996. However, the number of transactions dropped from 906,250 in 1996 to 881,410 in 1997 to 873,850 in 1998 to 856,989 in 1999, and finally down to 826,279 in 2000. Home Depot faced declining performance in 2000 from cannibalization of sales due to over expansion and market saturation. Resulting sales drops were also magnified by the slowing economy.
Question 2. What is your estimate of the intrinsic value of Home Depot’s stock as beginning of 2001, assuming that it will have a constant growth rate of 6% and maintain its same ROE as in 2000? Prepare a sensitivity analysis varying the cost of equity and ROE.
(See Question #2 Exhibit)
CAPM = Rf +β(Rm-Rf)
Ke =.058+1.09(.07)
Ke = 13.43%
ROE = .209
G = .06
V= BVE * (ROE-g)/(Ke-g)
12,341*(.209-.06)/(.1343-.06) = 24,748.44
Value ranges from $25.3B to $61.2B
Home Depot, Inc. in the New Millennium
(HBS 9-101-117)
Question 1. Assess Home Depot’s financial performance from 1986 to 1999. What explains the decline in performance in 2000? (See Question #1 Exhibit)
The slowing economy in 2000 combined with Home Depot’s aggressive expansion efforts was the reason for Home Depot’s poor financial performance. Between June 1999 and May 2000, the FED had raised interest rates six times – or a total of 1.75 percentage points – in an effort to slow the economy and economists had been noticing some softening of overall consumer demand.
From Exhibit 4 we see an average increase in sq. footage of 26% per year for period 1986 – 2000 while average sales growth fall from an average over the same time period of 31% to 19% in 2000. In addition Exhibit 4 shows there was a drop in sales per square footage from $423 in 1999 to $415 in 2000 and a drop in weekly sales per store from $876,000 in 1999 to $826,000 in 2000.
An additional calculation derived from Exhibit 4 is the average number of customer transactions per store per year which had been on the steady increase from 1986 to 1996. However, the number of transactions dropped from 906,250 in 1996 to 881,410 in 1997 to 873,850 in 1998 to 856,989 in 1999, and finally down to 826,279 in 2000. Home Depot faced declining performance in 2000 from cannibalization of sales due to over expansion and market saturation. Resulting sales drops were also magnified by the slowing economy.
Question 2. What is your estimate of the intrinsic value of Home Depot’s stock as beginning of 2001, assuming that it will have a constant growth rate of 6% and maintain its same ROE as in 2000? Prepare a sensitivity analysis varying the cost of equity and ROE.
(See Question #2 Exhibit)
CAPM = Rf +β(Rm-Rf)
Ke =.058+1.09(.07)
Ke = 13.43%
ROE = .209
G = .06
V= BVE * (ROE-g)/(Ke-g)
12,341*(.209-.06)/(.1343-.06) = 24,748.44
Value ranges from $25.3B to $61.2B