GURUFOCUS.COM » STOCK LIST » Industrials » Industrial Distribution » HD Supply Holdings Inc (NAS:HDS) » Definitions » Intrinsic Value: Projected FCF

HD Supply Holdings (HD Supply Holdings) Intrinsic Value: Projected FCF : $42.12 (As of May. 06, 2024)


View and export this data going back to 2013. Start your Free Trial

What is HD Supply Holdings Intrinsic Value: Projected FCF?

Since the intrinsic value calculations based on Discounted Cash Flow Intrinsic Value: DCF (FCF Based), or Discounted Earnings Intrinsic Value: DCF (Earnings Based) cannot be applied to companies without consistent revenue and earnings, GuruFocus developed a valuation model based on normalized Free Cash Flow and Book Value of the company. The details of how we calculate the intrinsic value of stocks are described in detail here.

As of today (2024-05-06), HD Supply Holdings's Intrinsic Value: Projected FCF is $42.12. The stock price of HD Supply Holdings is $55.99. Therefore, HD Supply Holdings's Price-to-Intrinsic-Value-Projected-FCF of today is 1.3.

The historical rank and industry rank for HD Supply Holdings's Intrinsic Value: Projected FCF or its related term are showing as below:

HDS' s Price-to-Projected-FCF Range Over the Past 10 Years
Min: 0.93   Med: 2.71   Max: 40.49
Current: 1.33

During the past 12 years, the highest Price-to-Intrinsic-Value-Projected-FCF of HD Supply Holdings was 40.49. The lowest was 0.93. And the median was 2.71.

HDS's Price-to-Projected-FCF is not ranked
in the Industrial Distribution industry.
Industry Median: 0.81 vs HDS: 1.33

HD Supply Holdings Intrinsic Value: Projected FCF Historical Data

The historical data trend for HD Supply Holdings's Intrinsic Value: Projected FCF can be seen below:

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.

* Premium members only.

HD Supply Holdings Intrinsic Value: Projected FCF Chart

HD Supply Holdings Annual Data
Trend Jan11 Jan12 Jan13 Jan14 Jan15 Jan16 Jan17 Jan18 Jan19 Jan20
Intrinsic Value: Projected FCF
Get a 7-Day Free Trial Premium Member Only Premium Member Only - 1.05 6.78 13.97 30.18

HD Supply Holdings Quarterly Data
Jan16 Apr16 Jul16 Oct16 Jan17 Apr17 Jul17 Oct17 Jan18 Apr18 Jul18 Oct18 Jan19 Apr19 Jul19 Oct19 Jan20 Apr20 Jul20 Oct20
Intrinsic Value: Projected FCF Get a 7-Day Free Trial Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only 28.31 30.18 30.71 34.56 42.12

Competitive Comparison of HD Supply Holdings's Intrinsic Value: Projected FCF

For the Industrial Distribution subindustry, HD Supply Holdings's Price-to-Projected-FCF, along with its competitors' market caps and Price-to-Projected-FCF data, can be viewed below:

* Competitive companies are chosen from companies within the same industry, with headquarter located in same country, with closest market capitalization; x-axis shows the market cap, and y-axis shows the term value; the bigger the dot, the larger the market cap. Note that "N/A" values will not show up in the chart.


HD Supply Holdings's Price-to-Projected-FCF Distribution in the Industrial Distribution Industry

For the Industrial Distribution industry and Industrials sector, HD Supply Holdings's Price-to-Projected-FCF distribution charts can be found below:

* The bar in red indicates where HD Supply Holdings's Price-to-Projected-FCF falls into.



HD Supply Holdings Intrinsic Value: Projected FCF Calculation

Since the intrinsic value calculations based on Discounted Cash Flow Intrinsic Value: DCF (FCF Based), or Discounted Earnings Intrinsic Value: DCF (Earnings Based) cannot be applied to companies without consistent revenue and earnings, GuruFocus developed a valuation model based on normalized Free Cash Flow and Book Value of the company.

The details of how we calculate the intrinsic value of stocks are described in detail here.

This method smooths out the free cash flow over the past 6-7 years, multiplies the results by a growth multiple, and adds a portion of Total Stockholders Equity.

Intrinsic Value: Projected FCF = ( Growth Multiple * Free Cash Flow (6 year avg) + 0.8 * Total Stockholders Equity (most recent) ) / Shares Outstanding (Diluted Average)

In the case of negative Total Stockholders Equity, the following formula is used (see Explanation section below for the reason):

Intrinsic Value: Projected FCF = ( Growth Multiple * Free Cash Flow (6 year avg) + Total Stockholders Equity (most recent) / 0.8 ) / Shares Outstanding (Diluted Average)


Add all the Free Cash Flow together and divide 6 will get HD Supply Holdings's Free Cash Flow(6 year avg) = $458.93.

HD Supply Holdings's Intrinsic Value: Projected FCF for today is calculated as

Intrinsic Value: Projected FCF=(Growth Multiple*Free Cash Flow (6 year avg)+Total Stockholders Equity (Oct20)*0.8)/Shares Outstanding (Diluted Average)
=(9.5203515959648*458.928+2952.3*0.8)/159.804
=42.12

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.


HD Supply Holdings  (NAS:HDS) Intrinsic Value: Projected FCF Explanation

The growth multiple is capped between 8.35 and 17.74.

Total Stockholders Equity weighting is more art than science and it should always be revisited in more detail when researching a company. Weightings from 0% to 100% to more than 100% are possible. 80% was chosen as a happy median after taking the above ideas into consideration.

HD Supply Holdings's Price-to-Intrinsic-Value-Projected-FCF for today is calculated as

Price-to-Intrinsic-Value-Projected-FCF=Share Price/Intrinsic Value: Projected FCF
=55.99/42.120321877005
=1.33

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.


HD Supply Holdings Intrinsic Value: Projected FCF Related Terms

Thank you for viewing the detailed overview of HD Supply Holdings's Intrinsic Value: Projected FCF provided by GuruFocus.com. Please click on the following links to see related term pages.


HD Supply Holdings (HD Supply Holdings) Business Description

Traded in Other Exchanges
N/A
Address
3100 Cumberland Boulevard, Suite 1480, Atlanta, GA, USA, 30339
Through a combination of acquisitions and organic growth, HD Supply has become one of the largest industrial distributors in North America. It is currently the market leader in the two sectors in which it operates (facilities and home improvement maintenance, repair, and operations and specialty construction). Today, HD Supply offers approximately 600,000 stock-keeping units and serves 500,000 customers through 270 branches and 44 distribution centers across the United States and Canada. HD Supply sold its construction and industrial business for $2.5 billion net of taxes and transaction costs in October 2020. On Nov. 16, 2020, Home Depot announced it had entered into a definitive agreement to acquire HD Supply for $56 per share.
Executives
Dan S Mcdevitt officer: Gen. Counsel & Corp. Secretary 3100 CUMBERLAND BOULEVARD SUITE 1700 ATLANTA GA 30339
Jana Partners Llc director, other: See Remarks 767 FIFTH AVENUE, 8TH FLOOR, NEW YORK NY 10153
Peter A Dorsman director
Bradley Paulsen officer: Pres, HDS Facilities Main 3400 CUMBERLAND BOULEVARD ATLANTA GA 30339
Anna Stevens officer: Chief People Officer 3400 CUMBERLAND BOULEVARD, ATLANTA GA 30339
Evan Levitt officer: SVP, CFO & CAO 3100 CUMBERLAND BLVD STE 1480 ATLANTA GA 30339
Milford W Mcguirt director 3400 CUMBERLAND BOULEVARD, ATLANTA GA 30339
Joseph J Deangelo director, officer: Chairman, President and CEO 3100 CUMBERLAND BOULEVARD, SUITE 1700, ATLANTA GA 30339
Patrick Mcnamee director C/O EXPRESS SCRIPTS, INC. 13900 RIVERPORT DRIVE MARYLAND HEIGHTS MO 63043
Lauren Taylor Wolfe director 3100 CUMBERLAND BOULEVARD, SUITE 1700, ATLANTA GA 30339
James A Rubright director 3435 WOODHAVEN RD NW, ATLANTA GA 30305
Kathleen J Affeldt director
Stephen J. Konenkamp director 3400 CUMBERLAND BOULEVARD ATLANTA GA 30339
Charles Peffer director 5424 MOHAWK, FAIRWAY KS 66205
John Stegeman officer: Pres, HD Supply C&I-White Cap 3100 CUMBERLAND BLVD STE 1480 ATLANTA GA 30339