HD Supply — Q4 2016 Earnings Presentation
27 slides from HD Supply's earnings presentation, Mar 14, 2017
Slide 1: Disclaimers
Disclaimers 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 informa
Slide 2: FY'16 Execution Highlights
FY’16 Execution Highlights Focused on Controllable Execution +4.4% Net Sales Growth Versus Prior Year (“VPY”) +7.3% Operating Income Growth VPY $196M Net Income in Fiscal 2016 $1,472M Net Income in Fiscal 20151 +5.1% Adjusted EBITDA Growth VPY +51.1% Adjusted Net Income per Diluted Share Growth VPY
Slide 3: Q4'16 Execution Highlights
Q4’16 Execution Highlights Focused on Controllable Execution +3.2% Net Sales Growth VPY +10.7% Operating Income Growth VPY $52M Net Income for Fiscal Q4’16 $871 Net Income for Fiscal Q4’151 +1.2% Adjusted EBITDA Growth VPY +63.0% Adjusted Net Income per Diluted Share Growth VPY +60 Basis Points Gros
Slide 4: FY'16 Execution Examples
FY’16 Execution Examples 200 Atlanta-Based Support Associates Customer Centric Digital Vision Supply Chain Improvements Sold San Diego Headquarters Facility Intense Daily Performance Cadence Controllable Execution +96 Customer Facing Associates Established National Strategic Account Teams Improved C
Slide 5: Controllable Execution
Controllable Execution Extend Leadership Positions Sell More to Existing Customers Introduce New Products and Services Expand and Integrate Channels to Reach Our Customers Acquire New Customers Enter New Geographies Deliver Operating Leverage Execute Category Management Save as We Grow Generate Cash
Slide 6: Topics of Recent Investor Interest
Improved Future After-tax Cash Flows Proprietary Brands; ~5% Annual Company Purchases Minimal Exposure Pockets of Strength; Non-residential Markets Topics of Recent Investor Interest Free Cash Flow is defined as Operating Cash Flow – Capital Expenditures (including Cash Flow from Discontinued Operat
Slide 7: Q4'16 Financial Results
Q4’16 Financial Results $1,584M $1,634M +3% Gross Profit Gross Margin % Operating Income Adj. EBITDA % Op. Income % $534M $560M 33.7% 34.3% $167M $169M $131M $145M 10.5% 10.3% 8.9% +5% +60 BPs -20 BPs +1% ($ in millions, except per share data) $55M $90M +11% Net Sales 1 Net Income in Q4’15 includes
Slide 8: Q4'16 and FY'16 Segment Results
Q4’16 and FY’16 Segment Results Q4’16 FY’16 $620M $2,762M Q4’16 FY’16 $551M $2,622M Q4’16 FY’16 $466M $2,063M +2% +3% Adj. EBITDA $98M $523M Sales Growth % Growth (4%) (1%) Op. Leverage1 nm nm +3% +4% $42M $234M +2% +5% 0.7x 1.2x +4% +7% $40M $224M +18% +22% 4.1x 3.2x Net Sales ($ in millions) Solid
Slide 9: Q4'16 Taxes and Cash Flow
Q4’16 Taxes and Cash Flow Taxes Cash Flow Favorable Tax Asset with Significant Gross Federal Net Operating Loss Carryforwards of Approximately $1.8 Billion ~$700M Tax-affected Amount of Federal and State NOLs Cash Taxes $1M in Q4’16 $4M – $5M Estimated for Q1’17 $15M – $25M Estimated for FY’17 GAAP
Slide 10: Q4'16 Monthly Average Daily Sales
Q4’16 Monthly Average Daily Sales (%) +3% Q4’16 Average Daily Sales Growth +6% Preliminary February Average Daily Sales Growth 2.8% 3.9% 3.7% 6.4% Feb. 0.2% 15.0% 5.3% 2.5% ’16 Selling Days 23 20 20 2.4% 6.4% Facilities Maintenance Waterworks Construction & Industrial (Preliminary) 2.3% 3.6% 3.4% 0.
Slide 11: Q1'17 Guidance
+2% -5% +6% +3% Q1’17 Guidance 5% Sales Growth VPY at Midpoint $1,890M $1,840M $215M $1,781M $220M $205M VPY Q1’16 Q1’17 Q1’16 Q1’17 Q1’17 Net Sales Adj. EBITDA Adj. Net Income Per Diluted Share1 VPY 1 Q1’17 Adjusted Net Income per Share range assumes a fully diluted weighted average share count of
Slide 12: FY'17 End Market Preliminary Outlook
FY’17 End Market Preliminary Outlook ~2% to 3% End Market Growth for FY’17 Residential Construction Water Infrastructure “Living Space” MRO Primary End Market Non- Residential Construction ~2% to 3% FY’17 End Market Estimates1 1% to 2% Current View as of March’ 17 Mid-Single Digit Low Single Digits
Slide 13: FY'17 Operating Leverage Framework
FY’17 Operating Leverage Framework HDS Market Growth1 ~2-3% + Above Market Growth2 ~300 BPs = End Market Growth Controllable Execution Annual Net Sales Growth1,2 Illustrative Adj. EBITDA Growth Adjusted EBITDA Growth 12% HDS Market Growth 7.5% 5-6% 2.0x 1.5x Operating Leverage Target2,3 1 Management
Slide 14: FY'17 External Free Cash Flow Framework
FY’17 External Free Cash Flow Framework Building Free Cash Flow Momentum Illustrative Annual Net Sales Growth1, 2 Illustrative Adj. EBITDA Growth Adjusted EBITDA Growth 12% HDS Market Growth 7.5% 5-6% 2.0x 1.5x Operating Leverage Target2,3 Above Market Growth 1 Management estimate; market estimate i
Slide 15: HD Supply Outlook Summary
HD Supply Outlook Summary Focused on Controllable Execution Q1’17 FY’17 $1,840M - $1,890M Net Sales Range $205M - $220M Adjusted EBITDA Range $0.60 - $0.68 Adjusted Net Income per Diluted Share Increase Range ~203M Diluted Share Count Illustrative 1 Management estimate; market estimate is management
Slide 16: Q1'17 and FY'17 Outlook
Q117 FY'17 = $1,840M - $1,890M Net Sales Range = 2% to 3% End Market Growth Range Estimate’ = $205M - $220M Adjusted EBITDA Range = ~300 Basis Points of Growth in Excess = $0.60 - $0.68 Adjusted Net Income per of Market Estimate? Diluted Share Increase Range = 1.5x to 2.0x Operating Leverage* Range
Slide 17: Concluding Remarks
Concluding Remarks Solid Continual Improvement +4.4% Net Sales Growth in FY’16 VPY +51.1% Adjusted Net Income per Diluted Share Growth in FY’16 VPY +29.6% Free Cash Flow in FY’16 VPY Focus on 2017 Investment in Long-term Capabilities to Achieve Full Potential Disciplined People, Thought and Action E
Slide 18: Solid Continual Improvement
¥ Solid Continual Improvement ~ +4.4% Net Sales Growth in FY’16 VPY ~— +51.1% Adjusted Net Income per Diluted Share Growth in FY'16 VPY ~ +29.6% Free Cash Flow in FY’16 VPY = Focus on 2017... Investment in Long-term Capabilities to Achieve Full Potential Disciplined People, Thought and Action » Earn
Slide 19: Capital Structure Overview
Capital Structure Overview Q4’16 Debt Balances Secured ABL Secured Term B-1 Secured 1st Lien Notes Senior Unsecured Notes $421 1,250 1,000 6/28/18 8/13/21 12/15/21 Outstanding Debt Less Cash and Cash Equivalents Net Debt $3,737 (75) $3,859 Balance Maturity 1 Represents the stated rate of interest, w
Slide 20: Illustrative Adjusted EPS Calculation
Illustrative Adjusted EPS Calculation Adjusted EBITDA Adjusted Net Income per Diluted Share Adjusted Net Income = = Diluted Shares Outstanding3 ÷ Illustrative TBD TBD TBD ~203M FY’17 $169M $0.44 $90M ~203M Q4’16 ($ in millions, except per share data) ~203 Q1’17 TBD TBD TBD ~204 Q4’17 Estimates ~203
Slide 21: Monthly Net Sales
Monthly Net Sales ($) $535M Preliminary February Sales FY’15 Facil. Maint. Waterworks Const. & Ind. ’16 Selling Days ’15 Selling Days ($ in millions) HD Supply Net Sales (Preliminary) FY’16 Jan. Feb. Mar. Apr. May Jun. Jul. Aug. Sep. Oct. Nov. $586M $502M $550M $729M $609M $622M $785M $639M $603M $7
Slide 22: HD Supply Organic Average Daily Sales Growth VPY
HD Supply Organic Average Daily Sales Growth VPY +6.4% Preliminary Average Daily Sales Growth in February (VPY%) Average Daily Sales – Organic (VPY%) FY’15 (Preliminary) FY’16 Jan. Feb. Mar. Apr. May Jun. Jul. Aug. Sep. Oct. Nov. 4.5% 9.2% 7.9% 5.6% 3.6% 6.2% 3.0% 2.3% 3.7% 4.1% 2.3% 3.6% 3.4% 6.4%
Slide 23: Average Daily Sales – Organic (VPY%)
Average Daily Sales – Organic1 (VPY%) 1 Adjusted to Exclude Acquisitions, Divestitures, and Selling Days Note: “VPY” Denotes Versus Prior Year (VPY%) Selling Days Facilities Maintenance Waterworks Construction & Industrial HD Supply 65 6.6% 6.1% 9.6% 7.3% Facilities Maintenance Waterworks Constructi
Slide 24: Operating Leverage (VPY)
Operating Leverage1 (VPY) 1 Operating Leverage is Defined as Adjusted EBITDA Growth Divided by Adjusted Net Sales Growth (adjusted for the 53rd Week in fiscal 2012) Not Meaningful (“nm”) when Sales Growth is Negative and when Prior Period Adjusted EBITDA is Negative or when Adjusted EBITDA Growth is
Slide 25: C&I Historical Performance (including HIS)
C&I Historical Performance (including HIS) ($ in millions) 1 2012 includes $26M and $2M in Net Sales and Adjusted EBITDA, respectively, for the 53rd week $501M $49M Sales Adjusted EBITDA Selling Days $1,425M $81M 258 $349M $14M 66 $325M $14M 65 $369M $25M 63 Sales Adjusted EBITDA Selling Days $382M
Slide 26: Reconciliation of Non-GAAP Measures: Net Income to Adjusted EBITDA
Reconciliation of Non-GAAP Measures: Net Income to Adjusted EBITDA ($ in millions) 1 During the fiscal year ended January 31, 2016, the Company recorded a $1,007 million tax benefit for the reversal of substantially all of the valuation allowance on its U.S. net deferred tax assets and a $189 millio
Slide 27: Reconciliation of Adjusted Net Income
‘DSUPPLY. (S inmlons, except share and per share amounts) Q4'16 FY15 Net income $52 $1,472 Less income (loss) from discontinued operations, net of tax = (102) (8) 146 Income (loss) from continuing operations 52 973 204 1,326 Provision (benefit) for income taxes! 38 (925) 139 (1,084) Cash paid for in