First Mid Bancshares, Inc. (FMBH) DCF Valuation

First Mid Bancshares, Inc. (FMBH) 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

First Mid Bancshares, Inc. (FMBH) 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:

Explore the financial potential of First Mid Bancshares, Inc. (FMBH) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of First Mid Bancshares, Inc. (FMBH) and enhance your investment decisions.


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 181.7 186.9 237.5 254.7 274.1 304.9 339.0 377.0 419.2 466.2
Revenue Growth, % 0 2.88 27.06 7.22 7.65 11.2 11.2 11.2 11.2 11.2
EBITDA 74.1 68.6 81.2 106.4 .0 93.6 104.0 115.7 128.7 143.1
EBITDA, % 40.79 36.7 34.2 41.76 0 30.69 30.69 30.69 30.69 30.69
Depreciation 9.4 8.9 9.8 11.2 .0 11.3 12.5 13.9 15.5 17.2
Depreciation, % 5.2 4.74 4.12 4.39 0 3.69 3.69 3.69 3.69 3.69
EBIT 64.7 59.7 71.4 95.2 .0 82.3 91.5 101.8 113.2 125.9
EBIT, % 35.59 31.96 30.08 37.37 0 27 27 27 27 27
Total Cash 835.6 1,296.5 1,590.0 1,365.3 143.1 275.7 306.6 340.9 379.1 421.6
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables .0 .0 .0 .0 .0
Account Receivables, % 0 0 0 0 0
Inventories -108.9 -441.8 -195.9 -186.5 .0 -192.5 -214.0 -238.0 -264.7 -294.3
Inventories, % -59.95 -236.32 -82.48 -73.24 0 -63.13 -63.13 -63.13 -63.13 -63.13
Accounts Payable 2.3 2.3 1.3 3.3 5.4 3.9 4.3 4.8 5.3 5.9
Accounts Payable, % 1.24 1.25 0.56669 1.31 1.98 1.27 1.27 1.27 1.27 1.27
Capital Expenditure -4.1 -2.5 -3.7 -5.0 -3.6 -5.1 -5.7 -6.4 -7.1 -7.9
Capital Expenditure, % -2.26 -1.32 -1.56 -1.97 -1.33 -1.69 -1.69 -1.69 -1.69 -1.69
Tax Rate, % 22.02 22.02 22.02 22.02 22.02 22.02 22.02 22.02 22.02 22.02
EBITAT 49.0 45.3 55.1 76.0 .0 63.6 70.8 78.7 87.5 97.3
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 165.5 384.6 -185.7 74.8 -188.1 260.7 99.6 110.7 123.1 136.9
WACC, % 12.34 12.34 12.45 12.7 12.53 12.47 12.47 12.47 12.47 12.47
PV UFCF
SUM PV UFCF 541.3
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 140
Terminal Value 1,334
Present Terminal Value 741
Enterprise Value 1,282
Net Debt 274
Equity Value 1,009
Diluted Shares Outstanding, MM 22
Equity Value Per Share 46.13

What You Will Get

  • Real FMBH Financials: Access to historical and projected data for precise valuation.
  • Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
  • Dynamic Calculations: Intrinsic value and NPV are automatically computed.
  • Scenario Analysis: Explore various scenarios to assess First Mid Bancshares' future performance.
  • User-Friendly Design: Crafted for professionals but easy to navigate for newcomers.

Key Features

  • Comprehensive Financial Data: First Mid Bancshares, Inc.'s (FMBH) historical financial statements and pre-filled projections.
  • Customizable Parameters: Modify WACC, tax rates, revenue growth, and net interest margins.
  • Real-Time Analysis: View First Mid Bancshares, Inc.'s (FMBH) intrinsic value recalculated instantly.
  • Intuitive Visualizations: Dashboard graphs showcase valuation outcomes and essential metrics.
  • Designed for Precision: A professional-grade tool for analysts, investors, and finance professionals.

How It Works

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

Why Choose First Mid Bancshares, Inc. (FMBH)?

  • Time Efficiency: Access ready-to-use financial tools without the hassle of starting from scratch.
  • Enhanced Precision: Utilize dependable financial metrics and calculations to minimize valuation errors.
  • Customizable Solutions: Adjust the tools to align with your unique financial assumptions and forecasts.
  • User-Friendly Insights: Intuitive charts and outputs simplify the interpretation of results.
  • Preferred by Professionals: Crafted for industry experts who prioritize accuracy and functionality.

Who Should Use This Product?

  • Investors: Evaluate First Mid Bancshares, Inc.'s (FMBH) performance before making investment decisions.
  • CFOs and Financial Analysts: Enhance valuation methodologies and assess financial forecasts for FMBH.
  • Startup Founders: Discover the valuation strategies applied to established financial institutions like First Mid Bancshares, Inc. (FMBH).
  • Consultants: Provide detailed valuation analyses and reports for clients interested in FMBH.
  • Students and Educators: Utilize current market data to teach and learn about financial valuation practices using FMBH as a case study.

What the Template Contains

  • Pre-Filled Data: Includes First Mid Bancshares, Inc.'s (FMBH) historical financials and forecasts.
  • Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations tailored for (FMBH).
  • Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs specific to (FMBH).
  • Key Financial Ratios: Analyze (FMBH)'s profitability, efficiency, and leverage metrics.
  • Customizable Inputs: Edit revenue growth, margins, and tax rates for (FMBH) with ease.
  • Clear Dashboard: Charts and tables summarizing key valuation results for (FMBH).

No products were found matching.