Discounted Cash Flow
RED River Bancshares Inc.
—
—
Average annual growth rates
| Metric | 10-Year | 5-Year | 3-Year |
|---|---|---|---|
| Sales | — | — | — |
| Free Cash Flow | — | — | — |
| Average (FCF & NI) | — | — | — |
| Net Income | — | — | — |
| Dividends | — | — | — |
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) |
|---|---|---|---|---|---|
| 2018 | $59.2m | $23.1m | $-5.8m | 38.9% | $3.43 |
| 2019 | $63.6m (7.4%) | $24.8m (7.7%) | $-4.9m (15.1%) | 39.0% (0.2%) | $3.51 (2.3%) |
| 2020 | $69.0m (8.4%) | $28.1m (13.4%) | $-6.6m (-34.4%) | 40.8% (4.6%) | $3.84 (9.4%) |
| 2021 | $71.7m (3.9%) | $33.0m (17.1%) | $-4.5m (32.0%) | 45.9% (12.6%) | $4.53 (18.0%) |
| 2022 | $86.6m (20.8%) | $36.9m (12.0%) | $-6.6m (-46.8%) | 42.6% (-7.3%) | $5.14 (13.5%) |
| 2023 | $86.4m (-0.2%) | $34.9m (-5.5%) | $-6.6m (-0.5%) | 40.4% (-5.3%) | $4.87 (-5.3%) |
| 2024 | $89.3m (3.3%) | $34.2m (-1.8%) | $-4.1m (38.6%) | 38.3% (-5.0%) | $4.96 (1.8%) |
| 2025 | $105.6m (18.2%) | $42.8m (24.9%) | $-1.9m (52.3%) | 40.5% (5.7%) | $6.40 (29.0%) |
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.