Parke Bancorp, Inc. (PKBK) 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
Parke Bancorp, Inc. (PKBK) Bundle
Designed for accuracy, our (PKBK) DCF Calculator allows you to evaluate Parke Bancorp, Inc. valuation using real-world financial data and offers complete flexibility to modify all essential parameters for improved 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 | 60.7 | 66.8 | 77.9 | 81.7 | 73.0 | 76.8 | 80.7 | 84.9 | 89.4 | 94.0 |
Revenue Growth, % | 0 | 10.05 | 16.59 | 4.87 | -10.71 | 5.2 | 5.2 | 5.2 | 5.2 | 5.2 |
EBITDA | 40.5 | 39.4 | 55.4 | 56.7 | .0 | 40.9 | 43.0 | 45.2 | 47.6 | 50.0 |
EBITDA, % | 66.7 | 58.93 | 71.11 | 69.42 | 0 | 53.23 | 53.23 | 53.23 | 53.23 | 53.23 |
Depreciation | .4 | .5 | .5 | .5 | .5 | .5 | .5 | .6 | .6 | .6 |
Depreciation, % | 0.70977 | 0.7452 | 0.63659 | 0.5593 | 0.63599 | 0.65737 | 0.65737 | 0.65737 | 0.65737 | 0.65737 |
EBIT | 40.1 | 38.9 | 54.9 | 56.3 | -.5 | 40.4 | 42.5 | 44.7 | 47.0 | 49.4 |
EBIT, % | 65.99 | 58.19 | 70.48 | 68.86 | -0.63599 | 52.58 | 52.58 | 52.58 | 52.58 | 52.58 |
Total Cash | 218.2 | 478.5 | 609.9 | 191.5 | 180.4 | 76.8 | 80.7 | 84.9 | 89.4 | 94.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 6.1 | 8.8 | 7.7 | 8.8 | 8.6 | 8.5 | 9.0 | 9.4 | 9.9 | 10.4 |
Account Receivables, % | 9.99 | 13.13 | 9.86 | 10.73 | 11.73 | 11.09 | 11.09 | 11.09 | 11.09 | 11.09 |
Inventories | -202.4 | -467.5 | -605.9 | -192.5 | .0 | -61.4 | -64.6 | -68.0 | -71.5 | -75.2 |
Inventories, % | -333.32 | -699.58 | -777.63 | -235.55 | 0 | -80 | -80 | -80 | -80 | -80 |
Accounts Payable | 2.3 | 2.3 | 1.6 | 2.7 | 4.1 | 2.8 | 2.9 | 3.1 | 3.3 | 3.4 |
Accounts Payable, % | 3.72 | 3.5 | 2.06 | 3.26 | 5.68 | 3.64 | 3.64 | 3.64 | 3.64 | 3.64 |
Capital Expenditure | -.6 | -.3 | -.1 | -.2 | .0 | -.2 | -.3 | -.3 | -.3 | -.3 |
Capital Expenditure, % | -0.9782 | -0.37559 | -0.08214079 | -0.18358 | 0 | -0.3239 | -0.3239 | -0.3239 | -0.3239 | -0.3239 |
Tax Rate, % | 24.48 | 24.48 | 24.48 | 24.48 | 24.48 | 24.48 | 24.48 | 24.48 | 24.48 | 24.48 |
EBITAT | 29.8 | 28.4 | 40.8 | 42.0 | -.4 | 30.0 | 31.6 | 33.2 | 34.9 | 36.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 228.3 | 291.2 | 179.9 | -371.2 | -190.7 | 90.4 | 34.7 | 36.5 | 38.4 | 40.4 |
WACC, % | 13.25 | 13.09 | 13.22 | 13.26 | 13.37 | 13.24 | 13.24 | 13.24 | 13.24 | 13.24 |
PV UFCF | ||||||||||
SUM PV UFCF | 177.2 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 41 | |||||||||
Terminal Value | 367 | |||||||||
Present Terminal Value | 197 | |||||||||
Enterprise Value | 374 | |||||||||
Net Debt | -12 | |||||||||
Equity Value | 387 | |||||||||
Diluted Shares Outstanding, MM | 12 | |||||||||
Equity Value Per Share | 31.85 |
What You Will Get
- Editable Forecast Inputs: Easily modify key assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Parke Bancorp’s financial data pre-loaded to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model tailored to meet your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, verifying strategies, and enhancing efficiency.
Key Features
- Comprehensive Financial Data: Parke Bancorp's historical financial statements and pre-filled forecasts.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Valuation: Observe Parke Bancorp's intrinsic value recalculating instantly.
- Intuitive Visual Outputs: Dashboard charts present valuation results and essential metrics clearly.
- Designed for Precision: A reliable tool for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Parke Bancorp data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Parke Bancorp’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Parke Bancorp, Inc. (PKBK)?
- Accurate Data: Access to real Parke Bancorp financials ensures trustworthy valuation outcomes.
- Customizable: Tailor key inputs such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Built-in calculations save you from having to start from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and financial consultants.
- User-Friendly: Easy-to-navigate design and clear instructions make it accessible for all users.
Who Should Use This Product?
- Investors: Accurately assess Parke Bancorp, Inc.’s (PKBK) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis.
- Consultants: Effortlessly customize the template for client valuation reports.
- Entrepreneurs: Acquire insights into the financial modeling practices of leading banks.
- Educators: Employ it as a teaching resource to illustrate valuation techniques.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for Parke Bancorp, Inc. (PKBK).
- Real-World Data: Parke Bancorp’s historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to Parke Bancorp, Inc. (PKBK).
- Dashboard with Visual Outputs: Charts and tables designed for clear and actionable results.