investorscraft@gmail.com

Investor's Craft

S&P 500 Health CareS&P 500 EnergyS&P 500 Information Tech.S&P 500 Communic. ServicesS&P 500 Consumer Discret.S&P 500 Consumer StaplesS&P 500 IndustrialsS&P 500 Materials
IntroductionThe concept of valuationRevenue and revenue growthVariable costsFixed costsProduction assets

Intrinsic value of CDW Corporation (CDW)

Previous Close$193.29
Intrinsic Value$30.43
Upside potential  -84%
Previous Close
$193.29
Intrinsic Value
$30.43
Potential        
-84%

VALUATION INPUT DATA (original, your and others' valuations)

ParameterOrig.Your
Date of valuation (DoV)  
Intrinsic value (IV) at DoV, $/sh  
IV at current val. algorithm, $/sh30.43 30.43

The original valuation is based on fiscal year data as of 2021-12-31 and quarterly data as of 2022-09-30.

Registered users can save their valuation input data

  1. Annual
  2. Quarterly YoY
  3. Quarterly QoQ

Annual revenue growth rates, % (past and forecasted)

NOTE: The bar chart shows historic and forecasted yearly revenue growth rates. Its purpose is to help you in determining what initial revenue rate you want to base your stock valuation on. Please make sure that you are confident in the value you select - for most stocks it is by far the most important parameter in valuation.

Company description

CDW Corporation provides information technology (IT) solutions in the United States, the United Kingdom, and Canada. It operates through three segments: Corporate, Small Business, and Public. The company offers discrete hardware and software products and services, as well as integrated IT solutions, including on-premise, hybrid, and cloud capabilities across data center and networking, digital workspace, and security. Its hardware products comprise notebooks/mobile devices, network communications, desktop computers, video monitors, enterprise and data storage, and others; and software products consists of application suites, security, virtualization, operating systems, and network management. The company also provides advisory and design, software development, implementation, managed, professional, configuration, and telecom services, as well as warranties; mission critical software, systems, and network solutions; and implementation and installation, and repair services to its customers through various third-party service providers. It serves government, education, and healthcare customers; and small, medium, and large business customers. The company was founded in 1984 and is headquartered in Vernon Hills, Illinois.

show cash flow forecast

FINANCIAL STATEMENTS FORECAST and PRESENT VALUE CALCULATION

Fiscal year2021(a)2022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046

INCOME STATEMENT

Revenue growth rate, %12.7NaN
Revenue, $20821NaN
Variable operating expenses, $mNaN
Fixed operating expenses, $mNaN
Total operating expenses, $m19402NaN
Operating income, $m1419NaN
EBITDA, $m1610NaN
Interest expense (income), $mNaN
Earnings before tax, $m1298NaN
Tax expense, $m309NaN
Net income, $m989NaN

BALANCE SHEET

Cash and short-term investments, $m258NaN
Total assets, $m13199NaN
Adjusted assets (=assets-cash), $m12941NaN
Average production assets, $m4712NaN
Working capital, $m1382NaN
Total debt, $m6859NaN
Total liabilities, $m12494NaN
Total equity, $m706NaN
Debt-to-equity ratio9.719NaN
Adjusted equity ratio0.043NaN

CASH FLOW

Net income, $m989NaN
Depreciation, amort., depletion, $m191NaN
Funds from operations, $mNaN
Change in working capital, $mNaN
Cash from operations, $m785NaN
Maintenance CAPEX, $mNaN
New CAPEX, $mNaN
Total CAPEX, $m-100NaN
Free cash flow, $m885NaN
Issuance/(repurchase) of shares, $mNaN
Retained Cash Flow, $mNaN
Pot'l extraordinary dividend, $m1382
Cash available for distribution, $mNaN
Discount rate, %NaN
PV of cash for distribution, $mNaN
Current shareholders' claim on cash, %NaN
HomeMenuAccount