XML 24 R9.htm IDEA: XBRL DOCUMENT v3.8.0.1
CONSOLIDATED STATEMENTS OF CASH FLOWS (HD Supply, Inc.) - USD ($)
$ in Millions
3 Months Ended
Apr. 29, 2018
Apr. 30, 2017
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net income $ 89 $ 85
Reconciliation of net income to net cash provided by (used in) operating activities:    
Depreciation and amortization 24 25
Provision for uncollectibles 2 2
Non-cash interest expense 6 3
Payment of discounts upon extinguishment of debt   (4)
Loss on extinguishment of debt   3
Stock-based compensation expense 6 6
Deferred income taxes 27 34
Other   (1)
Changes in assets and liabilities, net of the effects of acquisitions & dispositions:    
(Increase) decrease in receivables (66) (113)
(Increase) decrease in inventories (81) (83)
(Increase) decrease in other current assets (9) (3)
Increase (decrease) in accounts payable and accrued liabilities 52 129
Net cash provided by (used in) operating activities 50 83
CASH FLOWS FROM INVESTING ACTIVITIES:    
Capital expenditures (19) (24)
Payments for businesses acquired, net (362)  
Proceeds from sales of property and equipment   2
Net cash provided by (used in) investing activities (381) (22)
CASH FLOWS FROM FINANCING ACTIVITIES:    
Repayments of long-term debt (3) (100)
Borrowings on long-term revolver debt 6 75
Repayments on long-term revolver debt (9) (55)
Debt issuance and modification costs   (5)
Other financing activities (3) 3
Net cash provided by (used in) financing activities (77) (66)
Increase (decrease) in cash and cash equivalents (408) (5)
Cash and cash equivalents at beginning of period 558 75
Cash and cash equivalents at end of period 150 70
HD Supply, Inc. (Total HDS)    
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net income 89 85
Reconciliation of net income to net cash provided by (used in) operating activities:    
Depreciation and amortization 24 25
Provision for uncollectibles 2 2
Non-cash interest expense 6 3
Payment of discounts upon extinguishment of debt   (4)
Loss on extinguishment of debt   3
Stock-based compensation expense 6 6
Deferred income taxes 27 34
Other   (1)
Changes in assets and liabilities, net of the effects of acquisitions & dispositions:    
(Increase) decrease in receivables (66) (113)
(Increase) decrease in inventories (81) (83)
(Increase) decrease in other current assets (9) (3)
Increase (decrease) in accounts payable and accrued liabilities 52 129
Net cash provided by (used in) operating activities 50 83
CASH FLOWS FROM INVESTING ACTIVITIES:    
Capital expenditures (19) (24)
Payments for businesses acquired, net (362)  
Proceeds from sales of property and equipment   2
Net cash provided by (used in) investing activities (381) (22)
CASH FLOWS FROM FINANCING ACTIVITIES:    
Equity distribution to Parent (71)  
Repayments of long-term debt (3) (100)
Borrowings on long-term revolver debt 6 75
Repayments on long-term revolver debt (9) (55)
Debt issuance and modification costs   (5)
Other financing activities (3) 3
Net cash provided by (used in) financing activities (80) (82)
Increase (decrease) in cash and cash equivalents (411) (21)
Cash and cash equivalents at beginning of period 558 73
Cash and cash equivalents at end of period $ 147 $ 52