filings.toolsItem 8. Financial Statements and Supplementary Data
166K characters. Original on sec.gov · Markdown
Item 8. Financial Statements and Supplementary Data
Index to Consolidated Financial Statements
Report of Independent Registered Public Accounting Firm
To the Stockholders and the Board of Directors of CDW Corporation
Opinion on the Financial Statements
We have audited the accompanying consolidated balance sheets of CDW Corporation and subsidiaries (the Company) as of December 31, 2022 and 2021, the related consolidated statements of operations, comprehensive income, stockholders’ equity, and cash flows for each of the three years in the period ended December 31, 2022, and the related notes (collectively referred to as the “consolidated financial statements”). In our opinion, the consolidated financial statements present fairly, in all material respects, the financial position of the Company at December 31, 2022 and 2021, and the results of its operations and its cash flows for each of the three years in the period ended December 31, 2022, in conformity with U.S. generally accepted accounting principles.
We also have audited, in accordance with the standards of the Public Company Accounting Oversight Board (United States) (PCAOB), the Company’s internal control over financial reporting as of December 31, 2022, based on criteria established in Internal Control-Integrated Framework issued by the Committee of Sponsoring Organizations of the Treadway Commission (2013 framework) and our report dated February 24, 2023 expressed an unqualified opinion thereon.
Basis for Opinion
These financial statements are the responsibility of the Company’s management. Our responsibility is to express an opinion on the Company’s financial statements based on our audits. We are a public accounting firm registered with the PCAOB and are required to be independent with respect to the Company in accordance with the U.S. federal securities laws and the applicable rules and regulations of the Securities and Exchange Commission and the PCAOB.
We conducted our audits in accordance with the standards of the PCAOB. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the financial statements are free of material misstatement, whether due to error or fraud. Our audits included performing procedures to assess the risks of material misstatement of the financial statements, whether due to error or fraud, and performing procedures that respond to those risks. Such procedures included examining, on a test basis, evidence regarding the amounts and disclosures in the financial statements. Our audits also included evaluating the accounting principles used and significant estimates made by management, as well as evaluating the overall presentation of the financial statements. We believe that our audits provide a reasonable basis for our opinion.
Critical Audit Matters
The critical audit matters communicated below are matters arising from the current period audit of the financial statements that were communicated or required to be communicated to the audit committee and that: (1) relate to accounts or disclosures that are material to the financial statements and (2) involved our especially challenging, subjective or complex judgments. The communication of critical audit matters does not alter in any way our opinion on the consolidated financial statements, taken as a whole, and we are not, by communicating the critical audit matters below, providing separate opinions on the critical audit matters or on the accounts or disclosures to which they relate.
| Revenue recognition | ||||||||
| Description of the Matter | As described in Note 1 to the consolidated financial statements, the Company recognizes revenue upon transfer of control of promised products or services to customers when acting as a principal and upon arranging for the third party to provide the product or service, when acting as an agent. The Company applies judgment in determining whether it is the principal and reports revenue on a gross basis, or an agent and reports revenue on a net basis. The Company also sells some of its products and services as part of bundled contract arrangements containing multiple performance obligations. 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 each distinct performance obligation, judgment is required to determine the relative standalone selling price to allocate the transaction price, such as using an expected cost plus margin approach. Auditing the Company’s contracts with customers was challenging given the significant audit effort required to analyze the Company’s various products, services and contract arrangements. For example, certain customer contracts may contain multiple parties and there can be subjective judgment in assessing the Company’s role as principal or agent in the contract arrangement. For certain other customer contracts, there can be judgment in the identification of the distinct performance obligations along with the determination of the associated relative standalone selling prices. | |||||||
| How We Addressed the Matter in Our Audit | We obtained an understanding of the revenue process, evaluated the design and tested the operating effectiveness of the Company’s internal controls over the relevant terms of the customer contracts, including the determination of principal versus agent, the identification of distinct performance obligations and the determination of the relative standalone selling price for separate performance obligations. To test revenue recognition, our audit procedures included among others, examination of executed customer contracts for a sample of sales transactions, and evaluating the Company’s determination of principal versus agent, identifying products and services in the contract and assessing separate distinct performance obligations. To test management’s determination of relative standalone selling price for separate performance obligations, we performed audit procedures that included, among others, assessing the appropriateness of the methodology applied, testing the mathematical accuracy of the underlying data and calculations and inspecting the underlying data information on a sample basis. | |||||||
| Accounting for the Acquisition of Sirius - Valuation of Intangible Assets |
| Description of the Matter | As described in Note 1 and Note 3 to the consolidated financial statements, the Company acquired Granite Parent, Inc. (also referred to as “Sirius”) for net consideration of $2,455 million during the year ended December 31, 2021. The transaction was accounted for as a business combination and the Company allocated $1,164 million of the purchase price to the fair value of identified intangible assets. Auditing the Company’s accounting for its acquisition of Sirius was complex due to the significant estimation uncertainty in the Company’s determination of the fair value of identified intangible assets of $1,164 million, which principally consisted of customer relationships of $1,140 million. The significant estimation uncertainty was primarily due to the sensitivity of the fair value of customer relationships to underlying assumptions about the future performance of the acquired business and the expectations of market participant synergies on which those assumptions were based. The Company used the income approach to measure customer relationships. The significant assumptions used to estimate the value of customer relationships included the long-term growth rate, customer attrition rate and discount rate. These significant assumptions are forward looking and could be affected by future economic and market conditions. | |||||||
| How We Addressed the Matter in Our Audit | We obtained an understanding of the Company’s process for accounting for the acquisition. We tested the design and operating effectiveness of the Company's controls over the estimation process supporting the recognition and measurement of customer relationships, including the measurement period adjustments. We also tested controls regarding management’s review of assumptions used in the valuation model. To test the fair value of the Company’s customer relationships, including measurement period adjustments, we performed, with the assistance of our valuation specialists, audit procedures that included evaluating the Company’s selection of the valuation methodology, significant assumptions used and completeness and accuracy of the underlying data. For example, we compared the significant assumptions to historical and current industry, market and economic trends. We also tested the underlying source information used and verified the mathematical accuracy of the calculations within the valuation model. |
| /s/ Ernst & Young LLP | ||
| We have served as the Company’s auditor since 2011. | ||
| Chicago, Illinois | ||
| February 24, 2023 |
CDW CORPORATION AND SUBSIDIARIES
CONSOLIDATED BALANCE SHEETS
(dollars and shares in millions, except per share amounts)
| December 31, | |||||||||||
| 2022 | 2021 | ||||||||||
| Assets | |||||||||||
| Current assets: | |||||||||||
| Cash and cash equivalents | $ | 315.2 | $ | 258.1 | |||||||
| Accounts receivable, net of allowance for credit losses of $25.7 and $20.4, respectively | 4,461.3 | 4,499.4 | |||||||||
| Merchandise inventory | 800.2 | 927.6 | |||||||||
| Miscellaneous receivables | 489.1 | 435.5 | |||||||||
| Prepaid expenses and other | 498.2 | 357.5 | |||||||||
| Total current assets | 6,564.0 | 6,478.1 | |||||||||
| Operating lease right-of-use assets | 149.2 | 155.6 | |||||||||
| Property and equipment, net | 188.8 | 195.8 | |||||||||
| Goodwill | 4,342.7 | 4,382.9 | |||||||||
| Other intangible assets, net | 1,490.7 | 1,628.1 | |||||||||
| Other assets | 396.1 | 358.9 | |||||||||
| Total Assets | $ | 13,131.5 | $ | 13,199.4 | |||||||
| Liabilities and Stockholders’ Equity | |||||||||||
| Current liabilities: | |||||||||||
| Accounts payable-trade | $ | 2,821.3 | $ | 3,114.2 | |||||||
| Accounts payable-inventory financing | 519.0 | 448.3 | |||||||||
| Current maturities of long-term debt | 56.3 | 102.7 | |||||||||
| Contract liabilities | 485.5 | 402.9 | |||||||||
| Accrued expenses and other current liabilities: | |||||||||||
| Compensation | 377.8 | 361.7 | |||||||||
| Advertising | 130.5 | 145.5 | |||||||||
| Sales and income taxes | 73.5 | 65.9 | |||||||||
| Other | 483.2 | 454.8 | |||||||||
| Total current liabilities | 4,947.1 | 5,096.0 | |||||||||
| Long-term liabilities: | |||||||||||
| Debt | 5,866.4 | 6,755.8 | |||||||||
| Deferred income taxes | 203.4 | 222.3 | |||||||||
| Operating lease liabilities | 175.2 | 184.2 | |||||||||
| Other liabilities | 336.1 | 235.4 | |||||||||
| Total long-term liabilities | 6,581.1 | 7,397.7 | |||||||||
| Commitments and contingencies (Note 16) | |||||||||||
| Stockholders’ equity: | |||||||||||
| Preferred stock, $0.01 par value, 100.0 shares authorized; no shares issued or outstanding for both periods | — | — | |||||||||
| Common stock, $0.01 par value, 1,000.0 shares authorized; 135.5 and 134.8 shares outstanding, respectively | 1.4 | 1.3 | |||||||||
| Paid-in capital | 3,518.1 | 3,369.5 | |||||||||
| Accumulated deficit | (1,763.8) | (2,570.7) | |||||||||
| Accumulated other comprehensive loss | (152.4) | (94.4) | |||||||||
| Total stockholders’ equity | 1,603.3 | 705.7 | |||||||||
| Total Liabilities and Stockholders’ Equity | $ | 13,131.5 | $ | 13,199.4 |
The accompanying notes are an integral part of the Consolidated Financial Statements.
CDW CORPORATION AND SUBSIDIARIES
CONSOLIDATED STATEMENTS OF OPERATIONS
(dollars and shares in millions, except per share amounts)
| Year Ended December 31, | |||||||||||||||||
| 2022 | 2021 | 2020 | |||||||||||||||
| Net sales | $ | 23,748.7 | $ | 20,820.8 | $ | 18,467.5 | |||||||||||
| Cost of sales | 19,062.1 | 17,252.3 | 15,257.4 | ||||||||||||||
| Gross profit | 4,686.6 | 3,568.5 | 3,210.1 | ||||||||||||||
| Selling and administrative expenses | 2,951.4 | 2,149.5 | 2,030.9 | ||||||||||||||
| Operating income | 1,735.2 | 1,419.0 | 1,179.2 | ||||||||||||||
| Interest expense, net | (235.7) | (150.9) | (154.9) | ||||||||||||||
| Other (expense) income, net | (11.7) | 29.7 | (22.0) | ||||||||||||||
| Income before income taxes | 1,487.8 | 1,297.8 | 1,002.3 | ||||||||||||||
| Income tax expense | (373.3) | (309.2) | (213.8) | ||||||||||||||
| Net income | $ | 1,114.5 | $ | 988.6 | $ | 788.5 | |||||||||||
| Net income per common share: | |||||||||||||||||
| Basic | $ | 8.24 | $ | 7.14 | $ | 5.53 | |||||||||||
| Diluted | $ | 8.13 | $ | 7.04 | $ | 5.45 | |||||||||||
| Weighted-average common shares outstanding: | |||||||||||||||||
| Basic | 135.2 | 138.5 | 142.6 | ||||||||||||||
| Diluted | 137.0 | 140.5 | 144.8 |
The accompanying notes are an integral part of the Consolidated Financial Statements.
CDW CORPORATION AND SUBSIDIARIES
CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME
(dollars in millions)
| Year Ended December 31, | ||||||||||||||||||||
| 2022 | 2021 | 2020 | ||||||||||||||||||
| Net income | $ | 1,114.5 | $ | 988.6 | $ | 788.5 | ||||||||||||||
| Other comprehensive income (loss): | ||||||||||||||||||||
| Unrealized loss from cash flow hedge, net of tax | (0.1) | — | (0.6) | |||||||||||||||||
| Reclassification of cash flow hedge to net income, net of tax | 3.6 | 2.5 | 6.0 | |||||||||||||||||
| Foreign currency translation, net of tax | (61.5) | (1.1) | 16.6 | |||||||||||||||||
| Other comprehensive (loss) income | (58.0) | 1.4 | 22.0 | |||||||||||||||||
| Comprehensive income | $ | 1,056.5 | $ | 990.0 | $ | 810.5 |
The accompanying notes are an integral part of the Consolidated Financial Statements.
CDW CORPORATION AND SUBSIDIARIES
CONSOLIDATED STATEMENTS OF CASH FLOWS
(dollars in millions)
| Year Ended December 31, | |||||||||||||||||
| 2022 | 2021 | 2020 | |||||||||||||||
| Cash flows from operating activities: | |||||||||||||||||
| Net income | $ | 1,114.5 | $ | 988.6 | $ | 788.5 | |||||||||||
| Adjustments to reconcile net income to net cash provided by operating activities: | |||||||||||||||||
| Depreciation and amortization | 290.6 | 191.2 | 425.6 | ||||||||||||||
| Equity-based compensation expense | 91.1 | 72.6 | 42.5 | ||||||||||||||
| Deferred income taxes | (18.2) | (6.7) | (20.2) | ||||||||||||||
| Provision for credit losses | 8.3 | (5.4) | 30.9 | ||||||||||||||
| Other | 16.2 | (24.1) | 42.1 | ||||||||||||||
| Changes in assets and liabilities: | |||||||||||||||||
| Accounts receivable | (34.8) | (616.8) | (226.4) | ||||||||||||||
| Merchandise inventory | 111.9 | (151.0) | (71.4) | ||||||||||||||
| Other assets | (208.9) | (134.8) | 18.6 | ||||||||||||||
| Accounts payable-trade | (260.0) | 374.5 | 253.7 | ||||||||||||||
| Other liabilities | 225.2 | 96.5 | 30.4 | ||||||||||||||
| Net cash provided by operating activities | 1,335.9 | 784.6 | 1,314.3 | ||||||||||||||
| Cash flows from investing activities: | |||||||||||||||||
| Capital expenditures | (127.8) | (100.0) | (158.0) | ||||||||||||||
| Acquisitions of businesses, net of cash acquired | (36.7) | (2,705.6) | (43.0) | ||||||||||||||
| Proceeds from the sale of equity method investment | — | 36.0 | — | ||||||||||||||
| Net cash used in investing activities | (164.5) | (2,769.6) | (201.0) | ||||||||||||||
| Cash flows from financing activities: | |||||||||||||||||
| Proceeds from borrowings under revolving credit facilities | 2,301.4 | 1,619.7 | 1,024.0 | ||||||||||||||
| Repayments of borrowings under revolving credit facilities | (2,531.2) | (1,300.5) | (1,075.0) | ||||||||||||||
| Proceeds from issuance of long-term debt | — | 3,917.5 | 1,300.0 | ||||||||||||||
| Repayments of debt | (635.5) | (11.2) | (21.4) | ||||||||||||||
| Repayments of receivable financing liability | (68.8) | (15.8) | — | ||||||||||||||
| Payments to extinguish debt | — | (1,469.2) | (622.5) | ||||||||||||||
| Payments of debt financing fees | — | (38.1) | (16.2) | ||||||||||||||
| Net change in accounts payable-inventory financing | 84.6 | (161.8) | 93.0 | ||||||||||||||
| Financing payments for revenue generating assets | — | (46.1) | (18.1) | ||||||||||||||
| Repurchases of common stock | — | (1,500.4) | (340.6) | ||||||||||||||
| Proceeds from stock option exercises | 30.2 | 69.9 | 49.2 | ||||||||||||||
| Payment of incentive compensation plan withholding taxes | (23.1) | (28.5) | (22.5) | ||||||||||||||
| Dividend payments | (282.6) | (234.8) | (219.6) | ||||||||||||||
| Other | 22.9 | 32.1 | 8.5 | ||||||||||||||
| Net cash (used in) provided by financing activities | (1,102.1) | 832.8 | 138.8 | ||||||||||||||
| Effect of exchange rate changes on cash and cash equivalents | (12.2) | 0.1 | 4.1 | ||||||||||||||
| Net increase (decrease) in cash and cash equivalents | 57.1 | (1,152.1) | 1,256.2 | ||||||||||||||
| Cash and cash equivalents – beginning of period | 258.1 | 1,410.2 | 154.0 | ||||||||||||||
| Cash and cash equivalents – end of period | $ | 315.2 | $ | 258.1 | $ | 1,410.2 | |||||||||||
| Supplementary disclosure of cash flow information: | |||||||||||||||||
| Interest paid | $ | (224.3) | $ | (134.3) | $ | (139.4) | |||||||||||
| Income taxes paid, net | $ | (362.2) | $ | (351.0) | $ | (245.6) |
The accompanying notes are an integral part of the Consolidated Financial Statements.
CDW CORPORATION AND SUBSIDIARIES
CONSOLIDATED STATEMENTS OF STOCKHOLDERS’ EQUITY
(dollars and shares in millions)
| Common Stock | ||||||||||||||||||||||||||||||||||||||
| Shares | Amount | Paid-in Capital | Accumulated Deficit | Accumulated Other Comprehensive Loss | Total Stockholders’ Equity | |||||||||||||||||||||||||||||||||
| Balance as of December 31, 2019 | 143.0 | $ | 1.4 | $ | 3,095.3 | $ | (2,018.6) | $ | (117.8) | $ | 960.3 | |||||||||||||||||||||||||||
| Net income | — | — | — | 788.5 | — | 788.5 | ||||||||||||||||||||||||||||||||
| Equity-based compensation expense | — | — | 42.5 | — | — | 42.5 | ||||||||||||||||||||||||||||||||
| Stock option exercises | 1.4 | — | 49.2 | — | — | 49.2 | ||||||||||||||||||||||||||||||||
| Coworker Stock Purchase Plan | 0.1 | — | 16.8 | — | — | 16.8 | ||||||||||||||||||||||||||||||||
| Repurchases of common stock | (2.6) | — | — | (340.6) | — | (340.6) | ||||||||||||||||||||||||||||||||
| Dividend payments ($1.540 per share) | — | — | 1.1 | (220.7) | — | (219.6) | ||||||||||||||||||||||||||||||||
| Incentive compensation plan stock withheld for taxes | — | — | — | (22.5) | — | (22.5) | ||||||||||||||||||||||||||||||||
| Unrealized loss on cash flow hedge | — | — | — | — | (0.6) | (0.6) | ||||||||||||||||||||||||||||||||
| Reclassification of cash flow hedge to net income | — | — | — | — | 6.0 | 6.0 | ||||||||||||||||||||||||||||||||
| Foreign currency translation | — | — | — | — | 16.6 | 16.6 | ||||||||||||||||||||||||||||||||
| Adoption of Credit Losses ASU 2016-13 | — | — | — | 0.5 | $ | — | 0.5 | |||||||||||||||||||||||||||||||
| Balance as of December 31, 2020 | 141.9 | 1.4 | 3,204.9 | (1,813.4) | (95.8) | 1,297.1 | ||||||||||||||||||||||||||||||||
| Net income | — | — | — | 988.6 | — | 988.6 | ||||||||||||||||||||||||||||||||
| Equity-based compensation expense | — | — | 72.6 | — | — | 72.6 | ||||||||||||||||||||||||||||||||
| Stock option exercises | 1.5 | — | 69.9 | — | — | 69.9 | ||||||||||||||||||||||||||||||||
| Coworker Stock Purchase Plan | 0.1 | — | 20.6 | — | — | 20.6 | ||||||||||||||||||||||||||||||||
| Repurchases of common stock | (8.7) | (0.1) | — | (1,500.3) | — | (1,500.4) | ||||||||||||||||||||||||||||||||
| Dividend payments ($1.700 per share) | — | — | 1.5 | (236.3) | — | (234.8) | ||||||||||||||||||||||||||||||||
| Incentive compensation plan stock withheld for taxes | — | — | — | (28.5) | — | (28.5) | ||||||||||||||||||||||||||||||||
| Reclassification of cash flow hedge to net income | — | — | — | — | 2.5 | 2.5 | ||||||||||||||||||||||||||||||||
| Foreign currency translation | — | — | — | — | (1.1) | (1.1) | ||||||||||||||||||||||||||||||||
| Adoption of Income Tax ASU 2019-12 | — | — | — | 19.2 | — | 19.2 | ||||||||||||||||||||||||||||||||
| Balance as of December 31, 2021 | 134.8 | 1.3 | 3,369.5 | (2,570.7) | (94.4) | 705.7 | ||||||||||||||||||||||||||||||||
| Net income | — | — | — | 1,114.5 | — | 1,114.5 | ||||||||||||||||||||||||||||||||
| Equity-based compensation expense | — | — | 91.1 | — | — | 91.1 | ||||||||||||||||||||||||||||||||
| Stock option exercises | 0.5 | 0.1 | 30.1 | — | — | 30.2 | ||||||||||||||||||||||||||||||||
| Coworker Stock Purchase Plan | 0.2 | — | 25.5 | — | — | 25.5 | ||||||||||||||||||||||||||||||||
| Dividend payments ($2.090 per share) | — | — | 1.9 | (284.5) | — | (282.6) | ||||||||||||||||||||||||||||||||
| Incentive compensation plan stock withheld for taxes | — | — | — | (23.1) | — | (23.1) | ||||||||||||||||||||||||||||||||
| Unrealized gain on cash flow hedge | — | — | — | — | (0.1) | (0.1) | ||||||||||||||||||||||||||||||||
| Reclassification of cash flow hedge to net income | — | — | — | — | 3.6 | 3.6 | ||||||||||||||||||||||||||||||||
| Foreign currency translation | — | — | — | — | (61.5) | (61.5) | ||||||||||||||||||||||||||||||||
| Balance as of December 31, 2022 | 135.5 | $ | 1.4 | $ | 3,518.1 | $ | (1,763.8) | $ | (152.4) | $ | 1,603.3 |
The accompanying notes are an integral part of the Consolidated Financial Statements.
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
1. Description of Business and Summary of Significant Accounting Policies
Description of Business
CDW Corporation (“Parent”), 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 United States (“US”), the United Kingdom (“UK”) and Canada. The Company’s 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.
Throughout this report, the terms “the Company” and “CDW” refer to Parent and its 100% owned subsidiaries.
Parent has two 100% owned subsidiaries, CDW LLC and CDW Finance Corporation. CDW LLC is an Illinois limited liability company that, together with its 100% owned subsidiaries, holds all material assets and conducts all business activities and operations of the Company. CDW Finance Corporation is a Delaware corporation formed for the sole purpose of acting as co-issuer of certain debt obligations and does not hold any material assets or engage in any business activities or operations.
Significant Accounting Policies
Basis of Presentation
The Consolidated Financial Statements have been prepared in conformity with accounting principles generally accepted in the United States of America (“US GAAP”) and the rules and regulations of the US Securities and Exchange Commission (“SEC”). The Company’s Consolidated Financial Statements are based on a fiscal year ended December 31.
On December 1, 2021, the Company completed its acquisition of all issued and outstanding equity interests in Granite Parent, Inc., the parent company of Sirius Computer Solutions, Inc. (“Sirius”), a leading provider of secure, mission-critical technology-based solutions and one of the largest IT solutions integrators in the US. The Company included the financial results of Sirius in its Consolidated Financial Statements from the date of the acquisition. For additional information on the acquisition of Sirius, see Note 3 (Acquisitions).
Principles of Consolidation
The Consolidated Financial Statements include the accounts of Parent and its 100% owned subsidiaries. All intercompany transactions and accounts are eliminated in consolidation.
Use of Estimates
The preparation of the Consolidated Financial Statements in accordance with US GAAP requires management to make certain estimates and assumptions that affect the reported amounts of assets and liabilities and disclosure of contingent assets and liabilities as of the date of the Consolidated Financial Statements and the reported amounts of revenue and expenses during the reported periods. The Company bases its estimates on historical experience and on various other assumptions that management believes are reasonable under the circumstances, the results of which form the basis for making judgments about carrying values of assets and liabilities that are not readily apparent from other sources. Actual results and outcomes could differ from those estimates.
Business Combinations
The Company accounts for business combinations using the acquisition method of accounting, which allocates the fair value of the purchase consideration to the tangible and intangible assets acquired and liabilities assumed based on their estimated fair values. The excess of the purchase consideration over the fair values of these identifiable assets and liabilities is recorded as goodwill. When determining the fair values of assets acquired and liabilities assumed, management makes significant estimates and assumptions. The Company may utilize third-party valuation specialists to assist the Company in the allocation. Initial purchase price allocations are subject to revision within the measurement period, not to exceed one year from the date of acquisition. Acquisition-related expenses and transaction costs associated with business combinations are expensed as incurred.
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
Cash and Cash Equivalents
Cash and cash equivalents include deposits in banks and short-term (original maturities of three months or less at the time of purchase), highly liquid investments that are readily convertible to known amounts of cash and are so near maturity that there is insignificant risk of changes in value due to interest rate changes.
Accounts Receivable
The timing of revenue recognition may differ from the time of billing to customers. Accounts receivable presented on the Consolidated Balance Sheets represent an unconditional right to consideration, which includes unbilled receivables. Unbilled receivables represent revenues that are not currently billable where payment is unconditional and solely subject to the passage of time. These items are expected to be billed and collected in the normal course of business. Accounts receivable that are billed are recorded at the invoiced amount and include the taxes to be collected from the customer as part of the sale. Such billed amounts typically do not bear interest. The balance of the Company’s accounts receivable is classified as current for amounts expected to be collected within 12 months and noncurrent for amounts to be collected beyond 12 months.
The Company occasionally may transfer certain accounts receivable, without recourse, to third-party financial companies as a method to accelerate cash collections and reduce the Company’s credit exposure. Under these agreements, the Company may transfer certain accounts receivable in exchange for cash less a discount, as defined by the agreements. The Company’s ability to sell receivables is dependent on the financial institutions’ willingness to purchase such receivables. In addition, certain of these agreements also require that the Company continue to service, administer and collect the sold accounts receivable. Such transfers are recognized as a sale and the related accounts receivable is derecognized from the Consolidated Balance Sheet upon receipt of the third-party financing company’s payment.
The Company estimates an allowance for credit losses related to accounts receivable for future expected credit losses by using relevant information such as historical information, current conditions, and reasonable and supportable forecasts. The allowance is measured on a pool basis when similar risk characteristics exist, and a loss-rate for each pool is determined using historical credit loss experience as the basis for the estimation of expected credit losses. Adjustments to historical loss information are made for differences in current conditions as well as changes in forecasted macroeconomic conditions, such as changes in the unemployment rate or gross domestic product growth rate. The Company has typically observed a higher loss-rate experience with customers in pools associated with the Company’s Corporate and Small Business segments, as compared to the pools associated with the Public segment.
For additional information on the Company’s accounts receivables, see Note 4 (Accounts Receivable and Contract Balances).
Merchandise Inventory
Inventory is valued at the lower of cost and net realizable value. Cost is determined using a weighted-average cost method. Price protection is recorded when earned as a reduction to the cost of inventory. The Company decreases the value of inventory for estimated obsolescence equal to the difference between the cost of inventory and the net realizable value, based upon an aging analysis of the inventory on hand, specifically known inventory-related risks and assumptions about future demand and market conditions.
Miscellaneous Receivables
Miscellaneous receivables primarily consist of amounts due from vendors. The Company receives incentives from vendors related to cooperative advertising, volume rebates, bid programs, price protection and other programs. These incentives generally relate to written vendor agreements with specified performance requirements and are generally recorded as adjustments to Cost of sales or Merchandise inventory, depending on the nature of the incentive.
Property and Equipment
Property and equipment are stated at cost, less accumulated depreciation. The Company calculates depreciation expense using the straight-line method over the estimated useful lives of the assets. For revenue generating assets, the Company calculates depreciation expense using the straight-line method to the estimated residual value over the estimated useful life of the assets. Property and equipment are reviewed for impairment when events or changes in
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
circumstances indicate that the carrying amount may not be recoverable. Determination of recoverability is based on an estimate of undiscounted future cash flows resulting from the use of the asset and its eventual disposition. If the carrying amount of an asset exceeds its estimated future undiscounted cash flows, an impairment loss is recorded for the excess of the asset’s carrying amount over its fair value. Leasehold improvements are amortized over the shorter of their estimated useful lives or the remaining lease term. Expenditures for major renewals and improvements that extend the useful life of property and equipment are capitalized. Expenditures for maintenance and repairs are charged to expense as incurred.
Leases
The Company enters into operating lease contracts, as assessed at contract inception, primarily for real estate, data centers and equipment. On the lease commencement date, the Company records operating lease liabilities based on the present value of the future lease payments. In determining the present value of future lease payments, the Company uses its incremental borrowing rate based on the information available at the commencement date. For real estate and data center contracts, the Company accounts for the lease and non-lease components as a single lease component. For certain equipment leases, the Company applies a portfolio approach to account for the right-of-use asset and operating lease liability. In assessing the lease term, the Company includes options to renew only when it is reasonably certain that it will be exercised; a determination which is at the sole discretion of the Company. For equipment leases used in revenue generating activities with an initial term of 12 months or less, the Company records a right-of-use asset and lease liability. For all remaining leases with an initial term of 12 months or less, the Company has elected to not record a right-of-use asset and lease liability. The Company records lease expense on a straight-line basis over the lease term beginning on the commencement date.
Goodwill
The Company performs an evaluation of goodwill at the reporting unit level, utilizing either a qualitative or quantitative impairment test. A qualitative assessment is performed at least on an annual basis to determine whether it is more likely than not that the fair value of a reporting unit is less than its carrying value. The Company performs a quantitative impairment test for each reporting unit every three years, or more frequently if circumstances indicate a potential impairment. The annual test for impairment is conducted as of December 1. The Company’s reporting units included in the assessment of potential goodwill impairment are the same as its operating segments.
Under a qualitative assessment, the most recent quantitative assessment is used to determine if it is more likely than not that the reporting unit’s goodwill is impaired. As part of this qualitative assessment, the Company assesses relevant events and circumstances including macroeconomic conditions, industry and market conditions, cost factors, overall financial performance, changes in share price and entity-specific events to determine if there is an indication of impairment.
Under a quantitative assessment, goodwill impairment is identified by comparing the fair value of a reporting unit to its carrying amount, including goodwill. If the carrying amount of a reporting unit exceeds its fair value, goodwill is considered impaired and an impairment charge is recognized in an amount equal to that excess, not to exceed the carrying amount of goodwill. 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 the Company’s fair value in an orderly transaction between market participants.
Under the income approach, the Company determines fair value based on estimated future cash flows of a reporting unit, discounted by an estimated weighted-average cost of capital, which reflects the overall level of inherent risk of a reporting unit and the rate of return an outside investor would expect to earn. The estimated future cash flows of each reporting unit are based on internally generated forecasts for the remainder of the respective reporting period and the next five years.
Under the market approach, the Company utilizes valuation multiples derived from publicly available information for guideline companies to provide an indication of how much a knowledgeable investor in the marketplace would be willing to pay for a company. The valuation multiples are applied to the reporting units.
Determining the fair value of a reporting unit is judgmental in nature and requires the use of significant estimates and assumptions, including Net sales growth rates, gross profit margins, operating margins, discount rates and future market conditions, among others. Any changes in the judgments, estimates or assumptions used could produce significantly different results.
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
Intangible Assets
Intangible assets with determinable lives are amortized on a straight-line basis over their respective estimated useful lives. The cost of computer software developed or obtained for internal use is capitalized and amortized on a straight-line basis over the estimated useful life of the software. Intangible assets are reviewed for impairment when events or changes in circumstances indicate that the carrying amount of such assets may not be recoverable. Determination of recoverability is based on an estimate of undiscounted future cash flows resulting from the use of the asset and its eventual disposition. If the carrying amount of an asset exceeds its estimated future undiscounted cash flows, an impairment loss is recorded for the excess of the asset’s carrying amount over its fair value. In addition, each quarter, the Company evaluates whether events and circumstances warrant a revision to the remaining estimated useful life of each of these intangible assets. If the Company were to determine that a change to the remaining estimated useful life of an intangible asset was necessary, then the remaining carrying amount of the intangible asset would be amortized prospectively over that revised remaining useful life.
Deferred Financing Costs
Deferred financing costs, such as underwriting, financial advisory, professional fees and other similar fees are capitalized and recognized in Interest expense, net over the estimated life of the related debt instrument using the effective interest method or straight-line method, as applicable. The Company classifies deferred financing costs as a direct deduction from the carrying value of the Long-term debt liability on the Consolidated Balance Sheets, except for deferred financing costs associated with revolving credit facilities which are presented as an asset, within Other assets on the Consolidated Balance Sheets.
Fair Value Measurements
Fair value is defined under US GAAP as the price that would be received to sell an asset or paid to transfer a liability in an orderly transaction between market participants at the measurement date. A fair value hierarchy has been established for valuation inputs to prioritize the inputs into three levels based on the extent to which inputs used in measuring fair value are observable in the market. Each fair value measurement is reported in one of the three levels which is determined by the lowest level input that is significant to the fair value measurement in its entirety. These levels are:
Level 1 – observable inputs such as quoted prices for identical instruments traded in active markets.
Level 2 – inputs are based on quoted prices for similar instruments in active markets, quoted prices for identical or similar instruments in markets that are not active and model-based valuation techniques for which all significant assumptions are observable in the market or can be corroborated by observable market data for substantially the full term of the assets or liabilities.
Level 3 – inputs are generally unobservable and typically reflect management’s estimates of assumptions that market participants would use in pricing the asset or liability. The fair values are therefore determined using model-based techniques that include option pricing models, discounted cash flow models and similar techniques.
Revenue Recognition
The Company is a primary distribution channel for a large group of vendors and suppliers, including original equipment manufacturers (“OEMs”), software publishers and wholesale distributors.
The Company accounts for a contract when it has approval and commitment from both parties, the rights of the parties are identified, payment terms are established, the contract has commercial substance and collectability of consideration is probable. The Company evaluates the following indicators amongst others when determining whether it is acting as a principal in the transaction and recording revenue on a gross basis: (i) the Company is primarily responsible for fulfilling the promise to provide the specified goods or service, (ii) the Company has inventory risk before the specified good or service has been transferred to a customer or after transfer of control to the customer and (iii) the Company has discretion in establishing the price for the specified good or service. If the terms of a transaction do not indicate the Company is acting as a principal in the transaction, then the Company is acting as an agent in the transaction and the associated revenues are recognized on a net basis.
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
The Company recognizes revenue in transactions for which it is acting as a principal once control has passed to the customer. The following indicators are evaluated in determining when control has passed to the customer: (i) the Company has a right to payment for the product or service, (ii) the customer has legal title to the product, (iii) the Company has transferred physical possession of the product to the customer, (iv) the customer has the significant risk and rewards of ownership of the product and (v) the customer has accepted the product. The Company’s products can be delivered to customers in a variety of ways, including (i) as physical product shipped from the Company’s warehouse, (ii) via drop-shipment by the vendor or supplier or (iii) via electronic delivery of keys for software licenses. The Company’s shipping terms typically allow for the Company to recognize revenue when the product reaches the customer’s location.
The Company recognizes revenue in transactions for which it is acting as an agent once it has arranged for the third party to provide the product or service. Depending on the nature of the arrangement, this may occur at the time the Company executes the contract with the third party or at the time it invoices the customer.
The Company leverages drop-shipment arrangements with many of its vendors and suppliers to deliver products to its customers without having to physically hold the inventory at its warehouses. The Company is the principal in the transaction and recognizes revenue for drop-shipment arrangements on a gross basis.
Revenue Recognition for Hardware
Revenues from sales of hardware products are recognized on a gross basis as the Company is acting as a principal in these transactions, with the selling price to the customer recorded as Net sales and the acquisition cost of the product recorded as Cost of sales. The Company recognizes revenue from these transactions when control has passed to the customer, which is usually upon delivery of the product to the customer.
In some instances, the customer agrees to buy the product from the Company but requests delivery at a later date, commonly known as bill-and-hold arrangements. For these transactions, the Company deems that control passes to the customer when the product is ready for delivery. The Company views products ready for delivery when the customer has a signed agreement, significant risk and rewards for the products and the ability to direct the assets, and the products have been set aside specifically for the customer, cannot be redirected to another customer and for customer orders that include configuration services, when such services have been completed.
The Company’s vendor partners warrant most of the products the Company sells. These manufacturer warranties are assurance-type warranties and are not considered separate performance obligations. The warranties are not sold separately and only provide assurance that products will conform with the manufacturer’s specifications. In some transactions, a third party will provide the customer with an extended warranty. These extended warranties are sold separately and provide the customer with a service in addition to assurance that the product will function as expected. The Company considers these warranties to be separate performance obligations from the underlying product. For extended warranties, the Company is arranging for those services to be provided by the third party and therefore is acting as an agent in the transaction and records revenue on a net basis at the point of sale.
The Company sells cloud computing solutions which include Infrastructure as a Service (“IaaS”). IaaS solutions utilize third-party partners to enable customers to access data center functionality in a cloud-based solution, including storage, computing and networking. In these transactions, the Company is acting as an agent and recognizes revenue once its agency performance obligation is complete.
Revenue Recognition for Software
Revenues from most software license sales are recognized as a single performance obligation on a gross basis as the Company is acting as a principal in these transactions at the point the software license is delivered to the customer. Generally, software licenses are sold with accompanying third-party delivered software assurance, which is a product that allows customers to upgrade, at no additional cost, to the latest technology if new capabilities are introduced during the period that the software assurance is in effect. The Company evaluates whether the software assurance is a separate performance obligation by assessing if the third-party delivered software assurance is critical or essential to the core functionality of the software itself. This involves considering if the software provides its original intended functionality to the customer without the updates, if the customer would ascribe a higher value to the upgrades versus the up-front deliverable, if the customer would expect frequent intelligence updates to the software (such as updates that maintain the original functionality), and if the customer chooses to not delay or always install upgrades. If the Company determines that the accompanying third-party delivered software assurance is critical or essential to the core
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
functionality of the software license, the software license and the accompanying third-party delivered software assurance are recognized as a single performance obligation. The value of the product is primarily the accompanying support delivered by a third party and therefore the Company is acting as an agent in these transactions and recognizes them on a net basis once its agency performance obligation is complete. For software licenses where the accompanying third-party delivered software assurance is not critical or essential to the core functionality, the software assurance is recognized as a separate performance obligation, with the associated revenue recognized on a net basis. For additional information regarding the accounting for bundled arrangements, see “Revenue Recognition for Bundled Arrangements” below.
The Company sells cloud computing solutions which include Software as a Service (“SaaS”). SaaS solutions utilize third-party partners to offer the Company’s customers access to software in the cloud that enhances office productivity, provides security or assists in collaboration. In these transactions, the Company is acting as an agent and recognizes revenue once its agency performance obligation is complete.
The Company’s customers are offered the opportunity by certain of its vendors to purchase software licenses and software assurance under enterprise agreements (“EAs”). For most EA transactions, the Company’s obligation to the customer is that of a distributor or sales agent of the services, where all obligations for providing the services to customers are passed to the Company’s vendors. The Company’s performance obligations are satisfied at the time of the sale. In other EA transactions, the Company is responsible for fulfilling the promised services to the customer and providing remedy or refund for work if the customer is not satisfied with the delivered services, has inventory risk in the arrangement and has full control to set the price for the customer. With most EAs, the Company’s vendors will transfer the license and invoice the customer directly, paying resellers an agency fee or commission on these sales. The Company records these fees as a component of Net sales as earned and there is no corresponding Cost of sales amount.
Revenue Recognition for Services
The Company provides professional services, which include project managers and consultants recommending, designing and implementing IT solutions. Revenue from professional services is recognized either on a time and materials basis or proportionally as costs are incurred for fixed fee project work. Revenue is recognized on a gross basis each month as work is performed and the Company transfers those services.
Revenues from the sale of data center services, such as managed and remote managed services, server co-location, internet connectivity and data backup and storage provided by the Company, are recognized over the period the service is provided. Most hosting and managed service obligations are based on the quantity and pricing parameters established in the agreement. As the customer receives the benefit of the service each month, the Company recognizes the respective revenue on a gross basis as the Company is acting as a principal in the transaction. Additionally, the Company’s managed services team provides project support to customers that are billed on a fixed fee basis. The Company is acting as the principal in the transaction and recognizes revenue on a gross basis based on the total number of hours incurred for the period over the total expected hours for the project. Total expected hours to complete the project is updated for each period and best represents the transfer of control of the service to the customer.
Revenue Recognition for Bundled Arrangements
The Company also sells some of its products and services as part of bundled contract arrangements containing multiple deliverables, which may include a combination of products and services. For each deliverable that represents a distinct performance obligation, total arrangement consideration is allocated based upon the standalone selling prices of each performance obligation.
Sales In-Transit
The Company performs 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. This analysis is the basis upon which the Company estimates the amount of Net sales in-transit at the end of the period and adjusts revenue and the related costs to reflect only what has been delivered to the customer. Changes in delivery patterns may result in a different number of business days estimated to make this adjustment.
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
Freight Costs
The Company records freight billed to its customers as Net sales and the related freight costs as Cost of sales when the underlying product revenue is recognized. For freight not billed to its customers, the Company records the freight costs as Cost of sales. The Company’s typical shipping terms result in shipping being performed before the customer obtains control of the product. The Company considers shipping to be a fulfillment activity and not a separate performance obligation.
Other
The nature of the Company’s contracts give rise to variable consideration in the form of volume rebates and sales returns and allowances, which are estimated at contract inception. The Company estimates variable consideration at the most likely amount to which it is expected to be entitled. This estimated amount is included in the transaction price to the extent it is probable that a significant reversal of cumulative revenue recognized will not occur when the uncertainty associated with the variable consideration is resolved. The estimates of variable consideration and determination of whether to include estimated amounts in the transaction price are based on an assessment of the Company’s anticipated performance and all information that is reasonably available. At the time of sale, the Company records a liability for estimated sales returns and allowances and an associated right of return asset. The Company also records a provision for volume rebates based on the evaluation of contract terms and historical experience.
The Company excludes amounts collected on behalf of third-parties, such as sales taxes, when determining the transaction price.
When a contract results in revenue being recognized in excess of the amount the Company has the right to invoice to the customer, a contract asset is recorded on the Consolidated Balance Sheets. Contract assets primarily arise due to partially fulfilled contracts with integrated solutions and professional services with fixed fee arrangements.
Contract liabilities consist of payments received from customers, or such consideration that is contractually due, in advance of providing the product or performing services. Contract liabilities primarily arise due to professional services with fixed fee arrangements, bill-and-hold transactions where control has not passed to the customer and certain governmental contracts.
Any incremental direct costs of obtaining a contract, primarily sales commissions, are deferred on the Consolidated Balance Sheets and amortized over the period of contract performance.
The Company generally does not enter into long-term contracts. The Company has elected to use the practical expedient for its performance obligations table to include only those contracts that are longer than 12 months at the time of contract inception and those contracts that are non-cancelable. Additionally, for certain governmental contracts where there are annual renewals, the Company has excluded these contracts since there is only a one-year legal obligation. Typically, the only contracts that are longer than 12 months in duration are related to the Company’s managed services business.
Sales Taxes
Sales tax amounts collected from customers for remittance to governmental authorities are presented on a net basis in the Consolidated Statements of Operations.
Advertising
Advertising costs are generally charged to expense in the period incurred and are recorded in Selling and administrative expenses in the Consolidated Statements of Operations. Cooperative reimbursements from vendors are recorded in the period the related advertising expenditure is incurred. The Company classifies vendor consideration as a reduction to Cost of sales. During the years ended December 31, 2022, 2021 and 2020, the Company had advertising costs of $211 million, $199 million and $191 million, respectively.
Equity-Based Compensation
The Company measures all equity-based payments using a fair-value-based method and records compensation expense over the requisite service period using the straight-line method in its Consolidated Financial Statements. The expense calculation includes estimated forfeiture rates, which have been developed based upon historical experience.
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
Interest Expense
Interest expense is recognized in the period incurred at the applicable interest rate in effect.
Foreign Currency Translation
The Company’s reporting currency is the US dollar. The functional currency of the Company’s international operating subsidiaries is generally the same as the corresponding local currency. Assets and liabilities of the international operating subsidiaries are translated at the spot rate in effect at the applicable reporting date. Revenues and expenses of the international operating subsidiaries are translated at the average exchange rates in effect during the applicable period. The resulting foreign currency translation adjustment is recorded as Accumulated other comprehensive loss, which is reflected as a separate component of Stockholders’ equity.
Income Taxes
Deferred income taxes are provided to reflect the differences between the tax bases of assets and liabilities and their reported amounts in the Consolidated Financial Statements using enacted tax rates in effect for the year in which the differences are expected to reverse. The Company performs an evaluation of the realizability of deferred tax assets on a quarterly basis. This evaluation requires management to make use of estimates and assumptions and considers all positive and negative evidence and factors, such as the scheduled reversal of temporary differences, the mix of earnings in the jurisdictions in which the Company operates, and prudent and feasible tax planning strategies.
The Company accounts for unrecognized tax benefits based upon its assessment of whether a tax benefit is more likely than not to be sustained upon examination by tax authorities. The Company reports a liability for unrecognized tax benefits resulting from unrecognized tax benefits taken or expected to be taken in a tax return and recognizes interest and penalties, if any, related to its unrecognized tax benefits in income tax expense.
2. Recent Accounting Pronouncements
In September 2022, the Financial Accounting Standards Board issued Accounting Standards Update (“ASU”) 2022-04, Liabilities—Supplier Finance Programs (Subtopic 405-50): Disclosure of Supplier Finance Program Obligations. This ASU requires entities that use supplier finance programs in connection with the purchase of goods and services to disclose key terms of the programs and information about the obligations that are outstanding at the end of the reporting period. This disclosure requirement is intended to provide information about an entity’s use of supplier finance programs and their effect on the entity’s working capital, liquidity and cash flows. The ASU is effective for all entities for fiscal years beginning after December 15, 2022, including interim periods within those fiscal years, except for the rollforward requirement, which is effective for fiscal years beginning after December 15, 2023. The Company plans to adopt the standard during the first quarter of 2023, except for the rollforward requirement, which will be adopted during the first quarter of 2024. The standard does not affect the Company's recognition, measurement or financial statement presentation of supplier finance program obligations on the Consolidated Financial Statements. The Company is currently evaluating the impact the ASU will have on its disclosures.
3. Acquisitions
Sirius
On December 1, 2021, the Company completed its acquisition of all issued and outstanding equity interests of Sirius for an aggregate consideration paid, net of cash acquired, of approximately $2.4 billion. Transaction costs related to the acquisition were $35 million, which are included in Selling and administrative expenses for the year ended December 31, 2021. The Company used the net proceeds from the December 1, 2021 issuance of the $2.5 billion aggregate principal amount of senior unsecured notes to finance the acquisition and related transaction costs. For additional information on the issuance of the senior notes, see Note 9 (Debt).
Sirius is a leading provider of secure, mission-critical technology-based solutions and is one of the largest IT solutions integrators in the United States, leveraging its services-led approach, broad portfolio of hybrid infrastructure solutions, and deep technical expertise of its 2,600 coworkers to support corporate and public customers. This strategic acquisition enhances the Company’s breadth and depth of services and solutions offerings.
Following the close of the acquisition, the Company issued a mix of cash and equity-based retention awards to certain Sirius coworkers, which vest over a required service period and will be recorded as expense over the required service
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
period. The results of operations of Sirius are included in the Consolidated Financial Statements of the Company beginning on the acquisition date. These amounts are presented within the Corporate, Small Business and Public reportable segments. For the year ended December 31, 2021, the Company’s Consolidated Financial Statements included $197 million of net sales and $9 million of net income from the results of operations of Sirius.
The Sirius acquisition has been accounted for as a business combination. During the fourth quarter of 2022, the Company finalized the purchase price and completed its identification and measurement of the assets acquired and liabilities assumed as of the date of the acquisition. There were no significant adjustments to the preliminary purchase price allocation disclosed in the December 31, 2021 Consolidated Financial Statements. The table below summarizes the final purchase price allocation to acquired assets, including goodwill and intangible assets.
| Acquisition-Date Fair Value | ||||||||
| Cash and cash equivalents | $ | 52.8 | ||||||
| Accounts receivable | 634.1 | |||||||
| Intangible assets, net | 1,164.0 | |||||||
| Goodwill | 1,566.6 | |||||||
| Other assets | 438.1 | |||||||
| Total assets acquired | 3,855.6 | |||||||
| Accounts payable-trade | 633.8 | |||||||
| Debt | 170.1 | |||||||
| Deferred tax liabilities | 207.0 | |||||||
| Other liabilities | 389.7 | |||||||
| Total liabilities assumed | 1,400.6 | |||||||
| Total purchase price | $ | 2,455.0 |
The Company used the income approach to value the intangible assets, consisting of acquired customer relationships and trade name. 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. Significant inputs used to value these intangible assets include projection of all future cash flows, long-term growth rates, customer attrition rates, discount rates, royalty rates and applicable income tax rates. The excess purchase price recorded to goodwill primarily represents the future economic benefits the Company expects to achieve as a result of combining operations and Sirius’ workforce. The Company finalized its allocation of goodwill to the reportable segments during the fourth quarter of 2022. For additional information on goodwill allocation, see Note 6 (Goodwill and Other Intangible Assets).
The amount of goodwill expected to be deductible for income tax purposes is estimated to be $160 million.
The table below summarizes the fair value of identifiable intangible assets acquired.
| Useful Lives (Years) | Acquisition-Date Fair Value | |||||||||||||
| Customer relationships | 12 | $ | 1,140.0 | |||||||||||
| Trade name | 1 | 24.0 | ||||||||||||
| $ | 1,164.0 |
The following unaudited pro forma financial information presents the combined results of operations as if the acquisition of Sirius had been consummated on January 1, 2020. The pro forma adjustments are based on historical results of operations and financial condition of the Company and Sirius and do not include any anticipated synergies or other expected benefits of the acquisition. The unaudited pro forma financial information is not necessarily indicative of the actual consolidated results of operations had the acquisition actually consummated on January 1, 2020, nor are they indicative of future consolidated results of operations of the combined company.
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
| Year Ended December 31, | ||||||||||||||
| 2021 | 2020 | |||||||||||||
| Pro forma net sales | $ | 22,793.0 | $ | 20,659.0 | ||||||||||
| Pro forma net income | $ | 977.4 | $ | 771.1 |
The pro forma adjustments include, among other things:
-
Estimated impact to conform Sirius’ classification to the Company’s financial statement presentation.
-
Estimated amortization expense of intangible assets acquired.
-
Estimated compensation expense for the cash and equity retention awards.
-
Interest expense for the additional indebtedness incurred to fund the acquisition.
-
Transaction costs that have been incurred in connection with the acquisition.
Focal Point Data Risk LLC and certain affiliates (“Focal Point”)
On July 30, 2021, the Company completed the acquisition of Focal Point through a purchase of all issued and outstanding equity interests. Focal Point is a leading US-based cybersecurity services firm that brings a team skilled in identity and access management as well as the ability to serve customers across the full cybersecurity landscape. This strategic acquisition expands the Company’s services and capabilities to help customers address risks posed by malicious cyber threats and cyber workforce shortages, while helping customers navigate shifting data protection laws. The acquisition of Focal Point was not material to the Company’s results of operations and financial condition. The financial results of Focal Point have been included in the Company’s Consolidated Financial Statements since the date of the acquisition. These amounts are presented within the Public reportable segment and are insignificant during the year ended December 31, 2021. The purchase price allocation was final during the second quarter of 2022 and there were no adjustments to the preliminary purchase price allocation. The Company recorded $36 million of intangible assets related to customer relationships.
Amplified IT LLC (“Amplified IT”)
On March 15, 2021, the Company completed the acquisition of Amplified IT through a purchase of all issued and outstanding membership interests. Amplified IT is a Google Premium education partner and leading provider of Google Cloud services, solutions and software for education partners. This strategic acquisition expands the Company’s services and solutions capabilities to help schools leverage technology to achieve greater educational outcomes. The acquisition of Amplified IT was not material to the Company’s results of operations and financial condition. The financial results of Amplified IT have been included in the Company’s Consolidated Financial Statements since the date of the acquisition. These amounts are presented within the Public reportable segment and are insignificant during the year ended December 31, 2021. The purchase price allocation was final during the first quarter of 2022 and there were no adjustments to the preliminary purchase price allocation. The Company recorded approximately $88 million of intangible assets, which primarily consisted of customer relationships.
4. Accounts Receivable and Contract Balances
Accounts Receivable
The following table details the total accounts receivable recognized and the related classification on the Consolidated Balance Sheets:
| December 31, | ||||||||||||||
| 2022 | 2021 | |||||||||||||
| Accounts receivable, current(1) | $ | 4,461.3 | $ | 4,499.4 | ||||||||||
| Accounts receivable, noncurrent(2) | 203.0 | 197.4 | ||||||||||||
| Total accounts receivable | $ | 4,664.3 | $ | 4,696.8 |
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
(1)Accounts receivable, current are presented within Accounts receivable, net of allowance for credit losses on the Consolidated Balance Sheets.
(2)Accounts receivable, noncurrent are presented within Other assets on the Consolidated Balance Sheets.
From time to time, the Company transfers certain accounts receivable, without recourse, to third-party financial companies as a method to reduce the Company’s credit exposure and accelerate cash collections. Such transfers are recognized as a sale and the related accounts receivable is derecognized from the Consolidated Balance Sheets upon receipt of payment from the third-party financing company. During the years ended December 31, 2022 and 2021, the Company sold approximately $539 million and $139 million of accounts receivable, respectively.
The Company recognizes an allowance for credit losses at inception and reassesses quarterly on a pool basis based on expected collectability and forecasted macroeconomic conditions. The following table details the changes in the allowance for credit losses related to accounts receivable:
| Balance as of December 31, 2020 | $ | 29.6 | ||||||
| Decrease to provision for credit losses | (5.4) | |||||||
| Write-offs charged against the allowance for credit losses | (5.0) | |||||||
| Other | 1.2 | |||||||
| Balance as of December 31, 2021 | 20.4 | |||||||
| Increase to provision for credit losses | 8.3 | |||||||
| Write-offs charged against the allowance for credit losses | (6.0) | |||||||
| Other | 3.0 | |||||||
| Balance as of December 31, 2022 | $ | 25.7 |
Contract Balances
Contract assets and liabilities represent the difference in the timing of revenue recognition from receipt of cash from customers. Contract assets represent revenue recognized on performance obligations satisfied or partially satisfied for which the Company has no unconditional right to consideration. Contract liabilities consist of payments received from customers, or such consideration that is contractually due, in advance of providing the product or performing services. The following table details information about the Company’s contract balances recognized on the Consolidated Balance Sheets:
| December 31, | ||||||||||||||
| 2022 | 2021 | |||||||||||||
| Contract assets(1) | $ | 242.1 | $ | 134.7 | ||||||||||
| Contract liabilities(2)(3) | $ | 525.3 | $ | 423.3 |
(1)Contract assets are presented within Prepaid expenses and other on the Consolidated Balance Sheets.
(2)Includes $40 million and $20 million of long-term contract liabilities that are presented within Other liabilities on the Consolidated Balance Sheets as of December 31, 2022 and 2021, respectively.
(3)For the years ended December 31, 2022 and 2021, the Company recognized revenue of $238 million and $171 million, respectively, related to its contract liabilities that were included in the beginning balance of the respective periods.
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
A contract’s transaction price is allocated to each distinct performance obligation and recognized as revenue when, or as, the performance obligation is satisfied. For additional information regarding the Company’s performance obligations, see Note 1 (Description of Business and Summary of Significant Accounting Policies). The following table represents the total transaction price for the remaining performance obligations as of December 31, 2022 related to non-cancelable contracts longer than 12 months in duration that is expected to be recognized over future periods.
| Within 1 Year | Years 1-2 | Years 2-3 | Thereafter | |||||||||||||||||||||||
| Remaining performance obligations | $ | 56.3 | $ | 23.2 | $ | 11.3 | $ | 1.0 |
5. Property and Equipment
Property and equipment consist of the following:
| December 31, | |||||||||||||||||
| Useful Lives (Years) | 2022 | 2021 | |||||||||||||||
| Computer and data processing equipment | 3 - 5 | $ | 192.1 | $ | 161.9 | ||||||||||||
| Building and leasehold improvements | 5 - 25 | 149.5 | 151.3 | ||||||||||||||
| Machinery and equipment | 5 - 10 | 46.2 | 44.4 | ||||||||||||||
| Computer software | 3 - 5 | 34.6 | 32.9 | ||||||||||||||
| Furniture and fixtures | 5 - 10 | 30.5 | 31.0 | ||||||||||||||
| Land | -* | 27.7 | 27.7 | ||||||||||||||
| Revenue generating assets | 1 - 5 | 1.2 | 0.2 | ||||||||||||||
| Construction in progress | -* | 16.9 | 12.0 | ||||||||||||||
| Property and equipment, gross | 498.7 | 461.4 | |||||||||||||||
| Less: accumulated depreciation | (309.9) | (265.6) | |||||||||||||||
| Property and equipment, net | $ | 188.8 | $ | 195.8 |
*Asset is not depreciated.
During 2022, 2021 and 2020, the Company recorded disposals of $7 million, $20 million and $54 million, respectively, to derecognize Property and equipment that were no longer in use.
Depreciation expense for the years ended December 31, 2022, 2021, and 2020 was $58 million, $42 million and $213 million, respectively.
6. Goodwill and Other Intangible Assets
Goodwill
The changes in Goodwill by reportable segment are as follows:
| Corporate | Small Business | Public | Other(1) | Consolidated | ||||||||||||||||||||||||||||
| Balances as of December 31, 2020**(2)** | $ | 1,123.6 | $ | 185.9 | $ | 929.6 | $ | 356.8 | $ | 2,595.9 | ||||||||||||||||||||||
| Amplified IT acquisition(3) | — | — | 133.8 | — | 133.8 | |||||||||||||||||||||||||||
| Focal Point acquisition(3) | — | — | 82.7 | — | 82.7 | |||||||||||||||||||||||||||
| Sirius acquisition(3) | 900.6 | 80.2 | 591.6 | — | 1,572.4 | |||||||||||||||||||||||||||
| Other acquisition adjustments | 0.2 | — | — | — | 0.2 | |||||||||||||||||||||||||||
| Foreign currency translation | — | — | — | (2.1) | (2.1) | |||||||||||||||||||||||||||
| Balances as of December 31, 2021**(2)** | 2,024.4 | 266.1 | 1,737.7 | 354.7 | 4,382.9 | |||||||||||||||||||||||||||
| Sirius measurement period adjustment(3) | 109.0 | (35.9) | (78.9) | — | (5.8) | |||||||||||||||||||||||||||
| Foreign currency translation | — | — | — | (34.4) | (34.4) | |||||||||||||||||||||||||||
| Balances as of December 31, 2022**(2)** | $ | 2,133.4 | $ | 230.2 | $ | 1,658.8 | $ | 320.3 | $ | 4,342.7 |
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
(1)Other is comprised of CDW UK and CDW Canada operating segments.
(2)Goodwill is net of accumulated impairment losses of $1,571 million, $354 million and $28 million related to the Corporate, Public and Other segments, respectively, recorded in 2008 and 2009.
(3)For additional information regarding the Company’s acquisitions, see Note 3 (Acquisitions).
Other Intangible Assets
A summary of intangible assets is as follows:
| December 31, 2022 | Useful Lives (Years) | Gross Carrying Amount | Accumulated Amortization | Net Carrying Amount | ||||||||||||||||||||||
| Customer relationships | 3 - 14 | $ | 3,352.4 | $ | (2,100.6) | $ | 1,251.8 | |||||||||||||||||||
| Trade name | 1 - 20 | 446.1 | (341.0) | 105.1 | ||||||||||||||||||||||
| Internally developed software | 3 - 5 | 429.8 | (297.6) | 132.2 | ||||||||||||||||||||||
| Other | 1 - 10 | 2.5 | (0.9) | 1.6 | ||||||||||||||||||||||
| Total | $ | 4,230.8 | $ | (2,740.1) | $ | 1,490.7 | ||||||||||||||||||||
| December 31, 2021 | ||||||||||||||||||||||||||
| Customer relationships | 3 - 14 | $ | 3,330.9 | $ | (1,987.8) | $ | 1,343.1 | |||||||||||||||||||
| Trade name | 1 - 20 | 472.7 | (302.0) | 170.7 | ||||||||||||||||||||||
| Internally developed software | 3 - 5 | 352.0 | (239.8) | 112.2 | ||||||||||||||||||||||
| Other | 1 - 10 | 2.5 | (0.4) | 2.1 | ||||||||||||||||||||||
| Total | $ | 4,158.1 | $ | (2,530.0) | $ | 1,628.1 |
During the years ended December 31, 2022, 2021 and 2020, the Company recorded disposals of $8 million, $2 million and $25 million, respectively, to remove fully amortized intangible assets that were no longer in use.
During the years ended December 31, 2022, 2021 and 2020, the Company recorded amortization expense related to intangible assets of $233 million, $149 million and $212 million, respectively.
Estimated future amortization expense related to intangible assets is as follows:
| Years ending December 31, | Estimated Future Amortization Expense | |||||||
| 2023 | $ | 209.1 | ||||||
| 2024 | 187.1 | |||||||
| 2025 | 171.5 | |||||||
| 2026 | 158.0 | |||||||
| 2027 | 147.3 | |||||||
| Thereafter | 617.7 | |||||||
| Total future amortization expense | $ | 1,490.7 |
7. Inventory Financing Agreements
The Company has entered into agreements with certain financial intermediaries to facilitate the purchase of inventory from various suppliers under certain terms and conditions, as described below. These amounts are classified separately as Accounts payable-inventory financing on the Consolidated Balance Sheets. The Company does not incur any interest expense associated with these agreements as balances are paid when they are due.
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
Amounts included in Accounts payable-inventory financing are as follows:
| December 31, | ||||||||||||||
| 2022 | 2021 | |||||||||||||
| Revolving Loan inventory financing agreement(1) | $ | 444.5 | $ | 310.1 | ||||||||||
| Other inventory financing agreements | 74.5 | 138.2 | ||||||||||||
| Accounts payable-inventory financing | $ | 519.0 | $ | 448.3 |
(1)The revolving credit facilities include an inventory floorplan sub-facility that enables the Company to maintain an inventory financing agreement with a financial intermediary.
8. Financial Instruments
The Company does not hold or issue derivative financial instruments for trading or speculative purposes. The Company’s indebtedness creates interest rate risk on its variable-rate debt. The Company may use derivative financial instruments to manage its exposure to interest rate risk. For additional information, see Note 9 (Debt).
From time to time, the Company may execute interest rate cap agreements that entitle it to payments from the counterparty of the amount, if any, by which the interest rate, of an underlying variable rate debt, exceeds the strike rates of the caps during the agreement period in exchange for an upfront premium. During 2022, the Company did not enter into new interest rate cap agreements. The total notional amount of $1.3 billion in interest rate cap agreements matured on December 31, 2022. As such, there were no outstanding interest rate cap agreements on the Consolidated Balance Sheet as of December 31, 2022. As of December 31, 2021, the Company had a total notional amount of $1.3 billion in interest rate cap agreements with a fair value of less than $1 million, which were classified within Other assets on the Consolidated Balance Sheet.
The fair value of the Company’s interest rate cap agreements is classified as Level 2 in the fair value hierarchy. The valuation of the interest rate cap agreements is derived by using a discounted cash flow analysis on the expected cash receipts that would occur if variable interest rates rise above the strike rates of the caps. This analysis reflects the contractual terms of the interest rate cap agreements, including the period to maturity, and uses observable market-based inputs, including LIBOR curves and implied volatilities. The Company also incorporates insignificant credit valuation adjustments to appropriately reflect the respective counterparty’s nonperformance risk in the fair value measurements. The counterparty credit spreads are based on publicly available credit information obtained from a third-party credit data provider.
Since inception, the total notional amount of $1.3 billion in interest rate cap agreements were designated as cash flow hedges. As a result of a prepayment on the senior unsecured term loan facility, the Company dedesignated a notional amount of $350 million, which did not result in a material impact to the Consolidated Financial Statements for the year ended December 31, 2022. The changes in the fair value of derivatives that qualify as cash flow hedges are recorded in Accumulated other comprehensive loss (“AOCL”) and are subsequently reclassified into Interest expense in the period when the hedged forecasted transaction affects earnings. The following tables provide the activity in AOCL, net of tax, for the years ended December 31, 2022, 2021 and 2020.
| Year Ended December 31, | ||||||||||||||||||||
| 2022 | 2021 | 2020 | ||||||||||||||||||
| Change in fair value recorded to AOCL | $ | (0.1) | $ | — | $ | (0.6) | ||||||||||||||
| Reclassification from AOCL to Interest expense, net | $ | 3.6 | $ | 2.5 | $ | 6.0 |
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
9. Debt
| As of December 31, 2022 | As of December 31, 2021 | |||||||||||||||||||||||||||||||
| Maturity Date | Interest Rate | Amount | Interest Rate | Amount | ||||||||||||||||||||||||||||
| Credit Facility | ||||||||||||||||||||||||||||||||
| Senior unsecured revolving loan facility | December 2026 | Variable | $ | 72.5 | Variable | $ | 316.4 | |||||||||||||||||||||||||
| Term Loans | ||||||||||||||||||||||||||||||||
| Senior unsecured term loan facility | December 2026 | Variable | 784.5 | Variable | 1,420.0 | |||||||||||||||||||||||||||
| Unsecured Senior Notes | ||||||||||||||||||||||||||||||||
| Senior notes due 2024 | December 2024 | 5.500 | % | 575.0 | 5.500 | % | 575.0 | |||||||||||||||||||||||||
| Senior notes due 2025 | May 2025 | 4.125 | % | 600.0 | 4.125 | % | 600.0 | |||||||||||||||||||||||||
| Senior notes due 2028 | April 2028 | 4.250 | % | 600.0 | 4.250 | % | 600.0 | |||||||||||||||||||||||||
| Senior notes due 2029 | February 2029 | 3.250 | % | 700.0 | 3.250 | % | 700.0 | |||||||||||||||||||||||||
| Senior notes due 2026 | December 2026 | 2.670 | % | 1,000.0 | 2.670 | % | 1,000.0 | |||||||||||||||||||||||||
| Senior notes due 2028 | December 2028 | 3.276 | % | 500.0 | 3.276 | % | 500.0 | |||||||||||||||||||||||||
| Senior notes due 2031 | December 2031 | 3.569 | % | 1,000.0 | 3.569 | % | 1,000.0 | |||||||||||||||||||||||||
| Total unsecured senior notes | 4,975.0 | 4,975.0 | ||||||||||||||||||||||||||||||
| Receivable financing liability | 115.4 | 179.50 | ||||||||||||||||||||||||||||||
| Other long-term obligations | 11.6 | 13.6 | ||||||||||||||||||||||||||||||
| Unamortized discounts and deferred financing fees | (36.3) | (46.0) | ||||||||||||||||||||||||||||||
| Current maturities of long-term debt | (56.3) | (102.7) | ||||||||||||||||||||||||||||||
| Total long-term debt | $ | 5,866.4 | $ | 6,755.8 |
As of December 31, 2022, the Company is in compliance with the covenants under its credit agreements and indentures.
Credit Facility
The Company has a variable rate senior unsecured revolving loan facility (the “Revolving Loan Facility”) from which it may draw tranches denominated in US dollars, British pounds or Euros. The interest rate is based on LIBOR plus a margin or an alternate base rate plus a margin, where the margin is based on the Company’s senior unsecured rating. The Revolving Loan Facility is used by the Company for borrowings, issuances of letters of credit and floorplan financing. As of December 31, 2022, the Company could have borrowed up to an additional $1.1 billion under the Revolving Loan Facility. As of December 31, 2022, the Revolving Loan Facility had less than $1 million of undrawn letters of credit and $444 million reserved for the floorplan sub-facility.
Term Loan
The senior unsecured term loan facility (the “Term Loan Facility”) has a variable interest rate. The interest rate is based on LIBOR plus a margin, where the margin is determined by the Company’s senior unsecured credit rating. During the year ended December 31, 2022, the Company prepaid $636 million on the Term Loan Facility without penalty. As a result of the prepayment, no additional mandatory payments are required on the remaining principal amount until its maturity date on December 1, 2026.
Unsecured Senior Notes
The unsecured senior notes have a fixed interest rate, which is paid semi-annually.
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
Receivable Financing
As a result of the Sirius acquisition, the Company assumed liabilities related to receivable financing. Such amounts relate to certain accounts receivable transferred to third-party companies that did not qualify as a sale under the terms of the agreements. The proceeds from these arrangements are recognized as a liability and the associated accounts receivable remains on the Consolidated Balance Sheet until the liability is settled. The Company did not execute any transfers under these agreements during the year ended December 31, 2022 and 2021.
Debt Issuances and Extinguishments
On December 1, 2021, in order to fund the acquisition of Sirius, the Company obtained permanent financing through the issuance of $1.0 billion aggregate principal amount of 2.670% Senior Notes due 2026, $500 million aggregate principal amount of 3.276% Senior Notes due 2028 and $1.0 billion aggregate principal amount of 3.569% Senior Notes due 2031. Interest on each note is payable semi-annually on June 1 and December 1 of each year, and payments commenced on June 1, 2022. The net proceeds from the issuance were used to fund the Sirius acquisition and related transaction costs.
Also on December 1, 2021, the Company entered into the Revolving Loan Facility, a new five-year $1.6 billion senior unsecured revolving loan facility. The Revolving Loan Facility replaced the senior secured asset-based revolving credit facility. On the same date, the Company also entered into the Term Loan Facility, a new five-year $1.4 billion senior unsecured term loan facility. The Term Loan Facility replaced the senior secured term loan facility. The net loss recognized on extinguishment of the senior secured facilities was insignificant for the year ended December 31, 2021.
Total Debt Maturities
A summary of total debt maturities is as follows:
| Years ending December 31, | Debt Maturities | |||||||
| 2023 | $ | 56.3 | ||||||
| 2024 | 621.5 | |||||||
| 2025 | 623.3 | |||||||
| 2026 | 1,857.9 | |||||||
| 2027 | — | |||||||
| Thereafter | 2,800.0 | |||||||
| Total debt maturities | $ | 5,959.0 |
Fair Value
The fair values of the unsecured senior notes were estimated using quoted market prices for identical liabilities that are traded in over-the-counter secondary markets. The fair value of the Term Loan Facility was estimated using dealer quotes for identical liabilities in markets that are not considered active. The unsecured senior notes and Term Loan Facility were classified as Level 2 within the fair value hierarchy. The carrying value of the Revolving Loan Facility approximates fair value.
The approximate fair values and related carrying values of the Company’s long-term debt, including current maturities and excluding unamortized discount and unamortized deferred financing costs, were as follows:
| December 31, | ||||||||||||||
| 2022 | 2021 | |||||||||||||
| Fair value | $ | 5,412.6 | $ | 6,996.0 | ||||||||||
| Carrying value | 5,959.0 | 6,904.5 |
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
10. Income Taxes
Income before income taxes was taxed under the following jurisdictions:
| Year Ended December 31, | ||||||||||||||||||||
| 2022 | 2021 | 2020 | ||||||||||||||||||
| Domestic | $ | 1,355.6 | $ | 1,186.7 | $ | 934.3 | ||||||||||||||
| Foreign | 132.2 | 111.1 | 68.0 | |||||||||||||||||
| Total | $ | 1,487.8 | $ | 1,297.8 | $ | 1,002.3 |
Components of Income tax expense (benefit) consist of the following:
| Year Ended December 31, | ||||||||||||||||||||
| 2022 | 2021 | 2020 | ||||||||||||||||||
| Current: | ||||||||||||||||||||
| Federal | $ | 281.8 | $ | 235.6 | $ | 166.5 | ||||||||||||||
| State | 75.8 | 52.9 | 49.2 | |||||||||||||||||
| Foreign | 33.9 | 27.4 | 18.3 | |||||||||||||||||
| Total current | 391.5 | 315.9 | 234.0 | |||||||||||||||||
| Deferred: | ||||||||||||||||||||
| Domestic | (15.0) | (8.7) | (18.8) | |||||||||||||||||
| Foreign | (3.2) | 2.0 | (1.4) | |||||||||||||||||
| Total deferred | (18.2) | (6.7) | (20.2) | |||||||||||||||||
| Income tax expense | $ | 373.3 | $ | 309.2 | $ | 213.8 |
The reconciliation between the statutory tax rate expressed as a percentage of income before income taxes and the effective tax rate was as follows:
| Year Ended December 31, | ||||||||||||||||||||||||||||||||||||||
| 2022 | 2021 | 2020 | ||||||||||||||||||||||||||||||||||||
| Statutory federal income tax rate | $ | 312.4 | 21.0 | % | $ | 272.5 | 21.0 | % | $ | 210.5 | 21.0 | % | ||||||||||||||||||||||||||
| State taxes, net of federal effect | 61.1 | 4.1 | 50.3 | 3.9 | 36.0 | 3.6 | ||||||||||||||||||||||||||||||||
| Excess tax benefit of equity awards | (12.0) | (0.8) | (30.1) | (2.3) | (28.8) | (2.9) | ||||||||||||||||||||||||||||||||
| Tax on foreign earnings | 3.0 | 0.2 | 1.7 | 0.1 | 1.0 | 0.1 | ||||||||||||||||||||||||||||||||
| Effect of tax law changes | — | — | 4.8 | 0.4 | (6.8) | (0.7) | ||||||||||||||||||||||||||||||||
| Other | 8.8 | 0.6 | 10.0 | 0.7 | 1.9 | 0.2 | ||||||||||||||||||||||||||||||||
| Effective tax rate | $ | 373.3 | 25.1 | % | $ | 309.2 | 23.8 | % | $ | 213.8 | 21.3 | % |
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
The tax effect of temporary differences that give rise to net deferred income tax liabilities is presented below. Reclassifications have been made to conform to current year presentation.
| December 31, | ||||||||||||||
| 2022 | 2021 | |||||||||||||
| Deferred tax assets: | ||||||||||||||
| Contract liabilities | $ | 46.3 | $ | 45.3 | ||||||||||
| Equity compensation plans | 31.3 | 22.7 | ||||||||||||
| Net operating loss and credit carryforwards, net | 17.0 | 28.9 | ||||||||||||
| Payroll and benefits | 24.3 | 37.6 | ||||||||||||
| Operating lease liabilities | 48.5 | 51.6 | ||||||||||||
| Accounts receivable | 18.1 | 18.0 | ||||||||||||
| Other | 19.5 | 20.5 | ||||||||||||
| Total deferred tax assets | 205.0 | 224.6 | ||||||||||||
| Deferred tax liabilities: | ||||||||||||||
| Acquisition-related intangibles | 293.3 | 322.2 | ||||||||||||
| Property and equipment | 38.1 | 47.6 | ||||||||||||
| Operating lease right-of-use assets | 32.9 | 35.6 | ||||||||||||
| Other | 27.1 | 26.5 | ||||||||||||
| Total deferred tax liabilities | 391.4 | 431.9 | ||||||||||||
| Deferred tax asset valuation allowance | 17.0 | 17.0 | ||||||||||||
| Net deferred tax liabilities | $ | 203.4 | $ | 224.3 |
The Company has income tax net operating losses of $5 million that do not expire and international tax credit carryforwards of $16 million, which expire in 2027.
The Company is indefinitely reinvested in its UK business, and therefore did not provide for any US deferred taxes on the earnings of the UK business. The Company is not permanently reinvested in its Canadian business and therefore has recognized deferred tax liabilities of $4 million as of December 31, 2022 related to Canada withholding taxes on earnings of its Canadian business.
In the ordinary course of business, the Company is subject to review by domestic and foreign taxing authorities, including the Internal Revenue Service (“IRS”). In general, the Company is no longer subject to audit by the IRS or state, local, or foreign taxing authorities for tax years through 2014. Various taxing authorities are in the process of auditing income tax returns of the Company and its subsidiaries. The Company does not anticipate that any adjustments from the audits would have a material impact on its Consolidated Financial Statements.
Changes in the Company’s unrecognized tax benefits as of December 31, 2022, 2021 and 2020 were as follows:
| Year Ended December 31, | ||||||||||||||||||||
| 2022 | 2021 | 2020 | ||||||||||||||||||
| Balance as of January 1 | $ | 18.4 | $ | 18.3 | $ | 17.7 | ||||||||||||||
| Additions for tax positions related to current year | 0.3 | 0.1 | 0.1 | |||||||||||||||||
| Additions for tax positions related to prior year | — | 0.5 | ||||||||||||||||||
| Balance as of December 31 | $ | 18.7 | $ | 18.4 | $ | 18.3 |
As of December 31, 2022, the Company had $19 million of unrecognized tax benefits that, if recognized, would have decreased income taxes and the corresponding effective income tax rate and increased net income. The impact of recognizing these tax benefits, net of the federal income tax benefit related to unrecognized state income tax benefits, would be approximately $15 million.
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
11. Leases
The Company has operating leases primarily for real estate, data centers and equipment. Remaining lease terms are up to 13 years.
Supplemental Consolidated Balance Sheets information related to the Company’s operating leases is as follows:
| December 31, | ||||||||||||||||||||
| Classification on the Consolidated Balance Sheets | 2022 | 2021 | ||||||||||||||||||
| Assets | ||||||||||||||||||||
| Operating lease right-of-use assets | $ | 149.2 | $ | 155.6 | ||||||||||||||||
| Liabilities | ||||||||||||||||||||
| Current | Accrued expenses and other current liabilities - Other | $ | 31.9 | $ | 31.7 | |||||||||||||||
| Long-term | Long-term operating lease liabilities | 175.2 | 184.2 | |||||||||||||||||
| Total lease liabilities | $ | 207.1 | $ | 215.9 | ||||||||||||||||
| December 31, | ||||||||||||||||||||
| Lease term and discount rate | 2022 | 2021 | ||||||||||||||||||
| Weighted average remaining lease term (years) | 8.4 | 9.0 | ||||||||||||||||||
| Weighted average discount rate | 3.86 | % | 3.81 | % | ||||||||||||||||
Operating lease expense for the years ended December 31, 2022, 2021 and 2020 was $62 million, $50 million and $53 million, respectively.
Maturities of operating lease liabilities are as follows:
| December 31, 2022 | ||||||||
| 2023 | $ | 39.4 | ||||||
| 2024 | 34.6 | |||||||
| 2025 | 32.8 | |||||||
| 2026 | 29.2 | |||||||
| 2027 | 21.9 | |||||||
| Thereafter | 91.2 | |||||||
| Total lease payments | $ | 249.1 | ||||||
| Less: Interest | (39.3) | |||||||
| Less: Lease Incentives(1) | $ | (2.7) | ||||||
| Present value of lease liabilities | $ | 207.1 |
(1) Includes lease incentives that will be realized in 2023.
Supplemental cash flow information related to operating leases is as follows:
| Year Ended December 31, | ||||||||||||||||||||
| 2022 | 2021 | 2020 | ||||||||||||||||||
| Cash paid for amounts included in the measurement of lease liabilities | ||||||||||||||||||||
| Operating cash flows from operating leases | $ | 42.8 | $ | 35.9 | $ | 35.8 | ||||||||||||||
| Right-of-use assets obtained in exchange for lease obligations | ||||||||||||||||||||
| Operating leases(1) | $ | 43.6 | $ | 49.8 | $ | 26.7 |
(1)In 2021, primarily includes right-of-use assets acquired as a result of the Sirius acquisition.
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
12. Stockholders’ Equity
Share Repurchase Program
The Company has a share repurchase program under which it may repurchase shares of its common stock from time to time in private transactions, open market purchases or other transactions as permitted by securities laws and other legal requirements. The timing and amount of any purchases will be based on market conditions and other factors including but not limited to share price, regulatory requirements and capital availability. The share repurchase program does not obligate the Company to repurchase any dollar amount or number of shares and the program may be modified, suspended or discontinued at any time.
During 2022, the Company made no share repurchases. As of December 31, 2022, the Company has $88 million remaining under this program. On February 8, 2023, the Company announced that its Board of Directors authorized a $750 million increase to the share repurchase program.
13. Equity-Based Compensation
Equity-based compensation expense, which is recorded in Selling and administrative expenses in the Consolidated Statements of Operations was as follows:
| Year Ended December 31, | ||||||||||||||||||||
| 2022 | 2021 | 2020 | ||||||||||||||||||
| Equity-based compensation expense | $ | 91.1 | $ | 72.6 | $ | 42.5 | ||||||||||||||
| Income tax benefit(1) | (15.5) | (12.2) | (7.7) | |||||||||||||||||
| Equity-based compensation expense, net of tax | $ | 75.6 | $ | 60.4 | $ | 34.8 |
(1)Represents equity-based compensation tax expense at the statutory tax rates. Excess tax benefits associated with equity awards are excluded from this disclosure and separately disclosed in Note 10 (Income Taxes).
The total unrecognized compensation cost related to non-vested awards was $106 million as of December 31, 2022 and is expected to be recognized over a weighted-average period of 1.9 years.
Long-Term Incentive Plan
During May 2021, the Company adopted the 2021 Long-Term Incentive Plan (“2021 LTIP”), which replaced the former 2013 Long-Term Incentive Plan in connection with the issuance of new equity awards (“2013 LTIP” and, together with the 2021 LTIP, the “LTIPs”). The 2021 LTIP provides for the grant of incentive stock options, nonqualified stock options, stock appreciation rights, restricted stock, restricted stock units, bonus stock and performance awards. The maximum aggregate number of shares of the Company’s common stock that may be issued under the 2021 LTIP is 22.1 million shares. As of December 31, 2022, 7.2 million shares were available for issuance under the 2021 LTIP. Authorized but unissued shares are reserved for issuance in connection with equity-based awards.
Stock Options
The exercise price of a stock option granted is equal to the fair value of the underlying stock on the date of the grant. Stock options granted under the LTIPs have a contractual term of ten years and generally vest ratably over three years. To estimate the fair value of options granted, the Company uses the Black-Scholes option pricing model. The weighted-average assumptions used to value the stock options granted were as follows:
| Year Ended December 31, | ||||||||||||||||||||
| 2022 | 2021 | 2020 | ||||||||||||||||||
| Grant date fair value | $ | 43.20 | $ | 40.83 | $ | 20.46 | ||||||||||||||
| Volatility (1) | 27.50 | % | 30.00 | % | 25.50 | % | ||||||||||||||
| Risk-free rate (2) | 1.94 | % | 0.93 | % | 0.51 | % | ||||||||||||||
| Expected dividend yield | 1.17 | % | 1.03 | % | 1.52 | % | ||||||||||||||
| Expected term (in years) (3) | 6.0 | 5.6 | 6.0 |
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
(1)Based upon an assessment of the two-year and five-year historical and implied volatility for the Company’s selected peer group, adjusted for the Company’s leverage.
(2)Based on a composite US Treasury rate.
(3)Based on contractual term length and on historical experience of both exercised and unexercised options.
Stock option activity for the year ended December 31, 2022 was as follows:
| Options | Number of Options | Weighted-Average Exercise Price | Weighted-Average Remaining Contractual Term (years) | Aggregate Intrinsic Value | ||||||||||||||||||||||
| Outstanding at January 1, 2022 | 3,355,266 | $ | 89.76 | |||||||||||||||||||||||
| Granted | 600,567 | 170.79 | ||||||||||||||||||||||||
| Forfeited/Expired | (62,713) | 140.50 | ||||||||||||||||||||||||
| Exercised(1) | (393,819) | 76.63 | ||||||||||||||||||||||||
| Outstanding at December 31, 2022 | 3,499,301 | $ | 104.23 | 6.07 | $ | 260.5 | ||||||||||||||||||||
| Vested and exercisable at December 31, 2022 | 2,256,541 | $ | 79.30 | 4.93 | $ | 224.1 | ||||||||||||||||||||
| Expected to vest after December 31, 2022 | 1,226,577 | $ | 149.35 | 8.13 | $ | 36.1 |
(1)The total intrinsic value of stock options exercised during the years ended December 31, 2022, 2021 and 2020 was $40 million, $117 million and $94 million, respectively.
Restricted Stock Units (“RSUs”)
Restricted stock units represent the right to receive unrestricted shares of the Company’s stock at the time of vesting. RSUs granted under the LTIPs vest either ratably over three years or cliff-vest at the end of three years. The fair value of RSUs is equal to the closing price of the Company’s common stock on date of grant.
RSU activity for the year ended December 31, 2022 was as follows:
| Number of Units | Weighted-Average Grant-Date Fair Value | |||||||||||||
| Non-vested at January 1, 2022 | 437,524 | $ | 163.82 | |||||||||||
| Granted (1) | 124,683 | 169.11 | ||||||||||||
| Vested (2) | (102,078) | 153.23 | ||||||||||||
| Forfeited | (28,069) | 178.12 | ||||||||||||
| Non-vested at December 31, 2022 | 432,060 | $ | 166.92 |
(1)The weighted-average grant date fair value of RSUs granted during the years ended December 31, 2022, 2021 and 2020 was $169.11, $172.96 and $112.55, respectively.
(2)The aggregate fair value of RSUs that vested during the years ended December 31, 2022, 2021 and 2020 was $16 million, $2 million and $12 million, respectively.
Performance Share Units (“PSUs”)
Performance share units represent the right to receive unrestricted shares of the Company’s stock at the time of vesting. PSUs granted under the LTIPs cliff-vest at the end of three years. The majority of the PSUs will vest between 0% to 200% of the number of PSUs granted based on the Company’s performance against a cumulative adjusted free cash flow measure and cumulative non-GAAP net income per diluted share measure over a three-year performance period.
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
PSU activity for the year ended December 31, 2022 was as follows:
| Number of Units | Weighted-Average Grant-Date Fair Value | |||||||||||||
| Non-vested at January 1, 2022 | 387,204 | $ | 123.05 | |||||||||||
| Granted (1) | 308,263 | 176.14 | ||||||||||||
| Attainment adjustment (2) | 81,573 | 96.00 | ||||||||||||
| Vested (3) | (278,115) | 100.82 | ||||||||||||
| Forfeited | (54,692) | 153.29 | ||||||||||||
| Non-vested at December 31, 2022 | 444,233 | $ | 165.11 |
(1)The weighted-average grant date fair value of PSUs granted during the years ended December 31, 2022, 2021 and 2020 was $176.14, $154.37 and $102.96, respectively.
(2)During the year ended December 31, 2022, the attainment on PSUs vested at December 31, 2021 was adjusted to reflect actual performance.
(3)The aggregate fair value of PSUs that vested during the years ended December 31, 2022, 2021 and 2020 was $28 million, $28 million and $24 million, respectively.
14. Earnings Per Share
The numerator for both basic and diluted earnings per share is Net income. The denominator for basic earnings per share is the weighted-average shares outstanding during the period.
A reconciliation of basic weighted-average shares outstanding to diluted weighted-average shares outstanding is as follows:
| Year Ended December 31, | ||||||||||||||||||||
| 2022 | 2021 | 2020 | ||||||||||||||||||
| Basic weighted-average shares outstanding | 135.2 | 138.5 | 142.6 | |||||||||||||||||
| Effect of dilutive securities (1) | 1.8 | 2.0 | 2.2 | |||||||||||||||||
| Diluted weighted-average shares outstanding (2) | 137.0 | 140.5 | 144.8 |
(1) The dilutive effect of outstanding stock options, restricted stock units, performance share units and Coworker Stock Purchase Plan (“CSPP”) units is reflected in the diluted weighted-average shares outstanding using the treasury stock method.
(2) There were fewer than 0.1 million potential common shares excluded from diluted weighted-average shares outstanding for the years ended December 31, 2022, 2021 and 2020, respectively. Inclusion of these common shares in diluted weighted average shares outstanding would have had an anti-dilutive effect.
15. Coworker Retirement and Other Compensation Benefits
Profit Sharing Plan and Other Savings Plans
The Company has a profit-sharing plan that includes a salary reduction feature established under the Internal Revenue Code Section 401(k) covering substantially all coworkers in the US. In addition, coworkers outside the US participate in other savings plans. Company contributions to the profit sharing and other savings plans are made in cash and determined at the discretion of the Board of Directors. For the years ended December 31, 2022, 2021 and 2020, the amounts expensed for these plans were $43 million, $46 million and $28 million, respectively.
CSPP
The Company has a CSPP that provides the opportunity for eligible coworkers to acquire shares of the Company’s common stock through accumulated payroll deductions at a 5% discount from the closing market price on the final day of the offering period. There is no additional compensation expense associated with the CSPP.
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
16. Commitments and Contingencies
The Company is party to various legal proceedings that arise in the ordinary course of its business, which include commercial, intellectual property, employment, tort and other litigation matters. The Company is also subject to audit by federal, state, international, national, provincial and local authorities, and by various partners, group purchasing organizations and customers, including government agencies, relating to purchases and sales under various contracts. In addition, the Company is subject to indemnification claims under various contracts. From time to time, certain customers of the Company file voluntary petitions for reorganization or liquidation under the US bankruptcy laws or similar laws of the jurisdictions for the Company’s business activities outside of the US. In such cases, certain pre-petition payments received by the Company could be considered preference items and subject to return to the bankruptcy administrator.
As of December 31, 2022, the Company does not believe that there is a reasonable possibility that any material loss exceeding the amounts already recognized for these proceedings and matters, if any, has been incurred. However, the ultimate resolutions of these proceedings and matters are inherently unpredictable. As such, the Company’s consolidated financial statements could be adversely affected in any particular period by the unfavorable resolution of one or more of these proceedings or matters.
A subsidiary of the Company received a Civil Investigative Demand dated September 20, 2021 from the Department of Justice (“DOJ”) in connection with a False Claims Act Investigation. The DOJ requested information related to teaming agreements with OEMs and the Company is cooperating with the DOJ. At this stage of the matter, the Company is unable to assess the probability of any outcome or the range of possible loss, if any.
17. Segment Information
The Company’s segment information reflects the way the chief operating decision maker uses internal reporting to evaluate business performance, allocate resources and manage operations.
The Company has three reportable segments: Corporate, which is comprised primarily of private sector business customers with more than 250 employees in the US, Small Business, primarily servicing private sector business customers with up to 250 employees in the US, and Public, which is comprised of government agencies and education and healthcare institutions in the US. The Company has two other operating segments: CDW UK and CDW Canada, both of which do not meet the reportable segment quantitative thresholds and, accordingly, are included in an all other category (“Other”).
The Company has centralized logistics and headquarters functions that provide services to the segments. The logistics function includes purchasing, distribution and fulfillment services to support the Corporate, Small Business and Public segments. As a result, costs and intercompany charges associated with the logistics function are fully allocated to all of these segments based on a percent of Net sales. The centralized headquarters function provides services in areas such as accounting, information technology, marketing, legal and coworker services. Headquarters function costs that are not allocated to the segments are included under the heading of “Headquarters” in the tables below.
Segment information for Total assets and capital expenditures is not presented, as such information is not used in measuring segment performance or allocating resources between segments.
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
Selected Segment Financial Information
Information about the Company’s segments for the years ended December 31, 2022, 2021 and 2020 is as follows:
| Corporate | Small Business | Public | Other | Headquarters | Total | |||||||||||||||||||||||||||||||||
| 2022: | ||||||||||||||||||||||||||||||||||||||
| Net sales | $ | 10,350.1 | $ | 1,938.9 | $ | 8,551.3 | $ | 2,908.4 | $ | — | $ | 23,748.7 | ||||||||||||||||||||||||||
| Operating income (loss) | 931.7 | 186.8 | 681.7 | 130.7 | (195.7) | 1,735.2 | ||||||||||||||||||||||||||||||||
| Depreciation and amortization expense | (98.0) | (6.4) | (67.9) | (31.9) | (86.4) | (290.6) | ||||||||||||||||||||||||||||||||
| 2021: | ||||||||||||||||||||||||||||||||||||||
| Net sales | $ | 8,179.7 | $ | 1,870.1 | $ | 8,183.6 | $ | 2,587.4 | $ | — | $ | 20,820.8 | ||||||||||||||||||||||||||
| Operating income (loss) | 697.3 | 167.7 | 606.7 | 115.8 | (168.5) | 1,419.0 | ||||||||||||||||||||||||||||||||
| Depreciation and amortization expense | (22.9) | (4.1) | (57.2) | (34.4) | (72.6) | (191.2) | ||||||||||||||||||||||||||||||||
| 2020: | ||||||||||||||||||||||||||||||||||||||
| Net sales | $ | 6,846.0 | $ | 1,397.1 | $ | 8,137.7 | $ | 2,086.7 | $ | — | $ | 18,467.5 | ||||||||||||||||||||||||||
| Operating income (loss) | 489.5 | 99.0 | 678.2 | 65.9 | (153.4) | 1,179.2 | ||||||||||||||||||||||||||||||||
| Depreciation and amortization expense | (73.2) | (18.3) | (229.7) | (32.5) | (71.9) | (425.6) |
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
Geographic Areas and Revenue Mix
| Year Ended December 31, 2022 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Corporate | Small Business | Public | Other | Total | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Geography**(1)** | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| United States | $ | 10,321.2 | $ | 1,934.8 | $ | 8,550.8 | $ | 21.8 | $ | 20,828.6 | |||||||||||||||||||||||||||||||||||||||||||||||||
| Rest of World | 28.9 | 4.1 | 0.5 | 2,886.6 | 2,920.1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Total Net sales | 10,350.1 | 1,938.9 | 8,551.3 | 2,908.4 | 23,748.7 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Major Product and Services | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Hardware | 7,561.0 | 1,610.7 | 6,763.9 | 2,155.4 | 18,091.0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Software | 1,781.5 | 232.9 | 1,196.9 | 473.6 | 3,684.9 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Services | 929.3 | 73.8 | 570.7 | 268.2 | 1,842.0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Other(2) | 78.3 | 21.5 | 19.8 | 11.2 | 130.8 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Total Net sales | 10,350.1 | 1,938.9 | 8,551.3 | 2,908.4 | 23,748.7 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Sales by Channel | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Corporate | 10,350.1 | — | — | — | 10,350.1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Small Business | — | 1,938.9 | — | — | 1,938.9 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Government | — | — | 2,574.3 | — | 2,574.3 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Education | — | — | 3,621.4 | — | 3,621.4 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Healthcare | — | — | 2,355.6 | — | 2,355.6 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Other | — | — | — | 2,908.4 | 2,908.4 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Total Net sales | 10,350.1 | 1,938.9 | 8,551.3 | 2,908.4 | 23,748.7 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Timing of Revenue Recognition | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Transferred at a point in time where CDW is principal | 8,971.4 | 1,751.1 | 7,717.1 | 2,576.5 | 21,016.1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Transferred at a point in time where CDW is agent | 749.3 | 140.1 | 426.9 | 97.7 | 1,414.0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Transferred over time where CDW is principal | 629.4 | 47.7 | 407.3 | 234.2 | 1,318.6 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Total Net sales | $ | 10,350.1 | $ | 1,938.9 | $ | 8,551.3 | $ | 2,908.4 | $ | 23,748.7 | |||||||||||||||||||||||||||||||||||||||||||||||||
(1)Net sales by geography is generally based on the ship-to address with the exception of certain services that may be performed at, or on behalf of, multiple locations. Such service arrangements are categorized based on the bill-to address.
(2)Includes items such as delivery charges to customers.
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
| Year Ended December 31, 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Corporate | Small Business | Public | Other | Total | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Geography**(1)** | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| United States | $ | 8,165.4 | $ | 1,870.1 | $ | 8,183.6 | $ | 19.7 | $ | 18,238.8 | |||||||||||||||||||||||||||||||||||||||||||||||||
| Rest of World | 14.3 | — | — | 2,567.7 | 2,582.0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Total Net sales | 8,179.7 | 1,870.1 | 8,183.6 | 2,587.4 | 20,820.8 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Major Product and Services | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Hardware | 6,427.9 | 1,587.9 | 6,827.1 | 1,926.7 | 16,769.6 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Software | 1,172.4 | 211.0 | 1,017.3 | 401.7 | 2,802.4 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Services | 510.1 | 49.1 | 321.5 | 245.4 | 1,126.1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Other(2) | 69.3 | 22.1 | 17.7 | 13.6 | 122.7 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Total Net sales | 8,179.7 | 1,870.1 | 8,183.6 | 2,587.4 | 20,820.8 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Sales by Channel | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Corporate | 8,179.7 | — | — | — | 8,179.7 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Small Business | — | 1,870.1 | — | — | 1,870.1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Government | — | — | 2,155.6 | — | 2,155.6 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Education | — | — | 4,108.7 | — | 4,108.7 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Healthcare | — | — | 1,919.3 | — | 1,919.3 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Other | — | — | — | 2,587.4 | 2,587.4 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Total Net sales | 8,179.7 | 1,870.1 | 8,183.6 | 2,587.4 | 20,820.8 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Timing of Revenue Recognition | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Transferred at a point in time where CDW is principal | 7,332.3 | 1,734.7 | 7,634.3 | 2,288.7 | 18,990.0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Transferred at a point in time where CDW is agent | 517.5 | 112.3 | 336.6 | 83.2 | 1,049.6 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Transferred over time where CDW is principal | 329.9 | 23.1 | 212.7 | 215.5 | 781.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Total Net sales | $ | 8,179.7 | $ | 1,870.1 | $ | 8,183.6 | $ | 2,587.4 | $ | 20,820.8 | |||||||||||||||||||||||||||||||||||||||||||||||||
(1)Net sales by geography is generally based on the ship-to address with the exception of certain services that may be performed at, or on behalf of, multiple locations. Such service arrangements are categorized based on the bill-to address.
(2)Includes items such as delivery charges to customers.
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
| Year Ended December 31, 2020 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Corporate | Small Business | Public | Other | Total | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Geography**(1)** | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| United States | $ | 6,823.6 | $ | 1,397.1 | $ | 8,137.7 | $ | 20.8 | $ | 16,379.2 | |||||||||||||||||||||||||||||||||||||||||||||||||
| Rest of World | 22.4 | — | — | 2,065.9 | 2,088.3 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Total Net sales | 6,846.0 | 1,397.1 | 8,137.7 | 2,086.7 | 18,467.5 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Major Product and Services | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Hardware | 5,289.2 | 1,156.1 | 6,844.0 | 1,544.1 | 14,833.4 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Software | 1,088.3 | 189.3 | 982.8 | 320.6 | 2,581.0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Services | 400.8 | 31.5 | 269.8 | 211.8 | 913.9 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Other(2) | 67.7 | 20.2 | 41.1 | 10.2 | 139.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Total Net sales | 6,846.0 | 1,397.1 | 8,137.7 | 2,086.7 | 18,467.5 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Sales by Channel | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Corporate | 6,846.0 | — | — | — | 6,846.0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Small Business | — | 1,397.1 | — | — | 1,397.1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Government | — | — | 2,978.5 | — | 2,978.5 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Education | — | — | 3,458.1 | — | 3,458.1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Healthcare | — | — | 1,701.1 | — | 1,701.1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Other | — | — | — | 2,086.7 | 2,086.7 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Total Net sales | 6,846.0 | 1,397.1 | 8,137.7 | 2,086.7 | 18,467.5 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Timing of Revenue Recognition | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Transferred at a point in time where CDW is principal | 6,140.7 | 1,301.3 | 7,477.4 | 1,835.5 | 16,754.9 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Transferred at a point in time where CDW is agent | 457.4 | 84.5 | 292.5 | 61.6 | 896.0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Transferred over time where CDW is principal | 247.9 | 11.3 | 367.8 | 189.6 | 816.6 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Total Net sales | $ | 6,846.0 | $ | 1,397.1 | $ | 8,137.7 | $ | 2,086.7 | $ | 18,467.5 | |||||||||||||||||||||||||||||||||||||||||||||||||
(1)Net sales by geography is generally based on the ship-to address with the exception of certain services that may be performed at, or on behalf of, multiple locations. Such service arrangements are categorized based on the bill-to address.
(2)Includes items such as delivery charges to customers.
CDW CORPORATION AND SUBSIDIARIES
NOTES TO CONSOLIDATED FINANCIAL STATEMENTS
(dollars in millions, except per share data, unless otherwise noted)
The following table presents Net sales by major category for the years ended December 31, 2022, 2021 and 2020. Categories are based upon internal classifications.
| Year Ended December 31, | |||||||||||||||||||||||||||||||||||
| 2022 | 2021 | 2020 | |||||||||||||||||||||||||||||||||
| Net Sales | Percentage of Total Net Sales | Net Sales | Percentage of Total Net Sales | Net Sales | Percentage of Total Net Sales | ||||||||||||||||||||||||||||||
| Hardware: | |||||||||||||||||||||||||||||||||||
| Notebooks/Mobile Devices | $ | 6,179.7 | 26.0 | % | $ | 6,659.4 | 32.0 | % | $ | 5,486.2 | 29.7 | % | |||||||||||||||||||||||
| Netcomm Products | 2,729.7 | 11.5 | 1,950.9 | 9.4 | 1,955.0 | 10.6 | |||||||||||||||||||||||||||||
| Desktops | 1,284.9 | 5.4 | 1,203.6 | 5.8 | 1,132.4 | 6.1 | |||||||||||||||||||||||||||||
| Video | 1,785.2 | 7.5 | 1,605.0 | 7.7 | 1,190.8 | 6.4 | |||||||||||||||||||||||||||||
| Enterprise and Data Storage (Including Drives) | 1,375.0 | 5.8 | 992.1 | 4.8 | 947.4 | 5.1 | |||||||||||||||||||||||||||||
| Other Hardware | 4,736.5 | 19.9 | 4,358.6 | 20.9 | 4,121.6 | 22.3 | |||||||||||||||||||||||||||||
| Total Hardware | 18,091.0 | 76.1 | 16,769.6 | 80.6 | 14,833.4 | 80.2 | |||||||||||||||||||||||||||||
| Software(1) | 3,684.9 | 15.5 | 2,802.4 | 13.5 | 2,581.0 | 14.0 | |||||||||||||||||||||||||||||
| Services(1) | 1,842.0 | 7.8 | 1,126.1 | 5.4 | 913.9 | 4.9 | |||||||||||||||||||||||||||||
| Other(2) | 130.8 | 0.6 | 122.7 | 0.5 | 139.2 | 0.9 | |||||||||||||||||||||||||||||
| Total Net sales | $ | 23,748.7 | 100.0 | % | $ | 20,820.8 | 100.0 | % | $ | 18,467.5 | 100.0 | % |
(1)Certain software and services revenues are recorded on a net basis for accounting purposes. As a result, the category percentage of net revenues is not representative of the category percentage of gross profits.
(2)Includes items such as delivery charges to customers.
Previous: Item 7A. Quantitative and Qualitative Disclosures of Market Risks · Next: Item 9. Changes in and Disagreements with Accountants on Accounting and Financial Disclosure