HD Supply — Q4 2017 Earnings Presentation
23 slides from HD Supply's earnings presentation, Mar 13, 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: FY'17 Execution Highlights
FY’17 Execution Highlights Focused on Controllable Execution 1 See appendix slides 22 and 23 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: Q4'17 Execution Highlights
Q4’17 Execution Highlights Focused on Controllable Execution 1 See appendix slides 22 and 23 for a reconciliation of Adjusted EBITDA, Adjusted Net Income and Adjusted Net Income per Diluted Share to Net Income (Loss) and Income (Loss) from Continuing Operations 2 Operating Leverage is defined as Adj
Slide 4: FY'17 Execution Examples
FY’17 Execution Examples Sale of Waterworks Business for $2.5B Achieved Financial Leverage Target of 2x to 3x1 Announced $1B of Share Repurchase Programs Announced Acquisition of A.H. Harris for $380M One-Time Bonus for Hourly Associates Focused on Controllable Execution Will Stengel Announced as Pr
Slide 5: No Change; Continued Intense Environment
No Change; Continued Intense Environment $445M Remaining Under Existing Authorization1 Topics of Recent Investor Interest Topic Consideration Winter Weather Share Repurchases Competitive Environment Mild December Offset by Snow and Ice in January Focus on Shareholder Value Continued Pressure in Shor
Slide 6: Q4'17 Financial Results
$1,085M $1,183M +9% Gross Profit Gross Margin % Operating Income Adj. EBITDA % Op. Income % $431M $468M 39.7% 39.6% $122M $152M $102M $117M 11.2% 12.8% 9.9% +9% -10 BPs +160 BPs +25% ($ in millions, except per share data) $47M $91M +15% Net Sales 1 The decrease in Net income (loss) and Net income (l
Slide 7: Organic Growth Across Business Units
Organic Growth Across Business Units Q4’17 and FY’17 Business Unit Performance Adj. EBITDA1 Net Sales ($ in millions) Q4’17 $642M $102M Q4’16 $620M $88M VPY +4% +16% FY’17 $2,847M $499M FY’16 $482M +3% +4% $2,762M VPY Q4’17 $542M $50M Q4’16 $466M $34M VPY +16% +47% FY’17 $2,279M $232M FY’16 $198M +1
Slide 8: Q4'17 Taxes and Cash Flow
Q4’17 Taxes and Cash Flow Favorable Tax Asset with Significant Gross Federal Net Operating Loss Carryforwards of Approximately $790 Million ~$250M Tax-affected Amount of Federal and State NOLs Cash Taxes $2M in Q4’17 $2-4M Estimated in Q1’18 $11-13M Estimated in FY’18 Effective Rate ~35% for Q4’17 (
Slide 9: Q4'17 Average Daily Sales Growth
+9.0% Q4’17 Average Daily Sales Growth Q4’17 Monthly Average Daily Sales (%) 2.2% 13.3% 11.7% Feb. 7.1% 17.3% 4.9% ’16 Selling Days 23 20 20 18.6% Facilities Maintenance Construction & Industrial (Preliminary) 9.8% 10.9% 6.8% 4.3% 16.4% 18 2.0% 2.4% Nov. Dec. Jan. Prior Year $421M $391M $390M HD Sup
Slide 10: FY'18 End Market Preliminary Outlook
~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 March ’18 Mid-Single Digit 1 Management estimate end market growth ba
Slide 11: FY'18 Guidance
FY’18 Guidance Strong Sales and Earnings Growth 1 End Market estimate of 2%-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 Operating Levera
Slide 12: Q1'18 Guidance
+17% +11% +13% +9% Q1’18 Guidance +11% Net Sales Growth VPY at Midpoint $1,375M $1,3725M $157M $1,216M $184M $174M VPY Q1’17 Q1’18 Q1’17 Q1’18 Q1’18 Net Sales Adj. EBITDA Adj. Net Income Per Diluted Share1 VPY 1 Q1’18 Adjusted Net Income per Diluted Share range assumes a fully diluted weighted avera
Slide 13: Current Outlook Summary
Current Outlook Summary HD Supply Current Outlook Summary +11% Net Sales VPY at Midpoint $1,325M to $1,375M Net Sales +14% Adj. EBITDA VPY at Midpoint $174M to $184M Adj. EBITDA +62% Adj. Net Income per Diluted Share Increase VPY at Midpoint $0.60 to $0.66 Adj. Net Income per Diluted Share Assumes ~
Slide 14: Current Outlook Summary (Q1'18 and FY'18)
‘DSUPPLY. Q118 = +11% Net Sales VPY at Midpoint — $1,325M to $1,375M Net Sales = +14% Adj. EBITDA VPY at Midpoint ~ $174M to $184M Adj. EBITDA = +62% Adj. Net Income per Diluted Share Increase VPY at Midpoint ~ $0.60 to $0.66 Adj. Net Income per Diluted Share = Assumes ~186M Diluted Share Count? FY'
Slide 15: Concluding Remarks
Concluding Remarks One Team, Driving Customer Success and Value Creation Continual Operational Improvement +6% Net Sales Growth in FY’17 VPY +8% Adjusted EBITDA1 Growth in FY’17 VPY 1.2x Operating Leverage2 +54% Adjusted Net Income per Diluted Share Growth1 in FY’17 VPY Move to New Atlanta Leadershi
Slide 16: Concluding Remarks
‘DSUPPLY. = Continual Operational Improvement +6% Net Sales Growth in FY'17 VPY — +8% Adjusted EBITDA’ Growth in FY'17 VPY — 1.2x Operating Leverage? — +54% Adjusted Net Income per Diluted Share Growth’ in FY'17 VPY = Move to New Atlanta Leadership Development Center — First Investor Day: June 21%",
Slide 17: Capital Structure Overview
~$1.7B Net Debt Capital Structure Overview Q4’17 Debt Balances Senior ABL Facility Term B-3 Loans April 2016 Senior Unsecured Notes $58 1,000 4/5/22 8/13/21 Outstanding Debt3 Less: Cash and Cash Equivalents Net Debt $1,605 (558) $2,136 Balance Maturity 1 Represents the stated rate of interest, witho
Slide 18: 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 ~186M FY’18 Q1’17 ($ in millions, except per share data) Q2’17 $152M $0.49 $91M ~186M Q1’18 Estimates ~19
Slide 19: Preliminary February Sales
$391M Preliminary February Sales Monthly Net Sales ($) Facil. Maint. Const. & Ind. ’18 Selling Days ’17 Selling Days ($ in millions) HD Supply Net Sales (Preliminary) FY’17 Mar. Apr. May Jun. Jul. Aug. Sep. Oct. Nov. Dec. Jan. Feb. Feb. $350M $378M $488M $412M $408M $532M $390M $436M $403M $421M $53
Slide 20: Preliminary Average Daily Sales Growth in February
+11.7% Preliminary Average Daily Sales Growth in February 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 53
Slide 21: Reconciliation: Net Income (Loss) to Adjusted EBITDA
Reconciliation of Non-GAAP Measures: Net Income (Loss) 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
Slide 22: Reconciliation: Net Income (Loss) to Adjusted Net Income
Reconciliation of Non-GAAP Measures: Net Income (Loss) to Adjusted Net Income and Adjusted Net Income Per Share ($ in millions, except share and per share amounts) 1 Cash paid for income taxes in fiscal 2017 excludes $13 million in payments related to the sale of the Waterworks business unit 2 Repre
Slide 23: Reconciliation: Adjusted Net Income Per Share
‘DSUPPLY. (S milion, except share and per share amounts) Q417 Q4'16 FY'17. FY'16 Net income (loss) (89) $52 $970 $196 Less income from discontinued operations, net of tax 9 26 803 130 Income (loss) from continuing operations (18) 26 167 66 Provision for income taxes 101 21 193 51 Cash paid for incom