XML 32 R12.htm IDEA: XBRL DOCUMENT v3.3.1.900
CONSOLIDATED STATEMENTS OF CASH FLOWS (HD Supply, Inc.) - USD ($)
$ in Millions
12 Months Ended
Jan. 31, 2016
Feb. 01, 2015
Feb. 02, 2014
CASH FLOWS FROM OPERATING ACTIVITIES:      
Net income (loss) $ 1,472 $ 3 $ (218)
Reconciliation of net income (loss) to net cash provided by (used in) operating activities:      
Depreciation and amortization 134 226 246
Provision for uncollectibles 8 7 4
Non-cash interest expense 23 25 30
Payment of PIK interest & discounts upon extinguishment of debt (12) (1) (364)
Loss on extinguishment & modification of debt 100 108 87
Gain on sale of business (186) (8)  
Stock-based compensation expense 16 17 16
Deferred income taxes (839) 55 54
Other (4)   3
Changes in assets and liabilities, net of the effects of acquisitions & dispositions:      
(Increase) decrease in receivables (63) (90) (68)
(Increase) decrease in inventories (38) (71) (101)
(Increase) decrease in other current assets 11 18  
Increase (decrease) in accounts payable and accrued liabilities (14) 1 (64)
Increase (decrease) in other long-term liabilities (186) 5 8
Net cash provided by (used in) operating activities 422 295 (367)
CASH FLOWS FROM INVESTING ACTIVITIES:      
Capital expenditures (86) (119) (131)
Proceeds from sales of property and equipment 3 5 8
Proceeds from sale of investments     936
Proceeds from sales of businesses 809 198 4
Settlements for businesses acquired, net of cash acquired     3
Net cash provided by (used in) investing activities 726 84 820
CASH FLOWS FROM FINANCING ACTIVITIES:      
Borrowings of long-term debt 287 1,270 79
Repayments of long-term debt (1,152) (1,385) (1,624)
Borrowings on long-term revolver debt 784 878 858
Repayments on long-term revolver debt (880) (1,142) (798)
Debt issuance and modification costs (6) (21) (34)
Other financing activities 2   2
Net cash provided by (used in) financing activities (962) (404) (474)
Effect of exchange rates on cash and cash equivalents (2) (5) (5)
Increase (decrease) in cash and cash equivalents 184 (30) (26)
Cash and cash equivalents at beginning of period 85 115 141
Cash and cash equivalents at end of period 269 85 115
HD Supply, Inc. (Total HDS)      
CASH FLOWS FROM OPERATING ACTIVITIES:      
Net income (loss) 1,472 3 (218)
Reconciliation of net income (loss) to net cash provided by (used in) operating activities:      
Depreciation and amortization 134 226 246
Provision for uncollectibles 8 7 4
Non-cash interest expense 23 25 30
Payment of PIK interest & discounts upon extinguishment of debt (12) (1) (364)
Loss on extinguishment & modification of debt 100 108 87
Gain on sale of business (186) (8)  
Stock-based compensation expense 16 17 16
Deferred income taxes (839) 55 54
Other (4)   3
Changes in assets and liabilities, net of the effects of acquisitions & dispositions:      
(Increase) decrease in receivables (63) (90) (68)
(Increase) decrease in inventories (38) (71) (101)
(Increase) decrease in other current assets 11 18  
Increase (decrease) in accounts payable and accrued liabilities (14) 1 (64)
Increase (decrease) in other long-term liabilities (186) 5 8
Net cash provided by (used in) operating activities 422 295 (367)
CASH FLOWS FROM INVESTING ACTIVITIES:      
Capital expenditures (86) (119) (131)
Proceeds from sales of property and equipment 3 5 8
Proceeds from sale of investments     936
Proceeds from sales of businesses 809 198 4
Settlements for businesses acquired, net of cash acquired     3
Net cash provided by (used in) investing activities 726 84 820
CASH FLOWS FROM FINANCING ACTIVITIES:      
Equity contribution     1,039
Borrowings of long-term debt 287 1,270 79
Repayments of long-term debt (1,152) (1,385) (1,624)
Borrowings on long-term revolver debt 784 878 858
Repayments on long-term revolver debt (880) (1,142) (798)
Debt issuance and modification costs (6) (21) (34)
Other financing activities 2   2
Net cash provided by (used in) financing activities (965) (400) (478)
Effect of exchange rates on cash and cash equivalents (2) (5) (5)
Increase (decrease) in cash and cash equivalents 181 (26) (30)
Cash and cash equivalents at beginning of period 85 111 141
Cash and cash equivalents at end of period $ 266 $ 85 $ 111