DCF Tool

CDW

CDW Corp – Business to Business Electronic Markets
CDW Corporation is a leading multi-brand provider of information technology solutions to business, government, education and healthcare customers in the United States, the United Kingdom and Canada. A Fortune 500 company and member of the S&P 500 Index, CDW was founded in 1984 and employs approximately 10,000 coworkers. For the year ended December 31, 2020, the company generated Net sales over $18 billion.
Analysis Results
Intrinsic Value $306.74
Latest Price $160.20
Relative Value 48% undervalued
Thoughts on this result? Let us know.
Ad
Cash Flow (Billions)
Analysis Parameters
%
%
%
New Ticker
Ad
Analysis Details
Growth Rate Projection

An exponential growth model was fit to the past cash flow data, giving more weight to more recent years. This model determined a growth rate estimate of 15.3%.

Weighted Average Cost of Capital (WACC)

The calculated WACC is 8.1%. This value is used as the default discount rate.

Value of Future Flows

Assuming a growth rate of 15.3%, the cash flows for the next 5 years are projected.

The present value of each year's flow is adjusted to present value using the discount rate.

Year Future flow (billion) Present value (billion)
2022 1.72 1.6
2023 1.99 1.7
2024 2.29 1.82
2025 2.65 1.94
2026 3.05 2.07
Terminal Value

Assuming a growth rate after the projection years of 2.0%, the terminal value of the company would be 51.4 billion. This corresponds to a present value of 32.3 billion.

Intrinsic Value Per Share

The total present value of the projected cash flows is 9.13 billion. Adding in the terminal value gives a total present value of 41.4 billion.

There are presently 135.0 million outstanding shares, so the intrinsic value per share is 306.74.

Financial Statements

The following data was to determine the past cash flows.

Current Assets 6,478,100,000
Current Cash 258,100,000
Current Liabilities 5,096,000,000
Current Debt 102,700,000
Non-Cash Working Capital (NCWC) 1,226,700,000
Change in NCWC 510,800,000
EBIT 1,419,000,000
Tax Provision 309,200,000
Depreciation and Amortization 191,200,000
Capital Expenditure -100,000,000
Unlevered Free Cash Flow 1,682,924,179
Current Assets 5,953,500,000
Current Cash 1,410,200,000
Current Liabilities 3,898,300,000
Current Debt 70,900,000
Non-Cash Working Capital (NCWC) 715,900,000
Change in NCWC -6,900,000
EBIT 1,179,200,000
Tax Provision 213,800,000
Depreciation and Amortization 425,600,000
Capital Expenditure -158,000,000
Unlevered Free Cash Flow 1,188,365,569
Current Assets 4,334,100,000
Current Cash 154,000,000
Current Liabilities 3,491,400,000
Current Debt 34,100,000
Non-Cash Working Capital (NCWC) 722,800,000
Change in NCWC -90,400,000
EBIT 1,133,600,000
Tax Provision 212,900,000
Depreciation and Amortization 267,100,000
Capital Expenditure -236,300,000
Unlevered Free Cash Flow 819,874,023
Current Assets 3,796,800,000
Current Cash 205,800,000
Current Liabilities 2,803,100,000
Current Debt 25,300,000
Non-Cash Working Capital (NCWC) 813,200,000
Change in NCWC 68,400,000
EBIT 987,300,000
Tax Provision 197,500,000
Depreciation and Amortization 265,600,000
Capital Expenditure -86,100,000
Unlevered Free Cash Flow 1,003,205,056
Current Assets 3,378,100,000
Current Cash 144,200,000
Current Liabilities 2,514,600,000
Current Debt 25,500,000
Non-Cash Working Capital (NCWC) 744,800,000
Change in NCWC 32,600,000
EBIT 866,100,000
Tax Provision 137,300,000
Depreciation and Amortization 260,900,000
Capital Expenditure -81,100,000
Unlevered Free Cash Flow 898,406,815
Current Assets 3,238,100,000
Current Cash 263,700,000
Current Liabilities 2,280,700,000
Current Debt 18,500,000
Non-Cash Working Capital (NCWC) 712,200,000
Change in NCWC -180,900,000
EBIT 819,200,000
Tax Provision 248,000,000
Depreciation and Amortization 254,500,000
Capital Expenditure -63,500,000
Unlevered Free Cash Flow 527,156,038
Current Assets 2,790,800,000
Current Cash 37,600,000
Current Liabilities 1,887,300,000
Current Debt 27,200,000
Non-Cash Working Capital (NCWC) 893,100,000
Change in NCWC 236,800,000
EBIT 742,000,000
Tax Provision 243,900,000
Depreciation and Amortization 227,400,000
Capital Expenditure -90,100,000
Unlevered Free Cash Flow 836,387,789
Current Assets 2,453,400,000
Current Cash 344,500,000
Current Liabilities 1,468,000,000
Current Debt 15,400,000
Non-Cash Working Capital (NCWC) 656,300,000
Change in NCWC -11,900,000
EBIT 673,000,000
Tax Provision 142,800,000
Depreciation and Amortization 207,900,000
Capital Expenditure -55,000,000
Unlevered Free Cash Flow 566,116,584
Current Assets 2,213,500,000
Current Cash 188,100,000
Current Liabilities 1,402,600,000
Current Debt 45,400,000
Non-Cash Working Capital (NCWC) 668,200,000
Change in NCWC -400,000
EBIT 508,600,000
Tax Provision 62,700,000
Depreciation and Amortization 208,200,000
Capital Expenditure -47,100,000
Unlevered Free Cash Flow 506,183,785
Current Assets 1,814,800,000
Current Cash 37,900,000
Current Liabilities 1,148,300,000
Current Debt 40,000,000
Non-Cash Working Capital (NCWC) 668,600,000
Change in NCWC 29,400,000
EBIT 510,600,000
Tax Provision 67,100,000
Depreciation and Amortization 210,200,000
Capital Expenditure -41,400,000
Unlevered Free Cash Flow 524,698,656

This analysis is provided for informational purposes only and does not constitute financial or investing advice. For more information on the advantages and limitations of DCF analysis see background. This information is provided on an "as is" basis. No warranty, expressed or implied, is made regarding accuracy, adequacy, completeness, legality, reliability or usefulness of any information. By using this site you agree that under no circumstances shall Valuation Tools LLC be held liable for any loss or damage caused by information obtained from this website including any articles, data, videos, its social media accounts, or any other materials.