XML 36 R17.htm IDEA: XBRL DOCUMENT
v3.8.0.1

Long-Term Debt | 12 Months Ended
--- | ---
Dec. 31, 2017
Debt Disclosure [Abstract] |
Long-Term Debt | Long-Term Debt Long-term debt as of December 31, 2017 is as follows:
(dollars in millions) |  | Interest Rate |  | Principal |  | Unamortized Discount and Deferred Financing Costs |  | Total
Senior secured asset-based revolving credit facility |  | — | % |  | $ | — |  |  | $ | — |  |  | $ | — |
CDW UK revolving credit facility |  | — | % |  | — |  |  | — |  |  | — |
Senior secured term loan facility (1) |  | 3.7 | % |  | 1,468.0 |  |  | (2.0 | ) |  | 1,466.0 |
CDW UK term loan |  | 1.9 | % |  | 75.7 |  |  | (1.4 | ) |  | 74.3 |
Senior notes due 2023 |  | 5.0 | % |  | 525.0 |  |  | (4.5 | ) |  | 520.5 |
Senior notes due 2024 |  | 5.5 | % |  | 575.0 |  |  | (5.2 | ) |  | 569.8 |
Senior notes due 2025 |  | 5.0 | % |  | 600.0 |  |  | (7.3 | ) |  | 592.7 |
Other long-term obligations |  |  |  | 12.2 |  |  | — |  |  | 12.2 |
Total debt |  |  |  | 3,255.9 |  |  | (20.4 | ) |  | 3,235.5 |
Less current maturities |  |  |  | (25.5 | ) |  | — |  |  | (25.5 | )
Long-term debt, excluding current maturities |  |  |  | $ | 3,230.4 |  |  | $ | (20.4 | ) |  | $ | 3,210.0 |
(1) | The Senior secured term loan facility has a variable interest rate, which has effectively been capped through the use of an interest rate cap (see Note 9 (Financial Instruments)). The interest rate disclosed represents the variable interest rate in effect as of year ended December 31, 2017.
Long-term debt as of December 31, 2016 is as follows:
(dollars in millions) |  | Interest Rate |  | Principal |  | Unamortized Discount and Deferred Financing Costs |  | Total
Senior secured asset-based revolving credit facility |  | — | % |  | $ | — |  |  | $ | — |  |  | $ | — |
CDW UK revolving credit facility |  | — | % |  | — |  |  | — |  |  | — |
Senior secured term loan facility |  | 3.3 | % |  | 1,483.0 |  |  | (14.9 | ) |  | 1,468.1 |
CDW UK term loan |  | 1.8 | % |  | 69.1 |  |  | (1.6 | ) |  | 67.5 |
Senior notes due 2022 |  | 6.0 | % |  | 600.0 |  |  | (5.6 | ) |  | 594.4 |
Senior notes due 2023 |  | 5.0 | % |  | 525.0 |  |  | (5.3 | ) |  | 519.7 |
Senior notes due 2024 |  | 5.5 | % |  | 575.0 |  |  | (6.0 | ) |  | 569.0 |
Other long-term obligations |  |  |  | 15.7 |  |  | — |  |  | 15.7 |
Total long-term debt |  |  |  | 3,267.8 |  |  | (33.4 | ) |  | 3,234.4 |
Less current maturities of long-term debt |  |  |  | (18.5 | ) |  | — |  |  | (18.5 | )
Long-term debt, excluding current maturities |  |  |  | $ | 3,249.3 |  |  | $ | (33.4 | ) |  | $ | 3,215.9 |
Senior Secured Asset-Based Revolving Credit Facility (“Revolving Loan”) As of December 31, 2017, the Company had no outstanding borrowings under the Revolving Loan, less than $1 million of undrawn letters of credit, $454 million reserved for the floorplan sub-facility and a borrowing base of $1.6 billion, which is based on the amount of eligible inventory and accounts receivable balances as of November 30, 2017. Borrowings under the Revolving Loan are limited by the borrowing base. As of December 31, 2017, the Company could have borrowed up to an additional $996 million under the Revolving Loan. Borrowings are also limited by a minimum liquidity condition, which provides that, if excess cash availability is less than the lower of (i) $125 million and (ii) the greater of (a) 10.0% of the borrowing base, and (b) $100 million, the lenders are not required to lend additional amounts under the Revolving Loan unless the consolidated fixed charge coverage ratio, as defined, is at least 1.00 to 1.00. 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.25% to 1.75% for LIBOR borrowings and 0.25% to 0.75% for ABR borrowings) depending upon average daily excess cash availability under the agreement evidencing the Revolving Loan. On March 31, 2017, the Company amended, extended and increased its Revolving Loan to a five-year, $1.5 billion 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. The Revolving Loan matures on March 31, 2022. The Revolving Loan replaces the Company’s previous revolving loan credit facility that was to mature on June 6, 2019. The Revolving Loan (i) increases the overall revolving credit facility capacity available to the Company from $1.3 billion to $1.5 billion, (ii) maintains the maximum aggregate amount of increases that may be made to the revolving credit facility of $300 million, (iii) maintains the fees on the unused portion of the revolving credit facility at 25 basis points, (iv) makes permanent the 25 basis point reduction in the applicable interest rate margin that was previously conditioned on meeting certain credit ratings levels, and (v) maintains the existing inventory floorplan sub-facility. In connection with the amendment of the previous facility, the Company recorded a loss on extinguishment of long-term debt of $1 million in the Consolidated Statement of Operations for the year ended December 31, 2017, representing a write-off of a portion of unamortized deferred financing costs. Fees of $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. These deferred financing costs are recorded in Other assets on the Consolidated Balance Sheets. Senior Secured Term Loan Facility (“Term Loan”) On December 31, 2017, the outstanding principal amount of the Term Loan was $1.5 billion, excluding $2 million of deferred financing costs. On February 28, 2017, the Company amended the Term Loan to reprice the facility, reducing interest rate margins by 25 basis points. Borrowings under the Term Loan bear interest at either (i) the ABR plus a margin or (ii) LIBOR plus a margin, payable quarterly on the last day of each March, June, September and December. The margin is based upon a net leverage ratio as defined in the agreement governing the Term Loan, which is 1.00% for ABR borrowings and 2.00% for LIBOR borrowings as of December 31, 2017. The Term Loan was issued at par. The Term Loan replaced the prior senior secured term loan facility (the “Prior Term Loan Facility”) that had an outstanding aggregate principal amount of $1.5 billion. The Company is required to pay quarterly principal installments equal to 0.25% of the original principal amount of the Prior Term Loan Facility, with the remaining principal amount payable on the maturity date of August 17, 2023, which was retained from the Prior Term Loan Facility. In connection with this refinancing, the Company recorded a loss on extinguishment of long-term debt of $14 million in the Consolidated Statement of Operations for the year ended December 31, 2017. This loss represented the write-off of a portion of the unamortized deferred financing costs of $5 million and unamortized discount related to the Prior Term Loan Facility of $9 million. In connection with the issuance of the Term Loan, the Company incurred and recorded $2 million in deferred financing fees, which are recorded as a reduction to the debt and presented in the above table as of December 31, 2017. CDW UK Term Loan On August 1, 2016, the Company entered into a new five-year £56 million ($76 million at December 31, 2017) aggregate principal amount term loan facility (“CDW UK Term Loan”), which replaced the prior senior secured term loan facility (the “Prior CDW UK Term Loan Facility”) that had an outstanding principal amount of £56 million. Fees of $1 million were capitalized as deferred financing costs and are being amortized over the term of the loan on a straight-line basis. Commencing during the quarter ending September 30, 2018, the Company is required to make annual principal installments of £5 million ($7 million at December 31, 2017), with the remaining principal amount payable on the maturity date of August 1, 2021. Borrowings under the CDW UK Term Loan bear interest at LIBOR plus a margin, payable quarterly on the last day of each March, June, September and December. As of December 31, 2017, an interest rate of 1.92% was in effect, which represents LIBOR plus a 1.40% margin. In connection with this refinancing, the Prior CDW UK Term Loan Facility was amended to include both the CDW UK Term Loan and a £50 million ($68 million at December 31, 2017) revolving credit facility (the “CDW UK Revolving Credit Facility”). As of December 31, 2017, the Company had no borrowings from the CDW UK Revolving Credit Facility. 6.0% Senior Notes due 2022 (“2022 Senior Notes”) On March 2, 2017, the proceeds from the issuance of the 2025 Senior Notes, discussed below, along with cash on hand and proceeds from Revolving Loan borrowings, were deposited with the trustee to redeem all of the remaining $600 million aggregate principal amount of the 2022 Senior Notes at a redemption price of 106.182% of the principal amount redeemed, plus accrued and unpaid interest through the date of redemption. The redemption date was April 2, 2017. On the same date, the indenture governing the 2022 Senior Notes was satisfied and discharged. In connection with this redemption, the Company recorded a loss on extinguishment of long-term debt of $43 million in the Consolidated Statement of Operations for the year ended December 31, 2017. This loss represents $37 million in redemption premium and $6 million for the write-off of the remaining deferred financing costs related to the 2022 Senior Notes. 5.0% Senior Notes due 2023 (“2023 Senior Notes”) At December 31, 2017, the outstanding principal amount of the 2023 Senior Notes was $525 million. The 2023 Notes will mature on September 1, 2023 and bear interest rate of 5.0% per annum, payable semi-annually on March 1 and September 1 of each year. 5.5% Senior Notes due 2024 (“2024 Senior Notes”) At December 31, 2017, the outstanding principal amount of the 2024 Senior Notes was $575 million. The 2024 Senior Notes will mature on December 1, 2024 and bear interest at a rate of 5.5% per annum, payable semi-annually on June 1 and December 1 of each year. 5.0% Senior Notes due 2025 (“2025 Senior Notes”) On March 2, 2017, the Company completed the issuance of $600 million aggregate principal amount of 2025 Senior Notes at par. In connection with the issuance of the 2025 Senior Notes, the Company incurred and recorded $7 million in deferred financing fees, which is recorded as a reduction to the debt and presented in the above table as of December 31, 2017. At December 31, 2017, the outstanding principal amount of the 2025 Senior Notes was $600 million. The 2025 Senior Notes will mature on September 1, 2025 and bear interest at a rate of 5.0% per annum, payable semi-annually on March 1 and September 1 of each year. Debt Guarantors, Covenants and Restrictions CDW LLC is the borrower under the Term Loan and Revolving Loan. CDW LLC and CDW Finance Corporation are the co-issuers of the 2023, 2024 and 2025 Senior Notes (“Senior Notes”). The obligations under the Term Loan, the Revolving Loan and the Senior Notes are guaranteed by Parent and each of CDW LLC's direct and indirect, wholly owned, US subsidiaries (the “Guarantors”). The Revolving Loan is collateralized by a first priority interest in inventory (excluding inventory collateralized under the inventory floorplan arrangements as described in Note 7 (Inventory Financing Agreements)), deposits, and accounts receivable, and a second priority interest in substantially all US assets. 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 7 (Inventory Financing Agreements)), deposits, and accounts receivable, and by a first priority interest in substantially all other U.S. assets. As of December 31, 2017, the Company remained in compliance with the covenants under its various credit agreements. The Term Loan contains negative covenants that, among other things, place restrictions and limitations on the ability of the Guarantors 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. As of December 31, 2017, the amount of CDW’s restricted payment capacity under the Term Loan was $1.2 billion. However, the Company is separately permitted to make restricted payments, so long as the total net leverage ratio is less than 3.25:1.00 on a pro forma basis. The total net leverage ratio was 2.62:1.00 as of December 31, 2017. Each of the Senior Notes indentures contain negative covenants that, among other things, place restrictions and limitations on the ability of the Guarantors to enter into sale and lease-back transactions, incur additional secured indebtedness and create liens. The indenture governing each of the Senior Notes do not contain any financial covenants. The CDW UK Term Loan Agreement imposes restrictions on CDW UK's ability to transfer funds to the Company through the payment of dividends, repayment of intercompany loans, advances or subordinated debt that require, among other things, the maintenance of a minimum net leverage ratio. As of December 31, 2017, the amount of restricted payment capacity under the CDW UK Term Loan was £73 million ($98 million at December 31, 2017). Long-Term Debt Maturities A summary of Long-term debt maturities is as follows:
(in millions) |  |
Years ending December 31, |  | Total
2018 |  | $ | 25.5 |
2019 |  | 25.7 |
2020 |  | 25.9 |
2021 |  | 70.3 |
2022 |  | 14.9 |
Thereafter |  | 3,093.6 |
|  | $ | 3,255.9 |
Fair Value The fair values of the Senior Notes were estimated using quoted market prices for identical 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 liabilities in markets that are not considered active. The Senior Notes, Term Loan, and CDW UK Term Loan are classified as Level 2 within the fair value hierarchy. The carrying value of the Revolving Loan and CDW UK Revolving Loan approximate fair value if there are outstanding borrowings. The approximate fair values and related carrying values of the Company's long-term debt, including current maturities and excluding unamortized discount and unamortized deferred financing costs, were as follows:
|  | December 31,
(in millions) |  | 2017 |  | 2016
Fair value |  | $ | 3,366.5 |  |  | $ | 3,334.8 |
Carrying value |  | 3,255.9 |  |  | 3,267.8 |

X
- References No definition available. + Details
Name: | us-gaap_DebtDisclosureAbstract
Namespace Prefix: | us-gaap_
Data Type: | xbrli:stringItemType
Balance Type: | na
Period Type: | duration

X
- Definition The entire disclosure for long-term debt. + References Reference 1: http://www.xbrl.org/2003/role/presentationRef -Publisher FASB -Name Accounting Standards Codification -Topic 470 -URI http://asc.fasb.org/topic&trid=2208564 + Details
Name: | us-gaap_LongTermDebtTextBlock
Namespace Prefix: | us-gaap_
Data Type: | nonnum:textBlockItemType
Balance Type: | na
Period Type: | duration