Projected Income Statement: CDW Corporation

Forecast Balance Sheet: CDW Corporation

Forecast Balance Sheet - CDW Corporation
Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 6,600 5,608 5,056 5,339 5,011 5,209 5,005 4,627
Change - -15.03% -9.84% 5.6% -6.14% 3.95% -3.92% -7.55%
Announcement Date 09/02/22 08/02/23 07/02/24 05/02/25 04/02/26 - - -
1USD in Million
Estimates

Cash Flow Forecast: CDW Corporation

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 100 127.8 148.2 122.6 117.1 113 117.8 120.9
Change - 27.8% 15.96% -17.27% -4.49% -3.47% 4.23% 2.59%
Free Cash Flow (FCF) 1 684.6 1,476 1,450 1,155 1,088 1,098 1,244 1,432
Change - 115.53% -1.69% -20.39% -5.77% 0.86% 13.3% 15.12%
Announcement Date 09/02/22 08/02/23 07/02/24 05/02/25 04/02/26 - - -
1USD in Million
Estimates

Forecast Financial Ratios: CDW Corporation

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028

Profitability

        
EBITDA Margin (%) 8.37% 9.15% 10.08% 10.58% 9.47% 9.11% 9.4% 9.59%
EBIT Margin (%) 7.9% 8.63% 9.54% 9.27% 8.9% 8.69% 8.89% 8.93%
EBT Margin (%) 6.23% 6.26% 6.78% 6.84% 6.37% 6.34% 6.94% 7.19%
Net margin (%) 4.75% 4.69% 5.17% 5.13% 4.76% 4.57% 5.01% 5.24%
FCF margin (%) 3.29% 6.21% 6.79% 5.5% 4.85% 4.52% 4.93% 5.46%
FCF / Net Income (%) 69.25% 132.39% 131.35% 107.13% 102.02% 98.74% 98.31% 104.14%

Profitability

        
ROA 9.93% 10.19% 10.19% 9.21% 8.62% 8.33% 8.66% 8.93%
ROE 111.73% 116.2% 73.85% 58.57% 52.17% 52.83% 52.01% 47.38%

Financial Health

        
Leverage (Debt/EBITDA) 3.79x 2.58x 2.35x 2.4x 2.36x 2.35x 2.11x 1.84x
Debt / Free cash flow 9.64x 3.8x 3.49x 4.62x 4.61x 4.75x 4.02x 3.23x

Capital Intensity

        
CAPEX / Current Assets (%) 0.48% 0.54% 0.69% 0.58% 0.52% 0.47% 0.47% 0.46%
CAPEX / EBITDA (%) 5.74% 5.88% 6.88% 5.52% 5.52% 5.11% 4.96% 4.81%
CAPEX / FCF (%) 14.61% 8.66% 10.22% 10.62% 10.76% 10.3% 9.48% 8.44%

Items per share

        
Cash flow per share 1 5.584 11.7 11.73 9.448 9.123 9.618 10.71 -
Change - 109.57% 0.23% -19.45% -3.43% 5.42% 11.4% -
Dividend per Share 1 1.8 2.09 2.39 2.485 2.505 2.55 2.683 2.749
Change - 16.11% 14.35% 3.97% 0.8% 1.79% 5.22% 2.46%
Book Value Per Share 1 5.235 11.67 15.23 17.68 20.14 19.93 23.36 28.23
Change - 122.9% 30.53% 16.05% 13.94% -1.04% 17.22% 20.86%
EPS 1 7.04 8.13 8.1 7.97 8.08 8.718 10.12 11.26
Change - 15.48% -0.37% -1.6% 1.38% 7.9% 16.12% 11.24%
Nbr of stocks (in thousands) 135,723 135,391 133,960 133,264 130,194 125,017 125,017 125,017
Announcement Date 09/02/22 08/02/23 07/02/24 05/02/25 04/02/26 - - -
1USD
Estimates
2026 *2027 *
P/E 18.9x 16.3x
PBR 8.29x 7.07x
EV / Sales 1.06x 1.02x
Yield 1.54% 1.62%

EPS & Dividend

EPS & Dividend - CDW Corporation


Y-o-Y evolution of P/E

Valuation ratios - P/E - CDW Corporation
 

Year-on-year evolution of the Yield

Valuation ratios - Yield - CDW Corporation
Trader
Investor
Global
Quality
ESG MSCI
A
MarketScreener Ratings - CDW Corporation
Sell
Consensus
Buy
Mean consensus
BUY
Number of Analysts
10
Last Close Price
165.20USD
Average target price
159.11USD
Spread / Average Target
-3.69%

Quarterly revenue - Rate of surprise

Rate of surprise - Net sales - Quarterly - CDW Corporation
  1. Stock Market
  2. Stocks
  3. CDW Stock
  4. Financials CDW Corporation