XML 28 R9.htm IDEA: XBRL DOCUMENT v2.4.1.9
CONSOLIDATED STATEMENTS OF CASH FLOWS (HD Supply, Inc.) (USD $)
In Millions, unless otherwise specified
3 Months Ended
May 03, 2015
May 04, 2014
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net income (loss) $ 242us-gaap_NetIncomeLoss $ (12)us-gaap_NetIncomeLoss
Reconciliation of net income (loss) to net cash provided by (used in) operating activities:    
Depreciation and amortization 36us-gaap_DepreciationDepletionAndAmortization 63us-gaap_DepreciationDepletionAndAmortization
Provision for uncollectibles 1us-gaap_ProvisionForDoubtfulAccounts 3us-gaap_ProvisionForDoubtfulAccounts
Non-cash interest expense 7hds_NonCashInterestExpense 6hds_NonCashInterestExpense
Payment of PIK interest & discounts upon extinguishment of debt (1)hds_DebtDiscountAndPaidInKindInterest (1)hds_DebtDiscountAndPaidInKindInterest
Loss on extinguishment & modification of debt   2hds_GainsLossesOnExtinguishmentAndModificationOfDebt
Stock-based compensation expense 5us-gaap_ShareBasedCompensation 5us-gaap_ShareBasedCompensation
Deferred income taxes 6us-gaap_DeferredIncomeTaxesAndTaxCredits  
Other (2)us-gaap_OtherOperatingActivitiesCashFlowStatement 1us-gaap_OtherOperatingActivitiesCashFlowStatement
Changes in assets and liabilities:    
(Increase) decrease in receivables (76)us-gaap_IncreaseDecreaseInReceivables (108)us-gaap_IncreaseDecreaseInReceivables
(Increase) decrease in inventories (112)us-gaap_IncreaseDecreaseInInventories (108)us-gaap_IncreaseDecreaseInInventories
(Increase) decrease in other current assets (14)us-gaap_IncreaseDecreaseInOtherCurrentAssets 5us-gaap_IncreaseDecreaseInOtherCurrentAssets
Increase (decrease) in accounts payable and accrued liabilities 66us-gaap_IncreaseDecreaseInAccountsPayableAndAccruedLiabilities 22us-gaap_IncreaseDecreaseInAccountsPayableAndAccruedLiabilities
Increase (decrease) in other long-term liabilities (182)us-gaap_IncreaseDecreaseInOtherNoncurrentLiabilities 3us-gaap_IncreaseDecreaseInOtherNoncurrentLiabilities
Net cash provided by (used in) operating activities (23)us-gaap_NetCashProvidedByUsedInOperatingActivities (119)us-gaap_NetCashProvidedByUsedInOperatingActivities
CASH FLOWS FROM INVESTING ACTIVITIES:    
Capital expenditures (24)us-gaap_PaymentsToAcquireProductiveAssets (28)us-gaap_PaymentsToAcquireProductiveAssets
Proceeds from sales of property and equipment 1us-gaap_ProceedsFromSaleOfPropertyPlantAndEquipment  
Net cash provided by (used in) investing activities (23)us-gaap_NetCashProvidedByUsedInInvestingActivities (28)us-gaap_NetCashProvidedByUsedInInvestingActivities
CASH FLOWS FROM FINANCING ACTIVITIES:    
Borrowings of long-term debt   20us-gaap_ProceedsFromIssuanceOfLongTermDebt
Repayments of long-term debt (16)us-gaap_RepaymentsOfLongTermDebt (22)us-gaap_RepaymentsOfLongTermDebt
Borrowings on long-term revolver debt 307us-gaap_ProceedsFromLongTermLinesOfCredit 275us-gaap_ProceedsFromLongTermLinesOfCredit
Repayments on long-term revolver debt (188)us-gaap_RepaymentsOfLongTermLinesOfCredit (85)us-gaap_RepaymentsOfLongTermLinesOfCredit
Debt issuance and modification costs   (3)us-gaap_PaymentsOfDebtIssuanceCosts
Other financing activities   (1)us-gaap_ProceedsFromPaymentsForOtherFinancingActivities
Net cash provided by (used in) financing activities 114us-gaap_NetCashProvidedByUsedInFinancingActivities 204us-gaap_NetCashProvidedByUsedInFinancingActivities
Effect of exchange rates on cash and cash equivalents 2us-gaap_EffectOfExchangeRateOnCashAndCashEquivalents 1us-gaap_EffectOfExchangeRateOnCashAndCashEquivalents
Increase (decrease) in cash and cash equivalents 70us-gaap_CashAndCashEquivalentsPeriodIncreaseDecrease 58us-gaap_CashAndCashEquivalentsPeriodIncreaseDecrease
Cash and cash equivalents at beginning of period 85us-gaap_CashAndCashEquivalentsAtCarryingValue 115us-gaap_CashAndCashEquivalentsAtCarryingValue
Cash and cash equivalents at end of period 155us-gaap_CashAndCashEquivalentsAtCarryingValue 173us-gaap_CashAndCashEquivalentsAtCarryingValue
HD Supply, Inc    
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net income (loss) 242us-gaap_NetIncomeLoss
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
(12)us-gaap_NetIncomeLoss
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
Reconciliation of net income (loss) to net cash provided by (used in) operating activities:    
Depreciation and amortization 36us-gaap_DepreciationDepletionAndAmortization
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
63us-gaap_DepreciationDepletionAndAmortization
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
Provision for uncollectibles 1us-gaap_ProvisionForDoubtfulAccounts
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
3us-gaap_ProvisionForDoubtfulAccounts
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
Non-cash interest expense 7hds_NonCashInterestExpense
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
6hds_NonCashInterestExpense
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
Payment of PIK interest & discounts upon extinguishment of debt   (1)hds_DebtDiscountAndPaidInKindInterest
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
Loss on extinguishment & modification of debt   2hds_GainsLossesOnExtinguishmentAndModificationOfDebt
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
Stock-based compensation expense 5us-gaap_ShareBasedCompensation
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
5us-gaap_ShareBasedCompensation
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
Deferred income taxes 6us-gaap_DeferredIncomeTaxesAndTaxCredits
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
 
Other (2)us-gaap_OtherOperatingActivitiesCashFlowStatement
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
1us-gaap_OtherOperatingActivitiesCashFlowStatement
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
Changes in assets and liabilities:    
(Increase) decrease in receivables (76)us-gaap_IncreaseDecreaseInReceivables
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
(108)us-gaap_IncreaseDecreaseInReceivables
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
(Increase) decrease in inventories (112)us-gaap_IncreaseDecreaseInInventories
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
(108)us-gaap_IncreaseDecreaseInInventories
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
(Increase) decrease in other current assets (14)us-gaap_IncreaseDecreaseInOtherCurrentAssets
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
5us-gaap_IncreaseDecreaseInOtherCurrentAssets
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
Increase (decrease) in accounts payable and accrued liabilities 66us-gaap_IncreaseDecreaseInAccountsPayableAndAccruedLiabilities
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
22us-gaap_IncreaseDecreaseInAccountsPayableAndAccruedLiabilities
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
Increase (decrease) in other long-term liabilities (182)us-gaap_IncreaseDecreaseInOtherNoncurrentLiabilities
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
3us-gaap_IncreaseDecreaseInOtherNoncurrentLiabilities
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
Net cash provided by (used in) operating activities (23)us-gaap_NetCashProvidedByUsedInOperatingActivities
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
(119)us-gaap_NetCashProvidedByUsedInOperatingActivities
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
CASH FLOWS FROM INVESTING ACTIVITIES:    
Capital expenditures (24)us-gaap_PaymentsToAcquireProductiveAssets
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
(28)us-gaap_PaymentsToAcquireProductiveAssets
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
Proceeds from sales of property and equipment 1us-gaap_ProceedsFromSaleOfPropertyPlantAndEquipment
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
 
Net cash provided by (used in) investing activities (23)us-gaap_NetCashProvidedByUsedInInvestingActivities
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
(28)us-gaap_NetCashProvidedByUsedInInvestingActivities
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
CASH FLOWS FROM FINANCING ACTIVITIES:    
Borrowings of long-term debt   20us-gaap_ProceedsFromIssuanceOfLongTermDebt
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
Repayments of long-term debt (16)us-gaap_RepaymentsOfLongTermDebt
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
(22)us-gaap_RepaymentsOfLongTermDebt
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
Borrowings on long-term revolver debt 307us-gaap_ProceedsFromLongTermLinesOfCredit
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
275us-gaap_ProceedsFromLongTermLinesOfCredit
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
Repayments on long-term revolver debt (188)us-gaap_RepaymentsOfLongTermLinesOfCredit
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
(85)us-gaap_RepaymentsOfLongTermLinesOfCredit
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
Debt issuance and modification costs   (3)us-gaap_PaymentsOfDebtIssuanceCosts
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
Other financing activities   (1)us-gaap_ProceedsFromPaymentsForOtherFinancingActivities
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
Net cash provided by (used in) financing activities 103us-gaap_NetCashProvidedByUsedInFinancingActivities
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
184us-gaap_NetCashProvidedByUsedInFinancingActivities
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
Effect of exchange rates on cash and cash equivalents 2us-gaap_EffectOfExchangeRateOnCashAndCashEquivalents
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
1us-gaap_EffectOfExchangeRateOnCashAndCashEquivalents
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
Increase (decrease) in cash and cash equivalents 59us-gaap_CashAndCashEquivalentsPeriodIncreaseDecrease
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
38us-gaap_CashAndCashEquivalentsPeriodIncreaseDecrease
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
Cash and cash equivalents at beginning of period 85us-gaap_CashAndCashEquivalentsAtCarryingValue
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
111us-gaap_CashAndCashEquivalentsAtCarryingValue
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
Cash and cash equivalents at end of period $ 144us-gaap_CashAndCashEquivalentsAtCarryingValue
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember
$ 149us-gaap_CashAndCashEquivalentsAtCarryingValue
/ dei_LegalEntityAxis
= us-gaap_SubsidiariesMember