Discounted Cash Flow
MID Penn Bancorp Inc.
—
—
Average annual growth rates
| Metric | 10-Year | 5-Year | 3-Year |
|---|---|---|---|
| Sales | — | — | — |
| Free Cash Flow | — | — | — |
| Average (FCF & NI) | — | — | — |
| Net Income | — | — | — |
Endpoint CAGR (better for long term trend)
| Metric | 10-Year | 5-Year | 3-Year |
|---|---|---|---|
| Sales | — | — | — |
| Free Cash Flow | — | — | — |
| Average (FCF & NI) | — | — | — |
| Net Income | — | — | — |
Projected growth rate
—
—
%
%
Historical inputs (10 fiscal years)
| YEAR | Sales | Net Income | Free Cash Flow | Net Margin | EPS (diluted) |
|---|---|---|---|---|---|
| 2016 | $40.2m | $7.8m | $21.5m | 19.4% | $1.85 |
| 2017 | $43.9m (9.2%) | $7.1m (-9.2%) | $5.0m (-76.7%) | 16.2% (-16.8%) | $1.67 (-9.7%) |
| 2018 | $68.7m (56.4%) | $10.6m (49.5%) | $2.0m (-59.6%) | 15.4% (-4.4%) | $1.48 (-11.4%) |
| 2019 | $95.3m (38.8%) | $17.7m (67.1%) | $3.9m (94.9%) | 18.6% (20.3%) | $2.09 (41.2%) |
| 2020 | $107.9m (13.2%) | $26.2m (48.1%) | $10.4m (163.2%) | 24.3% (30.7%) | $3.11 (48.8%) |
| 2021 | $123.3m (14.3%) | $29.3m (11.9%) | $62.4m (500.9%) | 23.8% (-2.1%) | $2.71 (-12.9%) |
| 2022 | $165.6m (34.3%) | $54.8m (86.9%) | $55.7m (-10.7%) | 33.1% (39.2%) | $3.44 (26.9%) |
| 2023 | $236.3m (42.7%) | $37.4m (-31.8%) | $49.6m (-11.1%) | 15.8% (-52.2%) | $2.29 (-33.4%) |
| 2024 | $286.6m (21.3%) | $49.4m (32.2%) | $44.5m (-10.3%) | 17.3% (9.0%) | $2.90 (26.6%) |
| 2025 | $323.8m (13.0%) | $56.2m (13.8%) | $71.8m (61.5%) | 17.4% (0.7%) | $2.59 (-10.7%) |
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): —
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.