XML 25 R9.htm IDEA: XBRL DOCUMENT v3.5.0.2
CONSOLIDATED STATEMENTS OF CASH FLOWS (HD Supply, Inc.) - USD ($)
$ in Millions
9 Months Ended
Oct. 30, 2016
Nov. 01, 2015
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net income $ 144 $ 601
Reconciliation of net income to net cash provided by (used in) operating activities:    
Depreciation and amortization 76 106
Provision for uncollectibles 5 5
Non-cash interest expense 13 18
Payment of discounts upon extinguishment of debt   (12)
Loss on extinguishment & modification of debt 174 100
Stock-based compensation expense 15 14
Deferred income taxes 93 (15)
(Gain) loss on sales of businesses, net 7 (186)
Other (2) (2)
Changes in assets and liabilities:    
(Increase) decrease in receivables (236) (248)
(Increase) decrease in inventories (119) (124)
(Increase) decrease in other current assets   4
Increase (decrease) in accounts payable and accrued liabilities 134 93
Increase (decrease) in other long-term liabilities   (181)
Net cash provided by (used in) operating activities 304 173
CASH FLOWS FROM INVESTING ACTIVITIES:    
Capital expenditures (59) (61)
Proceeds from sales of property and equipment 2 2
Proceeds from sales of businesses, net 28 810
Net cash provided by (used in) investing activities (29) 751
CASH FLOWS FROM FINANCING ACTIVITIES:    
Borrowings of long-term debt 1,547 287
Repayments of long-term debt (2,435) (1,150)
Borrowings on long-term revolver debt 510 784
Repayments on long-term revolver debt   (850)
Debt issuance and modification fees (19) (6)
Other financing activities (1) 1
Net cash provided by (used in) financing activities (399) (930)
Effect of exchange rates on cash and cash equivalents 1 (2)
Increase (decrease) in cash and cash equivalents (123) (8)
Cash and cash equivalents at beginning of period 269 85
Cash and cash equivalents at end of period 146 77
HD Supply, Inc. (Total HDS)    
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net income 144 601
Reconciliation of net income to net cash provided by (used in) operating activities:    
Depreciation and amortization 76 106
Provision for uncollectibles 5 5
Non-cash interest expense 13 18
Payment of discounts upon extinguishment of debt   (12)
Loss on extinguishment & modification of debt 174 100
Stock-based compensation expense 15 14
Deferred income taxes 93 (15)
(Gain) loss on sales of businesses, net 7 (186)
Other (2) (2)
Changes in assets and liabilities:    
(Increase) decrease in receivables (236) (248)
(Increase) decrease in inventories (119) (124)
(Increase) decrease in other current assets   4
Increase (decrease) in accounts payable and accrued liabilities 134 93
Increase (decrease) in other long-term liabilities   (181)
Net cash provided by (used in) operating activities 304 173
CASH FLOWS FROM INVESTING ACTIVITIES:    
Capital expenditures (59) (61)
Proceeds from sales of property and equipment 2 2
Proceeds from sales of businesses, net 28 810
Net cash provided by (used in) investing activities (29) 751
CASH FLOWS FROM FINANCING ACTIVITIES:    
Borrowings of long-term debt 1,547 287
Repayments of long-term debt (2,435) (1,150)
Borrowings on long-term revolver debt 510 784
Repayments on long-term revolver debt   (850)
Debt issuance and modification fees (19) (6)
Other financing activities (1) 1
Net cash provided by (used in) financing activities (398) (934)
Effect of exchange rates on cash and cash equivalents 1 (2)
Increase (decrease) in cash and cash equivalents (122) (12)
Cash and cash equivalents at beginning of period 266 85
Cash and cash equivalents at end of period $ 144 $ 73