Pathfinder Bancorp, Inc. (PBHC) DCF Valuation

Pathfinder Bancorp, Inc. (PBHC) DCF Valuation
  • ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
  • ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
  • ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
  • ✓ No Se Necesita Experiencia; Fáciles De Seguir

Pathfinder Bancorp, Inc. (PBHC) 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:

Streamline your analysis and improve precision with our (PBHC) DCF Calculator! Equipped with actual data from Pathfinder Bancorp, Inc. and customizable assumptions, this tool empowers you to forecast, evaluate, and assess (PBHC) like a seasoned investor.


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 33.1 38.1 43.7 46.4 41.2 43.7 46.4 49.2 52.3 55.5
Revenue Growth, % 0 15.03 14.62 6.2 -11.27 6.14 6.14 6.14 6.14 6.14
EBITDA .0 9.7 18.7 16.4 .0 9.1 9.6 10.2 10.8 11.5
EBITDA, % 0 25.49 42.82 35.31 0 20.73 20.73 20.73 20.73 20.73
Depreciation 1.6 1.7 1.8 .7 .0 1.3 1.4 1.5 1.6 1.7
Depreciation, % 4.71 4.54 4.17 1.53 0 2.99 2.99 2.99 2.99 2.99
EBIT -1.6 8.0 16.9 15.7 .0 7.8 8.2 8.7 9.3 9.8
EBIT, % -4.71 20.95 38.65 33.78 0 17.73 17.73 17.73 17.73 17.73
Total Cash 131.3 171.7 227.7 205.7 48.7 43.7 46.4 49.2 52.3 55.5
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 3.7 4.5 4.5 888.6 .0
Account Receivables, % 11.2 11.93 10.34 1914.64 0
Inventories -24.0 -48.0 -41.7 837.7 .0 -14.7 -15.6 -16.5 -17.5 -18.6
Inventories, % -72.28 -125.93 -95.35 1805.01 0 -33.53 -33.53 -33.53 -33.53 -33.53
Accounts Payable .4 .2 .1 1.0 2.2 .8 .9 .9 1.0 1.1
Accounts Payable, % 1.19 0.50619 0.24256 2.1 5.45 1.9 1.9 1.9 1.9 1.9
Capital Expenditure -3.6 -1.3 -1.2 -5.2 -2.0 -2.9 -3.1 -3.2 -3.4 -3.7
Capital Expenditure, % -10.85 -3.31 -2.77 -11.22 -4.77 -6.59 -6.59 -6.59 -6.59 -6.59
Tax Rate, % 21.14 21.14 21.14 21.14 21.14 21.14 21.14 21.14 21.14 21.14
EBITAT -1.2 5.2 13.1 9.7 .0 5.6 5.9 6.3 6.7 7.1
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 17.4 28.7 7.3 -1,757.4 1,725.6 5.6 4.5 4.8 5.1 5.4
WACC, % 8.97 7.73 8.88 7.47 9 8.41 8.41 8.41 8.41 8.41
PV UFCF
SUM PV UFCF 20.1
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 6
Terminal Value 86
Present Terminal Value 57
Enterprise Value 77
Net Debt 163
Equity Value -85
Diluted Shares Outstanding, MM 6
Equity Value Per Share -14.16

What You Will Get

  • Real PBHC 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 in real time.
  • Scenario Analysis: Evaluate multiple scenarios to assess Pathfinder Bancorp’s future performance.
  • User-Friendly Design: Designed for professionals while remaining approachable for newcomers.

Key Features

  • Real-Life PBHC Data: Pre-filled with Pathfinder Bancorp’s historical financials and forward-looking projections.
  • Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures.
  • Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
  • Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
  • User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.

How It Works

  • Download: Obtain the pre-prepared Excel file containing Pathfinder Bancorp, Inc.'s (PBHC) financial data.
  • Customize: Modify projections such as revenue growth, EBITDA %, and WACC to fit your analysis.
  • Update Automatically: The intrinsic value and NPV calculations refresh in real-time as you make changes.
  • Test Scenarios: Generate various forecasts and evaluate different outcomes quickly.
  • Make Decisions: Leverage the valuation insights to inform your investment decisions.

Why Choose This Calculator for Pathfinder Bancorp, Inc. (PBHC)?

  • Designed for Industry Experts: A sophisticated tool tailored for financial analysts, CFOs, and investment consultants.
  • Comprehensive Data: Historical and projected financial data for Pathfinder Bancorp, Inc. (PBHC) preloaded for precision.
  • Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions to gauge potential outcomes.
  • Insightful Outputs: Automatically computes intrinsic value, NPV, and other essential financial metrics.
  • User-Friendly Interface: Step-by-step guidance ensures a smooth and efficient experience.

Who Should Use This Product?

  • Individual Investors: Make informed decisions about buying or selling Pathfinder Bancorp, Inc. (PBHC) stock.
  • Financial Analysts: Streamline valuation processes with ready-to-use financial models for Pathfinder Bancorp, Inc. (PBHC).
  • Consultants: Deliver professional valuation insights related to Pathfinder Bancorp, Inc. (PBHC) to clients quickly and accurately.
  • Business Owners: Understand how companies like Pathfinder Bancorp, Inc. (PBHC) are valued to guide your own strategy.
  • Finance Students: Learn valuation techniques using real-world data and scenarios involving Pathfinder Bancorp, Inc. (PBHC).

What the Template Contains

  • Comprehensive DCF Model: Editable template featuring detailed valuation calculations for Pathfinder Bancorp, Inc. (PBHC).
  • Real-World Data: Historical and projected financials for Pathfinder Bancorp, Inc. (PBHC) preloaded for in-depth analysis.
  • Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
  • Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into Pathfinder Bancorp, Inc. (PBHC).
  • Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to Pathfinder Bancorp, Inc. (PBHC).
  • Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results tailored to Pathfinder Bancorp, Inc. (PBHC).

No products were found matching.