Penns Woods Bancorp, Inc. (PWOD) DCF Valuation

Penns Woods Bancorp, Inc. (PWOD) 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

Penns Woods Bancorp, Inc. (PWOD) 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:

Enhance your investment choices with the Penns Woods Bancorp, Inc. (PWOD) DCF Calculator! Explore authentic financial data, adjust growth projections and expenses, and observe how these modifications affect the intrinsic value of PWOD in real-time.


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 61.3 60.4 61.4 66.5 63.3 63.9 64.5 65.2 65.8 66.4
Revenue Growth, % 0 -1.43 1.65 8.32 -4.74 0.94845 0.94845 0.94845 0.94845 0.94845
EBITDA 23.0 22.0 23.7 25.2 .0 19.3 19.4 19.6 19.8 20.0
EBITDA, % 37.52 36.43 38.68 37.91 0 30.11 30.11 30.11 30.11 30.11
Depreciation 3.4 3.5 4.0 3.5 2.9 3.6 3.6 3.6 3.7 3.7
Depreciation, % 5.62 5.8 6.47 5.31 4.66 5.57 5.57 5.57 5.57 5.57
EBIT 19.5 18.5 19.8 21.7 -2.9 15.7 15.8 16.0 16.1 16.3
EBIT, % 31.9 30.63 32.21 32.6 -4.66 24.54 24.54 24.54 24.54 24.54
Total Cash 197.2 375.6 380.3 234.0 37.5 58.7 59.3 59.8 60.4 61.0
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 5.2 8.4 8.0 9.5 11.0
Account Receivables, % 8.56 13.9 13.11 14.26 17.44
Inventories -53.9 -221.8 -271.9 -49.8 .0 -46.4 -46.8 -47.3 -47.7 -48.2
Inventories, % -87.95 -367.26 -443 -74.92 0 -72.57 -72.57 -72.57 -72.57 -72.57
Accounts Payable 1.7 1.1 .7 .6 3.8 1.6 1.6 1.6 1.7 1.7
Accounts Payable, % 2.73 1.84 1.06 0.90686 6.02 2.51 2.51 2.51 2.51 2.51
Capital Expenditure -2.7 -2.7 -1.1 -.4 -.8 -1.6 -1.6 -1.6 -1.6 -1.7
Capital Expenditure, % -4.42 -4.42 -1.85 -0.56698 -1.27 -2.51 -2.51 -2.51 -2.51 -2.51
Tax Rate, % 18.28 18.28 18.28 18.28 18.28 18.28 18.28 18.28 18.28 18.28
EBITAT 16.3 15.0 16.0 17.5 -2.4 12.8 12.9 13.0 13.2 13.3
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 67.3 180.1 68.9 -203.0 -48.4 61.4 15.3 15.4 15.6 15.7
WACC, % 7.3 7.18 7.15 7.14 7.2 7.19 7.19 7.19 7.19 7.19
PV UFCF
SUM PV UFCF 106.0
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 16
Terminal Value 308
Present Terminal Value 218
Enterprise Value 324
Net Debt 360
Equity Value -36
Diluted Shares Outstanding, MM 7
Equity Value Per Share -5.08

What You Will Get

  • Real PWOD Financial Data: Pre-filled with Penns Woods Bancorp’s historical and projected data for precise analysis.
  • Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
  • Automatic Calculations: See Penns Woods Bancorp’s intrinsic value update instantly based on your changes.
  • Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
  • User-Friendly Design: Simple structure and clear instructions for all experience levels.

Key Features

  • Comprehensive PWOD Data: Pre-filled with Penns Woods Bancorp's historical financials and future projections.
  • Customizable Input Options: Modify revenue growth rates, profit margins, cost of capital, tax rates, and capital expenditures.
  • Dynamic Valuation Framework: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on your specified inputs.
  • Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation results.
  • Intuitive User Interface: Easy to navigate, structured for both seasoned professionals and newcomers.

How It Works

  1. Download the Template: Gain immediate access to the Excel-based PWOD DCF Calculator.
  2. Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
  3. Instant Calculations: The model automatically recalculates Penns Woods Bancorp’s intrinsic value.
  4. Test Scenarios: Experiment with different assumptions to assess potential valuation changes.
  5. Analyze and Decide: Utilize the results to inform your investment or financial analysis.

Why Choose This Calculator for Penns Woods Bancorp, Inc. (PWOD)?

  • User-Friendly Interface: Tailored for both novice users and seasoned professionals.
  • Customizable Assumptions: Adjust inputs effortlessly to suit your financial analysis.
  • Real-Time Updates: Monitor immediate changes to Penns Woods Bancorp's valuation as you tweak the inputs.
  • Pre-Configured: Comes with Penns Woods Bancorp’s actual financial metrics for swift evaluations.
  • Relied Upon by Experts: A go-to tool for investors and analysts to make well-informed choices.

Who Should Use Penns Woods Bancorp, Inc. (PWOD)?

  • Investors: Make informed investment choices with comprehensive insights into PWOD's performance.
  • Financial Analysts: Streamline your analysis with detailed financial reports and metrics specific to PWOD.
  • Consultants: Tailor your presentations and reports using PWOD's data for client engagements.
  • Finance Enthusiasts: Expand your knowledge of banking operations and financial strategies through PWOD's case studies.
  • Educators and Students: Utilize PWOD as a real-world example in finance and investment courses.

What the Template Contains

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

No products were found matching.