Discounted Cash Flow

CDW Corp.

CDW · Based on 10 years of SEC filings

Average annual growth rates

Metric 10-Year 5-Year 3-Year
Sales
Free Cash Flow
Average (FCF & NI)
Net Income

Average annual growth is the mean year-over-year change across each period.

Endpoint CAGR (better for long term trend)

Metric 10-Year 5-Year 3-Year
Sales
Free Cash Flow
Average (FCF & NI)
Net Income

Endpoint CAGR is the compound annual rate from the first to last year in each period.

Projections use average year-over-year growth. Change this in Settings.

Projected growth rate

Free cash flow growth
10-year: — 5-year: — 3-year: —
Averaged growth (FCF & NI)
10-year: — 5-year: — 3-year: —
Net income growth
10-year: — 5-year: — 3-year: —
Sales growth (not added to calculations)
10-year: — 5-year: — 3-year: —

Click a greyed-out slider to switch metrics. Slide between the 10-year, 5-year, and 3-year historic growth rates for FCF, net income, or their average.

%
%

Historical inputs (10 fiscal years)

YEAR Sales Net Income Free Cash Flow Net Margin EPS (diluted)
2016 $14.0b $424.4m $540.5m 3.0% $2.59
2017 $15.2b (8.7%) $523.0m (23.2%) $696.6m (28.9%) 3.4% (13.4%) $3.37 (30.1%)
2018 $16.2b (6.9%) $643.0m (22.9%) $819.8m (17.7%) 4.0% (15.0%) $4.26 (26.4%)
2019 $18.0b (11.0%) $736.8m (14.6%) $790.9m (-3.5%) 4.1% (3.2%) $5.08 (19.2%)
2020 $18.5b (2.4%) $788.5m (7.0%) $1.2b (46.2%) 4.3% (4.5%) $5.53 (8.9%)
2021 $20.8b (12.7%) $988.6m (25.4%) $684.6m (-40.8%) 4.7% (11.2%) $7.14 (29.1%)
2022 $23.7b (14.1%) $1.1b (12.7%) $1.2b (76.5%) 4.7% (-1.2%) $8.24 (15.4%)
2023 $21.4b (-10.0%) $1.1b (-0.9%) $1.5b (20.1%) 5.2% (10.1%) $8.20 (-0.5%)
2024 $21.0b (-1.8%) $1.1b (-2.4%) $1.2b (-20.4%) 5.1% (-0.6%) $8.06 (-1.7%)
2025 $22.4b (6.8%) $1.1b (-1.0%) $1.1b (-5.8%) 4.8% (-7.3%) $8.13 (0.9%)

Base FCF: (latest fiscal year)

Discount rate: %

Terminal growth:

Projection period: years

Alt A decline yrs:

Alt B total yrs:

Values abbreviated: b = billions, m = millions, k = thousands.

Projected cash flows

Year Projected cash flow Discount Factor Present Value

PV of projected FCF:

Terminal FCF:

Terminal value:

PV of terminal value:

Enterprise value (DCF):

DCF price per share:

Current price:

Alternative DCF Models

Model Fair Value Upside PV(FCFs) PV(Terminal) Total Years
Standard (10yr→TV) 10 + TV
Alt A (Gradual Decline)
Alt B (30yr Hard Stop) N/A

This is a simplified DCF model for illustration. It uses reported free cash flow, a single growth assumption, fixed WACC, and a Gordon Growth terminal value. It is not investment advice.

+ 10YR Financials Balance Sheet (10YR) Cash Flow (10YR) DCF Model