CDW CORP (CDW) | Jive Data

Import this data to Google Sheets with:

=jivedata("CDW","financials")

Full statements spill as a table. For one cell: =jivedata("CDW","Revenue") or =jivedata("CDW","Revenue","TTM"). Install the Jive Data add-on, then paste into a cell.

CDW CORP

CDW • CIK 0001402057

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Revenue from Contract with Customer, Excluding Assessed Tax	$21,376,000	$20,998,700	$22,424,100	$23,500,400
Cost of Goods and Services Sold	$16,723,600	$16,396,300	$17,550,700	$18,480,700
Gross Profit	$4,652,400	$4,602,400	$4,873,400	$5,019,700
Selling, General and Administrative Expense	$2,971,500	$2,951,100	$3,217,800	$3,341,100
Operating Income (Loss)	$1,680,900	$1,651,300	$1,655,600	$1,678,600
Interest Income (Expense), Nonoperating, Net	—	$-214,500	$-227,400	$-229,000
Other Nonoperating Income (Expense)	$-4,100	$-1,400	$-800	$800
Income (Loss) from Continuing Operations before Income Taxes, Noncontrolling Interest	$1,450,200	$1,435,400	$1,427,400	$1,450,400
Income Tax Expense (Benefit)	$345,900	$357,600	$360,800	$370,100
Net Income (Loss) Attributable to Parent	$1,104,300	$1,077,800	$1,066,600	$1,080,300
Weighted Average Number of Shares Outstanding, Basic	134,600,000	133,800,000	131,300,000	127,200,000
Weighted Average Number of Shares Outstanding, Diluted	136,300,000	135,200,000	132,100,000	127,600,000
Weighted Average Number Diluted Shares Outstanding Adjustment	1,700,000	1,400,000	800,000	400,000
Antidilutive Securities Excluded from Computation of Earnings Per Share, Amount	200,000	200,000	300,000	800,000

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Cash and Cash Equivalents, at Carrying Value	$588,700	$503,500	$618,700	$361,800
Short-term Investments	—	$214,200	$0	$0
Operating Lease, Right-of-Use Asset	$128,800	$120,200	$136,700	$128,200
Accounts Receivable, after Allowance for Credit Loss, Current	$4,567,500	$5,135,800	$6,312,400	$7,343,700
Property, Plant and Equipment, Net	$195,500	$192,000	$171,500	$166,000
Inventory, Net	$668,100	$605,300	$563,400	$981,800
Goodwill	$4,413,400	$4,620,400	$4,662,300	$4,652,100
Other Receivables, Net, Current	$470,500	$509,900	$554,000	$546,800
Intangible Assets, Net (Excluding Goodwill)	$1,369,700	$1,356,600	$1,186,400	$1,095,700
Prepaid Expense and Other Assets, Current	$410,200	$404,400	$452,000	$446,400
Assets, Current	$6,705,000	$7,373,100	$8,500,500	$9,680,500
Assets	$13,284,600	$14,678,400	$16,028,200	$17,254,800
Accounts Payable, Trade, Current	$2,881,000	$3,381,300	$4,220,100	$5,117,400
Long-term Debt, Current Maturities	$613,100	$235,800	$1,007,500	$1,008,900
Contract with Customer, Liability, Current	$487,400	$491,000	$534,000	$576,600
Liabilities, Current	$5,442,000	$5,474,400	$7,226,100	$8,296,400
Long-term Debt, Excluding Current Maturities	$5,031,800	$5,607,000	$4,622,300	$4,808,100
Deferred Income Tax Liabilities, Net	$171,400	$167,400	$171,800	$162,300
Operating Lease, Liability, Noncurrent	$164,000	$149,100	$157,800	$147,300
Accounts Payable and Accrued Liabilities, Noncurrent	—	$927,800	$1,244,100	$1,398,600
Liabilities, Noncurrent	$5,800,100	$6,851,300	$6,196,000	$6,516,300
Preferred Stock, Value, Issued	$0	$0	$0	$0
Common Stock, Value, Issued	$1,300	$1,300	$1,300	$1,200
Additional Paid in Capital, Common Stock	$3,691,300	$3,834,400	$3,978,500	$4,052,900
Retained Earnings (Accumulated Deficit)	$-1,525,500	$-1,322,900	$-1,273,900	$-1,488,900
Accumulated Other Comprehensive Income (Loss), Net of Tax	$-124,600	$-160,100	$-99,800	$-123,100
Stockholders' Equity Attributable to Parent	$2,042,500	$2,352,700	$2,606,100	$2,442,100
Employee-related Liabilities, Current	$303,000	$275,800	$318,800	$295,300
Accrued Advertising, Current	$119,900	$137,700	$176,100	$228,100
Sales and Excise Tax Payable, Current	$52,400	$61,600	$82,900	$78,100
Other Accrued Liabilities, Current	$554,300	$536,000	$534,100	$526,800
Accounts Receivable, Allowance for Credit Loss, Current	$28,800	$43,300	$65,200	$68,400
Preferred Stock, Shares Authorized	100,000,000	100,000,000	100,000,000	100,000,000
Preferred Stock, Shares Issued	0	0	0	0
Common Stock, Shares Authorized	1,000,000,000	1,000,000,000	1,000,000,000	1,000,000,000
Common Stock, Shares, Outstanding	134,100,000	132,600,000	129,400,000	125,300,000
Operating Lease, Liability, Current	$34,000	$32,200	$32,900	$32,900
Operating Lease, Liability	$198,000	$181,300	$190,700	$190,700

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Net Income (Loss) Attributable to Parent	$1,104,300	$1,077,800	$1,066,600	$1,080,300
Effect of Exchange Rate on Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$3,100	$-12,200	$20,300	$-15,200
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Period Increase (Decrease), Including Exchange Rate Effect	$273,500	$-81,000	$111,200	$-118,100
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$588,700	$507,700	$618,900	$723,200
Depreciation, Amortization and Accretion, Net	$270,700	$275,300	$295,600	$297,600
Payments to Acquire Property, Plant, and Equipment	$148,200	$122,600	$117,100	$121,600
Share-based Payment Arrangement, Expense	$93,700	$64,700	$83,600	$89,800
Payments for (Proceeds from) Short-term Investments	—	—	$-211,100	$-211,100
Increase (Decrease) in Deferred Income Taxes	$32,700	$14,100	$-1,300	$-22,200
Payments to Acquire Businesses, Net of Cash Acquired	$76,400	$323,900	$21,500	$16,800
Accounts Receivable, Credit Loss Expense (Reversal)	$14,900	$32,200	$37,200	$35,200
Payments for (Proceeds from) Other Investing Activities	$5,000	$1,600	$2,300	$4,800
Other Operating Activities, Cash Flow Statement	$29,000	$4,100	$7,200	$11,100
Net Cash Provided by (Used in) Investing Activities	$-229,600	$-659,200	$70,200	$-143,200
Net Cash Provided by (Used in) Operating Activities	$1,598,700	$1,277,300	$1,205,200	$981,800
Proceeds from Lines of Credit	$207,600	$294,200	$2,604,400	$4,695,800
Repayments of Lines of Credit	$282,000	$294,200	$2,604,400	$4,520,800
Proceeds from Issuance of Long-term Debt	$0	$1,197,800	$592,500	$592,500
Repayments of Long-term Debt	$150,000	$0	$211,100	$0
Payment for Debt Extinguishment or Debt Prepayment Cost	$0	$962,400	$593,500	$593,500
Payments for Repurchase of Common Stock	$500,000	$500,000	$653,000	$847,600
Proceeds from Stock Options Exercised	$49,300	$47,000	$29,500	$14,000
Payment, Tax Withholding, Share-based Payment Arrangement	$40,000	$38,200	$26,100	$17,500
Payments of Ordinary Dividends, Common Stock	$321,500	$332,100	$328,600	$324,400
Proceeds from (Payments for) Other Financing Activities	$22,700	$24,200	$8,400	$13,900
Net Cash Provided by (Used in) Financing Activities	$-1,098,700	$-686,900	$-1,184,500	$-941,500
Interest Paid, Excluding Capitalized Interest, Operating Activities	$233,200	$217,500	$234,300	$230,800
Income Taxes Paid, Net	$401,400	$398,600	$326,000	$364,900
Increase (Decrease) in Accounts Receivable	$54,500	$559,400	$1,166,500	$1,770,400
Increase (Decrease) in Inventories	$-139,000	$-61,100	$-48,200	$222,800
Increase (Decrease) in Other Operating Assets	$-183,300	$605,300	$390,100	$299,700
Increase (Decrease) in Accounts Payable, Trade	$-55,400	$443,800	$815,400	$1,326,900
Increase (Decrease) in Other Operating Liabilities	$-93,600	$497,100	$406,700	$411,600

Loading financial statements…

Import this data to Google Sheets with:

=jivedata("CDW","financials")

Full statements spill as a table. For one cell: =jivedata("CDW","Revenue") or =jivedata("CDW","Revenue","TTM"). Install the Jive Data add-on, then paste into a cell.

CDW CORP

CDW • CIK 0001402057

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Revenue from Contract with Customer, Excluding Assessed Tax	$21,376,000	$20,998,700	$22,424,100	$23,500,400
Cost of Goods and Services Sold	$16,723,600	$16,396,300	$17,550,700	$18,480,700
Gross Profit	$4,652,400	$4,602,400	$4,873,400	$5,019,700
Selling, General and Administrative Expense	$2,971,500	$2,951,100	$3,217,800	$3,341,100
Operating Income (Loss)	$1,680,900	$1,651,300	$1,655,600	$1,678,600
Interest Income (Expense), Nonoperating, Net	—	$-214,500	$-227,400	$-229,000
Other Nonoperating Income (Expense)	$-4,100	$-1,400	$-800	$800
Income (Loss) from Continuing Operations before Income Taxes, Noncontrolling Interest	$1,450,200	$1,435,400	$1,427,400	$1,450,400
Income Tax Expense (Benefit)	$345,900	$357,600	$360,800	$370,100
Net Income (Loss) Attributable to Parent	$1,104,300	$1,077,800	$1,066,600	$1,080,300
Weighted Average Number of Shares Outstanding, Basic	134,600,000	133,800,000	131,300,000	127,200,000
Weighted Average Number of Shares Outstanding, Diluted	136,300,000	135,200,000	132,100,000	127,600,000
Weighted Average Number Diluted Shares Outstanding Adjustment	1,700,000	1,400,000	800,000	400,000
Antidilutive Securities Excluded from Computation of Earnings Per Share, Amount	200,000	200,000	300,000	800,000

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Cash and Cash Equivalents, at Carrying Value	$588,700	$503,500	$618,700	$361,800
Short-term Investments	—	$214,200	$0	$0
Operating Lease, Right-of-Use Asset	$128,800	$120,200	$136,700	$128,200
Accounts Receivable, after Allowance for Credit Loss, Current	$4,567,500	$5,135,800	$6,312,400	$7,343,700
Property, Plant and Equipment, Net	$195,500	$192,000	$171,500	$166,000
Inventory, Net	$668,100	$605,300	$563,400	$981,800
Goodwill	$4,413,400	$4,620,400	$4,662,300	$4,652,100
Other Receivables, Net, Current	$470,500	$509,900	$554,000	$546,800
Intangible Assets, Net (Excluding Goodwill)	$1,369,700	$1,356,600	$1,186,400	$1,095,700
Prepaid Expense and Other Assets, Current	$410,200	$404,400	$452,000	$446,400
Assets, Current	$6,705,000	$7,373,100	$8,500,500	$9,680,500
Assets	$13,284,600	$14,678,400	$16,028,200	$17,254,800
Accounts Payable, Trade, Current	$2,881,000	$3,381,300	$4,220,100	$5,117,400
Long-term Debt, Current Maturities	$613,100	$235,800	$1,007,500	$1,008,900
Contract with Customer, Liability, Current	$487,400	$491,000	$534,000	$576,600
Liabilities, Current	$5,442,000	$5,474,400	$7,226,100	$8,296,400
Long-term Debt, Excluding Current Maturities	$5,031,800	$5,607,000	$4,622,300	$4,808,100
Deferred Income Tax Liabilities, Net	$171,400	$167,400	$171,800	$162,300
Operating Lease, Liability, Noncurrent	$164,000	$149,100	$157,800	$147,300
Accounts Payable and Accrued Liabilities, Noncurrent	—	$927,800	$1,244,100	$1,398,600
Liabilities, Noncurrent	$5,800,100	$6,851,300	$6,196,000	$6,516,300
Preferred Stock, Value, Issued	$0	$0	$0	$0
Common Stock, Value, Issued	$1,300	$1,300	$1,300	$1,200
Additional Paid in Capital, Common Stock	$3,691,300	$3,834,400	$3,978,500	$4,052,900
Retained Earnings (Accumulated Deficit)	$-1,525,500	$-1,322,900	$-1,273,900	$-1,488,900
Accumulated Other Comprehensive Income (Loss), Net of Tax	$-124,600	$-160,100	$-99,800	$-123,100
Stockholders' Equity Attributable to Parent	$2,042,500	$2,352,700	$2,606,100	$2,442,100
Employee-related Liabilities, Current	$303,000	$275,800	$318,800	$295,300
Accrued Advertising, Current	$119,900	$137,700	$176,100	$228,100
Sales and Excise Tax Payable, Current	$52,400	$61,600	$82,900	$78,100
Other Accrued Liabilities, Current	$554,300	$536,000	$534,100	$526,800
Accounts Receivable, Allowance for Credit Loss, Current	$28,800	$43,300	$65,200	$68,400
Preferred Stock, Shares Authorized	100,000,000	100,000,000	100,000,000	100,000,000
Preferred Stock, Shares Issued	0	0	0	0
Common Stock, Shares Authorized	1,000,000,000	1,000,000,000	1,000,000,000	1,000,000,000
Common Stock, Shares, Outstanding	134,100,000	132,600,000	129,400,000	125,300,000
Operating Lease, Liability, Current	$34,000	$32,200	$32,900	$32,900
Operating Lease, Liability	$198,000	$181,300	$190,700	$190,700

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Net Income (Loss) Attributable to Parent	$1,104,300	$1,077,800	$1,066,600	$1,080,300
Effect of Exchange Rate on Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$3,100	$-12,200	$20,300	$-15,200
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Period Increase (Decrease), Including Exchange Rate Effect	$273,500	$-81,000	$111,200	$-118,100
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$588,700	$507,700	$618,900	$723,200
Depreciation, Amortization and Accretion, Net	$270,700	$275,300	$295,600	$297,600
Payments to Acquire Property, Plant, and Equipment	$148,200	$122,600	$117,100	$121,600
Share-based Payment Arrangement, Expense	$93,700	$64,700	$83,600	$89,800
Payments for (Proceeds from) Short-term Investments	—	—	$-211,100	$-211,100
Increase (Decrease) in Deferred Income Taxes	$32,700	$14,100	$-1,300	$-22,200
Payments to Acquire Businesses, Net of Cash Acquired	$76,400	$323,900	$21,500	$16,800
Accounts Receivable, Credit Loss Expense (Reversal)	$14,900	$32,200	$37,200	$35,200
Payments for (Proceeds from) Other Investing Activities	$5,000	$1,600	$2,300	$4,800
Other Operating Activities, Cash Flow Statement	$29,000	$4,100	$7,200	$11,100
Net Cash Provided by (Used in) Investing Activities	$-229,600	$-659,200	$70,200	$-143,200
Net Cash Provided by (Used in) Operating Activities	$1,598,700	$1,277,300	$1,205,200	$981,800
Proceeds from Lines of Credit	$207,600	$294,200	$2,604,400	$4,695,800
Repayments of Lines of Credit	$282,000	$294,200	$2,604,400	$4,520,800
Proceeds from Issuance of Long-term Debt	$0	$1,197,800	$592,500	$592,500
Repayments of Long-term Debt	$150,000	$0	$211,100	$0
Payment for Debt Extinguishment or Debt Prepayment Cost	$0	$962,400	$593,500	$593,500
Payments for Repurchase of Common Stock	$500,000	$500,000	$653,000	$847,600
Proceeds from Stock Options Exercised	$49,300	$47,000	$29,500	$14,000
Payment, Tax Withholding, Share-based Payment Arrangement	$40,000	$38,200	$26,100	$17,500
Payments of Ordinary Dividends, Common Stock	$321,500	$332,100	$328,600	$324,400
Proceeds from (Payments for) Other Financing Activities	$22,700	$24,200	$8,400	$13,900
Net Cash Provided by (Used in) Financing Activities	$-1,098,700	$-686,900	$-1,184,500	$-941,500
Interest Paid, Excluding Capitalized Interest, Operating Activities	$233,200	$217,500	$234,300	$230,800
Income Taxes Paid, Net	$401,400	$398,600	$326,000	$364,900
Increase (Decrease) in Accounts Receivable	$54,500	$559,400	$1,166,500	$1,770,400
Increase (Decrease) in Inventories	$-139,000	$-61,100	$-48,200	$222,800
Increase (Decrease) in Other Operating Assets	$-183,300	$605,300	$390,100	$299,700
Increase (Decrease) in Accounts Payable, Trade	$-55,400	$443,800	$815,400	$1,326,900
Increase (Decrease) in Other Operating Liabilities	$-93,600	$497,100	$406,700	$411,600

CDW CORP

Consolidated Statements of Operations

Consolidated Balance Sheets

Consolidated Statements of Cash Flows

CDW CORP

Consolidated Statements of Operations

Consolidated Balance Sheets

Consolidated Statements of Cash Flows