HD Supply — Q2 2018 Earnings Presentation
19 slides from HD Supply's earnings presentation, Sep 5, 2018
Slide 1: Q2'18 Execution Highlights
Q2’18 Execution Highlights Focused on Controllable Execution 1 Q2’17 Net Income includes $361M of Income from Discontinued Operations 2 See appendix slides 20 and 21 for a reconciliation of Adjusted EBITDA, Adjusted Net Income and Adjusted Net Income per Diluted Share to Net Income and Income from C
Slide 2: Topics of Recent Investor Interest
Pricing In-line with Market Topics of Recent Investor Interest Topic Consideration 3. Freight Costs Inflation Rising Freight Costs Focused on Shareholder Value Currently Minimal Impact on Sourcing from Tariffs Proprietary Brands Rebar Represents Approximately 5% of Total Sales Tariff Impact on Rebar
Slide 3: Q2'18 Financial Results
$1,352M $1,600M +18% Gross Profit Gross Margin % Operating Income Adj. EBITDA % Op. Income % $539M $622M 39.9% 38.9% $208M $246M $180M $211M 15.4% 15.4% 13.2% +15% -100 BPs - +18% ($ in millions, except per share data) $127M $182M +17% Net Sales 1 Q2’17 Net Income includes $361M of Income from Disco
Slide 4: Q2'18 Segment Performance
Organic Growth in Both Business Units Q2’18 Segment Performance Q2’18 $820M $781M Adj. EBITDA $150M $96M Net Sales ($ in millions) Q2’17 $769M $584M $145M VPY +7% +3% VPY +34% +52% $63M Q2’18 Q2’17 +15% organic
Slide 5: Q2'18 Average Daily Sales Growth
+18.3% Q2’18 Average Daily Sales Growth Q2’18 Monthly Average Daily Sales (%) 6.1% 33.4% 17.7% Aug. 6.0% 33.1% 7.4% 33.3% Facilities Maintenance Construction & Industrial (Preliminary) 18.7% 18.7% 17.8% 6.3% 34.5% 6.9% 6.7% May Jun. Jul. Prior Year $626M $513M $486M HD Supply Net Sales $488M 3.4% 5.
Slide 6: Q3'18 Guidance
+16% +12% +18% +14% Q3’18 Guidance +16% Net Sales Growth VPY at Midpoint $1,610M $1,560M $214M $1,370M $249M $239M VPY Q3’17 Q3’18 Q3’17 Q3’18 Q3’18 Net Sales Adj. EBITDA Adj. Net Income Per Diluted Share1 VPY 1 Q3’18 Adjusted Net Income per Diluted Share range assumes a fully diluted weighted avera
Slide 7: FY'18 Guidance
FY’18 Guidance Strong Sales and Earnings Growth 1 End Market estimate of ~3% is the management estimate of the growth of our markets based on multiple quantitative and long-term average growth target based on management estimates and projections 2 Consolidated from March 5, 2018 3 Guidance Raised on
Slide 8: Approximately 3% End Market Growth for FY'18
Approximately 3% End Market Growth for FY’18 FY’18 End Market Preliminary Outlook Residential Construction “Living Space” MRO Primary End Market Non-Residential Construction ~3% FY’18 End Market Estimates1 1% to 2% Current View as of September ’18 Mid-Single Digit 1 Management estimate; end market g
Slide 9: Current Outlook Summary
Current Outlook Summary HD Supply Current Outlook Summary +16% Net Sales VPY at Midpoint $1,560M to $1,610M Net Sales +14% Adj. EBITDA VPY at Midpoint $239M to $249M Adj. EBITDA +23% Adj. Net Income per Diluted Share VPY at Midpoint $0.95 to $1.00 Adj. Net Income per Diluted Share Assumes ~184M Dilu
Slide 10: Q3'18 and FY'18 Outlook
‘DSUPPLY. Q3'18 = +16% Net Sales VPY at Midpoint — $1,560M to $1,610M Net Sales = +14% Adj. EBITDA VPY at Midpoint — $239M to $249M Adj. EBITDA = +23% Adj. Net Income per Diluted Share VPY at Midpoint ~ $0.95 to $1.00 Adj. Net Income per Diluted Share = Assumes ~184M Diluted Share Count" FY'18 Appro
Slide 11: Concluding Remarks
Concluding Remarks One Team, Driving Customer Success and Value Creation Continual Operational Improvement +18% Net Sales Growth in Q2’18 VPY +18% Adjusted EBITDA1 Growth in Q2’18 VPY +55% Adjusted Net Income per Diluted Share1 Growth in Q2’18 VPY Continued Momentum into the Second Half of 2018 Team
Slide 12: Continual Operational Improvement
‘DSUPPLY. = Continual Operational Improvement +18% Net Sales Growth in Q2'18 VPY — +18% Adjusted EBITDA' Growth in Q2'18 VPY — +55% Adjusted Net Income per Diluted Share’ Growth in Q2'18 VPY «= Continued Momentum into the Second Half of 2018 = Team is Focused and Energized to Deliver
Slide 13: ~$1.7B Net Debt Capital Structure Overview
~$1.7B Net Debt Capital Structure Overview Q2’18 Debt Balances Senior ABL Facility Term B-3 Loans April 2016 Senior Unsecured Notes $49 1,000 4/5/22 8/13/21 Outstanding Debt3 Less: Cash and Cash Equivalents Net Debt $2,008 (228) $2,122 Balance Maturity 1 Represents the Stated Rate of Interest, Witho
Slide 14: Illustrative Adjusted EPS Calculation
Illustrative Adjusted EPS Calculation Adjusted EBITDA Adjusted Net Income per Diluted Share Illustrative Adjusted EPS Calculation Adjusted Net Income = = Diluted Shares Outstanding ÷ TBD TBD TBD ~184M FY’18 ($ in millions, except per share data) $152M $0.49 $91M ~186M Q3’18 Estimates Q3’17 $214M $0.
Slide 15: Preliminary August Sales
$513M Preliminary August Sales Monthly Net Sales ($) Facil. Maint. Const. & Ind. ’18 Selling Days ’17 Selling Days ($ in millions) HD Supply Net Sales (Preliminary) FY’17 $223 $283 $197 $208 $237 $212 $224 $287 $246 $249 $325 $263 $180 $249 $175 $182 $185 $179 $199 $288 $243 $237 $301 $250 $248 $188
Slide 16: Preliminary Average Daily Sales Growth in August
+10.2% Organic Preliminary Average Daily Sales Growth in August Average Daily Sales – Organic1 (VPY%) HD Supply Organic Average Daily Sales Growth VPY1 (VPY%) 1 Adjusted for Acquisitions, Divestitures, and Selling Days 2 Contains an extra selling week as compared with other years. Fiscal 2018 contai
Slide 17: Reconciliation of Non-GAAP Measures: Net Income to Adjusted EBITDA
Reconciliation of Non-GAAP Measures: Net Income to Adjusted EBITDA ($ in millions) 1 Depreciation and amortization includes amounts recorded within Cost of sales in the Consolidated Statements of Operations 2 Represents the loss on extinguishment of debt including the write-off of unamortized deferr
Slide 18: Reconciliation of Non-GAAP Measures: Net Income and Per Share
Reconciliation of Non-GAAP Measures: Net Income to Adjusted Net Income and Adjusted Net Income Per Share ($ in millions, except share and per share amounts) 1 Represents the loss on extinguishment of debt including the write-off of unamortized deferred financing costs, original issue discount, and o
Slide 19: ‘DSUPPLY.
‘DSUPPLY. (S inmiions, excep sare and per share amounts) Three Months Six Months: Ended Ended July 29, July 30, July 29, July 30, 2018 2017 2018 2017 Net income $131 $442 $220 $527 Less income from discontinued operations, net of tax 1 361 4 388 Income from continuing operations 130 81 219 139 Provi