Orange County Bancorp, Inc. (OBT) DCF Valuation

Orange County Bancorp, Inc. (OBT) DCF Valuation

US | Financial Services | Banks - Regional | NASDAQ
Orange County Bancorp, Inc. (OBT) 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

Orange County Bancorp, Inc. (OBT) Bundle

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

TOTAL:

Looking to determine the intrinsic value of Orange County Bancorp, Inc.? Our (OBT) DCF Calculator integrates real-world data with extensive customization features, allowing you to refine your forecasts and enhance your investment choices.


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 52.9 59.7 72.0 89.9 93.9 108.7 125.8 145.5 168.4 194.8
Revenue Growth, % 0 12.88 20.64 24.77 4.53 15.71 15.71 15.71 15.71 15.71
EBITDA 15.2 15.8 28.3 32.0 39.1 37.3 43.2 50.0 57.8 66.9
EBITDA, % 28.75 26.47 39.34 35.57 41.64 34.35 34.35 34.35 34.35 34.35
Depreciation 1.5 1.6 1.7 1.7 2.0 2.5 2.9 3.4 3.9 4.6
Depreciation, % 2.79 2.61 2.3 1.88 2.09 2.34 2.34 2.34 2.34 2.34
EBIT 13.7 14.2 26.7 30.3 37.1 34.8 40.3 46.6 53.9 62.4
EBIT, % 25.96 23.86 37.04 33.69 39.54 32.02 32.02 32.02 32.02 32.02
Total Cash 280.0 451.3 771.0 619.5 147.4 108.7 125.8 145.5 168.4 194.8
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 3.2 6.3 6.6 6.3 5.9
Account Receivables, % 6.05 10.54 9.22 7.03 6.32
Inventories -28.3 -127.5 -312.8 -92.4 .0 -76.9 -88.9 -102.9 -119.1 -137.7
Inventories, % -53.53 -213.59 -434.29 -102.82 0 -70.71 -70.71 -70.71 -70.71 -70.71
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 -1.9 -.7 -2.0 -1.5 -3.5 -2.8 -3.2 -3.7 -4.3 -5.0
Capital Expenditure, % -3.51 -1.16 -2.72 -1.72 -3.76 -2.57 -2.57 -2.57 -2.57 -2.57
Tax Rate, % 20.65 20.65 20.65 20.65 20.65 20.65 20.65 20.65 20.65 20.65
EBITAT 10.9 11.5 21.3 24.4 29.5 27.8 32.2 37.3 43.1 49.9
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 35.7 108.4 205.9 -195.6 -64.1 101.8 42.6 49.3 57.1 66.0
WACC, % 7.78 7.82 7.79 7.82 7.76 7.8 7.8 7.8 7.8 7.8
PV UFCF
SUM PV UFCF 258.2
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 67
Terminal Value 1,162
Present Terminal Value 798
Enterprise Value 1,057
Net Debt 107
Equity Value 950
Diluted Shares Outstanding, MM 6
Equity Value Per Share 168.77

What You Will Get

  • Editable Forecast Inputs: Easily adjust assumptions (growth %, margins, WACC) to explore various scenarios.
  • Real-World Data: Orange County Bancorp, Inc.'s (OBT) financial data pre-filled to kickstart your analysis.
  • Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
  • Customizable and Professional: A sleek Excel model that can be tailored to your valuation requirements.
  • Built for Analysts and Investors: Perfect for testing forecasts, validating strategies, and enhancing efficiency.

Key Features

  • 🔍 Real-Life OBT Financials: Pre-filled historical and projected data for Orange County Bancorp, Inc. (OBT).
  • ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
  • 📊 Professional DCF Valuation: Built-in formulas calculate Orange County Bancorp’s intrinsic value using the Discounted Cash Flow method.
  • ⚡ Instant Results: Visualize Orange County Bancorp’s valuation instantly after making changes.
  • Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.

How It Works

  • Step 1: Download the prebuilt Excel template featuring Orange County Bancorp, Inc. (OBT) data.
  • Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
  • Step 3: Adjust forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
  • Step 4: Instantly see recalculated results, including the intrinsic value of Orange County Bancorp, Inc. (OBT).
  • Step 5: Utilize the outputs to make informed investment choices or create detailed reports.

Why Choose This Calculator for Orange County Bancorp, Inc. (OBT)?

  • Accurate Data: Utilize authentic financials from Orange County Bancorp for trustworthy valuation outcomes.
  • Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
  • Time-Saving: Ready-made calculations save you the hassle of starting anew.
  • Professional-Grade Tool: Crafted for investors, analysts, and financial consultants.
  • User-Friendly: Easy-to-navigate design and detailed instructions ensure accessibility for all users.

Who Should Use Orange County Bancorp, Inc. (OBT)?

  • Investors: Gain insights into investment opportunities with our comprehensive financial tools.
  • Financial Analysts: Streamline your analysis with our user-friendly financial modeling resources.
  • Consultants: Easily tailor our materials for impactful client presentations and reports.
  • Finance Enthusiasts: Enhance your knowledge of banking and finance with practical examples from the industry.
  • Educators and Students: Utilize our resources as a valuable asset in finance-related educational programs.

What the Template Contains

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

No products were found matching.