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
Dividends

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 $125.6m $27.7m $37.4m 22.1% $2.20
2017 $146.5m (16.7%) $35.7m (29.0%) $28.0m (-25.2%) 24.4% (10.5%) $2.68 (21.8%)
2018 $183.9m (25.5%) $43.1m (20.8%) $52.8m (88.9%) 23.4% (-3.8%) $2.92 (9.0%)
2019 $234.3m (27.4%) $57.4m (33.1%) $64.1m (21.3%) 24.5% (4.5%) $3.65 (25.0%)
2020 $280.7m (19.8%) $60.6m (5.5%) $107.9m (68.4%) 21.6% (-11.9%) $3.84 (5.2%)
2021 $278.7m (-0.7%) $98.9m (63.3%) $74.2m (-31.2%) 35.5% (64.5%) $6.30 (64.1%)
2022 $311.8m (11.9%) $99.1m (0.2%) $85.4m (15.1%) 31.8% (-10.5%) $5.94 (-5.7%)
2023 $353.7m (13.4%) $113.6m (14.6%) $361.4m (323.0%) 32.1% (1.1%) $6.79 (14.3%)
2024 $347.3m (-1.8%) $113.8m (0.3%) $400.0m (10.7%) 32.8% (2.1%) $6.77 (-0.3%)
2025 $369.5m (6.4%) $127.2m (11.7%) $354.1m (-11.5%) 34.4% (5.0%) $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