CDW Corporation (CDW) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
CDW Corporation (CDW) Bundle
Designed for accuracy, our CDW DCF Calculator enables you to evaluate CDW Corporation (CDW) valuation using real-world financial data while providing comprehensive flexibility to modify all key parameters for enhanced projections.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 18,032.4 | 18,467.5 | 20,820.8 | 23,748.7 | 21,376.0 | 22,403.5 | 23,480.4 | 24,609.1 | 25,792.0 | 27,031.8 |
| Revenue Growth, % | 0 | 2.41 | 12.74 | 14.06 | -9.99 | 4.81 | 4.81 | 4.81 | 4.81 | 4.81 |
| EBITDA | 1,371.1 | 1,588.2 | 1,642.2 | 2,018.1 | 1,947.8 | 1,868.5 | 1,958.3 | 2,052.4 | 2,151.1 | 2,254.5 |
| EBITDA, % | 7.6 | 8.6 | 7.89 | 8.5 | 9.11 | 8.34 | 8.34 | 8.34 | 8.34 | 8.34 |
| Depreciation | 260.0 | 425.0 | 191.0 | 291.0 | 270.7 | 320.5 | 335.9 | 352.0 | 368.9 | 386.7 |
| Depreciation, % | 1.44 | 2.3 | 0.91735 | 1.23 | 1.27 | 1.43 | 1.43 | 1.43 | 1.43 | 1.43 |
| EBIT | 1,111.1 | 1,163.2 | 1,451.2 | 1,727.1 | 1,677.1 | 1,548.0 | 1,622.4 | 1,700.4 | 1,782.1 | 1,867.8 |
| EBIT, % | 6.16 | 6.3 | 6.97 | 7.27 | 7.85 | 6.91 | 6.91 | 6.91 | 6.91 | 6.91 |
| Total Cash | 154.0 | 1,410.2 | 258.1 | 315.2 | 588.7 | 618.8 | 648.6 | 679.8 | 712.4 | 746.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 3,397.3 | 3,592.1 | 4,499.4 | 4,703.4 | 4,567.5 | 4,528.8 | 4,746.5 | 4,974.6 | 5,213.8 | 5,464.4 |
| Account Receivables, % | 18.84 | 19.45 | 21.61 | 19.8 | 21.37 | 20.21 | 20.21 | 20.21 | 20.21 | 20.21 |
| Inventories | 611.2 | 760.0 | 927.6 | 800.2 | 668.1 | 826.9 | 866.7 | 908.3 | 952.0 | 997.7 |
| Inventories, % | 3.39 | 4.12 | 4.46 | 3.37 | 3.13 | 3.69 | 3.69 | 3.69 | 3.69 | 3.69 |
| Accounts Payable | 1,835.0 | 2,088.4 | 3,114.2 | 2,821.3 | 2,881.0 | 2,769.0 | 2,902.1 | 3,041.6 | 3,187.9 | 3,341.1 |
| Accounts Payable, % | 10.18 | 11.31 | 14.96 | 11.88 | 13.48 | 12.36 | 12.36 | 12.36 | 12.36 | 12.36 |
| Capital Expenditure | -236.3 | -158.0 | -100.0 | -127.8 | -148.2 | -173.7 | -182.1 | -190.9 | -200.0 | -209.6 |
| Capital Expenditure, % | -1.31 | -0.85556 | -0.48029 | -0.53813 | -0.6933 | -0.77554 | -0.77554 | -0.77554 | -0.77554 | -0.77554 |
| Tax Rate, % | 23.85 | 23.85 | 23.85 | 23.85 | 23.85 | 23.85 | 23.85 | 23.85 | 23.85 | 23.85 |
| EBITAT | 862.0 | 915.1 | 1,105.5 | 1,293.8 | 1,277.1 | 1,187.3 | 1,244.3 | 1,304.2 | 1,366.8 | 1,432.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1,287.8 | 1,091.9 | 1,147.4 | 1,087.5 | 1,727.3 | 1,101.9 | 1,273.8 | 1,335.0 | 1,399.2 | 1,466.4 |
| WACC, % | 8.26 | 8.27 | 8.24 | 8.23 | 8.24 | 8.25 | 8.25 | 8.25 | 8.25 | 8.25 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 5,163.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 1,496 | |||||||||
| Terminal Value | 23,940 | |||||||||
| Present Terminal Value | 16,107 | |||||||||
| Enterprise Value | 21,270 | |||||||||
| Net Debt | 5,220 | |||||||||
| Equity Value | 16,050 | |||||||||
| Diluted Shares Outstanding, MM | 136 | |||||||||
| Equity Value Per Share | 117.76 |
What You Will Get
- Real CDW Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Evaluate various scenarios to assess CDW’s future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Real-Life CDW Data: Pre-filled with CDW Corporation’s historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
- User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.
How It Works
- Download the Template: Gain immediate access to the Excel-based CDW DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates CDW Corporation's intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation variations.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis decisions.
Why Choose This Calculator for CDW Corporation (CDW)?
- Designed for Experts: A sophisticated tool favored by financial analysts, CFOs, and business consultants.
- Accurate Data: CDW’s historical and projected financial information is preloaded for precise calculations.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Detailed, step-by-step instructions make the process straightforward.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling CDW stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for CDW.
- Consultants: Deliver professional valuation insights on CDW to clients quickly and accurately.
- Business Owners: Understand how large companies like CDW are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to CDW.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled CDW historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for CDW.
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.