Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
CDW Corporation logo

CDW Corporation

Sector: Technology   

Industry: Information Technology Services

243.42
 
USD
  
2.73
  
(1.13%)
Optionable: Yes  Market Cap: 32,275 M  90-day average vol: 681,997

Previous close: 240.69  Open: 240.29  Bid: 229.13  Ask: 243.42
52 week range    
162.59   
   263.37
Peers   
NSIT / 
HPQ / 
AAPL / 
SNX / 
Last updated: Friday 26th April 2024
54
MarketXLS Rank
25
Value
61
Technical
76
Quality

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Financials

CDW Cash Flow

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
(Increase) Decrease in inventories-67 M44 M-31 M-68 M17 M-47 M-153 M-71 M-151 M112 M
(Increase) Decrease in other current assets-10 M-19 M-126 M-147 M-290 M-31 M-99 M-2 M-141 M-18 M
(Increase) Decrease in other current liabilities55 M7 M69 M50 M67 M117 M248 M30 M97 M225 M
(Increase) Decrease in other working capital-209 M
(Increase) Decrease in payables146 M44 M101 M225 M232 M271 M194 M254 M375 M-260 M
(Increase) Decrease in receivables-171 M-118 M-343 M-180 M-137 M-365 M-245 M-226 M-617 M-35 M
Acquisitions-87 M-264 M-95 M-43 M-2,706 M-37 M
AssetImpairmentCharge31 M-5 M8 M
CapitalExpenditureReported47 M55 M90 M64 M81 M86 M236 M158 M100 M128 M
Cash at beginning of period38 M188 M345 M38 M264 M144 M206 M154 M1,410 M258 M
Cash at end of period188 M345 M38 M264 M144 M206 M154 M1,410 M258 M315 M
Cash flow366 M435 M376 M604 M778 M906 M1,027 M1,314 M785 M1,336 M
CashFlowFromContinuingInvestingActivities-47 M-165 M-452 M-66 M-81 M-86 M-331 M-201 M-2,770 M-164 M
ChangeInAccountPayable146 M44 M101 M225 M232 M271 M194 M254 M375 M-260 M
ChangeInPayablesAndAccruedExpense146 M44 M101 M225 M232 M271 M194 M254 M375 M-260 M
ChangeInWorkingCapital-47 M-42 M-330 M-120 M-112 M-54 M-54 M-15 M-438 M-185 M
ChangesInAccountReceivables-171 M-118 M-343 M-180 M-137 M-365 M-245 M-226 M-617 M-35 M
CommonStockDividendPaid-7 M-34 M-53 M-79 M-107 M-139 M-183 M-220 M-235 M-283 M
CommonStockPayments-200000.0-241 M-367 M-534 M-522 M-657 M-341 M-1,500 M
Current deferred income taxes-49 M-89 M-54 M
Deferred income taxes-49 M-89 M-54 M
Depreciation unreconciled9 M6 M6 M7 M5 M
DepreciationAndAmortization9 M6 M6 M7 M5 M
EarningsLossesFromEquityInvestments-1 M11 M
Effect of exchange rate changes-700000.0-2 M-3 M-7 M3 M-3 M2 M4 M100000.0-12 M
FinancingCashFlow-168 M-112 M-226 M-305 M-819 M-755 M-750 M139 M833 M-1,102 M
Free cash flow319 M380 M286 M541 M697 M820 M791 M1,156 M685 M1,208 M
GainLossOnInvestmentSecurities100000.0
IncomeTaxPaidSupplementalData-82 M-241 M-300 M-329 M-276 M-261 M-272 M-246 M-351 M-362 M
InterestPaidSupplementalData-268 M-196 M-155 M-144 M-148 M-149 M-154 M-139 M-134 M-224 M
Issuance of capital stock425 M
Issuance of debt51 M-51 M319 M-230 M
IssuanceOfCapitalStock425 M
IssuanceOfDebt-563 M-139 M-33 M-12 M-53 M-22 M112 M1,231 M4,226 M-865 M
Net cash from financing activities-168 M-112 M-226 M-305 M-819 M-755 M-750 M139 M833 M-1,102 M
Net cash from investing activities-47 M-165 M-452 M-66 M-81 M-86 M-331 M-201 M-2,770 M-164 M
Net cash from operating activities366 M435 M376 M604 M778 M906 M1,027 M1,314 M785 M1,336 M
Net change in cash & cash equivalents150 M156 M-307 M226 M-119 M62 M-52 M1,256 M-1,152 M69 M
Net income from continuing operations133 M245 M403 M424 M523 M643 M737 M789 M989 M1,115 M
NetBusinessPurchaseAndSale-87 M-264 M-95 M-43 M-2,670 M-37 M
NetCommonStockIssuance425 M-241 M-367 M-534 M-522 M-657 M-341 M-1,500 M
NetInvestmentPropertiesPurchaseAndSale-23 M-99 M-2 M
NetInvestmentPurchaseAndSale-23 M-99 M-2 M
NetIssuancePaymentsOfDebt-563 M-139 M-33 M-12 M-53 M-22 M112 M1,231 M4,226 M-865 M
NetLongTermDebtIssuance-563 M-139 M-33 M-12 M-53 M-22 M61 M1,282 M3,906 M-635 M
NetPPEPurchaseAndSale-47 M-55 M-90 M-63 M-81 M-86 M-236 M-158 M-100 M-128 M
Operating (gains) losses64 M90 M36 M2 M57 M
Other financing charges net-16 M76 M97 M143 M-125 M-71 M-21 M58 M-220 M16 M
Other investing changes net-23 M-99 M-2 M
Other non-cash items257 M225 M261 M292 M310 M317 M345 M541 M234 M406 M
Payment of cash dividends7 M34 M53 M79 M107 M139 M183 M220 M235 M283 M
ProceedsFromStockOptionExercised7 M11 M17 M23 M49 M70 M30 M
Purchase of property plant & equipment-47 M-55 M-90 M-63 M-81 M-86 M-236 M-158 M-100 M-128 M
Purchase of short term investments1,535 M1,175 M525 M1,483 M2,083 M600 M1,300 M3,918 M
PurchaseOfPPE-47 M-55 M-90 M-63 M-81 M-86 M-236 M-158 M-100 M-128 M
Repayment of debt-2,098 M-1,314 M-558 M-1,495 M-2,136 M-22 M-539 M-18 M-11 M-635 M
RepaymentOfDebt-2,161 M-1,314 M-873 M-1,834 M-3,697 M-708 M-2,933 M-1,093 M-1,312 M-3,167 M
Repurchase of capital stock-200000.0-241 M-367 M-534 M-522 M-657 M-341 M-1,500 M
Revenue per share9 M6 M6 M7 M5 M
SaleOfBusiness36 M
ShortTermDebtIssuance63 M315 M339 M1,561 M687 M2,446 M1,024 M1,620 M2,301 M
ShortTermDebtPayments-63 M-314 M-339 M-1,561 M-687 M-2,394 M-1,075 M-1,300 M-2,531 M
StockBasedCompensation47 M16 M31 M39 M44 M41 M49 M43 M73 M91 M
UnrealizedGainLossOnInvestmentSecurities2 M-3 M-500000.0
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University