Discounted Cash Flow

QCR Holdings Inc.

QCRH · 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 $137.5m $27.7m $37.4m 20.1% $2.20
2017 $166.0m (20.7%) $35.7m (29.0%) $28.0m (-25.2%) 21.5% (6.8%) $2.68 (21.8%)
2018 $224.4m (35.2%) $43.1m (20.8%) $52.8m (88.9%) 19.2% (-10.7%) $2.92 (9.0%)
2019 $294.8m (31.4%) $57.4m (33.1%) $64.1m (21.3%) 19.5% (1.3%) $3.65 (25.0%)
2020 $312.2m (5.9%) $60.6m (5.5%) $107.9m (68.4%) 19.4% (-0.3%) $3.84 (5.2%)
2021 $300.6m (-3.7%) $98.9m (63.3%) $74.2m (-31.2%) 32.9% (69.6%) $6.30 (64.1%)
2022 $373.3m (24.2%) $99.1m (0.2%) $85.4m (15.1%) 26.5% (-19.4%) $5.94 (-5.7%)
2023 $546.1m (46.3%) $113.6m (14.6%) $361.4m (323.0%) 20.8% (-21.6%) $6.79 (14.3%)
2024 $231.8m (-57.6%) $113.8m (0.3%) $400.0m (10.7%) 49.1% (136.2%) $6.77 (-0.3%)
2025 $255.2m (10.1%) $127.2m (11.7%) $354.1m (-11.5%) 49.8% (1.5%) $7.54 (11.4%)

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