Chemung Financial Corporation (CHMG) DCF Valuation

Chemung Financial Corporation (CHMG) DCF Valuation
  • ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
  • ✓ Design Profissional: Modelos Confiáveis ​​E Padrão Da Indústria
  • ✓ Pré-Construídos Para Uso Rápido E Eficiente
  • ✓ Não É Necessária Experiência; Fácil De Seguir

Chemung Financial Corporation (CHMG) 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:

Evaluate Chemung Financial Corporation's (CHMG) financial outlook like an expert! This (CHMG) DCF Calculator provides you with pre-filled financial data and allows for complete customization to modify revenue growth, WACC, margins, and other critical assumptions to align with your projections.


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 79.9 82.9 88.4 94.6 95.7 100.2 104.9 109.7 114.9 120.2
Revenue Growth, % 0 3.72 6.7 7 1.19 4.65 4.65 4.65 4.65 4.65
EBITDA 23.5 28.1 37.3 39.9 34.3 36.8 38.5 40.3 42.1 44.1
EBITDA, % 29.38 33.94 42.14 42.19 35.83 36.7 36.7 36.7 36.7 36.7
Depreciation 4.4 4.2 3.5 3.0 2.8 4.2 4.4 4.6 4.8 5.0
Depreciation, % 5.55 5.12 3.96 3.2 2.93 4.15 4.15 4.15 4.15 4.15
EBIT 19.0 23.9 33.8 36.9 31.5 32.6 34.1 35.7 37.4 39.1
EBIT, % 23.83 28.82 38.18 38.99 32.9 32.55 32.55 32.55 32.55 32.55
Total Cash 406.0 663.1 819.0 688.5 630.2 100.2 104.9 109.7 114.9 120.2
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 33.5 43.1 43.8 89.5 .0
Account Receivables, % 41.97 51.99 49.57 94.56 0
Inventories -127.1 -115.0 -33.1 -64.7 .0 -61.3 -64.2 -67.1 -70.3 -73.5
Inventories, % -159.02 -138.83 -37.44 -68.43 0 -61.18 -61.18 -61.18 -61.18 -61.18
Accounts Payable 20.9 30.9 15.1 18.0 .0 19.9 20.9 21.8 22.8 23.9
Accounts Payable, % 26.15 37.25 17.07 18.99 0 19.89 19.89 19.89 19.89 19.89
Capital Expenditure -.9 -.9 -.4 -.4 -.5 -.7 -.7 -.8 -.8 -.8
Capital Expenditure, % -1.11 -1.05 -0.41506 -0.45025 -0.48254 -0.69985 -0.69985 -0.69985 -0.69985 -0.69985
Tax Rate, % 20.64 20.64 20.64 20.64 20.64 20.64 20.64 20.64 20.64 20.64
EBITAT 15.6 19.3 26.4 28.8 25.0 26.0 27.2 28.5 29.8 31.2
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 133.6 11.1 -68.9 20.3 34.1 63.0 32.4 33.9 35.5 37.1
WACC, % 16.12 15.94 15.6 15.57 15.75 15.8 15.8 15.8 15.8 15.8
PV UFCF
SUM PV UFCF 137.9
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 38
Terminal Value 274
Present Terminal Value 132
Enterprise Value 270
Net Debt 4
Equity Value 266
Diluted Shares Outstanding, MM 5
Equity Value Per Share 56.13

What You Will Receive

  • Comprehensive Financial Model: Utilize Chemung Financial Corporation’s (CHMG) actual data for accurate DCF valuation.
  • Complete Forecasting Control: Modify revenue growth, profit margins, WACC, and other essential metrics.
  • Real-Time Calculations: Automatic updates provide immediate results as you adjust parameters.
  • Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
  • Flexible and Reusable: Designed for adaptability, allowing for repeated application in detailed financial projections.

Key Features

  • Comprehensive Financial Data: Access Chemung Financial Corporation’s (CHMG) historical financial statements and pre-populated forecasts.
  • Customizable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins to suit your analysis.
  • Real-Time Insights: Observe the recalculation of Chemung Financial’s (CHMG) intrinsic value instantly.
  • Intuitive Visualizations: Dashboard graphs illustrate valuation outcomes and essential metrics clearly.
  • Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.

How It Works

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

Why Choose This Calculator for Chemung Financial Corporation (CHMG)?

  • All-in-One Solution: Combines DCF analysis, WACC calculations, and key financial ratios seamlessly.
  • Flexible Inputs: Easily modify yellow-highlighted fields to explore different financial scenarios.
  • In-Depth Analysis: Automatically computes Chemung Financial’s intrinsic value and Net Present Value.
  • Pre-Loaded Information: Access to historical and projected data for reliable analysis.
  • Expert-Level Tool: Perfect for financial analysts, investors, and business advisors focused on (CHMG).

Who Should Use This Product?

  • Investors: Assess Chemung Financial Corporation’s (CHMG) valuation prior to making investment decisions.
  • CFOs and Financial Analysts: Enhance valuation methodologies and evaluate financial forecasts.
  • Startup Founders: Understand the valuation practices of established financial institutions like Chemung Financial Corporation.
  • Consultants: Provide comprehensive valuation analyses and reports for clients in the financial sector.
  • Students and Educators: Utilize current market data to learn and teach valuation strategies effectively.

What the Template Contains

  • Preloaded CHMG Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
  • DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
  • Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
  • Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
  • Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
  • Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.

No products were found matching.