As filed with the Securities and Exchange Commission on March 22, 2013
Registration No. 333-
UNITED STATES
SECURITIES AND EXCHANGE COMMISSION
Washington, D.C. 20549
FORM S-1
REGISTRATION STATEMENT
UNDER
THE SECURITIES ACT OF 1933
CDW CORPORATION
(Exact name of registrant as specified in its charter)
Delaware | 5961 | 26-0273989 | ||
(State or other jurisdiction of incorporation or organization) |
(Primary Standard Industrial Classification Number) |
(I.R.S. Employer Identification No.) |
200 N. Milwaukee Avenue
Vernon Hills, Illinois 60061
Telephone: (847) 465-6000
(Address, including zip code, and telephone number, including area code, of registrants principal executive offices)
Christine A. Leahy
Senior Vice President, General Counsel and Corporate Secretary
CDW Corporation
200 N. Milwaukee Avenue
Vernon Hills, Illinois 60061
Telephone: (847) 465-6000
(Name, address, including zip code, and telephone number, including area code, of agent for service)
Copies to:
James S. Rowe Kirkland & Ellis LLP 300 N. LaSalle Chicago, Illinois 60654 Telephone: (312) 862-2000 |
Robert F. Wall, Esq. Brian M. Schafer, Esq. Winston & Strawn LLP 35 W. Wacker Drive Chicago, Illinois 60601 Telephone: (312) 558-5600 |
Approximate date of commencement of proposed sale of the securities to the public:
As soon as practicable after this Registration Statement becomes effective.
If any of the securities being registered on this Form are to be offered on a delayed or continuous basis pursuant to Rule 415 under the Securities Act of 1933, check the following box: ¨
If this Form is filed to register additional securities for an offering pursuant to Rule 462(b) under the Securities Act, please check the following box and list the Securities Act registration statement number of the earlier effective registration statement for the same offering. ¨
If this Form is a post-effective amendment filed pursuant to Rule 462(c) under the Securities Act, check the following box and list the Securities Act registration statement number of the earlier effective registration statement for the same offering. ¨
If this Form is a post-effective amendment filed pursuant to Rule 462(d) under the Securities Act, check the following box and list the Securities Act registration statement number of the earlier effective registration statement for the same offering. ¨
Indicate by check mark whether the registrant is a large accelerated filer, an accelerated filer, a non-accelerated filer, or a smaller reporting company. See the definitions of large accelerated filer, accelerated filer, and smaller reporting company in Rule 12b-2 of the Exchange Act (Check one):
Large accelerated filer ¨ Non-accelerated filer x (Do not check if a smaller reporting company) |
Accelerated filer ¨ Smaller reporting company ¨ |
CALCULATION OF REGISTRATION FEE
| ||||
Title of each class of securities to be registered |
Proposed maximum aggregate offering price(1)(2) |
Amount of registration fee | ||
Common Stock, par value $0.01 per share |
$500,000,000 | $68,200 | ||
| ||||
|
(1) | Estimated solely for the purpose of calculating the registration fee pursuant to Rule 457(o) under the Securities Act of 1933, as amended. |
(2) | Includes the offering price of any additional shares of common stock that the underwriters have the option to purchase. |
The registrant hereby amends this Registration Statement on such date or dates as may be necessary to delay its effective date until the registrant shall file a further amendment which specifically states that this Registration Statement shall thereafter become effective in accordance with Section 8(a) of the Securities Act of 1933 or until this Registration Statement shall become effective on such date as the Commission, acting pursuant to said Section 8(a), may determine.
The information in this prospectus is not complete and may be changed. We may not sell these securities until the registration statement filed with the Securities and Exchange Commission is effective. This prospectus is not an offer to sell, and we are not soliciting an offer to buy, these securities in any state where the offer or sale is not permitted.
Subject to completion, dated March 22, 2013
Prospectus
shares
CDW Corporation
Common stock
This is an initial public offering of shares of common stock of CDW Corporation. We are offering shares of our common stock. The estimated initial public offering price is between $ and $ .
Prior to this offering, there has been no public market for our common stock. We intend to apply to list our common stock on under the symbol CDW.
Investing in our common stock involves a high degree of risk. See Risk factors beginning on page 16.
Per share | Total | |||||||
Initial public offering price |
$ | $ | ||||||
Underwriting discounts and commissions |
$ | $ | ||||||
Proceeds to CDW, before expenses |
$ | $ |
The underwriters have an option to purchase up to additional shares from us to cover overallotments, if any. The underwriters can exercise this option at any time within 30 days from the date of this prospectus.
Delivery of the shares of common stock will be made on or about , 2013.
Neither the Securities and Exchange Commission nor any state securities commission has approved or disapproved of these securities or passed on the adequacy of this prospectus. Any representation to the contrary is a criminal offense.
J.P. Morgan | Barclays | Goldman, Sachs & Co. | ||
Deutsche Bank Securities | Morgan Stanley | |||
Baird | BofA Merrill Lynch |
Raymond James | ||
William Blair |
, 2013
Page | ||||
ii | ||||
1 | ||||
16 | ||||
33 | ||||
34 | ||||
35 | ||||
36 | ||||
37 | ||||
39 | ||||
41 | ||||
48 | ||||
Managements discussion and analysis of financial condition and results of operations |
52 | |||
87 | ||||
100 | ||||
111 | ||||
134 | ||||
137 | ||||
141 | ||||
148 | ||||
152 | ||||
Certain U.S. federal income and estate tax considerations for non-U.S. holders |
154 | |||
159 | ||||
167 | ||||
167 | ||||
169 | ||||
R-1 | ||||
F-1 |
We have not and the underwriters have not authorized anyone to provide you with any information other than that contained in this prospectus or in any free writing prospectus prepared by or on behalf of us or to which we have referred you. We are offering to sell, and seeking offers to buy, shares of our common stock only in jurisdictions where such offers and sales are permitted. The information in this prospectus or any free writing prospectus is accurate only as of its date, regardless of its time of delivery or the time of any sale of shares of our common stock. Our business, financial condition, results of operations and prospects may have changed since that date.
i
This prospectus includes our trademarks such as CDW, which are protected under applicable intellectual property laws and are the property of CDW Corporation or its subsidiaries. This prospectus also contains trademarks, service marks, trade names and copyrights of other companies, which are the property of their respective owners. Solely for convenience, trademarks and trade names referred to in this prospectus may appear without the ® or TM symbols, but such references are not intended to indicate, in any way, that we will not assert, to the fullest extent under applicable law, our rights or the right of the applicable licensor to these trademarks and trade names.
ii
This summary highlights information contained in greater detail elsewhere in this prospectus. You should carefully read the entire prospectus, including the section entitled Risk factors and the consolidated financial statements and notes related to those statements included elsewhere in this prospectus, before deciding to invest in our common stock. Unless otherwise indicated or the context otherwise requires, the terms we, us, our, the Company, CDW and other similar terms refer to the business of CDW Corporation and its consolidated subsidiaries.
Our business
Our company
CDW is a Fortune 500 company and a leading provider of integrated information technology (IT) solutions in the U.S. and Canada. We help our customer base of more than 250,000 small, medium and large business, government, education and healthcare customers by delivering critical solutions to their increasingly complex IT needs. Our broad array of offerings range from discrete hardware and software products to integrated IT solutions such as mobility, security, data center optimization, cloud computing, virtualization and collaboration. We are technology agnostic, with a product portfolio that includes more than 100,000 products from more than 1,000 brands. We provide our products and solutions through our sales force and service delivery teams consisting of more than 4,300 coworkers, including nearly 1,400 highly skilled technology specialists and engineers.
Our sales growth has historically outpaced U.S. IT spending growth. From 2002 to 2012, we grew our net sales at a compound annual growth rate (CAGR) of 9.0%, while U.S. IT spending and U.S. real GDP grew at CAGRs of only 4.5% and 1.6%, respectively, according to International Data Corporation (IDC) and the Bureau of Economic Analysis, respectively.
We are a leading U.S. sales channel partner for many original equipment manufacturers (OEMs) and software publishers (collectively, our vendor partners), whose products we sell or include in the solutions we offer. We believe we are an important extension of our vendor partners sales and marketing capabilities, providing them with a cost-effective way to reach customers and deliver a consistent brand experience through our established end-market coverage and extensive customer access.
We provide value to our customers by simplifying the complexities of technology across design, selection, procurement, integration and management. Our goal is to have our customers, regardless of their size, view us as an indispensable extension of their IT staffs. We seek to achieve this goal by providing our customers with superior service through our large and experienced sales force and service delivery teams. Our multi-brand offering approach enables us to identify the products or combination of products that best address each customers specific organizational IT requirements and to evolve our offerings as new technologies develop.
1
We believe we offer the following value proposition to our customers and our vendor partners:
Our value proposition to our customers | Our value proposition to our vendor partners | |
| ||
Broad selection of products and multi-branded IT solutions
Value-added services with integration capabilities
Highly skilled specialists and engineers
Solutions across a very broad IT landscape |
Access to over 250,000 customers throughout the U.S. and Canada
Large and established customer channels
Strong distribution and implementation capabilities
Value-added solutions and marketing programs that generate end-user demand | |
|
Our customers include private sector businesses that typically employ fewer than 5,000 employees, government agencies and educational and healthcare institutions. We serve our customers through channel-specific sales teams and service delivery teams with extensive technical skills and knowledge of the specific markets they serve. This market segmentation allows us to customize our offerings and to provide enhanced expertise in designing and implementing IT solutions for our customers. We currently have five dedicated customer channels: medium/large business, small business, government, education and healthcare, each of which generated over $1 billion in net sales in 2012. The scale and diversity of our customer channels provide us with multiple avenues for growth and a balanced customer base to weather economic and technology cycles. For example, from 2008 through 2010, a period that included the recent financial crisis, sales to our government and education customers grew while sales to our medium/large business and small business customers held steady or experienced only slight growth. In contrast, since 2010, our medium/large business and small business channels have experienced significantly stronger growth relative to our government and education channels. Our healthcare channel experienced strong growth during both periods.
The following table provides information regarding our reportable segments and our customer channels:
Corporate segment | Public segment | |||||||||||||||||||||||
Customer Channels | Medium/large business |
Small business |
Government | Education | Healthcare | Other | ||||||||||||||||||
|
||||||||||||||||||||||||
Target Customers |
|
100 - 5,000 employees |
|
|
10 - 100 employees |
|
|
Various federal, state and local agencies |
|
|
Higher education and K-12 |
|
|
Hospitals, ambulatory service providers and long-term care facilities |
|
|
Advanced services customers plus Canada |
| ||||||
2012 Net Sales (in billions) |
$ | 4.4 | $ | 1.1 | $ | 1.4 | $ | 1.2 | $ | 1.4 | $ | 0.6 | ||||||||||||
2010-2012 CAGR |
7% | 5% | 1% | 0% | 20% | 21% | ||||||||||||||||||
2008-2010 CAGR |
0% | 1% | 11% | 8% | 15% | 12% | ||||||||||||||||||
|
We offer over 1,000 brands, from well-established companies such as APC, Apple, Cisco, EMC, Hewlett-Packard, IBM, Lenovo, Microsoft, NetApp, Symantec and VMware, to emerging vendor partners such as Drobo, Fusion-io, Meraki, Nimble Storage, Salesforce.com, Sophos and Splunk. In 2012, we generated over $1 billion of revenue for each of three of our vendor partners and over $100 million of revenue for each of 12 other vendor partners. We have received the highest level
2
of certification from major vendor partners, such as Cisco, EMC and Microsoft, which reflects the extensive product and solution knowledge and capabilities that we bring to our customers IT challenges. These certifications also provide us with access to favorable pricing, tools and resources, including vendor incentive programs, which we use to provide additional value to our customers. Our vendor partners also regularly recognize us with top awards and select us to develop and grow new customer solutions.
In 2012, our net sales, Adjusted EBITDA, net income and non-GAAP net income were $10.1 billion, $767 million, $119 million and $247 million, respectively. Adjusted EBITDA and non-GAAP net income are non-GAAP financial measures. See Summary consolidated financial information for the definitions of Adjusted EBITDA and non-GAAP net income, the reasons for their inclusion and a reconciliation to net (loss) income.
Our market
We operate in the U.S. and Canadian IT market, which is a large and growing market. According to IDC, the overall U.S. IT market generated approximately $639 billion in sales in 2012. We believe our addressable market in the U.S. in the indirect sales channel represents more than $200 billion in annual sales and for the year ended December 31, 2012, our net sales of $10.1 billion represented approximately 5% of that highly diverse and fragmented market. We believe we have the largest market share in our addressable market, with our 2012 net sales exceeding the cumulative North American net sales of our five largest publicly traded sales channel competitors, based upon publicly available information for those companies. New technologies, including cloud, virtualization and mobility, coupled with the resulting increase in demand for data as well as aging infrastructure, are increasingly requiring businesses and institutions to seek integrated solutions to their IT needs. We expect this trend to continue for the foreseeable future, with end-user demand for business efficiency and productivity driving future IT spending growth.
The table below shows the estimated 2012 annual sales within the IT market and expected growth rates of certain technology solutions that we provide within our addressable market, each of which is expected to grow at a rate faster than both the U.S. IT market and our addressable market:
(dollars in billions) | 2012E | CAGR |
||||||
|
||||||||
Public Cloud(1) |
$ | 20.6 | 13% | |||||
Security(2) |
21.3 | 9 | ||||||
Mobility(3) |
3.4 | 39 | ||||||
Virtualization(4) |
1.8 | 11 | ||||||
Managed Services(5) |
46.2 | 11 | ||||||
Collaboration(6) |
5.3 | 6 | ||||||
|
(1) | Gartner, Forecast: IT Services, 2010-2016, 4Q12 Update, Cloud Services and Applications Outsourcing (December 2012) (U.S.) |
(2) | Gartner, Forecast: Information Security, Worldwide, 2010-2016, 4Q12 Update (January 2013) (U.S.) |
(3) | Gartner, Managed Mobility Services (March 2013) (US); Forecast: Tablets and Ultramobiles, Worldwide, 2010-2016, 4Q12 Update, Business Tablets and Ultramobiles (December 2012) (U.S.) |
(4) | Gartner, Forecast: Enterprise Software Markets, Worldwide, 2011-2016, Virtualization Infrastructure Software (December 2012) (U.S.) |
(5) | Gartner, Forecast: IT Services 2010-2016, 4Q12 Update, Colocation, Hosting, Data Center Outsourcing (December 2012) (U.S.) |
(6) | Gartner, Forecast: Enterprise Unified Communications Infrastructure, Worldwide, 2009-2016, Unified Communications Ready Enterprise Infrastructure (March 2013) (North America) |
3
IDC estimates that 59% of U.S. IT revenues are generated through indirect channels, including value-added resellers (VARs), retailers and e-tailers, rather than the direct sales forces of OEMs and software publishers. We purchase products directly from our vendor partners, as well as from wholesale distributors, for resale to our customers or for inclusion in the solutions we offer. Wholesale distributors, such as Arrow, Avnet, Ingram Micro, SYNNEX and Tech Data, provide logistics management and supply-chain services for us and our vendor partners but, unlike CDW, typically do not have relationships with end-users in the U.S.
The charts below depict the current principal sales channels for vendors in the IT market and our estimate of our market-leading share of our addressable market in the U.S.:
Our history
CDW was founded in 1984. We were a public company from 1993 until October 2007, when we were acquired by newly formed entities controlled by Madison Dearborn Partners (Madison Dearborn) and Providence Equity Partners (Providence Equity, and together with Madison Dearborn, the Sponsors) in a transaction valued at approximately $7.4 billion (the Acquisition).
Since our inception, our company has exhibited a strong culture of customer service while operating with a lean, highly efficient cost structure. Over the past ten years, we have grown our sales twice as fast as the overall U.S. IT market and maintained strong operating profitability across economic cycles. Most of our growth has been organic, driven largely by our strong execution as well as through our effective market segmentation. Over the years, we have been able to identify attractive growth opportunities, dedicate resources to them and execute on our strategy to capture above-market growth. For example, in 2005, we launched a sales team for our healthcare customer channel, which has since grown to represent over $1.4 billion in net sales in 2012. Our last acquisition was in 2006, when we acquired Berbee Information Networks Corporation, a regional provider of technology products, solutions and customized engineering services in advanced technologies. We leveraged this acquisition to significantly enhance our ability to deliver advanced solutions throughout the U.S. and Canada, adding approximately 675 specialists, field sellers and engineers since the time of the acquisition to further enhance these capabilities.
4
Since the Acquisition, we have continued to expand our customer footprint, breadth of products and solutions and developed stronger and deeper relationships with a greater number of our vendor partners. We increased our net sales from approximately $8 billion in 2008 to more than $10 billion in 2012, and increased our Adjusted EBITDA by 34% during that period.
We have increased our focus as an IT solutions provider and further diversified our business. We have become more efficient and have continued to improve our coworker productivity, improving our net sales per coworker from $1.22 million in 2008 to $1.50 million in 2012. We have also substantially reduced our leverage through debt reduction and improvement in our Adjusted EBITDA, and will further reduce our leverage as a result of this offering.
Our competitive strengths
We believe the following strengths have contributed to our success and enabled us to become an important strategic partner for both our customers and our vendor partners:
Significant scale and scope
| Breadth of solutions: We are able to provide our customers with a selection of over 100,000 products from over 1,000 brands and a multitude of advanced technology solutions. We are technology agnostic, which we believe better enables us to meet our customers evolving IT needs. We have leveraged our scale to provide a high level of customer service and a breadth of technology options, making it easy for customers to do business with us. |
| Extensive reach: We have a large sales organization, providing our vendor partners access to over 250,000 customers. Our extensive reach allows us to provide customers with local, on-site support, while at the same time providing them with the strength and consistency of a large and established organization. We believe this flexibility is particularly important to our customers with multiple geographically-dispersed locations. By engaging with a single IT solutions provider, customers can improve overall efficiency and effectiveness through the use of one set of standards across multiple locations and control costs through centralized purchasing. |
| Operational cost efficiencies: Our scale provides us with operational cost efficiencies across our organization, including purchasing, operations, IT, sales, marketing and other support functions. Our scale also enables us to negotiate volume discounts and other incentives from our vendor partners. We leverage these advantages to provide cost-efficient service to our customers. |
| Distribution advantages: Our scale allows us to maintain two modern distribution centers with sufficient capacity to support future growth. Our distribution capabilities enable us to provide effective and efficient inventory management and configuration services and operate a flexible procurement and fulfillment model, which we believe further distinguishes us from our competitors. |
Performance-driven coworker culture
Our steadfast focus on serving our customers and investing in our coworkers has fostered a strong, entrepreneurial make it happen culture. Since our founding, we have adhered to a
5
core philosophy known as the Circle of Service, which places the customer at the center of all of our actions. Our compensation structure is a key component of our performance-driven culture, with a significant portion of compensation based on performance. Our senior managements incentive compensation is based on both market share gains and our overall financial performance, and our account managers incentive compensation is based on the gross profit they generate. In addition, we have consistently and cost-effectively invested in our coworkers by providing extensive coworker training, supplying our coworkers with resources that contribute to their success, and offering them career development and advancement opportunities. This consistent focus on customers and coworkers has created a customer-centric, highly engaged coworker base. We believe this philosophy ultimately benefits our customers and fosters long-term customer loyalty.
Large and knowledgeable direct selling organization
We have a large and highly experienced sales force providing multi-brand solutions throughout the U.S. and Canada. Our sales force and service delivery team consists of more than 4,300 coworkers, including more than 2,800 account managers and field sellers. We believe our success is due in part to the strength of our account managers dedicated relationships with customers that are developed by frequently calling on existing and new customers, providing advice on products, responding to customer inquiries and developing solutions to our customers complex technology needs. The deep industry knowledge of our dedicated sales, marketing and support resources within each of our customer channels allows us to understand and solve the unique challenges and evolving IT needs of our customers.
Highly skilled technology specialists and engineers focused on delivering solutions
We have nearly 1,400 highly skilled technology specialists and engineers supporting solutions such as mobility, security, data center optimization, cloud computing, virtualization and collaboration. These individuals bring deep product and solution knowledge and experience to the technology challenges of our customers. We believe our technology specialists and engineers, who work with customers and our sales force to design, select, integrate and manage solutions, are a critical resource and differentiator for us as we seek to continue to expand our offerings of value-added services and solutions. We believe that the knowledge and experience that our technology specialists and engineers bring to our customers needs allow us to pursue the expected higher growth opportunities from solutions offerings.
Large and established customer channels
We have five customer channels each accounting for more than $1 billion of our net sales in 2012 that provide us with the scale to offer channel- and industry-specific solutions to our customers. Our specialized sales resources and targeted solutions enable us to better meet our customers evolving IT needs. In addition, the diversity of our customer channels provides us multiple avenues for growth and a balanced customer base, which enable us to better weather economic and technology cycles.
6
Strong, established vendor partner relationships
We believe that our strong vendor partner relationships differentiate us from other technology solutions providers. We are the largest U.S. sales channel partner for many of our vendor partners. We believe this makes us an important extension of their own sales and marketing capabilities, providing them with a cost-effective route to market for their products. We are also able to provide valuable customer feedback to our vendor partners, which allows us to collaborate with our vendor partners to develop solutions to meet our customers changing and evolving needs.
Our growth strategies
We believe we are well-positioned for growth and have a multifaceted strategy that builds upon our scale, broad solutions offerings and our important role in delivering value for both our customers and vendor partners. We believe we can further enhance our position as a leading provider of integrated IT solutions and increase our revenues and operating profits by capitalizing on our competitive strengths and executing the following strategies:
Further penetrate core customer markets
We compete in a highly fragmented market and believe this fragmentation presents significant opportunities for us to increase our market share. We intend to maintain our focus on continuing to outpace our competitors in revenue growth in the markets we serve through increased share of wallet from existing customers and sales to new customers. We intend to accomplish this objective by:
| leveraging our existing deep customer relationships to grow customer verticals; |
| continuing to focus on improvements in sales productivity and sales coverage in underpenetrated markets; |
| dedicating additional resources in high growth customer channels; and |
| leveraging our existing relationships with both established and emerging vendor partners. |
Continue to expand solution offerings
Our customers increasingly need complex integrated solutions, including solutions involving mobility, security, data center optimization, cloud computing, virtualization and collaboration, all of which are expected to grow at rates faster than the overall U.S. IT market. We offer a broad set of solutions to capture these growth opportunities. We intend to continue to invest resources to expand and deepen the capabilities of our technology specialists and engineers in these solutions, as well as in other technologies as they emerge. We will also continue to evaluate our suite of solutions and expand the range of our solutions as new customer needs emerge. We will continue to seek to identify and develop close, mutually beneficial relationships with both well-established and emerging vendor partners who are likely to be leaders across new technologies.
7
Expand our services capabilities
As our customers needs for integrated solutions grow, we expect increased demand for our value-added services. We plan to continue to invest in resources and training for our technology specialists and services delivery coworkers to provide our customers with the expert advice and experience they need to make the most of their technology expenditures. We believe our services offerings have and will continue to create deeper relationships with our customers and create further opportunities to cross-sell our products.
Risk factors
Our business is subject to a number of risks. These risks include, but are not limited to, the following:
| General economic conditions could negatively affect technology spending by our customers and put downward pressure on prices, which may have an adverse impact on our business, results of operations or cash flows. |
| Our business depends on our vendor partner relationships and the availability of their products. |
| Our sales are dependent on continued innovations in hardware and software offerings by our vendor partners, the competitiveness of their offerings and our ability to partner with new and emerging technology providers. |
| Substantial competition could reduce our market share and significantly harm our financial performance. |
| Our substantial indebtedness could impact our operating flexibility, competitive position compared to our less leveraged competitors and susceptibility to both general and industry-specific adverse economic conditions. |
If these or any of the other risks described in the section entitled Risk factors were to occur, the market price of our common stock could decline and you may lose all or part of your original investment.
Sponsors
Madison Dearborn is a leading private equity investment firm based in Chicago, Illinois that has raised over $18 billion of equity capital. Since its formation in 1992, it has invested in approximately 125 companies across a broad spectrum of industries, including basic industries, business and government services, consumer, financial and transaction services, healthcare and telecom, media and technology services. Madison Dearborns objective is to invest in companies in partnership with outstanding management teams to achieve significant long-term appreciation in equity value.
Providence Equity is a leading global private equity firm focused on media, communications, education and information investments. Providence Equity manages funds with $28 billion of equity commitments and has invested in more than 130 companies over its 23-year history.
8
Providence Equity is headquartered in Providence, Rhode Island and has offices in New York, London, Hong Kong, Beijing and New Delhi. Providences objective is to build extraordinary companies that will shape the future of the media, communications, education and information industries. To achieve this objective, Providence Equity creates value by forging lasting partnerships with talented entrepreneurs and executives and providing them with capital, industry expertise and a broad network of relationships that they need to succeed.
Corporate ownership
Currently, CDW Corporation is a wholly owned subsidiary of CDW Holdings LLC (CDW Holdings). Substantially all of the equity interests of CDW Holdings are owned by investment funds affiliated with the Sponsors, certain other co-investors and certain members of our current and former management. Prior to the completion of this offering, CDW Holdings will be liquidated and will distribute all of its shares of CDW Corporation common stock to its existing members in accordance with their respective membership interests and pursuant to the terms of CDW Holdings limited liability company agreement and unitholders agreement.
Recent developments
On January 30, 2013, CDW LLC, a 100% owned subsidiary of CDW Corporation, made an optional prepayment of $40.0 million aggregate principal amount of loans outstanding under its senior secured term loan facility (the Term Loan Facility) using cash on hand (the 2013 Prepayment). The optional prepayment satisfied our obligations under the excess cash flow payment provision of the Term Loan Facility with respect to the year ended December 31, 2012.
On March 8, 2013, CDW LLC and CDW Finance Corporation, another 100% owned subsidiary of CDW Corporation (CDW Finance), redeemed $50.0 million aggregate principal amount of their outstanding senior subordinated exchange notes due 2017 (the Senior Subordinated Notes) using cash on hand (the 2013 Redemption, and together with the 2013 Prepayment, the 2013 Debt Transactions). The redemption price of the Senior Subordinated Notes was 106.268% of the principal amount redeemed, plus accrued and unpaid interest to the date of redemption. As of the date of this prospectus, $571.5 million aggregate principal amount of Senior Subordinated Notes is outstanding.
Corporate information
Our principal executive offices are located at 200 N. Milwaukee Avenue, Vernon Hills, Illinois 60061, and our telephone number at that address is (847) 465-6000. Our website is located at http://www.cdw.com. The information on our website is not part of this prospectus.
9
The offering
Common stock offered by us |
shares |
Common stock to be outstanding after the offering |
shares |
Underwriters option to purchase additional shares |
We have granted the underwriters a 30-day option to purchase up to an additional shares from us at the public offering price less underwriting discounts and commissions. |
Use of proceeds |
We estimate that the proceeds to us from this offering, after deducting estimated underwriting discounts and commissions and offering expenses payable by us, will be approximately $ million, assuming the shares offered by us are sold for $ per share, the midpoint of the price range set forth on the cover of this prospectus. For a sensitivity analysis as to the initial public offering price and other information, see Use of proceeds. |
We intend to use a portion of the net proceeds received by us from this offering to redeem $ million aggregate principal amount of Senior Subordinated Notes at a redemption price of 106.268% plus accrued and unpaid interest thereon. |
Approximately $ million of the net proceeds received by us from this offering will be used to make a one-time payment to affiliates of the Sponsors in connection with the termination of our management services agreement with such entities (the Management Services Agreement) as described in Use of proceeds. |
We intend to use the remaining proceeds received by us from this offering for general corporate purposes. |
Dividends |
We do not anticipate paying any cash dividends in the foreseeable future. In addition, our ability to pay dividends on our common stock will be limited by restrictions on our ability to pay dividends or make distributions to our stockholders and on the ability of our subsidiaries to pay dividends or make distributions to us, in each case, under the terms of our current and any future agreements governing our indebtedness. Any future determination to pay dividends will be at the discretion of our board of directors, subject to compliance with covenants in our current and future agreements governing |
10
our indebtedness, and will depend upon our results of operations, financial condition, capital requirements, tax considerations and other factors that our board of directors deems relevant. See Dividend policy. |
Proposed symbol |
We intend to apply to list the shares of our common stock on under the symbol CDW. |
Risk factors |
For a discussion of risks relating to our business, our indebtedness and ownership of our common stock, see Risk factors. |
Unless otherwise indicated, all information in this prospectus relating to the number of shares of common stock to be outstanding immediately after the completion of this offering:
| gives effect to the reclassification of our Class A common stock and our Class B common stock into a single class of common stock and the subsequent -for-1 stock split of our common stock, both of which will be effected prior to the completion of this offering; |
| assumes the effectiveness of our amended and restated certificate of incorporation and amended and restated bylaws, which we will adopt prior to the completion of this offering; |
| assumes the liquidation of CDW Holdings and distribution of its shares of CDW Corporation to its members; |
| excludes an aggregate of shares of our common stock reserved for issuance under the new equity incentive plan we intend to adopt in connection with this offering; and |
| assumes (1) no exercise by the underwriters of their option to purchase up to additional shares from us and (2) an initial public offering price of $ per share, the midpoint of the price range set forth on the cover of this prospectus. |
11
Summary consolidated financial information
The following table sets forth our summary historical financial data and unaudited pro forma financial data for the periods ended and as of the dates indicated below. We have derived the summary historical financial data presented below as of December 31, 2011 and December 31, 2012 and for the years ended December 31, 2010, December 31, 2011 and December 31, 2012 from our audited consolidated financial statements and related notes, which are included elsewhere in this prospectus. The summary historical financial data presented below as of December 31, 2010 has been derived from our audited consolidated balance sheet as of that date, which is not included in this prospectus. Our summary historical financial data may not be a reliable indicator of future results of operations.
The unaudited pro forma net income for the year ended December 31, 2012 gives effect to the transactions described in Unaudited pro forma condensed consolidated financial data as if such transactions occurred at the beginning of such year. The unaudited pro forma financial data is for informational purposes only and is not intended to represent or be indicative of the consolidated results of operations that we would have reported had the foregoing transactions and this offering been completed on the dates indicated, and should not be taken as representative of our future consolidated results of operations.
The summary historical financial data and unaudited pro forma financial data set forth below is only a summary and should be read in conjunction with Selected consolidated financial and operating data, Unaudited pro forma condensed consolidated financial data, Risk factors, Use of proceeds, Capitalization, Managements discussion and analysis of financial condition and results of operations and our historical consolidated financial statements and related notes appearing elsewhere in this prospectus.
Years ended December 31, | ||||||||||||
(in millions) | 2010 | 2011 | 2012 | |||||||||
|
|
|
||||||||||
Statement of Operations Data: |
||||||||||||
Net sales |
$ | 8,801.2 | $ | 9,602.4 | $ | 10,128.2 | ||||||
Cost of sales |
7,410.4 | 8,018.9 | 8,458.6 | |||||||||
|
|
|||||||||||
Gross profit |
1,390.8 | 1,583.5 | 1,669.6 | |||||||||
Selling and administrative expenses |
932.1 | 990.1 | 1,029.5 | |||||||||
Advertising expense |
106.0 | 122.7 | 129.5 | |||||||||
|
|
|||||||||||
Income from operations |
352.7 | 470.7 | 510.6 | |||||||||
Interest expense, net |
(391.9 | ) | (324.2 | ) | (307.4 | ) | ||||||
Net gain (loss) on extinguishments of long-term debt |
2.0 | (118.9 | ) | (17.2 | ) | |||||||
Other income, net |
0.2 | 0.7 | 0.1 | |||||||||
|
|
|||||||||||
(Loss) income before income taxes |
(37.0 | ) | 28.3 | 186.1 | ||||||||
Income tax benefit (expense) |
7.8 | (11.2 | ) | (67.1 | ) | |||||||
|
|
|||||||||||
Net (loss) income |
$ | (29.2 | ) | $ | 17.1 | $ | 119.0 | |||||
|
|
|||||||||||
Pro forma net income |
$ | |||||||||||
|
12
Years ended December 31, | ||||||||||||
(dollars in millions) | 2010 | 2011 | 2012 | |||||||||
|
||||||||||||
Balance Sheet Data (at year end): |
||||||||||||
Cash and cash equivalents |
$ | 36.6 | $ | 99.9 | $ | 37.9 | ||||||
Total debt and capitalized lease obligations(1) |
4,290.0 | 4,066.0 | 3,771.0 | |||||||||
Working capital |
675.4 | 538.1 | 666.5 | |||||||||
Cash Flows Data: |
||||||||||||
Net cash provided by operating activities |
$ | 423.7 | $ | 214.7 | $ | 317.4 | ||||||
Net change in accounts payable-inventory financing(2) |
3.2 | 250.5 | (29.5 | ) | ||||||||
Capital expenditures |
(41.5 | ) | (45.7 | ) | (41.4 | ) | ||||||
|
|
|||||||||||
Subtotal |
$ | 385.4 | $ | 419.5 | $ | 246.5 | ||||||
Income taxes (paid) refunded, net (included in net cash provided by operating activities) |
(48.0 | ) | 20.9 | (123.2 | ) | |||||||
Net cash used in investing activities |
(125.4 | ) | (56.0 | ) | (41.7 | ) | ||||||
Net cash used in financing activities |
(350.1 | ) | (95.4 | ) | (338.0 | ) | ||||||
Other Key Metrics: |
||||||||||||
Gross profit as a percentage of net sales |
15.8 | % | 16.5 | % | 16.5 | % | ||||||
Adjusted EBITDA(3) |
$ | 601.8 | $ | 717.3 | $ | 766.6 | ||||||
Non-GAAP net income(4) |
$ | 85.7 | $ | 198.8 | $ | 247.1 | ||||||
Cash conversion cycle(5) |
32 | 27 | 24 | |||||||||
Coworker count (at year end) |
6,268 | 6,745 | 6,804 | |||||||||
Revenue per coworker(6) |
$ | 1.42 | $ | 1.48 | $ | 1.50 | ||||||
|
(1) | Excludes borrowings of $28.2 million, $278.7 million and $249.2 million, as of December 31, 2010, December 31, 2011 and December 31, 2012, respectively, under our inventory financing agreements. We do not include these borrowings in total debt because we have not in the past incurred, and in the future do not expect to incur, any interest expense under these agreements. These amounts are classified separately as accounts payableinventory financing on our consolidated balance sheets. For more information, see Description of certain indebtedness. |
(2) | We have entered into agreements with certain financial intermediaries to facilitate the purchase of inventory from various suppliers. These amounts are classified separately as accounts payable-inventory financing on our consolidated balance sheets and, in accordance with accounting principles generally accepted in the United States of America (GAAP), included in financing activities in our consolidated statements of cash flows. We have not incurred, and in the future do not expect to incur, any interest expense under the agreements. |
(3) | EBITDA is defined as consolidated net income (loss) before interest income (expense), income tax benefit (expense), depreciation, and amortization. Adjusted EBITDA, which is a measure defined in the Senior Credit Facilities (as defined herein), is calculated by adjusting EBITDA for certain items of income and expense including (but not limited to) the following: (a) non-cash equity-based compensation; (b) goodwill impairment charges; (c) sponsor fees; (d) certain consulting fees; (e) debt-related legal and accounting costs; (f) equity investment income and losses; (g) certain severance and retention costs; (h) gains and losses from the early extinguishment of debt; (i) gains and losses from asset dispositions outside the ordinary course of business; and (j) non-recurring, extraordinary or unusual gains or losses or expenses. |
We have included a reconciliation of EBITDA and Adjusted EBITDA in the table below. Both EBITDA and Adjusted EBITDA are considered non-GAAP financial measures. Generally, a non-GAAP financial measure is a numerical measure of a companys performance, financial position or cash flows that either excludes or includes amounts that are not normally included or excluded in the most directly comparable measure calculated and presented in accordance with GAAP. Non-GAAP measures used by the Company may differ from similar measures used by other companies, even when similar terms are used to identify such measures. We believe that EBITDA and Adjusted EBITDA provide helpful information with respect to our operating performance and cash flows including our ability to meet our future debt service, capital expenditures and working capital requirements. Adjusted EBITDA also provides helpful information as it is the primary measure used in certain financial covenants contained in the Senior Credit Facilities.
13
The following unaudited table sets forth reconciliations of net (loss) income to EBITDA and EBITDA to Adjusted EBITDA for the periods presented:
Years ended December 31, | ||||||||||||
(in millions) | 2010 | 2011 | 2012 | |||||||||
|
||||||||||||
Net (loss) income |
$ | (29.2 | ) | $ | 17.1 | $ | 119.0 | |||||
Depreciation and amortization |
209.4 | 204.9 | 210.2 | |||||||||
Income tax (benefit) expense |
(7.8 | ) | 11.2 | 67.1 | ||||||||
Interest expense, net |
391.9 | 324.2 | 307.4 | |||||||||
|
|
|||||||||||
EBITDA |
564.3 | 557.4 | 703.7 | |||||||||
|
|
|||||||||||
Non-cash equity-based compensation |
11.5 | 19.5 | 22.1 | |||||||||
Sponsor fees(i) |
5.0 | 5.0 | 5.0 | |||||||||
Consulting and debt-related professional fees |
15.1 | 5.1 | 0.6 | |||||||||
Net (gain) loss on extinguishments of long-term debt |
(2.0 | ) | 118.9 | 17.2 | ||||||||
Other adjustments(ii) |
7.9 | 11.4 | 18.0 | |||||||||
|
|
|||||||||||
Adjusted EBITDA |
$ | 601.8 | $ | 717.3 | $ | 766.6 | ||||||
|
(i) | Reflects historical fees paid to affiliates of the Sponsors under the Management Services Agreement. In connection with this offering, we intend to terminate the Management Services Agreement. See Certain transactionsManagement Services Agreement. |
(ii) | Includes certain retention costs and equity investment income and a litigation loss in the fourth quarter of 2012. |
The following unaudited table sets forth a reconciliation of EBITDA to net cash provided by operating activities for the periods presented:
Years ended December 31, | ||||||||||||
(in millions) | 2010 | 2011 | 2012 | |||||||||
|
||||||||||||
EBITDA |
$ | 564.3 | $ | 557.4 | $ | 703.7 | ||||||
Depreciation and amortization |
(209.4 | ) | (204.9 | ) | (210.2 | ) | ||||||
Income tax benefit (expense) |
7.8 | (11.2 | ) | (67.1 | ) | |||||||
Interest expense, net |
(391.9 | ) | (324.2 | ) | (307.4 | ) | ||||||
|
|
|||||||||||
Net (loss) income |
(29.2 | ) | 17.1 | 119.0 | ||||||||
|
|
|||||||||||
Depreciation and amortization |
209.4 | 204.9 | 210.2 | |||||||||
Equity-based compensation expense |
11.5 | 19.5 | 22.1 | |||||||||
Amortization of deferred financing costs and debt premium |
18.0 | 15.7 | 13.6 | |||||||||
Allowance for doubtful accounts |
(1.3 | ) | 0.4 | | ||||||||
Deferred income taxes |
(4.3 | ) | (10.2 | ) | (56.3 | ) | ||||||
Realized loss on interest rate swap agreements |
51.5 | 2.8 | | |||||||||
Mark to market loss on interest rate derivatives |
4.7 | 4.2 | 0.9 | |||||||||
Net (gain) loss on extinguishments of long-term debt |
(2.0 | ) | 118.9 | 17.2 | ||||||||
Net loss on sale and disposals of assets |
0.7 | 0.3 | 0.1 | |||||||||
Changes in assets and liabilities |
165.3 | (158.3 | ) | (9.4 | ) | |||||||
Other non-cash items |
(0.6 | ) | (0.6 | ) | | |||||||
|
|
|||||||||||
Net cash provided by operating activities |
$ | 423.7 | $ | 214.7 | $ | 317.4 | ||||||
|
(4) | Non-GAAP net income is considered a non-GAAP financial measure. Generally, a non-GAAP financial measure is a numerical measure of a companys performance, financial position or cash flows that either excludes or includes amounts that are not normally included or excluded in the most directly comparable measure calculated and presented in accordance with GAAP. Non-GAAP measures used by the Company may differ from similar measures used by other companies, even when similar terms are used to identify such measures. We believe that non-GAAP net income provides meaningful information regarding our operating performance and our prospects for the future. This supplemental measure excludes, among other things, charges related to the amortization of Acquisition-related intangibles, non-cash equity-based compensation and gains and losses from the early extinguishment of debt. |
14
The following unaudited table sets forth a reconciliation of net (loss) income to non-GAAP net income for the periods presented:
Years ended December 31, | ||||||||||||
(in millions) | 2010 | 2011 | 2012 | |||||||||
|
||||||||||||
Net (loss) income |
$ | (29.2 | ) | $ | 17.1 | $ | 119.0 | |||||
Amortization of intangibles(i) |
166.8 | 165.7 | 163.7 | |||||||||
Non-cash equity-based compensation |
11.5 | 19.5 | 22.1 | |||||||||
Net (gain) loss on extinguishments of long-term debt |
(2.0 | ) | 118.9 | 17.2 | ||||||||
Interest expense adjustment related to extinguishments of long-term debt(ii) |
(0.7 | ) | (19.4 | ) | (3.3 | ) | ||||||
Debt-related refinancing costs(iii) |
5.6 | 3.8 | | |||||||||
Aggregate adjustment for income taxes(iv) |
(66.3 | ) | (106.8 | ) | (71.6 | ) | ||||||
|
|
|||||||||||
Non-GAAP net income |
$ | 85.7 | $ | 198.8 | $ | 247.1 | ||||||
|
(i) | Includes amortization expense for Acquisition-related intangible assets, primarily customer relationships and trade names. |
(ii) | Reflects adjustments to interest expense resulting from debt extinguishments. Represents the difference between interest expense previously recognized under the effective interest method and actual interest paid. |
(iii) | Represents fees and costs expensed related to the December 2010 and March 2011 amendments to the Term Loan Facility. |
(iv) | Based on a normalized effective tax rate of 39.0%. |
(5) | Cash conversion cycle is defined as days of sales outstanding in accounts receivable plus days of supply in inventory minus days of purchases outstanding in accounts payable, based on a rolling three-month average. |
(6) | Revenue per coworker is defined as annual net sales divided by the average number of coworkers employed during such year (calculated as the sum of the number of coworkers employed at the beginning and end of the year divided by two). |
15
You should carefully consider each of the following risk factors and all of the other information set forth in this prospectus before deciding to invest in our common stock. Any of the following risks could materially and adversely affect our business, financial condition or results of operations. Additional risks and uncertainties not presently known to us or that we currently believe not to be material may also adversely affect our business, financial condition or results of operations. If that were to occur, the market price of our common stock could decline, and you may lose all or part of your original investment.
Risks related to our business
General economic conditions could negatively affect technology spending by our customers and put downward pressure on prices, which may have an adverse impact on our business, results of operations or cash flows.
Weak economic conditions generally, sustained uncertainty about global economic conditions, skepticism about the resolution of U.S. fiscal cliff negotiations and the implementation of resulting agreements, concerns about future scheduled budgetary cuts and that the U.S. government may reach its debt ceiling in early 2013, or a prolonged or further tightening of credit markets could cause our customers and potential customers to postpone or reduce spending on technology products or services or put downward pressure on prices, which could have an adverse effect on our business, results of operations or cash flows. For example, during the economic downturn at the end of 2008 and in 2009, due to a number of factors, including declines in the availability of credit, weakening consumer and business confidence and increased unemployment, we experienced significantly reduced revenue and gross margins when our customers and potential customers reduced their spending on technology and put downward pressure on prices.
Our financial performance could be adversely affected by decreases in spending on technology products and services by our Public segment customers.
Our sales to our Public segment customers are impacted by government spending policies, budget priorities and revenue levels. Although our sales to the federal government are diversified across multiple agencies and departments, they collectively accounted for approximately 10% of 2012 net sales. An adverse change in government spending policies (including budget cuts at the federal level resulting from sequestration), budget priorities or revenue levels could cause our Public segment customers to reduce their purchases or to terminate or not renew their contracts with us, which could adversely affect our business, results of operations or cash flows.
Our business depends on our vendor partner relationships and the availability of their products.
We purchase products for resale from vendor partners, which include OEMs and software publishers, and wholesale distributors. For the year ended December 31, 2012, we purchased approximately 52% of the products we sold directly from vendor partners and the remaining amount from wholesale distributors. We are authorized by vendor partners to sell all or some of their products via direct marketing activities. Our authorization with each vendor partner is subject to specific terms and conditions regarding such things as sales channel restrictions, product return privileges, price protection policies, purchase discounts and vendor partner
16
programs and funding, including purchase rebates, sales volume rebates, purchasing incentives and cooperative advertising reimbursements. However, we do not have any long-term contracts with our vendor partners and many of these arrangements are terminable upon notice by either party. A reduction in vendor partner programs or funding or our failure to timely react to changes in vendor partner programs or funding could have an adverse effect on our business, results of operations or cash flows. In addition, a reduction in the amount of credit granted to us by our vendor partners could increase our need for, and the cost of, working capital and could have an adverse effect on our business, results of operations or cash flows, particularly given our substantial indebtedness.
From time to time, vendor partners may terminate or limit our right to sell some or all of their products or change the terms and conditions or reduce or discontinue the incentives that they offer us. For example, there is no assurance that, as our vendor partners continue to sell directly to end users and through resellers, they will not limit or curtail the availability of their products to resellers like us. Any such termination or limitation or the implementation of such changes could have a negative impact on our business, results of operations or cash flows.
Although we purchase from a diverse vendor base, in 2012, products we purchased from distributors Ingram Micro, Tech Data and SYNNEX represented 12%, 10% and 9%, respectively, of our total purchases. In addition, sales of Apple, Cisco, EMC, Hewlett-Packard, Lenovo and Microsoft products comprise a substantial portion of our sales, representing approximately 56% of net sales in 2012. Sales of products manufactured by Hewlett-Packard and Cisco represented approximately 21% and 13%, respectively, of our 2012 net sales. The loss of, or change in business relationship with, any of these or any other key vendor partners, the diminished availability of their products, or backlogs for their products leading to manufacturer allocation, could reduce the supply and increase the cost of products we sell and negatively impact our competitive position.
Additionally, the relocation of key distributors utilized in our purchasing model could increase our need for, and the cost of, working capital and have an adverse effect on our business, results of operations or cash flows. Further, the sale, spin-off or combination of any of our vendor partners and/or certain of their business units, including any such sale to or combination with a vendor with whom we do not currently have a commercial relationship or whose products we do not sell, could have an adverse impact on our business, results of operations or cash flows.
Our sales are dependent on continued innovations in hardware, software and services offerings by our vendor partners and the competitiveness of their offerings, and our ability to partner with new and emerging technology providers.
The technology industry is characterized by rapid innovation and the frequent introduction of new and enhanced hardware, software and services offerings. We have been and will continue to be dependent on innovations in hardware, software and services offerings, as well as the acceptance of those innovations by customers. A decrease in the rate of innovation, or the lack of acceptance of innovations by customers, could have an adverse effect on our business, results of operations or cash flows.
In addition, if we are unable to keep up with changes in technology and new hardware, software and services offerings, for example by providing the appropriate training to our account managers, sales technology specialists and engineers to enable them to effectively sell and deliver such new offerings to customers, our business, results of operations or cash flows could be adversely affected.
17
We also are dependent upon our vendor partners for the development and marketing of hardware, software and services to compete effectively with hardware, software and services of vendors whose products and services we do not currently offer or that we are not authorized to offer in one or more customer channels. To the extent that a vendors offering that is highly in demand is not available to us for resale in one or more customer channels, and there is not a competitive offering from another vendor that we are authorized to sell in such customer channels, our business, results of operations or cash flows could be adversely impacted.
Substantial competition could reduce our market share and significantly harm our financial performance.
Our current competition includes:
| resellers, such as Dimension Data, ePlus, Insight Enterprises, PC Connection, PCM, Presidio, Softchoice, World Wide Technology, and many smaller resellers; |
| manufacturers who sell directly to customers, such as Dell, Hewlett-Packard and Apple; |
| e-tailers, such as Amazon, Newegg, TigerDirect.com and Buy.com; |
| large service providers and system integrators, such as IBM, Accenture, Hewlett-Packard and Dell; and |
| retailers (including their e-commerce activities), such as Staples, Office Depot and Office Max. |
We expect the competitive landscape in which we compete to continue to change as new technologies are developed. While innovation can help our business as it creates new offerings for us to sell, it can also disrupt our business model and create new and stronger competitors.
Some of our hardware and software vendor partners sell, and could intensify their efforts to sell, their products directly to our customers. In addition, traditional OEMs have increased their services capabilities through mergers and acquisitions with service providers, which could potentially increase competition in the market to provide comprehensive technology solutions to customers. Moreover, newer, potentially disruptive technologies exist and are being developed that deliver technology solutions as a service, for example, cloud-based solutions, including software as a service (SaaS), infrastructure as a service (IaaS) and platform as a service (PaaS). These technologies could increase the amount of sales directly to customers rather than through resellers like us, or could lead to a reduction in our profitability. If any of these trends becomes more prevalent, it could adversely affect our business, results of operations or cash flows.
We focus on offering a high level of service to gain new customers and retain existing customers. To the extent we face increased competition to gain and retain customers, we may be required to reduce prices, increase advertising expenditures or take other actions which could adversely affect our business, results of operations or cash flows. Additionally, some of our competitors may reduce their prices in an attempt to stimulate sales, which may require us to reduce prices. This would require us to sell a greater number of products to achieve the same level of net sales and gross profit. If such a reduction in prices occurs and we are unable to attract new customers and sell increased quantities of products, our sales growth and profitability could be adversely affected.
18
The success of our business depends on the continuing development, maintenance and operation of our information technology systems.
Our success is dependent on the accuracy, proper utilization and continuing development of our information technology systems, including our business systems, Web servers and voice and data networks. The quality and our utilization of the information generated by our information technology systems, and our success in implementing new systems and upgrades, affects, among other things, our ability to:
| conduct business with our customers; |
| manage our inventory and accounts receivable; |
| purchase, sell, ship and invoice our hardware and software products and provide and invoice our services efficiently and on a timely basis; and |
| maintain our cost-efficient operating model. |
The integrity of our information technology systems is vulnerable to disruption due to forces beyond our control. While we have taken steps to protect our information technology systems from a variety of threats, including computer viruses and malicious hackers, there can be no guarantee that those steps will be effective. Furthermore, although we have redundant systems at a separate location to back up our primary systems, there can be no assurance that these redundant systems will operate properly if and when required. Any disruption to or infiltration of our information technology systems could significantly harm our business and results of operations.
Breaches of data security could impact our business.
Our business involves the storage and transmission of proprietary information and sensitive or confidential data, including personal information of coworkers, customers and others. In addition, we operate three customer data centers which may store and transmit both business-critical data and confidential information of our customers. In connection with our services business, our coworkers also have access to our customers confidential data and other information. We have privacy and data security policies in place that are designed to prevent security breaches; however, breaches in security could expose us, our customers or other individuals to a risk of public disclosure, loss or misuse of this information, resulting in legal claims or proceedings, liability or regulatory penalties under laws protecting the privacy of personal information, as well as the loss of existing or potential customers and damage to our brand and reputation. In addition, the cost and operational consequences of implementing further data protection measures could be significant. Such breaches, costs and consequences could adversely affect our business, results of operations or cash flows.
The failure to comply with our Public segment contracts or applicable laws and regulations could result in, among other things, termination, fines or other liabilities, and changes in procurement regulations could adversely impact our business, results of operations or cash flows.
Revenues from our Public segment customers are derived from sales to governmental departments and agencies, educational institutions and healthcare customers, through various contracts and open market sales of products and services. Sales to Public segment customers are highly regulated. Noncompliance with contract provisions, government procurement regulations or other applicable laws or regulations (including but not limited to the False Claims Act and the
19
Medicare and Medicaid Anti-Kickback Statute) could result in civil, criminal and administrative liability, including substantial monetary fines or damages, termination of government contracts or other Public segment customer contracts, and suspension, debarment or ineligibility from doing business with the government and other customers in the Public segment. In addition, generally contracts in the Public segment are terminable at any time for convenience of the contracting agency or group purchasing organization or upon default. The effect of any of these possible actions could adversely affect our business, results of operations or cash flows. In addition, the adoption of new or modified procurement regulations and other requirements may increase our compliance costs and reduce our gross margins, which could have a negative effect on our business, results of operations or cash flows.
If we fail to provide high-quality services to our customers, or if our third-party service providers fail to provide high-quality services to our customers, our reputation, business, results of operations or cash flows could be adversely affected.
Our service offerings include field services, managed services, warranties, configuration services, partner services and telecom services. Additionally, we deliver and manage mission critical software, systems and network solutions for our customers. Finally, we also offer certain services, such as implementation and installation services and repair services, to our customers through various third-party service providers engaged to perform these services on our behalf. If we or our third-party service providers fail to provide high quality services to our customers or such services result in a disruption of our customers businesses, this could, among other things, result in legal claims and proceedings and liability, and our reputation with our customers, our brand and our business, results of operations or cash flows could be adversely affected.
If we lose any of our key personnel, or are unable to attract and retain the talent required for our business, our business could be disrupted and our financial performance could suffer.
Our success is heavily dependent upon our ability to attract, develop and retain key personnel to manage and grow our business, including our key executive, management, sales, services and technical coworkers.
Our future success will depend to a significant extent on the efforts of Thomas E. Richards, our Chairman and Chief Executive Officer, as well as the continued service and support of our other executive officers. Our future success also will depend on our ability to retain our customer-facing coworkers, who have been given critical CDW knowledge regarding, and the opportunity to develop strong relationships with, many of our customers. In addition, as we seek to expand our offerings of value-added services and solutions, our success will even more heavily depend on attracting and retaining highly skilled technology specialists and engineers, for whom the market is extremely competitive.
Our inability to attract, develop and retain key personnel could have an adverse effect on our relationships with our vendor partners and customers and adversely affect our ability to expand our offerings of value-added services and solutions. Moreover, our inability to train our sales, services and technical personnel effectively to meet the rapidly changing technology needs of our customers could cause a decrease in the overall quality and efficiency of such personnel. Such consequences could adversely affect our business, results of operations or cash flows.
The interruption of the flow of products from suppliers could disrupt our supply chain.
A significant portion of the products we sell are manufactured or purchased by our vendor partners outside of the U.S., primarily in Asia. Political, social or economic instability in Asia, or in
20
other regions in which our vendor partners purchase or manufacture the products we sell, could cause disruptions in trade, including exports to the U.S. Other events that could also cause disruptions to our supply chain include:
| the imposition of additional trade law provisions or regulations; |
| the imposition of additional duties, tariffs and other charges on imports and exports; |
| foreign currency fluctuations; |
| natural disasters or other adverse occurrences at, or affecting, any of our suppliers facilities; |
| restrictions on the transfer of funds; |
| the financial instability or bankruptcy of manufacturers; and |
| significant labor disputes, such as strikes. |
We cannot predict whether the countries in which the products we sell are purchased or manufactured, or may be purchased or manufactured in the future, will be subject to new or additional trade restrictions or sanctions imposed by the U.S. or foreign governments, including the likelihood, type or effect of any such restrictions. Trade restrictions, including new or increased tariffs or quotas, embargos, sanctions, safeguards and customs restrictions against the products we sell, as well as foreign labor strikes and work stoppages or boycotts, could increase the cost or reduce the supply of product available to us and adversely affect our business, results of operations or cash flows.
A natural disaster or other adverse occurrence at one of our primary facilities or customer data centers could damage our business.
Substantially all of our corporate, warehouse and distribution functions are located at our Vernon Hills, Illinois facilities and our second distribution center in North Las Vegas, Nevada. If the warehouse and distribution equipment at one of our distribution centers were to be seriously damaged by a natural disaster or other adverse occurrence, we could utilize the other distribution center or third-party distributors to ship products to our customers. However, this may not be sufficient to avoid interruptions in our service and may not enable us to meet all of the needs of our customers and would cause us to incur incremental operating costs. In addition, we operate three customer data centers and numerous sales offices which may contain both business-critical data and confidential information of our customers. A natural disaster or other adverse occurrence at any of the customer data centers or at any of our major sales offices could negatively impact our business, results of operations or cash flows.
We are heavily dependent on commercial delivery services.
We generally ship hardware products to our customers by FedEx, United Parcel Service and other commercial delivery services and invoice customers for delivery charges. If we are unable to pass on to our customers future increases in the cost of commercial delivery services, our profitability could be adversely affected. Additionally, strikes or other service interruptions by such shippers could adversely affect our ability to deliver products on a timely basis.
We are exposed to accounts receivable and inventory risks.
We extend credit to our customers for a significant portion of our net sales, typically on 30-day payment terms. We are subject to the risk that our customers may not pay for the products they have purchased, or may pay at a slower rate than we have historically experienced, the risk of which is heightened during periods of economic downturn or uncertainty or, in the case of Public segment customers, during periods of budget constraints.
21
We are also exposed to inventory risks as a result of the rapid technological changes that affect the market and pricing for the products we sell. We seek to minimize our inventory exposure through a variety of inventory management procedures and policies, including our rapid-turn inventory model, as well as vendor price protection and product return programs. However, if we were unable to maintain our rapid-turn inventory model, if there were unforeseen product developments that created more rapid obsolescence or if our vendor partners were to change their terms and conditions, our inventory risks could increase. We also from time to time take advantage of cost savings associated with certain opportunistic bulk inventory purchases offered by our vendor partners or we may decide to carry high inventory levels of certain products that have limited or no return privileges due to customer demand or request. These bulk purchases could increase our exposure to inventory obsolescence.
We could be exposed to additional risks if we make acquisitions or enter into alliances.
We may pursue transactions, including acquisitions or alliances, in an effort to extend or complement our existing business. These types of transactions involve numerous business risks, including finding suitable transaction partners and negotiating terms that are acceptable to us, the diversion of managements attention from other business concerns, extending our product or service offerings into areas in which we have limited experience, entering into new geographic markets, the potential loss of key coworkers or business relationships and successfully integrating acquired businesses, any of which could adversely affect our operations.
In addition, our financial results could be adversely affected by financial adjustments required by GAAP in connection with these types of transactions where significant goodwill or intangible assets are recorded. To the extent the value of goodwill or identifiable intangible assets with indefinite lives becomes impaired, we may be required to incur material charges relating to the impairment of those assets.
Our future operating results may fluctuate significantly.
We may experience significant variations in our future quarterly results of operations. These fluctuations may cause the market price of our common stock to be volatile and may result from many factors, including the condition of the technology industry in general, shifts in demand and pricing for hardware, software and services and the introduction of new products or upgrades.
Our operating results are also highly dependent on our level of gross profit as a percentage of net sales. Our gross profit percentage fluctuates due to numerous factors, some of which may be outside of our control, including general macroeconomic conditions; pricing pressures; changes in product costs from our vendor partners; the availability of price protection, purchase discounts and incentive programs from our vendor partners; changes in product, order size and customer mix; the risk of some items in our inventory becoming obsolete; increases in delivery costs that we cannot pass on to customers; and general market and competitive conditions.
In addition, our cost structure is based, in part, on anticipated sales and gross margins. Therefore, we may not be able to adjust our cost structure quickly enough to compensate for any unexpected sales or gross margin shortfall, and any such inability could have an adverse effect on our business, results of operations or cash flows.
We are exposed to risks from legal proceedings and audits.
We are party to various legal proceedings that arise in the ordinary course of our business, which include commercial, employment, tort and other litigation.
22
We are subject to intellectual property infringement claims against us in the ordinary course of our business, either because of the products and services we sell or the business systems and processes we use to sell such products and services, in the form of cease-and-desist letters, licensing inquiries, lawsuits and other communications and demands. In our industry, such intellectual property claims have become more frequent as the complexity of technological products and the intensity of competition in our industry have increased. Increasingly, many of these assertions are brought by non-practicing entities whose principal business model is to secure patent licensing revenue, but we may also be subject to suits from competitors who may seek licensing revenue, lost profits and/or an injunction preventing us from engaging in certain activities, including selling certain products and services.
Because of our significant sales to governmental entities, we also are subject to audits by federal, state and local authorities. We also are subject to audits by various vendor partners and large customers, including government agencies, relating to purchases and sales under various contracts. In addition, we are subject to indemnification claims under various contracts.
Current and future litigation, infringement claims, governmental proceedings, audits or indemnification claims that we face may result in substantial costs and expenses and significantly divert the attention of our management regardless of the outcome. In addition, current and future litigation, infringement claims, governmental proceedings, audits or indemnification claims could lead to increased costs or interruptions of our normal business operations. Litigation, infringement claims, governmental proceedings, audits or indemnification claims involve uncertainties and the eventual outcome of any litigation, infringement claim, governmental proceeding, audit or indemnification claim could adversely affect our business, results of operations or cash flows.
We have significant deferred cancellation of debt income.
As a result of a 2009 debt modification, we realized $395.5 million of cancellation of debt income (CODI). We made an election under Code Section 108(i) to defer this CODI from taxable income, pursuant to which we are also required to defer certain original issue discount (OID) deductions as they accrue. As of December 31, 2012, we had already deferred approximately $110.4 million of OID deductions and, on the relevant remaining debt instruments, we have $34.7 million of OID deductions that have yet to be accrued. Starting in 2014 we will be required to include the deferred CODI into taxable income ratably over a five-year period ending in 2018. During this same period we will also be permitted to benefit from our deferred OID deductions. Because we have more CODI than the aggregate of our deferred and unaccrued OID on the relevant remaining debt instruments, we will have a future cash tax liability associated with our significant deferred CODI. We have reflected the associated cash tax liability in our deferred taxes for financial accounting purposes.
All of our deferred CODI will be accelerated into current taxable income if, prior to 2018, we engage in a so-called impairment transaction and the gross value of our assets immediately afterward is less than 110% of the sum of our total liabilities and the tax on the net amount of our deferred CODI and OID (the 110% test) as determined under the applicable Treasury Regulations. An impairment transaction is any transaction that impairs our ability to pay the tax on our deferred CODI, and includes dividends or distributions with respect to our equity and charitable contributions, in each case in a manner that is not consistent with our historical practice within the meaning of the applicable Treasury Regulations.
23
Prior to 2018, our willingness to pay dividends or make distributions with respect to our equity could be adversely affected if, at the time, we do not meet the 110% test and, as a result, the payment of a dividend or the making of a distribution would accelerate the tax payable with respect to our deferred CODI. We currently believe that based on our interpretation of applicable Treasury Regulations, the gross value of our assets will exceed 110% of the sum of our total liabilities and the tax on the net amount of our deferred CODI and OID upon the completion of this offering. However, we cannot assure you that this will continue to be true in the future.
Risks related to our indebtedness
We have a substantial amount of indebtedness, which could have important consequences to our business.
We have a substantial amount of indebtedness. As of December 31, 2012, on a pro forma basis after giving effect to the 2013 Debt Transactions, this offering and the application of the net proceeds therefrom as described in Use of proceeds, we had $ billion of total long-term debt outstanding and $249.2 million of obligations outstanding under our inventory financing agreements, and the ability to borrow an additional $622.4 million under the senior secured asset-based revolving credit facility (the ABL Facility, and together with the Term Loan Facility, the Senior Credit Facilities). Our substantial indebtedness could have important consequences, including the following:
| making it more difficult for us to satisfy our obligations with respect to our indebtedness; |
| requiring us to dedicate a substantial portion of our cash flow from operations to debt service payments on our and our subsidiaries debt, which reduces the funds available for working capital, capital expenditures, acquisitions and other general corporate purposes; |
| requiring us to comply with restrictive covenants in the Senior Credit Facilities and the Indentures, which limit the manner in which we conduct our business; |
| making it more difficult for us to obtain vendor financing from our vendor partners; |
| limiting our flexibility in planning for, or reacting to, changes in the industry in which we operate; |
| placing us at a competitive disadvantage compared to any of our less leveraged competitors; |
| increasing our vulnerability to both general and industry-specific adverse economic conditions; and |
| limiting our ability to obtain additional debt or equity financing to fund future working capital, capital expenditures, acquisitions or other general corporate requirements and increasing our cost of borrowing. |
We will be required to generate sufficient cash to service our indebtedness and, if not successful, we may be forced to take other actions to satisfy our obligations under our indebtedness.
Our ability to make scheduled payments on or to refinance our debt obligations depends on our financial and operating performance, which is subject to prevailing economic and competitive
24
conditions and to certain financial, business and other factors beyond our control. Our outstanding long-term debt will impose significant cash interest payment obligations on us in 2013 and subsequent years and, accordingly, we will have to generate significant cash flow from operating activities to fund our debt service obligations. We cannot assure you that we will maintain a level of cash flows from operating activities sufficient to permit us to pay the principal, premium, if any, and interest on our indebtedness. See Managements discussion and analysis of financial condition and results of operationsLiquidity and capital resources.
If our cash flows and capital resources are insufficient to fund our debt service obligations, we may be forced to reduce or delay capital expenditures, sell assets or operations, seek additional debt or equity capital, restructure or refinance our indebtedness, or revise or delay our strategic plan. We cannot assure you that we would be able to take any of these actions, that these actions would be successful and permit us to meet our scheduled debt service obligations or satisfy our capital requirements, or that these actions would be permitted under the terms of our existing or future debt agreements, including the Senior Credit Facilities or the indentures respectively governing the Senior Subordinated Notes, the senior secured notes due 2018 (the Senior Secured Notes) and the senior notes due 2019 (the Senior Notes) (such indentures collectively referred to herein as the Indentures). In the absence of such operating results and resources, we could face substantial liquidity problems and might be required to dispose of material assets or operations to meet our debt service and other obligations. The Senior Credit Facilities and the Indentures restrict our ability to dispose of assets and use the proceeds from the disposition. We may not be able to consummate those dispositions or to obtain the proceeds which we could realize from them and these proceeds may not be adequate to meet any debt service obligations then due. See Description of certain indebtedness. Furthermore, the Sponsors have no obligation to provide us with debt or equity financing.
If we cannot make scheduled payments on our debt, we will be in default and, as a result:
| our debt holders could declare all outstanding principal and interest to be due and payable; |
| the lenders under the Senior Credit Facilities could foreclose against the assets securing the borrowings from them and the lenders under the Term Loan Facility could terminate their commitments to lend us money; and |
| we could be forced into bankruptcy or liquidation. |
Despite our indebtedness levels, we and our subsidiaries may be able to incur substantially more debt, including secured debt. This could further increase the risks associated with our leverage.
We and our subsidiaries may be able to incur substantial additional indebtedness in the future. The terms of the Senior Credit Facilities and the Indentures do not fully prohibit us or our subsidiaries from doing so. To the extent that we incur additional indebtedness or such other obligations, the risks associated with our substantial indebtedness described above, including our possible inability to service our debt, will increase. As of December 31, 2012, we had approximately $622.4 million available for additional borrowing under the ABL Facility after taking into account borrowing base limitations (net of $1.7 million of issued and undrawn letters of credit and $275.9 million of reserves related to our floorplan sub-facility). See Description of certain indebtedness.
25
Restrictive covenants under the Senior Credit Facilities and the Indentures may adversely affect our operations and liquidity.
The Senior Credit Facilities and the Indentures contain, and any future indebtedness of ours may contain, various covenants that limit our ability to, among other things:
| incur or guarantee additional debt; |
| pay dividends or make distributions to holders of our capital stock or to make certain other restricted payments or investments; |
| repurchase or redeem capital stock; |
| make loans, capital expenditures or investments or acquisitions; |
| receive dividends or other payments from our subsidiaries; |
| enter into transactions with affiliates; |
| create liens; |
| merge or consolidate with other companies or transfer all or substantially all of our assets; |
| transfer or sell assets, including capital stock of subsidiaries; and |
| prepay, repurchase or redeem debt. |
As a result of these covenants, we are limited in the manner in which we conduct our business and we may be unable to engage in favorable business activities or finance future operations or capital needs. In addition, the restrictive covenants in the Term Loan Facility require us to maintain a specified senior secured leverage ratio. A breach of any of these covenants or any of the other restrictive covenants would result in a default under the Senior Credit Facilities. Upon the occurrence of an event of default under the Senior Credit Facilities, the lenders:
| will not be required to lend any additional amounts to us; |
| could elect to declare all borrowings outstanding thereunder, together with accrued and unpaid interest and fees, to be due and payable; |
| could require us to apply all of our available cash to repay these borrowings; or |
| could prevent us from making payments on the Senior Subordinated Notes; |
any of which could result in an event of default under the Indentures.
If we were unable to repay those amounts, the lenders under the Senior Credit Facilities could proceed against the collateral granted to them to secure our borrowings thereunder. We have pledged a significant portion of our assets as collateral under the Senior Credit Facilities and the Senior Secured Notes. If the lenders under the Senior Credit Facilities or the holders of the Senior Secured Notes accelerate the repayment of borrowings, we cannot assure you that we will have sufficient assets to repay the Senior Credit Facilities and our other indebtedness or the ability to borrow sufficient funds to refinance such indebtedness. Even if we were able to obtain new financing, it may not be on commercially reasonable terms, or terms that are acceptable to us. See Description of certain indebtedness.
26
In addition, under the ABL Facility, we are permitted to borrow an aggregate amount of up to $900 million; however, our ability to borrow under the ABL Facility is limited by a borrowing base and a liquidity condition. The borrowing base at any time equals the sum of up to 85% of CDW LLC and its subsidiary guarantors eligible accounts receivable (net of accounts reserves) (up to 30% of such eligible accounts receivable which can consist of federal government accounts receivable) plus the lesser of (i) 70% of CDW LLC and its subsidiary guarantors eligible inventory (valued at cost and net of inventory reserves) and (ii) the product of 85% multiplied by the net orderly liquidation value percentage multiplied by eligible inventory (valued at cost and net of inventory reserves), less reserves (other than accounts reserves and inventory reserves). The borrowing base in effect as of December 31, 2012 was $1,018.2 million.
Our ability to borrow under the ABL Facility is also limited by a minimum liquidity condition, which provides that, if excess cash availability is less than the lesser of (i) $90 million or (ii) the greater of (A) 10% of the borrowing base or (B) $60 million, the lenders are not required to lend any additional amounts under the ABL Facility unless the consolidated fixed charge coverage ratio (as defined in the credit agreement for the ABL Facility) is at least 1.0 to 1.0. Moreover, the ABL Facility provides discretion to the agent bank acting on behalf of the lenders to impose additional availability reserves, which could materially impair the amount of borrowings that would otherwise be available to us. We cannot assure you that the agent bank will not impose such reserves or, were it to do so, that the resulting impact of this action would not materially and adversely impair our liquidity.
Variable rate indebtedness subjects us to interest rate risk, which could cause our debt service obligations to increase significantly.
Certain of our borrowings, primarily borrowings under the Senior Credit Facilities, are at variable rates of interest and expose us to interest rate risk. As of December 31, 2012, we had $1,339.5 million of variable rate debt outstanding. If interest rates increase, our debt service obligations on the variable rate indebtedness would increase even though the amount borrowed remained the same, and our net income would decrease. Although we have entered into interest rate cap agreements on the Term Loan Facility to reduce interest rate volatility, we cannot assure you we will be able to do so in the future on acceptable terms or that such caps or the caps we have in place now will be effective.
Risks related to this offering and ownership of our common stock
An active trading market for our common stock may not develop.
Since 2007 and prior to this offering, there has been no public market for our common stock. The initial public offering price for our common stock will be determined through negotiations between us and the underwriters, and market conditions, and may not be indicative of the market price of our common stock after this offering. If you purchase shares of our common stock, you may not be able to resell those shares at or above the initial public offering price. We cannot predict the extent to which investor interest in us will lead to the development of an active trading market for our common stock or how liquid that market might become. An active public market for our common stock may not develop or be sustained after this offering. If an active public market does not develop or is not sustained, it may be difficult for you to sell your shares of common stock at a price that is attractive to you, or at all.
27
Our common stock price may be volatile or may decline regardless of our operating performance, and you may not be able to resell your shares at or above the initial public offering price.
After this offering, the market price for our common stock is likely to be volatile, in part because our shares have not been traded publicly. In addition, the market price of our common stock may fluctuate significantly in response to a number of factors, many of which we cannot control, including those described under Risks related to our business and Risks related to our indebtedness and the following:
| changes in financial estimates by any securities analysts who follow our common stock, our failure to meet these estimates or failure of securities analysts to initiate or maintain coverage of our common stock; |
| downgrades by any securities analysts who follow our common stock; |
| future sales of our common stock by our officers, directors and significant stockholders, including the Sponsors; |
| market conditions or trends in our industry or the economy as a whole; |
| investors perceptions of our prospects; |
| announcements by us or our competitors of significant contracts, acquisitions, joint ventures or capital commitments; and |
| changes in key personnel. |
In addition, the stock markets have experienced extreme price and volume fluctuations that have affected and continue to affect the market prices of equity securities of many companies, including companies in our industry. In the past, stockholders have instituted securities class action litigation following periods of market volatility. If we were involved in securities litigation, we could incur substantial costs, and our resources and the attention of management could be diverted from our business.
The Sponsors will have the ability to control significant corporate activities after the completion of this offering and their interests may not coincide with yours.
After the consummation of this offering, the Sponsors will beneficially own approximately % of our common stock, assuming the underwriters do not exercise their option to purchase additional shares. If the underwriters exercise in full their option to purchase additional shares, the Sponsors will beneficially own approximately % of our common stock. As a result of their ownership, the Sponsors, so long as they hold a majority of our outstanding common stock, will have the ability to control the outcome of matters submitted to a vote of stockholders and, through our board of directors, the ability to control decisionmaking with respect to our business direction and policies. Matters over which the Sponsors will, directly or indirectly, exercise control following this offering include:
| the election of our board of directors and the appointment and removal of our officers; |
| mergers and other business combination transactions, including proposed transactions that would result in our stockholders receiving a premium price for their shares; |
| other acquisitions or dispositions of businesses or assets; |
28
| incurrence of indebtedness and the issuance of equity securities; |
| repurchase of stock and payment of dividends; and |
| the issuance of shares to management under our equity incentive plans. |
Even if the Sponsors ownership of our shares falls below a majority, they may continue to be able to strongly influence or effectively control our decisions. Under our amended and restated certificate of incorporation, the Sponsors and their affiliates will not have any obligation to present to us, and the Sponsors may separately pursue corporate opportunities of which they become aware, even if those opportunities are ones that we would have pursued if granted the opportunity. See Description of capital stockCorporate opportunity.
Future sales of our common stock, or the perception in the public markets that these sales may occur, may depress our stock price.
Sales of substantial amounts of our common stock in the public market after this offering, or the perception that these sales could occur, could adversely affect the price of our common stock and could impair our ability to raise capital through the sale of additional shares. Upon completion of this offering, we will have shares of common stock outstanding. The shares of common stock offered in this offering will be freely tradable without restriction under the Securities Act of 1933, as amended (the Securities Act), except that any shares of our common stock that may be acquired by our directors, executive officers and other affiliates, as that term is defined in the Securities Act, may be sold only in compliance with the limitations described in Shares eligible for future sale.
The remaining shares, representing % of our total outstanding shares of common stock following this offering, will be restricted securities within the meaning of Rule 144 and subject to certain restrictions on resale following the consummation of this offering. Restricted securities may be sold in the public market only if they are registered under the Securities Act or are sold pursuant to an exemption from registration such as Rule 144 or Rule 701, as described in Shares eligible for future sale.
We, each of our executive officers and directors, the Sponsors and certain other security holders have agreed, subject to certain exceptions, with the underwriters not to dispose of or hedge any of the shares of common stock or securities convertible into or exchangeable for shares of common stock during the period from the date of this prospectus continuing through the date that is 180 days after the date of this prospectus (subject to extension in certain circumstances). J.P. Morgan Securities LLC may, in its sole discretion, release any of these shares from these restrictions at any time without notice. See Underwriting.
After this offering, subject to any lock-up restrictions described above with respect to certain holders, holders of approximately shares of our common stock will have the right to require us to register the sales of their shares under the Securities Act, under the terms of an agreement between us and the holders of these securities. See Shares eligible for future saleRegistration rights for a more detailed description of these rights.
In the future, we may also issue our securities in connection with investments or acquisitions. The number of shares of our common stock issued in connection with an investment or acquisition could constitute a material portion of our then-outstanding shares of our common stock.
29
Anti-takeover provisions in our charter documents and Delaware law might discourage or delay acquisition attempts for us that you might consider favorable.
Our amended and restated certificate of incorporation and amended and restated bylaws will contain provisions that may make the acquisition of the Company more difficult without the approval of our board of directors. These provisions:
| authorize the issuance of undesignated preferred stock, the terms of which may be established and the shares of which may be issued without stockholder approval, and which may include super voting, special approval, dividend, or other rights or preferences superior to the rights of the holders of common stock; |
| establish a classified board of directors so that not all members of our board of directors are elected at one time; |
| generally prohibit stockholder action by written consent, requiring all stockholder actions be taken at a meeting of our stockholders, except that any action required or permitted to be taken by our stockholders may be effected by written consent until such time as the Sponsors cease to beneficially own 50% or more of our common stock; |
| provide that special meetings of the stockholders can only be called by (i) the chairman or vice chairman of our board of directors, (ii) our chief executive officer, (iii) a majority of our board of directors through a special resolution or (iv) the holders of at least 10% of our common stock until such time as the Sponsors cease to beneficially own 50% or more of our common stock, effected by consent in writing by such stockholders; |
| establish advance notice requirements for nominations for elections to our board of directors or for proposing matters that can be acted upon by stockholders at stockholder meetings; and |
| provide that our board of directors is expressly authorized to make, alter or repeal our amended and restated bylaws. |
Our amended and restated certificate of incorporation will also contain a provision that provides us with protections similar to Section 203 of the Delaware General Corporate Law, and will prevent us from engaging in a business combination with a person who acquires at least 15% of our common stock for a period of three years from the date such person acquired such common stock, unless board or stockholder approval is obtained prior to the acquisition. These anti-takeover provisions and other provisions under Delaware law could discourage, delay or prevent a transaction involving a change in control of the Company, even if doing so would benefit our stockholders. These provisions could also discourage proxy contests and make it more difficult for you and other stockholders to elect directors of your choosing and to cause us to take other corporate actions you desire. For a further discussion of these and other such anti-takeover provisions, see Description of capital stockAnti-takeover effects of our amended and restated certificate of incorporation and amended and restated bylaws.
If you purchase shares of common stock sold in this offering, you will incur immediate and substantial dilution.
If you purchase shares of common stock in this offering, you will incur immediate and substantial dilution in the amount of $ per share because the initial public offering price of $ is substantially higher than the pro forma net tangible book value per share of our outstanding common stock. Dilution results from the fact that the initial public offering price per share of the
30
common stock is substantially in excess of the book value per share of common stock attributable to our existing stockholder for the currently outstanding shares of common stock. In addition, you may also experience additional dilution upon future equity issuances or the exercise of stock options to purchase common stock granted to our coworkers and directors under our equity incentive plan. See Dilution.
We will have broad discretion in how we use the proceeds of this offering and we may not use these proceeds effectively. This could affect our results of operations and cause the price of our common stock to decline.
Our management team will have considerable discretion in the application of the net proceeds of this offering, and you will not have the opportunity, as part of your investment decision, to assess whether we are using the proceeds appropriately. We currently intend to use the net proceeds that we receive from this offering to reduce our outstanding indebtedness, to pay a one-time termination fee to affiliates of the Sponsors in connection with the termination of the Management Services Agreement and for general corporate purposes. We may use the net proceeds for corporate purposes that do not improve our results of operations or which cause our stock price to decline.
Following the offering, we will be classified as a controlled company and, as a result, we will qualify for, and intend to rely on, exemptions from certain corporate governance requirements. You will not have the same protections afforded to stockholders of companies that are subject to such requirements.
After the completion of this offering, the Sponsors will continue to control a majority of our common stock. As a result, we will be a controlled company within the meaning of the applicable stock exchange corporate governance standards. Under the rules of , a company of which more than 50% of the outstanding voting power is held by an individual, group or another company is a controlled company and may elect not to comply with certain stock exchange corporate governance requirements, including:
| the requirement that the board of directors consist of a majority of independent directors; |
| the requirement that nominating and corporate governance matters be decided solely by independent directors; and |
| the requirement that employee and officer compensation matters be decided solely by independent directors. |
Following this offering, we intend to utilize these exemptions. As a result, we may not have a majority of independent directors and our nominating and corporate governance and compensation functions may not be decided solely by independent directors. Accordingly, you will not have the same protections afforded to stockholders of companies that are subject to all of the stock exchange corporate governance requirements.
Conflicts of interest may arise because some of our directors are principals of our largest stockholders.
Paul Finnegan and Robin Selati, who are principals of Madison Dearborn, and Glenn Creamer and Michael Dominguez, who are managing directors of Providence Equity, serve on our board of directors. The Sponsors will continue to hold a majority of our outstanding common stock after giving effect to this offering. The Sponsors and the entities respectively controlled by them may
31
hold equity interests in entities that directly or indirectly compete with us, and companies in which they currently invest may begin competing with us. As a result of these relationships, when conflicts between the interests of Madison Dearborn or Providence Equity, on the one hand, and of other stockholders, on the other hand, arise, these directors may not be disinterested. Although our directors and officers have a duty of loyalty to us under Delaware law and our amended and restated certificate of incorporation, transactions that we enter into in which a director or officer has a conflict of interest are generally permissible so long as (1) the material facts relating to the directors or officers relationship or interest as to the transaction are disclosed to our board of directors and a majority of our disinterested directors approves the transaction, (2) the material facts relating to the directors or officers relationship or interest as to the transaction are disclosed to our stockholders and a majority of our disinterested stockholders approve the transaction or (3) the transaction is otherwise fair to us. Our amended and restated certificate of incorporation will also provide that any principal, officer, member, manager and/or employee of a Sponsor or any entity that controls, is controlled by or under common control with a Sponsor (other than us or any company that is controlled by us) or a Sponsor-managed investment fund will not be required to offer any transaction opportunity of which they become aware to us and could take any such opportunity for themselves or offer it to other companies in which they have an investment, unless such opportunity is offered to them solely in their capacities as our directors.
Because we do not intend to pay cash dividends in the foreseeable future, you may not receive any return on investment unless you are able to sell your common stock for a price greater than your purchase price.
We do not anticipate that we will pay any cash dividends on shares of our common stock for the foreseeable future. Any determination to pay dividends in the future will be at the discretion of our board of directors and will depend upon results of operations, financial condition, contractual restrictions, including those under the Senior Credit Facilities and the Indentures, any potential indebtedness we may incur, restrictions imposed by applicable law, tax considerations and other factors our board of directors deems relevant. Accordingly, if you purchase shares in this offering, realization of a gain on your investment will depend on the appreciation of the price of our common stock, which may never occur. Investors seeking cash dividends in the foreseeable future should not purchase our common stock.
We are a holding company and rely on dividends, distributions and other payments, advances and transfers of funds from our subsidiaries to meet our obligations.
We are a holding company that does not conduct any business operations of our own. As a result, we are largely dependent upon cash dividends and distributions and other transfers from our subsidiaries to meet our obligations. The agreements governing the indebtedness of our subsidiaries impose restrictions on our subsidiaries ability to pay dividends or other distributions to us. The deterioration of the earnings from, or other available assets of, our subsidiaries for any reason could also limit or impair their ability to pay dividends or other distributions to us.
32
This prospectus contains forward-looking statements within the meaning of the federal securities laws. All statements other than statements of historical fact included in this prospectus are forward-looking statements. These statements relate to analyses and other information, which are based on forecasts of future results and estimates of amounts not yet determinable. These statements also relate to our future prospects, developments and business strategies. These forward-looking statements are identified by the use of terms and phrases such as anticipate, believe, could, estimate, expect, intend, may, plan, predict, project, will and similar terms and phrases, including references to assumptions. However, these words are not the exclusive means of identifying such statements. These statements are contained in many sections of this prospectus, including those entitled Prospectus summary, Business and Managements discussion and analysis of financial condition and results of operations. Although we believe that our plans, intentions and expectations reflected in or suggested by such forward-looking statements are reasonable, we cannot assure you that we will achieve those plans, intentions or expectations. All forward-looking statements are subject to risks and uncertainties that may cause actual results to differ materially from those that we expected.
Important factors that could cause actual results to differ materially from our expectations, or cautionary statements, are disclosed under the sections entitled Risk factors and Managements discussion and analysis of financial condition and results of operations in this prospectus. All written and oral forward-looking statements attributable to us, or persons acting on our behalf, are expressly qualified in their entirety by the cautionary statements contained in this prospectus under the heading Risk factors, as well as other cautionary statements that are made from time to time in our other SEC filings and public communications. You should evaluate all forward-looking statements made in this prospectus in the context of these risks and uncertainties.
We caution you that the important factors referenced above may not contain all of the factors that are important to you. In addition, we cannot assure you that we will realize the results or developments we expect or anticipate or, even if substantially realized, that they will result in the consequences or affect us or our operations in the way we expect. The forward-looking statements included in this prospectus are made only as of the date hereof. We undertake no obligation to publicly update or revise any forward-looking statement as a result of new information, future events or otherwise, except as otherwise required by law.
33
Market, ranking and other industry data
This prospectus includes industry data, forecasts and information that we have prepared based, in part, upon data, forecasts and information obtained from independent industry publications and surveys and other information available to us. Some data is also based on our good faith estimates, which are derived from managements knowledge of the industry and independent sources. Industry publications and surveys and forecasts generally state that the information contained therein has been obtained from sources believed to be reliable, but there can be no assurance as to the accuracy or completeness of included information. We have not independently verified any of the data from third-party sources nor have we ascertained the underlying economic assumptions relied upon therein. Statements as to our market position are based on market data currently available to us. While we are not aware of any misstatements regarding the industry data presented herein, our estimates involve risks and uncertainties and are subject to change based on various factors, including those discussed under the heading Risk factors in this prospectus. Similarly, we believe our internal research is reliable, even though such research has not been verified by any independent sources.
34
Based upon an assumed initial public offering price of $ per share, the midpoint of the price range set forth on the cover of this prospectus, we estimate we will receive net proceeds from this offering of approximately $ million after deducting underwriting discounts and commissions and estimated offering expenses payable by us.
We intend to use a portion of the net proceeds received by us from this offering to redeem $ million aggregate principal amount of Senior Subordinated Notes at a redemption price of 106.268% plus accrued and unpaid interest thereon to the date of redemption. As of the date of this prospectus, $571.5 million aggregate principal amount of Senior Subordinated Notes is outstanding. The Senior Subordinated Notes mature on October 12, 2017 and have an interest rate of 12.535% per annum. See Description of certain indebtedness.
In connection with this offering, we intend to terminate the Management Services Agreement. We will use approximately $ million of the net proceeds received by us from this offering to pay a one-time termination fee to affiliates of the Sponsors in connection with the termination of the Management Services Agreement. See Certain transactionsManagement Services Agreement.
We intend to use the remaining proceeds received by us from this offering for general corporate purposes. Our management will have broad discretion over the uses of the net proceeds from this offering. Pending application of the net proceeds as described above, we intend to invest the net proceeds in short-term, investment-grade, interest-bearing securities.
A $1.00 increase or decrease in the assumed initial public offering price of $ per share would increase or decrease the net proceeds we receive from this offering by approximately $ million, assuming the number of shares offered by us, as set forth on the cover of this prospectus, remains the same. We may also increase or decrease the number of shares we are offering. An increase or decrease by 1.0 million shares in the number of shares offered by us would increase or decrease the net proceeds to us by $ million assuming the assumed initial public offering price of $ per share, the midpoint of the price range set forth on the cover of this prospectus, remains the same and after deducting the underwriting discounts and commissions and estimated offering expenses payable by us.
35
We currently intend to retain all available funds and any future earnings to fund the development and growth of our business, and therefore we do not anticipate paying any cash dividends in the foreseeable future. In addition, our ability to pay dividends on our common stock will be limited by restrictions on our ability to pay dividends or make distributions to our stockholders and on the ability of our subsidiaries to pay dividends or make distributions to us, in each case, under the terms of our current and any future agreements governing our indebtedness. See Description of certain indebtedness for further information regarding the restrictions on our subsidiaries ability to pay dividends to us and make other distributions to us. Any future determination to pay dividends will be at the discretion of our board of directors, subject to compliance with covenants in our current and future agreements governing our indebtedness, and will depend upon our results of operations, financial condition, capital requirements, tax considerations and other factors that our board of directors deems relevant. See Risk factorsRisks related to our businessWe have significant deferred cancellation of debt income for a discussion of certain tax considerations that could impact our willingness to pay dividends in the future.
36
The following table sets forth our consolidated cash and cash equivalents and capitalization as of December 31, 2012:
| on an actual basis; and |
| on a pro forma as adjusted basis to give effect to (1) the 2013 Debt Transactions, (2) the issuance of shares of common stock in this offering, (3) our receipt of the estimated net proceeds from the sale of shares of common stock offered by us in this offering at an assumed initial public offering price of $ per share, the midpoint of the price range set forth on the cover of this prospectus, after deducting the underwriting discounts and commissions and estimated offering expenses payable by us, and the application of the net proceeds as described in Use of proceeds, (4) the $ million loss on extinguishment for the redemption premium and write-off of deferred financing costs that will be recognized in connection with the redemption of the Senior Subordinated Notes using a portion of the proceeds from this offering and (5) the $ million of compensation expense related to the acceleration of the expense recognition for certain equity incentive awards that will be recognized in connection with the completion of this offering. |
37
This information should be read in conjunction with Use of proceeds, Selected consolidated financial and operating data, Unaudited pro forma condensed consolidated financial data, Managements discussion and analysis of financial condition and results of operations and the historical consolidated financial statements and related notes appearing elsewhere in this prospectus.
December 31, 2012 (dollars in millions, except per share amounts) |
Actual | Pro forma as adjusted(1) |
||||||
|
||||||||
Cash and cash equivalents |
$ | 37.9 | $ | |||||
|
|
|||||||
Total debt (including current portion): |
||||||||
ABL Facility due 2016 |
$ | | ||||||
Term Loan Facility due 2014 |
421.3 | |||||||
Term Loan Facility due 2017 |
918.2 | |||||||
Senior Secured Notes due 2018 |
500.0 | |||||||
Senior Notes due 2019 |
1,305.0 | (2) | ||||||
Senior Subordinated Notes due 2017 |
621.5 | |||||||
|
|
|||||||
Total debt (including current portion) |
3,766.0 | (3) | ||||||
Shareholders equity (deficit): |
||||||||
Preferred stock, par value $0.01 per share; authorized shares, no shares outstanding on an actual or as adjusted basis |
| | ||||||
Class A common stock, par value $0.01 per share; authorized, issued and outstanding shares on an actual basis; no shares authorized, issued or outstanding on an as adjusted basis |
| | ||||||
Class B common stock, par value $0.01; authorized shares, issued shares and outstanding shares on an actual basis; no shares authorized, issued or outstanding on an actual basis |
| | ||||||
Common stock, par value $0.01 per share; authorized shares, shares outstanding on an actual basis; shares outstanding on a pro forma basis |
| |||||||
Additional paid-in capital |
2,209.1 | |||||||
Accumulated deficit |
(2,073.0 | ) | ||||||
Accumulated other comprehensive income |
0.4 | |||||||
|
|
|||||||
Total shareholders equity |
136.5 | |||||||
|
|
|||||||
Total capitalization |
$ | 3,902.5 | $ | |||||
|
(1) | A $1.00 increase or decrease in the assumed initial public offering price of $ per share, the midpoint of the price range set forth on the cover of this prospectus, would result in an approximately $ million increase or decrease in each of cash and cash equivalents, additional paid-in capital, total shareholders equity and total capitalization, assuming that the number of shares offered by us set forth on the cover of this prospectus remains the same, and after deducting the underwriting discounts and commissions and estimated offering expenses payable by us. Each 1.0 million increase or decrease in the number of shares offered by us would increase or decrease each of cash and cash equivalents, additional paid-in capital, total shareholders equity and total capitalization by approximately $ million, assuming the initial public offering price of $ per share, the midpoint of the price range set forth on the cover of this prospectus, remains the same, and after deducting the underwriting discounts and commissions and estimated offering expenses payable by us. The pro forma as adjusted information discussed above is illustrative only and will change based on the actual initial public offering price and other terms of this offering. |
(2) | Excludes unamortized premium of $5.0 million. |
(3) | This amount does not include any of the $249.2 million in obligations outstanding under our inventory financing agreements as of December 31, 2012. We include these obligations in current liabilities and not in total debt because we have not in the past incurred, and in the future do not expect to incur, any interest expense under these agreements. This amount is classified separately as accounts payableinventory financing on our consolidated balance sheets. For more information, see Description of certain indebtedness. |
38
If you purchase our common stock in this offering, your ownership interest will be immediately diluted to the extent of the difference between the initial public offering price per share of our common stock and the net tangible book value per share of our common stock after this offering. Dilution results from the fact that the initial public offering price per share of our common stock is substantially in excess of the book value per share of common stock attributable to our existing stockholder for the currently outstanding shares of common stock.
Our pro forma net tangible book deficit as of December 31, 2012 was $ million, or $ per share of common stock after giving effect to this offering. Net tangible book value per share represents the amount of our total tangible assets (which for the purpose of this calculation excludes capitalized debt issuance costs) less total liabilities, divided by the basic weighted average number of shares of common stock that will be outstanding immediately prior to the completion of the offering.
After giving effect to the sale of the shares of common stock offered by us in this offering at an assumed initial public offering price of $ per share, the midpoint of the price range set forth on the cover of this prospectus, less estimated underwriting discounts and commissions and estimated offering expenses payable by us, our pro forma net tangible book value (deficit) as of would have been approximately $ million, or $ per share of common stock after giving effect to this offering. This represents an immediate increase in net tangible book value to our existing stockholder of $ per share and an immediate dilution to purchasers in this offering of $ per share. The following table illustrates this pro forma per share dilution in net tangible book value to purchasers.
Assumed initial public offering price per share |
$ | |||
Pro forma net tangible book value (deficit) per share as of December 31, 2012 |
||||
Increase per share attributable to purchasers in this offering |
||||
Pro forma net tangible book value per share after giving effect to this offering |
||||
|
|
|||
Dilution in pro forma net tangible book value per share to purchasers in this offering |
$ | |||
|
A $1.00 increase or decrease in the assumed initial public offering price of $ per share, the midpoint of the price range set forth on the cover of this prospectus, would increase or decrease pro forma net tangible book value by $ million, or $ per share, and would increase or decrease the dilution per share to purchasers in this offering by $ , based on the assumptions set forth above.
39
The following table summarizes as of December 31, 2012, on an as adjusted basis, the number of shares of common stock purchased, the total consideration paid and the average price per share paid by purchasers in this offering, based upon an assumed initial public offering price of $ per share, the midpoint of the initial public offering price range on the cover page of this prospectus, and before deducting estimated underwriting discounts and commissions and estimated offering expenses payable by us:
Shares purchased | Total consideration |
Average price per share |
||||||||||||||||
Number | Percent | Amount | Percent | |||||||||||||||
|
||||||||||||||||||
Existing stockholder |
% | $ | % | $ | ||||||||||||||
New investors |
||||||||||||||||||
|
||||||||||||||||||
Total |
100% | 100% | $ | |||||||||||||||
|
Except as otherwise indicated, the discussion and tables above assume no exercise of the underwriters option to purchase additional shares and no exercise of any outstanding options. If the underwriters option to purchase additional shares is exercised in full, our existing stockholder would own approximately % and purchasers in this offering would own approximately % of the total number of shares of our common stock outstanding after this offering. If the underwriters exercise their option to purchase additional shares in full, the pro forma net tangible book value per share after this offering would be $ per share, and the dilution in the pro forma net tangible book value per share to purchasers in this offering would be $ per share.
The tables and calculations above are based on shares of common stock outstanding as of and assume no exercise by the underwriters of their option to purchase up to an additional shares from us. This number excludes an aggregate of shares of common stock reserved for issuance under our equity incentive plan that we intend to adopt in connection with this offering.
40
Unaudited pro forma condensed consolidated financial data
The following tables set forth our unaudited pro forma and historical condensed consolidated balance sheet at December 31, 2012 and consolidated statement of operations for the year ended December 31, 2012.
The unaudited pro forma condensed consolidated balance sheet as of December 31, 2012 gives effect to the following transactions as if each had occurred on December 31, 2012: (i) the 2013 Debt Transactions, (ii) the reclassification of our Class A common stock and Class B common stock into a single class of common stock and the subsequent -for-1 stock split of our common stock, both of which will be effected prior to the completion of this offering, and (iii) this offering and the use of proceeds therefrom as set forth under Use of proceeds. The unaudited pro forma condensed consolidated balance sheet also includes adjustments for (a) the $ million loss on extinguishment for the redemption premium and write-off of deferred financing costs that will be recognized in connection with the redemption of the Senior Subordinated Notes using a portion of the proceeds from this offering and (b) the $ million of compensation expense related to the acceleration of the expense recognition for certain equity incentive awards in connection with the completion of this offering.
The unaudited pro forma consolidated statement of operations for the year ended December 31, 2012 gives effect to the following transactions as if each had occurred on January 1, 2012: (i) the February 2, 2012, February 14, 2012 and March 14, 2012 prepayments of an aggregate of $201.0 million principal amount of loans outstanding under the Term Loan Facility (the 2012 Prepayments), (ii) the February 17, 2012 issuance of $130.0 million aggregate principal amount of Senior Notes (the 2012 Senior Notes Issuance), (iii) the February 17, 2012 and March 5, 2012 repurchases and March 19, 2012 redemption of an aggregate of $129.0 million principal amount of Senior Notes due 2015 (the 2012 Senior Notes Repurchases and Redemption), (iv) the December 21, 2012 redemption of an aggregate of $100.0 million principal amount of the Senior Subordinated Notes (the 2012 Senior Subordinated Notes Redemption and, together with the 2012 Prepayments, the 2012 Senior Notes Issuance and the 2012 Senior Notes Repurchases and Redemption, the 2012 Debt Transactions), (v) the 2013 Debt Transactions, (vi) the reclassification of our Class A common stock and Class B common stock into a single class of common stock and the subsequent -for-1 stock split of our common stock, both of which will be effected prior to the completion of this offering, (vii) the elimination of the annual $5.0 million management fee paid to the Sponsors that will be terminated in connection with with the completion of this offering, and (viii) this offering and use of proceeds therefrom as set forth under Use of proceeds.
In connection with this offering, we expect to recognize certain nonrecurring charges which have not been adjusted in the unaudited pro forma consolidated statement of operations, as such charges will not have an ongoing impact on our financial results. These charges include a $ million termination fee related to the Management Services Agreement, compensation expense of $ million related to the acceleration of the expense recognition for certain equity incentive awards upon the completion of this offering, and a loss on extinguishment of $ million related to the Senior Subordinated Notes redemption using a portion of the proceeds from this offering.
We derived the unaudited pro forma condensed consolidated financial data by applying pro forma adjustments to our audited consolidated financial statements appearing elsewhere in this prospectus. The adjustments give effect to pro forma events that are (1) directly attributable to
41
the 2012 Debt Transactions, 2013 Debt Transactions and this offering, (2) factually supportable and (3) with respect to the unaudited pro forma consolidated statement of operations, expected to have a continuing impact on our financial results. The unaudited pro forma adjustments are based on available information and certain assumptions that we believe are reasonable. These assumptions are subject to change and the effect of any such change could be material. The adjustments necessary to fairly present this unaudited pro forma condensed consolidated financial data are described in the accompanying notes. The unaudited pro forma condensed consolidated financial data should be read in conjunction with the sections of this prospectus entitled Use of proceeds, Capitalization, Managements discussion and analysis of financial condition and results of operations, and our historical consolidated financial statements and related notes appearing elsewhere in this prospectus. The unaudited pro forma condensed consolidated financial data is for informational purposes only and is not intended to represent or to be indicative of the consolidated results of operations or financial position that we would have reported had the transactions and this offering been completed on the dates indicated and should not be taken as representative of our future consolidated results of operations or financial position.
CDW Corporation and Subsidiaries
Unaudited Pro Forma Condensed Consolidated Balance Sheet
December 31, 2012 (in millions) |
Historical As Reported December 31, 2012 |
Adjustments Related to the 2013 Debt Transactions |
Pro Forma for 2013 Debt Transactions |
Adjustments Related to this Offering |
Pro Forma December 31, 2012 |
|||||||||||||||
|
||||||||||||||||||||
Assets |
||||||||||||||||||||
Current Assets: |
||||||||||||||||||||
Cash and cash equivalents |
$ | 37.9 | $ | (37.9 | )(1) | $ | | $ | (8 | ) | $ | |||||||||
Accounts receivable, net |
1,265.1 | 1,265.1 | ||||||||||||||||||
Merchandise inventory |
314.6 | 314.6 | ||||||||||||||||||
Miscellaneous receivables |
148.5 | 0.5 | (3) | 150.2 | (9 | ) | ||||||||||||||
1.2 | (4) | (11 | ) | |||||||||||||||||
(15 | ) | |||||||||||||||||||
Deferred income taxes |
14.1 | 14.1 | ||||||||||||||||||
Prepaid expenses and other |
34.6 | 34.6 | ||||||||||||||||||
|
|
|
|
|
|
|
|
|
|
|||||||||||
Total current assets |
1,814.8 | (36.2 | ) | 1,778.6 | ||||||||||||||||
Property and equipment, net |
142.7 | 142.7 | ||||||||||||||||||
Goodwill |
2,209.3 | 2,209.3 | ||||||||||||||||||
Other intangible assets, net |
1,478.5 | 1,478.5 | ||||||||||||||||||
Deferred financing costs, net |
53.2 | (1.2 | )(2) | 52.0 | (10 | ) | ||||||||||||||
Other assets |
1.6 | 1.6 | ||||||||||||||||||
|
|
|
|
|
|
|
|
|
|
|||||||||||
Total assets |
$ | 5,700.1 | $ (37.4 | ) | $ | 5,662.7 | $ | $ | ||||||||||||
|
|
|
|
|
|
|
|
|
|
|
42
Historical As Reported December 31, 2012 |
Adjustments Related to the 2013 Debt Transactions |
Pro Forma for 2013 Debt Transactions |
Adjustments Related to this Offering |
Pro Forma December 31, 2012 |
||||||||||||||||
|
||||||||||||||||||||
Liabilities and Shareholders Equity |
||||||||||||||||||||
Current liabilities: |
||||||||||||||||||||
Accounts payabletrade |
$ | 518.6 | $ | 56.6 | (1) | $ | 575.2 | $ | $ | |||||||||||
Accounts payableinventory financing |
249.2 | 249.2 | ||||||||||||||||||
Current maturities of long-term debt |
40.0 | (40.0 | )(1) | | ||||||||||||||||
Deferred revenue |
37.9 | 37.9 | ||||||||||||||||||
Accrued expenses |
302.6 | (1.4 | )(1) | 301.0 | (12 | ) | ||||||||||||||
(0.2 | )(5) | (13 | ) | |||||||||||||||||
|
|
|
|
|
|
|
|
|
|
|||||||||||
Total current liabilities |
1,148.3 | 15.0 | 1,163.3 | |||||||||||||||||
Long-term liabilities |
||||||||||||||||||||
Debt |
3,731.0 | (50.0 | )(1) | 3,681.0 | (12 | ) | ||||||||||||||
Deferred income taxes |
624.3 | 0.3 | (6) | 624.6 | (14 | ) | ||||||||||||||
Accrued interest |
8.0 | (0.6 | )(5) | 7.4 | (13 | ) | ||||||||||||||
Other liabilities |
52.0 | 52.0 | ||||||||||||||||||
|
|
|
|
|
|
|
|
|
|
|||||||||||
Total long-term liabilities |
4,415.3 | (50.3 | ) | 4,365.0 | ||||||||||||||||
Commitments and contingencies |
||||||||||||||||||||
Shareholders equity: |
||||||||||||||||||||
Common stock |
| (16 | ) | |||||||||||||||||
(17 | ) | |||||||||||||||||||
Paid-in capital |
2,209.1 | 2,209.1 | (18 | ) | ||||||||||||||||
Accumulated deficit |
(2,073.0 | ) | (2.1 | )(7) | (2,075.1 | ) | (19 | ) | ||||||||||||
(20 | ) | |||||||||||||||||||
(21 | ) | |||||||||||||||||||
Accumulated other comprehensive income |
0.4 | 0.4 | ||||||||||||||||||
|
|
|
|
|
|
|
|
|
|
|||||||||||
Total shareholders equity |
136.5 | (2.1 | ) | 134.4 | ||||||||||||||||
|
|
|
|
|
|
|
|
|
|
|||||||||||
Total liabilities and shareholders equity |
$ | 5,700.1 | $ | (37.4 | ) | $ | 5,662.7 | $ | $ | |||||||||||
|
|
|
|
|
|
|
|
|
|
|
43
Adjustments Related to the 2013 Debt Transactions
1) | Reflects the 2013 Debt Transactions. Cash paid for the 2013 Redemption includes the principal amount of $50.0 million, accrued and unpaid interest of $1.3 million and a redemption premium of $3.1 million representing 106.268% of the principal amount redeemed. Cash paid for the 2013 Prepayment includes the principal amount of $40.0 million and $0.1 million of accrued and unpaid interest. Cash on hand of $37.9 million and a resulting cash overdraft of $56.6 million were assumed to be used for the 2013 Debt Transactions. |
For more information about the 2013 Debt Transactions, please refer to Note 20 in the historical consolidated financial statements appearing elsewhere in this prospectus. |
2) | Reflects the write-off of a portion of the unamortized deferred financing costs related to the 2013 Debt Transactions. |
3) | Reflects the adjustment to income taxes receivable related to the tax effect of the write-off of a portion of the unamortized deferred financing costs for the 2013 Debt Transactions, calculated using an estimated combined federal and state statutory tax rate of 39%. |
4) | Reflects the adjustment to income taxes receivable related to the tax effect of the redemption premium of $3.1 million from the 2013 Redemption, calculated using an estimated combined federal and state statutory tax rate of 39%. |
5) | Reflects the adjustment to interest expense and accrued interest payable for the difference between interest expense previously recognized under the effective interest method and actual interest paid, related to the 2013 Redemption. |
6) | Reflects the adjustment to deferred income taxes related to the tax effect of the interest expense adjustment discussed in note 5, calculated using an estimated combined federal and state statutory tax rate of 39%. |
7) | Reflects the adjustments to accumulated deficit for the following: |
Redemption premium related to the 2013 Redemption (see note 1) |
$ | (3.1 | ) | |
Tax effect of the redemption premium on the 2013 Redemption (see note 4) |
1.2 | |||
Interest expense adjustment related to the 2013 Redemption (see note 5) |
0.8 | |||
Tax effect of the interest expense adjustment from the 2013 Redemption (see note 6) |
(0.3 | ) | ||
Write-off of deferred financing costs related to the 2013 Debt Transactions (see note 2) |
(1.2 | ) | ||
Tax effect of the write-off of deferred financing costs (see note 3) |
0.5 | |||
|
|
|||
Total pro forma adjustment to accumulated deficit |
$ | (2.1 | ) |
Adjustments Related to this Offering
8) | Reflects the adjustments to cash and cash equivalents for the following: |
Net proceeds from this offering (see note 18) |
$ | |||
Payment to terminate the Management Services Agreement (see note 20) |
||||
Payment for the Redemption of the Senior Subordinated Notes (see note 12) |
||||
|
|
|||
Total pro forma adjustment to cash and cash equivalents |
$ |
9) | Reflects the adjustment to income taxes receivable for the tax effects of the payment of the $ million termination fee for the Management Services Agreement, calculated using an estimated combined federal and state statutory tax rate of 39%. |
10) | Reflects the write-off of a portion of the unamortized deferred financing costs related to the redemption of the Senior Subordinated Notes with a portion of the proceeds from this offering. |
11) | Reflects the adjustment to income taxes receivable related to the tax effects of the write-off of a portion of the unamortized deferred financing costs for the redemption of the Senior Subordinated Notes with a portion of the proceeds of this offering, calculated using an estimated combined federal and state statutory tax rate of 39%. |
12) | Reflects the redemption of the $ million aggregate principal amount of the Senior Subordinated Notes, $ million of accrued and unpaid interest to the date of redemption and a redemption premium of $ million representing 106.268% of the principal amount redeemed. |
13) | Reflects the adjustment to interest expense and accrued interest payable for the difference between interest expense previously recognized under the effective interest method and actual interest paid related to the redemption of the Senior Subordinated Notes with a portion of the proceeds of this offering. |
44
14) | Reflects the adjustment to deferred income taxes related to the tax effects of the interest expense adjustment discussed in note 13, calculated using an estimated combined federal and state statutory tax rate of 39%. |
15) | Reflects the adjustment to income taxes receivable related to the tax effects of the redemption premium of $ million discussed in note 12, calculated using an estimated combined federal and state statutory tax rate of 39%. |
16) | Reflects the reclassification of our Class A common stock and our Class B common stock into a single class of a common stock and the subsequent -for-1 stock split of our common stock, both of which will be effected prior to the completion of this offering. |
17) | Reflects the adjustment to common stock for the par value of $0.01 per share for the shares issued in this offering. |
18) | Reflects the adjustments to paid-in capital for the following: |
Net proceeds from this offering (see note 8) |
$ | (a) | ||
Par value of common stock in this offering (see note 17) -for-1 stock split of common stock (see note 16) |
||||
Acceleration of the expense recognition for certain equity incentive awards (see note 21) |
||||
|
|
|||
Total pro forma adjustments to paid-in capital |
$ |
a) | Reflects the issuance of shares of common stock in this offering at an assumed public offering price of $ per share, the midpoint of the price range set forth on the cover of this prospectus. |
19) | Reflects the adjustments to accumulated deficit for the following debt related items: |
Redemption premium related to the redemption of the Senior Subordinated Notes (see note 12) |
$ | |||
Tax effects of the redemption premium on the Senior Subordinated Notes (see note 15) |
||||
Interest expense adjustment related to the redemption of the Senior Subordinated Notes (see note 13) |
||||
Tax effects of the Senior Subordinated Notes interest expense adjustment (see note 14) |
||||
Write-off of deferred financing costs related to the redemption of the Senior Subordinated Notes (see note 10) |
||||
Tax effects of the write-off of deferred financing costs (see note 11) |
||||
|
|
|||
Total pro forma adjustments to accumulated deficit |
$ |
20) | Reflects the adjustment to accumulated deficit for the $ million termination fee related to the Management Services Agreement (see note 8), net of the tax effects of $ million (see note 9) calculated using an estimated combined federal and state statutory tax rate of 39%. |
21) | Reflects the adjustment to accumulated deficit for the $ million of compensation expense related to the acceleration of the expense recognition for certain equity incentive awards upon completion of this offering. |
45
CDW Corporation and Subsidiaries
Unaudited Pro Forma Consolidated Statement of Operations
For the Year Ended December 31, 2012 (in millions, except share-related |
Historical As Reported Year Ended December 31, 2012 |
Adjustments Related to the 2012 and 2013 Debt Transactions |
Pro Forma for 2012 and 2013 Debt Transactions |
Adjustments Related to this Offering |
Pro Forma Year Ended December 31, 2012 |
|||||||||||||||
|
||||||||||||||||||||
Net sales |
$ | 10,128.2 | $ | | $ | 10,128.2 | $ | $ | ||||||||||||
Cost of sales |
8,458.6 | | 8,458.6 | |||||||||||||||||
|
|
|
|
|
|
|
|
|
|
|||||||||||
Gross profit |
1,669.6 | | 1,669.6 | |||||||||||||||||
Selling and administrative expenses |
1,029.5 | | 1,029.5 | (4) | ||||||||||||||||
Advertising expense |
129.5 | | 129.5 | |||||||||||||||||
|
|
|
|
|
|
|
|
|
|
|||||||||||
Income from operations |
510.6 | | 510.6 | |||||||||||||||||
Interest expense, net |
(307.4 | ) | 18.3 | (1) | (289.1 | ) | (5) | |||||||||||||
Net loss on extinguishments of long-term debt |
(17.2 | ) | 17.2 | (2) | | |||||||||||||||
Other income, net |
0.1 | | 0.1 | |||||||||||||||||
|
|
|
|
|
|
|
|
|
|
|||||||||||
Income before income taxes |
186.1 | 35.5 | 221.6 | |||||||||||||||||
Income tax expense |
(67.1 | ) | (13.8 | )(3) | (80.9 | ) | (6) | |||||||||||||
|
|
|
|
|
|
|
|
|
|
|||||||||||
Net income |
$ | 119.0 | $ | 21.7 | $ | 140.7 | $ | $ | ||||||||||||
|
|
|
|
|
|
|
|
|
|
|||||||||||
Net income per common share: |
||||||||||||||||||||
Basic |
$ | 117.34 | (7) | |||||||||||||||||
Diluted |
$ | 116.73 | (7) | |||||||||||||||||
Weighted average number of common shares outstanding: |
||||||||||||||||||||
Basic |
1,014,138 | (7) | ||||||||||||||||||
Diluted |
1,019,448 | (7) | ||||||||||||||||||
|
46
Adjustments Related to the 2012 and 2013 Debt Transactions
1) | Reflects the 2012 Debt Transactions and the 2013 Debt Transactions. Pro forma adjustments to interest expense are as follows: |
Interest expense for the 2012 Prepayments and 2013 Prepayment |
(2.6 | )(a) | ||
Interest expense for the 2012 Senior Subordinated Notes Redemption and 2013 Redemption |
(16.8 | )(b) | ||
Other adjustments to interest expense |
1.1 | (c) | ||
|
|
|||
Total pro forma adjustment to interest expense |
(18.3 | ) |
a) | Reflects the decrease to interest expense related to the 2012 Prepayments and 2013 Prepayment using the interest rates at the original transaction dates of 3.7% and 4.0% for the non-extended and extended loans, respectively. After the prepayments, we had $408.7 million and $890.8 million of non-extended and extended loans outstanding, respectively. |
b) | Reflects the decrease to interest expense of $18.4 million related to the 2012 Senior Subordinated Notes Redemption and the 2013 Redemption using the principal balance after the redemptions of $571.5 million and the stated interest rate of 12.535%, partially offset by an adjustment of $1.6 million for the difference between interest recognized under the effective interest method and actual interest paid. |
c) | Primarily reflects the increase to interest expense of $1.3 million related to the 2012 Senior Notes Issuance, which notes currently bear interest at a rate of 8.5%. A decrease to interest expense of $2.0 million related to the 2012 Senior Notes Repurchases and Redemption was mostly offset by an increase to interest expense of $1.8 million representing the difference between actual interest paid and interest expense recognized under the effective interest method. The net impact on the amortization of deferred financing costs was insignificant. |
For more information about the 2012 Debt Transactions and the 2013 Debt Transactions, please refer to Notes 7 and 20 in the consolidated financial statements appearing elsewhere in this prospectus. |
2) | Reflects the adjustment to remove the loss on extinguishments of long-term debt that was recorded in connection with the 2012 Debt Transactions. |
3) | Reflects the tax impact of the pro forma adjustments using an estimated combined federal and state statutory tax rate of 39%. |
Adjustments Related to this Offering
4) | Reflects the elimination of $5.0 million of annual management fees paid to the Sponsors in 2012. The Management Services Agreement will terminate upon completion of this offering. |
5) | Reflects the reduction to interest expense related to the redemption of $ million aggregate principal amount of the Senior Subordinated Notes, which bear interest at a rate of 12.535%. |
6) | Reflects the tax impact of the pro forma adjustments using an estimated combined federal and state statutory tax rate of 39%. |
7) | Reflects adjustments to outstanding common shares and net income per share as if this offering had occurred on January 1, 2012. The following table sets forth the computation of pro forma basic and diluted net income per share: |
Pro forma net income |
$ | |||
Pro forma weighted-average number of shares basic and diluted |
||||
Weighted-average number of existing common shares |
||||
Shares issued in this offering |
||||
Shares used for general corporate purposes |
||||
|
|
|||
Pro forma net income per share basic and diluted |
$ |
8) | We expect to recognize certain nonrecurring charges directly related to this offering which have not been adjusted in the unaudited pro forma consolidated statement of operations as they will not have a continuing impact on our financial results. These charges include an expense of $ million within selling and administrative expenses and the corresponding tax effects of $ million related to the termination of the Management Services Agreement, $ million of compensation expense related to the acceleration of the expense recognition for certain equity incentive awards upon completion of this offering, and a loss on extinguishment of $ million related to the Senior Subordinated Notes redemption using a portion of the proceeds from this offering. As these adjustments are nonrecurring, they are not included in the pro forma adjustments above. |
47
Selected consolidated financial and operating data
The following table sets forth our selected historical consolidated financial and operating data for the periods ended and as of the dates indicated below. We have derived the selected historical consolidated financial and operating data presented below as of December 31, 2011 and December 31, 2012 and for the years ended December 31, 2010, 2011 and 2012 from our audited consolidated financial statements and related notes, which are included elsewhere in this prospectus. The selected historical consolidated financial and operating data as of December 31, 2008, December 31, 2009 and December 31, 2010 and for the years ended December 31, 2009 and 2008 have been derived from our audited consolidated financial statements as of and for those periods, which are not included in this prospectus.
The unaudited pro forma financial data for the year ended December 31, 2012 gives effect to the transactions described in Unaudited pro forma condensed consolidated financial data as if such transactions occurred at the beginning of such year. The unaudited pro forma financial data is for informational purposes only and is not intended to represent or be indicative of the consolidated results of operations that we would have reported had the foregoing transactions and this offering been completed on the dates indicated, and should not be taken as representative of our future consolidated results of operations.
The selected historical consolidated financial and operating data set forth below are not necessarily indicative of the results of future operations and should be read in conjunction with Managements discussion and analysis of financial condition and results of operations, Risk factors, Use of proceeds, Capitalization and our historical financial statements and related notes appearing elsewhere in this prospectus.
The following are some of the items affecting comparability of the selected historical consolidated financial and operating data for the periods presented:
| During the years ended December 31, 2011 and 2012, we recorded net losses on extinguishments of long-term debt of $118.9 million and $17.2 million, respectively. The losses represented the difference between the amount paid upon extinguishment, including call premiums and expenses paid to the debt holders and agents, and the net carrying amount of the extinguished debt, adjusted for a portion of the unamortized deferred financing costs. |
| During the years ended December 31, 2008 and 2009, we recorded goodwill impairment charges of $1,712.0 million and $241.8 million, respectively. These impairments were primarily attributable to deterioration in macroeconomic conditions and overall declines in net sales. |
48
Years ended December 31, (in millions, except per share data) |
||||||||||||||||||||
2008 | 2009 | 2010 | 2011 | 2012 | ||||||||||||||||
|
|
|
|
|
|
|
|
|
|
|
||||||||||
Statement of Operations Data: |
||||||||||||||||||||
Net sales |
$ | 8,071.2 | $ | 7,162.6 | $ | 8,801.2 | $ | 9,602.4 | $ | 10,128.2 | ||||||||||
Cost of sales |
6,710.2 | 6,029.7 | 7,410.4 | 8,018.9 | 8,458.6 | |||||||||||||||
|
|
|||||||||||||||||||
Gross profit |
1,361.0 | 1,132.9 | 1,390.8 | 1,583.5 | 1,669.6 | |||||||||||||||
Selling and administrative expenses |
894.8 | 821.1 | 932.1 | 990.1 | 1,029.5 | |||||||||||||||
Advertising expense |
141.3 | 101.9 | 106.0 | 122.7 | 129.5 | |||||||||||||||
Goodwill impairment |
1,712.0 | 241.8 | | | | |||||||||||||||
|
|
|||||||||||||||||||
Income (loss) from operations |
(1,387.1 | ) | (31.9 | ) | 352.7 | 470.7 | 510.6 | |||||||||||||
Interest expense, net |
(390.3 | ) | (431.7 | ) | (391.9 | ) | (324.2 | ) | (307.4 | ) | ||||||||||
Net gain (loss) on extinguishments of long-term debt |
| | 2.0 | (118.9 | ) | (17.2 | ) | |||||||||||||
Other income, net |
0.2 | 2.4 | 0.2 | 0.7 | 0.1 | |||||||||||||||
|
|
|||||||||||||||||||
Income (loss) before income taxes |
(1,777.2 | ) | (461.2 | ) | (37.0 | ) | 28.3 | 186.1 | ||||||||||||
Income tax benefit (expense) |
12.1 | 87.8 | 7.8 | (11.2 | ) | (67.1 | ) | |||||||||||||
|
|
|||||||||||||||||||
Net (loss) income |
$ | (1,765.1 | ) | $ | (373.4 | ) | $ | (29.2 | ) | $ | 17.1 | $ | 119.0 | |||||||
|
|
|||||||||||||||||||
Net (loss) income per common share |
||||||||||||||||||||
Basic |
$ | $ | $ | $ | $ | |||||||||||||||
Diluted |
$ | $ | $ | $ | $ | |||||||||||||||
Weighted average common shares outstanding |
||||||||||||||||||||
Basic |
||||||||||||||||||||
Diluted |
||||||||||||||||||||
Pro forma net income per common share(1) |
$ | |||||||||||||||||||
|
|
|||||||||||||||||||
Pro forma weighted average common shares outstanding(1) |
||||||||||||||||||||
December 31, (in millions) |
2008 | 2009 | 2010 | 2011 | 2012 | |||||||||||||||
|
||||||||||||||||||||
Balance Sheet Data: |
||||||||||||||||||||
Cash and cash equivalents |
$ | 94.4 | $ | 88.0 | $ | 36.6 | $ | 99.9 | $ | 37.9 | ||||||||||
Working capital |
877.6 | 923.2 | 675.4 | 538.1 | 666.5 | |||||||||||||||
Total assets |
6,276.3 | 5,976.0 | 5,943.8 | 5,949.6 | 5,700.1 | |||||||||||||||
Total debt and capitalized lease obligations(2) |
4,633.5 | 4,621.9 | 4,290.0 | 4,066.0 | 3,771.0 | |||||||||||||||
Total shareholders equity (deficit) |
262.2 | (44.7 | ) | (43.5 | ) | (7.3 | ) | 136.5 | ||||||||||||
Other Financial Data: |
||||||||||||||||||||
Capital expenditures |
$ | 41.1 | $ | 15.6 | $ | 41.5 | $ | 45.7 | $ | 41.4 | ||||||||||
Depreciation and amortization |
218.4 | 218.2 | 209.4 | 204.9 | 210.2 | |||||||||||||||
Gross profit as a percentage of net sales |
16.9% | 15.8% | 15.8% | 16.5% | 16.5% | |||||||||||||||
Ratio of earnings to fixed charges(3) |
(a) | (a) | (a) | 1.1 | 1.6 | |||||||||||||||
EBITDA(4) |
(1,168.5 | ) | 188.7 | 564.3 | 557.4 | 703.7 | ||||||||||||||
Adjusted EBITDA(4) |
570.6 | 465.4 | 601.8 | 717.3 | 766.6 | |||||||||||||||
Statement of Cash Flows Data: |
||||||||||||||||||||
Net cash provided by (used in): |
||||||||||||||||||||
Operating activities |
$ | 215.4 | $ | 107.6 | $ | 423.7 | $ | 214.7 | $ | 317.4 | ||||||||||
Investing activities |
(60.3 | ) | (82.6 | ) | (125.4 | ) | (56.0 | ) | (41.7 | ) | ||||||||||
Financing activities |
(75.8 | ) | (31.9 | ) | (350.1 | ) | (95.4 | ) | (338.0 | ) | ||||||||||
|
49
(1) | Both pro forma net income per share and pro forma weighted shares outstanding give effect to the reclassification of our Class A common stock and Class B common stock into a single class of common stock and the subsequent -for-1 stock split of our common stock, both of which will be effected prior to the completion of this offering, and the issuance of shares in this offering. In addition, the pro forma presentation does not reflect certain nonrecurring charges directly related to this offering which we expect to recognize, as they will not have an ongoing impact on our financial results. These charges include a $ million termination fee related to termination of the Management Services Agreement, compensation expense of $ million related to the acceleration of the expense recognition for certain equity incentive awards upon the completion of this offering, and a loss on extinguishment of $ million related to the Senior Subordinated Notes redemption using a portion of the proceeds from this offering. |
(2) | Excludes borrowings of $34.1 million, $25.0 million, $28.2 million, $278.7 million and $249.2 million, as of December 31, 2008, December 31, 2009, December 31, 2010, December 31, 2011 and December 31, 2012, respectively, under our inventory financing agreements. We do not include these borrowings in total debt because we have not in the past incurred, and in the future do not expect to incur, any interest expense these agreements. For more information, see Description of certain indebtedness. These amounts are classified separately as accounts payableinventory financing on our consolidated balance sheets. |
(3) | For purposes of calculating the ratio of earnings to fixed charges, earnings consist of earnings before income taxes minus income from equity investment plus fixed charges. Fixed charges consist of interest expensed and the portion of rental expense we believe is representative of the interest component of rental expense. |
(a) | For the years ended December 31, 2008, 2009 and 2010, earnings available for fixed charges were inadequate to cover fixed charges by $1,777.2 million, $461.2 million and $37.0 million, respectively. |
(4) | EBITDA is defined as consolidated net income (loss) before interest income (expense), income tax benefit (expense), depreciation, and amortization. Adjusted EBITDA, which is a measure defined in the Senior Credit Facilities, is calculated by adjusting EBITDA for certain items of income and expense including (but not limited to) the following: (a) non-cash equity-based compensation; (b) goodwill impairment charges; (c) sponsor fees; (d) certain consulting fees; (e) debt-related legal and accounting costs; (f) equity investment income and losses; (g) certain severance and retention costs; (h) gains and losses from the early extinguishment of debt; (i) gains and losses from asset dispositions outside the ordinary course of business; and (j) non-recurring, extraordinary or unusual gains or losses or expenses. |
We have included a reconciliation of EBITDA and Adjusted EBITDA in the table below. Both EBITDA and Adjusted EBITDA are considered non-GAAP financial measures. Generally, a non-GAAP financial measure is a numerical measure of a companys performance, financial position or cash flows that either excludes or includes amounts that are not normally included or excluded in the most directly comparable measure calculated and presented in accordance with GAAP. Non-GAAP measures used by the Company may differ from similar measures used by other companies, even when similar terms are used to identify such measures. We believe that EBITDA and Adjusted EBITDA provide helpful information with respect to our operating performance and cash flows including our ability to meet our future debt service, capital expenditures, and working capital requirements. Adjusted EBITDA also provides helpful information as it is the primary measure used in certain financial covenants contained in the Senior Credit Facilities.
The following unaudited table sets forth reconciliations of GAAP net income (loss) to EBITDA and EBITDA to Adjusted EBITDA for the periods presented:
Years ended December 31, |
|
|||||||||||||||||||
(in millions) | 2008 | 2009 | 2010 | 2011 | 2012 | |||||||||||||||
|
||||||||||||||||||||
Net (loss) income |
$ | (1,765.1 | ) | $ | (373.4 | ) | $ | (29.2 | ) | $ | 17.1 | $ | 119.0 | |||||||
Depreciation and amortization |
218.4 | 218.2 | 209.4 | 204.9 | 210.2 | |||||||||||||||
Income tax (benefit) expense |
(12.1 | ) | (87.8 | ) | (7.8 | ) | 11.2 | 67.1 | ||||||||||||
Interest expense, net |
390.3 | 431.7 | 391.9 | 324.2 | 307.4 | |||||||||||||||
|
|
|||||||||||||||||||
EBITDA |
(1,168.5 | ) | 188.7 | 564.3 | 557.4 | 703.7 | ||||||||||||||
|
|
|||||||||||||||||||
Non-cash equity-based compensation |
17.8 | 15.9 | 11.5 | 19.5 | 22.1 | |||||||||||||||
Sponsor fees(i) |
5.0 | 5.0 | 5.0 | 5.0 | 5.0 | |||||||||||||||
Goodwill impairment |
1,712.0 | 241.8 | | | | |||||||||||||||
Consulting and debt-related professional fees |
4.3 | 14.1 | 15.1 | 5.1 | 0.6 | |||||||||||||||
Net (gain) loss on extinguishments of long-term debt |
| | (2.0 | ) | 118.9 | 17.2 | ||||||||||||||
Other adjustments(ii) |
| (0.1 | ) | 7.9 | 11.4 | 18.0 | ||||||||||||||
|
|
|||||||||||||||||||
Adjusted EBITDA |
$ | 570.6 | $ | 465.4 | $ | 601.8 | $ | 717.3 | $ | 766.6 | ||||||||||
|
(i) | Reflects historical fees paid to affiliates of the Sponsors under the Management Services Agreement. In connection with this offering, we intend to terminate the Management Services Agreement. See Certain transactionsManagement Services Agreement. |
(ii) | Includes certain retention costs and equity investment income, a litigation loss in the fourth quarter of 2012, certain severance costs in 2009, and a gain related to the sale of the Informacast software and equipment in 2009. |
50
The following unaudited table sets forth a reconciliation of EBITDA to net cash provided by operating activities for the periods presented:
Years ended December 31, (in millions) |
||||||||||||||||||||
2008 | 2009 | 2010 | 2011 | 2012 | ||||||||||||||||
|
||||||||||||||||||||
EBITDA |
$ | (1,168.5 | ) | $ | 188.7 | $ | 564.3 | $ | 557.4 | $ | 703.7 | |||||||||
Depreciation and amortization |
(218.4 | ) | (218.2 | ) | (209.4 | ) | (204.9 | ) | (210.2 | ) | ||||||||||
Income tax benefit (expense) |
12.1 | 87.8 | 7.8 | (11.2 | ) | (67.1 | ) | |||||||||||||
Interest expense, net |
(390.3 | ) | (431.7 | ) | (391.9 | ) | (324.2 | ) | (307.4 | ) | ||||||||||
|
|
|||||||||||||||||||
Net (loss) income |
(1,765.1 | ) | (373.4 | ) | (29.2 | ) | 17.1 | 119.0 | ||||||||||||
|
|
|||||||||||||||||||
Depreciation and amortization |
218.4 | 218.2 | 209.4 | 204.9 | 210.2 | |||||||||||||||
Goodwill impairment |
1,712.0 | 241.8 | | | | |||||||||||||||
Equity-based compensation expense |
17.8 | 15.9 | 11.5 | 19.5 | 22.1 | |||||||||||||||
Amortization of deferred financing costs and debt premium |
38.6 | 16.2 | 18.0 | 15.7 | 13.6 | |||||||||||||||
Deferred income taxes |
(39.9 | ) | (94.4 | ) | (4.3 | ) | (10.2 | ) | (56.3 | ) | ||||||||||
Allowance for doubtful accounts |
0.4 | (0.2 | ) | (1.3 | ) | 0.4 | | |||||||||||||
Realized loss on interest rate swap agreements |
18.6 | 103.2 | 51.5 | 2.8 | | |||||||||||||||
Mark to market loss on interest rate derivatives |
| | 4.7 | 4.2 | 0.9 | |||||||||||||||
Net (gain) loss on extinguishments of long-term debt |
| | (2.0 | ) | 118.9 | 17.2 | ||||||||||||||
Net loss (gain) on sale and disposals of assets |
0.5 | (1.7 | ) | 0.7 | 0.3 | 0.1 | ||||||||||||||
Changes in assets and liabilities |
14.1 | (18.0 | ) | 165.3 | (158.3 | ) | (9.4 | ) | ||||||||||||
Other non-cash items |
| | (0.6 | ) | (0.6 | ) | | |||||||||||||
|
|
|||||||||||||||||||
Net cash provided by operating activities |
$ | 215.4 | $ | 107.6 | $ | 423.7 | $ | 214.7 | $ | 317.4 | ||||||||||
|
51
Managements discussion and analysis of financial condition and results of operations
The following discussion and analysis of our financial condition and results of operations should be read in conjunction with the section entitled Selected consolidated financial and operating data and our historical audited consolidated financial statements and the related notes thereto included elsewhere in this prospectus. This discussion contains forward-looking statements that are subject to numerous risks and uncertainties, including but not limited to those described in the section entitled Risk factors. Actual results may differ materially from those contained in any forward-looking statements.
Overview
CDW is a Fortune 500 company and a leading provider of integrated IT solutions in the U.S. and Canada. We help our customer base of more than 250,000 small, medium and large business, government, education and healthcare customers by delivering critical solutions to their increasingly complex IT needs. Our broad array of offerings range from discrete hardware and software products to integrated IT solutions such as mobility, security, data center optimization, cloud computing, virtualization and collaboration. We are technology agnostic, with a product portfolio that includes more than 100,000 products from more than 1,000 brands. We provide our products and solutions through sales force and service delivery teams consisting of more than 4,300 coworkers, including nearly 1,400 highly skilled technology specialists and engineers.
We are a leading U.S. sales channel partner for many OEMs and software publishers, whose products we sell or include in the solutions we offer. We believe we are an important extension of our vendor partners sales and marketing capabilities, providing them with a cost-effective way to reach customers and deliver a consistent brand experience through our established end-market coverage and extensive customer access.
We have two reportable segments: Corporate, which is comprised primarily of private sector business customers, and Public, which is comprised of government agencies and education and healthcare institutions. Our Corporate segment is divided into a medium-large business customer channel, primarily serving customers with more than 100 employees, and a small business customer channel, primarily serving customers with up to 100 employees. We also have two other operating segments, CDW Advanced Services and Canada, which do not meet the reportable segment quantitative thresholds and, accordingly, are combined together as Other. The CDW Advanced Services business consists primarily of customized engineering services delivered by technology specialists and engineers and managed services that include IaaS offerings. Revenues from the sale of hardware, software, custom configuration and third-party provided services are recorded within our Corporate and Public segments.
We may sell all or only select products that our vendor partners offer. Each vendor partner agreement provides for specific terms and conditions, which may include one or more of the following: product return privileges, price protection policies, purchase discounts and vendor incentive programs, such as purchase or sales rebates and cooperative advertising reimbursements. We also resell software for major software publishers. Our agreements with software publishers allow the end-user customer to acquire software or licensed products and services. In addition to helping our customers determine the best software solutions for their needs, we help them manage their software agreements, including warranties and renewals. A
52
significant portion of our advertising and marketing expenses are reimbursed through cooperative advertising reimbursement programs with our vendor partners. These programs are at the discretion of our vendor partners and are typically tied to sales or purchasing volumes or other commitments to be met by us within a specified period of time.
Trends and key factors affecting our financial performance
We believe the following trends may have an important impact on our financial performance:
| An important factor affecting our ability to generate sales and achieve our targeted operating results is the impact of general economic conditions on our customers willingness to spend on information technology. While our operating results have improved significantly from the recent financial crisis, beginning in the second quarter of 2012, we began to see customers take a more cautious approach to spending as increased macroeconomic uncertainty impacted decision-making and led to some customers delaying purchases. We expect this trend to continue into 2013. Uncertainties related to the potential impacts of federal budget negotiations, potential changes in tax and regulatory policy, weakening consumer and business confidence or increased unemployment could result in reduced or deferred spending by our customers on information technology products and services and increased competitive pricing pressures. |
| Our Public segment sales are impacted by government spending policies, budget priorities and revenue levels. An adverse change in any of these factors could cause our Public segment customers to reduce their purchases or to terminate or not renew contracts with us, which could adversely affect our business, results of operations or cash flows. Although our sales to the federal government are diversified across multiple agencies and departments, they collectively accounted for approximately 10%, 10% and 11% of our net sales in 2012, 2011 and 2010, respectively. |
| We believe that our customers transition to more complex technology solutions will continue to be an important growth area for us in the future. However, because the market for technology products and services is highly competitive, our success at capitalizing on this transition will be based on our ability to tailor specific solutions to customer needs, the quality and breadth of our product and service offerings, the knowledge and expertise of our sales force, price, product availability and speed of delivery. |
Key business metrics
Our management monitors a number of financial and non-financial measures and ratios on a regular basis in order to track the progress of our business and make adjustments as necessary. We believe that the most important of these measures and ratios include average daily sales, gross margin, operating margin, EBITDA and Adjusted EBITDA, cash and cash equivalents, net working capital, cash conversion cycle (defined to be days of sales outstanding in accounts receivable plus days of supply in inventory minus days of purchases outstanding in accounts payable, based on a rolling three-month average), debt levels including available credit and leverage ratios, sales per coworker and coworker turnover. These measures and ratios are compared to standards or objectives set by management, so that actions can be taken, as necessary, in order to achieve the standards and objectives. Adjusted EBITDA, a non-GAAP financial measure, also provides helpful information as it is the primary measure used in certain financial covenants contained in the Senior Credit Facilities. See Summary consolidated financial information for the definition of Adjusted EBITDA and a reconciliation to net (loss) income.
53
The results of certain of our key business metrics are as follows:
Years ended December 31, | ||||||||||||
(dollars in millions) | 2010 | 2011 | 2012 | |||||||||
|
||||||||||||
Net sales |
$ | 8,801.2 | $ | 9,602.4 | $ | 10,128.2 | ||||||
Gross profit |
1,390.8 | 1,583.5 | 1,669.6 | |||||||||
Income from operations |
352.7 | 470.7 | 510.6 | |||||||||
Net (loss) income |
(29.2 | ) | 17.1 | 119.0 | ||||||||
Adjusted EBITDA |
601.8 | 717.3 | 766.6 | |||||||||
Average daily sales |
34.7 | 37.7 | 39.9 | |||||||||
Net debt (defined as long-term debt plus capital leases minus cash and cash equivalents) |
4,253.4 | 3,966.1 | 3,733.1 | |||||||||
Cash conversion cycle (in days) |
32 | 27 | 24 | |||||||||
|
Background and basis of presentation
Corporate and capital structure
On October 12, 2007, CDW Corporation, a then-newly-formed Delaware corporation indirectly controlled by the Sponsors, acquired CDW Corporation, an Illinois corporation (Target), in a transaction valued at approximately $7.4 billion (the Acquisition). Upon completion of the Acquisition, the outstanding common stock of Target was converted into the right to receive cash, the common stock was delisted and deregistered and Target became a 100% owned subsidiary of CDW Corporation. CDW Corporation is owned directly by CDW Holdings. CDW Holdings is controlled by investment funds affiliated with the Sponsors, certain other co-investors and certain senior management investors. On December 31, 2009, Target merged into CDWC LLC, a limited liability company 100% owned by CDW Corporation with CDWC LLC as the surviving company in the merger. This change had no impact on operations or management. On December 31, 2010, CDWC LLC was renamed CDW LLC. Prior to the completion of this offering, CDW Holdings will be liquidated and will distribute all of its shares of CDW Corporation common stock to its existing members in accordance with their respective membership interests and pursuant to the terms of CDW Holdings limited liability company agreement and unitholders agreement.
Unless otherwise indicated or the context otherwise requires, the terms we, us, the Company, our, CDW and similar terms refer to CDW Corporation and its 100% owned subsidiaries.
Accompanying financial statements
Throughout managements discussion and analysis of financial condition and results of operations, data for all periods are derived from our consolidated financial statements included elsewhere in this prospectus, which include the audited consolidated financial statements as of December 31, 2012 and 2011 and for the years ended December 31, 2012, 2011 and 2010 (the Audited Financial Statements).
54
Results of operations
Year ended December 31, 2012 compared to year ended December 31, 2011
The following table presents our results of operations, in dollars and as a percentage of net sales, for the years ended December 31, 2012 and 2011:
Year
ended December 31, 2012 |
Year ended December 31, 2011 |
|||||||||||||||
Dollars in millions |
Percentage of net sales |
Dollars in millions |
Percentage of net sales |
|||||||||||||
|
||||||||||||||||
Net sales |
$ | 10,128.2 | 100.0% | $ | 9,602.4 | 100.0% | ||||||||||
Cost of sales |
8,458.6 | 83.5 | 8,018.9 | 83.5 | ||||||||||||
|
|
|||||||||||||||
Gross profit |
1,669.6 | 16.5 | 1,583.5 | 16.5 | ||||||||||||
Selling and administrative expenses |
1,029.5 | 10.2 | 990.1 | 10.3 | ||||||||||||
Advertising expense |
129.5 | 1.3 | 122.7 | 1.3 | ||||||||||||
|
|
|||||||||||||||
Income from operations |
510.6 | 5.0 | 470.7 | 4.9 | ||||||||||||
Interest expense, net |
(307.4 | ) | (3.0) | (324.2 | ) | (3.4) | ||||||||||
Net loss on extinguishments of long-term debt |
(17.2 | ) | (0.2) | (118.9 | ) | (1.2) | ||||||||||
Other income, net |
0.1 | | 0.7 | | ||||||||||||
|
|
|||||||||||||||
Income before income taxes |
186.1 | 1.8 | 28.3 | 0.3 | ||||||||||||
Income tax expense |
(67.1 | ) | (0.7) | (11.2 | ) | (0.1) | ||||||||||
|
|
|||||||||||||||
Net income |
$ | 119.0 | 1.1% | $ | 17.1 | 0.2% | ||||||||||
|
Net sales
The following table presents our net sales by segment, in dollars and as a percentage of total net sales, and the year-over-year dollar and percentage change in net sales for the years ended December 31, 2012 and 2011:
Year ended December 31, 2012 |
Year ended December 31, 2011 |
|||||||||||||||||||||||
Dollars in millions |
Percentage of total net sales |
Dollars in millions |
Percentage of total net sales |
Dollar change |
Percent change(1) |
|||||||||||||||||||
|
||||||||||||||||||||||||
Corporate |
$ | 5,512.8 | 54.4 | % | $ | 5,334.4 | 55.6 | % | $ | 178.4 | 3.3 | % | ||||||||||||
Public |
4,023.0 | 39.7 | 3,757.2 | 39.1 | 265.8 | 7.1 | ||||||||||||||||||
Other |
592.4 | 5.9 | 510.8 | 5.3 | 81.6 | 16.0 | ||||||||||||||||||
|
|
|||||||||||||||||||||||
Total net sales |
$ | 10,128.2 | 100.0 | % | $ | 9,602.4 | 100.0 | % | $ | 525.8 | 5.5 | % | ||||||||||||
|
(1) | There were 254 and 255 selling days in the years ended December 31, 2012 and 2011, respectively. On an average daily basis, total net sales increased 5.9%. |
55
The following table presents our net sales by customer channel for our Corporate and Public segments and the year-over-year dollar and percentage change in net sales for the years ended December 31, 2012 and 2011:
Years ended December 31, |
2012 |
2011 | Dollar change |
Percent change |
||||||||||||
(in millions) | ||||||||||||||||
|
||||||||||||||||
Corporate: |
||||||||||||||||
Medium / Large |
$ | 4,448.5 | $ | 4,287.1 | $ | 161.4 | 3.8 | % | ||||||||
Small Business |
1,064.3 | 1,047.3 | 17.0 | 1.6 | ||||||||||||
|
|
|||||||||||||||
Total Corporate |
$ | 5,512.8 | $ | 5,334.4 | $ | 178.4 | 3.3 | % | ||||||||
|
|
|||||||||||||||
Public: |
||||||||||||||||
Government |
$ | 1,394.1 | $ | 1,343.5 | $ | 50.6 | 3.8 | % | ||||||||
Education |
1,192.3 | 1,197.7 | (5.4 | ) | (0.4 | ) | ||||||||||
Healthcare |
1,436.6 | 1,216.0 | 220.6 | 18.1 | ||||||||||||
|
|
|||||||||||||||
Total Public |
$ | 4,023.0 | $ | 3,757.2 | $ | 265.8 | 7.1 | % | ||||||||
|
Total net sales in 2012 increased $525.8 million, or 5.5%, to $10,128.2 million, compared to $9,602.4 million in 2011. There were 254 and 255 selling days in the years ended December 31, 2012 and 2011, respectively. On an average daily basis, total net sales increased 5.9%. The increase in total net sales was the result of general volume growth, market share gains, a more tenured sales force, and a continued focus on seller productivity across all areas of the organization. Our net sales growth for the year ended December 31, 2012 reflected growth in notebooks/mobile devices, netcomm products, software products, desktop computers and enterprise storage.
Corporate segment net sales in 2012 increased $178.4 million, or 3.3%, compared to 2011. Within our Corporate segment, net sales to medium/large customers increased 3.8% between years, and net sales to small business customers increased 1.6% between years. Customers within the Corporate segment continued to take a more cautious approach to spending as increased macroeconomic uncertainty impacted decisionmaking and led to some customers delaying purchases. The increases in Corporate segment net sales were primarily a result of hardware growth, most notably in netcomm products, and unit volume growth in desktop computers. Software product growth, led by network management and security software, also contributed to the increase in net sales. Partially offsetting the growth was a decline in net sales of memory products due to several large orders in the second and third quarters of 2011 that did not recur.
Public segment net sales in 2012 increased $265.8 million, or 7.1%, between years, driven by continued strong performance in the healthcare customer channel. Net sales to healthcare customers increased $220.6 million, or 18.1%, between years, led by hardware growth, most notably in enterprise storage, and unit volume growth in netcomm products, desktop computers and point of care technology carts. Software product growth also contributed to the increase in net sales in healthcare. The healthcare customer channel growth was primarily the result of deeper relationships with several group purchasing organizations and increased healthcare industry demand for IT products, as the healthcare industry continued its adoption of electronic medical records and point of care technologies. Net sales to government customers increased $50.6 million, or 3.8%, in 2012 compared to 2011 led by unit volume increases in sales of notebooks/mobile devices, partially offset by a decline in net sales of netcomm products. Net sales to education customers decreased $5.4 million, or 0.4%, between years, reflecting budget
56
constraints. A decline in sales to K-12 customers was partially offset by growth in sales to higher education customers that was led by increased sales of netcomm products, as higher education customers refreshed and added additional enterprise technology.
Gross profit
Gross profit increased $86.1 million, or 5.4%, to $1,669.6 million in 2012, compared to $1,583.5 million in 2011. As a percentage of total net sales, gross profit was 16.5% in both 2012 and 2011. Gross profit margin was positively impacted 10 basis points by a higher mix of commission and net service contract revenue. Fully offsetting these increases in gross profit margin were declines in vendor funding primarily due to program changes for certain vendors. Commission revenue, including agency fees earned on sales of software licenses and software assurance under enterprise agreements, has a positive impact on our gross profit margin, as we record the fee or commission as a component of net sales when earned and there is no corresponding cost of sales. Net service contract revenue, including items such as third-party services and warranties, also has a positive impact on gross profit margin as our cost paid to the vendor or third-party service provider is recorded as a reduction to net sales, resulting in net sales being equal to the gross profit on the transaction. Vendor funding includes purchase discounts, volume rebates and cooperative advertising.
The gross profit margin may fluctuate based on various factors, including vendor incentive and inventory price protection programs, cooperative advertising funds classified as a reduction of cost of sales, product mix, net service contract revenue, commission revenue, pricing strategies, market conditions, and other factors, any of which could result in changes in gross profit margins.
Selling and administrative expenses
Selling and administrative expenses increased $39.4 million, or 4.0%, to $1,029.5 million in 2012, compared to $990.1 million in 2011. As a percentage of total net sales, selling and administrative expenses decreased 10 basis points to 10.2% in 2012, down from 10.3% in 2011. The dollar increase in selling and administrative expenses was primarily due to higher payroll costs (excluding bonus compensation tied to Adjusted EBITDA) of $43.0 million. The higher payroll costs reflected in selling and administrative expenses were driven by increased sales commissions and other variable compensation costs consistent with higher sales and gross profit. While total coworker count increased by 59 coworkers, from 6,745 coworkers at December 31, 2011 to 6,804 coworkers at December 31, 2012, the increase was primarily comprised of service delivery coworkers, the cost of which is reflected in cost of sales. Other factors that increased selling and administrative expenses included a $5.8 million increase in health benefits due to higher claims costs and a higher average number of participants in 2012 compared to 2011, a $5.3 million increase in depreciation and amortization expense related primarily to additional capital expenditures for information technology systems, and a $2.6 million increase in stock compensation expense, primarily due to incremental expense related to a modified Class B Common Unit grant agreement with our former chief executive officer. Partially offsetting these increases was an $11.8 million decline in bonus compensation tied to Adjusted EBITDA, as performance fell below target, $3.8 million of expenses related to the modification of our Term Loan Facility in 2011 that did not recur in 2012, and a $3.3 million decline in litigation expenses between years.
The decrease in selling and administrative expenses as a percentage of sales of 10 basis points between years was driven by the decline in incentive compensation tied to Adjusted EBITDA.
57
Advertising expense
Advertising expense increased $6.8 million, or 5.6%, to $129.5 million in 2012, compared to $122.7 million in 2011. As a percentage of net sales, advertising expense was 1.3% in both 2012 and 2011. The increase in advertising expense was due to a focus on continuing to advertise our solutions and products and to build our reputation as a leading IT solutions provider, primarily through targeted digital advertising, partially offset by decreases in expenditures for print advertising.
Income from operations
The following table presents income (loss) from operations by segment, in dollars and as a percentage of net sales, and the year-over-year percentage change in income (loss) from operations for the years ended December 31, 2012 and 2011:
Year ended December 31, 2012 |
Year ended December 31, 2011 |
|||||||||||||||||||
Dollars in millions |
Operating margin percentage |
Dollars in millions |
Operating margin percentage |
Percent change in income (Loss) from operations |
||||||||||||||||
|
||||||||||||||||||||
Segments:(1) |
||||||||||||||||||||
Corporate |
$ | 349.0 | 6.3 | % | $ | 331.6 | 6.2 | % | 5.2 | % | ||||||||||
Public |
246.7 | 6.1 | 233.3 | 6.2 | 5.7 | |||||||||||||||
Other |
18.6 | 3.1 | 17.5 | 3.4 | 6.5 | |||||||||||||||
Headquarters(2) |
(103.7 | ) | nm | * | (111.7 | ) | nm | * | 7.2 | |||||||||||
|
|
|||||||||||||||||||
Total income from operations |
$ | 510.6 | 5.0 | % | $ | 470.7 | 4.9 | % | 8.5 | % | ||||||||||
|
* | Not meaningful |
(1) | Segment income (loss) from operations includes the segments direct operating income (loss) and allocations for Headquarters costs, allocations for logistics services, certain inventory adjustments, and volume rebates and cooperative advertising from vendors. |
(2) | Includes Headquarters function costs that are not allocated to the segments. |
Income from operations was $510.6 million in 2012, an increase of $39.9 million, or 8.5%, compared to $470.7 million in 2011. This increase was driven by higher net sales and gross profit, partially offset by higher selling and administrative expenses and advertising expense. Total operating margin percentage increased 10 basis points to 5.0% in 2012, compared to 4.9% in 2011. Operating margin percentage was positively impacted by the decrease in selling and administrative expenses as a percentage of net sales.
Corporate segment income from operations was $349.0 million in 2012, an increase of $17.4 million, or 5.2%, compared to $331.6 million in 2011. This increase was primarily driven by higher net sales and gross profit margin, partially offset by higher selling and administrative expenses, resulting in a net increase in segment operating income before allocations of $14.4 million in 2012 compared to 2011. In addition, Corporate segment income from operations benefited from an increase of $2.5 million in income allocations from our logistics operations and a decrease of $0.5 million in Headquarters expense allocations in 2012 compared to 2011. The improved profitability of our logistics operations was driven by stronger operating leverage given higher purchase volumes while support costs remained flat.
Public segment income from operations was $246.7 million in 2012, an increase of $13.4 million, or 5.7%, compared to $233.3 million in 2011. This increase reflected higher segment operating income before allocations of $4.0 million as a result of increased net sales and gross profit
58
dollars, partially offset by higher selling and administrative costs. In addition, Public segment income from operations benefited from an increase of $5.7 million in income allocations from our logistics operations and a decrease in Headquarters expense allocations of $3.7 million in 2012 compared to 2011.
Interest expense, net
At December 31, 2012, our outstanding long-term debt totaled $3,771.0 million, compared to $4,066.0 million at December 31, 2011. Net interest expense in 2012 was $307.4 million, a decrease of $16.8 million compared to $324.2 million in 2011. Interest expense in 2011 included a benefit of $19.4 million, due to an adjustment to the long-term accrued interest liability associated with the extinguishment of $1,078.0 million of senior exchange notes due 2015 (the Senior Notes due 2015). The long-term accrued interest liability represents the difference between interest expense previously recognized under the effective interest method and actual interest paid. Of the remaining net decrease of $36.2 million, $27.2 million was due to lower effective interest rates and lower debt balances in 2012 compared to the prior year as a result of debt repayment and refinancing activities completed during 2011 and 2012. The remaining net decrease was primarily attributable to additional interest expense in 2011 related to the interest rate swaps that terminated in January 2011, higher 2011 mark-to-market losses on interest rate caps, higher amortization of deferred financing costs in 2011 compared to 2012 and a 2012 benefit related to an adjustment to the long-term accrued interest liability associated with the extinguishment of $100.0 million of Senior Subordinated Notes.
Net loss on extinguishments of long-term debt
During 2012, we recorded a net loss on extinguishments of long-term debt of $17.2 million compared to $118.9 million in 2011.
In February and March 2012, we purchased or redeemed the remaining $129.0 million of Senior Notes due 2015, funded with the issuance of an additional $130.0 million of Senior Notes. As a result, we recorded a loss on extinguishment of long-term debt of $9.4 million, representing the difference between the purchase or redemption price of the Senior Notes due 2015 and the net carrying amount of the purchased debt, adjusted for the remaining unamortized deferred financing costs.
In December 2012, we redeemed $100.0 million aggregate principal amount of Senior Subordinated Notes for $106.3 million. We recorded a loss on extinguishment of long-term debt of $7.8 million representing the difference between the redemption price and the net carrying amount of the purchased debt, adjusted for a portion of the unamortized deferred financing costs.
In March 2011, we amended the Term Loan Facility and recorded a loss on extinguishment of long-term debt of $3.2 million, representing a write-off of a portion of the unamortized deferred financing costs on this facility.
In April and May 2011, we purchased $1,078.0 million of Senior Notes due 2015, funded with the issuance of $1,175.0 million of Senior Notes. As a result, we recorded a loss on extinguishment of long-term debt of $114.1 million, representing the difference between the purchase price of the Senior Notes due 2015 at 109% of principal amount and the net carrying amount of the purchased debt, adjusted for a portion of the unamortized deferred financing costs.
59
In June 2011, we entered into a new $900.0 million ABL Facility, replacing the existing $800.0 million ABL Facility. As a result, we recorded a loss on extinguishment of long-term debt of $1.6 million representing a write-off of a portion of the unamortized deferred financing costs related to the previous facility.
Income tax expense
Income tax expense was $67.1 million in 2012, compared to $11.2 million in 2011. The effective income tax rate was 36.0% and 39.7% for 2012 and 2011, respectively.
For 2012, the effective tax rate differed from the U.S. federal statutory rate primarily due to favorable adjustments to state tax credits which are partially offset by the unfavorable impact of adjustments to deferred taxes due to changes in state tax laws and permanent differences. For 2011, the effective tax rate differed from the U.S. federal statutory rate primarily due to the unfavorable impact of permanent differences offset by a benefit for state income taxes. The lower effective tax rate for 2012 as compared to 2011 was primarily driven by the impact of favorable adjustments to state tax credits in 2012 and the lower rate impact of permanent differences in 2012 due to the significantly greater amount of pre-tax income.
Net income
Net income was $119.0 million in 2012, compared to $17.1 million in 2011. The 2012 and 2011 results included after-tax losses on extinguishments of long-term debt of $10.5 million and $72.5 million, respectively. Other significant factors and events causing the net changes from 2011 to 2012 are discussed above.
Adjusted EBITDA
Adjusted EBITDA was $766.6 million in 2012, an increase of $49.3 million, or 6.9%, compared to $717.3 million in 2011. As a percentage of net sales, Adjusted EBITDA was 7.6% and 7.5% in 2012 and 2011, respectively.
60
We have included a reconciliation of EBITDA and Adjusted EBITDA for 2012 and 2011 in the table below. EBITDA is defined as consolidated net income before interest expense, income tax expense, depreciation and amortization. Adjusted EBITDA, which is a measure defined in our Senior Credit Facilities, means EBITDA adjusted for certain items which are described in the table below. Both EBITDA and Adjusted EBITDA are considered non-GAAP financial measures. Generally, a non-GAAP financial measure is a numerical measure of a companys performance, financial position or cash flows that either excludes or includes amounts that are not normally included or excluded in the most directly comparable measure calculated and presented in accordance with GAAP. Non-GAAP measures used by the Company may differ from similar measures used by other companies, even when similar terms are used to identify such measures. We believe that EBITDA and Adjusted EBITDA provide helpful information with respect to our operating performance and cash flows including our ability to meet our future debt service, capital expenditures, and working capital requirements. Adjusted EBITDA also provides helpful information as it is the primary measure used in certain financial covenants contained in our Senior Credit Facilities. See Selected consolidated financial and operating data for a reconciliation of EBITDA to cash flows from operating activities.
Years ended December 31, | ||||||||
(in millions) | 2012 | 2011 | ||||||
|
||||||||
Net income |
$ | 119.0 | $ | 17.1 | ||||
Depreciation and amortization |
210.2 | 204.9 | ||||||
Income tax expense |
67.1 | 11.2 | ||||||
Interest expense, net |
307.4 | 324.2 | ||||||
|
|
|||||||
EBITDA |
703.7 | 557.4 | ||||||
|
|
|||||||
Adjustments: |
||||||||
Non-cash equity-based compensation |
22.1 | 19.5 | ||||||
Sponsor fee |
5.0 | 5.0 | ||||||
Consulting and debt-related professional fees |
0.6 | 5.1 | ||||||
Net loss on extinguishments of long-term debt |
17.2 | 118.9 | ||||||
Other adjustments(1) |
18.0 | 11.4 | ||||||
|
|
|||||||
Total adjustments |
62.9 | 159.9 | ||||||
|
|
|||||||
Adjusted EBITDA |
$ | 766.6 | $ | 717.3 | ||||
|
(1) | Other adjustments include certain retention costs, equity investment income and a litigation loss in the fourth quarter of 2012. |
61
Year ended December 31, 2011 compared to year ended December 31, 2010
The following table presents our results of operations, in dollars and as a percentage of net sales, for the years ended December 31, 2011 and 2010:
Year
ended December 31, 2011 |
Year
ended December 31, 2010 |
|||||||||||||||
Dollars in millions |
Percentage of net sales |
Dollars in millions |
Percentage of net sales |
|||||||||||||
|
||||||||||||||||
Net sales |
$ | 9,602.4 | 100.0 | % | $ | 8,801.2 | 100.0 | % | ||||||||
Cost of sales |
8,018.9 | 83.5 | 7,410.4 | 84.2 | ||||||||||||
|
|
|||||||||||||||
Gross profit |
1,583.5 | 16.5 | 1,390.8 | 15.8 | ||||||||||||
Selling and administrative expenses |
990.1 | 10.3 | 932.1 | 10.6 | ||||||||||||
Advertising expense |
122.7 | 1.3 | 106.0 | 1.2 | ||||||||||||
|
|
|||||||||||||||
Income from operations |
470.7 | 4.9 | 352.7 | 4.0 | ||||||||||||
Interest expense, net |
(324.2 | ) | (3.4 | ) | (391.9 | ) | (4.4 | ) | ||||||||
Net (loss) gain on extinguishments of long-term debt |
(118.9 | ) | (1.2 | ) | 2.0 | | ||||||||||
Other income, net |
0.7 | | 0.2 | | ||||||||||||
|
|
|||||||||||||||
Income (loss) before income taxes |
28.3 | 0.3 | (37.0 | ) | (0.4 | ) | ||||||||||
Income tax (expense) benefit |
(11.2 | ) | (0.1 | ) | 7.8 | 0.1 | ||||||||||
|
|
|||||||||||||||
Net income (loss) |
$ | 17.1 | 0.2 | % | $ | (29.2 | ) | (0.3 | )% | |||||||
|
Net sales
The following table presents our net sales by segment, in dollars and as a percentage of total net sales, and the year-over-year dollar and percentage change in net sales for the years ended December 31, 2011 and 2010:
Year ended December 31, 2011 |
Year ended December 31, 2010 |
|||||||||||||||||||||||
Dollars in millions |
Percentage of net sales |
Dollars in millions |
Percentage of net sales |
Dollar change |
Percent change(1) |
|||||||||||||||||||
|
||||||||||||||||||||||||
Corporate |
$ | 5,334.4 | 55.6 | % | $ | 4,833.6 | 54.9 | % | $ | 500.8 | 10.4 | % | ||||||||||||
Public |
3,757.2 | 39.1 | 3,560.6 | 40.5 | 196.6 | 5.5 | ||||||||||||||||||
Other |
510.8 | 5.3 | 407.0 | 4.6 | 103.8 | 25.5 | ||||||||||||||||||
|
|
|||||||||||||||||||||||
Total net sales |
$ | 9,602.4 | 100.0 | % | $ | 8,801.2 | 100.0 | % | $ | 801.2 | 9.1 | % | ||||||||||||
|
(1) | There were 255 and 254 selling days in the years ended December 31, 2011 and 2010, respectively. On an average daily basis, total net sales increased 8.7%. |
62
The following table presents our net sales by customer channel for our Corporate and Public segments and the year-over-year dollar and percentage change in net sales for the years ended December 31, 2011 and 2010:
Years ended December 31, | ||||||||||||||||
(in millions) | 2011 | 2010 | Dollar change | Percent change | ||||||||||||
|
||||||||||||||||
Corporate: |
||||||||||||||||
Medium / Large |
$ | 4,287.1 | $ | 3,867.3 | $ | 419.8 | 10.9 | % | ||||||||
Small Business |
1,047.3 | 966.3 | 81.0 | 8.4 | ||||||||||||
|
|
|||||||||||||||
Total Corporate |
$ | 5,334.4 | $ | 4,833.6 | $ | 500.8 | 10.4 | % | ||||||||
|
|
|||||||||||||||
Public: |
||||||||||||||||
Government |
$ | 1,343.5 | $ | 1,368.6 | $ | (25.1 | ) | (1.8)% | ||||||||
Education |
1,197.7 | 1,200.6 | (2.9 | ) | (0.2) | |||||||||||
Healthcare |
1,216.0 | 991.4 | 224.6 | 22.7 | ||||||||||||
|
|
|||||||||||||||
Total Public |
$ | 3,757.2 | $ | 3,560.6 | $ | 196.6 | 5.5 | % | ||||||||
|
Total net sales in 2011 increased $801.2 million, or 9.1%, to $9,602.4 million, compared to $8,801.2 million in 2010. There were 255 and 254 selling days in the years ended December 31, 2011 and 2010, respectively. On an average daily basis, total net sales increased 8.7%. The increase in total net sales was the result of general volume growth and increased demand in the information technology industry overall, in addition to our focus on growing market share. The most significant drivers of sales growth in 2011 were hardware unit volume growth in notebook/mobile devices, desktop computers and netcomm products, along with growth in software products.
Corporate segment net sales in 2011 increased $500.8 million, or 10.4%, compared to 2010. Within our Corporate segment, net sales to medium / large customers increased 10.9% between years, and net sales to small business customers increased 8.4% between years. These increases were primarily a result of hardware unit volume growth, most notably in notebook/mobile devices and netcomm products, and growth in software products as we continued to benefit from increased demand from our Corporate customers. Public segment net sales in 2011 increased $196.6 million, or 5.5%, between years as growth in the healthcare customer channel more than offset slight declines in the government and education customer channels. Net sales to healthcare customers increased $224.6 million, or 22.7%, between years, primarily driven by hardware unit volume increases in desktop computers, notebook/mobile devices and netcomm products, growth in software products and additional sales from an expanded relationship with a group purchasing organization. Net sales to government customers decreased $25.1 million, or 1.8%, in 2011 compared to 2010 driven by a 10.2% decline between years for the first nine months of 2011, partially offset by net sales growth of 22.8% between years for the fourth quarter of 2011. Although government spending was impacted negatively throughout 2011 as a result of budget constraints and uncertainty, net sales to federal government customers drove the fourth quarter increase of 22.8% in the government customer channel. The fourth quarter of 2011 benefited from increased orders placed late in the third quarter, the end of the federal governments fiscal year, that shipped during the fourth quarter, compared to the same period of the prior year. Net sales to education customers decreased $2.9 million, or 0.2%, between years, due to continuing budget pressures.
63
Gross profit
Gross profit increased $192.7 million, or 13.9%, to $1,583.5 million in 2011, compared to $1,390.8 million in 2010. As a percentage of total net sales, gross profit was 16.5% in 2011, up from 15.8% in 2010. Gross profit margin increased 70 basis points between years, primarily due to favorable price/mix changes within product margin across most product categories of 30 basis points, and a higher mix of commission and net service contract revenue of 20 basis points. Commission revenue, including agency fees earned on sales of software licenses and software assurance under enterprise agreements, has a positive impact on our gross profit margin as we record the fee or commission as a component of net sales when earned and there is no corresponding cost of sales amount. Net service contract revenue, including items such as third-party services and warranties, also has a positive impact on gross profit margin as our cost paid to the vendor or third-party service provider is recorded as a reduction to sales, resulting in net sales being equal to the gross profit on the transaction.
The gross profit margin may fluctuate based on various factors, including vendor incentive and inventory price protection programs, cooperative advertising funds classified as a reduction of cost of sales, product mix, net service contract revenue, commission revenue, pricing strategies, market conditions, and other factors, any of which could result in changes in gross profit margins.
Selling and administrative expenses
Selling and administrative expenses increased $58.0 million, or 6.2%, to $990.1 million in 2011, compared to $932.1 million in 2010. The increase was primarily due to higher payroll costs of $62.1 million driven by increased sales commissions and other variable compensation costs consistent with higher sales and gross profit and an increase in the number of coworkers in 2011. Our sales force increased to 3,636 coworkers at December 31, 2011, compared to 3,405 coworkers at December 31, 2010, while total coworker count increased to 6,745 coworkers at December 31, 2011, compared to 6,268 coworkers at December 31, 2010. We also had increases in profit sharing/401(k) expense of $4.9 million, travel and entertainment expense of $3.7 million and bad debt expense of $2.7 million. These increases were partially offset by lower consulting and debt-related professional fees of $10.0 million, lower depreciation and amortization expense of $4.2 million, lower healthcare benefits expense of $3.6 million and lower sales and use tax expense of $3.3 million.
Advertising expense
Advertising expense increased $16.7 million, or 15.7%, to $122.7 million in 2011, compared to $106.0 million in 2010. Higher expenses were due to increased spending on web-based advertising, TV advertising and customer-focused marketing events. As a percentage of net sales, advertising expense was 1.3% in 2011, compared to 1.2% in 2010.
64
Income from operations
The following table presents income (loss) from operations by segment, in dollars and as a percentage of net sales, and the year-over-year percentage change in income (loss) from operations for the years ended December 31, 2011 and 2010:
Year ended December 31, 2011 |
Year ended December 31, 2010 |
|||||||||||||||||||
Dollars in millions |
Operating margin percentage |
Dollars in millions |
Operating margin percentage |
Percent change in Income (loss) from operations |
||||||||||||||||
|
||||||||||||||||||||
Segments:(1) |
||||||||||||||||||||
Corporate |
$ | 331.6 | 6.2 | % | $ | 256.2 | 5.3 | % | 29.4 | % | ||||||||||
Public |
233.3 | 6.2 | 193.0 | 5.4 | 20.9 | |||||||||||||||
Other |
17.5 | 3.4 | 14.3 | 3.5 | 22.3 | |||||||||||||||
Headquarters(2) |
(111.7 | ) | nm | (110.8 | ) | nm | (0.8 | ) | ||||||||||||
|
|
|
|
|
|
|
|
|
|
|||||||||||
Total income from operations |
$ | 470.7 | 4.9 | % | $ | 352.7 | 4.0 | % | 33.5 | % | ||||||||||
|
(1) | Segment income (loss) from operations includes the segments direct operating income (loss) and allocations for Headquarters costs, allocations for logistics services, certain inventory adjustments, and volume rebates and cooperative advertising from vendors. |
(2) | Includes Headquarters function costs that are not allocated to the segments. |
Income from operations was $470.7 million in 2011, an increase of $118.0 million, or 33.5%, compared to $352.7 million in 2010. This increase was driven by higher net sales and gross profit, partially offset by higher advertising expense and selling and administrative expenses.
Corporate segment income from operations was $331.6 million in 2011, an increase of $75.4 million, or 29.4%, compared to $256.2 million in 2010. The increase in Corporate segment income from operations was primarily driven by higher net sales and gross profit margin, partially offset by higher selling and administrative costs, resulting in a net increase before allocations of $49.6 million in 2011 compared to 2010. In addition, Corporate segment income from operations benefited from an increase of $28.3 million in income allocations from our logistics operations in 2011 compared to 2010. The improved profitability of our logistics operations was driven by stronger operating leverage given higher purchase volumes while support structure costs remained flat. Partially offsetting the above items was an increase in Headquarters expense allocations to the Corporate segment of $2.5 million.
Public segment income from operations was $233.3 million in 2011, an increase of $40.3 million, or 20.9%, compared to $193.0 million in 2010. The increase reflected higher operating income before allocations of $25.9 million as a result of higher net sales and gross profit margin, partially offset by higher selling and administrative costs. In addition, Public segment income from operations benefited from an increase of $15.1 million in income allocations from our logistics operations in 2011 compared to 2010.
The loss from operations for our Headquarters function of $111.7 million in 2011 was flat compared to the loss from operations of $110.8 million in 2010.
Interest expense, net
At December 31, 2011, our outstanding long-term debt totaled $4,066.0 million, compared to $4,289.1 million at December 31, 2010. Net interest expense in 2011 was $324.2 million, a decrease of $67.7 million compared to $391.9 million in 2010. Interest expense was reduced by
65
$19.4 million in 2011 due to a decrease in the long-term accrued interest liability associated with the extinguishment of $1,078.0 million of Senior Notes due 2015. The long-term accrued interest liability represents the difference between interest expense previously recognized under the effective interest method and actual interest paid. The remaining decrease of $48.3 million was primarily due to lower effective interest rates in 2011 resulting from the termination of our interest rate swaps in January 2011 and the debt refinancing activities completed during the first half of 2011, partially offset by non-cash gains on hedge ineffectiveness recorded to interest expense in the prior year.
Net (loss) gain on extinguishments of long-term debt
During 2011, we recorded a net loss on extinguishments of long-term debt of $118.9 million compared to a net gain on extinguishments of long-term debt of $2.0 million in 2010.
In March 2011, we amended the Term Loan Facility and recorded a loss on extinguishment of long-term debt of $3.2 million, representing a write-off of a portion of the unamortized deferred financing costs on this facility.
In April and May 2011, we purchased $1,078.0 million of Senior Notes due 2015, funded with the issuance of $1,175.0 million of Senior Notes. As a result, we recorded a loss on extinguishment of long-term debt of $114.1 million, representing the difference between the purchase price of the Senior Notes due 2015 at 109% of par value and the net carrying amount of the purchased debt, adjusted for a portion of the unamortized deferred financing costs.
In June 2011, we entered into a new $900.0 million ABL Facility, replacing the existing $800.0 million ABL Facility. As a result, we recorded a loss on extinguishment of long-term debt of $1.6 million representing a write-off of a portion of the unamortized deferred financing costs related to the previous facility.
During 2010, we recorded a net gain of $2.0 million on the extinguishments of long-term debt resulting from two transactions. In March 2010, we repurchased $28.5 million of principal amount of senior subordinated bridge loans for a purchase price of $18.6 million. We recorded a gain of $9.2 million representing the difference between the purchase price, including expenses paid to the debt holders and agent, and the net carrying amount of the purchased debt, adjusted for a portion of the unamortized deferred financing costs. The $28.5 million in principal amount of senior subordinated bridge loans that was repurchased was exchanged for increasing rate notes and subsequently surrendered to the indenture trustee for cancellation. In December 2010, we extinguished $500.0 million of the outstanding principal balance of the Term Loan Facility funded by proceeds from the issuance of Senior Secured Notes. We recorded a loss of $7.2 million on the extinguishment of the Term Loan Facility, representing a write-off of a portion of the unamortized deferred financing costs. There was no additional gain or loss resulting from the paydown of the debt balance, as the cash paid equaled the principal amount of the debt extinguished.
Income tax (expense) benefit
The effective income tax rate was 39.7% and 21.1% for 2011 and 2010, respectively.
For 2011, the effective tax rate differed from the U.S. federal statutory rate primarily due to the unfavorable impact of permanent differences relative to pre-tax income. The effective tax rate for 2010 reflects the unfavorable impact of permanent differences relative to a small pre-tax loss.
66
Net income (loss)
Net income was $17.1 million in 2011, compared to a net loss of $29.2 million in 2010.
Adjusted EBITDA
Adjusted EBITDA was $717.3 million in 2011, an increase of $115.4 million, or 19.2%, compared to $601.8 million in 2010. As a percentage of net sales, Adjusted EBITDA was 7.5% and 6.8% in 2011 and 2010, respectively.
We have included a reconciliation of EBITDA and Adjusted EBITDA for 2011 and 2010 in the table below. EBITDA is defined as consolidated net income (loss) before interest expense, income tax expense (benefit), depreciation and amortization. Adjusted EBITDA, which is a measure defined in the Senior Credit Facilities, means EBITDA adjusted for certain items which are described in the table below. Both EBITDA and Adjusted EBITDA are considered non-GAAP financial measures. Generally, a non-GAAP financial measure is a numerical measure of a companys performance, financial position or cash flows that either excludes or includes amounts that are not normally included or excluded in the most directly comparable measure calculated and presented in accordance with GAAP. Non-GAAP measures used by the Company may differ from similar measures used by other companies, even when similar terms are used to identify such measures. We believe that EBITDA and Adjusted EBITDA provide helpful information with respect to our operating performance and cash flows including our ability to meet our future debt service, capital expenditures and working capital requirements. Adjusted EBITDA also provides helpful information as it is the primary measure used in certain financial covenants contained in the Senior Credit Facilities. See Selected consolidated financial and operating data for a reconciliation of EBITDA to cash flows from operating activities.
Years ended December 31, |
||||||||
(in millions) | 2011 | 2010 | ||||||
|
||||||||
Net income (loss) |
$ | 17.1 | $ | (29.2 | ) | |||
Depreciation and amortization |
204.9 | 209.4 | ||||||
Income tax expense (benefit) |
11.2 | (7.8 | ) | |||||
Interest expense, net |
324.2 | 391.9 | ||||||
|
|
|||||||
EBITDA |
557.4 | 564.3 | ||||||
|
|
|||||||
Adjustments: |
||||||||
Non-cash equity-based compensation |
19.5 | 11.5 | ||||||
Sponsor fee |
5.0 | 5.0 | ||||||
Consulting and debt-related professional fees |
5.1 | 15.1 | ||||||
Net loss (gain) on extinguishments of long-term debt |
118.9 | (2.0 | ) | |||||
Other adjustments(1) |
11.4 | 7.9 | ||||||
|
|
|||||||
Total adjustments |
159.9 | 37.5 | ||||||
|
|
|||||||
Adjusted EBITDA |
$ | 717.3 | $ | 601.8 | ||||
|
(1) | Other adjustments include certain retention costs and equity investment income. |
67
Unaudited quarterly financial results
The following tables present our unaudited quarterly consolidated results of operations for the eight quarters ended December 31, 2012. This unaudited quarterly consolidated information has been prepared on the same basis as our Audited Financial Statements and, in the opinion of management, the statements of operations data includes all adjustments, consisting of normal recurring adjustments, necessary for the fair presentation of the results of operations for these periods. You should read this table in conjunction with our Audited Financial Statements and the related notes located elsewhere in this prospectus. The results of operations for any quarter are not necessarily indicative of the results of operations for any future periods.
2012 | ||||||||||||||||
(in millions) | First quarter | Second quarter | Third quarter | Fourth quarter | ||||||||||||
|
||||||||||||||||
Net Sales Detail: |
||||||||||||||||
Corporate: |
||||||||||||||||
Medium / Large |
$ | 1,089.6 | $ | 1,124.7 | $ | 1,055.7 | $ | 1,178.5 | ||||||||
Small Business |
273.2 | 269.7 | 257.1 | 264.3 | ||||||||||||
|
|
|||||||||||||||
Total Corporate |
1,362.8 | 1,394.4 | 1,312.8 | 1,442.8 | ||||||||||||
Public: |
||||||||||||||||
Government |
262.6 | 318.0 | 408.6 | 404.9 | ||||||||||||
Education |
221.7 | 349.5 | 394.7 | 226.4 | ||||||||||||
Healthcare |
333.3 | 372.9 | 360.4 | 370.0 | ||||||||||||
|
|
|||||||||||||||
Total Public |
817.6 | 1,040.4 | 1,163.7 | 1,001.3 | ||||||||||||
Other |
138.8 | 149.9 | 146.8 | 156.9 | ||||||||||||
|
|
|||||||||||||||
Net sales |
$ | 2,319.2 | $ | 2,584.7 | $ | 2,623.3 | $ | 2,601.0 | ||||||||
|
|
|||||||||||||||
Gross profit |
$ | 384.6 | $ | 426.9 | $ | 432.7 | $ | 425.4 | ||||||||
Income from operations |
$ | 103.6 | $ | 136.4 | $ | 139.7 | $ | 130.9 | ||||||||
Net income |
$ | 10.9 | $ | 36.8 | $ | 38.0 | $ | 33.3 | ||||||||
|
2011 | ||||||||||||||||
(in millions) | First quarter | Second quarter | Third quarter | Fourth quarter | ||||||||||||
|
||||||||||||||||
Net Sales Detail: |
||||||||||||||||
Corporate: |
||||||||||||||||
Medium / Large |
$ | 1,022.9 | $ | 1,075.0 | $ | 1,070.6 | $ | 1,118.6 | ||||||||
Small Business |
256.4 | 263.4 | 259.7 | 267.8 | ||||||||||||
|
|
|||||||||||||||
Total Corporate |
1,279.3 | 1,338.4 | 1,330.3 | 1,386.4 | ||||||||||||
Public: |
||||||||||||||||
Government |
231.9 | 296.1 | 388.1 | 427.4 | ||||||||||||
Education |
214.6 | 343.3 | 415.7 | 224.1 | ||||||||||||
Healthcare |
277.4 | 311.8 | 319.3 | 307.5 | ||||||||||||
|
|
|||||||||||||||
Total Public |
723.9 | 951.2 | 1,123.1 | 959.0 | ||||||||||||
Other |
126.4 | 122.5 | 128.0 | 133.9 | ||||||||||||
|
|
|||||||||||||||
Net sales |
$ | 2,129.6 | $ | 2,412.1 | $ | 2,581.4 | $ | 2,479.3 | ||||||||
|
|
|||||||||||||||
Gross profit |
$ | 350.4 | $ | 400.8 | $ | 420.0 | $ | 412.3 | ||||||||
Income from operations |
$ | 91.7 | $ | 128.2 | $ | 139.7 | $ | 111.1 | ||||||||
Net (loss) income |
$ | (4.2 | ) | $ | (34.8 | ) | $ | 37.1 | $ | 19.0 | ||||||
|
68
Seasonality
While we have not historically experienced significant seasonality throughout the year, sales in our Corporate segment, which primarily serves business customers, are typically higher in the fourth quarter than in other quarters due to customers spending their remaining technology budget dollars at the end of the year. Additionally, sales in our Public segment have historically been higher in the third quarter than in other quarters primarily due to the buying patterns of the federal government and education customers.
Liquidity and capital resources
Overview
We finance our operations and capital expenditures through a combination of internally generated cash from operations and from borrowings under the ABL Facility. We believe that our current sources of funds will be sufficient to fund our cash operating requirements for the next year. In addition, we believe that, in spite of the uncertainty of future macroeconomic conditions, we have adequate sources of liquidity and funding available to meet our longer-term needs. However, there are a number of factors that may negatively impact our available sources of funds. The amount of cash generated from operations will be dependent upon factors such as the successful execution of our business plan and general economic conditions.
Cash flows
Cash flows from operating, investing and financing activities were as follows:
Years ended December 31, |
||||||||||||
(in millions) | 2012 | 2011 | 2010 | |||||||||
|
||||||||||||
Net cash provided by (used in): |
||||||||||||
Operating activities |
$ | 317.4 | $ | 214.7 | $ | 423.7 | ||||||
Investing activities |
(41.7 | ) | (56.0 | ) | (125.4 | ) | ||||||
Net change in accounts payableinventory financing |
(29.5 | ) | 250.5 | 3.2 | ||||||||
Other financing activities |
(308.5 | ) | (345.9 | ) | (353.3 | ) | ||||||
|
|
|||||||||||
Financing activities |
(338.0 | ) | (95.4 | ) | (350.1 | ) | ||||||
Effect of exchange rate changes on cash and cash equivalents |
0.3 | | 0.4 | |||||||||
|
|
|||||||||||
Net (decrease) increase in cash and cash equivalents |
$ | (62.0 | ) | $ | 63.3 | $ | (51.4 | ) | ||||
|
Operating activities
Net cash provided by operating activities for 2012 increased $102.7 million compared to 2011. The increase was primarily driven by changes in assets and liabilities, resulting in a $148.9 million increase in net cash provided by operating activities between periods. Despite a 2012 fourth quarter increase in net sales of 4.9% between years, accounts receivable remained relatively flat from the prior year end driven by improved collection results, particularly within the Public segment. Accounts receivable in 2011 represented a use of cash of $165.3 million, primarily due to a 2011 fourth quarter increase in net sales of 9.3% from the same period in the prior year. Merchandise inventory also contributed $36.1 million of the increase in cash between years driven by a return to more normalized inventory levels in 2012 following the build-up at the end of 2011 related to the hard drive shortage from the Thailand floods, along with a higher percentage of drop shipments from vendor partners and distributors in 2012 compared to 2011.
69
Partially offsetting these factors in 2012 was a $54.1 million decrease in other assets as we collected $53.3 million in income tax refunds in 2011 that did not repeat in 2012. Net income adjusted for the impact of non-cash items such as losses on extinguishment of long-term debt was $326.8 million in 2012 compared to $373.0 million in 2011, or a decrease of $46.2 million. Improved operating performance in 2012 drove higher net income between years, but also higher net cash income taxes paid. Net cash income taxes paid in 2012 were $123.2 million compared to a net cash tax refund of $20.9 million in 2011. In addition to the $53.3 million in cash tax refunds received in 2011, we also fully utilized our remaining federal net operating tax loss carryforwards during 2011.
Net cash provided by operating activities for 2011 decreased $209.0 million compared to 2010. The decrease was primarily driven by the changes in assets and liabilities, resulting in a $323.6 million reduction in cash between years. For 2011, the changes in assets and liabilities, excluding cash and cash equivalents, reduced cash by $158.3 million compared to a cash contribution of $165.3 million in 2010. The most significant driver of the cash contribution in 2010 was an increase in accounts payabletrade of $269.3 million as we reduced the amount of accelerated payments we made in exchange for early pay discounts at December 31, 2010 compared to the prior year. Accounts payabletrade decreased $19.8 million in 2011 compared to 2010, resulting in a relatively small reduction in cash. Cash flow from operating activities was further reduced by $83.7 million in 2011 compared to 2010 following an increase in accounts receivable between years driven by higher fourth quarter net sales in 2011. During 2011, we collected $53.3 million in cash tax refunds which reduced other assets between years, resulting in an increase in cash flow from operating activities. Net income, adjusting for the impact of non-cash items such as losses on extinguishment of long-term debt, increased $114.6 million between years reflecting our improved operating results in 2011.
In order to manage our working capital and operating cash needs, we monitor our cash conversion cycle, defined as days of sales outstanding in accounts receivable plus days of supply in inventory, less days of purchases outstanding in accounts payable. The following table presents the components of our cash conversion cycle:
December 31, |
||||||||||||
(in days) | 2012 | 2011 | 2010 | |||||||||
|
||||||||||||
Days of sales outstanding (DSO)(1) |
42 | 44 | 43 | |||||||||
Days of supply in inventory (DIO)(2) |
14 | 15 | 15 | |||||||||
Days of purchases outstanding (DPO)(3) |
(32 | ) | (32 | ) | (26 | ) | ||||||
|
|
|||||||||||
Cash conversion cycle |
24 | 27 | 32 | |||||||||
|
(1) | Represents the rolling three month average of the balance of trade accounts receivable, net at the end of the period divided by average daily net sales. Also incorporates components of other miscellaneous receivables. |
(2) | Represents the rolling three month average of the balance of inventory at the end of the period divided by average daily cost of goods sold for the same three-month period. |
(3) | Represents the rolling three month average of the combined balance of accounts payabletrade, excluding cash overdrafts, and accounts payableinventory financing at the end of the period divided by average daily cost of goods sold for the same three-month period. |
The cash conversion cycle decreased to 24 days at December 31, 2012 compared to 27 days at December 31, 2011, driven by improvements in DSO and DIO. The DSO decline was primarily related to improved collections in the Public segment. The DIO decline was primarily related to an increase in the percentage of products delivered to customers via drop-shipment in 2012 compared to 2011, which had the effect of increasing cost of sales without a corresponding increase in inventory-related working capital.
70
The cash conversion cycle decreased to 27 days at December 31, 2011 compared to 32 days at December 31, 2010, driven by a six-day increase in DPO. The increase in DPO reflected a higher combined balance of accounts payabletrade and accounts payableinventory financing at December 31, 2011 compared to December 31, 2010 as purchase volumes increased to support higher net sales and we received more favorable payment terms for payables related to certain vendors. The one-day increase in DSO primarily reflected our overall sales growth and a higher proportion of government sales in the fourth quarter of 2011 compared to the same period in 2010.
Investing activities
Net cash used in investing activities in 2012 decreased $14.3 million compared to 2011. This decline was primarily due to a reduction in cash payments between years of $6.6 million related to interest rate swap agreements, as the $6.6 million paid in 2011 reflected the final payment upon termination of the swap agreements on January 14, 2011. Capital expenditures were $41.4 million for 2012 and $45.7 million for 2011, primarily for improvements to our information technology systems during both years. During 2012 and 2011, we paid $0.3 million and $3.7 million, respectively, for new interest rate cap agreements.
Net cash used in investing activities in 2011 decreased $69.4 million compared to 2010. This decline was primarily due to a reduction in cash payments between years of $71.5 million under our interest rate swap agreements, as the $6.6 million paid in 2011 reflected the final payment upon termination of the swap agreements. Capital expenditures were $45.7 million for 2011 and $41.5 million for 2010, primarily for improvements to our information technology systems during both years. During 2011 and 2010, we paid $3.7 million and $5.9 million, respectively, for new interest rate cap agreements.
Financing activities
Net cash used in financing activities increased $242.6 million in 2012 compared to 2011. This change was primarily driven by 2011 net inflows from accounts payableinventory financing of $250.5 million compared to 2012 outflows of $29.5 million, resulting in a total impact on the change in cash used in financing activities of $280.0 million from accounts payableinventory financing. The reduction in cash during 2012 from accounts payableinventory financing was primarily due to the termination of one of our inventory financing agreements in the first quarter of 2012, with amounts owed for subsequent purchases being included in accounts payabletrade on the consolidated balance sheet and classified as cash flows from operating activities on the consolidated statement of cash flows. As discussed below under Inventory financing arrangements, in June 2011 we entered into a new inventory financing agreement with a financial intermediary to facilitate the purchase of inventory from a certain vendor.
Inventory purchases from this vendor under the June 2011 inventory financing agreement are included in accounts payableinventory financing and reported as cash flows from financing activities. The net impact of our debt transactions resulted in cash outflows of $310.6 million during 2012 and $346.5 million during 2011 as cash was used in each period to reduce our total long -term debt. Each debt transaction is described below under Long-term debt and financing arrangements.
Net cash used in financing activities decreased $254.7 million in 2011 compared to 2010, primarily driven by higher cash inflows of $247.3 million from accounts payableinventory financing. As
71
discussed below under Inventory financing arrangements, in June 2011 we entered into a new inventory financing agreement with a financial intermediary to facilitate the purchase of inventory from a certain vendor. Inventory purchases from this vendor under the new agreement are included in accounts payableinventory financing and reported as cash flows from financing activities. A combination of the increase in overall purchase volume under inventory financing agreements to support higher net sales in 2011 along with more favorable payment terms under the new inventory financing agreement drove the majority of the increase in cash flows from financing activities during 2011 compared to 2010. The net impact of our debt transactions resulted in cash outflows of $346.5 million during 2011 compared to cash outflows of $352.7 million during 2010 as cash was used in each period to reduce our total long-term debt. Each debt transaction is described below under Long-term debt and financing arrangements.
Long-term debt and financing arrangements
Long-term debt was as follows:
(in millions) |
Interest rate(1) | December 31, 2012 |
December 31, 2011 |
|||||||||
|
||||||||||||
ABL Facility due 2016 |
| % | $ | | $ | | ||||||
Term Loan Facility due 2014 |
3.9 | 421.3 | 484.5 | |||||||||
Term Loan Facility due 2017 |
3.9 | 918.2 | 1,056.0 | |||||||||
Senior Secured Notes due 2018 |
8.0 | 500.0 | 500.0 | |||||||||
Senior Notes due 2019 |
8.5 | 1,305.0 | 1,175.0 | |||||||||
Unamortized premium on Senior Notes due 2019 |
| 5.0 | | |||||||||
Senior Exchange Notes due 2015 |
| | 129.0 | |||||||||
Senior Subordinated Notes due 2017 |
12.535 | % | 621.5 | 721.5 | ||||||||
|
|
|||||||||||
Total long-term debt |
3,771.0 | 4,066.0 | ||||||||||
Less current maturities of long-term debt |
(40.0 | ) | (201.0 | ) | ||||||||
|
|
|||||||||||
Long-term debt, excluding current maturities |
$ | 3,731.0 | $ | 3,865.0 | ||||||||
|
(1) | Weighted-average interest rate as of December 31, 2012. |
As of December 31, 2012, we were in compliance with the covenants under the various credit facilities, which are described below.
ABL Facility
At December 31, 2012, there were no outstanding borrowings under the ABL Facility, $1.7 million of undrawn letters of credit and $275.9 million reserved related to the floorplan sub-facility.
On June 24, 2011, CDW LLC entered into the ABL Facility, a new five-year $900.0 million senior secured asset-based revolving credit facility, with the facility being available for borrowings, issuance of letters of credit and floorplan financing for certain vendor products. The ABL Facility matures on June 24, 2016, subject to an acceleration provision discussed below. The ABL Facility replaced the previous revolving loan credit facility that was to mature on October 12, 2012. The ABL Facility (i) increased the overall revolving credit facility capacity available to us from $800.0 million to $900.0 million, (ii) increased the maximum aggregate amount of increases that may be made to the ABL Facility from $100.0 million to $200.0 million, (iii) added a maturity acceleration provision based upon excess cash availability whereby the ABL Facility may mature 45 days prior to the maturity of the non-extended portion of the Term Loan Facility if excess cash availability
72
does not exceed an amount equal to $150 million plus the outstanding borrowings under the non-extended portion of the Term Loan Facility, (iv) increased the fee on the unused portion of the ABL 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, we recorded a loss on extinguishment of long-term debt of $1.6 million in the 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 ABL Facility 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 to the Audited Financial Statements, we have entered into agreements with certain financial intermediaries to facilitate the purchase of inventory from various suppliers. In connection with the floorplan sub-facility, we entered into an inventory financing agreement on an unsecured basis with a financial intermediary to facilitate the purchase of inventory from this vendor (the ABL facility inventory financing agreement). Amounts outstanding under the ABL facility inventory financing agreement are unsecured and non-interest bearing. We will either pay the outstanding ABL facility inventory financing agreement amounts when they become due, or the ABL Facilitys administrative agent will automatically initiate an advance on the ABL Facility 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 ABL facility inventory financing agreement, which did not reflect payments we made on December 31, 2012. The total amount reported on the consolidated balance sheet as accounts payableinventory financing related to the ABL facility 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 ABL facility 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 ABL Facility. Changes in cash flows from the ABL facility inventory financing agreement are reported in financing activities on our consolidated statement of cash flows.
Borrowings under the ABL Facility 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 our 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 ABL Facility 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 ABL facility 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
73
the agreement less (b) any reserves. At December 31, 2012, the borrowing base was $1,018.2 million as supported by eligible inventory and accounts receivable balances as of November 30, 2012. CDW LLC could have borrowed up to an additional $622.4 million under the ABL Facility at December 31, 2012.
CDW LLC is the borrower under the ABL Facility. All obligations under the ABL Facility are guaranteed by CDW Corporation and each of CDW LLCs direct and indirect, 100% owned, domestic subsidiaries. Borrowings under the ABL Facility are collateralized by a first priority interest in inventory (excluding inventory collateralized under the inventory floorplan arrangements as described in Note 5 to the Audited Financial Statements), deposits, and accounts receivable, and a second priority interest in substantially all other assets. The ABL Facility contains negative covenants that, among other things, place restrictions and limitations on the ability of CDW Corporation and each of CDW LLCs 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 ABL Facility also includes maintenance of a minimum average daily excess cash availability requirement. Should we fall below the minimum average daily excess cash availability requirement for five consecutive business days, CDW LLC will become subject to a fixed charge coverage ratio until such time as the daily excess cash availability requirement is met for 30 consecutive business days.
Term Loan Facility
At December 31, 2012, the outstanding principal amount of the Term Loan Facility was $1,339.5 million, with $421.3 million of non-extended term loans due October 10, 2014 and $918.2 million of extended term loans due July 15, 2017. The effective weighted-average interest rate on Term Loan Facility principal amounts outstanding on December 31, 2012 was 3.9% per annum.
Borrowings under the Term Loan Facility bear interest at either (a) the ABR plus a margin; or (b) LIBOR plus a margin. The margin is based on our senior secured leverage ratio, as defined in the amended agreement evidencing the Term Loan Facility. 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, CDW LLC entered into an amendment to the Term Loan Facility, 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 repricings of any extended loans for the six-month period following the effective date of the amendment. In connection with this amendment, we recorded a loss on extinguishment of long-term debt of $3.2 million in the 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 Facility.
74
The Term Loan Facility requires us to make certain mandatory prepayments of principal amounts under certain circumstances, including (i) a prepayment in an amount equal to 50% of our 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 us or our 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. On January 30, 2013, we 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 with respect to the year ended December 31, 2012. We were 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, we 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 Facility. All obligations under the Term Loan Facility are guaranteed by CDW Corporation and each of CDW LLCs direct and indirect, 100% owned, domestic subsidiaries. The Term Loan Facility is collateralized by a second priority interest in substantially all inventory (excluding inventory collateralized under the inventory floorplan arrangements as described in Note 5 to the Audited Financial Statements), deposits, and accounts receivable, and by a first priority interest in substantially all other assets. The Term Loan Facility contains negative covenants that, among other things, place restrictions and limitations on the ability of CDW Corporation and each of CDW LLCs 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 Facility also includes a senior secured leverage ratio requirement. The senior secured leverage ratio is required to be maintained on a quarterly basis and is defined as the ratio of senior secured debt (including amounts owed under certain inventory floorplan arrangements) less cash and cash equivalents, to Adjusted EBITDA, a non-GAAP financial measure, for the most recently ended four fiscal quarters. 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 senior secured leverage ratio requirement is a material component of the Term Loan Facility. Non-compliance with the senior secured leverage ratio requirement would result in a default under the credit agreement governing the Term Loan Facility and could prevent us from borrowing under the ABL Facility. If there were an event of default under the credit agreement governing the Term Loan Facility that was not cured or waived, the lenders under the Term Loan Facility could cause all amounts outstanding under the Term Loan Facility to be due and payable immediately, which would have a material adverse effect on our financial position and cash flows. For a discussion of net cash
75
provided by (used in) operating activities, investing activities and financing activities, see Liquidity and capital resourcesCash flows.
We are 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 Facility 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 to the Audited Financial Statements, we have satisfied this requirement through January 14, 2015.
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 are the co-issuers of the Senior Secured Notes and the obligations under the notes are guaranteed by CDW Corporation and each of CDW LLCs direct and indirect, 100% owned, domestic subsidiaries. The Senior Secured Notes are secured on a pari passu basis with the Term Loan Facility by a second priority interest in substantially all inventory (excluding inventory collateralized under the inventory floorplan arrangements as described in Note 5 to the Audited Financial Statements), deposits, and accounts receivable, and by a first priority interest in substantially all other assets. The indenture governing the Senior Secured Notes contains negative covenants that, among other things, place restrictions and limitations on the ability of CDW Corporation and each of CDW LLCs 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 indenture governing the Senior Secured Notes does not contain any financial covenants.
Senior Notes due 2015
At December 31, 2012, there were no outstanding Senior Notes due 2015.
On April 13, 2011, CDW LLC and CDW Finance completed a cash tender offer (the Senior Tender Offer) and purchased $665.1 million aggregate principal amount of the Senior Notes due 2015 comprised of $519.2 million of the senior cash pay exchange notes due 2015 and $145.9 million of the senior PIK election exchange notes due 2015. CDW LLC and CDW Finance concurrently issued $725.0 million aggregate principal amount of Senior Notes. The proceeds from this offering, together with cash on hand and borrowings under the then-outstanding ABL 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, CDW LLC and CDW Finance completed a follow-on cash tender offer (the Follow-on Senior Tender Offer, and together with the Senior Tender Offer, the 2011 Senior 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 cash pay exchange notes due 2015 and $91.4 million of the senior PIK election exchange notes due 2015. CDW LLC and CDW Finance concurrently issued $450.0 million aggregate principal amount of additional Senior
76
Notes. The proceeds from this offering, together with cash on hand and borrowings under the then-outstanding ABL 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 2011 Senior Tender Offers, we recorded a loss on extinguishment of long-term debt of $114.1 million in the 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, CDW LLC and CDW Finance commenced a cash tender offer (the 2012 Senior Tender Offer, and together with the 2011 Senior Tender Offers, the Senior Tender Offers) to purchase any and all of the remaining $129.0 million aggregate principal amount of Senior Notes due 2015. On February 17, 2012, CDW LLC and CDW Finance accepted for purchase $120.6 million aggregate principal amount of the outstanding Senior Notes due 2015 that were tendered. On March 5, 2012, CDW LLC and CDW Finance 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, CDW LLC and CDW Finance redeemed the remaining $8.3 million aggregate principal amount of Senior Notes due 2015 that was not tendered. CDW LLC and CDW Finance 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 at an issue price of 104.375% of par on February 17, 2012. The proceeds from this issuance, together with cash on hand and borrowings under the ABL Facility, funded the purchase of the tendered and redeemed Senior Notes due 2015, including $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 the 2012 Senior Tender Offer, we recorded a loss on extinguishment of long-term debt of $9.4 million in the 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.
Senior Notes
As discussed above, on April 13, 2011, CDW LLC and CDW Finance issued $725.0 million aggregate principal amount of Senior Notes and on May 20, 2011, CDW LLC and CDW Finance issued an additional $450.0 million aggregate principal amount of Senior Notes. The proceeds from these issuances together with cash on hand and borrowings under the then-outstanding ABL Facility were used to fund the 2011 Senior Tender Offers.
On February 17, 2012, CDW LLC and CDW Finance issued $130.0 million aggregate principal amount of additional Senior Notes at an issue price of 104.375% of par. The proceeds from this issuance together with cash on hand and borrowings under the ABL Facility were used to fund
77
the 2012 Senior Tender Offer. 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 are the co-issuers of the Senior Notes. Obligations under the Senior Notes are guaranteed on an unsecured senior basis by CDW Corporation and each of CDW LLCs direct and indirect, 100% owned, domestic subsidiaries. The indenture governing the Senior Notes contains negative covenants that, among other things, place restrictions and limitations on the ability of CDW Corporation and each of CDW LLCs 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 indenture governing the Senior Notes does not contain any financial covenants.
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, CDW LLC and CDW Finance 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, we recorded a loss on extinguishment of long-term debt of $7.8 million in the 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 our 100% owned subsidiaries purchased $28.5 million of principal amount of senior subordinated bridge loans for a purchase price of $18.6 million. We recorded a gain on the extinguishment of long-term debt of $9.2 million in the 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 are the co-issuers of the Senior Subordinated Notes. Obligations under the Senior Subordinated Notes are guaranteed on an unsecured senior basis by CDW Corporation and each of CDW LLCs direct and indirect, 100% owned, domestic subsidiaries. The indenture governing the Senior Subordinated Notes contains negative covenants that, among other things, place restrictions and limitations on the ability of CDW Corporation and each of CDW LLCs direct and indirect, 100% owned, domestic subsidiaries to dispose of assets, incur additional indebtedness, incur guarantee obligations, prepay other indebtedness, make distributions or other