CDW Corp (CDW) FY 2023 MD&A
This page reproduces the company's own Item 7 MD&A text from the linked SEC filing. It is filer text, not grepcent analysis, scoring, or investment advice.
Item 7. Management’s Discussion and Analysis of Financial Condition and Results of Operations
Unless otherwise indicated or the context otherwise requires, as used in this “Management’s Discussion and Analysis of Financial Condition and Results of Operations,” the terms “we,” “us,” “the Company,” “our,” “CDW” and similar terms refer to CDW Corporation and its subsidiaries. “Management’s Discussion and Analysis of Financial Condition and Results of Operations” should be read in conjunction with the Consolidated Financial Statements and the related notes included elsewhere in this report. This discussion contains forward-looking statements that are subject to numerous risks and uncertainties. Actual results may differ materially from those contained in any forward-looking statements. See “Forward-Looking Statements” above.
Overview
CDW Corporation, a Fortune 500 company and member of the S&P 500 Index, is a leading multi-brand provider of information technology (“IT”) solutions to small, medium and large business, government, education and healthcare customers in the US, the UK and Canada. Our broad array of offerings ranges from discrete hardware and software products to integrated IT solutions and services that include on-premise and cloud capabilities across hybrid infrastructure, digital experience and security.
We are vendor, technology and consumption model unbiased, with a solutions portfolio including more than 100,000 products and services from more than 1,000 leading and emerging brands. Our solutions are delivered in physical, virtual and cloud-based environments through approximately 10,900 customer-facing coworkers, including sellers, highly-skilled technology specialists and advanced service delivery engineers. We are a leading sales channel partner for many original equipment manufacturers (“OEMs”), software publishers and cloud providers (collectively, our “vendor partners”), whose products we sell or include in the solutions we offer. We provide our vendor partners with a cost-effective way to reach customers and deliver a consistent brand experience through our established end-market coverage, technical expertise and extensive customer access.
We have three reportable segments: Corporate, Small Business and Public. Our Corporate segment primarily serves US private sector business customers with more than 250 employees. Our Small Business segment primarily serves US private sector business customers with up to 250 employees. Our Public segment is comprised of government agencies and education and healthcare institutions in the US. We also have two other operating segments: CDW UK and CDW Canada, each of which do not meet the reportable segment quantitative thresholds and, accordingly, are included in an all other category (“Other”).
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 significant portion of our advertising and marketing expenses are reimbursed through cooperative advertising programs with our vendor partners. These programs are at the discretion of our vendor partners and are typically tied to sales or other commitments to be met by us within a specified period of time.
For a discussion of results for the year ended December 31, 2022, see “Item 7. Management’s Discussion and Analysis of Financial Condition and Results of Operations” of our Annual Report on Form 10-K for the year ended December 31, 2022, filed with the Securities and Exchange Commission on February 24, 2023.
Trends and Key Factors Affecting our Financial Performance
We believe the following key factors may have a meaningful impact on our business performance, influencing our ability to generate sales and achieve our targeted financial and operating results:
•General economic conditions are a key factor affecting our results as they can impact our customers’ willingness and ability to spend on information technology. Macroeconomic uncertainty persists as a result of the current inflationary environment, the corresponding increase in interest rates driven by monetary policy and lower economic growth rates in the United States and other countries. The uncertainty in the current economic environment resulted in, and may continue to result in, a delay, pause or reduction of investments in technology by our customers.
•Customers continue to balance priorities to focus on solutions that lead to business optimization, cost management and security risk management and in many cases are reassessing the timing of IT refresh cycles and pausing or deferring their IT spend. We have orchestrated solutions by leveraging netcomm products, security, software and hybrid and cloud offerings to help customers achieve their objectives.
25
Table of Contents
•Changes in spending policies, budget priorities and funding levels, including current and future stimulus packages, are key factors influencing the purchasing levels of Government, Healthcare and Education customers. As the duration and ongoing impact of current economic conditions remain uncertain, current and future budget priorities and funding levels for Government, Healthcare and Education customers may be adversely affected, leading to lower IT spend.
•Technology trends drive customer purchasing behaviors in the market. Current technology trends are focused on delivering greater flexibility and efficiency, as well as designing and managing IT securely. These trends are driving customer adoption of solutions such as those delivered via cloud, software defined architectures and hybrid on-premise and off-premise combinations, as well as the evolution of the IT consumption model to more “as a service” offerings, including software as a service and infrastructure as a service, in addition to ongoing managed and professional service arrangements. Technology trends are likely to change as customers prioritize the projects that produce the most important outcomes for their business.
Key Business Metrics
We monitor 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 profit, Net income, Operating income, Operating income margin, Non-GAAP operating income, Non-GAAP operating income margin, Non-GAAP net income, Net sales on a constant currency basis, Net income per diluted share, Non-GAAP net income per diluted share, Free cash flow, Adjusted free cash flow, Cash and cash equivalents, cash conversion cycle and debt levels including available credit. These measures and ratios are closely monitored by management, so that actions can be taken, as necessary, in order to achieve financial objectives.
In this section, we present Non-GAAP operating income, Non-GAAP operating income margin, Non-GAAP net income, Non-GAAP net income per diluted share, Net sales on a constant currency basis, Free cash flow and Adjusted free cash flow, which are non-GAAP financial measures.
We believe Non-GAAP operating income, Non-GAAP operating income margin, Non-GAAP net income, Non-GAAP net income per diluted share and Net sales on a constant currency basis provide analysts, investors and management with helpful information regarding the underlying operating performance of our business, as they remove the impact of items that management believes are not reflective of underlying operating performance. Management uses these measures to evaluate period-over-period performance as management believes they provide a more comparable measure of the underlying business. We also present Free cash flow and Adjusted free cash flow as we believe these measures provide more information regarding our liquidity and capital resources. Certain non-GAAP financial measures are also used to determine certain components of performance-based compensation. For the definitions of Non-GAAP measures and reconciliations to the most directly comparable US GAAP measure, see “Results of Operations - Non-GAAP Financial Measure Reconciliations.”
26
Table of Contents
The results of certain key business metrics are as follows:
| Year Ended December 31, | ||||||
|---|---|---|---|---|---|---|
| (dollars in millions, except per share amounts) | 2023 | 2022 | ||||
| Net sales | $ | 21,376.0 | $ | 23,748.7 | ||
| Gross profit | 4,652.4 | 4,686.6 | ||||
| Operating income | 1,680.9 | 1,735.2 | ||||
| Net income | 1,104.3 | 1,114.5 | ||||
| Non-GAAP operating income | 2,039.1 | 2,050.5 | ||||
| Non-GAAP net income | 1,346.2 | 1,341.5 | ||||
| Net income per diluted share | 8.10 | 8.13 | ||||
| Non-GAAP net income per diluted share | 9.88 | 9.79 | ||||
| Average daily sales(1) | 84.2 | 93.5 | ||||
| Net debt(2) | 5,056.2 | 5,607.5 | ||||
| Cash conversion cycle (in days)(3) | 17 | 21 | ||||
| Cash provided by operating activities | 1,598.7 | 1,335.9 | ||||
| Adjusted free cash flow(4) | 1,426.8 | 1,292.7 |
(1)There were 254 selling days for both the years ended December 31, 2023 and 2022. Average Daily Sales is defined as Net sales divided by the number of selling days.
(2)Defined as Total debt minus Cash and cash equivalents.
(3)Defined as days of sales outstanding in Accounts receivable and certain receivables due from vendors plus days of supply in Merchandise inventory minus days of purchases outstanding in Accounts payable and Accounts payable-inventory financing, based on a rolling three-month average.
(4)Defined as Cash flows provided by operating activities less capital expenditures, adjusted to include cash flows from financing activities that relate to the purchase of inventory.
Results of Operations
Results of operations, in dollars and as a percentage of Net sales are as follows:
| Year Ended December 31, | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2023 | 2022 | |||||||||||||
| Dollars in Millions | Percentage of Net Sales | Dollars in Millions | Percentage of Net Sales | |||||||||||
| Net sales | $ | 21,376.0 | 100.0 | % | $ | 23,748.7 | 100.0 | % | ||||||
| Cost of sales | 16,723.6 | 78.2 | 19,062.1 | 80.3 | ||||||||||
| Gross profit | 4,652.4 | 21.8 | 4,686.6 | 19.7 | ||||||||||
| Selling and administrative expenses | 2,971.5 | 13.9 | 2,951.4 | 12.4 | ||||||||||
| Operating income | 1,680.9 | 7.9 | 1,735.2 | 7.3 | ||||||||||
| Interest expense, net | (226.6) | (1.1) | (235.7) | (1.0) | ||||||||||
| Other expense, net | (4.1) | — | (11.7) | — | ||||||||||
| Income before income taxes | 1,450.2 | 6.8 | 1,487.8 | 6.3 | ||||||||||
| Income tax expense | (345.9) | (1.6) | (373.3) | (1.6) | ||||||||||
| Net income | $ | 1,104.3 | 5.2 | % | $ | 1,114.5 | 4.7 | % |
Net sales
Net sales decreased $2,373 million, or 10.0%, to $21,376 million for the year ended December 31, 2023, compared to $23,749 million for the year ended December 31, 2022. The decline in Net sales occurred across all operating segments. Continued economic uncertainty has led customers to focus their business priorities, resulting in a reduction or delay in their hardware spend. For additional information, see the “Segment Results of Operations” below.
27
Table of Contents
Gross profit
Gross profit decreased $34 million, or 0.7%, to $4,652 million for the year ended December 31, 2023, compared to $4,687 million for the year ended December 31, 2022. As a percentage of Net sales, Gross profit margin increased 210 basis points to 21.8% for the year ended December 31, 2023. The increase in Gross profit margin was primarily driven by a more favorable contribution of netted down revenue, primarily software as a service, and higher product margin due to lower mix in notebooks and increased margin rate across various categories.
Selling and administrative expenses
Selling and administrative expenses increased $20 million, or 0.7%, to $2,972 million for the year ended December 31, 2023, compared to $2,951 million for the year ended December 31, 2022. The increase was driven by costs related to the reduction of our workforce and real estate portfolio (collectively “workplace optimization”) and increased payroll expenses associated with higher year-over-year average coworker count, partially offset by reduced discretionary expenses.
Operating income
Operating income decreased $54 million, or 3.1%, to $1,681 million for the year ended December 31, 2023, compared to $1,735 million for the year ended December 31, 2022.
Interest expense, net
Interest expense, net includes interest expense and interest income. Interest expense, net decreased $9 million, or 3.9%, to $227 million for the year ended December 31, 2023, compared to $236 million for the year ended December 31, 2022. This decrease is primarily due to lower debt levels and higher interest income earned on cash balances, partially offset by higher variable interest rate on the senior unsecured term loan.
Income tax expense
Income tax expense was $346 million for the year ended December 31, 2023, compared to $373 million for the year ended December 31, 2022. The effective income tax rate, expressed by calculating income tax expense as a percentage of Income before income taxes, was 23.9% and 25.1% for 2023 and 2022, respectively.
The lower effective tax rate for the year ended December 31, 2023 as compared to the prior year was primarily attributable to higher excess tax benefits on equity-based compensation.
Segment Results of Operations
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 are as follows:
| Year Ended December 31, | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2023 | 2022 | ||||||||||||||||||||
| (dollars in millions) | Net Sales | Percentage of Total Net Sales | Net Sales | Percentage of Total Net Sales | Dollar Change | Percent Change(1) | |||||||||||||||
| Corporate | $ | 8,960.8 | 41.9 | % | $ | 10,350.1 | 43.6 | % | $ | (1,389.3) | (13.4) | % | |||||||||
| Small Business | 1,556.0 | 7.3 | 1,938.9 | 8.2 | (382.9) | (19.7) | |||||||||||||||
| Public: | |||||||||||||||||||||
| Government | 2,669.1 | 12.5 | 2,574.3 | 10.8 | 94.8 | 3.7 | |||||||||||||||
| Education | 3,298.3 | 15.4 | 3,621.4 | 15.2 | (323.1) | (8.9) | |||||||||||||||
| Healthcare | 2,338.3 | 10.9 | 2,355.6 | 9.9 | (17.3) | (0.7) | |||||||||||||||
| Total Public | 8,305.7 | 38.8 | 8,551.3 | 35.9 | (245.6) | (2.9) | |||||||||||||||
| Other | 2,553.5 | 12.0 | 2,908.4 | 12.3 | (354.9) | (12.2) | |||||||||||||||
| Total Net sales | $ | 21,376.0 | 100.0 | % | $ | 23,748.7 | 100.0 | % | $ | (2,372.7) | (10.0) | % |
(1)There were 254 selling days for both the years ended December 31, 2023 and 2022. Average daily sales is defined as Net sales divided by the number of selling days.
28
Table of Contents
Operating income by segment, in dollars and as a percentage of Net sales, and the year-over-year percentage change was as follows:
| Year Ended December 31, | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2023 | 2022 | ||||||||||||||||
| (dollars in millions) | Operating Income | Operating Income Margin | Operating Income | Operating Income Margin | Percent Change in Operating Income | ||||||||||||
| Segments:(1) | |||||||||||||||||
| Corporate | $ | 846.8 | 9.5 | % | $ | 931.7 | 9.0 | % | (9.1) | % | |||||||
| Small Business | 177.3 | 11.4 | 186.8 | 9.6 | (5.1) | ||||||||||||
| Public | 735.0 | 8.8 | 681.7 | 8.0 | 7.8 | ||||||||||||
| Other(2) | 142.1 | 5.6 | 130.7 | 4.5 | 8.7 | ||||||||||||
| Headquarters(3) | (220.3) | nm* | (195.7) | nm* | 12.6 | ||||||||||||
| Total Operating income | $ | 1,680.9 | 7.9 | % | $ | 1,735.2 | 7.3 | % | (3.1) | % |
*nm - Not meaningful
(1)Segment operating income includes the segment’s direct operating income, allocations for certain Headquarters’ costs, allocations for income and expenses from logistics services, certain inventory adjustments and volume rebates and cooperative advertising from vendors.
(2)Includes the financial results for our other operating segments, CDW UK and CDW Canada, which do not meet the reportable segment quantitative thresholds.
(3)Includes Headquarters’ function costs that are not allocated to the segments.
Corporate
Corporate segment Net sales for the year ended December 31, 2023 decreased $1,389 million, or 13.4%, compared to the year ended December 31, 2022. This decrease in Net sales was across various hardware categories and services, partially offset by increases in netcomm products.
Corporate segment Operating income was $847 million for the year ended December 31, 2023, a decrease of $85 million, or 9.1%, compared to $932 million for the year ended December 31, 2022. Corporate segment Operating income decreased primarily due to lower Gross profit dollars and increased payroll expenses, partially offset by reduced discretionary spend.
Small Business
Small Business segment Net sales for the year ended December 31, 2023 decreased $383 million, or 19.7%, compared to the year ended December 31, 2022. This decrease was across various categories primarily within notebooks/mobile devices.
Small Business segment Operating income was $177 million for the year ended December 31, 2023, a decrease of $10 million, or 5.1%, compared to $187 million for the year ended December 31, 2022. Small Business segment Operating income decreased primarily due to lower Gross profit dollars, partially offset by lower payroll expenses and reduced discretionary spend.
Public
Public segment Net sales for the year ended December 31, 2023 decreased $246 million, or 2.9%, compared to the year ended December 31, 2022. This decrease was across various categories, primarily notebooks/mobile devices and collaboration hardware within Education, partially offset by netcomm products and software across all sales channels.
Public segment Operating income was $735 million for the year ended December 31, 2023, an increase of $53 million, or 7.8%, compared to $682 million for the year ended December 31, 2022. Public segment Operating income increased primarily due to lower payroll expenses, higher Gross profit dollars and reduced discretionary spend.
Other
Net sales in Other, which is comprised of results from our UK and Canadian operations, for the year ended December 31, 2023 decreased $355 million, or 12.2%, compared to the year ended December 31, 2022. This decrease was driven by various hardware categories, primarily within notebooks/mobile devices, partially offset by an increase in netcomm products and software related to both the Canadian and UK operations.
29
Table of Contents
Other Operating income was $142 million for the year ended December 31, 2023, an increase of $11 million, or 8.7%, compared to $131 million for the year ended December 31, 2022. Other Operating income increased primarily due to higher Gross profit dollars related to the UK operations, partially offset by lower Gross profit dollars related to the Canadian operations.
Non-GAAP Financial Measure Reconciliations
We have included reconciliations of Non-GAAP operating income, Non-GAAP operating income margin, Non-GAAP net income, Non-GAAP net income per diluted share, Net sales on a constant currency basis, Free cash flow and Adjusted free cash flow for the years ended December 31, 2023 and 2022 below.
Non-GAAP operating income excludes, among other things, charges related to the amortization of acquisition-related intangible assets, equity-based compensation and the associated payroll taxes, acquisition and integration expenses, transformation initiatives and workplace optimization. Non-GAAP operating income margin is defined as Non-GAAP operating income as a percentage of Net sales. Non-GAAP net income excludes, among other things, charges related to acquisition-related intangible asset amortization, equity-based compensation, acquisition and integration expenses, transformation initiatives, workplace optimization and the associated tax effects of each. Net sales on a constant currency basis is defined as Net sales excluding the impact of foreign currency translation on Net sales compared to the prior period. Free cash flow is defined as cash flows provided by operating activities less capital expenditures. Adjusted free cash flow is defined as Free cash flow adjusted to include certain cash flows from financing activities incurred in the normal course of operations or as capital expenditures.
Non-GAAP operating income, Non-GAAP operating income margin, Non-GAAP net income, Non-GAAP net income per diluted share, Net sales on a constant currency basis, Free cash flow and Adjusted free cash flow are considered non-GAAP financial measures. Generally, a non-GAAP financial measure is a numerical measure of a company’s performance or financial condition 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 US GAAP. Non-GAAP measures used by management may differ from similar measures used by other companies, even when similar terms are used to identify such measures.
We believe Non-GAAP operating income, Non-GAAP operating income margin, Non-GAAP net income, Non-GAAP net income per diluted share and Net sales on a constant currency basis provide analysts, investors and management with useful information regarding the underlying operating performance of our business, as they remove the impact of items that management believes are not reflective of underlying operating performance. Management uses these measures to evaluate period-over-period performance as management believes they provide a more comparable measure of the underlying business. We also present Free cash flow and Adjusted free cash flow as we believe these measures provide more information regarding our liquidity and capital resources. Certain non-GAAP financial measures are also used to determine certain components of performance-based compensation.
Non-GAAP operating income and Non-GAAP operating income margin
| Year Ended December 31, | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| (dollars in millions) | 2023 | % of Net Sales | 2022 | % of Net Sales | % Change | |||||||||||
| Operating income, as reported | $ | 1,680.9 | 7.9 | % | $ | 1,735.2 | 7.3 | % | (3.1) | % | ||||||
| Amortization of intangibles(1) | 154.4 | 167.9 | ||||||||||||||
| Equity-based compensation | 93.7 | 91.1 | ||||||||||||||
| Acquisition and integration expenses | 30.0 | 48.3 | ||||||||||||||
| Transformation initiatives (2) | 27.1 | 6.3 | ||||||||||||||
| Workplace optimization(3) | 47.7 | — | ||||||||||||||
| Other adjustments | 5.3 | 1.7 | ||||||||||||||
| Non-GAAP operating income | $ | 2,039.1 | 9.5 | % | $ | 2,050.5 | 8.6 | % | (0.6) | % |
(1)Includes amortization expense for acquisition-related intangible assets, primarily customer relationships, customer contracts and trade names.
(2)Includes costs related to strategic transformation initiatives focused on optimizing various operations and systems.
(3)Includes costs related to the workforce reduction program and charges related to the reduction of our real estate lease portfolio.
30
Table of Contents
Non-GAAP net income and Non-GAAP net income per diluted share
| Year Ended December 31, 2023 | Year Ended December 31, 2022 | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| (dollars in millions) | Income before income taxes | Income taxexpense(1) | Net income | Income before income taxes | Income taxexpense(1) | Net income | Net Income % Change | ||||||||||||||||||||||
| US GAAP, as reported | $ | 1,450.2 | $ | (345.9) | $ | 1,104.3 | $ | 1,487.8 | $ | (373.3) | $ | 1,114.5 | (0.9) | % | |||||||||||||||
| Amortization of intangibles(2) | 154.4 | (40.2) | 114.2 | 167.9 | (44.6) | 123.3 | |||||||||||||||||||||||
| Equity-based compensation | 93.7 | (47.6) | 46.1 | 91.1 | (30.4) | 60.7 | |||||||||||||||||||||||
| Acquisition and integration expenses | 30.0 | (7.8) | 22.2 | 48.3 | (12.4) | 35.9 | |||||||||||||||||||||||
| Transformation initiatives(3) | 27.1 | (7.1) | 20.0 | 6.3 | (1.6) | 4.7 | |||||||||||||||||||||||
| Workplace optimization(4) | 47.7 | (12.4) | 35.3 | — | — | — | |||||||||||||||||||||||
| Net loss on extinguishment of long-term debt | — | — | — | 1.6 | (0.4) | 1.2 | |||||||||||||||||||||||
| Other adjustments | 5.3 | (1.2) | 4.1 | 1.7 | (0.5) | 1.2 | |||||||||||||||||||||||
| Non-GAAP | $ | 1,808.4 | $ | (462.2) | $ | 1,346.2 | $ | 1,804.7 | $ | (463.2) | $ | 1,341.5 | 0.4 | % | |||||||||||||||
| Net income per diluted share, as reported | $ | 8.10 | $ | 8.13 | |||||||||||||||||||||||||
| Non-GAAP net income per diluted share | $ | 9.88 | $ | 9.79 | |||||||||||||||||||||||||
| Shares used in computing US GAAP and Non-GAAP net income per diluted share | 136.3 | 137.0 |
(1)Income tax on non-GAAP adjustments includes excess tax benefits associated with equity-based compensation.
(2)Includes amortization expense for acquisition-related intangible assets, primarily customer relationships, customer contracts and trade names.
(3)Includes cost related to strategic transformation initiatives focused on optimizing various operations and systems.
(4)Includes costs related to the workforce reduction program and charges related to the reduction of our real estate lease portfolio.
Net sales on a constant currency basis
| Year Ended December 31, | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| (dollars in millions) | 2023 | 2022 | % Change(1) | ||||||||
| Net sales, as reported | $ | 21,376.0 | $ | 23,748.7 | (10.0) | % | |||||
| Foreign currency translation(2) | — | (28.2) | |||||||||
| Net sales, on a constant currency basis | $ | 21,376.0 | $ | 23,720.5 | (9.9) | % |
(1)There were 254 selling days for both the years ended December 31, 2023 and 2022. Average daily sales is defined as Net sales divided by the number of selling days.
(2)Represents the effect of translating Net sales for the year ended December 31, 2022 of CDW UK and CDW Canada at the average exchange rates applicable in 2023.
Free cash flow and Adjusted free cash flow
| Year Ended December 31, | |||||||
|---|---|---|---|---|---|---|---|
| (dollars in millions) | 2023 | 2022 | |||||
| Net cash provided by operating activities | $ | 1,598.7 | $ | 1,335.9 | |||
| Capital expenditures | (148.2) | (127.8) | |||||
| Free cash flow | 1,450.5 | 1,208.1 | |||||
| Net change in accounts payable - inventory financing | (23.7) | 84.6 | |||||
| Adjusted free cash flow(1) | $ | 1,426.8 | $ | 1,292.7 |
(1)Defined as Cash flows provided by operating activities less capital expenditures, adjusted to include cash flows from financing activities that relate to the purchase of inventory.
31
Table of Contents
Seasonality
While we have not historically experienced significant seasonality throughout the year, sales in our Corporate segment, which primarily serves US private sector business customers with more than 250 employees, have historically been 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. Since 2020, we have experienced variability compared to historic seasonality trends. Seasonality by channel is expected to continue to be different than historical experience.
Liquidity and Capital Resources
Overview
We finance our operations and capital expenditures with cash from operations and borrowings under our revolving loan facility. As of December 31, 2023, we had $1.2 billion of availability for borrowings under our revolving loan facility. Our liquidity and borrowing plans are established to align with our financial and strategic planning processes and ensure we have the necessary funding to meet our operating commitments, which primarily include the purchase of inventory, payroll and general expenses. We also take into consideration our overall capital allocation strategy, which includes dividend payments, assessment of debt levels, acquisitions and share repurchases. We believe we have adequate sources of liquidity and funding available for at least the next year; 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, general economic conditions and working capital management.
Our material contractual obligations consist of debt and related interest payments and operating leases. See Note 9 (Debt) and Note 11 (Leases) to the accompanying Consolidated Financial Statements for additional information regarding future maturities of debt and operating leases.
Long-Term Debt and Financing Arrangements
During the year ended December 31, 2023, we prepaid $150 million on our senior unsecured term loan facility without penalty. No additional mandatory payments are required on the remaining principal amount until its maturity date on December 1, 2026.
As of December 31, 2023, we had total unsecured indebtedness of $5.6 billion and we were in compliance with the covenants under our credit agreements and indentures.
We may from time to time repurchase one or more series of our outstanding unsecured senior notes, depending on market conditions, contractual commitments, our capital needs and other factors. Repurchases of our senior notes may be made by open market or private transactions and may be pursuant to Rule 10b5-1 plans or otherwise.
For additional information regarding our debt and refinancing activities, see Note 9 (Debt) to the accompanying Consolidated Financial Statements.
Inventory Financing Agreements
We have entered into agreements with certain financial intermediaries to facilitate the purchase of inventory from various suppliers under certain terms and conditions. These amounts are classified separately as Accounts payable-inventory financing on the Consolidated Balance Sheets. We do not incur any interest expense associated with these agreements as balances are paid when they are due. For additional information, see Note 7 (Inventory Financing Agreements) to the accompanying Consolidated Financial Statements.
Share Repurchase Program
During 2023, we repurchased 2.6 million shares of our common stock for $500 million under the previously announced share repurchase program. For additional information about our share repurchase program, refer to Note 12 (Stockholders’ Equity) to the accompanying Consolidated Financial Statements.
32
Table of Contents
Dividends
A summary of 2023 dividend activity for our common stock is as follows:
| Dividend Amount | Declaration Date | Record Date | Payment Date | |||||
|---|---|---|---|---|---|---|---|---|
| $ | 0.590 | February 7, 2023 | February 24, 2023 | March 10, 2023 | ||||
| 0.590 | May 3, 2023 | May 25, 2023 | June 13, 2023 | |||||
| 0.590 | August 2, 2023 | August 25, 2023 | September 12, 2023 | |||||
| 0.620 | November 1, 2023 | November 24, 2023 | December 12, 2023 | |||||
| $ | 2.390 |
On February 7, 2024, we announced that our Board of Directors declared a quarterly cash dividend on our common stock of $0.620 per share. The dividend will be paid on March 12, 2024 to all stockholders of record as of the close of business on February 26, 2024.
The payment of any future dividends will be at the discretion of our Board of Directors and will depend upon our results of operations, financial condition, business prospects, capital requirements, contractual restrictions (including in current or future agreements governing our indebtedness), restrictions imposed by applicable law, tax considerations and other factors that our Board of Directors deems relevant.
Cash Flows
Cash flows from operating, investing and financing activities are as follows:
| Year Ended December 31, | ||||||
|---|---|---|---|---|---|---|
| (dollars in millions) | 2023 | 2022 | ||||
| Net cash provided by (used in): | ||||||
| Operating Activities | $ | 1,598.7 | $ | 1,335.9 | ||
| Investing Activities | ||||||
| Capital expenditures | (148.2) | (127.8) | ||||
| Acquisitions of businesses, net of cash acquired | (76.4) | (36.7) | ||||
| Other | (5.0) | — | ||||
| Cash flows used in investing activities | (229.6) | (164.5) | ||||
| Financing Activities | ||||||
| Net change in accounts payable - inventory financing | (23.7) | 84.6 | ||||
| Other cash flows from financing activities | (1,075.0) | (1,186.7) | ||||
| Cash flows used in financing activities | (1,098.7) | (1,102.1) | ||||
| Effect of exchange rate changes on cash and cash equivalents | 3.1 | (12.2) | ||||
| Net increase in cash and cash equivalents | $ | 273.5 | $ | 57.1 |
33
Table of Contents
Operating Activities
Cash flows from operating activities are as follows:
| Year Ended December 31, | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| (dollars in millions) | 2023 | 2022 | Change | |||||||
| Net income | $ | 1,104.3 | $ | 1,114.5 | $ | (10.2) | ||||
| Adjustments for the impact of non-cash items(1) | 375.6 | 388.0 | (12.4) | |||||||
| Net income adjusted for the impact of non-cash items | 1,479.9 | 1,502.5 | (22.6) | |||||||
| Changes in assets and liabilities: | ||||||||||
| Accounts receivable(2) | (54.5) | (34.8) | (19.7) | |||||||
| Merchandise inventory | 139.0 | 111.9 | 27.1 | |||||||
| Accounts payable-trade(3) | (55.4) | (260.0) | 204.6 | |||||||
| Other(4) | 89.7 | 16.3 | 73.4 | |||||||
| Net cash provided by operating activities | $ | 1,598.7 | $ | 1,335.9 | $ | 262.8 |
(1)Includes items such as depreciation and amortization, deferred income taxes, provision for credit losses and equity-based compensation expense.
(2)The change is primarily due to higher sales activity during the fourth quarter 2023, partially offset by collection performance.
(3)The change is primarily due to higher sales activity during the fourth quarter 2023 and timing of payments.
(4)The change is primarily due to lower contract assets and vendor receivables, partially offset by decreased accrued compensation and lower contract liabilities in 2023.
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 minus days of purchases outstanding in accounts payable, based on a rolling three-month average. Components of our cash conversion cycle are as follows:
| December 31, | ||||
|---|---|---|---|---|
| (in days) | 2023 | 2022 | ||
| Days of sales outstanding (DSO)(1) | 77 | 71 | ||
| Days of supply in inventory (DIO)(2) | 13 | 17 | ||
| Days of purchases outstanding (DPO)(3) | (73) | (67) | ||
| Cash conversion cycle | 17 | 21 |
(1)Represents the rolling three-month average of the balance of Accounts receivable, net at the end of the period, divided by average daily Net sales for the same three-month period. Also incorporates components of other miscellaneous receivables.
(2)Represents the rolling three-month average of the balance of Merchandise inventory at the end of the period divided by average daily Cost of sales for the same three-month period.
(3)Represents the rolling three-month average of the combined balance of Accounts payable-trade, excluding cash overdrafts, and Accounts payable-inventory financing at the end of the period divided by average daily Cost of sales for the same three-month period.
The cash conversion cycle decreased to 17 days at December 31, 2023, compared to 21 days at December 31, 2022. The overall decrease was primarily driven by a reduction in DIO resulting from lower stocking positions. In addition, netted down revenue has an unfavorable impact to DSO and a favorable impact to DPO as the corresponding receivables and payables reflect the gross amounts due from customers and due to vendors while the corresponding sales and cost of sales are reflected on a net basis within Net sales.
Investing Activities
Net cash used in investing activities increased $65 million in 2023 compared to 2022. This increase was primarily due to higher acquisition activity in 2023 and increased capital expenditures.
Financing Activities
Net cash used in financing activities decreased $3 million in 2023 compared to 2022. The decrease was primarily driven by lower repayments on long-term debt, partially offset by share repurchases in 2023 with no similar activity in 2022, decreased activity within our inventory financing arrangements and increased dividend payments. For additional information regarding the inventory financing and debt activities, see Note 7 (Inventory Financing Agreements) and Note 9 (Debt) to the accompanying Consolidated Financial Statements.
34
Table of Contents
Off-Balance Sheet Arrangements
We have no off-balance sheet arrangements that have or are reasonably likely to have a material current or future effect on our financial condition, results of operations or liquidity.
Issuers and Guarantors of Debt Securities
Each series of our outstanding unsecured senior notes (the “Notes”) are issued by CDW LLC and CDW Finance Corporation (the “Issuers”) and are guaranteed by CDW Corporation (“Parent”) and certain of CDW LLC’s direct and indirect, 100% owned, domestic subsidiaries (the “Guarantor Subsidiaries” and, together with Parent, the “Guarantors”). All guarantees by Parent and the Guarantors are joint and several, and full and unconditional; provided that guarantees by the Guarantor Subsidiaries are subject to certain customary release provisions contained in the indentures governing the Notes.
The Notes and the related guarantees are the Issuers’ and the Guarantors’ senior unsecured obligations and are:
•structurally subordinated to all existing and future indebtedness and other liabilities of our non-guarantor subsidiaries and
•rank equal in right of payment with all of the Issuers’ and the Guarantors’ existing and future unsecured senior debt.
The following tables set forth Balance Sheet information as of December 31, 2023 and December 31, 2022, and Statement of Operations information for the years ended December 31, 2023 and 2022 for the accounts of the Issuers and the accounts of the Guarantors (the “Obligor Group”). The financial information of the Obligor Group is presented on a combined basis and the intercompany balances and transactions between the Obligor Group have been eliminated.
Balance Sheet Information
| December 31, | ||||||
|---|---|---|---|---|---|---|
| (dollars in millions) | 2023 | 2022 | ||||
| Current assets | $ | 5,770.0 | $ | 5,588.3 | ||
| Goodwill | 3,939.7 | 3,939.7 | ||||
| Other assets | 1,978.4 | 2,032.6 | ||||
| Total Non-current assets | 5,918.1 | 5,972.3 | ||||
| Current liabilities | 4,975.4 | 4,369.3 | ||||
| Long-term debt | 5,031.4 | 5,792.9 | ||||
| Other liabilities | 697.7 | 641.9 | ||||
| Total Long-term liabilities | 5,729.1 | 6,434.8 |
Statements of Operations Information
| Year Ended December 31, | ||||||
|---|---|---|---|---|---|---|
| (dollars in millions) | 2023 | 2022 | ||||
| Net sales | $ | 18,759.4 | $ | 20,741.8 | ||
| Gross profit | 4,106.4 | 4,156.6 | ||||
| Operating income | 1,507.3 | 1,584.7 | ||||
| Net income | 945.6 | 1,005.8 |
Commitments and Contingencies
The information set forth in Note 16 (Commitments and Contingencies) to the accompanying Consolidated Financial Statements included in Part II, Item 8 of this report is incorporated herein by reference.
35
Table of Contents
Critical Accounting Policies and Estimates
The preparation of the Consolidated Financial Statements in accordance with US GAAP requires management to make use of certain estimates and assumptions that affect the reported amounts of assets, liabilities, revenues and expenses, as well as related disclosure of contingent assets and liabilities in the Consolidated Financial Statements and accompanying notes. We base our estimates on historical experience and on various other assumptions that we believe are reasonable under the circumstances. Historically, we have not made significant changes to the methods for determining these estimates as our actual results have not differed materially from our estimates. We do not believe it is reasonably likely that the estimates and related assumptions will change materially in the foreseeable future; however, actual results could differ from those estimates under different assumptions, judgments or conditions.
Critical accounting policies and estimates are those that are most important to the portrayal of our financial condition and results of operations, and which require us to make our most difficult and subjective judgments, often as a result of the need to make estimates of matters that are inherently uncertain. Based on this definition, we have identified the critical accounting policies and estimates addressed below. For additional information related to significant accounting policies used in the preparation of our Consolidated Financial Statements, see Note 1 (Description of Business and Summary of Significant Accounting Policies) to the accompanying Consolidated Financial Statements included in Part II, Item 8 of this report.
Revenue Recognition
We sell some of our products and services as part of bundled contract arrangements containing multiple performance obligations, which may include a combination of different products and services. Significant judgment may be required when determining whether products and services are considered distinct performance obligations that should be accounted for separately versus together.
For contracts consisting of multiple performance obligations, the total transaction price is allocated to each performance obligation based upon its standalone selling price. Judgment is required to determine the standalone selling price for each distinct performance obligation. For certain types of performance obligations, we use a combination of methods to estimate the standalone selling price based on recent transactions. When evidence from recent transactions is not available to confirm that the prices are representative of the standalone selling price, an expected cost plus margin approach is used.
Additional judgment is required in determining whether we are the principal, and report revenues on a gross basis, or agent, and report revenues on a net basis. For each identified performance obligation in a transaction, we evaluate the facts and circumstances present to determine whether or not we control the specified good or service prior to transfer to the customer. This evaluation includes, but is not limited to, assessing indicators such as whether: (i) we are primarily responsible for fulfilling the promise to provide the specified goods or service, (ii) we have inventory risk before the specified good or service has been transferred to a customer and (iii) we have discretion in establishing the price for the specified good or service. When the evaluation indicates we control the specified good or service prior to transfer to the customer, we are acting as a principal. When the evaluation indicates we do not control the specified good or service prior transfer to the customer, we are acting as an agent.
The nature of our contracts give rise to variable consideration, primarily in the form of volume rebates and sales returns and allowances. We estimate variable consideration at the most likely amount to which we expect to be entitled. The estimates of variable consideration and determination of whether to include estimated amounts in the transaction price are based on an assessment of our anticipated performance and all information that is reasonably available.
We recognize revenue from performance obligations when, or as, the customer obtains control over the specified good or service. That is, when the customer has the ability to direct the use of and obtain substantially all of the benefits from the good or service. For the sale of hardware and software, this is generally upon delivery to the customer. As a result, we perform an analysis to estimate the amount of Net sales in-transit at the end of the period and adjust revenue and the related costs to reflect only what has been delivered to the customer. This analysis requires judgment whereby we perform an analysis of the estimated number of days of sales in-transit to customers at the end of each reporting period based on a weighted-average analysis of commercial delivery terms that include drop-shipment arrangements. Changes in delivery patterns may result in a different number of business days estimated to make this adjustment. For the sale of professional services, we recognize the revenue over time given that our customers simultaneously receive and consume the benefits from these services as they are performed. Revenues from professional services are primarily recognized using an input method, which requires management to make estimates regarding the amount of resources required for each engagement in order to satisfy the performance obligation.
36
Table of Contents
Goodwill
Goodwill is allocated to reporting units expected to benefit from the business combination. Goodwill is subject to periodic testing for impairment at the reporting unit level on an annual basis during the fourth quarter, or more frequently if events or changes in circumstances indicate that the asset may be impaired. These events or circumstances could include a significant change in the business climate, legal factors, operating performance indicators, competition or sale or disposition of a significant portion of a reporting unit.
We may elect to utilize a qualitative assessment to determine whether it is more likely than not that the fair value of a reporting unit is less than its carrying value. As part of our qualitative assessment, judgment is required in weighing the effect of various positive and negative factors that may affect the fair value. We consider various factors, including the excess of fair value over carrying value from the last quantitative test, macroeconomic conditions, industry and market considerations, the projected financial performance and actual financial performance compared to prior year projected financial performance.
If we elect to bypass the qualitative assessment, or if indicators of impairment exist, a quantitative impairment test is performed. As part of the quantitative assessment, application of the goodwill impairment test requires judgment, including the identification of reporting units, assignment of assets and liabilities to reporting units and determination of the fair value of each reporting unit. Fair value of a reporting unit is determined by using a weighted combination of an income approach and a market approach, as this combination is considered the most indicative of our fair value in an orderly transaction between market participants. This analysis requires significant judgments, including estimation of future cash flows, which is dependent on internal forecasts, estimation of the long-term rate of growth for our business, estimation of the useful life over which cash flows will occur, determination of our weighted average cost of capital, future market conditions and profitability of future business strategies. The estimates used to calculate the fair value of a reporting unit change from year to year based on operating results, market conditions and other factors. Changes in these estimates and assumptions could materially affect the determination of fair value and goodwill impairment for each reporting unit. However, our past estimates of fair value would not have indicated an impairment when revised to include subsequent years’ actual results.
We completed our annual impairment analysis during the fourth quarter of 2023. We performed a quantitative analysis for all reporting units and determined that the fair values of each reporting unit substantially exceeded their carrying values and, therefore, no impairment existed.
Business combinations
We allocate purchase price consideration to the assets acquired and liabilities assumed based on their fair values as of the acquisition date. Determining the fair value of these assets and liabilities requires the use of significant estimates, particularly in valuing acquired intangible assets and Goodwill.
Purchased intangible assets other than goodwill are initially recognized at fair value and amortized over their useful lives. We determine the fair value of purchased intangible assets using an income approach on an individual asset basis. The fair value measurements were primarily based on significant inputs that are not observable, which are categorized as a Level 3 measurement in the fair value hierarchy. The values assigned to consideration transferred, assets acquired and liabilities assumed may be adjusted during the measurement period as new information arises that existed as of the acquisition date.
We use the multi-period excess earnings method to determine the fair value of customer relationships. This method identifies the portion of revenue expected to be generated through repeat customers existing as of the valuation date and includes an attrition rate to account for the loss of customers over time. Critical estimates utilized in valuing customer relationships include estimated forecasted future revenue and EBITDA margin growth rates, customer attrition rates and market-participant discount rates. The assumptions we apply in forecasting future revenue and customer attrition rates is based on analysis of historical data, assessment of current and anticipated market conditions, estimated growth rates, and management plans.
Recent Accounting Pronouncements
The information set forth in Note 2 (Recent Accounting Pronouncements) to the accompanying Consolidated Financial Statements included in Part II, Item 8 of this report is incorporated herein by reference.