HD Supply — Q1 2018 Earnings Presentation
20 slides from HD Supply's earnings presentation, Jun 5, 2018
Slide 1: Disclaimer: Forward-Looking Statements and Preliminary Results
Disclaimer Forward-Looking Statements and Preliminary Results This presentation includes “forward-looking statements” within the meaning of Section 27A of the Securities Act and Section 21E of the Exchange Act. Forward-looking statements are based on management’s beliefs and assumptions and informat
Slide 2: Q1'18 Execution Highlights
Q1’18 Execution Highlights Focused on Controllable Execution 1 See appendix slides 19 and 20 for a reconciliation of Adjusted EBITDA, Adjusted Net Income and Adjusted Net Income per Diluted Share to Net Income and Income from Continuing Operations 2 Operating Leverage is defined as Adjusted EBITDA g
Slide 3: Demand Remains Strong
Demand Remains Strong Rebar Represents Approximately 5% of Total Sales Topics of Recent Investor Interest Topic Consideration Labor Inflation Tariff Impacts Non-residential End Market Modest Increase in Labor Costs Focused on Shareholder Value Rising Freight Costs Mitigated Freight Costs Milder Febr
Slide 4: Q1'18 Financial Results
$1,216M $1,389M +14% Gross Profit Gross Margin % Operating Income Adj. EBITDA % Op. Income % $484M $552M 39.8% 39.7% $157M $190M $129M $151M 12.9% 13.7% 10.9% +14% -10 BPs +80 BPs +21% ($ in millions, except per share data) $80M $130M +17% Net Sales 1 See appendix slides 19 and 20 for a reconciliati
Slide 5: Organic Growth in Both Business Units
Organic Growth in Both Business Units Q1’18 Segment Performance Q1’18 $723M $666M Adj. EBITDA $123M $67M Net Sales ($ in millions) Q1’17 $682M $536M $108M VPY +6% +14% VPY +24% +37% $49M Q1’18 Q1’17 Operating Leverage 2.3x 1.5x +14% organic
Slide 6: Q1'18 Taxes and Cash Flow
Q1’18 Taxes and Cash Flow Favorable Tax Asset with Significant Gross Federal Net Operating Loss (“NOL”) Carryforwards of Approximately $675 Million ~$205M Tax-affected Amount of Federal and State NOLs Cash Taxes $2M in Q1’18 $2-4M Estimated in Q2’18 $10-12M Estimated in FY’18 Effective Rate ~25% for
Slide 7: Q1'18 Average Daily Sales Growth
+14.2% Q1’18 Average Daily Sales Growth Q1’18 Monthly Average Daily Sales (%) 5.4% 32.8% 18.7% May 6.3% 34.5% 5.9% 19.7% Facilities Maintenance Construction & Industrial (Preliminary) 11.7% 12.0% 17.7% 7.1% 17.3% 2.4% 6.9% Feb. Mar. Apr. Prior Year $575M $488M $423M HD Supply Net Sales $391M 3.9% 3.
Slide 8: Q2'18 Guidance
+18% +13% +18% +14% Q2’18 Guidance +16% Net Sales Growth VPY at Midpoint $1,595M $1,535M $208M $1,352M $245M $235M VPY Q2’17 Q2’18 Q2’17 Q2’18 Q2’18 Net Sales Adj. EBITDA Adj. Net Income Per Diluted Share1 VPY 1 Q2’18 Adjusted Net Income per Diluted Share range assumes a fully diluted weighted avera
Slide 9: ~2 to 3% End Market Growth for FY'18
~2 to 3% End Market Growth for FY’18 FY’18 End Market Preliminary Outlook Residential Construction “Living Space” MRO Primary End Market Non-Residential Construction ~2 to 3% FY’18 End Market Estimates1 1% to 2% Current View as of June ’18 Mid-Single Digit 1 Management estimate; end market growth ba
Slide 10: Current Outlook Summary
Current Outlook Summary HD Supply Current Outlook Summary +16% Net Sales VPY at Midpoint $1,535M to $1,595M Net Sales +15% Adj. EBITDA VPY at Midpoint $235M to $245M Adj. EBITDA +48% Adj. Net Income per Diluted Share VPY at Midpoint $0.92 to $0.97 Adj. Net Income per Diluted Share Assumes ~185M Dilu
Slide 11: Current Outlook Summary (Q2'18 and FY'18)
‘DSUPPLY. Q218 = +16% Net Sales VPY at Midpoint — $1,535M to $1,595M Net Sales = +15% Adj. EBITDA VPY at Midpoint ~ $235Mto $245M Adj. EBITDA = +48% Adj. Net Income per Diluted Share VPY at Midpoint ~ $0.92to $0.97 Adj. Net Income per Diluted Share = Assumes ~185M Diluted Share Count? FY'18 +2% to +
Slide 12: Concluding Remarks
Concluding Remarks One Team, Driving Customer Success and Value Creation Continual Operational Improvement +14% Net Sales Growth in Q1’18 VPY +21% Adjusted EBITDA1 Growth in Q1’18 VPY 1.5x Operating Leverage +79% Adjusted Net Income per Diluted Share Growth1 in Q1’18 VPY Strong Start to 2018 First I
Slide 13: Concluding Remarks
‘DSUPPLY. = Continual Operational Improvement — +14% Net Sales Growth in Q1'18 VPY — +21% Adjusted EBITDA’ Growth in Q1'18 VPY = 1.5x Operating Leverage — +79% Adjusted Net Income per Diluted Share Growth’ in Q1'18 VPY «= Strong Start to 2018 = First Investor Day: June 21°, 2018, Atlanta Leadership
Slide 14: Capital Structure Overview
~$1.7B Net Debt Capital Structure Overview Q1’18 Debt Balances Senior ABL Facility Term B-3 Loans April 2016 Senior Unsecured Notes $52 1,000 4/5/22 8/13/21 Outstanding Debt3 Less: Cash and Cash Equivalents Net Debt $2,092 (150) $2,128 Balance Maturity 1 Represents the Stated Rate of Interest, Witho
Slide 15: 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 ~185M FY’18 ($ in millions, except per share data) Q2’17 $152M $0.49 $91M ~186M Q2’18 Estimates ~199M Q3’
Slide 16: Preliminary May Sales: Monthly Net Sales
$488M Preliminary May Sales Monthly Net Sales ($) Facil. Maint. Const. & Ind. ’18 Selling Days ’17 Selling Days ($ in millions) HD Supply Net Sales (Preliminary) FY’17 Jun. Jul. Aug. Sep. Oct. Nov. Dec. Jan. Feb. Mar. Apr. May May $412M $408M $532M $436M $403M $531M $423M $372M $390M $575M $421M $39
Slide 17: Preliminary Average Daily Sales Growth in May
+10.6% Organic Preliminary Average Daily Sales Growth in May 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 contains
Slide 18: 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 19: Reconciliation of Non-GAAP Measures: Net Income to Adjusted 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 20: Reconciliation of Net Income to Adjusted Net Income and Per Share
‘DSUPPLY. (Sin milons, except share and per share amounts) arg Qt17 Net income $89 $85 Less income from discontinued operations, net of tax : 27 Income from continuing operations 89 58 Provision for income taxes 29 19 Cash paid for income taxes (2) @) ‘Amortization of acquisition related intangible