XML 40 R9.htm IDEA: XBRL DOCUMENT v2.4.0.8
CONSOLIDATED STATEMENTS OF CASH FLOWS (HD Supply, Inc.) (USD $)
In Millions, unless otherwise specified
9 Months Ended
Nov. 03, 2013
Oct. 28, 2012
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net income (loss) $ (152) $ (466)
Reconciliation of net income (loss) to net cash provided by (used in) operating activities:    
Depreciation and amortization 184 255
Provision for uncollectibles 4 3
Non-cash interest expense 23 86
Payment of PIK interest & discounts upon extinguishment of debt (364)  
Loss on extinguishment & modification of debt 87 220
Stock-based compensation expense 12 13
Deferred income taxes 35 27
Gain on sale of a business   (12)
Other (2) 1
Changes in assets and liabilities:    
(Increase) decrease in receivables (226) (215)
(Increase) decrease in inventories (87) (197)
(Increase) decrease in other current assets 4 (4)
(Increase) decrease in other assets   2
Increase (decrease) in accounts payable and accrued liabilities (42) (46)
Increase (decrease) in other long-term liabilities 14 6
Net cash provided by (used in) operating activities (510) (327)
CASH FLOWS FROM INVESTING ACTIVITIES:    
Capital expenditures (96) (80)
Proceeds from sales of property and equipment 6 5
Proceeds from sale of investments 936  
Purchase of investments   (985)
Proceeds from sale of a business   481
(Payment) settlement for acquisition of a business, net of cash acquired 2 (196)
Other investing activities   (2)
Net cash provided by (used in) investing activities 848 (777)
CASH FLOWS FROM FINANCING ACTIVITIES:    
Borrowings of long-term debt 79 4,140
Repayments of long-term debt (1,621) (3,290)
Borrowings on long-term revolver debt 736 1,192
Repayments on long-term revolver debt (556) (797)
Debt issuance and modification fees (34) (95)
Other financing activities   1
Net cash provided by (used in) financing activities (357) 1,151
Effect of exchange rates on cash and cash equivalents (2)  
Increase (decrease) in cash and cash equivalents (21) 47
Cash and cash equivalents at beginning of period 141 111
Cash and cash equivalents at end of period 120 158
HD Supply, Inc
   
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net income (loss) (152) (466)
Reconciliation of net income (loss) to net cash provided by (used in) operating activities:    
Depreciation and amortization 184 255
Provision for uncollectibles 4 3
Non-cash interest expense 23 86
Payment of PIK interest & discounts upon extinguishment of debt (364)  
Loss on extinguishment & modification of debt 87 220
Stock-based compensation expense 12 13
Deferred income taxes 35 27
Gain on sale of a business   (12)
Other (2) 1
Changes in assets and liabilities:    
(Increase) decrease in receivables (226) (215)
(Increase) decrease in inventories (87) (197)
(Increase) decrease in other current assets 4 (4)
(Increase) decrease in other assets   2
Increase (decrease) in accounts payable and accrued liabilities (42) (46)
Increase (decrease) in other long-term liabilities 14 6
Net cash provided by (used in) operating activities (510) (327)
CASH FLOWS FROM INVESTING ACTIVITIES:    
Capital expenditures (96) (80)
Proceeds from sales of property and equipment 6 5
Proceeds from sale of investments 936  
Purchase of investments   (985)
Proceeds from sale of a business   481
(Payment) settlement for acquisition of a business, net of cash acquired 2 (196)
Other investing activities   (2)
Net cash provided by (used in) investing activities 848 (777)
CASH FLOWS FROM FINANCING ACTIVITIES:    
Equity contribution from parent 1,039  
Borrowings of long-term debt 79 4,140
Repayments of long-term debt (1,621) (3,290)
Borrowings on long-term revolver debt 736 1,192
Repayments on long-term revolver debt (556) (797)
Debt issuance and modification fees (34) (95)
Other financing activities   1
Net cash provided by (used in) financing activities (357) 1,151
Effect of exchange rates on cash and cash equivalents (2)  
Increase (decrease) in cash and cash equivalents (21) 47
Cash and cash equivalents at beginning of period 141 111
Cash and cash equivalents at end of period $ 120 $ 158