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,533 5,210 4,637
Change - -15.03% -9.84% 5.6% -6.14% 10.41% -5.84% -11%
Announcement Date 2/9/22 A 2/8/23 A 2/7/24 A 2/5/25 A 2/4/26 A - - -
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 109.9 119.5 125.2
Change - 27.8% 15.96% -17.27% -4.49% -6.15% 8.73% 4.74%
Free Cash Flow (FCF) 1 684.6 1,476 1,450 1,155 1,088 1,146 1,298 1,468
Change - 115.53% -1.69% -20.39% -5.77% 5.32% 13.26% 13.1%
Announcement Date 2/9/22 A 2/8/23 A 2/7/24 A 2/5/25 A 2/4/26 A - - -
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% 8.98% 9.41% 9.61%
EBIT Margin (%) 7.9% 8.63% 9.54% 9.27% 8.9% 8.66% 8.87% 8.96%
EBT Margin (%) 6.23% 6.26% 6.78% 6.84% 6.37% 6.04% 6.69% 6.99%
Net margin (%) 4.75% 4.69% 5.17% 5.13% 4.76% 4.41% 4.8% 5.18%
FCF margin (%) 3.29% 6.21% 6.79% 5.5% 4.85% 4.53% 4.86% 5.28%
FCF / Net Income (%) 69.25% 132.39% 131.35% 107.13% 102.02% 102.83% 101.17% 101.8%

Profitability

        
ROA 9.93% 10.19% 10.19% 9.21% 8.62% 8.23% 8.06% 8.3%
ROE 111.73% 116.2% 73.85% 58.57% 52.17% 53.96% 52.61% 47.02%

Financial Health

        
Leverage (Debt/EBITDA) 3.79x 2.58x 2.35x 2.4x 2.36x 2.44x 2.07x 1.73x
Debt / Free cash flow 9.64x 3.8x 3.49x 4.62x 4.61x 4.83x 4.01x 3.16x

Capital Intensity

        
CAPEX / Current Assets (%) 0.48% 0.54% 0.69% 0.58% 0.52% 0.43% 0.45% 0.45%
CAPEX / EBITDA (%) 5.74% 5.88% 6.88% 5.52% 5.52% 4.84% 4.75% 4.68%
CAPEX / FCF (%) 14.61% 8.66% 10.22% 10.62% 10.76% 9.59% 9.21% 8.53%

Items per share

        
Cash flow per share 1 5.584 11.7 11.73 9.448 9.123 10.36 11.76 -
Change - 109.57% 0.23% -19.45% -3.43% 13.53% 13.56% -
Dividend per Share 1 1.8 2.09 2.39 2.485 2.505 2.569 2.702 2.853
Change - 16.11% 14.35% 3.97% 0.8% 2.54% 5.2% 5.59%
Book Value Per Share 1 5.235 11.67 15.23 17.68 20.14 20.48 25.09 31.5
Change - 122.9% 30.53% 16.05% 13.94% 1.69% 22.51% 25.54%
EPS 1 7.04 8.13 8.1 7.97 8.08 8.78 10.33 11.81
Change - 15.48% -0.37% -1.6% 1.38% 8.67% 17.68% 14.32%
Nbr of stocks (in thousands) 135,723 135,391 133,960 133,264 130,194 124,809 124,809 124,809
Announcement Date 2/9/22 A 2/8/23 A 2/7/24 A 2/5/25 A 2/4/26 A - - -
1USD
Estimates
2026 *2027 *
P/E 19.3x 16.4x
PBR 8.27x 6.75x
EV / Sales 1.05x 0.99x
Yield 1.52% 1.6%

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
-
MarketScreener Ratings - CDW Corporation
Sell
Consensus
Buy
Mean consensus
BUY
Number of Analysts
10
Last Close Price
169.36USD
Average target price
184.11USD
Spread / Average Target
+8.71%