Affinity Bancshares, Inc. (AFBI) DCF Valuation

Affinity Bancshares, Inc. (AFBI) DCF Valuation
  • Fully Editable: Tailor To Your Needs In Excel Or Sheets
  • Professional Design: Trusted, Industry-Standard Templates
  • Pre-Built For Quick And Efficient Use
  • No Expertise Is Needed; Easy To Follow

Affinity Bancshares, Inc. (AFBI) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Whether you're an investor or analyst, this (AFBI) DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from Affinity Bancshares, Inc., you can adjust forecasts and instantly observe the results.


Discounted Cash Flow (DCF) - (USD MM)

Year AY1
2019
AY2
2020
AY3
2021
AY4
2022
AY5
2023
FY1
2024
FY2
2025
FY3
2026
FY4
2027
FY5
2028
Revenue 14.4 27.0 32.1 32.2 29.7 37.1 46.3 57.9 72.3 90.3
Revenue Growth, % 0 88.2 18.78 0.2369 -7.62 24.9 24.9 24.9 24.9 24.9
EBITDA 1.1 4.6 10.6 9.7 .0 6.5 8.1 10.1 12.7 15.8
EBITDA, % 7.54 16.95 32.99 30.06 0 17.51 17.51 17.51 17.51 17.51
Depreciation .8 1.0 1.0 .9 .0 1.1 1.4 1.7 2.1 2.6
Depreciation, % 5.27 3.54 2.96 2.81 0 2.92 2.92 2.92 2.92 2.92
EBIT .3 3.6 9.6 8.8 .0 5.4 6.8 8.4 10.5 13.2
EBIT, % 2.27 13.4 30.03 27.24 0 14.59 14.59 14.59 14.59 14.59
Total Cash 51.9 202.3 160.3 99.1 50.0 37.1 46.3 57.9 72.3 90.3
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 3.0 .0 .0 .0 .0
Account Receivables, % 20.97 0 0 0 0
Inventories -48.3 -179.5 -115.3 .0 .0 -22.3 -27.8 -34.7 -43.4 -54.2
Inventories, % -336.26 -664.76 -359.45 0 0 -60 -60 -60 -60 -60
Accounts Payable 3.9 4.7 5.3 7.0 .0 6.2 7.7 9.7 12.1 15.1
Accounts Payable, % 27.5 17.58 16.63 21.72 0 16.68 16.68 16.68 16.68 16.68
Capital Expenditure -.4 -.5 -.8 -1.4 -.5 -1.0 -1.2 -1.5 -1.9 -2.3
Capital Expenditure, % -2.63 -1.67 -2.59 -4.33 -1.77 -2.6 -2.6 -2.6 -2.6 -2.6
Tax Rate, % 23.13 23.13 23.13 23.13 23.13 23.13 23.13 23.13 23.13 23.13
EBITAT .4 2.9 7.4 6.7 .0 4.4 5.5 6.9 8.6 10.8
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 49.9 138.5 -56.2 -107.5 -7.5 31.4 12.4 15.5 19.3 24.1
WACC, % 13.85 12.12 11.85 11.85 11.89 12.31 12.31 12.31 12.31 12.31
PV UFCF
SUM PV UFCF 74.4
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 25
Terminal Value 239
Present Terminal Value 134
Enterprise Value 208
Net Debt -10
Equity Value 218
Diluted Shares Outstanding, MM 7
Equity Value Per Share 33.24

What You Will Get

  • Pre-Filled Financial Model: Affinity Bancshares, Inc.'s (AFBI) actual data enables precise DCF valuation.
  • Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers.
  • Instant Calculations: Automatic updates ensure you see results as you make changes.
  • Investor-Ready Template: A refined Excel file designed for professional-grade valuation.
  • Customizable and Reusable: Tailored for flexibility, allowing repeated use for detailed forecasts.

Key Features

  • Comprehensive DCF Model: Offers both unlevered and levered DCF valuation frameworks tailored for Affinity Bancshares, Inc. (AFBI).
  • WACC Analysis Tool: Ready-to-use Weighted Average Cost of Capital calculator with adjustable parameters.
  • Customizable Forecast Inputs: Easily alter growth projections, capital spending, and discount rates.
  • Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency metrics specific to Affinity Bancshares, Inc. (AFBI).
  • Visual Dashboard and Charts: Graphical representations provide a clear overview of essential valuation indicators for streamlined assessment.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered Affinity Bancshares, Inc. (AFBI) data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for Affinity Bancshares, Inc.'s (AFBI) intrinsic value.
  5. Step 5: Use the outputs for investment decisions or reporting.

Why Choose This Calculator?

  • Designed for Experts: A sophisticated tool tailored for analysts, CFOs, and financial consultants.
  • Accurate Data: Affinity Bancshares, Inc. (AFBI)’s historical and projected financials preloaded for precision.
  • Flexible Scenario Testing: Effortlessly simulate various forecasts and assumptions.
  • Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
  • User-Friendly: Step-by-step guidance makes the process straightforward.

Who Should Use Affinity Bancshares, Inc. (AFBI)?

  • Institutional Investors: Develop comprehensive valuation models for assessing investment opportunities.
  • Banking and Finance Professionals: Evaluate financial scenarios to inform strategic decision-making.
  • Financial Advisors: Deliver precise valuation assessments for clients interested in Affinity Bancshares, Inc. (AFBI).
  • Students and Educators: Utilize current market data to enhance learning in financial analysis and modeling.
  • Market Analysts: Gain insights into the valuation methods applicable to community banks like Affinity Bancshares, Inc. (AFBI).

What the Template Contains

  • Operating and Balance Sheet Data: Pre-filled Affinity Bancshares, Inc. (AFBI) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
  • WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
  • DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
  • Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
  • Key Ratios: Includes profitability, leverage, and efficiency ratios for Affinity Bancshares, Inc. (AFBI).
  • Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.