Farmers & Merchants Bancorp, Inc. (FMAO) DCF Valuation

Farmers & Merchants Bancorp, Inc. (FMAO) 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

Farmers & Merchants Bancorp, Inc. (FMAO) 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 prospects of Farmers & Merchants Bancorp, Inc. (FMAO) with our user-friendly DCF Calculator! Enter your forecasts for growth, margins, and expenses to uncover the intrinsic value of Farmers & Merchants Bancorp, Inc. (FMAO) and enhance your investment approach.


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 63.6 74.9 84.8 100.4 95.7 106.4 118.3 131.5 146.2 162.6
Revenue Growth, % 0 17.77 13.31 18.32 -4.66 11.18 11.18 11.18 11.18 11.18
EBITDA 26.3 29.5 34.5 44.5 .0 35.3 39.2 43.6 48.5 53.9
EBITDA, % 41.34 39.41 40.66 44.33 0 33.15 33.15 33.15 33.15 33.15
Depreciation 3.0 3.3 3.4 3.9 .0 3.6 4.0 4.5 5.0 5.5
Depreciation, % 4.77 4.36 4.02 3.86 0 3.4 3.4 3.4 3.4 3.4
EBIT 23.2 26.2 31.1 40.6 .0 31.6 35.2 39.1 43.5 48.4
EBIT, % 36.57 35.05 36.64 40.47 0 29.74 29.74 29.74 29.74 29.74
Total Cash 276.7 410.7 576.3 478.3 499.4 106.4 118.3 131.5 146.2 162.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 .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Inventories, % 0 0 0 0 0 0 0 0 0 0
Accounts Payable .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Accounts Payable, % 0 0 0 0 0 0 0 0 0 0
Capital Expenditure -3.5 -3.2 -2.0 -2.6 -10.9 -5.6 -6.2 -6.9 -7.6 -8.5
Capital Expenditure, % -5.52 -4.3 -2.32 -2.59 -11.42 -5.23 -5.23 -5.23 -5.23 -5.23
Tax Rate, % 19.63 19.63 19.63 19.63 19.63 19.63 19.63 19.63 19.63 19.63
EBITAT 18.9 20.9 24.8 32.6 .0 25.4 28.2 31.4 34.9 38.8
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 18.4 21.0 26.2 33.9 -10.9 23.5 26.1 29.0 32.2 35.9
WACC, % 11.12 10.98 10.98 11.03 11.04 11.03 11.03 11.03 11.03 11.03
PV UFCF
SUM PV UFCF 105.9
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 37
Terminal Value 405
Present Terminal Value 240
Enterprise Value 346
Net Debt 157
Equity Value 189
Diluted Shares Outstanding, MM 13
Equity Value Per Share 14.02

What You Will Get

  • Comprehensive FMAO 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 computed in real-time.
  • Scenario Analysis: Explore various scenarios to assess Farmers & Merchants Bancorp's future performance.
  • User-Friendly Interface: Designed for professionals while remaining approachable for newcomers.

Key Features

  • Customizable Financial Inputs: Adjust essential metrics such as loan growth, net interest margin, and operating expenses.
  • Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other financial metrics.
  • High-Precision Analytics: Leverages Farmers & Merchants Bancorp's (FMAO) actual financial data for accurate valuation results.
  • Effortless Scenario Testing: Easily evaluate various assumptions and analyze different financial outcomes.
  • Efficiency Boost: Streamline the valuation process without the hassle of constructing intricate models from the ground up.

How It Works

  1. Download the Template: Get instant access to the Excel-based FMAO DCF Calculator.
  2. Input Your Assumptions: Adjust the yellow-highlighted cells for growth rates, WACC, margins, and more.
  3. Instant Calculations: The model automatically updates Farmers & Merchants Bancorp's intrinsic value.
  4. Test Scenarios: Simulate different assumptions to evaluate potential valuation changes.
  5. Analyze and Decide: Use the results to guide your investment or financial analysis.

Why Choose This Calculator for Farmers & Merchants Bancorp, Inc. (FMAO)?

  • Comprehensive Tool: Offers DCF, WACC, and financial ratio analyses tailored for FMAO.
  • Customizable Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
  • Detailed Insights: Automatically computes the intrinsic value and Net Present Value for Farmers & Merchants Bancorp.
  • Preloaded Data: Includes historical and forecasted data for precise analysis.
  • Professional Quality: Perfect for financial analysts, investors, and consultants focusing on FMAO.

Who Should Use This Product?

  • Investors: Evaluate Farmers & Merchants Bancorp, Inc. (FMAO)'s financial health before making investment decisions.
  • CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
  • Startup Founders: Understand the valuation strategies of established financial institutions like Farmers & Merchants Bancorp, Inc. (FMAO).
  • Consultants: Provide comprehensive valuation analyses for clients in the banking sector.
  • Students and Educators: Utilize current financial data to learn and teach valuation principles effectively.

What the Template Contains

  • Pre-Filled DCF Model: Farmers & Merchants Bancorp, Inc.'s (FMAO) financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital specific to (FMAO).
  • Financial Ratios: Evaluate (FMAO)'s profitability, leverage, and efficiency metrics.
  • Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios for (FMAO).
  • Financial Statements: Annual and quarterly reports for (FMAO) to support detailed analysis.
  • Interactive Dashboard: Easily visualize key valuation metrics and results for (FMAO).

No products were found matching.