Long-Term Debt | 12 Months Ended |
Dec. 31, 2012 |
Debt Disclosure [Abstract] | ' |
Long-Term Debt | ' |
Long-Term Debt |
Long-term debt was as follows: |
|
| | | | | | | | | | |
(dollars in millions) | | | December 31, |
| Interest Rate (1) | | 2012 | | 2011 |
Senior secured asset-based revolving credit facility | — | % | | $ | — | | | $ | — | |
|
Senior secured term loan facility | 3.9 | % | | 1,339.50 | | | 1,540.50 | |
|
Senior secured notes due 2018 | 8 | % | | 500 | | | 500 | |
|
Senior notes due 2019 | 8.5 | % | | 1,305.00 | | | 1,175.00 | |
|
Unamortized premium on senior notes due 2019 | | | 5 | | | — | |
|
Senior subordinated notes due 2017 | 12.535 | % | | 621.5 | | | 721.5 | |
|
Senior notes due 2015 | — | % | | — | | | 129 | |
|
Total long-term debt | | | 3,771.00 | | | 4,066.00 | |
|
Less current maturities of long-term debt | | | (40.0 | ) | | (201.0 | ) |
Long-term debt, excluding current maturities | | | $ | 3,731.00 | | | $ | 3,865.00 | |
|
(1)Weighted-average interest rate as of December 31, 2012. |
As of December 31, 2012, the Company was in compliance with the covenants under its various credit agreements and indentures as described below. Under the indentures governing the Senior Notes and Senior Secured Notes, which contain 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 unless CDW LLC could incur an additional dollar of indebtedness under its fixed charges ratio covenant and the amount of such dividend or other restricted payment, together with the amount of all other dividends and restricted payments made from January 1, 2011 through the end of the most recently ended fiscal quarter, is less than 50% of consolidated net income (less 100% of any consolidated net loss), adjusted for certain items, plus the amount of certain other items occurring during that period that increase (and in some cases decrease) the amounts available for such payments. At December 31, 2012, the amount of consolidated net income free of restrictions under the credit agreements and indentures was $146.7 million. |
Senior Secured Asset-Based Revolving Credit Facility (“Revolving Loan”) |
At December 31, 2012, the Company had no outstanding borrowings under the Revolving Loan, $1.7 million of undrawn letters of credit and $275.9 million reserved related to the floorplan sub-facility. |
On June 24, 2011, the Company entered into the Revolving Loan, a new five-year $900.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 24, 2016, subject to an acceleration provision discussed below. The Revolving Loan replaced the Company's previous revolving loan credit facility that was to mature on October 12, 2012. The Revolving Loan (i) increased the overall revolving credit facility capacity available to the Company from $800.0 million to $900.0 million, (ii) increased the maximum aggregate amount of increases that may be made to the revolving credit facility from $100.0 million to $200.0 million, (iii) added a maturity acceleration provision based upon excess cash availability whereby the Revolving Loan may mature 45 days prior to the maturity of the non-extended portion of the Company's senior secured term loan facility, 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) increased the fee on the unused portion of the revolving credit facility from 25 basis points to either 37.5 or 50 basis points, depending on the amount of utilization, (v) increased the applicable interest rate margin, and (vi) incorporated a $300.0 million floorplan sub-facility, which was increased to $400.0 million on August 2, 2011. In connection with the termination of the previous facility, the Company recorded a loss on extinguishment of long-term debt of $1.6 million in the Company's consolidated statement of operations for the year ended December 31, 2011, representing a write-off of a portion of unamortized deferred financing costs. Fees of $7.2 million related to the Revolving Loan were capitalized as deferred financing costs and are being amortized over the term of the facility on a straight-line basis. |
As described in Note 5, the Company has entered into agreements with certain financial intermediaries to facilitate the purchase of inventory from various suppliers. In connection with the floorplan sub-facility, the Company entered into the Revolving Loan inventory financing agreement. Amounts outstanding under the Revolving Loan inventory financing agreement are unsecured and noninterest bearing. The Company will either pay the outstanding Revolving Loan inventory financing agreement amounts when they become due, or the Revolving Loan's administrative agent will automatically initiate an advance on the Revolving Loan and use the proceeds to pay the balance on the due date. As of December 31, 2012, the financial intermediary reported an outstanding balance of $267.9 million under the Revolving Loan inventory financing agreement, which did not reflect payments the Company made on December 31, 2012. The total amount reported on the Company's consolidated balance sheet as accounts payable-inventory financing related to the Revolving Loan inventory financing agreement is $19.6 million less than the $267.9 million owed to the financial intermediary due to differences in the timing of reporting activity under the Revolving Loan inventory financing agreement. The outstanding balance reported by the financial intermediary excludes $8.0 million in reserves for open orders that reduce the availability under the Revolving Loan. Changes in cash flows from the Revolving Loan inventory financing agreement are reported in financing activities on the Company's consolidated statement of cash flows. |
Borrowings under the Revolving Loan bear interest at a variable interest rate plus an applicable margin. The variable interest rate is based on one of two indices, either (i) LIBOR, or (ii) the Alternate Base Rate (“ABR”) with the ABR being the greatest 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 (2.00% to 2.50% for LIBOR borrowings and 1.00% to 1.50% for ABR borrowings) depending upon the Company's average daily excess cash availability under the agreement and is subject to a reduction of 0.25% if, and for as long as, the senior secured leverage ratio is less than 3.0. The senior secured leverage ratio is defined as the ratio of senior secured debt (including amounts owed under certain inventory floorplan arrangements and capital leases) less cash and cash equivalents, to Adjusted EBITDA, a non-GAAP measure, for the four most recently ended fiscal quarters. For the four quarters ended December 31, 2012, the senior secured leverage ratio was 2.4. |
Availability under the Revolving Loan is limited to (a) the lesser of the revolving commitment of $900.0 million and the amount of the borrowing base less (b) outstanding borrowings, letters of credit, and amounts outstanding under the Revolving Loan inventory financing agreement plus a reserve of 15% of open orders. 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, 2012, the borrowing base was $1,018.2 million based on the amount of eligible inventory and accounts receivable balances as of November 30, 2012. The Company could have borrowed up to an additional $622.4 million under the Revolving Loan at December 31, 2012. |
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 (“Term Loan”) |
At December 31, 2012, the outstanding principal amount of the Term Loan was $1,339.5 million, with $421.3 million of non-extended loans due October 10, 2014 and $918.2 million of extended loans due July 15, 2017. The effective weighted-average interest rate on Term Loan principal amounts outstanding on December 31, 2012 was 3.9% per annum. |
Borrowings under the Term Loan bear interest at either (a) the ABR plus a margin; or (b) LIBOR plus a margin. The margin is based on the Company's senior secured leverage ratio as defined in the amended agreement evidencing the Term Loan. Effective with the March 2011 amendment discussed below, the margins were reduced on extended loans. For ABR borrowings, the applicable margin varies within a range of 2.50% to 3.00% for non-extended loans and 1.75% to 2.25% for extended loans. For LIBOR borrowings, the applicable margin varies within a range of 3.50% to 4.00% for non-extended loans and 2.75% to 3.25% for extended loans. |
On March 11, 2011, the Company entered into an amendment to the Term Loan, which became effective on March 14, 2011. This amendment, among other things: (i) reduced the margins with respect to extended loans, (ii) established a LIBOR floor of 1.25% and an ABR floor of 2.25% with respect to extended loans, (iii) reset the start date for accumulating restricted payments that count against the general limit of $25.0 million and (iv) provided a 1% prepayment premium for certain repayments or re-pricings of any extended loans for the six-month period following the effective date of the amendment. In connection with this amendment, the Company recorded a loss on extinguishment of long-term debt of $3.2 million in the Company's consolidated statement of operations for the year ended December 31, 2011. This loss represented a write-off of a portion of the unamortized deferred financing costs related to the Term Loan. |
The Term Loan requires the Company to make certain mandatory prepayments of principal amounts under certain circumstances, including (i) a prepayment in an amount equal to 50% of the Company's excess cash flow for a fiscal year (the percentage rate of which decreases to 25% when the total net leverage ratio, as defined in the governing agreement, is less than or equal to 5.5 but greater than 4.5; and decreases to 0% when the total net leverage ratio is less than or equal to 4.5), and (ii) the net cash proceeds from the incurrence of certain additional indebtedness by the Company or its subsidiaries. Excess cash flow is defined as Adjusted EBITDA, plus items such as reductions in working capital, less items such as increases in working capital, certain taxes paid in cash, interest that will be paid in cash, capital expenditures and repayment of long-term indebtedness. A mandatory prepayment of approximately $40.0 million will be due in 2013 under the excess cash flow provision with respect to the year ended December 31, 2012. The payment is due within ten business days of filing this report with the SEC. On January 30, 2013, the Company made an optional prepayment of $40.0 million aggregate principal amount. The prepayment was allocated on a pro rata basis between the extended and non-extended loans. The optional prepayment satisfied the excess cash flow payment requirement. The Company was required to make a mandatory prepayment of $201.0 million under the excess cash flow provision with respect to the year ended December 31, 2011. The requirement was satisfied through $180.0 million of optional prepayments in February 2012 and $21.0 million of mandatory prepayments in March 2012. The prepayments were allocated on a pro rata basis between the extended and non-extended loans. On March 16, 2011, the Company made a mandatory prepayment of $132.0 million with respect to the year ended December 31, 2010, under the excess cash flow provision. |
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. The Term Loan also includes a senior secured leverage ratio requirement. The senior secured leverage ratio is required to be maintained on a quarterly basis. Compliance may be determined after giving effect to a designated equity contribution to the Company to be included in the calculation of Adjusted EBITDA. The senior secured leverage ratio for the four quarters ended December 31, 2012 was required to be at or below 6.75. For the four quarters ended December 31, 2012, the senior secured leverage ratio was 2.4. |
The Company is required to maintain interest rate derivative arrangements to fix or cap the interest rate on at least 50% of the outstanding principal amount of the Term Loan through maturity, subject to certain limitations currently in effect. With the interest rate cap agreements in effect at December 31, 2012 as described in Note 8, the Company has satisfied this requirement through January 14, 2015. |
8.0% Senior Secured Notes due 2018 (“Senior Secured Notes”) |
The Senior Secured Notes were issued on December 17, 2010 and will mature on December 15, 2018. At December 31, 2012, the outstanding principal amount of the Senior Secured Notes was $500.0 million. |
CDW LLC and CDW Finance Corporation are the co-issuers of the Senior Secured Notes and the obligations under the notes are guaranteed by Parent and each of CDW LLC's direct and indirect, 100% owned, domestic subsidiaries. The Senior Secured Notes are secured on a pari passu basis with the Term Loan 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 Senior Secured 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 Senior Secured Note indenture does not contain any financial covenants. |
11.0% Senior Exchange Notes due 2015 (“Senior Exchange Notes”); 11.5% / 12.25% Senior PIK Election Exchange Notes due 2015 (“PIK Election Notes” together with the Senior Exchange Notes, the “Senior Notes due 2015”) |
At December 31, 2012, there were no outstanding Senior Notes due 2015. |
On April 13, 2011, the Company completed a cash tender offer (the “Initial Senior Notes due 2015 Tender Offer”) and purchased $665.1 million aggregate principal amount of Senior Notes due 2015 comprised of $519.2 million of the Senior Exchange Notes and $145.9 million of the PIK Election Notes. The Company concurrently issued $725.0 million aggregate principal amount of Senior Notes (as defined below). The proceeds from this offering, together with cash on hand and borrowings under the then-outstanding revolving loan credit facility, were used to fund the purchase of the tendered Senior Notes due 2015, including $665.1 million aggregate principal amount of Senior Notes due 2015, $59.9 million in tender offer premium and $36.5 million of accrued and unpaid interest, along with transaction fees and expenses. |
On May 20, 2011, the Company completed a follow-on cash tender offer (the “Follow-on Senior Notes due 2015 Tender Offer,” and together with the Initial Senior Notes due 2015 Tender Offer, the “Senior Notes due 2015 Tender Offers”) and purchased an additional $412.8 million aggregate principal amount of Senior Notes due 2015 comprised of $321.4 million of the Senior Exchange Notes and $91.4 million of the PIK Election Notes. The Company concurrently issued $450.0 million in aggregate principal amount of additional Senior Notes. The proceeds from this offering, together with cash on hand and borrowings under the then-outstanding revolving loan credit facility, were used to fund the purchase of the tendered Senior Notes due 2015, including $412.8 million aggregate principal amount of Senior Notes due 2015, $37.2 million in tender offer premium and $4.5 million of accrued and unpaid interest, along with transaction fees and expenses. |
In connection with the Senior Notes due 2015 Tender Offers, the Company recorded a loss on extinguishment of long-term debt of $114.1 million in the Company's consolidated statement of operations for the year ended December 31, 2011. This loss represented $97.0 million in tender offer premiums and $17.1 million for the write-off of a portion of the unamortized deferred financing costs related to the Senior Notes due 2015. In connection with the issuance of Senior Notes, fees of $19.1 million were capitalized as deferred financing costs and are being amortized over the term of the notes using the effective interest method. |
On February 2, 2012, the Company commenced a tender offer to purchase any and all of the remaining $129.0 million aggregate principal amount of Senior Notes due 2015. On February 17, 2012, the Company accepted for purchase $120.6 million aggregate principal amount of the outstanding Senior Notes due 2015 that were tendered. On March 5, 2012, the Company accepted for purchase an additional $0.1 million aggregate principal amount of the outstanding Senior Notes due 2015 that were tendered prior to the expiration of the tender offer on March 2, 2012. On March 19, 2012, the Company redeemed the remaining $8.3 million aggregate principal amount that was not tendered. |
The Company funded the purchases and redemptions of the Senior Notes due 2015 with the issuance of $130.0 million aggregate principal amount of additional Senior Notes on February 17, 2012. The proceeds from this issuance, together with cash on hand and borrowings under the Revolving Loan, funded the payment of $129.0 million aggregate principal amount of Senior Notes due 2015, $7.9 million in tender and redemption premiums and $5.0 million of accrued and unpaid interest, along with transaction fees and expenses. |
In connection with these transactions, the Company recorded a loss on extinguishment of long-term debt of $9.4 million in the Company's consolidated statement of operations for the year ended December 31, 2012. This loss represented $7.9 million in tender and redemption premiums and $1.5 million for the write-off of the remaining unamortized deferred financing costs related to the Senior Notes due 2015. |
8.5% Senior Notes due 2019 (“Senior Notes”) |
As discussed above, on April 13, 2011, the Company issued $725.0 million principal amount of Senior Notes and on May 20, 2011, the Company issued an additional $450.0 million principal amount of Senior Notes. The proceeds from these issuances together with cash on hand and borrowings under the then-outstanding revolving loan credit facility were used to fund the Senior Notes due 2015 Tender Offers. |
On February 17, 2012, the Company issued $130.0 million aggregate principal amount of additional Senior Notes at an issue price of 104.375% of par. The $5.7 million premium received is reported on the consolidated balance sheet as an addition to the face amount of the Senior Notes and is being amortized as a reduction of interest expense over the term of the related debt. At December 31, 2012, the outstanding principal amount of Senior Notes was $1,305.0 million, excluding $5.0 million in unamortized premium. The Senior Notes mature on April 1, 2019. |
CDW LLC and CDW Finance Corporation are the co-issuers of the Senior Notes. Obligations under the 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 Senior Notes contain 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 Senior Notes do not contain any financial covenants. |
12.535% Senior Subordinated Exchange Notes due 2017 (“Senior Subordinated Notes”) |
At December 31, 2012, the outstanding principal amount of the Senior Subordinated Notes was $621.5 million. The Senior Subordinated Notes have a maturity date of October 12, 2017. |
On December 21, 2012, the Company redeemed $100.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 $100.0 million aggregate principal amount, $6.3 million of redemption premium and $2.3 million in accrued and unpaid interest. In connection with this redemption, the Company recorded a loss on extinguishment of long-term debt of $7.8 million in the Company's consolidated statement of operations for the year ended December 31, 2012. This loss represented $6.3 million in redemption premium and $1.5 million for the write-off of a portion of the unamortized deferred financing costs related to the Senior Subordinated Notes. |
On March 10, 2010, one of the Company's 100% owned subsidiaries purchased $28.5 million of principal amount of Senior Subordinated Notes for a purchase price of $18.6 million. The Company recorded a gain on the extinguishment of long-term debt of $9.2 million in the Company's consolidated statement of operations for the year ended December 31, 2010 related to this repurchase. In May 2010, the $28.5 million in principal amount of senior subordinated debt that were repurchased were exchanged for increasing rate notes and subsequently surrendered to the indenture trustee for cancellation. |
CDW LLC and CDW Finance Corporation are the co-issuers of the Senior Subordinated Notes. Obligations under the Senior Subordinated Notes are guaranteed on an unsecured senior basis by Parent and each of CDW LLC's direct and indirect, 100% owned, domestic subsidiaries. The Senior Subordinated Notes contain 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 Senior Subordinated Notes do not contain any financial covenants. |
Long-Term Debt Maturities |
As of December 31, 2012, the maturities of long-term debt were as follows: |
| | | | | | | |
| | | | | | | | | | |
(in millions) | | | | | | | | |
Years ending December 31, | | | | | | | | |
2013 | $ | 40 | | | | | | | | |
| | | | | | |
2014 | 408.7 | | | | | | | | |
| | | | | | |
2015 | — | | | | | | | | |
| | | | | | |
2016 | — | | | | | | | | |
| | | | | | |
2017 | 1,512.30 | | | | | | | | |
| | | | | | |
Thereafter | 1,805.00 | | | | | | | | |
| | | | | | |
| $ | 3,766.00 | | | | | | | | |
| | | | | | |
See Note 20 for a description of refinancing transactions completed during 2013. |
Fair Value |
The fair value of the Company's long-term debt instruments at December 31, 2012 was $3,970.0 million. The fair value of the Senior Secured Notes, Senior Notes and Senior Subordinated Notes is 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 is 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, 2012, the carrying value of the Company's long-term debt was $3,766.0 million, excluding $5.0 million in unamortized premium. |
Deferred Financing Costs |
The following table summarizes the deferred financing costs activity for the years ended December 31, 2012 and 2011: |
| | | |
| | | | | | | | | | |
(in millions) | December 31, | | | |
| 2012 | | 2011 | | | |
Beginning balance | $ | 68.5 | | | $ | 79.7 | | | | |
| | |
Additional costs capitalized | 2.1 | | | 26.3 | | | | |
| | |
Recognized in interest expense | (14.4 | ) | | (15.7 | ) | | | |
Write-off of unamortized deferred financing costs | (3.0 | ) | | (21.8 | ) | | | |
Ending balance | $ | 53.2 | | | $ | 68.5 | | | | |
| | |
|
As of December 31, 2012 and December 31, 2011, the weighted-average remaining life of unamortized deferred financing costs was 5.1 and 5.9 years, respectively. |