Pioneer Bancorp, Inc. (PBFS) DCF Valuation

Pioneer Bancorp, Inc. (PBFS) 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

Pioneer Bancorp, Inc. (PBFS) 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:

Explore the financial future of Pioneer Bancorp, Inc. (PBFS) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of Pioneer Bancorp, Inc. (PBFS) and enhance your investment strategy.


Discounted Cash Flow (DCF) - (USD MM)

Year AY1
2020		 AY2
2021		 AY3
2022		 AY4
2023		 AY5
2024		 FY1
2025		 FY2
2026		 FY3
2027		 FY4
2028		 FY5
2029
Revenue 64.5 57.6 56.5 79.7 74.2 78.2 82.4 86.9 91.6 96.5
Revenue Growth, % 0 -10.71 -1.94 41.16 -6.9 5.41 5.41 5.41 5.41 5.41
EBITDA .0 .0 16.1 30.6 .0 10.5 11.0 11.6 12.2 12.9
EBITDA, % 0 0 28.49 38.34 0 13.37 13.37 13.37 13.37 13.37
Depreciation 2.9 2.9 2.8 2.7 .0 2.8 2.9 3.1 3.2 3.4
Depreciation, % 4.51 4.96 4.88 3.39 0 3.55 3.55 3.55 3.55 3.55
EBIT -2.9 -2.9 13.3 27.9 .0 7.7 8.1 8.5 9.0 9.5
EBIT, % -4.51 -4.96 23.6 34.95 0 9.82 9.82 9.82 9.82 9.82
Total Cash 231.3 589.4 854.4 465.3 294.3 78.2 82.4 86.9 91.6 96.5
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 3.5 4.0 4.6 1,151.4 1,351.6
Account Receivables, % 5.38 7.03 8.19 1444.82 1821.77
Inventories -160.6 -329.4 .0 986.5 .0 -15.6 -16.5 -17.4 -18.3 -19.3
Inventories, % -249.15 -572.16 0 1237.93 0 -20 -20 -20 -20 -20
Accounts Payable 7.8 .0 .0 .0 .0 1.9 2.0 2.1 2.2 2.3
Accounts Payable, % 12.03 0 0 0 0 2.41 2.41 2.41 2.41 2.41
Capital Expenditure -1.7 -.6 -.8 -.5 -.8 -1.1 -1.1 -1.2 -1.2 -1.3
Capital Expenditure, % -2.64 -1.04 -1.38 -0.56595 -1.13 -1.35 -1.35 -1.35 -1.35 -1.35
Tax Rate, % 21.38 21.38 21.38 21.38 21.38 21.38 21.38 21.38 21.38 21.38
EBITAT -1.9 -1.2 10.3 21.9 .0 5.2 5.5 5.8 6.1 6.5
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 164.2 161.5 -317.7 -2,109.0 785.4 1,341.6 6.4 6.8 7.1 7.5
WACC, % 11.78 9.83 12.59 12.72 12.71 11.93 11.93 11.93 11.93 11.93
PV UFCF
SUM PV UFCF 1,217.4
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 8
Terminal Value 77
Present Terminal Value 44
Enterprise Value 1,261
Net Debt -151
Equity Value 1,412
Diluted Shares Outstanding, MM 25
Equity Value Per Share 55.99

What You Will Get

  • Real Pioneer Bancorp Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Pioneer Bancorp, Inc. (PBFS).
  • Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit Pioneer Bancorp's specific needs.
  • Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Pioneer Bancorp's fair value.
  • Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections relevant to Pioneer Bancorp, Inc. (PBFS).
  • Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Pioneer Bancorp, Inc. (PBFS).

Key Features

  • Comprehensive Financial Data: Gain access to precise historical performance and future forecasts for Pioneer Bancorp, Inc. (PBFS).
  • Tailored Forecast Inputs: Modify highlighted fields such as WACC, growth rates, and profit margins to fit your analysis.
  • Real-Time Calculations: Enjoy automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
  • User-Friendly Dashboard: Intuitive charts and summaries to clearly present your valuation outcomes.
  • Designed for All Skill Levels: A straightforward and accessible layout suitable for investors, CFOs, and consultants alike.

How It Works

  • Download: Get the pre-prepared Excel file containing Pioneer Bancorp, Inc.'s (PBFS) financial data.
  • Customize: Modify forecasts such as revenue growth, EBITDA %, and WACC according to your needs.
  • Update Automatically: The intrinsic value and NPV calculations refresh in real-time as you make changes.
  • Test Scenarios: Develop various projections and instantly compare the results.
  • Make Decisions: Leverage the valuation findings to inform your investment approach.

Why Choose This Calculator for Pioneer Bancorp, Inc. (PBFS)?

  • Accuracy: Leveraging real Pioneer Bancorp financials for precise data.
  • Flexibility: Tailored for users to easily experiment and adjust inputs.
  • Time-Saving: Eliminate the need to construct a DCF model from the ground up.
  • Professional-Grade: Crafted with the precision and usability expected by CFOs.
  • User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.

Who Should Use This Product?

  • Investors: Accurately assess Pioneer Bancorp, Inc.’s (PBFS) fair value prior to making investment choices.
  • CFOs: Utilize a high-quality DCF model for financial reporting and analysis specific to Pioneer Bancorp, Inc. (PBFS).
  • Consultants: Efficiently modify the template for valuation reports tailored to Pioneer Bancorp, Inc. (PBFS) clients.
  • Entrepreneurs: Acquire knowledge on financial modeling practices employed by leading banks like Pioneer Bancorp, Inc. (PBFS).
  • Educators: Implement it as a teaching resource to illustrate valuation techniques relevant to Pioneer Bancorp, Inc. (PBFS).

What the Template Contains

  • Pre-Filled Data: Contains Pioneer Bancorp, Inc.'s (PBFS) historical financials and projections.
  • Discounted Cash Flow Model: An editable DCF valuation model with automatic calculation features.
  • Weighted Average Cost of Capital (WACC): A specific sheet for calculating WACC based on user-defined inputs.
  • Key Financial Ratios: Evaluate Pioneer Bancorp, Inc.'s (PBFS) profitability, efficiency, and leverage metrics.
  • Customizable Inputs: Easily modify revenue growth, profit margins, and tax rates.
  • Clear Dashboard: Visual representations and tables summarizing essential valuation outcomes.

No products were found matching.