Discounted Cash Flow

PC Connection Inc.

CNXN · 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 $2.7b $48.1m $21.7m 1.8% $1.81
2017 $2.9b (8.1%) $54.9m (14.0%) $7.5m (-65.4%) 1.9% (5.4%) $2.05 (13.3%)
2018 $2.7b (-7.3%) $64.6m (17.7%) $65.6m (772.7%) 2.4% (27.0%) $2.42 (18.0%)
2019 $2.8b (4.5%) $82.1m (27.1%) $10.9m (-83.3%) 2.9% (21.7%) $3.12 (28.9%)
2020 $2.6b (-8.1%) $55.8m (-32.1%) $25.1m (129.0%) 2.2% (-26.1%) $2.13 (-31.7%)
2021 $2.9b (11.7%) $69.9m (25.4%) $47.5m (89.3%) 2.4% (12.3%) $2.67 (25.4%)
2022 $3.1b (8.0%) $89.2m (27.6%) $25.8m (-45.6%) 2.9% (18.1%) $3.40 (27.3%)
2023 $2.9b (-8.8%) $83.3m (-6.7%) $188.4m (629.7%) 2.9% (2.3%) $3.17 (-6.8%)
2024 $2.8b (-1.7%) $87.1m (4.6%) $166.3m (-11.7%) 3.1% (6.4%) $3.31 (4.4%)
2025 $2.9b (2.5%) $83.7m (-3.9%) $58.0m (-65.1%) 2.9% (-6.2%) $3.28 (-0.9%)

Base FCF: (latest fiscal year)

Discount rate: %

Terminal growth:

Projection period: years

Alt A decline yrs:

Alt B total yrs:

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