XML 83 R15.htm IDEA: XBRL DOCUMENT v2.4.1.9
Long-Term Debt
12 Months Ended
Dec. 31, 2014
Debt Disclosure [Abstract]  
Long-Term Debt
Long-Term Debt
Long-term debt was as follows:
(dollars in millions)
 
 
December 31,
 
Interest Rate (1)
 
2014
 
2013
Senior secured asset-based revolving credit facility
%
 
$

 
$

Senior secured term loan facility
3.25
%
 
1,513.5

 
1,528.9

Unamortized discount on senior secured term loan facility
 
 
(3.7
)
 
(4.4
)
Senior secured notes due 2018
%
 

 
325.0

Senior notes due 2019
8.5
%
 
503.9

 
1,305.0

Unamortized premium on senior notes due 2019
 
 
1.3

 
4.2

Senior notes due 2022
6.0
%
 
600.0

 

Senior notes due 2024
5.5
%
 
575.0

 

Senior subordinated notes due 2017
%
 

 
92.5

Total long-term debt
 
 
3,190.0

 
3,251.2

Less current maturities of long-term debt
 
 
(15.4
)
 
(45.4
)
Long-term debt, excluding current maturities
 
 
$
3,174.6

 
$
3,205.8

(1)Interest rate at December 31, 2014.
At December 31, 2014, the Company was in compliance with the covenants under its various credit agreements and indentures as described below. Under the indenture governing the 8.5% Senior Notes due 2019, which contains the most restrictive restricted payment provisions in the Company’s various credit agreements and indentures, CDW LLC and its restricted subsidiaries are generally restricted from paying dividends and making other restricted payments. For the purpose of determining restricted payment capacity, consolidated net income or loss includes certain adjustments that are defined in the applicable indenture. At December 31, 2014, the amount of cumulative consolidated net income free of restrictions under the credit agreements and indentures ("Restricted Payment Capacity") was $230.3 million.
Senior Secured Asset-Based Revolving Credit Facility (“Revolving Loan”)
At December 31, 2014, the Company had no outstanding borrowings under the Revolving Loan, $2.1 million of undrawn letters of credit and $312.3 million reserved related to the floorplan sub-facility.
On June 6, 2014, the Company entered into the Revolving Loan, a new five-year $1,250.0 million senior secured asset-based revolving credit facility, with the facility being available to the Company for borrowings, issuance of letters of credit and floorplan financing for certain vendor products. The Revolving Loan matures on June 6, 2019, subject to an acceleration provision discussed below. The Revolving Loan replaces the Company’s previous revolving loan credit facility that was to mature on June 24, 2016. The Revolving Loan (i) increases the overall revolving credit facility capacity available to the Company from $900.0 million to $1,250.0 million, (ii) increases the maximum aggregate amount of increases that may be made to the revolving credit facility from $200.0 million to $300.0 million, (iii) maintains a maturity acceleration provision based upon excess cash availability whereby the Revolving Loan may mature 45 days prior to the final maturity of any then outstanding senior debt if excess cash availability does not exceed the outstanding borrowings of the subject maturing debt at the time of the test plus $150.0 million, (iv) decreases the fee on the unused portion of the revolving credit facility from either 37.5 or 50 basis points, depending on the amount of utilization, to 25 basis points, (v) decreases the applicable interest rate margin by 50 basis points, and (vi) amends the existing inventory floorplan sub-facility as discussed below. In connection with the termination of the previous facility, the Company recorded a loss on extinguishment of long-term debt of $0.4 million in the consolidated statement of operations for the year ended December 31, 2014, representing a write-off of a portion of unamortized deferred financing costs. Fees of $6.4 million related to the Revolving Loan were capitalized as deferred financing costs and are being amortized over the five-year term of the facility on a straight-line basis.
The Revolving Loan incorporates the previous inventory floorplan sub-facility and related Revolving Loan inventory financing agreement while removing the previous $400.0 million limit on the size of the floorplan sub-facility and the in-transit reserve of 15% of open orders. At December 31, 2014, the financial intermediary reported an outstanding balance of $312.3 million under the Revolving Loan inventory financing agreement. The amount included on the Company's consolidated balance sheet as of December 31, 2014 as accounts payable-inventory financing related to the Revolving Loan inventory financing agreement of $330.1 million includes a $17.8 million accrual for amounts in transit.
Borrowings under the Revolving Loan bear interest at a variable interest rate plus an applicable margin. The interest rate margin is based on one of two indices, either (i) LIBOR, or (ii) the Alternate Base Rate (“ABR”) with the ABR being the greater of (a) the prime rate, (b) the federal funds effective rate plus 50 basis points or (c) the one-month LIBOR plus 1.00%. The applicable margin varies (1.50% to 2.00% for LIBOR borrowings and 0.50% to 1.00% for ABR borrowings) depending upon average daily excess cash availability under the agreement evidencing the Revolving Loan and is subject to a reduction of 0.25% if, and for as long as, CDW LLC's corporate credit rating from Standard & Poor’s Rating Services is BB or better and CDW LLC's corporate family rating from Moody’s Investors Service, Inc. is Ba3 or better (in each case with stable or better outlook).
Under the new Revolving Loan, the Company is permitted to borrow an aggregate amount of $1,250.0 million; however, its ability to borrow under the Revolving Loan is limited by a borrowing base. The borrowing base is (a) the sum of the products of the applicable advance rates on eligible accounts receivable and on eligible inventory as defined in the agreement less (b) any reserves. At December 31, 2014, the borrowing base was $1,253.4 million based on the amount of eligible inventory and accounts receivable balances as of November 30, 2014. The Company could have borrowed up to an additional $935.6 million under the Revolving Loan at December 31, 2014.
The ability to borrow under the Revolving Loan also remains limited by a minimum liquidity condition which provides that, if excess cash availability is less than the lesser of (i) $125.0 million and (ii) the greater of (A) 10.0% of the borrowing base and (B) $100.0 million, the lenders are not required to lend any additional amounts under the Revolving Loan unless the consolidated fixed charge coverage ratio (as described in the agreement evidencing the Revolving Loan) is at least 1.00 to 1.00.
CDW LLC is the borrower under the Revolving Loan. All obligations under the Revolving Loan are guaranteed by Parent and each of CDW LLC's direct and indirect, 100% owned, domestic subsidiaries. Borrowings under the Revolving Loan are collateralized by a first priority interest in inventory (excluding inventory collateralized under the inventory floorplan arrangements as described in Note 5), deposits, and accounts receivable, and a second priority interest in substantially all other assets. The Revolving Loan contains negative covenants that, among other things, place restrictions and limitations on the ability of Parent and each of CDW LLC's direct and indirect, 100% owned, domestic subsidiaries to dispose of assets, incur additional indebtedness, incur guarantee obligations, prepay other indebtedness, make distributions or other restricted payments, create liens, make equity or debt investments, make acquisitions, engage in mergers or consolidations, or engage in certain transactions with affiliates. The Revolving Loan also includes maintenance of a minimum average daily excess cash availability requirement. Should the Company fall below the minimum average daily excess cash availability requirement for five consecutive business days, the Company becomes subject to a fixed charge coverage ratio until such time as the daily excess cash availability requirement is met for 30 consecutive business days.
Senior Secured Term Loan Facility
On April 29, 2013, the Company entered into a seven-year, $1,350.0 million aggregate principal amount senior secured term loan facility (the "Term Loan"). The Term Loan was issued at a price that was 99.75% of par, which resulted in a discount of $3.4 million. Substantially all of the proceeds from the Term Loan were used to repay the $1,299.5 million outstanding aggregate principal amount of the prior senior secured term loan facility (the "Prior Term Loan Facility"). In connection with this refinancing, the Company recorded a loss on extinguishment of long-term debt of $10.3 million in the consolidated statement of operations for the year ended December 31, 2013. This loss represented a write-off of the remaining unamortized deferred financing costs related to the Prior Term Loan Facility.
On July 31, 2013, the Company borrowed an additional $190.0 million aggregate principal amount under the Term Loan at a price that was 99.25% of par, which resulted in a discount of $1.4 million. Such proceeds were used to redeem a portion of outstanding Senior Subordinated Notes. The discounts are reported on the consolidated balance sheet as a reduction to the face amount of the Term Loan and are being amortized to interest expense over the term of the related debt. Fees of $6.1 million related to the Term Loan were capitalized as deferred financing costs and are being amortized over the term of the facility using the effective interest method.
The Company is required to pay quarterly principal installments equal to 0.25% of the original principal amount of the Term Loan, with the remaining principal amount payable on the maturity date of April 29, 2020. The quarterly principal installment payments commenced during the quarter ended June 30, 2013. At December 31, 2014, the outstanding principal amount of the Term Loan was $1,513.5 million, excluding $3.7 million in unamortized discount.
Borrowings under the Term Loan bear interest at either (a) the alternate base rate ("ABR") plus a margin or (b) LIBOR plus a margin; provided that for the purposes of the Term Loan, LIBOR shall not be less than 1.00% per annum at any time ("LIBOR Floor"). The margin is based upon a net leverage ratio as defined in the agreement governing the Term Loan, ranging from 1.25% to 1.50% for ABR borrowings and 2.25% to 2.50% for LIBOR borrowings. The total net leverage ratio was 3.1 at December 31, 2014. An interest rate of 3.25%, LIBOR Floor plus a 2.25% margin, was in effect during the three-month period ended December 31, 2014.
In order to manage the risk associated with changes in interest rates on borrowings under the Term Loan, the Company has entered into interest rate cap agreements. The Company had ten interest rate cap agreements in effect through January 14, 2015 with a combined notional amount of $1,150.0 million which entitled the Company to payments from the counterparty of the amount, if any, by which three-month LIBOR exceeds a weighted average rate of 2.4% during the agreement period. The fair value of these interest rate cap agreements was zero at both December 31, 2014 and 2013.
In connection with the expiration of the ten interest rate cap agreements noted above, during the year ended December 31, 2014, the Company entered into 14 additional interest rate cap agreements with a combined notional amount of $1,000.0 million. Under these agreements, the Company made premium payments totaling $2.1 million to the counterparties in exchange for the right to receive payments equal to the amount, if any, by which three-month LIBOR exceeds 2.0% during the agreement period. These interest rate cap agreements are effective from January 14, 2015 through January 14, 2017. The fair value of these interest rate cap agreements was $1.7 million at December 31, 2014.
The Company's interest rate cap agreements have not been designated as cash flow hedges of interest rate risk for GAAP accounting purposes. The interest rate cap agreements are recorded at fair value on the Company’s consolidated balance sheet in Other Assets each period, with changes in fair value recorded directly to interest expense in the Company’s consolidated statements of operations. The fair value of the Company’s interest rate cap agreements is classified as Level 2 in the fair value hierarchy. The valuation of the interest rate cap agreements is derived by using a discounted cash flow analysis on the expected cash receipts that would occur if variable interest rates rise above the strike rates of the caps. This analysis reflects the contractual terms of the interest rate cap agreements, including the period to maturity, and uses observable market-based inputs, including LIBOR curves and implied volatilities. The Company also incorporates insignificant credit valuation adjustments to appropriately reflect the respective counterparty’s nonperformance risk in the fair value measurements. The counterparty credit spreads are based on publicly available credit information obtained from a third party credit data provider.
See Note 20 for a description of the interest rate cap agreements entered into during the first quarter of 2015.
On January 30, 2013, the Company made an optional prepayment of $40.0 million aggregate principal amount outstanding under the Prior Term Loan Facility. The optional prepayment satisfied the excess cash flow payment provision of the Prior Term Loan Facility with respect to the year ended December 31, 2012.
CDW LLC is the borrower under the Term Loan. All obligations under the Term Loan are guaranteed by Parent and each of CDW LLC's direct and indirect, 100% owned, domestic subsidiaries. The Term Loan is collateralized by a second priority interest in substantially all inventory (excluding inventory collateralized under the inventory floorplan arrangements as described in Note 5), deposits, and accounts receivable, and by a first priority interest in substantially all other assets. The Term Loan contains negative covenants that, among other things, place restrictions and limitations on the ability of Parent and each of CDW LLC's direct and indirect, 100% owned, domestic subsidiaries to dispose of assets, incur additional indebtedness, incur guarantee obligations, prepay other indebtedness, make distributions or other restricted payments, create liens, make equity or debt investments, make acquisitions, engage in mergers or consolidations, or engage in certain transactions with affiliates.
8.0% Senior Secured Notes due 2018 (“Senior Secured Notes”)
At December 31, 2014, there were no outstanding Senior Secured Notes.
On August 5, 2014, the proceeds from the issuance of the 2022 Senior Notes discussed below, along with cash on hand, were deposited with the trustee to redeem all of the remaining $325.0 million aggregate principal amount of the Senior Secured Notes at a redemption price of 106.061% of the principal amount redeemed, plus accrued and unpaid interest through the date of redemption. On the same date, the indenture governing the Senior Secured Notes was satisfied and discharged. The redemption date was September 5, 2014. In connection with this redemption, the Company recorded a loss on extinguishment of long-term debt of $23.7 million in the consolidated statement of operations for the year ended December 31, 2014, which was comprised of $4.0 million for the write-off of the unamortized deferred financing fees, a redemption premium of $13.0 million and a make-whole interest payment of $6.7 million.
On July 2, 2013, the Company used a portion of the net proceeds from the IPO to redeem $175.0 million aggregate principal amount of Senior Secured Notes. The redemption price of the Senior Secured Notes was 108.0% of the principal amount redeemed, plus $0.7 million of accrued and unpaid interest to the date of redemption. The Company used cash on hand to pay such accrued and unpaid interest. In connection with this redemption, the Company recorded a loss on extinguishment of long-term debt of $16.7 million in the consolidated statement of operations for the year ended December 31, 2013. This loss represented $14.0 million in redemption premium and $2.7 million for the write-off of a portion of the remaining deferred financing costs related to the Senior Secured Notes.
8.5% Senior Notes due 2019 (“2019 Senior Notes”)
At December 31, 2014, the outstanding principal amount of 2019 Senior Notes was $503.9 million, excluding $1.3 million in unamortized premium. The 2019 Senior Notes mature on April 1, 2019.
On December 1, 2014, the proceeds from the issuance of the 2024 Senior Notes discussed below, along with cash on hand, were deposited with the trustee to redeem $541.4 million aggregate principal amount of the 2019 Senior Notes at a redemption price of 106.202% of the principal amount redeemed, plus accrued and unpaid interest through the date of redemption. The redemption date was December 31, 2014. In connection with this redemption, the Company recorded a loss on extinguishment of long-term debt of $36.9 million in the consolidated statement of operations for the year ended December 31, 2014, which was comprised of $4.7 million for the write-off of a portion of the unamortized deferred financing fees, a redemption premium of $23.0 million, and a make-whole interest payment of $10.6 million, partially offset by $1.4 million for the write-off of a portion of the unamortized premium.
On August 5, 2014, the proceeds from the issuance of the 2022 Senior Notes discussed below, along with cash on hand, were deposited with the trustee to redeem $234.7 million aggregate principal amount of the 2019 Senior Notes at a redemption price of 108.764% of the principal amount redeemed, plus accrued and unpaid interest through the date of redemption. The redemption date was September 5, 2014. In connection with this redemption, the Company recorded a loss on extinguishment of long-term debt of $22.1 million in the consolidated statement of operations for the year ended December 31, 2014, which was comprised of $2.2 million for the write-off of a portion of the unamortized deferred financing fees, a redemption premium of $10.0 million, and a make-whole interest payment of $10.6 million, partially offset by $0.7 million for the write-off of a portion of the unamortized premium.
On March 20, 2014, the Company repurchased and subsequently canceled $25.0 million aggregate principal amount of the 2019 Senior Notes from an affiliate of Providence Equity in a privately negotiated transaction on an arms' length basis at a price of 109.75% of the principal amount. Cash on hand was used to fund the repurchase of $25.0 million aggregate principal amount, $2.4 million of repurchase premium and $1.0 million in accrued and unpaid interest to the date of repurchase. In connection with this repurchase, the Company recorded a loss on extinguishment of long-term debt of $2.7 million in the Company's consolidated statement of operations for the year ended December 31, 2014. This loss represented $2.4 million in repurchase premium and $0.3 million for the write-off of a portion of the unamortized deferred financing costs related to the 2019 Senior Notes.
CDW LLC and CDW Finance Corporation are the co-issuers of the 2019 Senior Notes. Obligations under the 2019 Senior Notes are guaranteed on an unsecured senior basis by Parent and each of CDW LLC's direct and indirect, 100% owned, domestic subsidiaries. The 2019 Senior Note indenture contains negative covenants that, among other things, place restrictions and limitations on the ability of Parent and each of CDW LLC's direct and indirect, 100% owned, domestic subsidiaries to dispose of assets, incur additional indebtedness, incur guarantee obligations, prepay other indebtedness, make distributions or other restricted payments, create liens, make equity or debt investments, make acquisitions, engage in mergers or consolidations, or engage in certain transactions with affiliates. The 2019 Senior Notes do not contain any financial covenants.
6.0% Senior Notes due 2022 ("2022 Senior Notes")
On August 5, 2014, CDW LLC and CDW Finance Corporation, as co-issuers, completed the issuance of $600.0 million aggregate principal amount of 2022 Senior Notes at par. Fees of $8.0 million related to the 2022 Senior Notes were capitalized as deferred financing costs and are being amortized over the term of the notes on a straight-line basis. The 2022 Senior Notes will mature on August 15, 2022 and bear interest at a rate of 6.00% per annum, payable semi-annually on February 15 and August 15 of each year. The first interest payment date was February 15, 2015.
CDW LLC and CDW Finance Corporation are the co-issuers of the 2022 Senior Notes and the obligations under the notes are guaranteed by Parent and each of CDW LLC's direct and indirect, wholly owned, domestic subsidiaries. The 2022 Senior Notes indenture contains negative covenants that, among other things, place restrictions and limitations on the ability of Parent and each of CDW LLC's direct and indirect, 100% owned, domestic subsidiaries to enter into sale and lease-back transactions, incur additional secured indebtedness, and create liens. The indenture governing the 2022 Senior Notes does not contain any financial covenants.
5.5% Senior Notes due 2024 ("2024 Senior Notes")
On December 1, 2014, CDW LLC and CDW Finance Corporation, as co-issuers, completed the issuance of $575.0 million aggregate principal amount of 2024 Senior Notes at par. Fees of $7.5 million related to the 2024 Senior Notes were capitalized as deferred financing costs and are being amortized over the term of the notes on a straight-line basis. The 2024 Senior Notes will mature on December 1, 2024 and bear interest at a rate of 5.50% per annum, payable semi-annually on June 1 and December 1 of each year. The first interest payment date will be June 1, 2015.
CDW LLC and CDW Finance Corporation are the co-issuers of the 2024 Senior Notes and the obligations under the notes are guaranteed by Parent and each of CDW LLC's direct and indirect, wholly owned, domestic subsidiaries. The 2024 Senior Notes indenture contains negative covenants that, among other things, place restrictions and limitations on the ability of Parent and each of CDW LLC's direct and indirect, 100% owned, domestic subsidiaries to enter into sale and lease-back transactions, incur additional secured indebtedness, and create liens. The indenture governing the 2024 Senior Notes does not contain any financial covenants.
12.535% Senior Subordinated Exchange Notes due 2017 (“Senior Subordinated Notes”)
At December 31, 2014, there were no outstanding Senior Subordinated Notes.
On May 9, 2014, the Company redeemed all of the remaining $42.5 million aggregate principal amount of Senior Subordinated Notes at a redemption price that was 104.178% of the principal amount redeemed. Cash on hand was used to fund the redemption of $42.5 million aggregate principal amount, $1.8 million in redemption premium and $0.4 million in accrued and unpaid interest to the date of redemption. In connection with this redemption, the Company recorded a loss on extinguishment of long-term debt of $2.2 million in the consolidated statement of operations for the year ended December 31, 2014. This loss represented $1.8 million in redemption premium and $0.4 million for the write-off of the remaining deferred financing costs related to the Senior Subordinated Notes.
On January 22, 2014 and February 21, 2014, the Company redeemed $30.0 million and $20.0 million aggregate principal amounts of Senior Subordinated Notes, respectively, at redemption prices that were 104.178% of the principal amounts redeemed. Cash on hand was used to fund the redemptions of $50.0 million aggregate principal amount, $2.1 million in redemption premiums and $1.9 million in aggregate accrued and unpaid interest to the dates of redemption. In connection with these redemptions, the Company recorded a loss on extinguishment of long-term debt of $2.7 million in the consolidated statement of operations for the year ended December 31, 2014. This loss represented $2.1 million in redemption premiums and $0.6 million for the write-off of a portion of the remaining deferred financing costs related to the Senior Subordinated Notes.
On October 18, 2013, the Company redeemed $155.0 million aggregate principal amount of Senior Subordinated Notes at a redemption price that was 104.178% of the principal amount redeemed. A combination of cash on hand and the net proceeds from the sale of shares of common stock related to the underwriters' exercise in full of the overallotment option granted to them in connection with the IPO, in the amount of $56.0 million, was used to fund the redemption of $155.0 million aggregate principal amount, $6.5 million of redemption premium and $0.2 million in accrued and unpaid interest to the date of redemption. See Note 9 for additional discussion of the underwriters' overallotment option. In connection with this redemption, the Company recorded a loss on extinguishment of long-term debt of $8.5 million in the Company's consolidated statement of operations for the year ended December 31, 2013. This loss represented $6.5 million in redemption premium and $2.0 million for the write-off of a portion of the remaining unamortized deferred financing costs related to the Senior Subordinated Notes.
On August 1, 2013, the Company redeemed $324.0 million aggregate principal amount of Senior Subordinated Notes at a redemption price that was 106.268% of the principal amount redeemed. The Company used a portion of the net proceeds from the IPO to redeem $146.0 million aggregate principal amount of Senior Subordinated Notes and incremental borrowings of $190.0 million under the Term Loan to redeem $178.0 million aggregate principal amount of Senior Subordinated Notes. The Company used cash on hand to pay $12.0 million of accrued and unpaid interest to the date of redemption. In connection with this redemption, the Company recorded a loss on extinguishment of long-term debt of $24.6 million in the consolidated statement of operations for the year ended December 31, 2013. This loss represented $20.3 million in redemption premium and $4.3 million for the write-off of a portion of the remaining deferred financing costs related to the Senior Subordinated Notes.
On March 8, 2013, the Company redeemed $50.0 million aggregate principal amount of Senior Subordinated Notes at a redemption price that was 106.268% of the principal amount redeemed. Cash on hand was used to fund the redemption of $50.0 million aggregate principal amount, $3.1 million of redemption premium and $2.5 million in accrued and unpaid interest to the date of redemption. In connection with this redemption, the Company recorded a loss on extinguishment of long-term debt of $3.9 million in the Company's consolidated statement of operations for the year ended December 31, 2013. This loss represented $3.1 million in redemption premium and $0.8 million for the write-off of a portion of the remaining unamortized deferred financing costs related to the Senior Subordinated Notes.
Long-Term Debt Maturities
As of December 31, 2014, the maturities of long-term debt were as follows:
(in millions)
 
Years ending December 31,
 
2015
$
15.4

2016

2017

2018

2019
503.9

Thereafter
2,673.1

 
$
3,192.4


Fair Value
The fair value of the Company's long-term debt instruments at December 31, 2014 was $3,208.7 million. The fair value of the 2019 Senior Notes, the 2022 Senior Notes, and the 2024 Senior Notes was estimated using quoted market prices for identical assets or liabilities that are traded in over-the-counter secondary markets that are not considered active. The fair value of the Term Loan was estimated using dealer quotes for identical assets or liabilities in markets that are not considered active. Consequently, the Company's long-term debt is classified as Level 2 within the fair value hierarchy.
At December 31, 2014, the carrying value of the Company's long-term debt was $3,192.4 million, excluding $1.3 million in unamortized premium and $3.7 million in unamortized discount.
Deferred Financing Costs
The following table summarizes the deferred financing costs activity for the years ended December 31, 2014 and 2013:
(in millions)
December 31,
 
2014
 
2013
Beginning balance
$
30.1

 
$
53.2

Additional costs capitalized
21.9

 
6.1

Recognized in interest expense
(6.4
)
 
(9.1
)
Write-off of unamortized deferred financing costs
(12.6
)
 
(20.1
)
Ending balance
$
33.0

 
$
30.1



As of December 31, 2014 and December 31, 2013, the weighted-average remaining life of unamortized deferred financing costs was 6.6 and 4.9 years, respectively.