Projected Income Statement: 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 123.8
Change - 27.8% 15.96% -17.27% -4.49% -3.47% 4.23% 5.08%
Free Cash Flow (FCF) 1 684.6 1,476 1,450 1,155 1,088 1,091 1,226 1,448
Change - 115.53% -1.69% -20.39% -5.77% 0.27% 12.42% 18.06%
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.1% 9.38% 9.59%
EBIT Margin (%) 7.9% 8.63% 9.54% 9.27% 8.9% 8.7% 8.91% 9.02%
EBT Margin (%) 6.23% 6.26% 6.78% 6.84% 6.37% 6.32% 6.87% 6.79%
Net margin (%) 4.75% 4.69% 5.17% 5.13% 4.76% 4.57% 5.01% 5.09%
FCF margin (%) 3.29% 6.21% 6.79% 5.5% 4.85% 4.5% 4.88% 5.6%
FCF / Net Income (%) 69.25% 132.39% 131.35% 107.13% 102.02% 98.4% 97.49% 110.16%

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.75% 51.91% 47.3%

Financial Health

        
Leverage (Debt/EBITDA) 3.79x 2.58x 2.35x 2.4x 2.36x 2.36x 2.12x 1.87x
Debt / Free cash flow 9.64x 3.8x 3.49x 4.62x 4.61x 4.77x 4.08x 3.2x

Capital Intensity

        
CAPEX / Current Assets (%) 0.48% 0.54% 0.69% 0.58% 0.52% 0.47% 0.47% 0.48%
CAPEX / EBITDA (%) 5.74% 5.88% 6.88% 5.52% 5.52% 5.12% 5% 4.99%
CAPEX / FCF (%) 14.61% 8.66% 10.22% 10.62% 10.76% 10.36% 9.61% 8.55%

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.696 10.07 10.85
Change - 15.48% -0.37% -1.6% 1.38% 7.62% 15.77% 7.74%
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 16.4x 14.2x
PBR 7.16x 6.1x
EV / Sales 0.95x 0.91x
Yield 1.79% 1.88%

EPS & Dividend



Y-o-Y evolution of P/E

 

Year-on-year evolution of the Yield

Trader
Investor
Global
Quality
ESG MSCI
A
Sell
Consensus
Buy
Mean consensus
BUY
Number of Analysts
10
Last Close Price
142.60USD
Average target price
158.89USD
Spread / Average Target
+11.42%

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Stocks
  3. CDW Stock
  4. Financials CDW Corporation
40% Discount: Identify Tomorrow's Best Investments With The Best Subscriber-Only Tools!
d
:
:
SEIZE THE OFFER!