Auburn National Bancorporation, Inc. (AUBN) DCF Valuation

Auburn National Bancorporation, Inc. (AUBN) DCF Valuation

US | Financial Services | Banks - Regional | NASDAQ
Auburn National Bancorporation, Inc. (AUBN) 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

Auburn National Bancorporation, Inc. (AUBN) 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 assess the intrinsic value of Auburn National Bancorporation, Inc.? Our (AUBN) DCF Calculator integrates real-world data with extensive customization features, allowing you to refine your forecasts and enhance your investment strategies.


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 31.6 29.7 28.3 3.2 23.3 23.4 23.4 23.5 23.5 23.6
Revenue Growth, % 0 -5.85 -4.83 -88.56 621.92 0.19013 0.19013 0.19013 0.19013 0.19013
EBITDA 13.3 10.7 10.7 14.4 2.3 10.6 10.6 10.6 10.6 10.6
EBITDA, % 42.04 36.1 37.8 444.56 9.93 45.17 45.17 45.17 45.17 45.17
Depreciation 1.2 1.7 1.2 1.5 1.7 3.2 3.2 3.2 3.2 3.2
Depreciation, % 3.67 5.61 4.4 47.25 7.28 13.64 13.64 13.64 13.64 13.64
EBIT 12.1 9.1 9.4 12.8 .6 9.6 9.6 9.6 9.6 9.7
EBIT, % 38.38 30.49 33.4 397.31 2.65 40.98 40.98 40.98 40.98 40.98
Total Cash 302.4 419.2 500.7 423.3 310.9 23.4 23.4 23.5 23.5 23.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 -1.8 -8.4 -20.2 -7.0 -.4 -9.7 -9.7 -9.7 -9.7 -9.8
Capital Expenditure, % -5.73 -28.12 -71.35 -217.97 -1.79 -41.4 -41.4 -41.4 -41.4 -41.4
Tax Rate, % -125.73 -125.73 -125.73 -125.73 -125.73 -125.73 -125.73 -125.73 -125.73 -125.73
EBITAT 9.7 7.5 8.0 10.3 1.4 8.2 8.2 8.2 8.3 8.3
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 9.1 .8 -10.9 4.8 2.7 1.7 1.7 1.7 1.7 1.7
WACC, % 14.48 14.66 14.92 14.49 16.32 14.98 14.98 14.98 14.98 14.98
PV UFCF
SUM PV UFCF 5.8
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 2
Terminal Value 14
Present Terminal Value 7
Enterprise Value 13
Net Debt -40
Equity Value 53
Diluted Shares Outstanding, MM 3
Equity Value Per Share 15.02

What You Will Get

  • Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real AUBN financials.
  • Real-World Data: Access to historical data and forward-looking estimates (as indicated in the highlighted cells).
  • Forecast Flexibility: Adjust forecast assumptions including revenue growth, EBITDA %, and WACC.
  • Automatic Calculations: Instantly observe how your inputs affect Auburn National Bancorporation’s valuation.
  • Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
  • User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step guidance.

Key Features

  • Comprehensive Financial Data: Auburn National Bancorporation's historical financial statements and pre-filled projections.
  • Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
  • Real-Time Valuation: Observe Auburn National Bancorporation's intrinsic value update instantly.
  • Intuitive Visualizations: Dashboard charts present valuation results and essential metrics clearly.
  • Designed for Precision: A robust tool tailored for analysts, investors, and finance professionals.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review Auburn National Bancorporation's pre-filled financial data and forecasts.
  3. Step 3: Modify key inputs such as loan growth, cost of equity, and tax rates (highlighted cells).
  4. Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
  5. Step 5: Analyze the outputs and leverage the results for your investment decisions.

Why Choose This Calculator for Auburn National Bancorporation, Inc. (AUBN)?

  • Designed for Finance Experts: A sophisticated tool utilized by financial analysts, CFOs, and investment consultants.
  • Comprehensive Data: Historical and projected financial information for Auburn National Bancorporation preloaded for precision.
  • Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
  • Insightful Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
  • User-Friendly Interface: Step-by-step guidance makes the process straightforward.

Who Should Use This Product?

  • Investors: Evaluate Auburn National Bancorporation’s (AUBN) financial health before making investment decisions.
  • CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts for accuracy.
  • Startup Founders: Discover the valuation strategies of established financial institutions like Auburn National Bancorporation.
  • Consultants: Create comprehensive valuation reports tailored for your clients' needs.
  • Students and Educators: Utilize real-life financial data to enhance learning and understanding of valuation principles.

What the Template Contains

  • Pre-Filled Data: Includes Auburn National Bancorporation’s 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 Auburn National Bancorporation’s 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.